Media Files Export
If your form includes an image , video, or audio recording question, these files will be uploaded to the server along with your other data. When exporting your dataset in CSV or Excel formats these files will include links to the filenames of the media attachments, but not the files themselves.
Downloading media files
To download a single media file, navigate to the form’s Table view then right click on the file link and select Save link as to download it.
You can download all the media files in one folder by selecting the ZIP folder of media attachments option under the Export data section of the form’s Overview page.
For a large number of collected media files, you can use a download manager/accelerator to download the files as quickly as possible. The download manager allows you to pause and resume the download. Below is a step by step guide on how to use a download manager.
Add direct hyperlinks to collected media in Excel
- Download your data in Excel format and open the file
- If the media data is referenced by the image name (i.e. Mango-17_3_5.jpeg):
- In a new column next to the one that contains the filenames of your images, enter the following formula: =HYPERLINK(“https://ona.io/attachment/original?media_file=username/attachments/”&A2)
- In the formula, replace ‘username’ with your account username and ‘A2’ with the first cell reference that contains the filename of your media data. Then, copy the formula down for all your records.
- If the media data is referenced by a URL (i.e. http://classic.ona.io/api/v1/files/10581059?filename=acme/attachments/370528_pictures_example/Mango-17_3_5.jpeg):
- In a new column next to the one that contains the URL of your images, enter the following formula: =HYPERLINK(A2)
- In the formula, replace ‘A2’ with the first cell reference that contains the filename of your media data. Then, copy the formula down for all your records.
Create an alternative batch download of collected media
- Save your Excel file with the added hyperlinks (see instructions above) as an HTML file to your Desktop, using the File > Save as… option (choose ‘Web page’)
- Download and install JDownloader for your operating system
- Open JDownloader
- Open the Excel file saved as an HTML file with your browser (Chrome or Firefox recommended)
- Copy the URL
- In JDownloader, click Add New Links
- A window will open. Paste the file’s copied URL into the top box (shown below in the red box).
- Next to the Save icon (second box), click Browse and select the location you want the files to be saved to. Click Save.
- Click Continue.
- This will launch JDownloader’s LinkGrabber to verify a file is available to download via the URL provided.
- In JDownloader, click the second tab LinkGrabber
- You can start the downloading by clicking Start all Downloads or the Start Icon
- Optional: In the Download Tab, click the tools icon (shown below by the red arrow). In that window, you can set the download speed limit to avoid using all available bandwidth. You can also set the max chunks per downloads and maximum number of simultaneous downloads.
If you have a lot of media files, this will take a while to download. But the JDownloader will make sure you have downloaded all the images and let you know in case any of them were not downloaded so you can try again.