I need to set up an excel form for csv to import file to an ftp

  • Profile Image
    geminicocoa
    Asked 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.

     

    1

    35045,,PO13203291,,FIL,

    John Doe,161 Willow Mill Park Road,,Mechanicsburg,PA,17050,,A,5001

    200931,,3,,,

    ***EOF***

     

  • Profile Image
    BDAVID
    Answered 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