Sql code extract xls file jobs

I am looking for an expert web scraper to extract information from government websites regarding civil court cases. Key Requirements: - Scrape for specific civil case details, including: - Case number - Parties involved - Current case status - Judgment date - Amounts owed - Address info on up to 2 plaintiffs and 3 defendants - Deliver the data in a structured format. Ideal Skills: - Proficiency in web scraping tools and techniques - Experience with data extraction from judicial or government websites - Attention to detail and ability to deliver accurate data - Proficient in organizing and presenting data in a clear and understandable manner Please note that the data needs to be scraped only once.

I need a skilled professional to brand our Excel file with our company letterhead. In terms of skills and experience, I would prefer someone who has: - Proficiency in Excel and graphic design software. - Experience with corporate branding. The file we want to add our logo/letterhead on is attached.

If you are an ML and Python language expert and have experience in completing such projects, I urgently need your service to update an existing code in 10 hours. let's talk and discuss the project details.

I'm looking for someone to extract information from three websites. The task involves capturing details of approximately 400 individuals. The data to be collected includes their name, title, bio, email, and phone number, if available on the site. - URLS to extract - 4 number of websites and altogether approx 400 entries. - Format: The extracted data should be neatly organized in an Excel spreadsheet. - URLs: URLs are below. AND will supply another two to winning bidder. Ideal candidates should have excellent data extraction and Excel skills. Prior experience with web scraping is a plus. Please be prepared to ensure

...that allows users to upload a CSV file exported from their bank. Once imported, the website should: Parse the CSV file to extract transaction data (e.g., Date, Merchant, Amount). Automatically categorise transactions based on their merchant. Provide two views for the analysed data: Pay Cycle View: Group transactions and spending totals based on the user’s pay cycle. Monthly View: Group transactions and spending totals by calendar month. Key Requirements Custom-Built Website Expertise: The platform is built with HTML, CSS, and JavaScript. It’s not based on common CMS platforms like WordPress or Shopify, so a deep understanding of bespoke web development is necessary. Proficiency in Core Web Technologies: Expertise in HTML, CSS, JavaScript, a...

I am facing an issue while installing PHP code. The installation method is a PHP script and the error that is popping up is an installation error. I would appreciate someone with expert knowledge in PHP and installation processes to help troubleshoot and resolve the issue.

I need a PHP script that can extract emails from a business domain email account, as well as any free accounts like Gmail. The script should use SMTP information, such as POP3 and IMAP login credentials. The script needs to run through browser. The script will be on a VPS and use proxies in the backend. User will only need to input email account credentials in browser dashboard. - Development - Configurations and testing - Successful deployment Attached sample files descrive all needed setting requirements. Key Requirements: - Email filtering: The script should filter emails based on specific sender email. - Output: After the extraction is complete, I need the results to be downloaded in a .txt file. - Single Account: The script only needs to handle one account at a time. ...

I'm having trouble with an MOV video file that's not playing audio on my iOS mobile device. I need the audio to play at the same time the video is playing. Issues: - Video type: MOV - Playback device: iOS mobile device Skills and experience ideal for this job include: - Proficient understanding of MOV file format - Experience with iOS troubleshooting - Knowledge in audio/video synchronization issues - Familiarity with mobile device media playback troubleshooting

EASY 10 RATING... I'm seeking a skilled data scraper to extract contact details from a specific website. This project involves collecting comprehensive information from numerous business listings. Key Requirements: - Extract the business name, postal address, URL, description, and services offered from each listing. - Deliver the collected data in a CSV file. Ideal Skills: - Proficiency in web scraping tools and techniques. - Experience with data extraction and handling large datasets. - Attention to detail to ensure all relevant data is collected.

I'm in need of a professional adept at image scraping. The primary goal is to extract product images from specific retailer websites for my website. // Ideal Freelancer Skills: - Proficiency in image scraping - Familiarity with e-commerce and retail websites - Attention to detail, ensuring high-quality image extraction - Experience with web scraping tools and software // Job Task - 1117 - page urls supplied in spreadsheet - Image if found, saved, renamed, and name recorded in sheet - Each url can have multiple images, between 1 - 6 - Save main image and any secondary gallery images - Image file name to follow naming convention found in supplied spreadsheet example - ,, - Image must be large gallery full version - Image saved as jpg 100% compression

