Vba csv xml jobs
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
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
Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, 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 kno...
...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) Output: CSV of SKUs with the following columns (category, sub_category, br...
I require a 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 data formatting - Ability to create user-friendly interfac...
Finding Someone Who can Solve this error (One site is sending me callbacks and in 10 callbacks theyre getting this response in 5 callbacks and rest 5 callbacks are working fine) <?xml version='1.0' ?> <env:Envelope xmlns:env=''> <env:Body> <env:Fault> <faultcode>env:Client</faultcode> <faultstring>Internal Error</faultstring> </env:Fault> </env:Body> </env:Envelope
...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...
I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of mechanical engineering prin...
I'm seeking a knowledgeable professional proficient in Azure Databricks, Azure Data Factory, and ADLS to assist with data manipulation and transformation tasks. In specific, you will be working with semi-structured data, particularly JSON and XML formats. Key tasks will include: - Filtering and cleaning of data - Converting the cleaned data into different formats Having previous experience with semi-structured data and being familiar with machine learning and AI integration will be highly regarded. I'm looking for an individual who can ensure efficiency and accuracy throughout the process. Let's make data work for us!
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://academictorrent...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 a...
...automatically downloads building and road data from OpenStreetMap in CSV format on a monthly basis or with a html frontend site, where we can "click" in Downloadbutton. Key requirements: - Automate the retrieval of building and road data from OpenStreetMap - Download the data in CSV format - Set up the system to run the download process on a monthly basis optimizely on html frotend with a download button Format of the csv: ID (from OSM), ZIP, City, District of City, Federal State, District, Street, Housenumber If available the Community and the Code of the Community Ideal skills and experience: - Proficient in OpenStreetMap data retrieval - Programming experience to automate data downloads - Strong understanding of CSV data formatting - Abilit...
I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.
...Developer, Oracle SQL Developer, Eclipse. The project involves writing comprehensive tests for a range of technologies including: - Java and JavaScript. - Spring Framework. - Oracle Database. - XML and JSON. - Junit. - Eclipse/Intellij. - PL-SQL Developer. - Utilizing Github and other version control tools. The ideal candidate must have a deep understanding and practical experience with these technologies. The project has an urgent timeline, so the selected candidate must be able to work under pressure and deliver high-quality results quickly. Ideal Skills: - Proficient in Java, Spring Framework, Oracle, XML, JSON, Junit, and JavaScript. - Experienced with Eclipse/Intellij, PL-SQL Developer, and Oracle SQL Developer. - Skilled in writing tests for Java and Oracle. - Fa...
I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.
Project Duration: 1 Hour Project Type: Python Script Modification Project Level: Normal Server Type: Ubuntu 22.04 Number of Changes Required: 1 Project Overview: We have an existing Python script that allows us to upload a CSV with two columns: Prompt Output The script then submits each “Prompt” to the OpenAI API, inserts the output into the “Output” column. We would like one change made to the existing script. Change Required: We would like to add one more column to the CSV file, “Id”, it will be the first column. We use “Id” as our own reference number for the row This column and its value should be retained in the output file. 5* FEEDBACK WILL BE LEFT FOR YOU
...payment and number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, where you w...
I'm in need of a skillful developer experienced ...from TNT ... quote There is a change coming to the TNT RTT API, this is what you use to get pricing for shipping on your online store or internal system. Please have this email directed to whomever controls the online portal: You are currently using the ASP version of the RTT service, and we need customers to move to our .NET version. This will require that the XML payload is URL encrypted, note there is no change to the content of the XML just how it is presented. I have included the newer spec doc but it should be a simple process. endquote I am at a loss on how to update or replace this extension. The links in the email take me to a blank page. The attachment is confusing, but you might be able to make sense of it. ...
I'm in need of an expert to assist with the cleanup of our Medicine database. The goal of this project is to accurately remove all duplicate entries improving the overall accuracy of the data. Ideal Skills & Experience: - Strong background in Database / Excel /CSV management, specifically in the medical field. - Proven track record of similar past work. In your application, please include details of similar projects you've worked on. Efficiency and precision are pivotal for this task. Looking forward to a neat and streamlined database!
I need a professional with experience in Odoo to implement accounting reports in Odoo saas~16.3+e (Enterprise Edition). The reports should be exportable as XLSX or CSV files. Required Reports: 1- Account Payables Display tabs for each supplier. Information on invoices issued, quantity, and payment dates. 2-Inventory Summary Display existing inventory as of a specific date. Price and cost information. 3-Sales Tax Display total sales within a specified time period. Consider both taxed and untaxed sales. Additional Features: *Ability to specify dates for the report results. Example: For the "Inventory Summary FEB 2024" report, be able to search for results for January or other previous months. Access and Meeting: Upon project acceptance, access to our Odoo system will be p...
...The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work with the specified technologies. Your ability to deliver a professional, well-structured, and visually appealing report within the give...
As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.
I'm seeking a highly skilled programmer proficient in Excel macros and ODBC data connections to automate critical processes in my business. Specifically, your tasks will involve: - Automating order tracking, inventory management, and vendor communication processes. - Connecting to Excel files, SQL databases, and CSV files using ODBC. - Developing an automated procurement system capable of: - Generating purchase requisitions, - Aiding in vendor selection and negotiation, - Creating and tracking purchase orders. Proficiency in utilizing Excel macros is a must, and experience with ODBC data connections and related platforms is highly desirable. Knowledge of procurement systems and order logistics would be beneficial. Successful completion of this project requires strong c...
2 excel files with VBA macro as per customer requirement
One excel file with macro as per the customer requirement
I need an experienced Python developer with solid skills in webscraping to gather data from the Premier League's stats page (). The required task involves capturing all available statistics and organizing them into rows and columns within a single CSV file: every season is a row, with different statistics as columns. Applicants should be able to provide the following: - Evidence of past work, particularly related to webscraping. - Their robust experience in Python language and relevant industries. - Detailed project proposals outlining strategy and timeline. Given specified needs, Python is the preferred programming language for this project. Previous experience in similar webscraping projects is desirable, demonstrating your ability to
I need to gather emails from: https://alaskabar(.org)/for-lawyers/member-directories/ Need it in CSV
...payment and number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, where you w...
This project is open only to individuals. Agencies need not apply. Freelancers with no rating need not apply. Generic copy-paste responses will be marked as spam. Your past freelance feedback should clearly show that you have completed similar tasks. I require a specialist in web scraping to extract the body text from articles on Google News. The information wi...extract the body of the news articles with no need for the title, date or author. Let me know your approach and estimated timeframe for completion and budget. I give you (English only) - Google News search keywords, (possibly 500K-1M news articles) You give me - excel file with two columns (possibly split excel file based on year/month) A- URL to the news article B- article body (no photo, video or XML tags, ONLY text of...
Looking to develop a hiking App in Flutter. Key Requirements: 1: It will need to work both online and offline and display/use offline maps. (Normally a topo map. ) 2: It will need to allow the user to select different layers to display, eg / tracks / waterways / POI. These could be Polygon shape files, CSV files, KML or GEOJSON files. 3: It will need allow the user to save: tracks as they hike around, POIs, and maybe take a photo at a point and Geolocate it? 4: User will need to be able to add/save waypoints 5: User will need to be able to select items in KML /shape files to display data.
I'm in need of a skillful developer experienced i...TNT ... quote There is a change coming to the TNT RTT API, this is what you use to get pricing for shipping on your online store or internal system. Please have this email directed to whomever controls the online portal: You are currently using the ASP version of the RTT service, and we need customers to move to our .NET version. This will require that the XML payload is URL encrypted, note there is no change to the content of the XML just how it is presented. I have included the newer spec doc but it should be a simple process. endquote I am at a loss on how to update or replace this extension. The links in the email take me to a blank page. The attachment is confusing, but you might be able to make sense of it. ...
I need an experienced data scraper to extract specific financial information from the NASDAQ and HKEX stock markets. Your task will be to focus on: - Stock prices - Company financials - Last 5 Years ROE - Last 5 Years EPS - NAV - P/E Ratio - P/B Ratio -Net Cash Flow Other econo...Company financials - Last 5 Years ROE - Last 5 Years EPS - NAV - P/E Ratio - P/B Ratio -Net Cash Flow Other economic indicators(US & HK) -Interest rate -Unemployment rate -Inflation rate The ideal freelancer for this job should have experience in data scraping and familiarity with financial data. The requirements involve pulling data from the past five years. All data should be delivered in a CSV file format. The ability to achieve high-accuracy and precision in data extraction is critical ...
...task is to build an online marketplace utilizing the Motta theme. Key features that are integral to this project include: - Product listing: This should be managed by a bulk upload method through my csv file. - User registration: Allow for a simple and secure sign-up procedure for our customers. - Payment gateway integration: Ideally, this should be a secure, trusted, and well-known service. All website hosting will be executed through Hostinger for this project. Additionally, I will be supplying all the content needed for the website, so no content creation services are needed. WordPress-centric
This project is open only to individuals. Agencies need not apply. Freelancers with no rating need not apply. Generic copy-paste responses will be marked as spam. Your past freelance feedback should clearly show that you have completed similar tasks. I require a specialist in web scraping to extract the body text from articles on Google News. The information will b...the body of the news articles with no need for the title, date or author. Let me know your approach and estimated timeframe for completion and budget. I give you (English only) - Google News search keywords, (possibly 500K-1M news articles) You give me - excel file with two columns (possibly split excel file based on year/month) A- URL to the news article B- article body (no photo, video or XML tags, ONLY text of...
As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to delivering high quality and defect-f...
I'm seeking an expert to merge and de-dupe around 700 account / contact records to enable us to obtain a clear deduped prospecting list to be uploaded into a CRM like HubSpot. The records will need to be deduped using a specific criteria to ensure that all unique information is kept for each account. The list is currently in Excel/CSV file format. Each contact record encapsulates around 10 key fields: Customer type and association, Store Name, Contact Name, Email, Phone, Mobile, Email, Address, Job Title and notes. Ideal Skills and Experience: - Proficiency in Excel and other spreadsheet tools - Experience with data cleansing and deduplication - Attention to detail and accuracy - Experience with handling sensitive data securely Tasks Involved: - Merging duplicate contacts (b...
I'm looking for a skilled WordPress developer to assist me in creating a custom, multipage form using Contact Form 7. This form will have a unique require...address - Stored in a specific page inside WordPress dashboard, already configured Furthermore, I require the setup of an export mechanism for this incomplete data, specifically in a CSV format. This CSV should: - Have separate columns for each field to ensure easy data processing - Include timestamps for each form submission for traceability and analysis. The ideal candidate should be proficient in WordPress development, especially with Contact Form 7 plugin integration. Experience in setting up and managing multipage logic for forms is a plus. Additionally, knowledge of data handling and export in CSV ...
I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.
Specification: Facebook-Web-Scraping and Web-Crawling Write Swift Code that prompts the user to give username and password This information is used to login to facebook and scrape facebook for facebook friends and extract the following information: - Name - Birthday and month and if available year - Gender This information should be made available in a JSON or XML format. The code will be embedded in an app. It is important that this web-scraping activity can run in the background of the app invisible to the user.
As a data enthusiastic business, we're seeking a talented freelancer who can design an effective Power BI Dashboard to integrate various data sources including Excel spreadsheets, CSV files, and SQL databases. The ideal freelancer would: - Have extensive experience with Power BI and DAX language integration. - Demonstrate an excellent grasp of designing dashboards that report on KPIs. - Be well-versed with creating DAX calculations in the Power BI environment. We require the dashboard to focus on specific metrics, therefore, a strong understanding of reporting on KPIs using DAX language is a must. Additional Skills: - Proficient in Microsoft Excel and SQL databases. - Understanding of data integration and reporting. - High attention to detail. We're excited to colla...
I need an Excel...Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Experience in creating tools that can handle daily data updates would be ideal. If you have experience with similar projects, please provide example...
...product data from XML sheets. The data needs to be imported into multiple Prestashop faced search feature tables. Key project details: - I need the product information to be imported - The data needs to be updated daily and in real-time - Multilingual support is not required, so a single language is sufficient Ideal Skills and Experience - Proficiency in working with XML data and importing it into systems - Expertise in Prestashop and its search feature tables - Experience with real-time data updates in web applications - Strong problem-solving skills and attention to detail Import data from xml sheets into multiple prestashop faced search feature table. Here's an outline of the tasks Script to Parse XML for Nightly Update: This script will run on...
I am seeking an experienced Dynamics CRM 365 developer with Virtu...it in two different ways but it doesn't work. Method 1: I created fetchXML and link two tables, I get the result but issue is records don't filter in query. I tried this method with advance find as well, and again records don't filter according to criteria for virtual entity. in Advance find, if I try to select the columns from second table then I get error. Methos 2: I tried to create Fetch XML query and use addCustomView method. This method works if filter criteria is small. If I pass filter for say 50 GUIDS then this query does not return any records. I think addCustomView makes rest call and pass all filters in URL. and this URL is too big. Are you able to investigate / fix this issue for me...
I'm looking for a professional programmer, proficient in Python to craft a script. This script is for the main p...Python to craft a script. This script is for the main purpose of finding mobile numbers, identifying their carrier, and matching this information with corresponding zip codes. This process is vital for my verification purposes. Not only this, but your script must provide these details in a CSV file output format. Key requirements are: - Extensive knowledge and experience in Python - Experience in number location and carrier identification script writing is a plus - Knowledge of data presentation in CSV format This task requires high attention to detail and a strong understanding of number location matching technology. If you meet this description, I'...
I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.
This is a Python-based project involving LinkedIn connections parsing using a cookie file. The target is to uncover and analyze mutual connections between my personal friend's list and a CRM file. Important Aspects: - The script needs to efficiently ...existing client database is distinctly relevant. - I also need the parser to generate records of connections between my LinkedIn friends and contacts in my CRM. - I would require the output to be well-organized and easy to navigate. It should be exportable and storable both as a CSV file and an Excel spreadsheet. Ideal Skills and Experience: - Proficiency in Python for web scraping and data handling - Experience in working with LinkedIn's data structure and APIs - Demonstrated expertise in managing and exporting data in ...
I have an existing VBA application that performs various calculations. I need to convert the VBA application to a Python-based desktop application. Key Requirements: - The converted application should perform the same calculations as the original VBA application. - The application should have a user-friendly GUI for easy input and output. - I am looking for a programmer with experience in both VBA and Python, to ensure a smooth and accurate conversion. Ideal Skills: - Strong proficiency in VBA and Python. - Experience in desktop application development. - Knowledge in creating user-friendly GUIs. - Ability to accurately replicate functionality from VBA to Python.
I am looking for a skillful freelancer who can assist me in converting an Excel spreadsheet into a daily calendar schedule like this: Key Requirements: - You must have a firm understanding of Excel and calendar scheduling. - You must be capable of adjusting the Excel data to fit into a daily calendar layout. All data will be up...skillful freelancer who can assist me in converting an Excel spreadsheet into a daily calendar schedule like this: Key Requirements: - You must have a firm understanding of Excel and calendar scheduling. - You must be capable of adjusting the Excel data to fit into a daily calendar layout. All data will be uploaded by an excel spreadsheet or .csv file
...create a flow that will automate the discount application process on my Shopify store from a Google Sheets CSV. Key Requirements: - The ZAP should identify new email addresses added to the CSV, and then add a customer tag "REGATHLETE" to them in Shopify. When the tag is added, they will be eligible to use that discount, as we have already created a customer segment for customers with the tag. - The ZAP must be able to add the tag both to new and existing customers in our Shopify database. Required Skills: - Proficiency in working with Zapier - Experience in creating Zaps with google sheets and matching CSV/data fields - Experience in automating processes and dealing with CSV files. The timeline is asap, and the budget for this is &poun...
