Data extraction sql csvεργασίες

Το έργο είναι πλήρως ολοκληρωμένο σε επίπεδο ανάλυσης και έχει σχεδιαστεί και η βάση δεδομένων σε SQL Server. Οποιαδήποτε εμπειρία σε διασύνδεση με SQL Server θεωρεί&tau...

Γειά σου Νίκο, είμαι ο Στέργιος. Στη δουλειά έχουμε κάποια site σε cpanel σε shared hosting στο hostgator και προσφατα μας κλειδωσαν την SQL και με το support τους δεν υπάρχει επικοινωνία γ&i...

θέλω να εξάγω δεδομένα από sql σε excel, , δηλαδή να έχω κάποια σταθερά κελιά που θα πρέπει να ενημερώνονται κάθε φορά μετά την καταxώρηση νέων στοιχείων στο erp.

Θα ήθελα να ενημερώνω ένα φύλλο ms excel από μια βάση δεδομένων MS SQL την οποία χρησιμοποιεί το ERP (SoftOne) ως χώρο αποθήκευσης δεδομένων.

Θέλω να δημιουργήσω οικονομικές αναφορές στο excel που να αντλούν πληροφορίες απο την sql που χρησιμοποιεί το erp μου.

SQL Tuning, PL/SQL, ΟΒΙΕΕ, Discoverer, APEX, Forms, Reports

...Κεντρικά Γραφεία της Εταιρείας, στη Θεσσαλονίκη. Τα επιθυμητά προσόντα της θέσης είναι: Πτυχίο σχολής ΑΕΙ ή ΤΕΙ Πληροφορικής Πολύ καλή γνώση προγραμματισμού ...

Θέλω την δημιουργία ενός eshop που να μπορώ να συγχρονίζω τις κατηγορίες και τα προϊόντα των προμηθευτών στο site είτε μέσα από excel, csv, xml. Και αναλυτική αναζήτηση προϊόντων με βάσ&e...

ΔΕΔΟΜΕΝΑ πολύφυλλα έγγραφα ΚΑΤΑΧΩΡΗΣΗ σε sql server2005 ημερομηνία έκδοσης εκδότη θέμα 3level κατηγορία το έγγραφο σαν εικόνα στο sql server και όχι το path του αρχείου ΑΝΑΖΗΤΗ&...

ΔΕΔΟΜΕΝΑ πολύφυλλα έγγραφα ΚΑΤΑΧΩΡΗΣΗ σε sql server2005 ημερομηνία έκδοσης εκδότη θέμα 3level κατηγορία το έγγραφο σαν εικόνα στο sql server και όχι το path του αρχείου ΑΝΑΖΗΤΗ&...

I need a skilled freelancer to extract table data from a PDF file. The extracted data will be used for analysis in a Microsoft Excel spreadsheet. Key Requirements: - Extract tables from a PDF - Ensure data quality and integrity - Deliver the data in a Microsoft Excel format Ideal Skills: - Proficiency in PDF data extraction - Strong understanding of table structures - Experience in working with Microsoft Excel - Attention to detail and accuracy is crucial look attached PDF and EXCEL then Bid, start Bid writing PDF and sample attached. So I know you look my file

I'm looking for a skilled software developer to create a Windows application that focuses on generating data reports from a SQL database. Key Requirements: - The application must be compatible with the Windows platform - The main functionality of the application should be the generation of data reports. - The reports should be sourced from SQL database. Ideal Skills and Experience: - Proficiency in Windows application development - Strong knowledge and experience with SQL database and report generation - Previous experience with data reporting software would be a plus.

ML with ensemble methods via CSV file. Only code, no deployment!

I'm in need of a Junior Full Stack Engineer who is proficient with Java, with beginner level experience. The primary task will be to work on implementing Go Live for an assigned project. Ideal skills for the job: - Understanding of Java programming language - Ability to work collaboratively on a team - JSON - XML - SQL - Data Mapping Some experience with project implementation is a plus. Dedicated beginners are also welcome to take their first steps in a real project.

