...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
We are currently having an issue importing products into Magento 1.9.2 The import will managed around 8 records before it ceases to function. The site currently runs on a shared server using litetspeed. We have already made some modifications to execution time and memory sizes although this doesn't seem to have fixed the issue. It may be a memory
...pre-created SQL Server DataTable (that you define based upon the columns) * Ability to process all CSV Files in a folder (easy - recursive) Datatables needed: 1. Node Database with Unique Identifier and all information in the first 2 rows (see example spreadsheet) 2. Tags Database will use the Unique Identifier for the node to determine which CSV file the
...linux machine. I have a CSV file with around 400,000 entries of the following format: (We'll call this MAIN table) name1, color, date created, notes name2, color, date created, notes name3, color, date created, notes I would want a python script that can take the format above and import the data automatically into the given sql database. From there you'll
...files based on the table's name in the sql query. Each .csv is supposed to have only THAT TABLES data but, when generating the files, it exports all data from the query and it's joins. I also have a script that's supposed to import into another database, based on the .csv file names, those .csv files will import into tables in the...
I need to pull data from a legacy Cobol application. I don't have much information about it, but I know it relies on .vix ...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 a long-term sql expert to work with us in order to import data from different data formats, csv, xml, html to one sqlite file Summary: (Import data from 2000 files to 5 sql files) this will be permanent or at least long-term project details will be shared only with selected freelancers
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.
...as well as an excel file laying out how the tables relate to one another. Some of the functions of the interface/database listed below. Requirements of front end/back end: Will run the sql dB and front end on an in house sql / web server with the ability in the future to move to aws or cloud. Admin interface: Import txt,csv,xls, comma delimited
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
...to import patient information from a csv file with mr number, visit number, admit date ,discharge date etc. If the visit number already exists for that patient it should update only the discharge date. If not it should create a new entry for that patient visit. We are looking for desktop application done in vb.net or c# with access or sql express
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...
...generated from the machine into a CSV file and I now need a process that will open the CSV file and import the values. The solution MUST be a desktop application using Microsoft Access with the SQL back end and VBA as the language inside the access application. There are 6 types of machine so each type will produce a CSV file and the...
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
...do a large scale import, directly into the database for updating and adding products. This would in include adding/updating products, assigning the images, categories and all attributes associated with the ONIX import file. In addition to the ONIX import, there will be an additional inventory position file. This is a CSV file containing SKU...
...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 be added to
Hello I want to Import 25.5 GB CSV database File to Microsoft SQL Sever 2008 & There are 155 columns in this CSV [login to view URL] check attached excel file for columns . Appriximately There are 28 million raw with this database . Once File is imported to SQL Sever Then I want to filter by each columns and export to CSV ...
Need someone who Import EXCEL/CSV file in LARAVEL and check for no duplicates. We're looking for an assistant to help us add products/services to our website importing by preparing CSV file. You'll have to organize this data into a file suitable for our database. You must have previous experience importing CSV files into Laravel as this wi...
...without key fields into SQL. The automated programs I've tried do not work. The Access files have a lot of appends and VB that will need to be converted so nightly batch jobs can import 8-10 source files in CSV and text file format. Some assistance will be needed setting up the nightly batch jobs and automating the import process. Doc...
...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
...with SQL installed, and you will setup AX and do the development into that system, then demonstrate it to me in that system The Development: Create the functionality to export purchase invoices & Vendor details to a CSV file based on a schedule, only new un-exported files each time it runs Then a separate piece of functionality to import purchase
...are all CSV files. I'm interested in having a means to automate the import of these files into separate SQL tables, parsing the data and adding part of the file name to a field within the table. I'm also interested in this import creating a log of the time the file was imported as well as the name of the file imported. The attached...
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.
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
Hello, I want someone who can develop idcard maker desktop app like idjet 360. I want freelancer who can ...I want freelancer who can develop card graphic design interface. I want some custom features there. I want database integration with it and also want all type file import/export(sql,csv,xls,xlxs,pdf,txt,xml) feature. Thanks, Malini D.
...java backend. Your job is to make single page app which will take whatever csv partner sends us, parse it to show data as utf-8, comma as decimal separator, [login to view URL] as date format, add two columns for manually entering additional data, and after finishing send it to sql server with US English formating. It has to have login with user name / password
...(attached php file), but this doesn't seem to be scalable to handle zipcodes. I was thinking SQL would be better, preferably with something on the wordpress admin side where we could upload a CSV with two columns for zipcode and email address. If building the admin side backend is too much work, I'm also fine with using phpmyadmin to import a CSV...
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
...<Overview> This is a QR code/Barcode Scanning App for Events Before the event, user goes to the web control panel, and upload the attendee list by CSV. On the web control panel, I can upload the attendee list by CSV. This has to be done before using the app. On the web control panel, I can see the attendee list. User login to the app, then download the
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 found ...
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 have a file that is created every day that is .csv. It has a whole host of data in it regarding what happened the prior day. I would like to have someone create a program that can import all this data into a dbase, which I don't have created, and have the ability to run 8 queries and export the results. I would prefer SQLite as I do not have access
... 1: Working with CSV files, it takes the filename and "date modified" meta-data from the windows system for each respective file and appends them as two additional columns in each given file (so each csv now contains a column with it's own file name and it's own date modified value which spans the length of rows in the CSV). CSV<...