Sql server extract data csv jobs
...both my sales and customer data. The report will include the following data fields: - Date - Customer name - Product name - Sales quantity - Sales amount - Other additional fields depending on the specific requirements at a given time. Notably, this report needs to be sent to a FTP server daily in CSV format. Ideal Skills: - Expertise in data analysis and report creation, specifically targeting sales and customer data. - Strong knowledge of CSV formatting and transferring files to a FTP server. - Ability to accurately arrange data fields in the specified format. - Proficient in creating actionable and easy-to-understand reports from complex data. Experience: Prior experience in similar projects is a significant...
I'm seeking a Python expert to extract the text data from various eCommerce websites. You'll apply your Python prowess to develop web scraping techniques that effectively capture the desired text. Key Responsibilities: - Web scraping - Text data extraction from eCommerce websites Ideal Skills: - Proficient in Python - Proficiency in web scraping - Experience with data extraction from eCommerce websites Your innovative strategies and attention to detail will be fundamental to meeting my goal of extracting text data successfully. With your help, we will be able to leverage valuable data from eCommerce platforms to make informed business decisions.
As a client, I require a sophisticated web app, built to extract MRZ (Machine Readable Zone) from passports and seamlessly integrate this data with our odoo ERP system for efficient customer record management. Key Features: - MRZ Reading: Utilising OCR and AI technologies, the app should be efficient in reading and deciphering MRZ data from passports. A minimum accuracy level for preliminary data collection is anticipated, intending to refine and perfect data manually. - Odoo ERP Integration: The extracted MRZ data should be directly transferred to our odoo ERP, updating customer records, ensuring overall seamless data management. Ideal Skills: - Proficient with OCR and AI technologies - Experience with ID and Passport reading appli...
I am going to build a AI program on a website. Can be a simple app used to rank/give feedback for CVs to recruiters. When job candidates apply for a job and hand in their CVs, it will automatically extract information and choose qualified ones. Goal: Lead magnet, Good Demo for Calls Function: Evaluate, rank CVs(The more they can bulk upload the better, if this is difficult no need to waste time on it) Here is an example link: Please apply with certain solutions and tools you are going to use at the end of your bid..
HELLO :) We are already running on Espcode, that can pull/change modbus on solar inverters(mostly growatt) We need to expand this code, and make it able to take energy (Spot prices) into relation. We use ESP32 1. Be better grapchal looking (Web interface) 2. Access to the energy Prices (Live spot prices) 3. Be able to choose between DK1 or DK2 (This is price regions in denmark) (Also we need to expand to other countries later on) 4. Add tax/vat/tarifs 5. Code needs to be stand alone, meaning it should be able to run without home assistant, but also should be compatible with home assistant. 5. Allow Simple automations, like: Stop exporting electricity if spot price falls below X. or like Start charing battery if prices go lower than X Potentially we i will need you to work with us on ...
Hello, I am currently seeking assistance from a skilled individual or team who specializes in image editing and manipulation. The task involves a specific image from which I need to extract and isolate the background, removing the characters present in the foreground while retaining the original background in its entirety. REQUIRIMENTS: Image Editing: The main objective is to remove two characters from the foreground, leaving the background intact. This process should not alter the original composition or quality of the background. Image Dimensions: The final image must maintain its original size of 864 x 1536 pixels. Quality Assurance: The finished background should be free of artifacts and editing marks, ensuring it appears as natural and untouched as possible. This project ...
I have a VBScript page that uses Classic ASP to query an SQL database with over 4000 entries. This is now causing loading issue due to the number of entries loaded into the web page. I require this page to be converted to JSON and save as a text file. The saved text file should then be loaded using AJAX and using JavaScript formatted for using Data Tables. I am also open to other ways that this can be achieved BUT DataTables is a MUST as all entries need to be loaded on the page and it MUST be written in VBScript. The current web page formatting and design details MUST remain the same. A copy of the page will be sent to the ideal candidate. No other data will be supplied. I'm looking for someone that has very good understanding of VBScript, Classic ASP, JSON an...
...potential networking opportunities LinkedIn has to offer. Tasks to be carried out: * Develop a specialized software that focuses on LinkedIn. * This software should be able to extract key lead generation data based on search queries - specified as contact information, including, name, job title, company, email address (if available) and phone number (if available). Requirements: * Proven experience in creating lead generation software. * An understanding of LinkedIn's data structure. I require the data to be stored efficiently for easy access and interpretation. Open to suggestions - such as a database, a CSV file, a CRM system - on the best storage method from experienced freelancers. Interested developers should be ready to provide a thor...
I have a set of digital PDF files, each containing complex data in both numerical and textual formats, neatly organized in tables. I'm looking to convert these into clean, precise CSV files. Ideal Candidate: - Proficiency in data conversion from PDF to CSV - Exceptional precision in handling both textual and numerical data - Knowledgeable in structural recognition of data tables in PDF Task Requirements: - Convert tables from digital PDF to CSV - Ensure the accurate transformation of all data points - Preserve data consistency, particularly with numerical and textual data elements - Attention to detail is a must to prevent errors while converting into CSV. Please place a bid only if you're comforta...
My email campaign has outgrown the limitations set by Gmail and now, I require a technically skilled professional to create an efficient SMTP server. This will allow me to send more than 1000 emails per day, with content predominantly revolving around recruitment. Essential Skills: - In-depth understanding of SMTP servers and email protocols - Proven Experience with high-volume email campaign management - Familiarity with potential blacklisting issues and their solutions - Delivering scalable and efficient solutions While tracking features like open rates or click-through rates are not currently required, the system should be versatile enough for potential add-ons in the future.
As a rapidly growing business, we are now experiencing some difficulties with our large MS SQL database system. The system comprises of multiple databases, which includes complex relationships and transactions. The primary task we need to carry out is Query Optimization and Performance Tuning. Our large infrastructure could use the expertise of a professional who can recognize inefficiencies and have them fixed. The ideal candidate will have: - Extensive experience with MS SQL , especially Stored Procedure - Proven expertise in query optimization and performance tuning - Experience with large databases, managing complex relationships and transactions. Your aim will be to help us optimize our system and ensure smoother operation of our database infrastructure. Looking...
I'm seeking an expert familiar with Google Cloud Hosting and PHP for server configuration, and to make changes to the Godaddy domain DNS, with support to have a sub-domain. I have a functioning website built on PHP that requires hosting on Google Cloud. The selected candidate will handle server settings configuration to ensure my website runs seamlessly. Ideal skills and experience: - Proficiency in PHP; - Demonstrated knowledge of Google Cloud Hosting; - Previous experience in server configuration.
I'm requiring a proficient and experienced freelancer who possesses expertise in data crawling to extract specific elements from various e-commerce websites. Your prime objective will be to efficiently retrieve the following data: - Product titles - Product descriptions - Product prices The website to crawl from is , look at attachment to understand what I need. The ideal candidate for this job should have: - Acute knowledge of e-commerce platforms and their structure - Experience with web scraping tools and methodologies - Ability to collate, organize and present data in a comprehensible format - A strong respect for deadlines and project goals Your role will be instrumental in boosting my understanding of e-commerce market trends, so a beneficial, p...
I'm in need of a skilled web scraper to extract text content and PDF documents from https://www.dell.com/en-us/dt/corporate/social-impact/advancing-sustainability/climate-action/product-carbon-footprints.htm#scroll=off&tab0=1 We are creating a database of all of the carbon offset metrics to be stored. there are 6 categories on that page: 1. Desktops 2. Laptops 3. Monitors 4. Client peripherals 5. Servers 6. Storage I want each of those category's products scraped and I want to save the pdf along with parse the PDF so the excel document has the following information Category Series Model Carbon Footprint Carbon Footprint Mean 95th Percentile Unit of Measure Use % Transportation Percentage EOL Percentage Manufacturing Percentage Then there is a break down of what...
I am looking for a python programmer who can develop python code to interface with some hardware data acqusition and basic signal processing. Phidgets Device: Basic Functionality: 1. GUI for User 2. Be able to read raw data from 1-4 channels from bridge sensor 3. Be able to set ADC scale, data sampling rate 4. Perform auto zero (take X readings, average it, and subtract it from the values) 5. Calibrate sensor (we apply 3 points of known excitation to sensor, and scale reading to that using linear or polynomial fit) 6. Save raw and scaled data to CSV files You must be able to debug software with the hardware remotely via Team Viewer or remote desktop.
...scraping and data organization to extract detailed information about Funko Pop collectibles valued at $150 or more from PopPriceGuide.com. The project aims to create an Excel document listing these collectibles, focusing on item names and detailed data for each variant, including chase versions and their sub-variants. Scope of Work 1. Data Extraction: • Target the Funko Pop section on for data collection. • Extract data for Funko Pop collectibles with an estimated value of $150 or more. Required data points include: • Item name • Estimated value • Details for each variant (e.g., colors, themes) • Information on chase versions and any sub-variants • Ensure the accuracy of the extra...
I am looking for a seasoned freelancer to build an automated product uploader for eBay.co.uk. I have no specific preference over whether the uploader uses manual entry, CSV/Excel file or API integration methods to retrieve product information, so I am open to suggestions here. As for skills and experience: - Strong working knowledge of eBay's platform is crucial - Prior experience in building automated uploading systems is desirable - Familiarity with CSV/Excel file handling or API integration would be bonus points In your proposal, I would appreciate a brief overview of your past work, relevant experience and detailed explanation on how you plan to tackle this project. Looking forward to see your innovative bids.
We have a wordpress website that we need to transfer to another domain today.
As the primary user of a Windows 11 Pro PC acting as a server for a SQL based car dealership software, EasyDeal, I require technical support to resolve my ongoing issue. The main problem I encounter is that various devices are struggling to maintain a connection to the software, indicating a "Connection Timeout" TCP errors, "could not locate server" error message. Key Tasks: * Troubleshoot and repair the connection issues on the server and other devices * Ensure stable, reliable connection between the devices and server Ideal Skills & Experience: * Proven experience with EasyDeal software * Excellent knowledge and skills in SQL and network troubleshooting * Familiarity with Windows 11 Pro and server management.
I'm looking for someone proficient in SQL Server to help with my complex stored procedure. This task incorporates both performance optimization throughout and enhancements in specific areas. Required Skills and Experience: • Expertise in SQL Server. • Experience in performance optimization of stored procedures. • Tackling both overall and specific improvements. I have complete documentation of the current structure and logic of the procedure. This will aid in understanding what needs to be fixed and consequently expedite the completion of the project. Your role will include finalizing it and working according to the requirements. Do not bid for this unless you are free to work on this for the next 5 days, as this is urgent work!
I'm looking for a professional who can assist me in setting up a Linux web server. The main purpose of this server will be to host an informational website that predominantly features educational content. Your expertise should ideally include: - Substantial understanding of Linux server setup - Previous experience in hosting informational websites - Ability to optimize servers for efficient operation You'll be providing the foundation for a website aiming to make an educational impact, so attention to detail and an understanding of best practices for informational site hosting are key for this project.
...a proficient data scraper to gather key information from an entire forum. This project requires extraction of distinct data points such as all user comments, the date and time of each post, and the related thread categories. Ideal Skills and Experience: • Extensive knowledge in data scraping • Proven understanding of data analysis • Familiarity with various forum platforms Scope of Work: • Extract all user comments from the forum • Record the date and time of all posts • Identify and label the thread categories of each post • Execute this task across all forums within the website This data will be utilized for in-depth data analysis. The ability to accurately categorize the extracted information is cr...
I require a capable professional to set up an SMTP server for less than 10,000 daily marketing emails. These emails will primarily be a combination of graphics and text. Ideal Skills and Experience: - Extensive knowledge and experience with SMTP server set up - Background in email marketing - Understanding of best practices for sending marketing emails in high volumes - Experience with incorporating both graphics and text into emails Key Task: - Ensure the server is capable and optimized for the daily volume of less than 10,000 emails - Provide guidance on best practices for minimizing bounce rates and spam flags. - Support in creating graphic and text-based emails that are compelling and engaging. This project demands attention to detail and a good understandin...
I am looking for an accomplished expert or team in Lineage 2 server setup to establish a Gracia Final version. Requirements: * Experience with setting up Lineage 2 servers, particularly the Gracia Final version. * Understanding of and experience with the mixed PvP/PvE server settings. * Capability to configure server for players to start at Level 1. * Native donations with auto inventory fills * Custom items, skills, quests, NPCs + This project requires a keen attention to details and exceptional knowledge of the mechanics of Lineage 2. Your expertise will ensure a smooth and efficient setup process.
I am seeking a skilled web scraper who can efficiently extract certain bio details from a specified adult content website. The data required for this aggregation includes names, ages, descriptions, additional information presented, and images. - No format or resolution requirements for the images. - Predictable accuracy in data extraction and aggregation is pertinent. - Reliability and discretion are key. Expertise in web scraping and data mining is highly desirable. Familiarity with adult content websites is a distinct advantage. Please note that all data will be strictly used for content aggregation purposes.
...exporting it to a CSV format. This CSV file will be utilized to automatically populate templates in Marketing Cloud, optimizing our workflow for copywriting and content management. Key Deliverables: Custom Figma Plug-in: Develop a custom plug-in for Figma that enables users to extract text content from Figma frames and export it to a CSV format. User Interface: Design and implement a user-friendly interface within the plug-in for importing text, managing templates, and exporting CSV files. Import Functionality: Create functionality within the plug-in to import text content from Figma frames. The plug-in should recognize text layers based on their names and map them to corresponding cells in the CSV table. Export Functionality: Implement fea...
Please give a viral and unique idea for a Minecraft server so that everyone will enjoy it and players will play for a long time
I am in need of an expert web scraper who can fetch information from Make.com. It's not necessary for you to extract a particular type of data as I haven't decided on the specifics yet so versatility is key. Ideally, I'd like your application to include: - Detailed project proposals While it would be advantageous if you're proficient in certain web scraping tools like Python with BeautifulSoup, JavaScript with Puppeteer, or Php with Goutte, I do not have a specific requirement, indicating flexibility in the tools you employ. Your ability to choose the right tool for this project will be part of your proposal. Feel free to apply if you can handle this task.
Description: I am in need of a skilled developer who can create a Twitter scraper capable of gathering data from user profiles based on specific keywords present in their bios. The primary keywords of interest include ".ai" and "llm". The scraper should be able to extract the following information from each profile: Username: The unique Twitter handle of the user. Profile Link: Direct URL link to the user's profile. Bio: The user's bio text, containing the specified keyword. Follower Count: The number of followers the user has. Linked Websites: Any websites or URLs linked in the user's profile, if available. The scraper should efficiently collect this data from Twitter profiles and compile it into a structured format for further ana...
I'm seeking an experienced Server Management Specialist, who predominantly manages 35 servers and is skilled in Cassandra, Elastic Search, and MySQL (Jira docs). Comfort with Jenkins and Linux is critical. Ideally, our selected freelancer possesses strong communication skills and exhibits an ability to identify key infrastructure resources rapidly. The scope of tasks includes, but not limited to: - Routine maintenance and updates - Troubleshooting - Problem resolution - Installation and Configuration My project is focused on making frequent updates to resources found in Jira and app-status.ot. It is imperative that the freelancer is able to check emails regularly to stay current with any urgent alerts. Please consider this a long-term project opportunity if found s...
...scraper with a knack for dealing with extensive data amounts. The primary objective is to extract text content from numerous public social media websites. Key Tasks: - You will need to retrieve all available information on these web pages, focusing solely on the text content. - Following the successful extraction of the data, your responsibility will be to deliver it in JSON format. - The databases for the transfer of data includes MongoDB and MySQL. Ideal Skills: - Advanced knowledge of web scraping tools and techniques. - Experience with social media platforms and their data structures. - Strong understanding of JSON and databases, specifically MongoDB and MySQL. - Diligence and attention to detail for extracting vast amounts of data ac...
Looking for a SQL Expert who is good with Transact SQL, stored procedure and expert with MS SQL server. Task is related to trigger and XML and should hardly take one day to complete
I have a webform developed in HTML5, PHP, SQL, and JavaScript. I'm looking for a developer to make a few key improvements. PRE-BUILT I have currently built a where the user selects a customer from a dropdown and selects the number of products to add to this order. Each customer from an SQL table called 'customers' has its own price class 'customerPriceClass' When the user selects the number of products, the page updates and adds rows for each product with a dropdown menu where the choices are fetched from another table called 'products'. The user selects the product and enters the number of units. NEEDED: STEP1 For each row of products the corresponding price from the table 'prices' should be fetched that is associated with t...
...calculate the hourly rate and the time needed to complete different task documents, on an agreed fixed price. The best offers with the right experience will have the opportunity to work with us on a long-term basis. Also, Good prospects for the right developers, based on the performances evaluated over a period of time, once you established your skills. Need to provide the changed code details and sql queries if any at the end of each sub-task, with the changed code line numbers. Unlimited Revisions are needed. Any bugs created due to your own developments are to be fixed on free of Charge. Recruitment is for a long-term big project as such, all the developers are subject to practical skill test for which not paid. Please send your details for the below-mentioned questions....
...servers on Linux systems. The primary goal is to streamline the game server setup process, reducing manual setup and configuration time. The script should handle the entire setup process, from initial server preparation to the final game server launch. Script Requirements: — Automated Deployment: Automatically download, install, and configure game server software. — Configuration Management: Scripts should read from config file — Compatibility: Must run on Ubuntu — Security: Incorporate basic security settings to protect the server. — Efficiency: Minimize resource usage during setup to not impact server performance. Skills Required: — Proficiency in Python or Bash scripting under Linux environments. — U...
I need an experienced C# developer to create an advanced contact form for my existing website and execute its storage function by integrating it with MS SQL Server. Key Requirements: - Development of a contact form with fields for Name, Email, Phone number, and Address. - Form validation should be included to ensure data input integrity. Specifically: * Email format should adhere to standard email format * Phone number input should match a predefined format. Preferred Skills: - Proficiency in C# and MS SQL Server - Experience in form creation and data validation - Attention to detail for error-free functionality.
...looking for an expert who can aid with the design and development of an SQL database and a coherent PHP framework. The ideal candidate should have extensive experience with: - Designing efficient SQL database structures for small-scale databases (less than 1000 records). - Writing comprehensive SQL queries. - Effectively integrating PHP with SQL databases. The purpose of this project is to utilize SQL and PHP to innovatively design and construct a web application. The applicant should have a strong track record of building successful, high-performing web applications. Emphasis will be placed on the ability to manage and manipulate small-sized databases. Given the nature of this project, a meticulous approach to data management and a keen eye f...
Hi we need a professional linux server administrator I need a series of tasks regarding setting up a linux server and configuring it's security. Analytical details will be given in a doc in chat. Every step needs to be reported in a doc according to the requirements, including the screenshots of the system and the commands used. Deadline is in 12 hours from now, we need to do as much as possible Budget: $70 USD (fixed)
Hi we need a professional linux server administrator I need a series of tasks regarding setting up a linux server and configuring it's security. Analytical details will be given in a doc in chat. Every step needs to be reported in a doc according to the requirements, including the screenshots of the system and the commands used. Deadline is in 12 hours from now, we need to do as much as possible Budget: $70 USD (fixed)
...screen sharing) Resource must have Knowledgeable of the ASP.NET framework, Microsoft SQL Server and design/architectural patterns (e.g., Model View-Controller (MVC)). Knowledge of web development languages, such as HTML, XML, CSS, JavaScript and AJAX. Experience with database servers, particularly Microsoft SQL Server 2016 or newer/ In-depth knowledge of the .NET infrastructure Experience with architecture styles/APIs (REST, RPC). Understanding of the Agile methodology. Knowledge of REST and RPC APIs. Strong communication and interpersonal skills with an ability to work well in a team setting. Advanced proficiency in C#, F#, or VB.NET; preferably all three. Highly experienced using Microsoft SQL. Outstanding analytical, problem-so...
...hospital usage, I need a proficient developer to create a secure server that is cloud based. The server should be crafted in a way that integrates HL7, placing a strong focus on data security, as we will be storing confidential patient information. Key tasks to undertake include: - Implementing encrypted data storage and retrieval, ensuring integrity and confidentiality of patient data. - Setting up HL7 message parsing and processing, enhancing data interoperability. - Facilitating user authentication and access control via role-based access control, limiting system access to authorized personnel only. To meet these tasks, you should bring a proven familiarity with encryption methods and SSL/TLS certificates to secure server connecti...
This project requires building a robust flight booking system that will function as the primary focus of the software. Ideal freelancers should have a strong background in this area. Key Details: - Essential components of the system will include flight booking capabilities along with...book or cancel reservations. - Ability to review and rate hotels is a mandatory feature to incorporate. Payment Details: - The software system should integrate a secure payment gateway for the booking procedure. - I prefer to accept payments using Credit/Debit cards and Bank Transfers. Previous experience in developing booking systems and payment gateways will be a plus. Skills: - Python, C#, SQL or other relevant languages - Payment gateway integration - UX/UI - Database Management - Project M...
I am looking for an experienced Java programmer, well-versed in handling .tex files. Your task will be to write a script that can efficiently parse and extract certain data from these documents which include the text content, references and citations, and any mathematical equations present within. Skills and Requirements: • Profound knowledge of Java for data extraction • Understanding of .tex files • Familiarity with using regular expressions to parse text • Experience with handling UTF-8 for any special characters and equations This project doesn't require the text to be reformatted, it simply needs to be extracted to a plain text .txt file, preserving the content, citations and equations as they are in the source .tex file. If you have pr...
...reports into one comprehensive report. - Source Reports: The two reports to be used are System Report A and System Report B. - Data Requirements: Financial data from these reports are consolidated and presented a user friendly way including the use of pie charts. - Responsibilities: - Extract the necessary data from system reports. - Deliver a consolidated and readable report using the provided template. Ideal candidates would have solid experience in handling and manipulating large datasets using Visual Basic or similar tools. Proficiency in report preparation and presentation is key to this role. Knowledge of transaction data and how to interpret this data will be advantageous. Attention to detail is paramount, as accurate informa...
...expertise in both Simple and Winter's Exponential Smoothing. The project entails: - two exercises that involve working with a particular set of data in a file format (either CSV, XLSX, etc.) and applying both variants of Exponential Smoothing to predict future values. - Optimizing the forecasting process to procure the most accurate results. discuss your forecasting method, your forecasts, and the business insights from these in a 750 word report. - Please note that the provided data set won't be updated, so the focus should be on competing the steps of the task assigned. The perfect candidate would have: - Strong experience in Excel and data analysis. - A profound understanding of Simple and Winter's Exponential Smoothing techniques. - Ex...
...creation of a dummy server for a hospital with HL7 integration. A pay portal is already in place and will be connected to the server. The server must include the following functionalities: - Patient Registration - Displaying Laboratory Results - Storing and Accessing Medical Records The ideal freelancer would have experience in server development and healthcare-specific technology integration. Please include detailed project proposals in your application. This should illustrate your understanding of the project, your approach to fulfilling the requirements, and outline any relevant past work or experiences that would make you an excellent fit for this project. As for programming languages, while I didn't specify a preference, knowledge in languages ...
The local MySQL server engine suddenly shut down due to a power failure. This caused an error in storage or a memory error that led to corruption when the storage engine is writing data to the table. Attempting to fix it, I manipulated the LOGS files (transaction logs, etc.) and managed to connect to the database, query data, and export some of it, and the data was exported perfectly. That's why I know the data is intact. Unfortunately, I didn't think to export all the data because I thought the error had been fixed. However, the next day, the error returned, and I couldn't fix it. Here is a link that explains that it is a common problem in my situation: We are using, XAMPP, MYSQL and Maria
Hello I just purchased new Rapid SSL certificate but I didn't generated it so I don't mess anything up I will need someone to generate my newcert. and install it on Ubuntu server - So NO CPANNEL And I need this 5-10min job to be done today please
...part of an ongoing project, I am looking for a highly skilled freelancer who can assist me in automating a process on an FTP site. The bulk of the task involves: - Creating a Zap in Zapier that can manage and manipulate .CSV files on the FTP site. - The Zap should be programmed to effectively delete redundant files. - It should also be capable of renaming files to ensure consistent importation. Ideal Skills and Experience: - Proven experience in using and manipulating Zapier. - Familiarity and experience with File Transfer Protocol (FTP). - Confidence in handling .CSV files. - Demonstrable problem-solving skills and attention to detail. In your application, provide a detailed project proposal on how you intend to meet my requirements. Your proposal should demonstrate...
