Sql code extract xls file trabalhos

I'm seeking a data mining professional to assist in organizing and extracting data from .xlsx files into a provided .xls template. Key Responsibilities: - Extract and organize customer orders and information from .xlsx files. - Input data into a specified .xls template. Ideal Skills: - Proficient in data mining and data entry. - Experience with .xlsx and .xls files. - Attention to detail to ensure data is accurately recorded. The chosen candidate will mine the archives and put them in the template as "2023" and "2024"

I'm looking for an expert in Java to edit my code and help with deploying it to show responses from a REST API in a chatbox. The main focus will be on fetching data from the API. Ideal skills and experience for the job include: - Proficiency in Java programming - Extensive experience with REST API integration - Strong skills in code editing and troubleshooting - Experience with deploying code to a user interface - Understanding of chatbox implementation and integration

I need a skilled professional to convert a Photoshop file to CorelDRAW. The converted file will be used for designing a medium-sized product packaging box (approximately 20x20x20 cm). Key requirements: - Proficient in both Adobe Photoshop and CorelDRAW. - Experience with product packaging design. - Able to maintain design accuracy during the conversion process. - Understanding of the specifications of a medium-sized box. Your expertise will be pivotal in ensuring the design is suitable for product packaging. Its a LED bulb box. PSD file will be provided

...reports and declarations. Scope of Work Frontend Development Build an intuitive, client-friendly interface for uploading files and entering metadata. Include fields for key client information: Company Name BAID Facility Lists Reporting Period Contact Information Design a drag-and-drop file upload feature with clear instructions. Provide visual feedback (e.g., progress bars, confirmation messages) for uploaded files. Backend Development Implement secure file handling with data validation: Check for acceptable file formats (e.g., CSV, Excel, PDF). Validate data structure and flag incomplete or incorrect submissions. Parse and store uploaded files into a structured database. Develop a system to analyze data against EPAP themes and flag anomalies. Create an automated...

I need an expert in Google Sheets who can write scripts or use advanced formulas to extract data from a horizontal layout and transpose it vertically. Key Requirements: - Extract Numbers from specific cells - Format extracted data as currency - Handle additional text-based transformations in subsequent columns This task will be best explained over a call, as there are nuanced requirements beyond simple data extraction. Prior experience with Google Sheets, data manipulation and scripting is a must.

I am looking for a skilled Blazor developer with Postgres SQL experience to help us finish an existing application. This application will primarily serve content, and I need it to be user-friendly and efficient. Key Requirements: - Expertise in Blazor and Postgres SQL - Experience in developing mobile applications - Skills in implementing user authentication features The application must have robust user authentication to ensure content security and controlled access. Your experience in building secure, scalable, and high-performance applications will be critical to the success of this project. Please include examples of your past work that demonstrate your ability to deliver high-quality mobile applications in your bid.

Description: I am looking for a frontend tutor with strong knowledge of Node.js, module management, and experience using Visual Studio Code. The main goal is to receive support and guidance to resolve doubts during the creation of a frontend interface. Knowledge of the MEAN or MERN stack is a plus. Requirements: Proficiency in Node.js and its module ecosystem. Knowledge of frontend interface development. Experience working with Visual Studio Code. Ability to clearly explain concepts and provide effective guidance to resolve questions. Modality: Personalized support and doubt resolution. If you have the required experience and are willing to collaborate on a case-by-case basis, apply and tell me about your experience!

