- geminicocoaAsked on January 30, 2017 at 06:57 PM
I have to use a specific format for ftp for my supplier for importing products and I understand how they want me to set up the file in excel and them convert it over to csv.
My question is how do I get there form to look like what they want with out the headings.
This is what my csv looked like now but they need it formatted with there example below.
CUSTOMER NUMBER PURCHASE ORDER NUMBER TYPE SHIP-TO NAME SHIP-TO ADDRESS 1 SHIP-TO ADDRESS 2 SHIP-TO CITY SHIP-TO STATE SHIP-TO ZIP CODE SHIP-TO PHONE NUMBER SHIP VIA CODE STORE NUMBER UNFI PRODUCT NUMBER QUANTITY
90787 100125 Ann Margaret Beebe 510 Henrietta 5 Algonac MI 48001 5869806366 A 5001 2900023 99999
Please see below, and attached, the format this needs to be provided in. Our system requires this to be in the attached format specifically for orders to successfully flow through.
John Doe,161 Willow Mill Park Road,,Mechanicsburg,PA,17050,,A,5001
- JotForm SupportBDAVIDAnswered on January 30, 2017 at 09:42 PM
Unfortunately, there is not way to change the format the CSV, or Excel submission is downloaded. You will need to do it manually after you download it from your submissions view: https://www.jotform.com/help/73-How-to-Download-Form-Submissions-as-Excel-CSV-PDF