...skilled data scientist for an essential project, focusing primarily on data visualization and classification. IDEAL CANDIDATE SHOULD BE: • Proficient in creating visuals using complex data. • Capable of effectively interpreting data from CSV files. • Experienced in performing sophisticated data classification. TASKS DETAILS: • Devise an effective strategy for visualizing extensive information derived from CSV files. • Incorporate classification techniques to understand and categorize the data efficiently. PROJECT OBJECTIVE: The ultimate goal of this project is to successfully classify data and use it for an effective and visually appealing representation. This outcome aids in understandi...

I am seeking a well-researched, detailed list of car models. The desired freelancer should have experience compiling similar information. Past work showcasing thorough attention to detail would be a plus. The list should be universal and not limited to specific types of cars such as Sedans, SUVs or Hatchbacks. Please provide samples of similar projects you've do...The desired freelancer should have experience compiling similar information. Past work showcasing thorough attention to detail would be a plus. The list should be universal and not limited to specific types of cars such as Sedans, SUVs or Hatchbacks. Please provide samples of similar projects you've done before, demonstrating your ability to produce a comprehensive and accurate list. Maibe on CSV if it'...

...can help me extract specific data on the results of the Tokyo 2021 Paralympic Games from the official website - The data I require includes: - Athlete profiles - All the results of each competitor - Medal winners The extracted data should be presented in a CSV file format. It should be in a similar format as this dataset on the results of the Olympic games: No specific analysis is needed on the extracted data. Ideal skills and experience for this job include: - Proficiency in web scraping - Experience in data extraction - Expertise in data formatting and CSV files Your professional approach and ability to deliver accurate, complete data will be crucial. Please bid

I am looking for a skilled and experienced Full stack developer with Hands-on experience in Java Hands-on experience in Angular/ REACT Hands on experience on AWS RDS/AWS S3/Oracle/AWS Athena/ SQL In-depth knowledge in Core Java, Spring framework and RESTful API Services, Apache Camel, CI/CD Jenkins, Containerization Experience with AWS Cloud and its services like EC2, Athena, Lambda, S3, SQS and Cloud Formation Experience in writing JUnit test cases Problem-solving abilities

We are looking for a freelancer with strong web scraping experience for an exciting and challenging project. We need to gather specific data from multiple online sources and transform it into useful, structured information for analysis. Responsibilities: Utilize web scraping techniques to extract data from selected websites. Automate the extraction process to ensure accuracy and efficiency. Clean and structure the collected data into readable and usable formats. Integrate the extracted data into a database or spreadsheet as needed. Collaborate with our team to understand specific requirements and ensure the quality of the obtained data. Requirements: Demonstrable experience in web scraping using tools like Python (Beautiful Soup, Scrapy), Seleni...

...designed to integrate data from various advertising platforms, website activity, CRM, and Marketing Automation Platforms (MAP) to provide a unified view of marketing performance. We require a highly skilled and efficient Data Engineer or Architect who can handle data export processes, model and create tables and entity relationships, and develop an efficient and scalable database within a tight one-month deadline. ### Responsibilities: - Data Integration: connect and streamline data from multiple sources including ad platforms (like Google Ads, Facebook), website analytics tools (e.g., Google Analytics), CRM systems (e.g., Salesforce), and MAPs (e.g., HubSpot). - **Accelerated Database Design:** Design and implement a robust and scalable database that...

...Internet price research mechanism for the electronic products listed within a .csv file. The deliverable I expect from this project is a separate report containing the price of each product, along with additional details such as a link to the retailer's page and the price history. Key Responsibilities: - Extracting and updating the price information of electronic products from the Internet, based on the .csv file provided. - Incorporating a detailed report that includes the prices, a link to the retailer's page, and the price history of each product. Skills and Experience: - Proficiency in data extraction, research, and analysis. - Experience with web scraping tools. - Strong organizational skills to present the data in a clear, concise man...

I need a web scraper to extract specific data from various websites. The project will involve: - Identifying the necessary data to be scraped - Building a scraper to extract this data Ideal skills for this job include: - Proficiency in web scraping tools - Familiarity with web data extraction techniques - Ability to work with and extract data from various websites Please provide your quote for this project.