...* Proxy Server Integration: Rotate between 30 different proxy servers to simulate access from distinct geographic locations. * Web Scraping with Headless Chrome: Use Selenium WebDriver with headless Chrome to navigate to the URLs. Capture and save screenshots of each webpage. Text Recognition API Integration: Utilize a Text Recognition API (e.g., Tesseract, Google Vision, or AWS Textract) to extract visible text directly from the webpages. Store the extracted text in a structured format, associating it with the corresponding URL and geographic location for seamless analysis and organization. * Scheduling: Automate periodic checks on all URLs. * Data Storage: Save screenshots and extracted text to a server bucket with an organized folder structure (e.g., by geographic region, ...

...4. **Security:** - Implement security measures to protect user data and ensure secure transactions. 5. **Performance:** - Optimize the software for efficient performance, especially during peak usage times. 6. **Compatibility:** - Ensure compatibility with different operating systems and browsers. ### Technical Requirements: 1. **Web Scraping:** - Use web scraping techniques to extract information from the VFS Global website. 2. **Browser Automation:** - Implement browser automation to simulate user actions on the website. 3. **Data Encryption:** - Employ encryption mechanisms for secure data transmission and storage. 4. **Logging:** - Implement a logging system to track user actions and system activities. 5. **Error Handling:** - Include error-han...

I'm seeking an expert to boost the overall loading speed of my Squarespace site and compress my image and video files. Key Tasks: - Optimize the overall page load time. - Compress all images (JPEG, PNG, GIF) and videos on the site to enhance loading speed. Ideal Skills: - Proficiency with Squarespace. - Expertise in file compression techniques. - Knowledgeable in web speed optimization strategies. - Familiarity with various image formats. Your bid should reflect your experience with similar projects, and please provide examples of Squarespace sites you've optimized in the past. Thank you.

I am looking for a freelancer who can modify my dog file. The modifications will be focused primarily on the pier section. While the specific changes to the pier have not been determined yet, I am open to suggestions for enhancements. Ideal skills for this project include: - Proficiency in file modification software - Creative thinking for potential pier improvements - Attention to detail to ensure all modifications are accurate. If you're interested in this project, please provide examples of similar work you've done in the past.

...and iOS). The system should: Search for odds within a predefined range in the application interface. Place bets with a set amount, ensuring no bets are placed if there is already an open one. Continue repeating the process, searching for new odds and avoiding duplicate bets. General Considerations No API available: Automation will rely on techniques such as OCR, scraping, or similar methods to extract information directly from the app’s screen. Compatibility: The tool must work on both Android and iOS devices, operating in the background on the same mobile device. Access Restrictions: The development requires functional access to the mobile application, which may be subject to regional restrictions. Exclusive Use: The tool will not be published or commercialized in the ...

I'm looking for a proficient web scraper who can extract data from Instagram, Snapchat and TikTok, specifically from Stories, Reels and Posts. The insights I want to get include Comments, Engagement and Reach. Ideal skills and experience for the job: - Expertise in web scraping with a focus on social media platforms - Proficient in data analysis - Understanding of social media metrics - Familiarity with Instagram, Snapchat and TikTok - Experience in handling large datasets

I need an experienced professional to help me migrate my Spark messaging implementation from an old server to a new Windows server. Old server is running the instance on an openfire database and ideally we would like that migrated to ms sql on the new server. Old instance quit running a few days ago. Key Requirements: - Full access to the old server for data transfer - No additional configurations needed on the new server, just a straightforward move of the implementation Ideal Skills: - Expertise in Spark messaging system - Proficient in Windows server management - Data migration experience

I'm seeking a Kentic...experience in implementing an arbitrary file upload feature. This project will focus on the upload of documents, specifically HTML files. Key Requirements: - Implement a reliable file upload feature within Kentico CMS, tailored for HTML files. - Ensure a user-friendly interface for seamless document uploads. Ideal Skills and Experience: - Proven experience with Kentico CMS. - Prior work on implementing file upload features is a plus. - Strong understanding of HTML file structure and compatibility with CMS. - Ability to deliver a user-friendly, seamless file upload interface. Please note, this project does not require a drag-and-drop interface, file validation, or a multi-file upload function. It's purely ...

I need assistance with manual data entry. The data has to be extracted from video and organized into Excel spreadsheets. Ideal Skills: - Proficiency in Excel - Attention to detail - Experience with manual data entry - Ability to accurately extract data from PDF files

...automatically extract product data from AliExpress.com. The script will read product URLs and associated data from a MySQL database, scrape relevant information, and then update the database with the scraped results. The scraping process will be managed based on the `scraping_active` status and the `last_scrap_date` in the database. Project Goals: Develop a Python script that can efficiently and reliably scrape product data from AliExpress.com. The script should interact with a specified MySQL database to fetch product URLs and update the scraped data. The script should be able to handle potential errors during scraping (e.g., website changes, network issues). The script should be modular and maintainable for future updates. Specific Requirements: Data to Extract...