...transfer my current FileMaker system to SQL, primarily to enhance performance. Current File Maker Database is located in a local server. But for new database we are flexible about local or cloud. We want something to use for next 20 years. And to use Power BI tool to live report. We need the data entry forms as well to input data in SQL database. And we prefer those forms will be similar to the current File Maker data entry layouts. Key Issues: - Frequent crashes and errors with the current FileMaker setup, particularly affecting data input and retrieval. - Slow query response times impacting overall system performance. - Inconsistent data integrity issues due to frequent crashes, requiring regular manual corrections. Ideal Skills: - Proficiency in SQL...

Re-designing the rdl file to display/print batch of reports in a way that each invoice gets printed as a separate.

I'm looking for an expert to help me prepare a Vectric VCarve file for a JBass body using VCarve 12.01. The body will be made from Ash wood. I already have a design file that will be used. Key Requirements: - Generate a Vectric VCarve file for a JBass body - Include necessary toolpaths - Provide a simple guide for use

I need a developer to make a modification to the source code of the app by adding a feature and uploading the app to the Google Play Store. Here's where I bought the source code: App created By: Android Studio No licence key Required modifications: -Ability to add/delete companies under the "Offerwalls" category. -Change the referral system to 5% of earnings. -Minor text modification. -Add a new section named "Surveys" with the ability to add/delete companies in this category and connect their respective API/SDK. -Link the app to my accounts with the companies via API/SDK/POSTBACK. -Upload the app to Google Play.

perhaps I can change this project format. Have someone capture many images, someone that doesnt need to be expert at all, and he will provide the images for training in order to get to 95% accuracy with set up everything There is a poker app called 7xl, it contains texts that I want to extract. The training will be based on opening the software, capturing texts from there, and training the mode

I need a freelancer skilled in Adobe Illustrator to adjust the brightness of the background in my product label AI file. Key Requirements: - Adjust the background to be lighter while keeping the same color. - Experience with Adobe Illustrator is a must. - Attention to detail and ability to work with a complete file where all parts of the label are combined. Please note, the adjustment should only apply to the background, not to the product description or any other elements in the file.

Hours per week - Average 20 hours per week Length of project - 6 months (with possible extension) Looking for a proactive software engineer with experience in Python, SQL, and Generative AI. We are building a text-to-sql solution in AWS which leverages AWS services to extract data based on natural language. We need support in these main areas: 1. Building additional functionality in the application. 2. Improving responses from the LLM with refined prompt engineering. 3. Recommend areas of improvement over time which can be implemented by the same engineer. Communication will be done with one member of the team and through email or an agreed upon chat service. An AWS account will be provided as a development environment and Chat GPT workspace to assist with collabora...

I'm in need of a machine learning expert to develop a predictive analytics model using structured data from a database. The model will primarily be working with structured data. Key Requirements: - Proficient in machine learning techniques for predictive analytics. - Experienced in handling and p...predictive analytics model using structured data from a database. The model will primarily be working with structured data. Key Requirements: - Proficient in machine learning techniques for predictive analytics. - Experienced in handling and processing structured data. - Able to work with data sourced from a database. - Strong programming skills in Python, R or similar languages. - Familiar with SQL for database manipulation. Your expertise will greatly contribute to the success o...

I'm seeking a professional who can enhance the training of a Pytesseract OCR model. The task involves capturing images of printed text from software screenshots, creating training data, and improving the model's accuracy. Key Responsibilities: - Extract and capture images of printed text from software screenshots - Create data for training the OCR model - Train the model to increase its accuracy Ideal Skills: - Proficiency in using Pytesseract OCR - Experience in data extraction and model training - Strong understanding of image processing and machine learning Thank you for your interest in this project. The target accuracy rate is 95-100. The text primarily uses special or custom fonts.

I'm seeking a professional who can create a .pdf presentation and a 10-minute visualization file from a provided template (NASAs-LunaRecycle-Ph1-Digital-Twin-Submission-Template) focused on CATEGORY 2 (Plastics). The final deliverables should include 30 presentation slides and a comprehensive visualization file. - You will need to closely follow the template and the content guidelines for sections 1-6. - The calculations should be based on the file: NASAs-LunaRecycle-Phase-1-Rules-1.pdf. The style of the presentation should be corporate and professional as it is intended for NASA officials. - The primary goal of the presentation is to educate the audience about our project and its significance in the recycling challenge. - I appreciate creativity, attention t...

I'm looking for an expert in SQL Reporting Services (SSRS) to create a report that pulls from various tables and displays a dashboard when a row is expanded. The dashboard should be similar to a provided sample image. The report will show: - Data Usage - Line Status The ideal freelancer for this project should: - Have extensive experience with SSRS - Be able to create visually appealing and functional dashboards - Understand how to pull and display data from various SQL tables The dashboard should visually represent data using: - Graphs/Charts Please ensure you have the necessary skills and experience before bidding on this project. I look forward to your proposals.