...Seller Data: The main purpose of this project is to gather information about the sellers on the Miravia platform (). This includes the shop_id shop_name Ivl1_cate_name product_number avg_price shipping_duration company_location phone_number email_address vat_number company_name shop_rating shipping_on_time % followers comments etc. I require 10,000 entries of data I require the data to be well-structured and organized into a CSV or Excel file for further analysis. Skills and Experience: - Proficiency in Web Scraping: The ideal candidate should have extensive experience in web scraping and data extraction. - Attention to Detail: Since the project involves gathering a wide range of data points, having a keen eye for detail is crucial t...

I need a freelancer to transcribe an English video that's between 10-30 minutes long. Additionally, I require the audio to be extracted and edited to improve its quality. Ideal Skills and Experience: - Proficiency in English to transcribe the video accurately. - Experience with audio editing to enhance the MP3's quality.

I'm seeking an experienced .NET developer with over 4 years of expertise in C# programming and SQL databases. Key Responsibilities: - Enhancing existing software application - Adding new functionalities The ideal candidate should possess: - Strong experience in C# programming - Solid knowledge and practical experience with SQL databases Be ready to dive into the project and help us bring significant functionality enhancements to our existing software. Your experience and skills in C# and SQL will be invaluable in this task.

...freelancer who can work with OpenStreetMap data to extract specific elements and format them into a .csv file. Key Requirements: - Extracting Geographical locations: ID (from OSM), ZIP, City, District of City, Federal State, District, Street, Housenumber, Latitude, Longitude. If available the Community and the Code of the Community The dumpfile is on: The Download and Format-Process should be automated and if possible triggered with a download Button on an HTML Page. By clicking on the Download button, the process of formating the OSM into .csv is startet. Coding of .csv should be UTF-8 Ideal Skills: - Proficiency with OpenStreetMap data and extraction tools. - Experience in formatting data into .csv files. This is a ...

I need a talented VB.net developer with a strong background in SQL Server. Key Responsibilities: - Develop software applications using VB.net - Efficiently manage databases - Designing, coding, testing, and debugging software applications using VB.NET. - Calling third-party API - Payment gateway integration - Stored Procedure Ideal Candidate: - Proven experience in VB.net development - Strong familiarity with SQL Server - Good problem-solving skills - Ability to work independently and meet deadlines. Please provide relevant work samples in VB.net development and describe your experience with SQL Server.

I am seeking a talented Python developer to create a recommendation model. The scope involves mining unspecified data types for the model training. It should be noted that while the purpose of the model is to be determined, the data for the model training is in CSV format. Ideal Skills: - Expertise in Python. - Familiarity with recommendation algorithms. - Experience manipulating CSV data. Responsibilities: - Developing a flexible, adaptable recommendation model. - Importing and managing data from CSV files. - Advising on and utilizing appropriate algorithms depending on the eventual decision for the purpose of the model. DELIVERABLES Output Data Frame: Attribute Name | Ad 1 | Ad 2 | Ad 3 | Ad 4 | Ad 5 | Ad 6 | Ad 7 | Ad 8 | Ad 9 ...

I'm searching urgently for an experienced PHP architect who can const...items. - Integrating an 'Add to cart and checkout' feature ensuring a simple and smooth transaction process. - Developing order management and inventory tracking system within the admin panel to help me keep track of orders and product stocks. Skills and Experience Required: - Proficient in PHP programming - Experience in developing e-commerce websites - Solid understanding of databases and SQL - Familiarity with different payment solutions Although there is no specific requirement for payment method integration at the moment, the ability to seamlessly add these in the future is essential. My project requires immediate attention and the chosen freelancer needs to be able to commit and delive...

******* LOCATION ******* You must live in Eastern Europe or Latin America. ******* OVERVIEW ******* I will conduct searches on Google like "Plumbers Minneapolis, Minnesota" or "Carpenters Charlotte, North Carolina." Then I will run the script(s) you created for me. The script(s) you create will save the Google search results in a .csv file. That is trivial and straightforward. The script(s) will also open the websites associated with the search results. That is also trivial and straightforward. The main challenge lies in locating and filling out contact forms on these websites with my first name, last name, email address, phone number, etc. Most search results will include a link to the company’s website. For example, when I search on Google for&helli...