I'm looking for a skilled developer who can create a custom SQL Server Integration Services (SSIS) task in C#. This task will need to facilitate data exporting to a SQL compatible database. Key Requirements: - Create a specific SSIS task that can export data to a SQL compatible database - Use a specific .NET driver that I will provide - Implement the task in C# Ideal skills for this project: - Extensive experience with SSIS and SQL Server - Proficient in C# and .NET framework - Familiar with creating custom SSIS tasks - Experience in data exporting Please note, I will provide the specific .NET driver to be used for this project. Previous experience with similar tasks is highly advantageous. Bidder with the most relevant experience will be preferred.

...(VAPT) on our Laravel-based websites. The primary concern is safeguarding against Cross-Site Scripting (XSS) vulnerabilities and any other vulnerability our website might have. The expert will also be responsible for fixing identified security issues to make our sites hackproof. Key Responsibilities: - Conduct VAPT on all our websites - Identify and fix security vulnerabilities, primarily XSS, CSRF, SQL INjection, Network Hijacking. - Implement security best practices for future development - Provide both one-time assessment and ongoing security monitoring Ideal Skills and Experience: - Proven expertise in web application security - Extensive experience with Laravel - Proficiency in conducting VAPT - Excellent understanding and ability to fix XSS vulnerabilities - Capability to...

will fix the code of calculation in API

I'm in need of a diligent virtual assistant. Your first task will involve sorting through job candidate applications and compiling relevant information into a Google Sheets spreadsheet. You will need to extract and organize the following details: - Contact details - Education background - Work experience - Projects Done - CGPA - Availability (Start date and end date) - Educational Institution - Course The information should be organized alphabetically by candidate name. Ideal Skills: - Proficient in Google Sheets - Excellent attention to detail - Good organizational skills - Ability to maintain confidentiality - Previous experience as a virtual assistant or data entry professional preferred. There are about 230 candidates . Information for all these candidates need to be o...

I'm looking for a data scraping expert who can help me extract player statistics from various professional basketball sources. Ideal Skills: - Proficient in data scraping tools and techniques - Familiarity with basketball and its statistics - Ability to extract, clean and organize data Experience: - Previous work in sports data scraping - Proven track record of delivering accurate and comprehensive datasets

I need an experienced SQL developer to write a MySQL statement that will interrogate my Magento database. - Input: I will provide a text file containing a list of order numbers. - Output: The SQL query should export the customer name and email address associated with those order numbers to a standard CSV file. No custom formatting or delimiters needed, just a standard CSV. - Scope: The SQL query does not need to handle multiple Magento store views, just one. Ideal skills for this job include: - Proficiency in MySQL and SQL programming - Experience working with Magento databases - Ability to create SQL queries that export data to CSV files Please, only bid if you have the necessary skills and experience.

I need a skilled professional to extract text from a PDF file that is primarily structured in continuous paragraphs. The purpose of this task is for archiving, so accuracy and attention to detail are crucial.

I'm looking for a Tableau expert who can assist me with various tasks. I need help...who can assist me with various tasks. I need help with creating data visualizations, generating reports, and customizing dashboards. Key Details: - The primary data source for this project is an SQL database, so a strong understanding of SQL and its integration with Tableau is critical. - The visualizations will require advanced interactivity, including the use of custom scripts and complex actions. Ideal Skills and Experience: - Extensive experience with Tableau, particularly in data visualization creation, report generation, and dashboard customization. - Strong SQL skills and experience with SQL databases. - Ability to create advanced, interactive visualizations using...

