Sql database import export jobs
I need a Power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: - Retrieve Product ID, Quantity and Location. - Gather Specific Production Data including t...number. Ideal Skills: - Proficient in DAX query language - Comprehensive experience with Power BI - Excellent attention to detail - Previous experience in inventory data management will be a plus What to do: I need to get a query in DAX (Power BI) that gives me the same result as what I show in the excel file ( table (column in yellow)). The Excel file was obtained from the attached SQL query ( ) The two screenshots show the Power BI tables. I need to get a new column in Power BI that shows me the results like in the yellow column in Excel.
...for the Snipepay Payment Plugin: WooCommerce Integration: Develop a payment plugin to integrate Snipepay into WooCommerce, allowing users to choose Snipepay along with existing options like PayPal and GoUrl for payments. Deliverables: A fully functional WordPress plugin for hosting management. A Snipepay payment gateway plugin for WooCommerce. Skills Required: Proficient in PHP, JavaScript, and SQL. Experience with WordPress and WooCommerce plugin development. Strong understanding of RESTful API integration. Knowledge in payment gateway integration, specifically Snipepay, PayPal, and GoUrl. Excellent problem-solving skills and attention to detail. Project Timeline: Please provide an estimated timeline for completion with your bid. Budget: Your bid should include the total cos...
Hi Yasar W., I noticed you posted a following project ( https://www.freelancer.com/projects/sql/SQL-Expert-Needed-for-Data/details )
I need an expert to design a DICOM database specifically for storing and retrieving radiology images. Key requirements are: - Comprehensive understanding of DICOM Standards - Proficiency in database design and administration - Experience in handling medical images, particularly radiology The proposed database should support retrieval of images via Unique Identifier Codes (DICOM's UID). Being well-versed in medical systems integration will be considered a great advantage. This project will require strict adherence to privacy regulations and standards.
I need an expert to migrate my products from an Excel file to my WooCommerce store. Key Requirements: - Migrate products from an Excel file to WooCommerce - Use attributes to define variations within a single product - Update existing product descriptions during the migration Ideal Skill...file to WooCommerce - Use attributes to define variations within a single product - Update existing product descriptions during the migration Ideal Skills and Experience: - Strong experience with WooCommerce and product migration - Proficiency in handling product variations using attributes - Attention to detail for updating and modifying product descriptions - Excellent knowledge of data import/export and product management on WooCommerce. - Ability to ensure a smooth and error-free m...
...Proficiency in working with XML data and importing it into systems - Expertise in Prestashop and its search feature tables - Experience with real-time data updates in web applications - Strong problem-solving skills and attention to detail Import data from xml sheets into multiple prestashop faced search feature table. Here's an outline of the tasks Script to Parse XML for Nightly Update: This script will run once a night to parse a large XML file provided by the content provider. It will update, add, or remove relevant data in the PrestaShop facet search database tables. The script should be optimized to avoid system slowdowns and long processing times. Script to Parse Product XML Files: The second script. This script will run continuously and parse XML produc...
I need a proficient data specialist to compile a comprehensive database of Romanian companies. - Compatibility: The database must be compatible with Windows and Mac platforms. - Specific Details: Every company's record in the database must contain the company's name, phone number, and email address. - Extent of Database: Aim for a sizable database that contains information about 100,000 companies. Ideal candidates will have experience in data mining and database management, and an understanding of Romanian market dynamics. Strong accuracy and attention to high-quality data is a must.
I'm in need of an experienced telemarketer and lead generator to assist with my export business. Your primary focus will be on home textiles, so a flair for this industry and its nuances would be invaluable. Key Responsibilities: - Conducting cold calls to prospects in the home textiles industry - Generating leads and setting appointments for further negotiation - Managing data and documenting sales prospects Your Skills: - Proven experience in telemarketing and lead generation - Excellent communication and negotiation skills - Familiarity with the home textiles industry - Ability to maintain a positive attitude in a high-pressure environment. I'm looking for someone who is not only able to generate leads, but also has the ability to close deals. The ideal candidate wi...
import all the data from a json to custom compis all json data must be imported
...from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command to change the Admin name , Instance name -- now i do manually 7. env file need to be updated 50% mile stone will be created at the time of awarding the project, All payment will be released as soon as satisfied with your work and fit to my requirements. If you are interested, please send me a message so that we can discuss... Thanks...
...strong understanding of software architecture and design patterns. - CAD Software Development: Prior experience in developing CAD software, particularly with a focus on 3D modeling, will be highly beneficial. - Windows OS: A good understanding of Windows OS and its specific requirements for software development. - File Format Handling: Experience in handling DWG files and developing import/export functionalities for CAD software. If you have relevant experience and skills in C++ development, particularly in CAD software, and can commit to creating a high-quality, Windows-compatible CAD software, I'm keen to hear from you. Extra info: I am looking at a long term contract of 1 year, renewable each year. I will conduct a written test before making...
I'm looking for a developer who's proficient in C#, MS SQL Server, Dot Net, and XAMARIN to work on an already existing application. Need to improvise and add amend few things. Pls note we can pay maximum INR 4,000 for the work.
I am seeking an experienced Dynamics CRM 365 developer with Virtual Entity expirence. I have got few virtual entity tables link to Azure SQL database. One table has got 1:M relationship with another. In my form, I am trying to populate custom view in lookup field of this virtual entity lookup. I tried it in two different ways but it doesn't work. Method 1: I created fetchXML and link two tables, I get the result but issue is records don't filter in query. I tried this method with advance find as well, and again records don't filter according to criteria for virtual entity. in Advance find, if I try to select the columns from second table then I get error. Methos 2: I tried to create Fetch XML query and use addCustomView method. This method works if filter...
As the developer of an existing project written in Python, SQL Server, and MongoDB, I am currently facing a challenge. A logical error in the code is causing a bug, and I need an expert to fix it. High-level summary of the code- 1. Fetch records from SQL server ( total 680000 records) 2. Apply face recognition on each record 3. Insert the response from step 2 in MongoDB along with other data from the SQL server Issue- The existing code is currently doing steps 1 & 2 and performing step 3 at last when face recognition is applied on all records. Due to this it step 3 is waiting to complete the step 1 & 2. Expectation- After fetching each record from SQL server, the code should apply face recognition and then store the data in MongoDB immediately. I wil...
...from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command to change the Admin name , Instance name -- now i do manually 7. env file need to be updated 50% mile stone will be created at the time of awarding the project, All payment will be released as soon as satisfied with your work and fit to my requirements. If you are interested, please send me a message so that we can discuss... Thanks...
We need Oracle resource who are expert in below skills and having 8+ years of exp. Mandatory Skills: *• Need candidates with extensive experience in data migration across CRP, SIT, UAT, and GoLive phases in Oracle Fusion ERP implementation, utilizing ETL tools. * Experience in SQL Server, T-SQL, and SSIS Job Responsibilities: Data Extraction: * Extract data from various source systems, including flat files, spreadsheets, legacy databases, and external APIs. * Develop and optimize SQL queries and scripts for efficient data retrieval. Data Transformation: * Perform data cleansing, validation, and transformation to ensure data quality. * Convert data from source formats to Oracle-compatible formats. * Apply business rules and data mapping for aligning source data ...
...expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficie...
...expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficie...
...this program to be multi-faceted, with the capability to track referrals, assign rewards and incentives to referrers, and provide benefits to referred customers. The system should also be able to manage and monitor the referral process with ease. There are other smaller improvements required to the website and the database we use to run our suppliers prices. Our stock database was designed by me and built by our then developers. We also link into accounting to import customers orders and convert to invoices. We also link / interface to Ideal skills for this project would include: - Proficiency in Opencart system development - Strong UI/UX design capabilities, especially in mobile responsiveness - Experience in developing and implementing referral programs in...
I'm in need of a proficient database specialist to manually collect email addresses and phone numbers, and compile them into an efficient and reliable database system. The leads to be collected are specifically from the Social Media industry. Ideal Skills and Experience: - Proven experience in data collection and management. - Exceptional research abilities, particular in the social media landscape. - Ability to use manual collection methods efficiently and effectively. - Knowledge and understanding of database management and lead generation. - Accuracy and attention to detail in dealing with phone numbers and email addresses. Roles: - Locating and collecting required data from specific direct websites. - Organizing the data into a systematic database...
I'm seeking an expert in Entity-Relationship Modelling and Rational Database Design. Key Requirements: - I need an expert in this particular area. Please only apply if you have a proven track record in both Entity-Relationship Modelling and Rational Database Design. - I'm looking for a high-level overview of the Entity-Relationship Diagram. This means I don't need every minute detail, but rather a clear and concise depiction of the core entities and relationships. - Experience is key. Please share your past work in this field. Ideal Skills: - Proficient in Entity-Relationship Modelling - Experienced in Rational Database Design - Strong track record in this particular project type - Excellent communication and understanding of client needs. Pleas...
I'm looking to have a tool developed that can analyze biological microscopy images, specifically with features such as color segmentation, edge detection, and cell counting. The tool should also support universal data import and corrections of alignment and image rotation. Ideal candidates for this project should have: - Strong proficiency in Python and Java - Previous experience with image analysis and microscopy imaging - Fiji, Maven, Eclipse preferred - Bio-formats - Would be great if you have experience in setting up a Fiji plugin (post your work)
Need help with a simple task that involves writing simple SQL statements and completion of the relevant ER diagrams. This task is in the context of simple data analysis. To be completed within 2-3 days.
I have a running Python file, who parse data from xml and insert it into sql server. Currently it isnt working. need an expert in python, who can fix it and upgrade few things as well.
I'm in urgent need of skilled professionals with experience in MySQL and Digital Ocean recovery console. My MySQL server is locked and I require assistance in exporting a SQL file. The exact cause of the server lock is not currently known but it might be due to server resource overload or a potential security breach. Required Skills: - MySQL - Knowledge of Digital Ocean's recovery console - Server management The main objective of the task is: - Successfully export the locked SQL file for further analysis and resolution - Provide insights on the potential cause of the server lock for future prevention. Experience in server management, specifically in handling locked servers, will be a great plus. Thanks.
I need a WordPress expert to help me import posts from a JSON file to my website. I need to import posts from a JSON file to my WordPress site, without any media files, just the text content. This is a one-time job and I want the imported content to look exactly like the original. Key requirements: - Expertise in WordPress - Proficiency in handling JSON file imports - Attention to detail to ensure no data loss Please ensure that you have prior experience in handling similar projects.
I am seeking a skilled database developer to convert my .frm and .idb files into a SQL file. The original files are in MySQL format. Key tasks will include: - Conversion of .frm and .idb files to SQL format. - Exporting these converted files to mysql server. I did not specify any special properties or features of the .frm and .idb files that need to be preserved, but will appreciate a careful and diligent conversion to ensure no data loss. The ideal candidate for this job would have: - Extensive experience with MySQL 5.7. - Proficiency in SQL file conversion. - Strong knowledge of database export practices. - Keen attention to detail to ensure data integrity.
...calculate the hourly rate and the time needed to complete different task documents, on an agreed fixed price. The best offers with the right experience will have the opportunity to work with us on a long-term basis. Also, Good prospects for the right developers, based on the performances evaluated over a period of time, once you established your skills. Need to provide the changed code details and sql queries if any at the end of each sub-task, with the changed code line numbers. Unlimited Revisions are needed. Any bugs created due to your own developments are to be fixed on free of Charge. Recruitment is for a long-term big project as such, all the developers are subject to practical skill test for which not paid. Please send your details for the below-mentioned questions....
I'm in need of a tool that can convert PDF voter lists into Excel in a text format. Here's a breakdown of what I'm looking for: - Conversion Style: I'd like the tool to convert the PDF voter list by combining all columns into a single table. This will make it easier for me to wor...incorporating multi-language support. Ideal Skills and Experience: - Proficiency in PDF extraction and conversion tools - Strong knowledge of Excel and text formatting - Experience in developing error detection and correction features - Attention to detail for accurate text conversion - Fluent in the English language for error-free translation. Attached PDF file. Note: It’s NOT a one-time PDF to Excel export requirement. The project is to have a tool to locate PDF files & ...
...flight departure time, drop off location - Every day 3 buses are departing to airport. Say morning 8am, 1pm and 8pm. We need to get auto emails based on this bus timings of scheduled pax list and they take manually report with date/time filter. Ideal Skills: - Strong background in web application development - Experience in booking system or related is a huge plus - Fluency in database management, preferably SQL - Proficiency in PHP or a similar back-end programming language - Strategic problem-solving skills and attention to detail The success of this project requires not just technical expertise, but also a clear understanding of travel agency operations and the importance of efficient booking management. If you have relevant experience and the right skill set, I ...
I need a skilled professional to assist with a data entry task. The project involves the following: - The task is primarily image data entry. - The images will be provided in digital photo format. - The entered data should be compiled into a database. Ideal candidates should have experience with data entry, particularly with image data. Proficiency in database management is also essential. A keen eye for detail to ensure accurate data entry is a plus.
I currently have several completed projects ready for deployment, so I need to build websites for the products. I have prototype designs, and I just need to beautify them according to my prototype designs, and then export them to hand over to the frontend development team Requirements: - Preferably based in Bangkok, Thailand. - Proficiency in both Chinese is required
Company description Fulle Imports is a company specialized in the import of baby care products in Ecuador. Founded by two mothers with experience and knowledge of the needs of babies, our company is dedicated to providing safe and reliable products to Ecuadorian families. We make sure to only work with internationally recognized and certified suppliers to ensure the quality and safety of our products. We need colors that highlight values Values: Quality: We ensure that we import only the highest quality products that meet international safety and nutrition standards. Trust: We work with recognized and certified suppliers to guarantee trust in our products. Care: We care about the well-being of babies and their families, which is why we offer safe and nutritious products. Cu...
We are import export company from Pakistan. We need buyers worldwide for our export products. We are hiring freelancers to find buyers for us and research the market in their areas.
I'm currently in need of an experienced full stack developer who is proficient in both JavaScript and PHP. Key requirements: - Strong skills in front-end development, specifically using JavaScript. - Proven experience in handling backend development with PHP. - Knowledge of SQL is also important. - While not a strict requirement, familiarity with JavaScript frameworks such as React, Angular, or Vue and PHP frameworks like Laravel or CodeIgniter would be a big plus. - Experience with SSL implementation is a must, but there are no strict preferences as to the type of SSL to be used (Wildcard or EV SSL). Being able to pick the right SSL depending on the project’s needs will be part of your responsibility. If you're the kind of developer who is adept at managing the f...
I have a task that involves extracting business logos from websites and resizing each one individually. The logos need to be exported as PNG files. Key Requirements: - Extract 10 business logos from different websites - Resize each logo - Rename image - Export each logo as separate PNG I only need the exported logos, each renamed, resized, and exported individually. There is no need for a combined file. Detailed instructions: - Where possible, only use the logomark - Rename the image to match the name of the firm - Export the logo as a png to 240x240 px - Keep default background white, unless logo requires a different color background - Logos don't need additional space around them; they can fill the container edge to edge as there will be padding built into the area ...
Hey I’m looking for someone to tutor me on C4D. I have models which I’m able to texture and also have animations in fbx format. I’m looking for tutoring on how to apply animations to models and then export the final animated scene to mov with alpha channel so I can then import into my Prem Pro projects. I'm an intermediate user of Cinema 4D and looking to enhance my skills in the area of Animation and Dynamics. I'm seeking a tutor to help me dive deeper into these aspects of the tool in a method that's focused on troubleshooting and problem-solving. Key requirements: - Intermediate to advanced level understanding of Cinema 4D, with a strong emphasis on animation and dynamics. - Prior experience in tutoring or teaching, preferably in a tro...
...in creating similar systems or possessing a deep understanding of the workings of Windows OS will be preferred. Additional Details: Monitor Regedit for the changes related to the policies applied through Service. Send notification to server, send mail to a group, in case of change not applied through Service. 7. Logs needs to be updated to SQL via a API POST call (this endpoint is developed you need to call this Only) and keep a backup at local database. POST JSON - { "Username": "", "MachineName": "ABC", "Timestamp": "", "appliedPolicies": [ { "Policy1": "0", "Policy2": "2" } ], "removedPolicies": [ { "Policy3": "2" } ], "cha...
I'm seeking a software developer with expertise in HTML, AI, and email platform integration. The project involves creating an online software that includes: - Drag-and-drop HTML editor - User-friendly interface - Ability to export emails to any sending platform - Customizable templates, Pre-designed blocks, and image hosting capabilities Necessary Skills: - Advanced comprehension of HTML and AI - Experience with software development and UI design - Proficiency in various email platforms (Mailchimp, Constant Contact, gmail, hubspot, outlook) The final product should seamlessly integrate with the aforementioned email sending platforms. Moreover, the email builder should allow for logo integration, custom color schemes, and font customization. Your commitment to creating a pol...
...need an expert who can manage the export process, as it's a complex area I'm unfamiliar with. This project includes comprehending the nuances of international logistics, dealing with customs and regulations in both countries, and ensuring the right packaging and labeling requirements for export. Key requirements and tasks will include: - Understanding and managing international logistics. - Navigating through customs and trade regulations in the USA and France. - Finding the optimal courier company for shipping in different quantities. - Ensuring packaging and labelling fulfil FDA regulations. - Including necessary nutritional information on labels. - Creating a workflow process for our operations to follow on. Your expertise in the field of food export...
I need an experienced developer to handle a two-way synchronization between the Bling system and the ERP DeluxeUp. - You will need to import vendors from the Bling system and update their information on the ERP DeluxeUp. - Also, you'll update the Bling system with the latest information from the ERP DeluxeUp. - A GitHub connection is required for the DeluxeUp vendor registration. The synchronization process should be scheduled to run daily and should work efficiently. The ideal candidate for this project should have: - Proficiency in API integration, specifically with the Bling system and GitHub - Experience in two-way synchronization between systems - Strong understanding of the ERP systems Please note that access to the Bling system's source code is a requirement ...
...for jobs, and managing profiles and portfolios. - Build an admin portal with role-based access for monitoring user activity, managing complaints, and generating reports on job listings and user satisfaction. Preferred Tech Stack: - Front End: TypeScript framework with Server Side Rendering (React.js or Vue.js for web, React Native or Flutter for mobile) - Back End: Utilize GCP services (Cloud SQL, Cloud Functions, etc.) - Payment Gateway: Midtrans Indonesia. This work is going to be divided into 6 major stages, corresponding to 6 milestones: 1. Planning 2. Designing (Software design) 3. Developing 4. Testing 5. Implementation & Integration 6. Maintenance Details upon each stage will be discussed through online meeting If you're passionate about creating innovati...
We are seeking a team of Database Engineers who can combine multiple sources of data into an Azure MySQL database on an automated basis. The operation must comply with HIPAA regulations under an organizational development environment (VDE). All VM's and databases will be deployed through Azure.
I'm in need of an expert WordPress developer or programmer with a keen understanding of JSON API, URL redirection, and content importation. The specific project tasks are: - Import diverse news content types — including text, photos, and video articles — from JSON API into my WordPress site. - Perform a one-time importation of these news articles with the view of possibly updating this in the future. - Undertake a URL redirection process where old URLs are successfully redirected to new URLs, minimizing any potential disruption for site visitors. Ideal candidates should have proven success with similar projects involving JSON API and WordPress, as well as URL redirection. Proficiency in handling large batches of data and importation tasks is crucial, and meticul...
I am in need of an investment website that allows users to buy and sell stocks. Key Features: - Database Integration: This website should include a database to facilitate and record stock transactions. - Buying and Selling: The primary function of this site is to allow users to buy and sell stocks. - User-friendly Interface: The site should be intuitive and easy to navigate, ensuring a seamless user experience. Ideal Skills: - Web Development: Experience in developing dynamic websites with database functionality is crucial. - Financial Knowledge: A basic understanding of the stock market and investment is advantageous to ensure the site meets the required standards. - UI/UX Design: A good eye for design and user experience is important to create an engaging and...
I need to integrate Tableau with my SQL database, and I'm looking for a skilled freelancer to handle this. Key Responsibilities: - Setup Tableau integration with SQL database - Ensure seamless connection and data flow between the two - Deliver a functional, user-friendly interface for data visualization Ideal Skills: - Strong experience with Tableau and SQL - Excellent understanding of database management and integration - Ability to create interactive dashboards - Proficiency in optimizing data for Tableau visualization This project will require a keen eye for detail and a commitment to delivering a quality, tailored solution.
Looking for someone that can create a web-based 3D modelling tool (or use an existing one) which allows my customers to create 3D models of Veranda's based on input of width, height and...a web-based 3D modelling tool (or use an existing one) which allows my customers to create 3D models of Veranda's based on input of width, height and depth. Sample of a Veranda included in attachments. Requirements: - Webbased tool (might be PHP and Database for example) on my own hosting - Admin and User panel seperate - User should be able to define a Width, Height and Depth which will generate a 3D model of the veranda - Additional options like with/without glasses on the sides, color option (RGB), sample backgrounds to choose from. - Export 3D model as PNG or PDF option - Depl...
As the client, I'm seeking a professional with skills and experience in Microsoft's .NET framework who can include a CSV export feature in a software report. Ideally, the freelancer should understand how to structure data in a clear and organized manner. - Specifically, you will: - Add an option that allows the software report to be exported to CSV. - Ensure the data export is neatly structured and organized by entries. This role requires excellent knowledge of .NET, C#, and strong data organization skills. A background in creating business reports will also be beneficial. Enthusiasm for accuracy and attention to detail is a must-have.
Adjust code to export Supplier's name