I'm in need of a skilled data miner who can help to extract certain details from a vast range of Shopify products. Your mission, if you choose to accept it, is as follows: - list products that contain non-English writing or words in text and videos - Organise and sort these findings for simple review - Identify and list any products filled with non-English language in the description, pictures or images - Compile lists of products that aren’t currently making top-seller lists - List any products can not be delivered in eight days or less. Please note that tractors and food vans may take up to two months to deliver. - List any products that are not suitable for industrial purposes/non-commercial products. Ensure that the products you are considering are meant for commerci...

I am looking for an expert in RFID technology and .NET programming to integrate the RFID into our current weighbridge system. Key Details: - 3rd Party System was developed using .NET and it does support API or external interface connections. - The task will involve programming to fully integrate the system with RFID technology. Skills and Experience: - Proficiency in .NET programming & SQL Database - Previous experience with RFID technology - Knowledge of API integration - Experience with weighbridge systems would be a huge advantage. Your role will be to ensure the smooth functioning of the weighbridge system post-integration and provide us with a user-friendly, effective RFID solution.

...experienced in web scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to ensure accuracy of the scraped data. * An understand...

I require an efficient solution to extract contact details, specifically phone numbers and email addresses, for newly sold residential properties.

Project Budget: $100 Project Deadline: 1-2 Days Project Type: Custom WordPress Plugin Project Difficulty: Standard PHP Version: 8.2 and above Project Overview: Custom WordPress plugin required to allow a user to: - Upload a CSV with bulk new POST data - Select a post category, schedule start date, choose how many posts to PUBLISH each a day - Import post data and create all new posts as DRAFTS, to go live on the specified post schedule & keep a suitable log that can be checked - Insert the new POST IDs back into the original CSV file & automatically download the update CSV for a user 5* FEEDBACK WILL BE LEFT FOR YOU

• Experience with Testing tools Experienced using SQL Advanced experience developing test metrics and reports Experience with Automated Testing Five (5) • years of Testing experience in a Software Development Lifecycle environment Five (5) • SQL and PLSQL Programming in SQL Server ETL and Data warehouse process Informatica 10 • 20 Informatica Data Quality Profiles , Score Cards SQL Server RDBMS SQL Server Analytics Services SSAS SQL Server Reporting Services SSRS Tableau Reporting BMC Control M Scheduler Tool Data Analysis Data Profiling Application Life Cycle Management Complete Testing process SDLC, Agile Process, SAFE and Kanban methodologies, TFS Tool Good Communication Skills and Quick Learner Se...

...consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Macro, MS Office skills to drive automation opportunities. • Well-versed with dynamic loops, data extraction from images. • Work with users and team members at all levels for performance improvement and suggestions. • Understand and prepare Ad hoc reports. • Identify the opportunities of automating reports, snapshots and dashboards using advanced formulas, Advanced Excel, Python and other techniques • Consolidate, sort, organize and summar...

I'm looking for a talented freelancer who can assist with scraping automobile ads from website. Key Requirements: - Scraping specific automobile ads. - Extracting ad titles, descriptions and prices. The ideal candidate should have: - Experience in web scraping. - A strong understanding of data collection from websites. - Attention to detail to ensure accurate extraction of data. Please note that the exact websites and the car details are not provided yet, so the freelancer should be able to work with changing parameters.

I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.

...where the last row of data was successfully extracted. Scraper Functions Function: list_category_tree Input: competitor_name(astro | sayurbox | segari), existing_csv (optional - CSV file to append to for continuing execution, if the scraper stopped or got IP blocked) Output: CSV of category tree with the following columns (scrape_date, URL, category name, position index, parent_category (null if top level)) Function: extract_sku Input: competitor_name, location (autocomplete place from google maps API), category (optional - extract SKUs from all categories if null), sub_category (optional - extract all SKUs from all subcategories if null), existing_csv (optional - CSV file to append to for continuing execution, if the scraper stopped or got IP blocked) ...

I require a skilled Excel VBA developer to create a dyna...skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct d...