...wanted to build a web that selling digital file download from this web. some basic function as bellow. sample web similar like this ( can create this web by ready template with shopping cart also acceptable ) the web should contain bellow function but not limited to 1. User Interface (Frontend) 1.1 Home Page Header: Logo Navigation menu (Home, About Us, Services, Pricing, Contact Us, Login/Sign Up) Main Content: Search bar for file lookup (by car/truck brand, ECU/PCM model, or error code). Featured files or promotions. Call-to-action buttons (e.g., "Browse Files", "Sign Up Now"). Footer: Quick links (Privacy Policy, Terms of Service, FAQ, Support). Social media links. Contact details. 1.2 File Library Page File...

...concepts and methodologies ●Code fixes and development of solutions; cross training as a developer within the project stack ●Teamwork in a cross-functional, high-performance international team ●Estimate, prioritize, plan and coordinate testing activities ●Design, develop and execute automation scripts using open source tools ●Identify, record, document thoroughly and track bugs ●Perform thorough regression testing when bugs are resolved ●Stay up-to-date with new testing tools and test strategies ●Familiarity with tools and libraries such as pytest,selenium. Profile Requirements ●3+ years of experience as a Data Tester or QA Engineer ●Strong knowledge of software QA methodologies, tools and processes ●Experience with Programming languages such as Python ●Experience with SQL...

Provide a dll (complete VS-Project with all sources) from the dll from the contest, with just all mangeged code in C#

I'm in the market for the Unity source code of the Tapper game. Budget is over 2k . but, code should be worked properly. Thanks.

I'm seeking a Research Assistant Virtual Assistant to help me locate commercial websites on Google. Your primary task will be to gather specific contact details from these sites, focusing on email addresses in particular. Key Responsibilities: - Conduct thorough searches for commercial websites on Google. - Extract email addresses from these sites. Ideal Skills: - Proficient in using Google for research purposes. - Strong attention to detail to ensure accurate data collection. - Previous experience as a Virtual Assistant or in a similar research role is preferre

I'm looking to build a comprehensive database that primarily focuses on player statistics for football. The main emphasis will be on tracking specific performance metrics, especially tackles and interceptions. Key Requirements: - Expertise in data managemen...be on tracking specific performance metrics, especially tackles and interceptions. Key Requirements: - Expertise in data management and database creation - Experience with sports statistics, specifically football - Ability to track and record performance metrics, with a focus on tackles and interceptions - Understanding of the importance of player in football Ideal Skills: - Proficiency in SQL or other database management software - Strong analytical skills - Attention to detail - Passion for football and understand...

I need assistance setting up a VPN network to enable remote access to files on my QNAP server and connecting to my Unifi equipment. Key Requirements: - Configure a VPN network connecting my Android phone to my home network. - Ensure secure and reliable access to both my Unifi equipment and QNAP server. The ideal freelancer for this project should have: - Proven experience with setting up VPN networks. - Familiarity with Unifi equipment and QNAP servers. - Expertise in Android device configurations.

...transaction data from .csv files to extract actionable insights regarding traders’ actions. Deliver the results in a .csv file, formatted according to the provided specifications. The choice of tools, technologies, or programming languages for script development is entirely up to you, as long as the results are accurate and meet the requirements. Provide clear and concise documentation explaining how to use the script. Required Skills: Strong proficiency in Rust and experience with the Anchor framework on the Solana blockchain. Expertise in React and TypeScript for frontend-related tasks. Excellent problem-solving skills and experience with data analysis. Ability to work independently and deliver high-quality results within deadlines. Deliverables: A .csv file...

I need an experienced database expert to compare my ORIGINAL and NEW Microsoft SQL databases. The primary goal is to update the NEW database with missing fields. Key Responsibilities: - Compare both databases thoroughly using SQL Server Management Studio (SSMS). - After identifying discrepancies, we will discuss what is missing before updating the NEW database. - Specific tables to be compared will be decided post initial comparison. Ideal Skills and Experience: - Extensive experience with Microsoft SQL databases. - Proficient in using SQL Server Management Studio (SSMS). - Strong analytical skills to identify missing fields. - Good communication skills for discussing updates.

