Database query csv file jobs
I'm looking for a detail-oriented freelancer to help with data entry from survey results. The data is currently in Excel/CSV files, and I need the data to be accurately entered and organized. The specific information that needs to be entered includes demographic data, response summaries, and open-ended comments. Ideal skills and experience for the job: - Proficiency in Excel and CSV file handling - Experience with data entry and market research - Attention to detail for accurate data handling - Ability to manage and organize different types of data.
Enhance SQL Server trigger on the UserProfile table to correctly handle scenarios where RoleId changes for a given UserId (via UI or direct query) and log them appropriately in the UserProfileHistory table.
I need a skilled professional to seamlessly integrate my Microsoft Access Database with a daily-updated Excel sheet. The Excel sheet contains mixed data (text and numbers). Key Tasks: - Daily integration of updates from the Excel sheet into the Access database. This includes both appending new records and updating existing ones. Ideal skills and experience: - Proficient in Microsoft Access and Excel. - Experience with data integration and automation. - Ability to set up a system that requires minimal manual intervention.
I need a skilled freelancer to scrape product information from a specific website. The task involves extracting a total of 841 entries accurately and efficiently. The data fields req...freelancer to scrape product information from a specific website. The task involves extracting a total of 841 entries accurately and efficiently. The data fields required include product name and price, product description and images, and product specifications and reviews. The ideal candidate should have experience with web scraping tools and techniques, ensuring clean and organized data output in CSV format. Key Requirements: - Web scraping expertise, preferably with Python - Attention to detail for data accuracy - Ability to deliver results in a timely manner - Providing the code used for the scr...
Project Overview: React/TypeScript application using for video meetings, integrated with Supabase for backend services. The application handles interview scheduling and video meetings but has connection issues that need debugging and fixing. Tech Stack: Frontend: React 18, TypeScript Backend: Supabase Video Integration: State Management: React Query UI Components: Shadcn/UI Real-time Updates: Supabase Realtime Current Issues: Meeting connection failures Token creation errors Room URL validation issues Device permission handling problems Key Files to Work With: src/components/ src/components/ supabase/functions/manage-daily-room/ src/components/ Required Skills: Strong experience with React and TypeScript Experience
...environments. Monitoring Requirements: Host-Level Metrics: Ping and availability CPU usage (load averages, CPU core utilization) Memory (RAM usage, swap usage) Disk (IOPS, available space, read/write operations) Network traffic (bandwidth usage, errors, dropped packets) Service uptime Service-Level Metrics: Web services (HTTP/HTTPS status, performance, and visitor statistics) Database performance (MySQL/MariaDB, including query statistics) Mail servers (Exim/Postfix queues, processed emails, deferred emails, etc.) DNS server health FTP server monitoring Other cPanel/DirectAdmin-specific services and statistics Backup monitoring Security and Logs: User login activity Firewall rules and hit statistics Error logs and system log monitoring Mail log monitoring Apache log ...
I'm looking for a web-based, secure chat platform primarily for text messaging and file attachments, with normal level of security. Key Features: - Text messaging: The platform should facilitate seamless text communication. - Text and File Attachments: Users should be able to send and receive file attachments without any hitches. 2 or 3 users can join and chat or send files. With specific room. Look at this example: Project 1: user 1 and 2 should be able share ideas, and share their works and get comments Project 2: User 3 and 4 can do the same. Would be good that I can delete rooms or create new ones. User Authentication: - The system should use a simple username and password for user authentication. Ideal Skills and Experience: - Proficiency in web dev...
I'm looking for a skilled developer to create an automated script that scrapes products from an eCommerce site. The script should capture comprehensive product details and export them into a CSV file via Excel. Key Requirements: - The script needs to operate automatically, without manual intervention. - It should meticulously gather: - Photos and text - Price and description - Category and SKU Ideal skills include web scraping, Python or similar programming language expertise, and experience with data handling in Excel and CSV formats. Please ensure your proposal includes relevant past projects, as well as your approach to this task.
More details: What specific tasks do you want the macro to perform? Data analysis, Data formatting Do you need the macro to run automatically under certain conditions? No, I'll run it manually What level of user interaction do you foresee with the macro? Simple prompts and inputs
...into post-trade stock movements, such as: Maximum progression Re-entry price hits End-of-day value Customizations: Allow users to upload a list of stocks in .csv format for scanning. Provide filters to shortlist stocks based on Elliott Wave patterns, Fibonacci levels, RSI, and other criteria. Set adjustable parameters for trading conditions, such as time frames, indicators, and thresholds. Technology and Platforms: Programming language: Python (preferred), or any suitable language. Frontend: Simple and user-friendly interface (web-based or desktop-based). Backend: High-performance algorithm with cloud or on-premise hosting. Database: Store historical data, strategy parameters, and trade logs. Risk Management: Automate risk management, including position sizing, maximum ...
I need a skilled AutoCAD professional to create a KMZ file for mapping purposes. The level of detail required is medium, so it's crucial to understand how to balance detail with clarity. The project involves agricultural land parcels spreading across multiple villages. We need to consolidate these various maps and present them in KMZ and pdf formats. Key elements that need to be included in this KMZ file are land/survey numbers.
...Option to generate commissions for pickups. - A seller dashboard for managing pickups. - Configure the above with the Dokan plugin. - Allow sellers to process multiple orders in bulk for shipping. - Enable sellers to print shipping labels directly from their dashboard. - Automate shipment tracking updates for both sellers and buyers. - Add options for sellers to import and export shipment data via CSV files. - Integrate real-time shipping rate calculation based on package dimensions and destination. - Implement notification system to alert sellers of shipment statuses and issues. - Set up a system for managing shipment returns seamlessly. Ideal Skills: - Experience with Dokan plugin and its integration. - Familiarity with Shiprocket courier service. - Web development skills for...
...and state filters, allowing Employers to search Freelancers locally. Modify the Task Search/Listing Page to filter tasks/projects based on selected city and state. Database Changes: Add "City" and "State" fields in the Freelancer and Employer profile meta data. Ensure that the selected city and state are saved in the database when profiles are updated. Ensure Compatibility with Future Updates: Use the child theme to override necessary template files from the workreap-core plugin (templates directory). Avoid modifying the core theme or plugin files directly to ensure updates won’t overwrite customizations. Custom Query Modifications: Modify WP_Query or task queries to ensure that tasks and Freelancers are properly filtered by city a...
...include a scalable website, secure APIs, and an efficient database capable of handling billions of records (around 300-400 billions). The system will provide users with actionable insights through dashboards, monitoring tools, and real-time alerts. These are a few functionalities and features planned as of now. Once these implementations are completed successfully, we aim to scale the platform further by introducing advanced capabilities and enhancements to cater to a broader audience and meet future demands. To achieve this, we are looking for skilled professionals with expertise in database management, web development, and cloud infrastructure. Below are the detailed requirements for the project: Expertise Required 1. Database Administrator (DBA): • Prof...
...detection and CRM integration for lead management. Additionally, the AI can be trained using the user's voice to add a personalized human touch to conversations. Calls will be made using SIM-based calling instead of VoIP for reliability and cost-effectiveness. 1. Lead Management Integration with CRM: Import leads directly from our CRM system. Manual Import: Upload leads using Excel files or CSV format. Manual Entry: Allow users to input numbers manually. 2. Call Modes Manual Calling: Enable users to make calls directly through the app. AI-Powered Automatic Calling: AI should initiate calls on behalf of the user, engaging leads in natural, human-like conversations. - SIM-Based Calling Reliability: Calls are made using SIM-based telephony rather ...
I'm looking to create an e-commerce platform focused on selling digital products, specifically databases. The platform should have features that allow for product samples and multiple downloads. Key Features: - E-commerce functionality ta...that allow for product samples and multiple downloads. Key Features: - E-commerce functionality tailored for digital products - Product sampling capabilities - Allowing multiple downloads for customers In addition, I need the backend to handle customer data for marketing purposes. This means that the database needs to be efficient in storing and retrieving customer information, tracking campaign performance, and managing sales data. Ideal Skills: - E-commerce website development - Database management - Marketing data analysis - ...
I need a Python expert who can help me develop an automation script for monitoring my databases. Key Responsibilities: - Develop a Python script that can systematically monitor our databases. - Ensure the script can handle various database types. - Implement alerts for system anomalies or irregularities. Ideal Skills and Experience: - Proven experience in Python programming, specifically in creating automation scripts. - Prior experience in system monitoring is a plus. - Familiarity with various database types is highly desirable.
I'm looking for a professional with extensive experience in Odoo database migrations. My current system is the latest version of Odoo, and I need to migrate to the very latest version as well. Key Tasks: - Assess the current Odoo database and identify potential challenges for the migration. - Execute the migration to the latest Odoo version smoothly and efficiently. - Ensure data integrity and system functionality post-migration. Ideal Skills and Experience: - Proven track record in Odoo database migrations. - Deep understanding of the latest Odoo versions. - Strong problem-solving skills. - Excellent attention to detail.
Hi I had a designer improve the page of a back-end web app (a list of orders) and now I need to merge back those changes to the php file (and css and js) I'll provide you the new html file and ftp access to the php file. I'm using the adminlte template. Max bid 50 euros. Thank you.
I need an expert to update certain fields of user data in my database. Specifically, the changes involve age, birth year, school attendance dates, and high school graduation year, among others.
I'm looking for an expert to help me modify user activity history on a website's database. Ideal Candidate: - Proficient in database management and web technologies. - Previous experience with user data modification. - Knowledge of data privacy regulations and ethical standards. Task: - Edit existing user activity entries. Please note, the selected freelancer will have to work under strict confidentiality and adhere to data protection laws.
I need a WordPress developer to create a simple function that does the following: **Fetch Data from SQL: Retrieve the correct row from an SQL database based on a value passed in the URL query (e.g., ?workorder=12345). Extract the corresponding URL from the database. Display PDF: Use the retrieved URL to display a PDF file in a viewer, such as , in the same way as in this demo: **Integrate with Forminator: Pass the retrieved URL into a hidden field in a Forminator form, allowing it to be submitted with the form. **Additional Information: * The website is built with Oxygen Builder. * You will have access to all necessary systems to complete the task. * If you have experience with WordPress, SQL, PDF viewers (e.g., ), and Forminator, this task should
I am in need of a Microsoft Visual Studio expert with extensive experience in Visual Basic and database applications. I am currently developing a database application and require assistance with Microsoft Visual Studio. - **Skills Needed**: - Proficient in Visual Basic - Expertise in Microsoft Visual Studio - Experience with developing database applications - Excellent problem-solving and debugging skills - Familiarity with project setup and extension development in Visual Studio Your role will primarily focus on helping me set up the project correctly and ensuring that all components of the application interact seamlessly. If you are adept at troubleshooting and code debugging, it would be a huge plus. I am looking for someone who can help me make this p...
I have a project in CodeIgniter that was running perfectly, but now it's giving some errors. - Authentication emails aren't sending. - Emails aren't working. - Bulk upload of CSV files aren't working (Some Socket Issue In Network Tab). The application is installed on a VPS and I am using CWP Panel. Therefore, I need an expert in CodeIgniter who is also familiar with CWP Panel. Please type "CI" at the top of your bid so I can see you aren't a bot. Thank you.
...in 20 minutes). I need someone to accomplish two main goals in this project: 1) Modify the code so that only the bare minimum information is listened to in Alchemy to satisfy the requirements: For a given list of market/outcome IDs, once every 60 seconds fetch the object showing the top 10 holders and their number of shares. (And also NOT fetch any other information that will drive up Alchemy query usage.) 2) Configure the code so that it can be dynamic. I can write TypeScript code that will fetch and update a list of market/outcomes every 60 minutes. I just need you to configure the repo's code so that the connection to Alchemy reads in from a dynamic variable (the current list of markets). When you apply, send me an example of related Web3 work that you've done, o...
I'm seeking assistance with modifying a flat file database. The task primarily involves updating existing records. This is a one-time project.
Looking for a Python programmer to do the following: User will press a button. program will activate an output that will turn off at a preset time by the system (Regardless if the user continues to press in the input) The system will then wait a preset time before it will allow the input to activate the out put. Example: Preset on time := 10 Sec. (This s...on (for as long as the user presses the input or 'on time' (10 seconds has been reached) The user can try and press the input in after this but the output will not turn on. until the wait time has reach. Every time they press the input the system will log date and time. Every time the output is on the system will log duration, date and time This will need to be exported to a database where it can be retrieved in a ...
I'm looking for an experienced tutor for an intermediate level session focused on Power Query and Power BI. The session will involve using a practice dataset to clean data, transform it, and merge queries in Power Query. Key Areas of Focus: - Data Cleaning - Data Transformation - Merging Queries In Power BI, we will be concentrating on: - Creating Dashboards - Data Visualization - Automating Reports Ideal candidates should have a strong expertise in Power Query and Power BI, with proven experience in teaching and using practice datasets. Your ability to simplify complex concepts and create a fun, engaging learning environment will be key to a successful session. Please provide examples of previous tutoring sessions you've conducted related to these topics...
I'm looking for someone to develop a practical file for a BTech Computer Science and Engineering workshop. The file will be primarily for educational purposes. Key Components of the Practical File: - A well-structured written section that includes theory explanations - Diagrams relevant to the workshop content - White blank pages for additional notes or observations - Diagrams that will help visualize complex concepts Ideal Freelancer: - a strong background in computer science and engineering - Excellent writing skills - Experience creating educational materials
...protection for data privacy. • Ability to switch profiles within the app. 6. Third-Party Integration: • Integration with Google Fit, Apple Health, and potentially Strava. 7. Social Sharing: • Generate shareable summaries of activity and achievements. • Optional integration with social platforms (e.g., Instagram, Facebook). 8. Data Export: • Export health and activity data in formats like CSV and PDF. 9. Future AI Integration: • Enable personalized insights using AI for health improvement and activity optimization. Technical Requirements • Use the SDK provided by the smart ring manufacturer, which supports Flutter and both iOS and Android platforms. • Ensure secure storage and handling of health data, adhering to G...
...backend of the search engine for users to search results from the indexed data. • Features: • Simple, user-friendly interface for searching indexed data. • Fast and relevant search results. • Results should be displayed with the most relevant information at the top (based on keyword match, ranking, etc.). 5. Database Integration: • Purpose: Set up a database to store and manage crawled data and indexes. • Features: • Use a scalable database like MySQL, PostgreSQL, or MongoDB. • Efficient query handling to fetch search results quickly. 6. Scalability & Performance: • Goal: Ensure the entire system is optimized for performance, scalability, and reliability. • Details: The search engine should handle a larg...
I'm currently developing an iOS app that leverages the Screentime API and Family Controls. This app involves tracking usage, implementing parental controls, and setting up app restrictions. I'm seeking a seasoned Swift developer who can help troubleshoot coding issues and assist with the setup of specific code segments on a pay-per-query basis. Key Areas of Focus: - Usage tracking: I need guidance on how to implement this feature and help troubleshooting any issues that arise. - Parental controls: I require assistance with feature implementation and bug fixing. - App restrictions: I'm looking for an expert to help optimize performance and address any potential coding issues. Ideal Candidate: - You must be an expert in Swift, with extensive experience in Xcode and iO...
...management, such as notifying agents of assigned orders and allowing them to update the status of deliveries. Reports and analytics should be available for sales data, with an option to download reports in CSV format. Additionally, a mobile-friendly delivery agent portal should be created to let agents view their assigned orders and mark them as delivered. For the technical specifications, I prefer using PHP for the backend, with Laravel or CodeIgniter as the framework. The frontend can be developed using HTML, CSS, and JavaScript, with Bootstrap for responsiveness. MySQL should be used for the database. I already have hosting with Hostinger, so the system should be compatible with their services. Integration with Razorpay or Paytm is required for secure online payments.....
Looking to get a php api that takes a postcode. goes too my database and brings back customer details for that post code. A similar api is written like this so most of code can be copied. Simple project and i need this done today public function geteircode(){ if(isset($_POST['eircode']) && !empty($_POST['eircode'])){ $code = strtr($_POST['eircode'],[' '=>'']); $ir_identifiser = array("A41","A42","A45","A63","A67","A75","A81","A82","A83","A84","A85","A86","A91","A92","A94","A96","A98","C15","D01","D02",...
I'm a recent high school graduate seeking assistance with data entry into my SQL-based database. Ideal Skills: - Proficient in manual data entry - Experienced with SQL databases (e.g., MySQL, PostgreSQL) - Strong attention to detail and accuracy - Good communication skills - Problem-solving abilities
Project Overview: Comprehensive Airport Lounge Database Creation I am seeking a detail-oriented freelancer with strong research and data collection skills to compile a comprehensive and accurate list of airport lounges worldwide. This project focuses on categorizing lounges into the following types: Airline Lounges (operated by an airline) Common-use Lounges (operated by an independent lounge operator) Priority Pass Lounges (similar to common-use lounges but within the Priority Pass network of lounges) The compiled data will be delivered in a well-organized CSV file, suitable for analysis and integration into other platforms. Scope of Work: - Conduct thorough online research using search engines and reliable travel resources to identify airport lounges globally. ...
...Technologies - Flutter (Latest stable version) - Flutter Web - Firebase - Dart (Latest stable version) ### Required Firebase Services Knowledge 1. Firebase Authentication - Email/Password authentication - Phone number verification - Custom claims for role-based access - Security rules implementation 2. Cloud Firestore - Database design and structuring - Query optimization - Indexing - Security rules - Batch operations 3. Firebase Storage - File upload/download - Security rules - Image optimization - Content delivery 4. Firebase Cloud Functions - Background tasks - API endpoints - Scheduled operations - Event triggers ### Required Flutter Expertise 1. State Management - Provider pattern - State lifecycle ...
I'm looking for a freelancer who can help me convert a PDF file into an editable document. This involves typing out the content of the PDF, with the following specific requirements: - The document should be formatted as a simple text format. - Maintaining the original layout is not necessary, but accuracy in transcription is crucial. - Attention to detail and a commitment to producing high-quality work are essential. Ideal skills for this job include strong typing abilities, proficiency with word processing software, and experience with document formatting. Please note, there are no specific sections of the PDF that require prioritization or special attention.
I need assistance with finding product codes (SKU and size in either US or EUR and link for a proof) for 4100 EANs. The data should be sourced from Google or VERY easy because 2 /3 brands only Key Requirements: - Data processing and research skills - Experience with Excel/CSV - Ability to follow a specific format for data input I will provide the EANs in a spreadsheet (Excel/CSV) and I already have a format for the SKU and size. This is a straightforward project that requires basic data input and online research. Please be prepared to work meticulously and efficiently.
I need help adjusting the size and bleed areas on some card files I have. - Current Format: The files are in PDF format. - Task: There are 30 cards (60 pages front and back) that need overall size adjusting according to specific dimensions provided by my card printing manufacturer. All content is already in place, so this is minimal work. - Software: I have tried using Adobe Acrobat for adjustments, but it hasn't been successful. If you have experience with this type of project and are able to help, I would greatly appreciate it. Thank you in advance.
...backend of the search engine for users to search results from the indexed data. • Features: • Simple, user-friendly interface for searching indexed data. • Fast and relevant search results. • Results should be displayed with the most relevant information at the top (based on keyword match, ranking, etc.). 5. Database Integration: • Purpose: Set up a database to store and manage crawled data and indexes. • Features: • Use a scalable database like MySQL, PostgreSQL, or MongoDB. • Efficient query handling to fetch search results quickly. 6. Scalability & Performance: • Goal: Ensure the entire system is optimized for performance, scalability, and reliability. • Details: The search engine should handle a larg...
I have multiple Excel files that need to be consolidated into a single Excel workbook. Each file should be placed in a separate sheet named according to its original file name. No data transformations or cleaning are required. Ideal skills for this project include: - Proficiency in Microsoft Excel - Experience in data consolidation tasks - Attention to detail to ensure correct file placement and naming.
I'm looking for a freelancer who can help me convert a PDF file into an editable document. This involves typing out the content of the PDF, with the following specific requirements: - The document should be formatted as a simple text format. - Maintaining the original layout is not necessary, but accuracy in transcription is crucial. - Attention to detail and a commitment to producing high-quality work are essential. Ideal skills for this job include strong typing abilities, proficiency with word processing software, and experience with document formatting. Please note, there are no specific sections of the PDF that require prioritization or special attention.
This project aims to streamline and automate data preparation, analysis, and visualization processes within the tourism sector. By transitioning from manual Excel-based workflows to an automated system using Power BI and Power Query, the project seeks to improve efficiency, accuracy, and decision-making capabilities. Objectives of Dashboards in Power BI Build interactive dashboards to visualize key trends, traveler preferences, and satisfaction levels. Utilize advanced Power BI features such as DAX formulas and custom indicators to provide meaningful insights. Statistical Indicators Generate descriptive statistical measures (e.g., average, median, and standard deviation) directly within Power BI. Use these measures to establish benchmarks and identify trends.
I'm looking for a comprehensive database of 10,000 active job seekers with a focus on entry-level & mid-level Software Development skills. Requirements: - Job seekers should be looking for job in IT field. - Database should include first name, last name, email, and phone number. Please note, the job seekers must be currently seeking IT roles.
I need assistance with my Android app which reads a .bds file from Busy Accounting software's MS Access database. Currently, the app can read the file but cannot update it without causing corruption. I want to be able to add new records and modify existing ones. Key Requirements: - Diagnose and resolve the corruption issue when trying to update the .bds file. - Implement functionality to add new records and modify existing ones from the Android app to the .bds file. Essential Skills: - Experience with Busy Accounting software and .bds file structure. - Proficiency in Android app development, particularly with direct file access. - Knowledge of MS Access database management. Please note, I need a solution that does not require ...
I'm seeking a freelancer who can provide me with a daily supply of up to 30K email addresses of individuals aged between 50 and 60 in the USA. The primary purpose of this email database will be for marketing campaigns, so the emails should be valid and ideally have a history of engagement with similar campaigns. Skills and Experience Required: - Data mining and web scraping - Experience with email list building - Understanding of demographic targeting - Knowledge of email marketing standards Please note, the lists need to be delivered daily, and must be of high quality to ensure maximum deliverability and engagement.
I need a skilled developer to create a .Net core, Web API connected to a MySQL database. The main function of the API will be data retrieval, specifically user data. Key Requirements: - Proficient in .Net core and Web API - Strong experience with MySQL - Previous work with creating APIs for data retrieval - Able to understand and implement secure data retrieval practices Please note that the specifics about the users accessing the system (admin users, end-users/customers, or both) have yet to be determined. However, the API will primarily need to handle requests for user data.
I’m working on an Angular/.NET application with a functional small attachment tab UI and several working APIs. However, I’m facing issues with two APIs: 1. Insert API: Data is not being inserted into the database. 2. Fetch API: Unable to retrieve data properly. Technologies used: - Frontend: Angular - Backend: .NET Core, .net framework - Database: [SQL Server/MySQL, MongoDB.] Deliverables: - Fix the insert and fetch API issues. - Ensure proper testing for functionality.