I have an image file containing typed text that requires editing. The task involves changing names and dates within the document to ensure clarity. Ideal skills for the job include: - Proficiency in image editing software - Excellent attention to detail - Strong command of written English

I'm seeking an expert who can code a Flowgorithm file for me. The primary purpose of this Flowgorithm file is to solve a specific problem that revolves around decision-making logic. Key Requirements: - The Flowgorithm file should effectively process user inputs. - The file needs to encapsulate and solve a specific problem using decision-making logic. - The code must be clean and well-commented for educational purposes. Ideal Skills and Experience: - Proficiency in Flowgorithm and coding. - Strong understanding of decision-making logic. - Ability to create user-interactive programs. - Previous experience with educational coding demonstrations will be a plus.

I'm looking for a professional who can extract data from an Android application. Specific details about the type of data, usage format, and end-use are currently unspecified. Ideal candidates should have: - Proven experience with data extraction from Android applications. - Strong skills in handling and processing various data formats. - Proficiency in data analysis and migration processes.

...security. Integrate APIs with backend systems and external data sources. Collaborate with the Android development team to ensure seamless integration. Troubleshoot and resolve issues related to API functionality or performance. Requirements: Strong experience in building RESTful APIs using technologies such as Node.js, Python (Django/Flask), or PHP (Laravel). Proficiency in working with databases (SQL/NoSQL). Understanding of API authentication and security protocols (OAuth, JWT). Preferred Skills: Experience with real-time data delivery and caching mechanisms. Knowledge of microservices architecture. Prior experience working on business/news-related applications. Additional Information: Project Type: Freelance/Contract Timeline: To be discussed based on the scope of the proje...

I need a Python code that solves the stream function and vorticity using Control Volume Finite Element Method (CVFEM) for natural convection. I have the specific details including the physical domain, governing equations, and boundary conditions. Key Requirements: - The code needs to output both graphs and plots as well as numerical data. - Utilization of Matplotlib and NumPy for plotting and data handling is necessary. - The results produced by the code must match a set of reference results I have. Skills and Experience: - Proficiency in Python programming is essential. - Experience with Matplotlib and NumPy is required. - Prior knowledge of Control Volume Finite Element Method (CVFEM) is a plus. - Ability to write and understand complex physical and mathematical g...

I'm looking for a skilled developer proficient in ASP.NET, C#, and MS SQL Server ODBC to create a robust e-commerce web application. The primary users of this application will be customers, so a strong focus on user-friendly design and seamless functionality is essential. Key aspects of the project include: - Developing a comprehensive business management system within the e-commerce platform. - Implementing necessary features such as user authentication, data analytics dashboards, and inventory management. Ideal Skills and Experience: - Extensive experience with ASP.NET and C#. - Strong knowledge of MS SQL Server ODBC. - Proven track record in e-commerce web application development. - UX/UI design experience is a plus.

...upload risk records via an Excel file. Download: Export existing risk records into an Excel file. Upsert: Update or insert risk records based on uploaded Excel data. This feature aims to enhance efficiency and accuracy in handling large volumes of risk data, especially for policy administration and client management. Key Deliverables Custom Salesforce Button: A button integrated into the SIA system (on relevant screens like risk records or policy detail pages) to trigger the upload/download/upsert functionality. File Handling: Ability to handle Excel files (.xls, .xlsx) with predefined templates for smooth data mapping. Templates to include columns for mandatory fields, optional fields, and error handling. Upload Functionality: Validate the uploaded fi...

I have 5 simple tasks, i need some sql queries with indexes and a doc explaining how you did each task. Analytical details will be sent in docx via chat Deadline 29/11 Budget $30 USD

I need help with my MuseScore file. There are some note corrections and formatting changes that need to be made.