I'm looking for an expert to convert my current Laravel PHP Modular apps to ASP.NET ZERO apps( + Angular App and MS SQL database) - Two Main apps. This project is time-sensitive, with a strict one-month deadline for full completion. Key Requirements: - Complete conversion of all existing functionalities from Laravel to ASP.NET. - Ensure the new ASP.NET app has identical functionality and API as the Laravel version, so existing front ends continue to operate as expected. - Retain features such as user authentication and authorization, reporting and analytics, and payment processing. - Maintain all current third-party integrations without alteration. Please note that this project does not involve adding new functionalities or significant enhancements to the app. The primary g...

I'm seeking a skilled 3D modeler who can convert an image into high-detail STL files suitable for 3D printing. The primary purpose of these models will be as tabletop miniatures. Ideal skills for this project include: - Proficiency in 3D modeling software - Experienced in creating STL files for 3D printing - Previous work with designing tabletop miniatures is a plus - Attention to detail to ensure high-quality, intricate models - Understanding of 3D printing process to design print-friendly models Your primary task will be to transform an image into a detailed 3D model that can be printed as a miniature. Please provide examples of your past work, particularly any STL files designed for miniatures.

I'm looking for a Cloud Priority Support Engineer. As the Cloud Priority Support Engineer, you will be main support technical expert in Acronis Cyber Protect Cloud. Be the person responsible for resolving the customers' technical incidents using your own...level troubleshooting with Procmon and Process Explorer) or Linux/UNIX professional (application and configuration management; RHCSA as a baseline; CLI power user) Virtualization professional (know how to deploy and manage Virtual Machines on VMware ESXi / Microsoft Hyper-V clusters) is a plus Business applications professional (should be familiar with one or more of the following: MS Exchange, MS SQL, MySQL, Oracle DB, Citrix XenApp, NTP servers) Passion for troubleshooting, ability to come up with efficient solutions f...

1. Message Capture (Text): Enable the selection of one or more messages (sent or received) within WhatsApp Web conversations. Extract and display the content of selected messages in a text format. Ensure compatibility with both individual and group messages (sent and received). Action Button: Add a contextual or floating button in the WhatsApp Web interface for selecting specific messages. Template Integration: Selected messages must be exported to a predefined template while preserving the content 2. Customizable Template: Provide predefined templates with various styles (e.g., professional, minimalist, elegant borders, etc.). Include an option for users to upload their own custom template: Supports common formats like images (JPG, PNG) or designs in HTML/CSS. Margin Conf...

Description: We are seeking a skilled web designer/developer with experience in WooCommerce to complete and translate our website bycasabona.es. The work involves: Data Transfer: Extract product information, images, and text from our main website casabona.cl. Input this content into , ensuring accuracy and consistency. Page Creation: Build and design static pages such as: About Us FAQs Warranty Policies Shipping and Returns Policies Contact Page Translation: Translate the WooCommerce theme and all pre-existing text into Spanish, including buttons, menus, and automated messages. Customization for Spain: Set up currency (EUR), tax (VAT), and shipping options for Spain, including options for mainland, Canary Islands, and Balearic Islands. Configure popular payment methods in

...Node.js, or Java, and server management. Experience parsing data from multiple API streams to enable an AI chatbot to produce desired outcomes and reports. Familiarity with building platforms where multiple API streams can be siloed and securely provisioned for access by authorized users only. Database Management: Designing and optimizing databases to handle large volumes of data. Experience with SQL and NoSQL databases (PostgreSQL, MongoDB, etc.). Automated Reporting: Generating automatic reports based on data collected by the tool. Ability to create interactive dashboards or automated templates. Data Security: Implementing security and privacy standards to protect sensitive information. Experience with data encryption and access management. Knowledge of data security protocol...

...access principles. - Implement Cloud KMS-based encryption at rest and set up secure data-in-transit configurations (TLS/HTTPS) for a few sample resources (e.g., Cloud Storage bucket, Cloud SQL instance). - Enable and validate key logging and monitoring services (Cloud Audit Logs, Cloud Logging, Cloud Monitoring) to ensure visibility into all activities, changes, and potential anomalies. - Demonstrate incident detection and response flows, integrating GCP Security Command Center, Pub/Sub alerts, and automated remediation (e.g., using Cloud Functions). - Set up basic backup and restore scenarios (Cloud SQL backups, Cloud Storage versioning) to showcase data resilience. - Document the resulting architecture, IAM policies, configuration snapshots, and a sample compli...

