FTP File Format

  • Profile Image
    rgoddard
    Asked on February 01, 2013 at 09:58 AM

    I have created a form that submits uploads to my FTP Server.  But the format is PDF.  How to I change this to be a CSV file or Excel?

  • Profile Image
    Welvin
    Answered on February 01, 2013 at 01:22 PM

    Hi,

    Unfortunately, there is no way you can change it to CSV or Excel file. All submissions are in PDF Format, just like Dropbox.

     

    Thanks

  • Profile Image
    rgoddard
    Answered on February 01, 2013 at 04:23 PM

    How do I get a csv or excel file to be automaticlly transferred to my server from my JotForm so that I can process it?

  • Profile Image
    jonathan
    Answered on February 01, 2013 at 06:00 PM

    Hi,

    Can you please clarify more on your initial inquiry. To my knowledge, if you integrate the form to FTP, your uploaded file will not change to PDF format. You can actually use this feature to upload your files to your own FTP server.

    Here is my test form that I have integrated to FTP http://jotformpro.com/form/30316549111950

    When I uploaded a .csv  file.. it remains a csv file that I can now access on my ftp server.

     

    Please inform us if you have more inquiry.

    Thanks.

     

  • Profile Image
    rgoddard
    Answered on February 01, 2013 at 06:08 PM

    Under the submissions tab, where you set up your FTP information, there is no abillity to change the format of the fie.  It transfer to the FTP server as a PDF.  These are the steps I followed:

    http://www.jotform.com/help/177-How-to-Enable-FTP-on-Form-Submissions

    How do you integrate a form to FTP?

    thx

     

  • Profile Image
    jonathan
    Answered on February 01, 2013 at 06:24 PM


    "http://www.jotform.com/help/177-How-to-Enable-FTP-on-Form-Submissions

    How do you integrate a form to FTP?"

    This is also the guide I used.

    As you can see on my resulting ftp screen, my uploaded csv file is now located in my ftp server. The added pdf file is an additional docs for the uploads generated by the system.

    Did you integrate the form to FTP? Are you able to transfer the files as is (i.e. csv) on your server? Tell us if this is not what is happening on your end.

    Thanks.

  • Profile Image
    rgoddard
    Answered on February 01, 2013 at 06:39 PM

    I see the pdf file on my ftp server.  I don't have a csv though ...  I am not sure what you mean by "integrate the form to FTP"

     

     

  • Profile Image
    jonathan
    Answered on February 01, 2013 at 06:43 PM

    You have to upload the file... in the upload field (My Photo), then submit the form.

    I checked your test submissions, your last test do not have an uploaded file on it.

    Thanks.

  • Profile Image
    jonathan
    Answered on February 01, 2013 at 06:46 PM

    Try also test my form

    http://jotformpro.com/form/30316549111950

    Upload your csv file or any file. And I'll check my ftp server if your uploaded file is there.

    Thanks.

  • Profile Image
    rgoddard
    Answered on February 01, 2013 at 08:55 PM

    I am not trying to just add a csv file to my form like I would a photo.  I want the form data intself to be in a csv file.

    I need to access the data that the user entered.  In a PDF file, I can't pul the data out.

  • Profile Image
    jonathan
    Answered on February 01, 2013 at 09:05 PM

    OK. Thank you for the clarifications.

    Are you perhaps looking for this instead -Create-a-CSV-Report

    Or like this -How-to-Download-Form-Submissions-to-Excel-CSV-PDF.

    This 2 method will allow you to have csv formatted data out of your form's submissions.

    Thanks.

  • Profile Image
    rgoddard
    Answered on February 01, 2013 at 09:09 PM

    It has to get the ftp server automaticlly .. with our somewhat creating a report or expoting it ...  thx

  • Profile Image
    EltonCris
    Answered on February 02, 2013 at 03:09 AM

    @rgoddard

    Sorry but we do not have feature where CSV is generated every form submissions. There's no other submisisons format available other than PDF submisions file. The best way to achieve that for now is to upload your submissions CSV file manually by exporting your form submissions to CSV and upload it to your FTP server.

    Also, how about creating a report where you can view all the data just like HTML Table Listing Report? This may not sound to be related but I think it would help. :)

    Thanks!

  • Profile Image
    benchappers
    Answered on March 21, 2017 at 12:54 PM

    So four years down the line are we now able to export the data in csv or txt format?
  • Profile Image
    Nik_C
    Answered on March 21, 2017 at 03:27 PM

    @benchappers,

    I opened a separate thread for you and we will attend it here: https://www.jotform.com/answers/1097976.

    Thank you!