Database query csv file jobs
I'm in need of a seasoned PHP Laravel developer for a project focused on database integration, specifically with MySQL. The core task for this engagement is query optimization. Skills and Experience required: - Profound expertise in PHP development - Familiarity and proficiency in MySQL - Proven track record of successful query optimization I'm looking forward to engaging with highly qualified and responsible individuals for swift, efficient implementation of this particular task.
My project revolves around a MySQL select query that is showing slower-than-desired execution times. I cannot provide the data as it has PII and is very large. Main issue is that for pulling 1 month of data it takes about 3 hours, regardless if it returns 500 rows or 500,000 rows. There is likely a required index that I cannot see. I will be providing 1) The query 2) The Explain Tree 3) The table definition from which it is pulling data.
More details: I need a Logo for a new website. simplesax.com. The logo should just be simplesax. Its a site for learning how to play the saxophone. Please also provide the font name used, layered file (psd) and png file.
I'm in need of an adept website developer to create a simple, straightforward website for my personal database management. The primary function of this website is to securely store personal information. Key Features Required: - User registration and management functionality: Users should be able to register, manage their own profiles and access their data at any time. - Comment Capabilities: Necessary infrastructure for users to generate discussions and comments should be included. Skills & Experience: - Proficiency in various web development languages such as HTML, CSS, JavaScript and server languages. - Extensive experience with user management systems and development of secure database management solutions. - Familiarity with comment system integration. Your f...
I'm in urgent need of an AWS professional with a strong background in data recovery. I have a terminated EC2 instance that housed crucial database files in its root volume. While I've reached out to AWS Support, they were unable to help with my data recovery issue. This is a complex problem without any available snapshots or AMIs for data recovery. If you've dealt with similar issues in the past or have a potential solution, I would be very interested in your services. Required skills and experience: - Expert knowledge of AWS, particularly EC2 - Proven experience in data recovery tasks, ideally with AWS - Familiarity with database files and how to recover them - Problem-solving abilities and persistence, due to the lack of snapshots and AMIs - Good communi...
As the project initiator, I require someone skilled in data entry to transfer numeric data from the online databases I specify, into Google sheets. Previous experience with online databases is preferred, along with accuracy and attention to detail. Basic understanding of managing Google Sheets is a must. You will also need to practice integrity when handling potentially sensitive data. Skills & experience: - Prior data entry experience - Familiarity with online databases - Proficient in Google Sheets - Attention to detail - Discretion with sensitive data
I'm seeking a skilled Python developer to integrate my local project with a WordPress database. The immediate task involves retrieving and showcasing user account information from the WordPress database in my local project. Key responsibilities: - Create a secure, reliable connection between my local project and a WordPress database using Python - Design and implement an efficient method for retrieving user account information - Ensure the retrieved data is displayed correctly within the local project Ideal skills: - Strong Python development skills - Experience with SQL and WordPress databases - Proven track record of creating database connections and retrieving data - Attention to detail in presenting the retrieved data in a user-friendly format Ple...
I need a comprehensive list of all moving companies operating in Germany Spain Italy France Poland Austria Sweden Denmark Ireland Belgium Netherlands Croatia Finland Norway Portugal Switzerland Luxembourg Key Scope Details: * The database should primarily focus on these countries. * The data collection should be accurate and verifiable and should contain (google maps link, google maps rating, name, address, phone number, URL, email (probably to be retrieved from website is best) * Any additional relevant information about the companies is welcomed. Applicant Requirements: * Freelancers are required to demonstrate past work involving similar data collection and research projects. * Accuracy in data collection is crucial in this task. * A methodical approach to research would b...
*** This is a VERY SIMPLE minimum work request. Only cosmetic changes/ NO MAJOR or functional design changes. *** I am seeking to modify existing open source STEP file. The central task of the project is to remove logo from design and replace with a simple textured design on both the face that hosted the logo and to opposite face of the part. The potential freelancer should have: • Excellent skills in dealing with CAD / 3D modeling software to efficiently execute required cosmetic design changes. • A good understanding of how to create a functional and tactile texture on an existing design. The task is to: • Remove/Replace the logo from the specified part location • Replacement of logo with tactile texture on both the face that previously hosted the log...
I'm searching for an experienced programming freelancer who can efficiently create a simple script to organize my files. Primarily, this task includes: - Designing a script to specifically move files with the extension ".VAR". ...output an easily readable log of what was done, e.g., "Moved XYZ.abc.1 to XYZ folder" or "Created XYZ folder", as in the case where the folder didn't exist previously. - No undo functionality needed. - Should run as a standalone without an install package. The ideal candidate for this job would have a strong background in building file management scripts and savvy knowledge of programming languages. A keen attention to detail is crucial to ensure the accuracy of file organization. The quicker you can complete...
I'm seeking a python backend developer with proficiency in API integration and database management. The developer will be primarily responsible for: - Managing an SQL database, ensuring it runs optimally. - Seamlessly integrating APIs, and troubleshooting any issues that emerge. Ideal candidates should: - Possess a strong understanding of Python. - Have prior experience in database management using SQL. - Possess experience in API integration. Familiarity with server maintenance is a bonus, but not mandatory. Success in this project requires excellent problem-solving skills and meticulous attention to the fine details of backend coding.
...looking to create a robust database from around 780 warranty pages. info is this format. install date customer name address Model1 serial 1 Model2 serial 2 Model 3 serial 3 warranty term These pages are of varied formats, but predominantly image-based (JPEG, PNG, etc.). The core goal is an efficient setting for editing and updating these pages. In addition to this, it's paramount that this database allows for a search functionality based on warranty details. The project involves: - Digitizing and formatting all the pages effectively for database entry. - Setting up a user-friendly database that facilitates easy edits and updates. - Incorporating a search function by warranty details. Ideal candidate should: - Have strong experience in data digiti...
...text in the 3 boxes will be saved to the 3 tables in SQLite. The page will also have a ‘view’ button that print all records of all 3 tables. There will also be 3 buttons: ‘partial’, ‘full’, and ‘export’. If click on ‘partial’ then it will save a copy of the SQLite database to the user’s iCloud but will only save table 1 and 2. If click ‘full’, it will save a copy of the SQLite database to the user’s iCloud and will include all 3 tables. If click ‘export’, then it will save a full copy of the SQLite database to the user’s device file manager. There will also be a section that lists all the versions saved to iCloud. There will be a ‘restore’ butt...
I'm on the lookout for a freelancer who can help me gather data. Specifically, I need information on companies offering Notary & Apostille services, totaling 2500 companies with any available email addresses, based in the USA. While I prioritize those in Washington DC, feel free to include companies from other cities too. Keep a sample of 10 leads ready, before you send a proposal (write, "Berry" in the proposal if you have the sample ready)
...in the 3 boxes will be saved to the 3 tables in SQLite. The page will also have a ‘view’ button that print all records of all 3 tables. There will also be 3 buttons: ‘partial’, ‘full’, and ‘export’. If click on ‘partial’ then it will save a copy of the SQLite database to the user’s iCloud but will only save table 1 and 2. If click ‘full’, it will save a copy of the SQLite database to the user’s iCloud and will include all 3 tables. If click ‘export’, then it will save a full copy of the SQLite database to the user’s device file manager. There will also be a section that lists all the versions saved to iCloud. There will be a ‘restore’ button f...
...extraction, as well as data entry into CSV files is a requirement. KEY RESPONSIBILITIES: - Scrape Website 1 to extract names and quantities. - Data required is located on the same page. - Organise the scraped data into a CSV file in a neat format. IDEAL SKILLS: - Proven experience with web scraping. - Strong data organization skills. - Experience with CSV file formats. - Attention to detail is important for accurate data extraction. once the .csv is ready i want to be able to run the routine again so i can keep my database up to date. And this can also be done manually. Python is ok, but some web solution would be also nice. The card names must match exactly the name on the web site, and each card name has a link to scryfall that i...
As a highly skilled and experienced GIS professional, my expertise aligns perfectly with the requirements of this project. With a Master's degree in Geo-informatics and a Bachelor's degree in Agricultural Technology and Management, I have the academic knowledge and hands-on experience you need to convert your CADGIS Your project not only requires the conversion of CADGIS maps but also rigorous testing to guarantee compatibility with QField for field use. From my attention to detail to my commitment to producing deliverables of the highest quality - and my successful track record in doing so - you can trust me to get the job done right. I believe that my comprehensive proposal will demonstrate my suitability for this project. Thank you for considering me. Best Regards, Sujeewa ...
I'm currently experiencing a specific issue with converting ONIX Cloud XML to CSV. The problem involves a data formatting error, specifically an incorrect string format. In detail, it's the special character-related issues that are causing the problem. For this job, the appropriate freelancer would need: - Deep understanding of the ONIX Cloud XML and CSV format - Knowledge of data formatting, with a focus on string formatting - Expertise in resolving special character-related issues The task would be to help identify and correct the special character issues in my data input and ensure the CSV output is of correct format.
I'm looking to create a website that allows users to efficiently search for specific data. Given that the nature of the data to be stored has not been specified, the successful freelance developer should have the flexibility to wor... Key responsibilities include: - Designing and building a user-friendly website - Incorporating a robust and accurate search function - Ensuring the integrity and security of the data Since it wasn't specified, freelancers are encouraged to include details about their past work, experience and a detailed project proposal in their application. Developers with experience in creating similar database-driven, information-seeking websites will be given priority. Reliability, communication, and thoroughness are essential characteristics for thi...
I'm looking for a meticulous professional who can carry out data verification tasks for online databases. Your role will demand high standards of accuracy, as it is critically important to ensure all data examined is entirely correct. Key Responsibilities: • Extracting and verifying data from online databases • Delivering the verified data in an Excel spreadsheet format Ideal Skills: • Proven experience in data verification • Excellent attention to detail • Proficient in Excel • Prior experience with online databases If you possess the above skills and are eager, attentive, and meticulous, I will be glad to discuss this project further with you.
I need an experienced AWS specialist to set up, configure and secure a database on an AWS server. This job will involve hosting a relational database i.e., (MySQL, PostgreSQL), and therefore requires someone with strong experience in this area. Key Tasks: - Set up and configuration of the database on AWS - Implementing data encryption for enhanced security Ideal Skills: - Proven expertise in AWS - Strong experience with MySQL or PostgreSQL - Familiarity with data encryption methods Please, highlight your previous experiences with similar projects when placing your bid.
I am in need of a specialist who can successfully save values from forms into a database. Preliminary specifications of the form source, type of data to be saved and the type of database have not been provided, thus, I need a professional who is versatile with different forms and databases. Here’s what I expect: • Proficiency with different types of forms, such as HTML, Google forms and WordPress forms. • Ability to work well with various databases, including MySQL, PostgreSQL and MongoDB. • A proactive approach in your actions. For example, suggesting the best form and database for this task if required. • Strong communication skills, providing regular updates about the progress. While bidding, please include: • Your past work related...
I am looking for an administrative assistant with experience in managing ...update existing contact details including job title, country, contact details and skills • Identify and merge duplicate contacts. Duplicates in our database are defined as contacts with the same name or same email address • In case of duplicates, merge information from both records to preserve all relevant information Skills and Ideal Experience: • Expertise in using Bullhorn CRM • Strong data management skills • Excellent attention to detail and high level of accuracy • Experience in managing contact databases and merging duplicates Accuracy is paramount in this role. I am looking for a reliable person who can ensure that our Bullhorn CRM database is correct, up-to-dat...
I have a mysql query which loads customers email addresses thru a php script. inside the php script it loads all customer email and usually only takes about 5 seconds then also in the script it loads any emails which have been BLOCKED or BLACKLISTED these come from another table then it allows me to filter the emails and remove the blocked emails from the mailing list before sending emails. BUT HERES THE MAJOR PROBLEM as my blacklist or blocked list grows the query time seems to GROW EXPONENTIALLY ive went from 5 secs with 0 blocked emails to 70 secs with just 300 blocked emails its taking around 5 secs for every additional email i add i had a look at the query it doesnt seem excessive but something is slowing it down i need this looked at to see if we can come up...
I need to bulk import several products to my website but my csv isnt being able to filter down each category input. the task is to help with the file so I can successfully upload those new products onto woocommerce
...process verifies email by email from a given list -Email validation status values are retrieved and matched with email list records -For each validation performed the system consumes one credit from the customer´s balance Current situation: Same as above, but instead of performing validations email by email, better perform a file validation, has an API to do it. It takes the CSV file and uploads to , then it processes the file and returns results using API. For each list sent and validated, the cost of it (count of validated emails )should be deducted from the customer´s balance. I have an active subscription plan with MillionVerifier, so direct access to their API would not be a problem. Note: Please no Bidders without prior experience in A...
...create new teaching materials for teachers to use in the classroom every day. You can find examples of good teaching materials here: Nice cover: Currently, I would like to have different teaching materials for children in grades 1 to 4 (ages 6-10). Each material should have a goal. Please let me know in advance exactly what the material you create will be used for, what subject it will be used for and how it will be used. Each material should be 5-25 pages long with 1 cover page (in a file). No copyrights must be infringed (if other resources/licenses other than are used, always specify). Only unique content created entirely by you. The material
I want some one to build app that contain a database for collecting company. Details: we have customers and we need database which contain their names and if they pay or not yet. features : ability to Search for customers information Interface for sign in for each employee work in this sector For each customer there is sign if he paid or not yet
After reviewing the files you have sent, I understand that you are looking for SQL expert to write sql query and extract the data. I have carefully analyzed your needs and believe that I possess the skills and expertise necessary to successfully complete this project. I estimate that I will take approximately 1-2 days to complete.
I am seeking a proficient data entry specialist for my project. Here are the critical details you need to know: - The task involves alphanumeri...The task involves alphanumeric data that requires careful inputting. - The data sources are hardcopy documents, so having excellent attention to detail and experience handling paper files are crucial. - Ideally, the candidate should be familiar with scanning and OCR techniques to facilitate the data entry process. - The end goal is to have the data accurately entered into a database. If you have expertise in database structuring and maintenance, this would be beneficial. - Proficiency in data entry, document scanning, OCR, and databases are preferred skills for this job. Thank you for considering this project. I look forward to ...
This site i need the data, only Coingeko will block scripts like selinium so i need the data from other site or api, and need it in CSV here is a example i need, the volumes by hour and day are most importand for me.
...skills and attention to detail. Python Expertise: Proven experience in Python development with a focus on ETL processes. A deep understanding of data extraction, transformation, and loading best practices. A track record of successfully automating ETL pipelines for efficient data processing. Excellent problem-solving skills and meticulous attention to detail. Delivarbles: structured and organized CSV files, each containing accurately transformed, structured data. An automated and efficient ETL pipeline that can be easily maintained. Regular updates on project progress, ensuring we're always on the same page. If you're a Python ETL expert looking for an engaging project, we'd love to hear from you! Please send a propsal detailing your relevant experience, a brie...
I am hoping to turn my paper-based warranty sheet books into a searchable, easy-to-use digital database. This database will have to support adding new entries, as I need to be able to continuously update it. Key requirements: - Convert 1000-2000 paper-based warranty books into a digital format - Create a database where all information, including product names, warranty periods and terms, customer names, installation dates, addresses, and model and serial numbers, can be easily searched and accessed. Ideal candidates would have: - Previous experience in creating and managing databases - Strong organizational skills to ensure data accuracy - Ability to understand and manage complex data sets.
...in the 3 boxes will be saved to the 3 tables in SQLite. The page will also have a ‘view’ button that print all records of all 3 tables. There will also be 3 buttons: ‘partial’, ‘full’, and ‘export’. If click on ‘partial’ then it will save a copy of the SQLite database to the user’s iCloud but will only save table 1 and 2. If click ‘full’, it will save a copy of the SQLite database to the user’s iCloud and will include all 3 tables. If click ‘export’, then it will save a full copy of the SQLite database to the user’s device file manager. There will also be a section that lists all the versions saved to iCloud. There will be a ‘restore’ button f...
I am seeking an experienced database architect who can assist in creating an extensive database with listings for Engineering companies, Accountants, and Restaurants/hotels in Australia. Your task will be to collate valuable data to include: - Comprehensive Contact information - Business Address - Company Website - Detailed Business Description - Director's Name - Director's Contact details - Postcode - Company Size (Small, medium, large, multinational) - Number of Staff employed - Type of Services Also, I want these listings to be sorted Alphabetically to promote navigation ease. The freelancer who takes on this job will ideally have: - Experience in database creation and management - Excellent attention to detail - Good knowledge of Australian busines...
I'm in need of a SQL, web/app developer skilled in the areas of database creation and management, the database is already connected, but its not sending the info properly. Key Responsibilities: - Design a robust, SQL-based database for efficient data storage - Implement proficient data manipulation techniques as per project requirements Ideal SQL developer for this project should possess: - Proven experience in SQL database creation and management - In-depth understanding of data storage procedures - Expertise in data manipulation techniques.
I am in need of an experienced Data Entry Specialist who can efficiently convert my physical documents into text data to be inputted into a database system. Key Tasks: - Convert physical documents into electronic format - Accurately input the text data into a database Requirements: - Must have strong typing skills - Fast and accurate in transcription - Having extensive experience in data entry - Experience with databases preferred - Capability to handle a volume of documents - Attention to detail is crucial This project requires a fast, accurate, and skillful data entry specialist who has a good understanding of database systems. The accurate and dependable execution of this project is my top priority, so I am seeking someone who can deliver precisely.
...their ownership transferred to end users - Quizzes In terms of form response management, I require a software that can: - Send email notifications - Store responses in a database - Integrate with other software or systems such as excel is optional Lastly, advanced customization for the forms is of utmost importance for this project. My business demands inclusion of features such as conditional logic and custom fields for better user experiences and data collection. Ideal candidates for this project will have experience in software development, specifically in creating form building programs. A robust understanding of database management, system integration, and a keen eye for software customization is essential. Knowledge in creating interactive GUIs would also be a g...
I need a detailed and broad global database of one thousand neon sign companies. This is for networking purposes, so your role will primarily be about gathering reliable and accurate data. Whilst the main information required is EMAIL ADDRESSES, company name and country they are based in, an extra insight into each company's annual revenue would be an additional advantage. This research project does not place restrictions on any particular global region, so the broader the spectrum of countries, the better. The deliverable for this project will be a spreadsheet with the aforementioned details. Top-notch research skills and experience in data gathering are crucial for this task. A knack for accuracy and detail is highly appreciated. 100AUD is the project price.
We are seeking a skilled Electrical Engineer with expertise in PCB design using Altium Designer to execute the panelization of 7 distinct PCB designs. The successful candidate will be responsible for preparing...candidate will be responsible for preparing and optimizing each design for manufacturing (DFM) and ensuring efficient utilization of PCB space during panelization to minimize costs and enhance production efficiency. Deliverables: -Panelized PCB design in Altium Designer format (.PcbDoc). -Gerber files for the panelized design. -Bill of Materials (BOM) for the design in Excel or CSV format. -Pick and place files (.CSV) for automated assembly. Requirements: -Proficiency in Altium Designer for PCB layout and panelization. -Experience with DFM principles and PCB manufac...
I need an expert well-versed in Python or Access macro to create a solution for processing data from a .csv file and exporting the results to multiple .csv files. Export to a new .csv file every time the data in the first column changes. See attached power point for details. It will be employed on a Windows operating system - no specific Python version was mentioned, so either current stable releases of Python 2 or 3 should work. The responsibilities and requirements are detailed as follows: - Data aggregation: Your solution should be capable of aggregating the data where necessary. - Category-wise CSV Export: Export the resulting data into .csv files, with one file per category of data. The ideal freelancer for this project ...
I require a detail-oriented professional to assist in a crucial data entry project. Your role will involve: - Gathering text data from online files - Accurate entry of said data into a pre-established database system - Ensuring the integrity of information by checking for accuracy while entering the data The ideal freelancer for this task should have: - Solid experience in data entry from online sources - Proven accuracy and attention to detail - Reliable access to high-speed internet - Strong competency with database systems Understanding of specific database system tools would be beneficial for this project. Please indicate your familiarity with data entry into databases in your bid.
...and promotions with a 50% discount. Users will have access to a wide range of purchasing opportunities, covering various product categories. Project Benefits: Expansion of research to cover a wide range of offers. Increased accuracy in online searches. Specific relevance to user needs in the buy-sell market. Overall improvement of the user experience. IT Professional Needed: Advanced Search Query Architect: We are looking for an IT expert specializing in optimizing online searches through advanced queries. Required skills include: Programming Languages: Advanced experience in scripting languages like Python to develop a dynamic and adaptable script. Google Dorking and Advanced Search: In-depth knowledge of Google Dorking and advanced search techniques. Reference Ontolog...
I am in need of a knowledgeable a...need of a knowledgeable and experienced freelancer who is proficient in SQL and using the Visual Studio Code editor. Specifically, I need assistance in: - Opening SQL and source files - Modifying existing SQL code Your skills and experience should ideally include: - Proven expertise in SQL, including writing and modifying code. - Familiarity with Visual Studio Code, and general code editing and file opening. - Strong problem-solving skills and attention to detail. - Excellent communication skills and the ability to work independently. This is your chance to showcase your SQL and Visual Studio Code knowledge and your ability to modify existing code, ultimately helping me resolve my issues with oustanding efficiency. I look forward to connecting...
...or books, ask detailed questions, and receive answers extracted directly from the uploaded content using AI technology. Project Components : Frontend Development: The project will include the creation of a responsive, user-friendly interface using React or Angular. Experience in developing intuitive file upload experiences and dynamic user interfaces is essential. Backend Development: We'll be architecting a robust backend using Flask or , focusing on secure API endpoints for file management and integration with cloud storage solutions like Google Cloud Storage or Amazon S3. PDF Processing & Text Segmentation: Involvement in converting uploaded PDFs to text and segmenting the content into manageable sections for AI processing. Familiarity with PyMuPDF, PDFMiner,...
I am seeking expert assistance with a Microsoft Access report that is a bit complex for me. The report is built around several linked tables, and I am currently having difficulties managing calculations and queries related to it. Key Tasks: • need last price from vendor for list of items in a table • Revising existing queries • Extracting operational data The crux of this project revolves around understanding the report and improving the queries to get the right operational data. As such, vast experience in handling Microsoft Access linked tables and proficient knowledge of SQL will be crucial. Thank you for considering my project.
I need someone proficient in WordPress and WooCommerce to help me upload 3 CSV files, each containing 50,000 products, to my eCommerce site within a 24-hour timeframe. The CSV files, formatted in Excel, consist of product details including the product name, descriptions, and images. Note that there are no size or color variations in the products. This project requires: - Expertise in WordPress and WooCommerce product upload. - Familiarity with Excel CSV formats. - Fast and efficient working capacity to meet the 24-hour deadline. - Accuracy in uploading product details as provided. - Familiarity with image uploading and placement in product descriptions. The lowest bid will be favored, however, adherence to the requirements and timeframe is paramount.