I'm looking for a developer to create a ChatGPT-like chatbot that can be deployed in a Docker container for us...Features: - The chatbot should be able to access our internal company database to fetch information. - It should be capable of answering general queries posed by employees. Data Interaction: - The data from our internal database is structured, primarily in SQL format. Therefore, experience with SQL databases and structured data is a must. - The chatbot should be able to interpret and pull relevant data from the database based on the queries received. Ideal Skills: - Experience developing chatbots or AI systems. - Proficient in Docker and SQL. - Ability to create user-friendly, efficient systems. - Understanding of internal company operations and poten...

I need an Excel expert to help me lock an Excel file to restrict any one to bypass my macro password. - The task involves securing an entire workbook with a combination of a strong password and digital signatures. - Ideal candidates should have extensive experience with Excel's security features and macros. - Knowledge of creating and applying digital signatures is crucial. - The goal is to ensure that only authorized individuals can access the macro, while keeping the rest of the workbook secure. sample files attached

I have a pre-written Python code that needs to be executed. The project is centered around automation. Ideal skills for this project include: - Proficiency in Python - Experience with automation tasks - Ability to troubleshoot and optimize existing code If you're a Python expert who can help me run this code, please reach out!

I need a professional iOS developer to test the source code of my iOS app. The individual should check whether the app works properly, and if there are errors, the individual should fix them. My budget for this task is $30. Key Requirements: - Testing the source code of my iOS app - Fixing any errors found during the testing process Ideal Skills: - Strong experience with iOS app development and testing - Proficient in troubleshooting and fixing source code errors - Good communication skills to provide updates and report on progress I am looking for someone who can ensure the app works properly and is ready for deployment.

Hi, I need the order as we chat.

I'm looking for a professional who can automatically extract data from the Livescore app. The information required includes scores and match details, which should be logged in an Excel sheet. Key Project Details: - Data to be extracted: Scores and match details - Frequency of extraction: Weekly Please note, the extraction must be done automatically, not manually. I would appreciate if you could send me an example of this extraction. Ideal skills and experience for the job includes: - Proficiency in data extraction and web scraping - Experience working with mobile applications - Advanced Excel skills - Ability to provide automated solutions

I'm seeking a professional graphic designer to make specific edits to my logo file. The purpose of these modifications is to prepare the logo for cutting with a Cricut machine. Key tasks include: - Removing a decal from the logo - Increasing the thickness of the text to ensure it's cuttable I would appreciate your expertise in determining the appropriate dimensions for the resized logo. The final deliverable should be the edited logo in a PNG format. Ideal skills for this job: - Proficiency in graphic design software - Experience with preparing files for Cricut - Strong understanding of logo design and modification

I'm looking for an expert in Azure and ELK stack to create an elastic dashboard for me. This dashboard should pull and systematically display logs from Azure SQL servers, Azure app services, and installed applications. The logs to be monitored include error logs, performance logs, and access logs. Key Features of the Dashboard: - Data visualization: It should present data using graphs and charts, tables and lists, and heatmaps. - User Access: The dashboard will primarily be accessed by Admins and Business Analysts. Ideal Skills: - Proficiency in Azure and ELK stack - Experience in creating data visualization dashboards - Understanding of various log types and their significance - Ability to create user-friendly interfaces. Please provide examples of similar projects you have...

No firms please. I'm looking for a web developer to create a Proof of Concept (POC) website for my business. The main purpose of the website is to share my business, have individual pages for a loan seeker to share their story & loan request, a link for individual investors to fund the loan through a button "FUND ME NOW!. The button would be a form for the investor to fill out their information and what pledge amount they want to invest. On the landing page would also be other potential loan requesters to fill out. This would flow into google sheets for me to manually process transactions & promissory notes. Key Features: - A landing page detailing the business w/ link for interested loan seekers & to explain to individual investors the concept. - Individual pages...