Skip to main content

Export/Import File

  • Files in the worksheet can be downloaded in bulk, and links can also be exported to Excel.

  • When importing Excel files, you can import images or documents into the file field by importing the link to the image or document, which is automatically downloaded and saved by the server to the corresponding file field, while local files cannot be imported directly.

I. Export File​

You can batch export files from one or more file fields in multiple records.

This feature is only available in paid editions.

Entrance to Export File​

Way 1: Batch select and export

Way 2: Export in a view

If the [Export Attachments] button is not showed, it means there is no file field, and if the file field is a field of other worksheets, the files cannot be exported.

Configuration for Exporting​

  • Multiple file fields can be checked when exporting.

  • File naming

    The file name can be composed of three parts, the record title, the name of the file field, and the original name of the file, and a connector can be set between these three parts. As shown in the above figure, San Zhang is the record title, ID photo is the name of the file field, and ID portrait is the original name of the file. In the figure below, only the record title field and name of the file field are selected.

  • Whether to create a folder for each record

    As shown below, the photos of three users are selected to export:

    Create a folder for each record:

    Put them in one folder:

Restrictions on Exporting Files​

  • Export up to 1000 files, if exceeding 1000, only the first 1000 files will be exported ( according to the order in the record list).

  • The total size of files should not exceed 1GB, if exceeding 1GB, only the first 1GB files will be exported (according to the order in the record list).

If the files you select are beyond the limit and cannot be downloaded, you need to reselect the records and download them.

II. Import File​

You can't import local files directly, but you have to save the public and accessible links of images or documents in Excel, which will be automatically downloaded and saved to the corresponding file fields when imported.

Supported formats​

  • Link

    As shown below, write the link to the image or document in the cell, and if you want to import multiple images or documents to a file field, separate the links with an English comma.

    After importing, the name of the attachment is the name in the link, for example, the first in the following figure, the name of the imported image is qGkYtIVfp_107173456.

  • Custom file name + link

    When uploading an attachment, you can set the file name with the extension. Format: Name. Extension (URL). If there are multiple attachments, you need to add English commas.

III. Export File to Excel​

File fields can be exported to Excel along with other fields. Images or documents are exported as links, and users can click the links to view the source files.

Effect:

  1. The exported links are saved in Excel in the format of file name (with extension) and link, separated by a Chinese comma if there are multiple links;

  2. The exported links can be re-imported to generate new files;

  3. When users export files, they will not be checked whether they have viewing or downloading permissions for the attachments and can export directly;

  4. Users need to login to HAP to view the exported links (only need to login once).

Have questions about this article？ Send us feedback