Sql code extract xls filelavori
I'm looking for a professional to set up the backend code for my OVI Panel project. The backend needs to be coded in PHP and should interface seamlessly with an SQL database. Key Requirements: - Proficient in PHP for backend development - Extensive experience with SQL for database handling - Ability to set up user authentication, data storage and retrieval, and API integration functionalities Please note, specific functionality requirements were not specified but experience in handling the above tasks is crucial. Your ability to understand and implement these functions will be key to the success of this project.
I need a skilled freelancer to implement multiple im...app using Java and PHP. Key Requirements: - The uploaded files should be stored on a local server and cloud server. - Expertise in Java, PHP and Android Studio is a must. - Previous experience in implementing file upload features in mobile apps is preferred. - Larger files also can be uploaded. I am creating an android app using Java & PHP. In one page I am accepting the files from the user and enabling an option to upload single/multiple files from mobile. Here I tried to use Java and Volley on the front end and for the server side I am using PHP and MySQL database. The below code is working fine when we uploading below 500 KB size images/files. But when we trying to upload more than that it showing error and not...
Help needed in sql code via dataiku My issue is two-fold. Aussuming i have the following table CONTRACT ID CONTRACT NUMBER DATE STATUS A 4582 2024-09 ACTIVE A 4582 2024-08 ACTIVE A 4582 2024-07 CREATED B 8952 2023-11 ACTIVE B 8952 2023-10 CREATED C 8952 2024-10 ACTIVE C 8952 2024-09 ACTIVE C 8952 2024-08 CREATED D 4582 2023-09 TERMINATED D 4582 2023-08 ACTIVE D 4582 2023-07 CREATED They main key is built on two fields : CONTRACT ID & CONTRACT NUMBER What i need: I would like to get all lines that have an ACTIVE active as of 2024-09. And if the line for this date is not existing that having the last line with an ACTIVE status displayed as well. In other terms, the result of the query should be the following CONTRACT ID CONTRACT NUMBER DATE STATUS A 4582 2024-09 ACTIV...
... - Create efficient CRUD operations and workflows within the XAF framework. - Design and implement APIs to support application functionality. - Develop and optimize database solutions using SQL Server. - Build responsive and user-friendly UIs with HTML5, Bootstrap, and the Metronic theme. - Collaborate with cross-functional teams to gather requirements and deliver high-quality solutions. - Ensure application performance, security, and scalability. Required Skills and Qualifications: - Minimum 3 years of experience with DevExpress XAF. - Proficiency in ASP.NET Core development. - Strong knowledge of SQL Server and database design principles. - Hands-on experience in creating and consuming APIs. - Proficient in front-end development using HTML5, Bootstrap, and Metronic them...
...Quality Assurance: All backlinks must be from indexed domains. Links from unindexed domains or low-quality sites will not be counted. Delivery Timeline 24 Hours Maximum: The work must be completed, and the final report delivered within 24 hours of the project being awarded—not when you accept. This is a hard deadline. Reporting Requirements Detailed Report: Provide a complete list of backlinks in an XLS file, including: Domain URL DR score (verified through Ahrefs) Anchor text used Link placement URL Payment Terms Results-Based Payment: We will pay only after verifying all backlinks meet the criteria above. Any missing, non-compliant, or low-quality links will result in no payment. If you deliver 199 links instead of 50, payment will not be made. Disqualifications Pl...
I need assistance with my Excel file, which has become very heavy and disorganized. The primary use of this file is for data processing, with a specific focus on data entry tasks. Your main tasks would include: - Organizing the Excel file for clarity and efficiency - Streamlining the data entry process The ideal freelancer for this project should have extensive experience with Excel, particularly with handling heavy files and data entry. Skills in data cleaning, aggregation and visualization, while not entirely necessary, would be beneficial.
I'm seeking a skilled programmer to help develop an algorithmic trading code. This code should be capable of trading across various asset classes, specifically stocks, cryptocurrencies, and forex. Key Project Components: - The trading algorithm will primarily focus on implementing arbitrage strategies. - The algorithm must be versatile enough to operate in different markets (stocks, cryptocurrencies, and forex). - The goal is to identify price discrepancies across these markets and capitalize on them. Ideal Skills: - Proficiency in algorithmic trading code development. - Experience with arbitrage strategies. - Knowledge of trading in stocks, cryptocurrencies, and forex. Please provide examples of similar projects you've completed in your bid.
I'm looking for a professional who can set up a SPIDER benchmarking based on the Spider2 repo. The solution must include an API interface for running benchmarks, customizable database...databases, and configure test counts. Key Requirements: * Create an API interface for running benchmarks * Allow plug/unplug of databases with the ability to run benchmarks on custom data * Implement options for configuring test counts * Integrate a provided function for generating SQL queries from natural language into the testing process The selected freelancer should have experience with: * API development * Benchmarking software * Working with SQLite databases * Configuring test counts per the Git repository's README file Please refer to the Spider2 repo for installation, capa...
I'm seeking an expert in advanced Excel, particularly with Pivot Tables and Power Query, as well as advanced SQL skills, to analyze customer data and create detailed reports. Experience with big data is a plus. Ideal Skills and Experience: - Proficient in SQL for data manipulation and extraction - Advanced Excel skills, particularly with Pivot Tables and Power Query - Experience with big data analytics - Excellent report creation skills - Understanding of customer data patterns and trends - Proficiency with data visualization tools such as Tableau or Power BI
More details: Implementation of PRTG software start from scratch, managing the routing with Server and get unlimited access, also we can use in mobile application of IOS
Necesito alguien que me ayude con mi proyecto que cuenta con una parte front en vue una parte back en .net y una base de datos sql. Las partes de front back y base de datos ya deberían de funcionar correctamente. Necesito que estos corran a través de contenedores en docker para comprobar que el proyecto funciona correctamente
I need two vector files combined into one for product packaging. The design should adhere to a minimalistic style. The final output should be in AI (Adobe Illustrator) format. Ideal skills for this project include: - Proficiency in Adobe Illustrator - Experience with vector file manipulation - Understanding of minimalistic design principles - Prior experience in product packaging design Please only bid if you can deliver a professional quality result. also, the second file outline file has sources which can be rearranged
...Science. The target trainees are absolute beginners, so the trainer must be adept at simplifying complex concepts. The Trainee should explain all the topic that are required but not subject to the one mentioned below. The Trainer should also execute end to end hands on project with the trainee. Please refer to the attached Training topic requirement. The training should cover: - Python and R - SQL and Excel - Tableau and Power BI - Data Extracting, Transforming, and Loading (ETL) processes - Large data platforms Ideal candidates are those with extensive experience dealing with corporate clients and delivering projects. A proven track record of training success is a plus. Your ability to engage with beginners and make learning enjoyable and effective will be key. Th...
We are Zha Foundation, a charitable trust focused on promoting sustainability and digital literacy. We are seeking an experienced web and mobile app developer with expertise in low-code platforms to upgrade our existing website and expand it into a mobile application. Our current website serves as a platform for sustainability education and digital literacy. We aim to enhance its functionality and user experience using low-code tools for both web and mobile. Responsibilities Redesign and upgrade the existing website using low-code platforms (e.g., Webflow, Bubble, OutSystems, Mendix, etc.). Develop a mobile application that seamlessly integrates with the upgraded website. Ensure responsive, user-friendly designs optimized for both web and mobile. Integrate essential ...
I need a freelancer to extract data from specific sections of the GSIDC website. The data should be organized into separate sheets in an Excel file for each of the following categories: Contractors, Major consultants( Only category 2 &3), and Minor consultants. Data Fields Required: - Name - Phone Number - Email - Address - State - PIN Code - Company/Organization Name Ideal Skills: - Proficient in data entry and Excel - Attention to detail - Familiarity with data extraction from websites - Ability to organize data efficiently Please be sure to check the specified URLs for the data categories: , , and
>Registrati o accedi per visualizzare i dettagli.
...* 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, ...
I'm in need of an experienced Python developer to write a script for extract message from Venderbilt device. Key Requirements: - Python script to communicate with Venderbilt device Ideal Skills: - Have you done any integration with Venderbilt using FlexC Protocol - do you have experience on the socket, FlexC and bytes array The script should include real-time processing capabilities.
I'm in search of a skilled data scraper who can extract comprehensive real estate data from into an Excel spreadsheet. This project involves gathering information from all states and territories across Australia and includes a variety of property types such as residential, commercial and land. Data Fields Required: - Price - Address - Number of Bedrooms - Land Size - Bathrooms - And other relevant details Ideal Skills and Experience: - Proficiency in web scraping and data mining - Familiarity with Excel for data organization - Understanding of real estate terminology would be a plus - Prior experience with similar projects is preferred Please note, I do not require any additional property details beyond the basics.
I will give you my website, you must design me a folow chart of a feature section of the website
Requires experienced social networking code canyon app developer who have developed social networking apps using similar or same scripts I purchased these 2 scripts *17dv9tr*_gcl_au*MTI1ODEzNTA3Mi4xNzMzOTg0ODQw*_ga*MjQyMjgxMzgxLjE3MzM5ODQ4Mzk.*_ga_ZKBVC1X78F*MTczMzk4NDg0MC4xLjEuMTczMzk4NDg1NS40NS4wLjA.&_ga=2.109255941.1457101667.1733984839-242281381.1733984839 Work with original app developer to install both first. I have already paid developer US $300 to install it Suggest minor and major customisations so that is different from major
...in Python, R, SQL, Excel, Advanced Excel, Statistics, Probability, Tableau, and Power BI. The primary focus of the content will be tutorials and guides specifically designed for beginners. Your role would involve: - Creating engaging and easy-to-follow tutorials and guides - Teaching and explaining complex data science concepts in a simple way - Using various data science tools and languages in the tutorials - Covering necessary theoretical concepts such as Statistics and Probability - Creating high-quality video lectures explaining key concepts. - Hosting live Q&A sessions to address student questions. - Designing hands-on projects to apply theoretical concepts. - Developing interactive quizzes to reinforce learning. - Creating practical coding exercises in Python, R, and ...
...python-based environment. Knowledge in NoSQL technologies like MongoDB and relational databases like MS SQL Server and MySQL databases. Experience in working with Object Oriented concepts like Creating Classes, Inheritance, Constructors, Polymorphism, Overloading and Overriding. Knowledge in Model View Controller (MVC) frameworks like Django, Angular JS, Java Script, JQuery and Node.JS. Experience in Installation of various packages in python using pip and easy install. Knowledge in Python packages like Numpy, Pandas. Experienced with web-based application development using frameworks like Django and Flask . Actively participated in all phases of Software Development Life Cycle. Experience in writing SQL, Sub Queries, Stored Procedures, Triggers, Cursors and Functions. Exp...
...Quality Assurance: All backlinks must be from indexed domains. Links from unindexed domains or low-quality sites will not be counted. Delivery Timeline 24 Hours Maximum: The work must be completed, and the final report delivered within 24 hours of the project being awarded—not when you accept. This is a hard deadline. Reporting Requirements Detailed Report: Provide a complete list of backlinks in an XLS file, including: Domain URL DR score (verified through Ahrefs) Anchor text used Link placement URL Payment Terms Results-Based Payment: We will pay only after verifying all backlinks meet the criteria above. Any missing, non-compliant, or low-quality links will result in no payment. If you deliver 199 links instead of 200, payment will not be made. Disqualifications P...
I'm looking for a proficient data scraper who can help me extract valuable information from and LinkedIn. The primary aim is to fill up a spreadsheet with useful data for sales leads. Key Requirements: - Scraping of contact details and company information from the mentioned platforms. - Experience with LinkedIn and other contact scraping tools. - Ability to deliver data in a well-organized Google spreadsheet. I currently have access to and need this project completed as soon as possible. This project is crucial for my sales lead generation efforts. Please only apply if you have the necessary skills and experience. Thank you.
I need a Shopify expert to teach me how to deploy a custom landing page design on my store. I have the code ready (HTML, CSS, JavaScript) and I'm a beginner with Shopify's Liquid framework. The deployment process will require: - Integrating my HTML/CSS/JavaScript with Liquid: This is the area where I need the most assistance. - Ensuring Responsiveness: I will be testing the page on desktop and mobile browsers. - Maintaining Theme Alignment: Ensuring the new page aligns with my store's current theme. Your teaching style should be clear, step-by-step, and easy to follow. Ideally, you have previous experience in teaching or tutoring, particularly in the realm of Shopify. A portfolio of successful Shopify landing page deployment would be a plus. The guidance will be c...
I need a freelancer to help me extract project owners' names from a list of project names posted on the IGEM website. Key Tasks: - Process an Excel spreadsheet containing hundreds of project names. - Identify and extract the corresponding project team member' names (thousands) from a specific section of each project's page on the IGEM website. - Prepare a new excel spreadsheet with project name, team members and a like to their linkedin profile. Ideal skills for this project: - Experience with data processing and Excel. - Attention to detail to ensure accurate identification of project owners. - Ability to follow instructions and work independently. Link to the iGEM team pages (see for example year 2024): Deliver
I am seeking a seasoned software developer with extensive full stack experience to help me build a new web application. Key Responsibilities: - Adding new features to existing web application from scratch using .NET and React JS. - Implementing robust database integration features. - Designing and developing RESTful APIs for seamless front-end and back-end integration. Ideal Ski...Experience in Cypress testing for quality assurance. - Full stack development experience is a must. The primary task here is to develop a new web application with seamless database integration. Please share your previous work that aligns with these requirements. The project is expected to be completed within 6 months. Must have experience in - Typescript, React testing, Cypress testing, Asp .NET 6, SQL...
I need a professional to translate a picture of my kitchen into a Room Sketcher file. The project requires full detail including decor, as I have specific decor elements that I want included in the room. I can provide photos of these decor items. Ideal Skills and Experience: - Proficiency in Room Sketcher software - Attention to detail - Interior design understanding - Ability to interpret and translate images into design files - Experience with 3D rendering to create accurate and realistic visualizations. The final Room Sketcher file should be in the format: a native Room Sketcher file where modifications can be implemented. The decor and styling should reflect a modern theme throughout the sketch. No floor plan or specific measurements are available. The project ne...
I need a freelancer to convert a picture of my kitchen into a Room Sketcher file. This file should include all appliances, cabinets and countertops, plumbing fixtures, the centre island, and the breakfast table. - Ideal Skills: Proficiency in Room Sketcher - Experience: Previous projects involving similar tasks will be highly regarded. Please note, the Room Sketcher file does not need to contain exact measurements, just approximate dimensions will suffice. Please ensure to highlight modern cabinetry in the design. The cabinets and countertops should have a contemporary style with quartz as the primary material. The design should feature the following color scheme: existing colours. The Room Sketcher file should be in 3D format. The design should be detailed ...
...extensive code removal by my hosting provider. The changes to the file resulted in losing the ability to log in to the website, so to restore functionality, I reverted to a backup of the file. Now, I need a skilled professional to carefully review this file for any embedded malware while ensuring that the login function remains operational. Key Aspects of the Job: - Malicious code detection: Please scrutinize the file for any potential malware or harmful code. - Ensuring login functionality: It is critical that any necessary changes do not disrupt the website's login capability. Deliverable: - A clean file that maintains login functionality. I am not seeking any complex security measures or hardening at this time, just ...
I'm seeking a professional who can analyze and reverse engineer a Windows executable for the purpose of extracting internal process logic or workflows. Key Requirements: - Proficiency in both static and dynamic analysis tools to dissect the executable - Ability to identify and extract complex algorithms and data from the executable - Experience in reverse engineering and understanding Windows executables - Experience with IDA Pro and other disassemblers - Expertise in using debugging techniques to trace executable processes The ultimate goal of this project is to understand the hidden intricacies of the executable. The right freelancer for this job should be able to deliver a comprehensive breakdown of the internal processes of the executable.
...data sources to identify potential defects or issues. Key Responsibilities: - Monitor diverse data sources including: - Source code repositories - Live sensors data - SQL data - SharePoint files - Identify a range of potential issues such as: - Visual defects in images - Code conflicts and bugs - Data discrepancies and errors in files Reporting: - Generate detailed reports with visuals and data points Ideal Skills and Experience: - Strong background in AI and machine learning - Experience with quality control and inspection programs - Proficient in data analysis and interpretation - Knowledgeable in monitoring manufacturing line images and source code for quality control - Able to produce comprehensive and detailed reports Utilize pre-train...
Web server migration. Our company operates a Windows server running IIS, PHP, and hosts Crystal Reports that query a Microsoft SQL database. A new web server has been built by our server admin and the contents of the previous web server were copied over. Several of the prerequisite runtimes were also installed. We need a web developer with experience in these technologies to troubleshoot and resolve the following issues after the migration: - The authentication system loads but does not work. We assume this is a DB connection issue - Crystal reports are not loading. Aspx errors indicate ‘could not load file or assembly’ - Crystal reports components need to be updated In summary this migration was done by a server admin, and we need a developer to troubleshoot...
...a pitty so link do not count. I need to keep CLEAR keep your SCUM AWAY! So DR on must to be 80 or Above not below. Domain have below 80? You did not meet order objective thank you that you try! YOU CAN REQUEST ZERO=NULL PAYMENT. If you did not understand do not bid please. Your BOT BID? That's a pitty take resposibility for your BOT. We pay after we gather raport with results in XLS. We pay after we test every single link. So if you previously SCUMMED your customers it will not happened here. You will not get a payment. And you will gather DETAILED NEGATIVE REVIEW. Let's change SCUM on FREELANCER.COM into less SCUMMY enviroment. ALL or NOTHING. We need 100 LINKS and we pay for 100 LINKS if yiu deliver 99 LINKS you will not get payment. Let's REMOVE SCU...
This would be an 8-9 month project working full-time with a non-profit maintaining their web applications
I would like an Excel macro that updates my Master Household File with current revenue data I download from a proprietary system in a separate Excel sheet. I would like it to check for duplicate household names in both the New Revenue File and the Master Household File as this does not have to be unique and generate a separate text file to report it so I can manually clear duplicates. I would like to add new Excel rows if the Master Household File if there are new ones in the New Revenue File I would like it add update an X for a household revenue in Master Household File if it is in there but not in the New Revenue File Keep existing additional column data what for each unique row in Master Household File. There could be new ...
>Registrati o accedi per visualizzare i dettagli.
I'm looking for a batch file to transfer all CSV files from a specified folder to a designated SAS URI using AzCopy. Requirements: - The batch file should overwrite existing files at the destination. - No form of logging is required for the file transfer process. - The batch file does not need any error handling or retries. Ideal Skills: - Proficient in creating batch files. - Familiarity with AzCopy version 8.1.0 installed on windows server 2008 R2 - Experience with file transfer automation. I will provide the SAS URI, folder location for the csv files, and the folder location where is installed.
QRcreation---- The couple fills out a form on Web Novios- DONE A QRfrom the Frontend Web Guests is sent to their email in the language that the bride and groom have selected in the form. REVIEW The QRgenerates a dynamic URL of the Guest Web Frontend with the correct language. CHECK AS THERE ARE 3 LANGUAGES The QRis sent to the email indicated in the form once you have made the purchase. LACK BACKEND-This whole part is fundamentally for mobile and 90% is completed. Main Page When incorporating the frame, when the image is moved from the mobile, the frame blinks. Load new page to “Send Memory” When Sending a Memory, load a new page (this is already done) and generate an image + comment. LACK- Below, add a “Send another memory” button that returns the user ...
I'm in need of a data scraping expert to extract specific contact details from a directory. The project involves scraping contact names, email addresses, phone numbers, and postal addresses from a specified website. Ideal Skills and Experience: - Proficient in web scraping and data extraction - Familiarity with using scraping tools and software - Attention to detail to ensure all data is captured accurately - Ability to handle large datasets and deliver in a timely manner Please note that the data needs to be scraped from the following website: 8700 records then locate email addresses for the same Budget not more than $35 Will be awarded to the best balance of delivery speed and cost.
I created a CAD file for a design I have in mind. The problem is that the design includes a spring, so my CAD file needs to be designed for 3D printing, taking into account that the spring will be placed inside after printing. I will provide the worker with the job specifications, my CAD file, and the exact measurements of the spring. I would appretiate a product designer with experience
I'm in need of a proficient web scraper to extract product information from a specific website. The data should be compiled and delivered to me in an Excel/CSV file. This is a one-time project, so the ability to deliver comprehensive and clean data in a timely manner is essential. Ideal Skills: - Proficient in web scraping tools and software - Experience with data cleaning and organization - Familiarity with Excel/CSV file formatting - Strong attention to detail
Web scraping project: Extract data from website and organize into Excel.
...supported by scheduled cron jobs. It should not be to difficult. If any questions let me know. Full FTP and website access will be provided upon awarding the project. Part 1: Automating FTP File Handling Objective: Develop a script to automate the retrieval, renaming, and replacement of a CSV file from an FTP source. Requirements: Create a script that: Connects to a specified FTP source (plain ftp) and retrieves a CSV file named Artikelbestand - K14113.csv. Renames the file to while maintaining its original content. Replaces any existing file on our server with the newly downloaded version. Schedule the script to run every six hours using a cron job. Deliverables: Fully functional script installed on the ...
...Bitbucket code repositories. The goal is to demonstrate basic code analysis capabilities, including error detection and code quality suggestions, using an open-source AI model hosted on internal infrastructure. Objectives: ● Code Suggestions: Provide basic code improvement recommendations. ● Error Detection: Identify simple coding errors and inefficiencies. ● Private Hosting: Host the AI model on internal servers to ensure data security and control. The architecture for this minimal PoC consists of: 1. Bitbucket Server: Internal repository hosting. 2. Open-Source AI Model (e.g., CodeBERT or CodeT5): Deployed on private infrastructure for simple code analysis tasks. 3. CI/CD Integration (Optional): Automate code analysis using Bitbucket ...
... We are seeking a web application and "QR code software engineering" specialist to do a thorough website test and web code audit. Our existing medical application needs a QR software developer who can IMPROVE its QR code functionality. This means reviewing all code to be PERFECT in terms of generating, reading, and interpreting QR codes within software systems so that users can scan them with their devices to access medical information and take action. We need your help to enhance and fortify our QR code logins so that private and sensitive medical records can be securely authenticated. Your service is required to improve and strengthen our QR code logins for secure authentication of personal sensitive medical records. Improve our exis...
I'm seeking a skilled developer to integrate OpenAI's Chat GPT with the open-source web IDE, VS Code. This project involves generating code primarily in React and Rust, ensuring it adheres to both syntax and structural validation, as well as best practices. Key tasks will include: - Modifying the IDE to compile, test, and render/preview the generated code. - Implementing a system to display AI-generated code in the editor and render the output. - Controlling code generation to fit the structure of VS Code. This role does not require any AI development, as we will be utilizing OpenAI's API. The ideal candidate would have a strong background in web IDE modifications, React and Rust coding, and experience with OpenAI's API. Plea...
I am looking for an experienced developer with expertise in Azure Document Intelligence to assist with an invoice processing project. You should have hands-on experience using Azure Document Intelligence to extract, analyze, and automate data processing from invoices. Requirements: Strong knowledge of Azure Document Intelligence, especially for invoices. Experience in implementing and optimizing document intelligence solutions. Ability to integrate APIs and customize solutions for project needs. If you are the right person for the job, please share a brief description of your experience.