I need a QR code that, when scanned from either an iOS or Android phone camera, will add a reminder to the default calendar app after x days (90 days) from the date of the scan. I need it to be done without the need to install additional apps, maybe to link to a seperate website that contains a front end button and a simple back-end dahsboard is ok. but I dont want the user to go through installing additional app to their device. Key Features: - Compatibility: The QR code must support both iOS and Android platforms. - Reminder: The reminder should be set in the default calendar app of the device scanning the code. - Custom Message: The reminder should include a custom message that I will provide. Ideal Skills: - QR Code Generation - Mobile App Development (i...

I'm seeking a proficient developer to replace my current SQL database and modify the PHP Laravel code that interacts with it. Key tasks include: - Migrating data from an Excel sheet into the new SQL database. - Redesigning the database structure to accommodate the data. - Updating the existing PHP Laravel code to function with the new database structure. - You will do this for 8 pages Ideal candidates for this project should: - Possess extensive experience with MySQL and SQL database management. - Exhibit strong problem-solving skills to assess and modify unknown code segments. - Communicate effectively, explaining changes and updates in a clear manner. - Be patient and detail-oriented, ensuring every aspect is accounted for.

Join us on our mission to build the world’s leading impact investing platform for self-directed private investors. We’re looking for a hands-on, mission-driven senior engineer / acting CTO to join our core...open-minded team  • A chance to create a truly meaningful and scalable product OUR TECH STACK  • Front-end: Vue.js, Vuetify, Vuex • Back-end: PHP/Laravel, PostgreSQL, third-party integrations (e.g., data: Plaid, Snaptrade, Intrinio; payments: Stripe; mailing: Sendgrid) YOUR SKILLSET • Proficient in Vue.js  • Proficient in PHP • Fluent in at least one web framework, ideally Laravel • Proficiency in SQL • Experience with AWS • You prize reliability, simplicity, and robustness in building out systems &bull...

• Description The TWS API Demo App is here: and documentation is here: You will extract code to your own winform as follows: Connection Login Button: Login via the Interactive Brokers web API Logout Button: Disconnect from the IB server : It stores a list of instruments. The default is empty. Search Winform Search Button: The user can search, e.g. equities/bonds Search Grid: It displays the search results (contracts and specifications). With a tick on the grid in the first column and select OK, it will be added to the and the main Winform data grid. Main Winform Data grid: It loads the Default.txt. There is a cross in the first column, and hitting the cross

It is required a technical translation of an instruction manual, from English to Portuguese. An extract of the manual (10 pages on 57) is here enclosed for a clear and perfect evaluation Manual is provided in .docx or .odt file. Translation shall be offered in the same format and keeping the same layout (pictures, bolts, etc., etc.) Manual is actually composed by 57 pages and a total of 35.863 characters, spaces included Only sharp and definitive quotations will be accepted. Fast and generic quotations will be rejected Thank you to post your best offer and timing

I'm in need of a professional who can convert my QR code into an SVG vector file. The QR code will be printed on my business cards, so it needs to be precise and high-quality. Key Requirements: - Transform QR code into SVG format - Ensure vector is suitable for print The QR code doesn't need to include any additional information, just the code itself. A keen attention to detail and experience in graphic design and vector file creation is essential for this project.

I'm seeking a seasoned developer with expertise in code audits and performance tuning, specifically with a React.js and PHP tech stack. The primary focus of this project is to: - Evaluate the overall quality of the code: This includes examining the code for readability, maintainability, and adherence to best practices. -Evaluate architecture design for the code and database and provide recommendation . - Identify and rectify causes of high memory usage: My application is currently experiencing issues with excessive memory consumption, which needs to be diagnosed and resolved. The ideal candidate for this project would be someone with extensive experience in auditing code quality , architecture and optimizing performance in a React.js/PHP environme...

I'm seeking a mid-level .NET developer with a strong focus on the .NET Framework, to add new functionalities or fix the existing issues in the app - Developing and maintaining high-quality software solutions - Troubleshooting and debugging applications - Microsoft SQL query and stored procedures Skills and experience required: - Proficient in .NET Framework - Experience with web and desktop application development - Problem-solving and debugging abilities

I'm looking for a database engineer to design and develop a MS SQL database containing 3 tables. This database will primarily be storing sales data and transaction details. Key requirements: - Design and develop a database with 3 tables, approximately 8 fields per table based on a provided list. - Populate the tables with synthetic data post-design, based on provided guidance. - The final number of records should be determined in discussion with the database engineer, but will fall between 200 to 500 records. - Implement One-to-Many relationships between the tables. Ideal skills and experience for the job include: - Proficiency in MS SQL - Experience in database design and development - Skills in generating synthetic data - Understanding of One-to-Many relationships...

I need help refining my existing VBA code in Excel. The code is used to search for specific key words in longer text strings in one workbook, and to find corresponding terms in another workbook. It should return certain values if found. The main goal of this project is twofold: - Improve search accuracy - Enhance processing efficiency, given the large size of the database I prefer the use of a dictionary-based search for speeding up the process. there are 250,000 rows of data to search in one of the spreadsheets, so efficient logic required to minimize processing. Ideal skills for this project include: - Extensive experience with Excel VBA - Proficiency in implementing dictionary-based search methods - Strong understanding of search accuracy improvement techniques Please...

...funcionalidades de gerenciamento, execução programada e manual, envio de relatórios personalizados e registro de logs. O front-end será desenvolvido em Angular, o back-end em Node.js, e o banco de dados PostgreSQL será usado para armazenar os logs e dados relacionados. Requisitos Funcionais 1. Gerenciamento de Pontos de Auditoria (PA) 1.1. Cadastro de PA Campos obrigatórios: Nome do PA. Query SQL que será executada. Banco de dados onde a query será executada (Postgres ou BigQuery). Setor responsável pelo ponto. Instruções para corrigir erros encontrados. Horário de execução programada. Estado do PA (Ativo/Inativo). Responsáveis vinculados: Permitir a seleção de...

WordPress site migration from ipage to GoDaddy ** Getting Error 500, while importing the database, database file size around 175 MB ** Need PHP & Sql expert with good knowledge of Cpanel

Easy webscraping work Extract articlenumber, price and SKU code from an website.

...productivity. -- Basically, we have a data processing project which is going to be presented into our new website. We need a backend Python Developer whom can process data in our Google sheet then be dumped into SQL, eventually going to be presented into our new website. Therefore, the Python developer needs to be familiar with Google sheet API, Django framework API, and scrapping for our data processing. Data synchronization should occur in real-time. Our budget is $3/hour for maintaining the codes and website $5/fix rate for replicating or making a new code, but for a specific code if it's not that easy since you need to crawl from third party API etc, you can negotiate it. You can also negotiate after our website is finished and when we eventually we sta...

...create a duplicate of our production VM, which we will be using as a development and testing environment. Examples of other upcoming tasks are: - Resize the root partition and file system, so any increase to the storage disk will reflect correctly. - Revise version numbers of architecture, such as MySQL version, PHP version, Debian version, PHPMyAdmin version etc., and upgrade them when necessary. - Revise relationship between Xampp and Cloud SQL server communication, to identify 'breaking points' of number of users. - Revise accesses, both via IAM as well as Linux users. - PHPMyAdmin maintenance. - Setup detailed SQL logging, allowing us to freesearch all executed queries. - Cron job (Scheduler) consultation. Applicants need to have great knowledge of G...

I'm looking for a professional web developer with experience in creating web crawlers and databases. Key Responsibilities: - Develop a web crawler for 1-5 e-commerce sites - The crawler should extract product details, price changes, and availability - The data should be stored in an intermediary database that updates daily Ideal Skills and Experience: - Proven experience in web crawling and database creation - Familiarity with e-commerce sites - Ability to ensure the crawler operates smoothly and the database is accurate and up-to-date - Familiarty with python and woo commerce Please provide examples of similar projects you've completed. Crawl 3rd party supplier sites > Update database > make updates to our woo commerce site.

I need to setup my python code in Github. Currently using Colab grom google. This includes creating deployment scripts for the model.

I need immediate help with a quiz involving Python code. The quiz consists of fill-in-the-blank questions focused on programming concepts. Skills and experience ideal for this project: - Proficiency in Python - Strong understanding of programming concepts - Experience with solving quiz or exam questions - Ability to work under pressure and meet tight deadlines

...Custom website design and development - E-commerce solutions - Responsive web applications Hosting Services - Shared, VPS, and dedicated hosting - Cloud solutions (AWS, Azure) - Domain registration and management - MIS Development Tailored Management Information Systems - Reporting and analytics tools - Integration with existing systems - Database Development Database design and implementation - SQL and NoSQL database solutions - Data migration and management - Data Entry Services Accurate and efficient data entry - Data cleansing and validation - Document management solutions ICT Consultancy - IT strategy and planning - Technology assessments - Project management - IT Support Technical support and troubleshooting - Network setup and maintenance - Cybersecurity solutions Why...

I'm in need of a mid-level Azure ETL Developer to assist with my project. The ideal candidate should have hands-on experience with the following Azure ETL tools and services: - Azure Data Factory - Azure Synapse Analytics - Azure Databricks Additionally, the ETL process will need to handle a variety of data sources, including: - SQL Databases - NoSQL Databases - Cloud Storage Services The perfect freelancer for this job should have a solid understanding of these tools and services, as well as experience working with diverse data sources. I look forward to receiving your proposals.