Is there a way to mass-download all files that were uploaded through a form?

  • Profile Image
    MarquetteOSCM
    Asked on April 09, 2014 at 12:33 PM

    We need to periodically download and clear out all info submitted, including the files that users uploaded as part of the form.  Is there a way to download all uploaded files at once, even if it's a bit messy?  We just need it for archival purposes.  Thank you!

  • Profile Image
    EliezerN
    Answered on April 09, 2014 at 01:41 PM

    Hi

    You can export your submission data including the uploaded files to Excel, CSV and PDF format and then delete them all from the submissions page. Here is how to export the submission data to any of the format mendtioned before: How to download form submission as Excel/CSV/PDF?

    Or you can download the uploaded files you have received through your forms by using our File Downloader app: http://apps.jotform.com/app/file_downloader

    Then you can proceed to delete your submissions. Please note that this app will download the uploaded files of all your forms, not of the one specific form.

    Please let us know if you need further assistance with this inquiry.

    Thanks

  • Profile Image
    MarquetteOSCM
    Answered on April 09, 2014 at 01:54 PM

    OK, thanks, the file downloader functionality is what I'm looking for.

    BUT- the link just shows me the programming code, how do I actually integrate or run it?

  • Profile Image
    Mike_T
    Answered on April 09, 2014 at 03:20 PM

    That App is not trivial, but we should be able to use it.

    The script is written in ruby language, so here are the steps to use it:

    1. First of all, you will need to have ruby installed on your machine. If you are on a Linux/Mac, it is most likely that you have it pre-installed, and for Windows you will need to do manuall installation.

    The easy way to install Ruby on Windows:

    http://rubyinstaller.org/

    To make sure that the ruby programming language is installed on your machine you can run:

    ruby -v

    Example of successful output from a Windows computer:

    2. Create some folder on your computer and download downloadUploadedFiles.rb & JotForm.rb files to that folder. Those files are available through https://github.com/jotform/api-use-cases/tree/master/ruby-uploaded-files-downloader

    In my case it is a down folder.

    3. Press Win key and run cmd.exe command to launch the Windows console.

    Then, go to the folder with downloaded scripts using console. In my case it is a C:\Users\admin\Desktop\down path, so the command is:

    cd C:\Users\admin\Desktop\down

    And run the following command in order to run the download script:

    ruby downloadUploadedFiles.rb {apiKey} {formID

    Where {apiKey} is your JotForm Account API Key and {formID} is the ID of the form in question.

    Example:

    Also, my colleague Kade has updated instructions on the File Downloader App page.

    If you need any further assistance on this, please let us know.

  • Profile Image
    deadcenterfilm
    Answered on June 03, 2014 at 12:52 AM

    Can you please post a step-by-step for Mac users?