What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
I need to set up an excel form for csv to import file to an ftpAsked by geminicocoa 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
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