I'm in need of an expert who can help in developing a relational database using SQL and Python. The project will primarily revolve around database management. Consequently, I would appreciate assistance in the following tasks: - Designing a new relational database, ensuring it's optimized for efficiency and performance. - Implementing data import and export capabilities for seamless data movement. - Developing queries to support the database's functionality and ease of use. The ideal candidate for this project should have a strong background in both SQL and Python, with a specific focus on database development. Experience with optimizing databases for performance and some knowledge of data import/export mechanisms would be advantageous. M...

I'm in need of a developer who can create a n8n script to login to a specific website and extract stock data for multiple companies. Key features of this project include: - Extraction of table data: You should have knowledge and experience working with web data extraction, specifically with table data. - Selection of stocks data: The script should have the ability to select and extract information from the stock table. - Capability for multiple companies: The tool should be versatile to handle data extraction for multiple companies, not limited to just one. Experience in the use of n8n for data extraction from websites, especially in the finance sector, will be a significant advantage for this project....

...crucial for ensuring that when uploading a CSV file to Shopify, each product will display its respective images seamlessly. Project Details: Scope: Adding image links to Excel sheets for 666 products in total. Task: Create a new column labeled Images in each Excel sheet and insert corresponding image links for each product. Requirements: Image links should open the respective product images when clicked. The CSV files must be Shopify-compatible without any issues upon upload. Deadline: Project completion required within the next 48 hours. Quality Assurance: Accuracy is paramount, as each CSV file will be cross-checked before final approval. Deliverables: Two Excel sheets with a new Images column containing accurate image links for each product. CSV files read...

Need advanced SQL including stored procedures, functions, based on existing SQL code. Need c# coding with dojo -Ideal Skills/experience * c# with dojo * MS SQL Server proficient. * Expert in advanced SQL features like stored procedures, functions. * complex SQL queries. * generating SQL reports from tables.

I need add an automatic stock control to Amazon, currently the catalogue is contained on a CSV

I need a professional to mine data for me. I need you to download and extract the submissions and comments from a public Reddit dataset for 40 subreddits that I will give you. - Data Collection: Please extract the submissions and comments from this academictorrents link: https://academictorrents.com/details/56aa49f9653ba545f48df2e33679f014d2829c10/tech&filelist=1 I only want the comments and submissions for specific subreddits that I will supply to you. Please save the extracted data as csv file. - Frequency: This is a one-time job. Skills and Experience: - Torrent download and extraction.

...search of a skilled freelancer proficient in web scraping with Scrapy to extract product data from This project involves scraping the Category page to retrieve product details including name, price, SKU, URL, breadcrumb, currency, and brand. Targeted webpage: Category page of Required data: Product name, price, SKU, URL, breadcrumb, currency, and brand Experience: Prior experience in scraping product-related information from e-commerce sites is essential, with proficiency in Scrapy being crucial for accurate and efficient data extraction. Data Handling: Ability to ensure accuracy and consistency of extracted data. Familiarity with different data formats is advantageous. Dynamic Scraping: Navigation logic for all categories must be cont...

...Predictive Analytics functionalities. Key Requirements: - Proven experience in implementing AI features in Power BI is a must. - Strong background in Natural Language Processing, Machine Learning Models, and Predictive Analytics. - Proficient in working with SQL databases and Online APIs for data integration. - Ability to deliver a dashboard with basic filtering and sorting capabilities. Your main tasks will include: - Integrating the AI functionalities into the Power BI project. - Ensuring seamless communication between Power BI and the SQL databases, Online APIs. - Implementing a user-friendly interface with basic filtering and sorting options. If you are confident in your Power BI and AI skills, and have the technical expertise to deliver such a project, I wou...

I'm in dire need of a seasoned data analyst, capable of working proficiently with Power BI, to delve into our recent financial data. The objective of your analysis will be the understanding of our customer's purchasing behavior within the last month. Key areas to focus on: - The extraction and interpretation of relevant purchasing behaviors from our financial data - Creating accessible visual representations of these findings through Power BI Ideal Skills And Experience: - Proven data analysis skills - Proficiency with Power BI - Familiarity with financial data interpretation - Insightful about purchasing behaviors and able to spot trends - Experience working with data from the past month would be great.