Use VBSCRIPT as the programming language in a .vbs file to extract various details of a complete directory of dozens of Excel .xlsx files each with multiple Worksheet Tabs in every Excel file each containing multiple Column Name Headers into a single CSV file with a single row for each of the unique Excel .xlsx Worksheet Tabs in the Workbook and all
...that all use the same Point of Sale software (Junction 6). This software has been configured to generate and email a daily sales report once every 24 hours that attaches as a .csv breakdown of sales every day. We would like this dropped into a Google Sheet so that we can have an Automatic Daily updated report (dashboards are linked to this Google Sheet)
Hello! Who can write me a script, which is catching the csv file from my wholeseller to my ftp server? With Cron every 20 minutes? My wholeseller has an open api to catch it. Here is the documentation: [login to view URL] Thanks!
I am searching for a skilled freelancer who is able to grab a decent amount of products from an online shop which the link i will give you later on. Datas I need in that .csv file are: product-title product-price product-description image 1-x product-category product-subcategory technical-informations ATTENTION: I need everything in the correct formatting
...and PHP as well as the importation of large CSV files to go through this in more detail. We need offers offers from companies who can resolve this within 2 days. we are able to provide some initial test data in CSV format for you to load which would be a 25 product CSV sheet. We can then provide a larger CSV to test after this although no matter what
My company buys used electronics. We have a web s...site designed in wordpress. We have a excell spreadsheet (CSV) file. We update our prices for our products and upload this to wordpress. This csv file then updates the web site. We are having issues with getting the file to update the Mysql database. You must be a DB pro and be good...
There is a simple AWS MySQL database set up. There is also a Shiny visualisation script already implemented that takes local CSV data file and then hosts the visualisation on shinyapps.io. The goal is to have Shiny Server OpenSource on AWS powering a Shiny visualisation on a custom domain. And the data powering this visualisation will need to be
I need to pull data from a legacy Cobol application. I don't have...application. I don't have much information about it, but I know it relies on .vix and .dat files for its database. What I need is a consulting about the better approach to extract data from those files and create csv files. The goal is to populate a SQL database with that legacy data.
...page you will find two things a. a set of long and lat defining a polygon for the city name provided. a: you will get those long and lat and put in a CSV file as one record in the following format City Name, Sub City Name, Date Retrieved, State, Points of polygon (would be lat , long | next point....)
I need a PHP script that will allow a user to select and upload a csv file and then map the csv data to the correct fields in the database. During the import process I need the script to either insert a field into the csv file (subuserid) OR insert the subuserid into the imported records. The subuserid field is coming from a cookie. The data that
we need to read csv file. in row metadata wise need to create as document in one folder in filenet. we need to maintian mutliple version of docuemnts. For more details we will send email if u understand requirement.
Main Task: 1. Download the distributors (currently 3 distributor) flat file from their respective ftp site to our server. Daily basis. Automation through crone job. Also able to import manually. Sub-Task: At admin panel there should be Top Menu like Focaas Distributors>Manage Distributors. Clicking Manage Distributors will open up grid. Able to add
I need a complete Data Extraction from a Prestashop instance. Get me the data inside a CSV / XLS file I need the following fields: * Product Short Description * Product Long Descritpion Tab * Product Data Sheet exploded in separated fields
I have the following code that when writing csv will split csvbody by comma, CSVWriter writer = new CSVWriter(new FileWriter(datasheet), CSVWriter.DEFAULT_SEPARATOR,CSVWriter.NO_QUOTE_CHARACTER); [login to view URL](csvBody); but my csvBody which is a List<String> looks like "a","b","c", "e,f,g" so after splitting, "e,f,g" wi...
E vorba despre cateva mii de produse care trebuie adugate cat mai repede. De aceea voi angaja mai multi oameni care vor adauga in .csv. Experienta nu e necesarea dar starduinta de a invata si de face lucrurile bine da. Ar trebuie sa stii sa operezi un pc si sa stii putin excel. De preferat sa fii genul care cauta si gaseste solutii daca ceva nu merge
Every day I have around 10-15 CSV files. They all have the same colums and can be easily merged into one txt. file. I have already a script for this. What I want now is for someone to deliver me a solution so that I can automatically delete certain rows, that contains certain values. The CSV files are saved on a FTPS. I want to extract them, and
...currently run a python code to download a csv of todays stock data and update an excel database with todays stock data. I want to be able to run my program on my computer but have some sort of script (preferably php) that would allow me to easily update a mysql database to be the same as my excel database with the updated information. So in s...
...CRUD application with this function : Create (in a pop up form), edit, update and delete posts with MySQL database for three tables example: (products , category , attribute ). Also with this features: 1- print 2- export to Excel , PDF (with custom header) , CSV 3- upload CSV file 4- search (results in table) 5- pagination Also i need a form
...- Cat 1, ImportId1 Row 3 - Cat 2, ImportId1 Row 4 - Company B, ImportId2 Row 5 - Cat 2, ImportId2 I want some code which can be run in a console or Azure function to update the SQL Azure tables with new customers and categories, linking up the company to categories. New Customers should be added to a Customers Table New Categories should
...Overview: We need a simple relational database developed that has search and download functionality. This database needs to be written in MySQL. This database needs to be built to accommodate a large number of user accounts. Searchable Relational Database Functionality: Our data is contained in 500+ CSV files totaling over 30 gigabytes in siz...
...somebody who is skilled in PowerShell scripting. We get an *.xls file, which your script should: 1. convert to csv 2. one column (A3, B3, C3 and so on) contains values like 1,2 or 3. these should be multiplicated by 5; so add a column to the csv file where x = A3 * 5 3. save it as csv We have a lot of these small projects and tasks so if you are
Tasl: Convert an CSV data file into MT940 format for Rabobank The CSV file contains bank transactions. This needs to be converted into MT940 format. Prefer Freelancers who work in the banking and finance industry and thos ethat are experts in SWIFT messaging and MT940. Computer experts and payments experts please apply. Please qualified
I want to create PHP CRUD application with this function : Create, edit, update and delete posts with MySQL database for three tables example: (products , category , attribute ). also with this features: 1- print 2- export to Excel , PDF , CSV 3- upload CSV file 4- search 5- pagination and the page should be two part the first part is the
...: Task 1 : We need to override wordpress core and modify password recovery functionality. When Users ask for password recovery, we need to send him actual password. On database structure, we need to add a field with password not crypted. On recovery, force the system to use that password. All users are added automatically from a custom plugin.
...United States, and if you do a good job here then we will likely have more work for you. You will be given a cPanel Linux server on which to do the dev with access to a mySQL database. Please also let us know what language you will program this system in. No Microsoft languages - software must run on linux sever. The system will require a very minimal
Create a scripts in Python (I suppose two), which will download data from Yahoo Finance and save it to CSV files and to MySQL. You can use a library to download data from finance.yahoo.com. The source is a TXT file with stock symbols (attached file – [login to view URL]). I need to be able to set the start date and end date. Downloaded data history is
Scrap Auto parts from PDF or converted Excel file to CSV for upload to shopify. Upload all parts into shopify theme with year, make, model, and engine size search. Will provide site details via PM.
I need a set of php APIs which will store data from my mobile client application into mysql Database. Critical fields will be encoded with JWT and stored in the DB. 1. User credentials will be stored from Mobile Client registration screens and stored via API call to php API. Password will be stored with JWT. 2. Login from Mobile client application
We need to cross reference information from 5 CSV files into one. Each file has 400,000 + products descriptions, weights, costs, rates, etc. The expected results are: 1) a CSV to upload to shopify. With fields Handle, Title, Body (HTML), Vendor, Type, Tags, Published, Option1 Name, Option1 Value, Option2 Name, Option2 Value, Option3 Name, Option3
...must be in yyyy-MM-dd format in database Q 1 - Process Consumer Complaint file A only as per instructions below 1) Read file A, remove duplicates; load to table Consumer_Complaints; 2) Print no of records processing at the count of 5000, and total count in console Q 2 – Process multiple consumer complaints file as per instructions below – 1)
Node.js webpage to do maths: data are taken from a provided csv file User would upload the csv file and do some queries: filter rows with a dropdown menu. The node.js page would show maths results based on user's query.
Hey I'm wondering if it is possible to create some code so I can import csv data into my app (I use [login to view URL]) via an API call or similar. My CSV data is a pricelist and may have up to 5000 items
I need to have my catalogue copied from Ebay to Walmart Marketplace via formatted excel file. This would include all item specifics and images. We have approximately 400 sku's.
...idea on how to help us. -We want to upload over 500,000 products to our Shopify shop, the products are in CSV files, Organized and ready to upload and matching with Shopify requirements. -Shopify currently allow each shop upload only 1 CSV each time. We want to find a creative way to upload our products without have to wait months for this process
...after uploading post using bulk csv file, all the post are getting uploaded to site well but if there is some changes on csv file like price if I upload the new csv file with new product price its creates new post on the site. so basically I want " Update existing posts with changed data in excel csv file and if the csv...
Hi, I need assistance with altering my CSV file for my POS system using Vend. We have all the details in the CSV file but its not set out how i want it to be, i just need you to adjust so that it all works as i need it. For example we have a range of different hi vis polos and i want it to come u seperate on the POS system but currently they all
I need you to develop some software for me. I would like this software to be developed for Windows . Existing simple CSV processing Python program, adjustments needed. Adjust simple operations, display in GUI and the addition of a final output.
Hello Freelancers! I own a Shopify website and need someone to input a CSV file of website products into the correct format for Shopify(reference link) [login to view URL] in order for me to upload these products to my website. For someone who knows what they are doing this is a very easy job. If done
...has ended, the next product automatically is displayed. I would need that the details of the product, and the final going price for each product is saved, and apprended to a CSV with the date, description of the product, and the final price. The crawler also needs to take care of authenticating with the website. The flow of events is that the crawler
Data not present in the catalog has to be ignored. Freelancer has to try import csv file in Prestashop before send me the definitive file (has to know prestashop)
I want to required Inventory Features PhP Script with some Special CSV Imports the following feature are required. All System is Departmental wise and multi companies and multi warehouses Sales Department 1. Import Orders Multi Company Wise, Multi Store Wise, Manual Orders and Sales Reports 2. Different Steps for Processing Orders for attachment
My wordpress shop site is up and running and previous developer has already customised WooCommerce Customer/Order CSV Export plugin but i want some fixes in the checkout form and hence added to the export csv. fixes: In checkout form 1. We sell in Cyprus and Greece. If Cyprus is selected then a drop down menu should appear to select closest