Sql code extract xls file jobs
I need a Windows-compatible program that can execute a DOS .bat file, read values from .txt files after its execution finishes, and insert them into a MariaDB SQL table Has to be able to be "scheduled" to auto-executed each 12 hours. Could be a resident, a Windows Service, or via Windows Task Manager Ideal Skills: - Proficiency in programming for Windows - Experience with SQL, specifically MariaDB - Familiarity with DOS .bat files - Ability to read and process .txt files for config (IP of the DB, user, pass, table, fields, etc) - Ability to read and process .txt files (xml style) 4 variables will be readen from the .txt files 8 fields will be updated at the DB (4 for the variables, 4 time-stamps) The successful freelancer will be able to efficiently conn...
...database - A database that can assist officers in matching vehicle descriptions - Automatic location updates for efficiency, using built-in location settings User roles: - Admin - Officer - Viewer As for the database, I'm currently unsure which to use - SQL or NoSQL. I would appreciate your guidance on this matter. Ideal skills and experience for this project include: - Expertise in mobile app development for both iOS and Android - Knowledge of cloud-based systems - Experience in creating role-based applications - Familiarity with SQL and NoSQL databases - Skills in integrating location services into mobile applications The app should have a modern and minimalist user interface design. Please use native development for optimal performance on both iOS and Android ...
I'm experiencing problems with incorrect label assignments in my Embedded C AVR programming. The issue seems to occur during test runs. I need an expert who is proficient in AVR programming and can help me debug this issue.
...provider or to update our database remotely when rooms or particular service is full or not available or for us to offer others a standby options to a database list of standby users. The ideal freelancer for this project will have a strong portfolio of building business directories, Airbnb type comparison sites, building site around customised large Databases, WordPress projects, particularly using SQL or as suitable, HivePress THEMES (Listing PRESS and Rental Press), and a keen understanding of corporate and professional design aesthetics. Your ability to create a clean, modern, yet corporately styled interface will be key to the success of this project. Someone with strong AirBnb, Reservation, Portal. In addition, maybe some knowledge of A.I skills solutions knowledge w...
...Python-based web application that validates data integrity between a SQL database and Elasticsearch using Logstash pipeline configurations. The application will accept any Logstash .conf file, parse it to extract SQL queries and Elasticsearch mappings, query the database and Elasticsearch index, and validate that the data matches. This ensures the data flow configured in the Logstash pipeline is functioning correctly, with any discrepancies clearly identified. The web application will be built using Flask or Django and include an intuitive interface. Users will be able to upload a Logstash .conf file and input the connection details (locations and credentials) for both the SQL database and Elasticsearch index. The interface will display the ...
...com/courses/temperature-transmitter
I need a freelancer to extract product details from multiple e-commerce websites including Zara, H&M, and Country Road. The extracted data should be delivered in JSON format. The specific product details I need include: - Product name and price - Product description and images - Product reviews and ratings - Page URL - Image URL Ideal candidates for this project should have experience with web scraping and data extraction from e-commerce sites. Proficiency in delivering data in JSON format is essential. An understanding of the significance of each data point for e-commerce analysis will be an added advantage.
I'm looking for a proficient web lister who can help me extract data from a dynamic webpage that's heavily reliant on JavaScript. Key Requirements: - The project involves looping and auto-loading data from link list on the webpage. - You will need to add two columns to the extracted data for calculations. - The data should be saved in a CSV file. Calculations: - The first additional column will be the difference between existing data columns. - The second column is yet to be determined, but it could involve further calculations based on the data extracted. Ideal Skills: - Proficiency in web scraping techniques, specifically from dynamic webpages. - Experience in data manipulation and calculations. - Ability to save data in CSV format. - Familiarity with JavaScri...
I'm looking for a proficient web lister who can help me extract data from a dynamic webpage that's heavily reliant on JavaScript. Key Requirements: - The project involves looping and auto-loading data from link list on the webpage. - You will need to add two columns to the extracted data for calculations. - The data should be saved in the webpage. Calculations: - The first additional column will be the difference between existing data columns. - The second column is yet to be determined, but it could involve further calculations based on the data extracted. Ideal Skills: - Proficiency in web scraping techniques, specifically from dynamic webpages. - Experience in data manipulation and calculations. - Ability to save data in CSV format. - Familiarity with JavaScript and...
Objective: Looking for someone to get started now. This should be a short and quick project. Please see attached files. Message me if you are ready. This project involves integrating an Arduino Nano ESP32 with a DY-SV5W MP3 audio module to play a specific audio file stored on an onboard SD card when an analog audio signal is detected. The audio currently plays, but I am having trouble getting the Arduino to control the start and stop of the DY-SV5W Audio. Assistance is required to trouble shoot or validate both wiring and Arduino IDE coding to ensure proper functionality. Project Overview: Hardware: Arduino Nano ESP32: Central controller for the project. Pinout and datasheet are provided. DY-SV5W Audio Module: Plays preloaded MP3 files from its onboard SD card. Datasheet provide...
thank you for being here; Please see the attached "" attached to the project here For each in column "M" or "Payee Name" would like a total for that item and # of items of column "C" or "Amount" Expect the report to be something like below with aligned columns in fixed text report/ XYZ company. $434.29 records 7 PDQ company $581.23 records 3 Please note I will run this on Python 3.12.4 | packaged by Anaconda, Inc Please allow time for me to test and will cheerfully express happiness in a review . Would appreciate if this could be done within 2 hours, and ideally we can keep the hourly budget to a maximum of $10. I'm hoping th...
I'm seeking a skilled professional to set up a NAS system primarily for file storage and backup. The main files stored will be photos and videos, so it's essential that the system can handle large file sizes efficiently. Key aspects of the project include: - Setting up a NAS that can be accessed by a small team (2-10 users). - Ensuring the system is reliable and secure for storing sensitive content. - Providing a user-friendly interface for team members of varying tech-savviness. Ideal candidates should have prior experience with NAS setup, particularly for media storage, and should be able to provide references from similar projects. Please include your relevant experience in your bid.
I'm seeking a Data Scientist Trainer for 1-2 hours daily. The focus i...Science. - Sharing hands-on experiences and insights from the field. - Mentoring professionals looking to advance their Data Science careers. Ideal Candidate: - Minimum of 1 year experience as a Data Scientist. - Proven track record of conducting engaging and practical training. - Excellent communication and mentorship skills. - In-depth knowledge of Python and its libraries, R and its packages, SQL and databases. The training will be for advanced professionals, requiring the trainer to tailor content to challenge and develop these experienced individuals. The training sessions will be delivered online. The training should have a dedicated focus on Deep Learning. The training sessions will be delivered o...
thank you for being here; Please see the attached "" attached to the project here For each in column "D" or "Name" would like a total for that item and # of items For each in column "D" or "Name" that is "black" would like a total for that item and # of items column "E" or "Type" Expect the report to be something like below with aligned columns in fixed text report/ XYZ company. $434.29 records 7 PDQ company $581.23 records 3 PreApproved Payment Bill User Payment $973.11 records 123 Please note I will run this on Python 3.12.4 | packaged by Anaconda, Inc Please allow time for me to test and will ch...
...Tracking of referral counts - Preventing self-referrals - Implementing a leaderboard The foundational code can be referenced from two GitHub projects: 1. - for the basics 2. - for the leaderboard part I'll be using Pycharm for the project, and we can utilize a free SQL database for data storage. It's important that the developer can adapt the existing code to meet our needs, as some of it may be outdated. Ideal skills and experience for the job include: - Proficiency in Python - Experience with developing Telegram bots - Familiarity with SQL databases - Ability to work with and adapt existing code I'm keen to have the bot developed swiftly and efficiently, with a focus on functionality and reliability
I'm seeking a skilled data engineer to assist with processing mixed data from CSV files. The primary focus will be on data transformation, as I need to prepare the data for further analysis or machine learning tasks...from CSV files. The primary focus will be on data transformation, as I need to prepare the data for further analysis or machine learning tasks. Key Responsibilities: - Transforming mixed data from CSV files - Refactoring existing code for improved efficiency and readability Ideal Skills: - Extensive experience with data transformation - Proficiency in handling mixed data - Strong coding skills, particularly in Python or R - Familiarity with CSV file manipulation Please provide examples of past projects that demonstrate your capability in data processing...
I need a Graffana dashboard in Azure designed for operational reporting. The dashboard needs to track specific metrics including System uptime, Response time, Error rates, and overall availability. ...time, Error rates, and overall availability. Key Requirements: - Proficiency in using Azure and Graffana - Experience in designing dashboards for operational reporting - Ability to track specific metrics and KPIs - Skills in data visualization The dashboard needs to connect to various data sources, primarily SQL databases and Cloud services. Therefore, experience in working with these data sources is crucial. The ideal freelancer would have a solid background in cloud services, SQL databases, and Graffana. Please only apply if you can demonstrate relevant experience with th...
Project Title: Windows/Mac OS Application Developer – Banner Overlay for .EXE Window Project Description: We are seeking an experienced Windows and Mac OS developer to create a wrapper application that overlays a customizable banner or user interface over a running .exe file. The banner should remain in the foreground, providing information or branding, while the .exe runs seamlessly in the background. Key Features: Banner Overlay: A static or dynamic banner visible above the .exe window. Customizable design, including text and images. Resizable and repositionable banner. Seamless Integration: Ensure the underlying .exe application runs without interference. The banner must not obstruct critical functionality of the underlying program. Cross-Platform Support: Compatibili...
The objective of this web app is to organise and clarify a succession to be split between different successors. • The app shall gather in the same place various documents related to this legacy: emails, PDF, XLS, WORD, FMP, etc. • These documents come from multiple sources: external drives, local drives, emails and from different persons. • Users shall connect to the app with their credentials to view, navigate, search, export and print out. • This app is for internal use only. Deliverables: - User Panel: consists off 8 menus (list + detail page): - Admin Panel: consists off 8 menus. Ability to enter, edit and delete data and to create user - User credentials: no need to sign up. Users are created only by the admin - Design: there's a global overview but n...
I have a mockup of a logo that I need someone to recreate into an editable AI file. I also need the logo to be modernized into a minimalist style with vibrant colors. Ideal Skills: - Graphic Design - Proficient in Adobe Illustrator - Experience with logo design and modernizations - Understanding of minimalist design principles - Color theory knowledge for vibrant color application
I have a Python code that I use on a postal website that automatically makes postal labels from an Excel CSV file of orders that I feed it. Recently, one thing changed on the postal website, there used to be a scroll and click menu for the destination country. Now, there is a scroll and click option but also a type in the country option - because of this change, my code is giving an error at this point. The code is already written, I just need someone to help modify the code with the new scroll option on the website. I need this done ASAP and the budget is €5 as it is a quick and easy fix for someone who knows what they are doing. Here is the link to the website - The python script is attached
...work with !! I have set a budget already for the project. Lets stick to it! I'm looking for an experienced backend developer with strong JavaScript skills. The primary focus of the project will be integrating a MySQL database with both third-party and internal APIs. Key Responsibilities: - Implementing a robust SQL database/backend integration - Ensuring seamless API connectivity and data flow Ideal Skills: - Proficient in JavaScript backend frameworks - Experienced in SQL database management, specifically MySQL - Skilled in both third-party and internal API integration The goal is to create an efficient, user-friendly backend system. Your expertise will greatly contribute to data processing and user authentication. Please include previous similar projects in y...
MY BUDGET IS $70 NON NEGOTIABLE I'm looking for a Python developer to create a script that automatically updates my Minecraft mods from version 1.12.2 to 1.20.1. The mods are integrated with Forge and include various changes like new items and blocks, gameplay mechanics modifications, and world generation alterations. The script should ensure basic compatibility with the newer version of the game. Ideal skills and experience: - Proficient in Python - Familiar with Minecraft modding, particularly with Forge - Understanding of basic compatibility requirements for Minecraft versions - Experience in coding for game modifications Please note, the main requirement is to ensure the mods are compatible with the newer version of Minecraft, not to enhance their functionality with new feature...
Sql and python assistance Sql and python assistance
...will be to see who can develop code that writes the most data in the least amount of time using C++, taking into account some output files may be 1-5tb range and multithreading for multiple files writing at the same time. The best solution will be awarded the project. Please see attached project which is currently using PHP and xampp local web server. ***PLEASE NOTE - the only thing to covert to C++ code is the "write to file" button, not the entire script**** This script combines the 3 panels into every possible combination of things. Normal use will be to have a large list is box a, box b, and box c. Then pressing "write to file" will combine them. 1) Copy the existing php combine script that runs when pressing "write to f...
I'm looking to create a 30-second video from a source file. The video should highlight key moments and be crafted for educational purposes. video to me made in 3d and from 3d source file. .stp format. source file. Key Requirements: - Highlight key moments in the source file - Edit the video to fit a 30-second duration ATTACHED SAMPLE VIDEO output file. total is 3 case to make video. (we no need any background effct etc need this simple so that any one can know how to open and fix mobile in this case. that is the main purpose. Ideal Skills and Experience: - Video editing - Understanding of educational content creation - Ability to identify and emphasize key moments in footage
I am looking for a Python expert to develop an online data scraper tool that can extract data from our supplier websites. detail of product prices and stock and other info which required. The data needs to be cleaned and organized, and the preferred output format is Excel so we can upload on ebay and amazon and on our website easily. The ideal candidate should have experience in web scraping, Python, and data organization. The project will involve the following tasks: - Developing a web Custom scraper tool to extract data from specific 20 Supplier websites. - Cleaning and organizing the data to make it usable for each website. - Exporting the data in Excel format. and store on our cloud folder. and local folder. - Testing and debugging the tool to ensure it works efficientl...
...notifications for passport expirations, birthdays, and special notes. Ability to issue unique chip cards linked to customer profiles. Android & iOS Apps: Mobile camera integration for scanning passports, ID cards, or visas (OCR functionality). Compatibility with chip card readers to fetch and display customer data instantly. Notifications for reminders (e.g., expiring documents, birthdays). Key Features: Extract and save customer details (name, DOB, passport number, expiry date, etc.). Add comments or special notes for customers. Family grouping for linked customer profiles. Centralized notification dashboard for admin use. Data encryption and secure access for selected devices only. Technology Preferences (Optional): Web Framework: Laravel, Django, or similar. Mobile Apps: F...
I'm in need of a CAD file for my school auditorium. This file is intended for use by a manufacturer for flooring and auditorium seats. Your tasks will include: - Utilizing detailed existing architectural plans to create the CAD file - Ensuring the CAD file includes exact dimensions and measurements - Incorporating the layout and positioning of seats into the CAD file Ideal candidates for this project should have: - Proficient skills in CAD software - Experience in creating CAD files for large scale projects - Ability to work with detailed architectural plans - Strong attention to detail to ensure all measurements are precise.
I need a Telegram bot to assist with my cryptocurrency trading. I'll provide the code, so your role will primarily involve building the bot according to my specifications. Key functionalities: - The bot should perform automated trading actions based on pre-defined parameters. Ideal skills include: - Proficiency in Python or the programming language used in the provided code. - Experience with Telegram bot development. Please note that the specifics of the trading strategies will be discussed further, as I have not settled on a particular approach yet.
...request for flyer design created for InspireHub Tutoring, a tutoring service dedicated to fostering a love for learning and supporting students' academic success. I have attached a brochure (poorly made by myself... however contains all the context and information such as my mission statement and pricing, to be included on the flyer). I have also created an AI generated flyer (please make sure you extract info from the brochure and not the AI flyer), to give you an idea of how I want it to look visually. The flyer should promote InspireHub Tutoring’s services, summer programs, and mission. - Summer Programs like the Summer Success Program and Summer Transition Program tailored for students transitioning between key educational milestones. - Pricing and Pack Deals f...
We need a slt file of 2 logos to print these on a 3D printer
I've recently installed Visual Studio Code on my macOS, and I'm encountering a 'visual code command not found' error. This issue surfaced right after the installation. I didn't add Visual Studio Code to my PATH during installation, and I believe this might be the root cause of the problem. I'm looking for an expert who can help troubleshoot and resolve this issue. Ideally, you should have: - Extensive experience with macOS - Proficient knowledge of Visual Studio Code - Skills in configuring system PATH variables - Ability to explain the solution in simple terms I appreciate a quick resolution to this problem, as I am eager to get started with my coding projects.
I'm in need of a skilled data scraper to extract structured data (like tables and lists) from a specific website. This is a one-time task and the extracted data should be delivered in an Excel format. Ideal Skills: - Proficient in web scraping tools and techniques - Experience in data extraction from structured formats - Competent in data cleaning and organization for Excel Please provide a brief proposal outlining your relevant experience and your approach to this task.
I need a professional developer to create a blog website using for the frontend, Node.js for the backend, and SQL for the database. The site should include comprehensive details about my interior company, such as: - About Us - Our Team - Our Latest Projects - Our Products All these sections should be dynamic and able to showcase real-time updates. The project needs to be completed within 2 days. Ideal skills for this project include: - Proficiency in , Node.js - Experience with SQL databases - Prior experience in creating dynamic websites - Ability to deliver within tight deadlines Please bid only if you can meet the deadline.
I have an Excel sheet with 1100 links to service-based websites. I need a freelancer to visit each link, extract the price listed in currency with symbol (e.g., $100), and input it back into the Excel sheet. Please don’t ask for excel It’s Like this link Key Requirements: - Attention to detail: It's crucial to accurately capture the prices. - Excel proficiency: Comfort with data entry into Excel is a must. - Time management: The task needs to be completed in a timely manner. Please note: - The prices are displayed in various formats and might have different representations across sites. - The project is straightforward, and if you thoroughly read the project brief, there should be little to no questions
I'm looking for a professional web scraper who can extract contact information from a specific business directory. The data needed includes: - Email addresses - Phone numbers - Social media profiles This data should be neatly organized into an Excel spreadsheet, ready for analysis and outreach. Ideal skills and experience for the job include: - Proficiency in web scraping tools and software - Familiarity with Excel and data organization - Experience with scraping business directories specifically - Attention to detail for accurate data collection Please provide examples of similar projects you've completed in your proposal.
...business leaders to align technical initiatives with business objectives. Skills & Qualifications Technical Skills • Strong coding expertise in backend technologies (Node.js, Python, or PHP). • Proficiency in API design, integration, and management (REST, GraphQL, webhooks). • Hands-on experience with system architecture design and cloud platforms (AWS, GCP, Azure). • Knowledge of databases (SQL, NoSQL) and containerization (Docker/Kubernetes). • Familiarity with ERP, WMS, and POS systems like Logic ERP, Unicommerce, etc. Project Management Skills • Proven experience with Agile/Scrum methodologies. • Proficiency in tools like Jira, Trello, or Asana for task and sprint management. Soft Skills • Excellent communication and ...
...of projects • Collaborate on-site with a cross-functional team that includes project managers, web designers, programmers and marketers to deliver solutions for external clients • Adhere to Bayshore Solutions Best Practices and administrative procedures • Record project time into project management software on a daily basis and meet billable time utilization expectations Requirements: • MS SQL 2012 or higher • Visual Studio 2015 • 4 + years of experience using ASP.NET MVC • C# • CSS, Javascript, and Jquery • Data access: Linq & Entity Framework • Familiarity with TFS • Experience with nopCommerce is preferred What we have for you: Bayshore Solutions is partnered with ADP and committed to providing our ...
I need a skilled CAD designer who can take my concept sketch for an idea we have and create detailed CAD files and possibly 2D drawings. Depending on the terms, this may also involve refining the design to make it more feasible for production. Ideal Skills and Experience: - Proficient in CAD software - Experience in designing consumer goods - Ability to translate sketches into technical files - Possible experience in design improvement for production
I'm in need of a skilled 3D modeler to create a detailed product model. The model needs to be high detail as it's intended for close-up views. Ideal Skills: example website is this we need to create this kind of wheels 3d ai model...
The application should be compatible with both Windows and macOS operating systems. It is intended to bypass the restrictions a lockdown browser imposes, enabling users to use applications such as AnyDesk, TeamViewer, and standard web browsers. The primary purpose of bypassing the lockdown browser is to allow for research and web browsing activities that would...browser imposes, enabling users to use applications such as AnyDesk, TeamViewer, and standard web browsers. The primary purpose of bypassing the lockdown browser is to allow for research and web browsing activities that would otherwise be limited during the lockdown session. The app will be used primarily for work-related tasks. The app should include advanced security measures for the registration code to avoid unauthorize...
I'm looking for a software developer who can create a MacOS application for me. This programme should convert ticket images stored in a d...and the destination for the output PDFs - Converts all ticket images in the specified folder into separate PDFs - Names each output PDF after the corresponding original image - Event tickets data to extract all details Ideal candidates for this project should be proficient in software development for MacOS and have a good understanding of PDF generation. Experience with image processing and file handling software would be an added advantage. Please ensure your bid reflects your capacity to deliver this project. The software should support all common image formats. The software should extract and include both text and images ...
i m looking expert developer who is good in excel n mysql database for more detail we will discuss over chat its just simple task
Title: Freelance Developer Needed for Booking Automation with Mentorship Opportunity Job Overview: I’m seeking a developer to help automate the booking process for a moving company. The third-party website where bookings are received does not provide API access, so the project will likely require using Selenium to extract client information (e.g., phone numbers). The goal is to set up an SMS system to manage booking details and confirmations. Additionally, I’d like to work closely with the person taking on this job to learn how to build the system. If you're open to mentoring and collaborating, I’d also explore ways to bring in more clients for future projects. Requirements: Expertise in Selenium or similar tools for web automation. Familiarity with SMS AP...
I need a QR code created that links to a digital version of my restaurant's menu. The code should incorporate the restaurant's logo and be delivered in PNG format. Features: - The QR code should direct customers to a page that allows them to rate their experience out of 5 and submit a review, all integrated into the menu page. Requirements: - Proficiency in QR code generation and digital menu creation - Skills in graphic design to incorporate the restaurant's logo into the QR code - Experience with creating interactive web pages desirable - Ability to deliver a final product that is user-friendly and visually appealing. i have the domain and the menu image
I'm in need of an experienced Python developer to create a text-based chatbot that interfaces with my SQL Server database, specifically for the healthcare domain. Key Requirements: - The chatbot should be able to interact with 2-3 different database tables. - It will primarily handle simple retrieval queries, so understanding of basic SQL is essential. - The chatbot needs to maintain context history during conversations to provide a more natural and dynamic user experience. Ideal Skills and Experience: - Proficiency in Python and SQL Server. - Proven experience in developing chatbots, particularly with context retention. - Familiarity with the healthcare industry will be a significant advantage. Please provide examples of similar projects you've worked ...
I'm seeking a seasoned full-stack developer to create a custom web application. The application should incorporate user authentication, data visualization, and e-commerce capabilities. A custom...e-commerce capabilities. A custom design is required, so experience with UI/UX is crucial. Key Responsibilities: - Develop a user-friendly web application from scratch - Implement robust user authentication - Design and integrate data visualization features - Incorporate e-commerce capabilities seamlessly - Create a unique, custom design for the UI Ideal Skills and Experience: - Proficient in SQL, Python, PHP - Extensive experience in web application development - Strong UI/UX skills - Previous experience with e-commerce web applications - Proven track record of delivering custom-de...
