Using correct tables schema create query using either jobs
I'm running a MySQL database and looking for an expert to help me optimize the query performance. Key responsibilities: - Analyzing the current database structure and configurations to identify areas that need optimization. - Implementing efficient indexing strategies and query tuning to enhance the query performance. - Providing insights and recommendations on how to maintain and keep the optimized database running smoothly. Ideal skills and experience: - Proven experience in MySQL database management and optimization. - Strong understanding of database performance metrics and monitoring tools. - Familiarity with indexing strategies and query tuning techniques. - Excellent problem-solving and analytical thinking capabilities. This role requires a profe...
...Developer with 3-5 years of experience to join our team as a full-time freelancer. This role involves working closely with our technical lead to develop and refine an AI-powered tool that automates health economic modeling and analysis. Responsibilities: - Develop and maintain web applications using Django, Python, and other technologies - Collaborate with cross-functional teams to define, design, and ship new features - Ensure the performance, quality, and responsiveness of applications - Identify and correct bottlenecks and fix bugs Requirements: - Strong proficiency in Python, with solid knowledge of Django framework - Experience in developing scalable web applications - Excellent problem-solving skills and ability to work independently or as part of a team - Ability ...
I'm seeking a s...numeric data from PDF files. The extracted data will then need to be arranged in a specific format in an Excel sheet. Key Responsibilities: - Extract both text and numeric data from PDF files - Perform the data extraction on a weekly basis - Arrange the extracted data in specific columns and rows in Excel Ideal Candidate: - Proficient in using PowerAutomate for data extraction - Experience working with PDF files and Excel - Attention to detail for correct formatting of data - Ability to meet weekly deadlines - Strong communication skills to verify data accuracy Please find attached pdf (extract) example (there is 5 different templates to use) & excel (input). Looking forward to working with you! We have many more use cases like this, so looking...
DUE DATE: MAY 3,2024 Dynamic Trading Strategy Design: • will provide auxiliary materials ( 2 files ) and Jupyter Notebooks (“ Regression for Pair ” are related to this project. • Design an improved version of the pairs trading strategy (will share with freelancer chosen) by including more stocks in your strategy. • You can consider using the top 100 stocks () and their daily close price during the period of 2019 - 2020 [Note: you may not have access to all the stocks from Yahoo Finance during this period; please explain how you handle this issue]. • Explain whether dimension reduction techniques are needed. • Explain how you measure the performance. • Please show both the in-sample and out-of-sample performance. • Show evi...
I am seeking an experienced WordPress developer to adapt pages of my existing website using the Soledad theme and Elementor Pro. The pages to be updated are the home page, about page, services page, contact page, and news article. The new design needs to mirror pre-exisitng graphic models which will be provided to you. This project requires the following: - Extensive experience with WordPress, specifically the Soledad template and Elementor Pro. - Ability to implement plugins, including a slider for the home page and an agenda. - Familiarity with design adaptation to ensure a seamless transition between existing and updated designs. - Basic understanding and reading of french to work with provided documents (communication can be in english) The home page slider is intended to sh...
In need of a proficient Qt developer, with knowledge of Windows operating systems, to finalize a project. This application should grant access to multiple mouse and keyboard inputs all at once. Key Features: * Individual movement control * Simultaneous input execution * Control mapping customization As a versatile app, it must be functional with a range of mouse and keyboard brands. While there's no preference for specific brands or models, a thorough testing phase to ensure broad compatibility will be necessary. Successful project completion may lead to further work, including porting the app to different operating systems. Ideal Skills & Experience: * Qt development * Windows programming * Familiarity with input device controls * Experience in software testing for compatib...
I want a creative and innovative experienced graphic designer who has innovative ideas of creating designs of snacks and namkeen . His/Her role will be to make 12-16 creative...experienced graphic designer who has innovative ideas of creating designs of snacks and namkeen . His/Her role will be to make 12-16 creatives per month with a proper calendar and he has to post on a proper time with right captions and hashtags and has to put 3 stories a week to engage the audience. Along with that he has to change the page banner monthly . In which i planned, ● 8 creatives should be either reels or animated creatives [Attract & engage the audience] ● Rest will Static creative, Which covers; - Product Showcase (5 to 6 monthly) - Engagement Post (Rest posts in calendar) - Festival Creati...
...Goal: The primary objective of this project is to implement robust asset management practices via a comprehensive depreciation forecast. I'm seeking a professional with: Creating a excel spreadsheet that i can download my asset register into and then have the worksheet calculate future annual depreciation say to 10 years. But also allow the ability to have the individual assets to be revalued either an increase or decrease in the original asset cost. This would mean the excel sheet would need to be able to take into account prior accumulative depreciation and adjust in the year we are currently reporting in. The attached file is current assets as at 30th June 2023. No depreciation has ran for FY24 01/07/2023 to present date. I want to use the data attached and present a...
I am looking for an expert in deep learning and robot localization to help develop a mobile robot for indoor use. The primary function of this robot will be to localization using mcl. The ideal freelancer for this job should have: - Extensive experience in deep learning techniques for machine vision purposes - Specific skills in mobile robot localization - A successful track record of creating robots for indoor usage - Proven history of working on object detection, particularly relating to obstacles The objective of this project is not just to develop the robot, but also to ensure that it can operate effectively in an indoor environment. The robot should be able to detect and navigate around obstacles to perform its function. Your role will involve both code development and testi...
I am looking to design and build a basic data warehouse utilizing MS SQL Server's various services such as SSIS, SSAS, and SSRS. This includes analyzing and reporting on large sets of data while integrating and transforming data from different sources. Key specific requirements include: - Creating a basic data warehouse structure. This should involve a few tables and relationships. - Using SSIS (Integration Services) for transferring and integrating data. - Implementing SSAS (Analysis Services) for performing advanced analytics. - Utilizing SSRS (Reporting Services) for generating comprehensive reports. The ideal freelancer for this gig should have: - Proficiency in MS SQL Server, specifically in SSIS, SSAS, and SSRS. - Experience in designing and creating data wareho...
Hi, We are looking for a developer to do the following tasks: 1. Index resumes in pinecone using langchain 2. Convert query from user into structured response in langchain. 3. Get responses from langchain and pinecone 4. Tank the resumes based on score 5. Test postman APIs for each of the above tasks. There will be two queries - one to fetch the relevant CVs and the other to rank a group of CVs. Ideally the score will be to use both one after the other and get ranked and relevant CVs. This can be written in Nodejs or python; we are okay with either. I will provide sample datasets and test with you. We are on a low budget for this - max - 1500-5000 inr. we want to work with individuals who are keen to learn and do this for the learning and not much for commercial g...
I'm seeking an experienced WordPress developer with a specialty in MySQL databases to help me with optimizing query speeds. This personal project requires proficiency in both SQL database handling and WordPress development. Key responsibilities: - Analyzing my WordPress site's interaction with the MySQL database. - Tweaking and fine-tuning to enhance query speeds. - Testing and confirming the increase in performance. Skills and Experience: - Detailed knowledge of MySQL databases. - Extensive experience with WordPress development and optimization. - Proficiency in writing efficient SQL queries. - Ability to diagnose and optimize databases for better speed performance. This project offers the opportunity to showcase your skills in SQL optimization, while significan...
Create a Spark script to transfer metastore data from Hive to S3 - Create a connection to Hive metastore - Fetch definition for the database - Create a connection to S3 bucket - Create a new within S3 Hive metastore - Transfer data from Hive metastore to S3 - Configure multiple creation based on config variables - Create recursive data transfer based on difference in data Skills and Experience: - Proficiency in Spark and Hive - Extensive experience with S3 buckets - Understanding of data backup strategies Project Details: - The script needs to read the schema and perform metadata transfer for selected schema to s3 bucket. - Only bid if you have work experience with spark, hive, s3. - multiple schemas needs to be migrated. - I have loca...
...org/certified-entity/00522bad-28f0-51ce-a86a-86b27ffac5ca). ## Please provide your personal information for the interview. 1. Are you a team player or an individual worker? 2. Past projects involving React and TypeScript. 3. Link to your GitHub profile. 4. Have you used Figma before? # Project Overview ## Objective This job involves repairing the presentation of an existing website, the main job is to correct existing page errors and exceptions. ## Task ### Issue 1 : [UI Update] Improve UX for CRM User Directory Quick Navigation - Please check the attachment image --- ### Issue 2 : [UI Update] Change Ctrl+S / Cmd+S Behavior in Article and Bulletin Edit Pages to Call Patch API - Please check the attachment image ### Deadline - Within 16HR after accepting the job. - Late submis...
...that it's related to wordpress WPML plugin's SQL queries. To solve this issue, I'm specifically looking for a professional who can optimize our database. Familiarity and experience with the WPML plugin is a must. Additionally, we've made several modifications to our database structure and queries which include tables, SQL, and indexes modifications. Skills Required: - WordPress development - SQL database optimization - Experience with WPML plugin - Deep knowledge in modifying tables, SQL queries, and indexes. This job requires a thorough understanding and hands-on experience in these fields to ensure all issues are addressed correctly and efficiently. Your assistance will be invaluable in improving the operational ease of the website's post-up...
...org/certified-entity/00522bad-28f0-51ce-a86a-86b27ffac5ca). ## Please provide your personal information for the interview. 1. Are you a team player or an individual worker? 2. Past projects involving React and TypeScript. 3. Link to your GitHub profile. 4. Have you used Figma before? # Project Overview ## Objective This job involves repairing the presentation of an existing website, the main job is to correct existing page errors and exceptions. ## Task ### Issue 1 : [BUG] Implement Non-hyperlinked, Bold Breadcrumb for the Last Item - Please check the attachment image ### Issue 2 : [BUG] Incorrect filePathType value in payload for image uploads in Article comments - Please check the attachment image ### Issue 3 : [BUG] Fix Email Sending Bug and Remove Unnecessary API Call in ...
I need a document formatting specialist with proficient experience in Microsoft Word. Tasks include: - Adjusting margins and layout within the document, for a polished and professional appearance. - Inserting tables and graphics to enhance the presentation and display of information. - Applying styles and formatting text, utilizing Serif fonts (like Times New Roman) for consistency and readability. - Crafting a unique and eye-catching cover page design. - Document is 105 pages The ideal freelancer will have an eye for design and great attention to detail. Strong knowledge in Microsoft Word and experience in document styling are key for this job.
I'm currently seeking a highly skilled C# .NET programmer to develop a new feature for our system that will generate access tokens without requiring user login. Key Task: - You will conceptualize, design and implement a robust solution capable of granting programmatic access to API endpoints and providing a secure authentication mechanism. Essential Token Features: - The generated access tokens must have specific scope and permissions. - The process must successfully integrate with our existing authentication system. The ideal freelancer for this project is someone with a strong background in web application development, database management and integrating third-party APIs. Efficiency, precision and security-consciousness are expected in delivering this feature. Familiarity with a...
...horseshoe and cow in the middle. We would like that but with a horse in the middle and still look modern so put your own flair to it. Also, it would be interesting to see the name have the C in Copper be a horseshoe and the P in Penny have the top part of the letter be a horseshoe. Something creative like that. CHANGE: I spelled the name wrong. The correct spelling is Copper Penny Stables. I'm looking for a talented graphic designer to create a minimalist and modern logo for my horse farm, named "Cooper Penny Stables". The logo should exude modernity and affluence, reflecting the prestige of my company. Design Specifications: - The logo should feature horse head silhouettes, don't limit the number but keep it clean and modern. - The chos...
... or Basil plant. - Container needs a border/edges to set it apart from the background photo - Uses colors from the brand, off-white is probably fine, see for colors - Container edges have shadow effect so it looks like it's sitting above the background photo - Container is a display for 3 roll-on product images with the words "For Targeted Relief" in Raleway font either below it or above the product images. - This is the most important factor in determining the winning entry. - Deliverables: raw files with background photo, visual container, product photos, and tagline all on separate layers. The .png and .webp files at 72dpi, 1800 pixels wide, and height anywhere from 400-600 pixels, height is up to you based on space you need for your des...
I'm looking for an expert in GCP & Ai...expert in GCP & Airflow who understands the intricacies of creating an Airflow DAG in Project-A (cloud composer) and triggering it via Project-B's service account. Work encompasses: - Crafting an Airflow DAG implementing Python script to create BigQuery tables. - Making the DAG operative within the confines of Project-A. - Leverage the service account of Project-B to trigger the DAG. - The BigQuery tables need to be created within Project-C. Ideal skills and experience: - Proficient in Python Scripting. - Experience in creating and managing workflows using Airflow. - Extensive knowledge of Google Cloud Platform. - Familiarity with BigQuery is a must. - Proven ability to script and manage service acco...
...seeking a detail-oriented graphic designer to create a layered Photoshop file from an image intended for printing. The goal behind creating this file type is to allow for toggling and changing specific elements easily, especially text contents. This job requires: - Proficiency in Adobe Photoshop. - Expertise in graphic design for print. - Experience with creating layers for different image elements. - Good understanding of colour profiles for printing. Your main task will be to: - Design the file such that the text is on separate layers for straightforward editing. These text contents will primarily revolve around product descriptions and need regular updates. - Ensure the final file should be print-ready, with high resolution and correct colour profiles. - Preserve t...
I'm seeking an experienced Laravel and Flutter programmer to design and develop a basic e-commerce application. Key features to be included are: - A product catalogue - Shoppin...prior experience with this payment processor is highly valuable. The ideal freelancer profiles for this project should have previous experience in Laravel and Flutter coding and a strong portfolio of constructing and integrating shopping cart features, user authentication, and Stripe payments processing into an e-commerce setting. There are approximately 15 screens for the App, 25 data base tables and roughly the same number of micro services to connect the backend to app. No admin panel required in first phase. I can share the details of the front end and back end design to help with appr...
...also included examples in the appendix. ## Please note that the examples have nothing to do with the topic, I just wanted you to see what I like ##: ----- Logo name / company name: “MoneyHunter” We want to show people how they can earn/invest/save money. The offer is aimed at younger people. The design should therefore not be as boring as normal financial advisor pages. But not too cheesy either. ---- Offer consists of two tasks: # 1x logo for the website etc. - The logo should be vertical - It should be simple and modern - It should consist of a symbol/icon + text (MoneyHunter). - The symbol should be chosen appropriately... for example, I thought of a spearhead (but you can also make other suggestions), perhaps the Stone Age man's tool is somewher...
I'm looking for an experienced developer to create Escrow staking platform where people can continuously bet against each other for games . Someone can also open up a bet and call others to bet against them . I can open a bet and say a team will lose today or lose by 2 goals , and someone can bet against me . So the platform can hold their money in escrow and then release it to the winner and then the website owner can take percentage the amount deposited - Sports: Soccer, Basketball - Board Games The platform should be designed to allow users to: - Either open a bet or join an existing one - Stake on various outcomes such as team wins/loses, goal differences, etc. Key Features: - Escrow staking system - Multi-game support - User-created bets - Comprehensive user pro...
I need an experienced team to correct a couple of problematic issues on my WooCommerce/WordPress website and devise an online sales strategy. My website struggles with product addition to the cart and an efficiency concern with the coupon system. Key Tasks: 1. WooCommerce Bug Fixes: - Resolve the issue with adding products to cart - Improve the coupon system for better functionality 2. Create Sales Boost Strategy: - Develop a scheme to target specific demographics - Devise methods for improving site traffic and the conversion rate In addition, I'd like you to create content and a roadmap for an engaging social media strategy to enhance brand presence on Facebook, Instagram, and Twitter. Ideal Skills: - Proficient in WordPress and WooCommerce - ...
Currently working on a project where I need ABMP file Printed using a raspberry pie PicoW and a thermal printer HS-K33 using the UART on thr pico. I have attached the bmp file.
if you know the order grabbing script and can make something similar, I'm waiting for you
I need an experienced database developer to create a highly functional Access database. Required functionality: - Robust data entry and retrieval system - Capable of generating custom reports and analyses - Seamlessly integrated with other software The database will store: - Customer information - Product inventory - Sales transactions Expectations: - Development of significantly more than 10 tables - Efficient organizing and handling of these tables The ideal candidate should possess significant experience working on Access Database creation, be able to confidently handle extensive data and complex systems integration. Expertise in table management and data analysis would be an added benefit.
I need to convert an 2D .dwg file led linear lamp to a 3D .stp file with same and correct dimensions.
I am looking for someone who can help me correct some formulas and formatting errors in my Excel spreadsheet. - The spreadsheet contains Sum and Count formulas that need to be fixed. - There are also formatting errors that need to be addressed. Ideal skills: - Proficiency in Excel - Experience with formula correction - Attention to detail for formatting errors.
I am currently experiencing some issues with a Google Sheets array formula that is pulling the wrong data from columns G, H, I, and J. I need a skilled and experienc...currently experiencing some issues with a Google Sheets array formula that is pulling the wrong data from columns G, H, I, and J. I need a skilled and experienced freelancer who is adept at Google Sheets formula manipulation to help me rectify this. Here is what needs to be done: - Identify why the formula is pulling incorrect data and address the issue. - Correct the array formula such that it accurately matches and places data from the correct columns. Deep understanding of array formulas and error troubleshooting in Google Sheets is a prerequisite for this project. An ability to work quickly and accura...
I need an AI language generation model that can create a completely new language based on user prompts. - The language must be highly realistic and usable. - The prompts can range from textual descriptions to linguistic parameters and even cultural or historical contexts. - The AI should be able to deliver the generated language in both written and spoken forms. (For written, the language should be per the prompt. Either Latinbased or an entirely new script or derived from existing scripts) The ideal freelancer for this job should have advanced knowledge in AI, Natural Language Processing, linguistics, and machine learning. Experience in creating language models or AI generators is a huge plus. The ability to deliver a highly realistic and usable language with written an...
I need a proficient Apache Airflow and SQL consultant to provide expert-level support, specifically focused on complex query formation. - Specific Project Tasks - Implementing Apache Airflow - Creating complex SQL queries - Handling financial transaction data The ideal collaborator should have: - Proven experience working with Apache Airflow - Proficient in SQL, with an emphasis on generating complex queries - Prior experience managing financial transaction data is highly desirable. The objective is to streamline the handling, management, and processing of large volumes of financial transaction data, ensuring efficient and accurate results.
I'm seeking a video editor with expertise in Camtasia software to enhance and modify my recorded tutorial videos. These videos will be transformed into final pieces of no more than 3 hours playtime in total. Each videos are categorised into 10 chapters and 2 to 5 lecture videos inside each chapter. The total number of video clips are 35, each video shall have 5-15min approximately. The total time duration of the trimmed videos will be approximately 3 hours. Your tasks will encompass: - Trimming and cutting unnecessary sections - Adding appropriate texts and captions where required - Enhancing the audio quality to ensure clarity and easy understanding. - Add cursor smoothing effects. - Add fade in / out effects wherever transition is present. - Review the continuity...
I'm in need of a...guidelines which will set the tone for the brand's visual elements. - **Website Design**: I need assistance in creating a website that's not only visually engaging but also user-friendly. The ideal developer should have experience in Wordpress and Web UI/UX. The primary goal of the website is not specified, but I'm looking for someone who can create a site that effectively serves the needs of the business. The main target audience is not specified either, but experience in designing for various audiences is a big plus. To sum up, I'm looking for a developer who can provide expert insights on branding, and implement them through logo design, brand identity guidelines, and website design. Experience in Wordpress, AI, PSD, XD, and...
I need a meticulous and creative research & paraphrasing specialist who can also proofread my documents Your proficiency in both research and writing is crucial for this task. The right individual will also have a keen eye for detail, ensuring that the documents is correct in grammar, punctuation, and structure.
I want a software, written in php Laravel, VUE3, using Vuexy Dashboard Template that I will provide to freelancer. Tempalte version: I can provide hosting environment for development. We will create a MVP at first, to test and try the concept. Many thing will be configured directly in database through phpmyadmin. The short description of the project: A database management system with dynamic columns. Users will have access to advanced table plugin where they can see and edit values. details in attached document
I'm looking for a talented designer to create a logo and a modern business card for a company of private driver services. The business card will be printed The business card must include the elements below which are written in French: • Two pages • Logo: you can suggest one or take inspiration from the last picture « » (I don't want a sports car, only a sedan), otherwise another proposition that seems appropriate to you. No picture of a real car • Name: « My Private Driver in Paris ». • Phrase to add at the bottom of the company name: «Service de chauffeur privé haut de gamme » • The QR Code for Google reviews: • Add the expressions “Scannez-moi” and “Scan m...
- The content of the bucket should only be able to be consumed from a domain (or any subdomain associated to it) - The content of the bucket should be automatically deleted every 48 hours. - The AWS account ows the content. - Prevent objects from being overwritten. - This should be delivered today. There might be other configurations required as you create the bucket. I simply don't know what they mean as I go through them from my console. Once this has been done, please share the instructions with me so that I can replicate this in the future. To apply to this project, please start your response with "Bonjour". Also, only apply if you have done this before.
I need to create a class in KOTLIN for a project that allows deleting the application data and cache of the device's applications (for example YouTube, Netflix) without the need to be ROOT / Shizuku and without the need to confirm by the user. In short, I need to automate a process that factory resets these applications. It should work on android tv version 9/12.
Tengo trabajo constante relacionado con proyectos anteriores '3D Designer to Create Realistic a Sword and its from Photos'
...can help me integrate a new functionality into my existing PHP application. Key Requirements: - The task involves enhancing a synchronization system with an external API. Ideal Skills: - Proficient in PHP programming - Experience with API integration - Familiarity with data synchronization techniques We designed a custom WordPress plugin to integrate with our supplier API to automatically query products in our WooCommerce database and update pricing for those items (as well as some other tasks). We need the following changes/enhancements made to the program: 1. The program was originally set to use the test API. We need to switch this to use the production API instead 2. Currently, the program iterates through all products and updates them. We would like to option to ente...
I have a small number of photos where I'd like to have a face swap done. The purpose of this is for personal use, so I'm not looking for perfect professional editing, but rather a fun...of this is for personal use, so I'm not looking for perfect professional editing, but rather a fun and entertaining twist for my personal pictures. Key Requirements: - Applying face swap to 1 photos - The face swap can be done manually or through an AI algorithm, whichever method you find most suitable Ideal Skills: - Experience in photo editing, specifically in face swapping - Proficiency in either manual or AI-based face swapping techniques - Understanding of the importance of privacy and discretion for personal photos Looking forward to seeing your bids and examples of face swaps...
I'm looking for a Java springboot expert who can seamlessly add additional fields to an existing API. The exact fields to be added are not defined at this stage, giving the successful freelancer the opportunity to demonstrate innovation and flexibility. The API interface is built using elasticsearch. Ideal Skills and Experience: • Proven experience in Java Springboot, preferably with elasticsearch. • Excellent problem-solving abilities. • Strong understanding of API structure and functionality. Application Instructions: While exact past experience and detailed project proposals are not necessary for this job, any relevant work or skills showcasing your proficiency in Java Springboot and APIs would be beneficial in your application. Java Springboot Version: T...
I'm in need of a Java and JavaFX developer to create a comprehensive system for a local restaurant. The system should have the following features: - Online Ordering: The system should allow customers to place their orders online. - Table Reservation: Implement a feature that enables customers to reserve tables in advance. - Menu Management: The system should facilitate the management of the restaurant's menu. - Events Management: Implement functionality for managing restaurant events. - Reports Generation: Develop a reporting system for the management to analyze various aspects of the restaurant operations. - Customers Management: The system should allow for easy management and tracking of customer data. - Staff Management: Implement features for managing various s...
I'm in need of a skilled 3D artist or architectural modeller who can quickly create two or three reasonably scale-accurate visualizations of a proposed housing development, as it will be seen from specific viewpoints. You'll be tasked with crafting "artists impression" visuals that accurately depict the scale and appearance of a block of flats. The developer has produced visuals which we do not believe are even close to scale-accurate - and which deliberately downplay the dominance of the 3 storey apartments. The objectors wish to produce their own version. I can provide: Site layout plan; apartment and house elevations; photographs of site from existing viewpoints; developers impression; various other visual references and photographs; estimated dimensions....
I need a professional who can effectively convert my PDF files to Word so I can easily edit the content. The PDF documents contain both images and tables that I need to be accurately transferred into the Word document. Key Requirements: - Proficient in PDF to Word conversion - Capable of accurately reproducing images and tables - Ability to maintain the original document formatting This project is critical for me, so I need a freelancer with extensive experience in this area. Please provide samples of previous similar work in your proposal.
I'm looking for an expert who can help us create an address validation API. Key Requirements: - Use our Street and Zipcode Database: We have a comprehensive database that should serve as the master template for the address checks. You'll need to integrate this into the API for accurate validation. - Handle incorrect addresses: It's crucial that the API is programmed to suggest corrections automatically when an incorrect address is identified. - Accept Excel and CSV files: The API should have the capacity to check addresses from both Excel and CSV files. We need an html frontend, to Upload files. The result shoud be added in the file The api should also react on soap requests and deliver the correct address back The request should be locked by costumer key...
