Sql code extract xls fileJobs
I'm seeking a Python expert to help me understand and modify a Python file. The primary aim is to add a user authentication feature. Key tasks include: - Debugging the existing syntax errors in the file - Implementing a user authentication feature into the file - Optimizing the existing code to improve performance - Adding support for integration with a database Ideal candidates for this project should: - Have extensive experience with Python - Be proficient in troubleshooting syntax errors - Have prior experience implementing user authentication in Python files - Be able to explain their work in a simple and understandable way The project requires implementing password-based user authentication.
I have a file containing numbers. I have attached C# code to read the file. I need efficient code to read the file in Python and store the numbers in arrays. Please see the attachment.
...estate leases and pseudo-accounting functionalities. Current System Details: Database: Hosted on SQL Server 2000, consisting of 43 tables (primarily lookup and accessory tables). Application: Includes 50 forms and 15 reports. Core Application Features: * Real estate lease management: * Entities: landlords, tenants, contracts, periods, payments received. Pseudo-accounting system: * Journal book: Records detailed entries in pseudo double-entry format. * Ledger accounts: Groups, accounts, subaccounts, and vendors. Reports: * Monthly payment details for tenants. * Receipts for payments. * Journal book report. Objective: We aim to migrate the database to a cloud-hosted SQL Server (e.g., Azure SQL) and redesign or rebuild the application for modern, cloud-based use....
I'm looking for an expert who can extract geometric patterns from a photo for fabric design purposes. The patterns are primarily complementary in color scheme. Key requirements: - Proficiency in pattern recognition and extraction - Experience in fabric design - Understanding of geometric patterns and complementary color schemes Skills and experience: - Graphic design - Textile design - Analytical skills in recognizing and interpreting patterns
...of the document, add a "Submit" button. Ensure the "Submit" button directly uploads the completed PDF form to a specified cloud storage Automated Data Collection: Enable attendees to download the PDF, complete the test, and submit it directly from the document. Store the submitted forms in cloud storage for centralized access. Data Extraction to Excel: Extract the data from the uploaded PDFs into a structured format. Transfer the extracted data to a prebuilt Excel template with predefined fields. Automated Scoring in Excel: Compare the responses with predefined correct answers. Automate the scoring process and generate results within Excel. Key Requirements The PDF test should be dow...
I'm looking for a skilled professional to create data dashboards and reports using Microsoft Power BI The Purpose: The main aim of these dashboards is to monitor business performance. They should be designed to provide a clear, concise, and easy-to-understand overview of key metrics and business performance. Data Sources: The dashboards will need to connect to data from Microsoft SQL Server and pull data from 3 tables to access: - Trade Transactions Key Metrics: The dashboards should track the following KPIs: - Revenue Performance - Profit / Loss margin - Year and Quarter Revenue Comparison (The Actual Data Visualization and Reports requirements will be provided) Ideal Skills and Experience: - Proficiency in the development and design of data dashboards and reports. - Stro...
I'm seeking a professional illustrator to create 50 consistent cartoon characters in a modern/minimal, 3D style. Ideal Skills: - Proficient in modern/minimal cartoon illustration - Experience in creating character sets - Ability to maintain consistency across multiple designs - Strong understanding of 3D graphic design The characters will be used for various purposes, so they need to be versatile and appealing to a broad audience. Please include samples of your previous character designs in your bid.
I'm looking for a professional who can help me submit promo codes on websites. These codes are intended for individual customers to receive discounts. The primary purpose of this project is to: - Enable customers to use discou...can help me submit promo codes on websites. These codes are intended for individual customers to receive discounts. The primary purpose of this project is to: - Enable customers to use discount codes on websites. - Enhance marketing efforts through discounts, with the hopes of tracking their effectiveness. Ideal skills for this job would include: - Familiarity with website management and promo code submission processes. - Understanding of e-commerce and customer engagement strategies. - Experience with tracking marketing effectiveness based on discou...
...(experience with Solana’s Rust-based programs is a plus). • Experience with blockchain data indexing solutions such as The Graph, Anchor, or custom-built indexing frameworks. • Proven ability to work with blockchain nodes and APIs to extract and process data. • Familiarity with data pipelines and tools like Apache Kafka, Airflow, or AWS Glue. • Strong understanding of tokenomics, including token supply dynamics and holder calculations. • Experience with implementing token screening algorithms or filtering mechanisms. • Knowledge of database technologies, including SQL and NoSQL databases (e.g., Postgres, DynamoDB). • Excellent problem-solving skills and ability to work independently to meet deadlines. Preferred Qualification...
...menu etc... Automate Data Collection: Collect completed PDFs via email or a shared cloud location (e.g., OneDrive). Extract the form data into a structured format. Data Processing in Excel: Transfer the extracted data into a prebuilt Excel template with predefined fields. Automate scoring by comparing candidate responses with a list of correct answers. Automation & Tools: Suggest and implement the best tools Ensure scalability and ease of use for non-technical users. Deliverables A secure, fillable PDF forms. (Might need few forms with minor changes in each) A reliable workflow to extract and transfer data to Excel. Automated scoring in Excel based on predefined rules. Clear documentation ...
...skilled .NET developer to integrate an AI chat system, similar to ChatGPT, into my .NET application. This AI will interact through text-based conversations and will fetch data from a SQL server to provide insightful responses to user queries. Key Responsibilities: - Develop a text-based AI chat system. - Ensure the AI can fetch and process data from a SQL server. - Implement features for the AI to summarize data, perform calculations or analytics, and provide insights and recommendations. Ideal Skills and Experience: - Proficient in .NET development. - Experience with AI and NLM integration. - Strong knowledge of SQL server. - Excellent problem-solving skills to create insightful responses. - Previous work on data insights and reporting systems is a plus. The pri...
Vær venlig at Tilmelde dig eller Log ind for at se detaljer.
I'm seeking a developer to create a passport scanning application that utilizes the Mindee API... depending on your expertise and what you believe would work best. Key Requirements: - The app should be capable of scanning all types of passports. - It needs to extract all pertinent details from the passports. This includes personal information (name, date of birth, etc.), visa details, and travel history. - All extracted information should be compiled and shareable as an Excel file. Ideal Skills and Experience: - Proficient in app development with significant experience in both web and offline programs. - Familiarity with the Mindee API is a plus. - Excellent understanding of data extraction and Excel file formatting. - Prior experience with developin...
Bar code software design for customer with multiple types option
I'm in need of a Google Apps Script or similar programming language based application that can extract essential information from my Google Calendar. This pertains specifically to events related to rental apartment reservations. The data to be collected includes event Titles, Dates, and the number of Guests, all of which should be organized into a single Google Sheet. Key Requirements: - The script or application must sort data into corresponding columns in the Google Sheet. - The system should allow for manual updates. Ideal Skills for This Project: - Proficiency in Google Apps Script or a similar programming language. - Prior experience with integrating Google Sheets and Google Calendar. - Strong data organization and sorting skills.
Create a Model To extract Numbers that must work on Tampermonkey.
I need an experienced programmer to debug my Python and VB.Net code which is supposed to access a DLL written in C. This DLL was previously compatible with VB6. I've attached the DLL, a file exemple handled by the DLL and the relevant code for all languages. - **Specific Issues**: The code is throwing runtime errors when executed. - **Code Evaluation**: Both Python and VB.Net code are causing these runtime errors. - **Error Analysis**: The root cause of these runtime errors seems to be incorrect parameter passing. Ideal candidates for this project should have: - Proficient knowledge in Python and VB.Net - Experience working with DLLs and debugging runtime errors - Understanding of parameter passing in different programming languages Please...
I'm looking for a Windows-compatible software that can generate barcodes in the same format as a sample I will provide. The software should replicate the barcodes from the picture accurately. Ideal Skills and Experience: - Proficiency in...- Prior experience in creating barcode generation software - Attention to detail for precise barcode replication - Ability to incorporate visual examples into software functionality The software should save the generated barcodes as PNG files. The software should allow customizing the dimensions of the generated barcodes. Please include support for UPC barcode format. Please include support for Code 128. The software should include a feature for barcode validation to ensure accuracy. The software should have a user-friendly interface for i...
...users' personal information). SEO and Optimization: Optimize for search engines (SEO) and site speed. Required Skills: Full-Stack Web Development: Experience in frontend (HTML, CSS, JavaScript) and backend (PHP, Python, Node.js, or similar). API Integration: Experience integrating external APIs (preferably experience with cryptocurrency APIs such as Coinbase and Binance). Database: Experience with SQL databases to manage user data, predictions, and rankings. Web Security: Experience with secure login systems and data protection. Design: Skills in creating simple, clear, and modern user interfaces. SEO and Performance: Basic knowledge of optimizing websites for search engines and improving site performance. Important Notes: No specific details will be required until candida...
I'm looking for a proficient developer or a team for long term with extensive experience in Asp.Net Core, microservices & SQL Server. We are looking of company who can quote and work with us on competitive rates as we are working on india Projects. Team with high expectation and those who quote small values for discussion may please excuse. Exclusive cost effective guys in the band expected by us only may quote. We already have CSS done. We are looking for independent guys or a Team or a company who can deliver the solution as per our requirements. The ideal freelancer or team will: - Have a strong background in Asp.Net Core development. - Be well-versed in creating applications with microservices architecture. - Have a solid understanding of implementing user authenti...
I need help troubleshooting my Zamarin Android App code in Visual Studio. The project currently has some runtime errors, compiling errors, installation set up errors etc that are need to be identified and resolved. Ideal Skills: - Proficient in Zamarin and Android app development - Experienced with Visual Studio - Strong problem-solving skills to troubleshoot runtime errors - Able to modify code as needed Please note, this project is focused on identifying and fixing runtime errors compiling errors, installation set up errors etc.
I'm looking for a skilled React developer who can help me convert my existing HTML and JS WebSocket code into a React application using RTK Query. The primary goal of the WebSocket connection is to facilitate chat messaging within the app. Key Requirements: - Convert existing WebSocket code into a React application - Ensure the app is capable of handling chat messaging via WebSocket Ideal Skills: - Proficiency in React.js - Experience with RTK Query - Strong understanding of WebSocket connections - Prior experience with chat application development will be a plus Please note, I do not have a backend service set up for handling WebSocket connections, so if you have the capability to assist with that as well, it would be highly beneficial.
I need an expert in AutoCAD to tidy up my structural design CAD file. The goal is to make sure all line types, fonts, and notes are consistent throughout the file. Additionally, I need assistance with setting up pages for printing. Tasks: - Standardize line types, fonts, and notes across the CAD file - Prepare the CAD file for printing Ideal Skills: - Extensive experience with AutoCAD - Prior work with structural CAD files - Attention to detail - Good understanding of line types, fonts, and notes in CAD files - Experience with setting up CAD files for printing
I need a straightforward login page using .NET MVC, with Entity Framework and Microsoft SQL Server as the database. The login process should involve user ID and password verification against the database followed by Multi-Factor Authentication (MFA) via the Google Authenticator app. Key Requirements: - Create a simple and user-friendly login interface. - Implement MFA for enhanced security without complicating the user experience. - Use of .NET MVC, Entity Framework and Microsoft SQL Server for the entire project. Ideal Skills and Experience: - Proficient in .NET MVC and Entity Framework. - Experience with Microsoft SQL Server. - Knowledge of creating secure login systems with MFA. Please note that other security measures such as Captcha, IP whitelisting or accoun...
I'm in need of an advanced document AI system designed to extract mixed handwritten data (both text and numbers) from scanned documents and populate an Excel spreadsheet (.xlsx). Key Requirements: - Development of a document AI system capable of recognizing and processing mixed handwritten data (numerical and textual) - System should output processed data into an Excel file - Experience in AI/ML and OCR technologies is highly preferred - Previous work on similar data extraction projects will be an added advantage - Achieve a minimum accuracy rate of 95% for data extraction. Your understanding of AI and data processing, coupled with your ability to create user-friendly systems, will be key to the successful completion of this project. Please provide examples of your pr...
I'm seeking a skilled web scraper to extract text data from 4 specific telecom websites on a daily basis. The goal is to gather promotional offers from these sites. Deliverables: - Daily extraction of text data from 4 websites - Compilation of this data into a CSV file Ideal Skills and Experience: - Proficiency in web scraping techniques and tools - Prior experience with data extraction from promotional websites - Ability to deliver tasks consistently on a daily basis.
...techniques. 6. Implemented error handling mechanisms to manage and resolve any issues during the automation process. 7. Ability to validate and clean the data extracted to ensure accuracy and reliability. 8. Proficient in API integration to ensure seamless data flow between web scraping tool and email platform. ### Deliverables: - Automated script or workflow in RTILA/Zerowork to identify and extract competitor names relevant to each recipient. - Integration of this workflow with Instantly to replace placeholders in email templates dynamically. - A replicable setup for future campaigns across different clients. **Example Email Template:** _Subject:_ Te ayudo con esto? _Hola {{nombre_contacto}},_ He visto cómo {{competidor_1}} y {{competidor_2}} manejan la rot...
I need a freelancer to extract structured data from a public online guide related to family support policies. The guide is organised into multiple sections and subsections, each with detailed text content, tables, and occasional links. The extracted data should be compiled into a well-organised document or database that mirrors the structure of the original guide. Key requirements: - Accurately capture all text, headings, and subheadings. - Preserve formatting for tables and lists. - Deliver the data in a clean, editable Word document. - Include a method (Notification on changes) to regularly update the data if the guide is revised. The final output will be used for internal reference and summarisation purposes, not for redistribution or publication. Ideal candidates should have:...
Necesito conectar mi app a una base de sql server instalado en un vps de Azure
I'm in need of an AI solution that can efficiently extract data from various sources, including webpages and downloaded reports, and present a concise summary regarding a client's current digital exposure. - Data Sources: The AI will need to pull information from both webpages and downloaded reports. - Report Formats: The downloaded reports come in PDF, Excel, and Word Document formats. - Key Information: Primarily, I want the AI to focus on extracting digital exposure metrics. - Extract information from social media platforms like Facebook, Twitter, and LinkedIn. The ultimate goal is to create an easy-to-understand and pedagogical summary of the data that can be presented to the client. Currently, our reports are too lengthy and complex. The ideal candidate fo...
I have a 3-hour Twitch stream that I need transformed into a 15-minute engaging YouTube video. The primary focus of the video will be highlights and funny moments from the stream. Key Requirements: - Extract and compile the most entertaining segments of the stream into a cohesive and engaging video. - Add minimal and clean subtitles throughout the video. - Incorporate relaxed background music to enhance the viewing experience, while keeping the main objective music (crazy frog song) playing from my stream Ideal Skills: - Video editing - Subtitle syncing - Understanding of Twitch content and YouTube audience - Music selection and audio editing The background music should be calm and relaxing to enhance the viewing experience. The project should be completed within 1 week. You ca...
...efficient and responsive file-sharing network using React Native. - Implement a straightforward email and password user authentication system. - Integrate social media login options, specifically Facebook and Google, alongside standard email authentication. - Implement a reliable file upload system allowing users to share various file types. - Create an admin dashboard for monitoring user activity and managing content. - Develop advanced search and filter functionalities to easily find shared files. - Integrate real-time notifications to alert users of new downloads or shares. - Integrate with cloud storage providers like AWS or Google Cloud for file storage. - Enable users to create and manage their profiles, including avatars and bios. - Include a system to...
I need a proficient data extractor to gather specific contact details from a website and deliver them in a CSV format. Details to Extract - Email addresses - Phone numbers - Physical addresses - Company name - Occupational therapist name - Website URLs from the contact page Ideal Skills - Web scraping - Data entry - CSV file handling Experience - Prior experience in data extraction from websites is a plus. - It's from the following website - It is a list of Occupational therapists who specialize in Home Modifications & access for all of Australia
I need a proficient data scraper who can extract and compile information from public websites into Google Sheets. Key Responsibilities: - Scrape data from various public domains on the web. - Organize and integrate the collected data into Google Sheets. Ideal Skills: - Proficiency in web scraping tools and techniques. - Experience with Google Sheets, particularly in data integration and management. - Familiarity with handling data from e-commerce sites, social media platforms, and news websites.
...skilled freelance consultant for application development of a C# web application on the AWS cloud platform. Key Requirements: - Extensive experience in C# and web application development - Proficient in AWS services and deployment strategies - Capable of creating efficient, robust and scalable applications - Experience in system integration and data migration would be a plus - Strong skills in SQL and NoSQL databases - Experience with unit testing frameworks and methodology - Experience implementing CI/CD pipelines - Familiarity with designing and consuming RESTful APIs Best practices for scalability, security, and performance optimization The ideal candidate should have hands-on experience with similar projects and be available for a detailed consultation to help optimize an...
I have a collection of over 500 images in CorelDRAW format. These images contain logos, and I need an expert graphic designer to extract the logos and design them in a consistent format. The goal is to ensure all logos have a uniform design style and are prepared in a specific format suitable for my website. Consistency in size, style, and alignment is crucial for this project. If you are skilled in CorelDRAW and logo design, and can deliver high-quality, consistent logos, please submit your proposal. Attention to detail is essential as these logos will represent my brand online. Deliverables: Logos extracted from provided CorelDRAW files. Each logo designed in the specified format with a consistent appearance. Final files delivered Size 300x200 and formats - JPG Skills Require...
Se trata de una PWA turistica especialmente de contenidos desarrollada sin codigos en el constructor de Apps conocido como GoodBarber. En una primera etapa incluiria los 25 atractivos mas iconicos del patrimonio arquitectonico y monumental de la ciudad de Paris, Francia. La plataforma incuye todas las herramientas necesarias para incluir mapas de sectores de una ciudad para establecer la exacta ubicacion de cada sitio y sus vias de acceso. La plataforma GoodBarber dispone de su propia AI para los textos. Cuento con mas de 40 acuarelas de artista que me interesa destacar en la PWA porque las ofrezco para su venta digital en mi tienda en Shopify. Estoy disponible para cualquier pregunta sobre este proyecto.
I'm seeking assistance in configuring an automation on Make.com. I have a couple of Google Sheets with a column of URLs that I want to scrape for email addresses and potentially the names of business owners or managers. Key tasks include: - Helping me connect Google Sheets to - Setting up the built-in web scraping tools of to extract data from the URLs - Configuring the automation to insert the scraped data back into the original Google Sheets I am new to , so I would appreciate your help in configuring this automation so I can run it in my account. Ideally, you have experience in web scraping, Google Sheets and Make.com.
We are seeking an experienced Python developer to fetch live data from Upstox API and feed into: 1. Amibroker - live streaming data as well as intraday backfill 2. SQL Database hosted on AWS - historical data KEY REQUIREMENTS: - Proficiency in Python, Amibroker, SQL, AWS, WebSocket APIs. - Familiarity with Amibroker and its data ingestion process. SCOPE - Create Python script to fetch tick by tick and historical data from Upstox API (Websocket) for all active segments (Already hardcoded in Python with resources, will be made available) - Build SQL database on AWS - Create script to interact wit Amibroker to ingest live feed into Amibroker for charting (Already hardcoded in Python with resources, will be made available) - Create user friendly GUI (Clien...
What I need is: graphs/analysis/Comparison of energy consumption of different lab equipment, combined with an extrapolation of total co2e footprint using austrian standard co2 values for energy production. data can be provided as xls.
I need a skilled JavaScript developer to modify a piece of code in preparation for creating logic rules that will process numerical input and modify the output. The final result should be in plain text format. Key Requirements: - Proficient in JavaScript - Experience with code modification - Understanding of logic rule creation - Ability to process numerical input - Capable of outputting in plain text The project involves following three preparatory steps which I have detailed in an attached Excel file. Please review the Excel file prior to bidding to ensure you can meet the requirements.
I'm looking for a talented AI expert to develop a script that generates short summaries of breaking news based on a provided link. Key Requirements: - The AI script should focus exclusively on breaking news. - Output should be concise, in the form of a short summary. - The script should autonomously use relevant terms, without needing specified keywords or phrases. Ideal Skills: - Proficiency in AI and machine learning, particularly in natural language processing. - Experience with news content and understanding of its unique language and structure. - Ability to create concise, coherent and engaging content. Please note, the goal is to create a script that can autonomously generate news summaries from a variety of sources. Previous experience in a similar project would be greatly...
...developer to create new APIs and update old ones. The new APIs will primarily focus on supporting data retrieval from various databases. Key Tasks: - Develop new APIs using .NET, specifically designed for data retrieval. - Update existing APIs with the new API repository. Technical Requirements: - Proficient in .NET with proven experience in API development. - Strong background in working with SQL Server Management Studio (SSMS) databases. - Prior experience in updating and maintaining old APIs. - Ability to connect to and retrieve data from various databases. - Experience working with Entity Framework for database transactions. - Familiar with OData in .Net 8.0. Ideal Candidate: - A detail-oriented developer with a knack for problem-solving. - Excellent understanding of datab...
Seasonal Pattern Analysis in AmiBroker I'm seeking an experienced AFL (AmiBroker Formula Language) programmer to develop custom code for generating explorations and charts that describe seasonal patterns in stock prices. I already have and can provide starting AFL code that generates charts and exploration for average all years and by presidential year. My timeline is flexible, and I’m open to changing the request if some features are overly complex or will require significant work/cost. Exploration Outputs The AFL code should generate the following exploration outputs: 1. Return (close/close % price change) 2. Return/Standard Deviation (using SD over last X days, set as parameter) These outputs should be calculated as average for all years of data avail...
I'm seeking a skilled developer to create code for real-time stock market analysis. The code needs to be integrated with financial news APIs and stock exchange APIs for comprehensive, real-time investment insights. Key Requirements: - Develop real-time data analysis code for the stock market - Integration with financial news APIs - Integration with stock exchange APIs Ideal Skills: - Proficiency in programming languages like Python, R, or Java - Experience with stock market data analysis - Familiarity with API integration - Strong understanding of financial news impact on stock prices Please provide examples of similar projects you've completed in your proposal. Thank you!
Job Title: Data Cleaning and Consolidation Specialist Job Description: We are seeking a skilled data specialist to clean, deduplicate, and consolidate two datasets unified file with approximately 18,000 unique entries. The task involves address cleaning and validation, ensuring all data is properly formatted and duplicates are removed. Key Responsibilities: Clean and standardize address fields (e.g., remove pin codes, extract city/state names). Identify and remove duplicate entries across datasets. Merge the two datasets into a single file, ensuring accuracy and consistency. Perform quality checks to confirm no duplicates or formatting errors remain. Requirements: Proven experience with large datasets and tools like Excel, Google Sheets, or Python. Strong attention to...
I'm looking for a Telegram bot that can extract printed text from photos and post it in a specific order as plain text. The photos will be sent to a dedicated chat, so the bot needs to be able to monitor this chat and process the images accordingly. Ideal skills and experience for the job include: - Proficiency in Python or JavaScript, the primary languages for Telegram bot development. - Experience with Optical Character Recognition (OCR) technology to accurately extract printed text from photos. - Understanding of Telegram's Bot API for smooth interaction with the chat. - Ability to implement orderly posting of the extracted text. The bot only needs to support text extraction in one language. The bot should extract text in English. The bot should post th...
...and secure transactions. Collaborate with the restaurant management team to refine the system based on feedback. Provide technical support and updates post-launch. Qualifications: Proficiency in web development languages (HTML, CSS, JavaScript). Experience with back-end frameworks (Node.js, Django, etc.). Familiarity with database management systems (MySQL, MongoDB, etc.). Knowledge of QR code generation and scanning technologies. Experience in payment gateway integration is a plus. Strong problem-solving and communication skills. Benefits: Opportunity to work on an exciting project from the ground up. Flexible working hours. Competitive compensation Potential for long-term collaboration on future projects....
Project Description: We are seeking an experienced data analyst or data scientist to extract detailed historical data for the cryptocurrencies Litecoin (LTC), Ripple (XRP), and Ethereum (ETH). The data should cover the entire period from the inception of each currency to the present day and be delivered in a well-structured CSV format. Specific Data Requirements: 1-minute interval charts for LTC, XRP, and ETH from their inception to the current date. Essential data fields required: Opening Price (Open), Highest Price (High), Lowest Price (Low), and Closing Price (Close), Trading Volume (Volume). Desirable but optional data fields include Number of Trades and Relative Strength Index (RSI) for each interval if available. Qualifications: Proven experience in extracting and processi...
