How to bulk upload documents and field values from the user interface?

Tabla de contenidos

Bulk uploads in Athento are performed at the form or document type level. That is, all documents uploaded in bulk will have the same document type.

This bulk upload functionality allows you to upload many files to Athento with their field values or metadata at the same time. In order to use this functionality, you need to have administration permissions on the form in which you want to use it.

Bulk upload is accessed from the form from which you want to perform the upload. You must go to the Document Types or Forms menu and then to the specific form on which you need to perform the bulk upload.

In the Form, go to the Import tab.

Within the Import tab.

Load values or metadata

Loading metadata values is done using a CSV file.

This file must contain the details of the names of the documents to be uploaded and the corresponding metadata. The first column of the CSV must be the name of each file to be uploaded (including the file extension), for example: File name.pdf. The following columns will be the metadata; thus, the number of columns will depend on the amount of metadata in our document type.

In the Load new files or Upload new files tab, Athento will ask you to upload the CSV file.

  1. Select the csv file.
  2. Select the separator to use; it must be the default one, semicolon (;)
  3. Select the space where the records will be created.
  4. Select the processing status of the documents to be uploaded. If this is not selected, Athento will default to the Draft status.
  5. Select whether existing documents are updated by title or by uuid.
  6. If updating documents by title, select whether documents that do not exist in the system should be created.
  7. Then click Upload or Upload.

Upload the files

Next, in the file upload panel, you must drag or select the files to upload. The file names must match the values in the first column of the CSV file.

Once the file upload is finished, click the "Next" button.

This step can be skipped in cases where what you want to upload in bulk are not documents with a binary (file). That is, it may be the case that, for example, you want to upload case files and only require the bulk creation of the forms with metadata and that they do not have an attached binary.

Indicate column matches with the form fields

Next, for each column in the CSV, you must indicate the corresponding field into which the value should be imported.

At the end, click Process CSV to continue.

It is possible to verify the upload from the "Status Online Import" tab. In the Number of lines (csv) column, the number of records in the uploaded csv will be shown, and in the Number of validated documents column, how many of them have been created in the import process.

In the status column, all loaded records will appear in blue. To view the entire log, you can select "more" and see all the upload details for each line. Likewise, from this log, if the upload for some reason stops on a line, you can see on which line processing stopped and thus be able to perform the upload again in a new file starting from the line that produced the error.

How to make a bulk correction or modification of documents?

Using this functionality, the system allows making a bulk correction to the values of the document fields. To do so, you must follow the same upload process; you just have to take into account the following points:

  1. The first column must contain the title of the document to be corrected. The csv must have the same format for the upload but VERY IMPORTANT, the title or the UUID must be indicated exactly as it appears in Athento.

When uploading the csv, in step 1 of the upload, you must select from the dropdown list the update of the records as appropriate:

  1. No update: When they are new records in the tool
  2. Update usign the filename: Update existing records using the document title
  3. Update usign the uuid: Update existing records using the document uuid

The rest of the upload process will be performed in the same way as the bulk upload.

Update the document lifecycle

Athento also allows bulk updating of the document lifecycle status; following the procedure described above, the csv must have the same format for the upload, but VERY IMPORTANT, the title or the UUID and the lifecycle status must be indicated exactly as it appears in Athento.

When indicating the column match, the first option in the list must be selected

Aspects to consider before launching the upload

  1. The file format must be .csv
  2. The .csv file encoding must be UTF8.
  3. Avoid including accents and special characters in the file header.
  4. The .csv file must not contain line breaks.
  5. Before launching the upload, review the .csv file in a text editor tool, which will allow us to verify that there are no line breaks or any other aspect that is not noticeable from Excel.
  6. Bulk upload does not imply the execution of automations on documents.
  7. If you have autoincrement-type fields, review the instructions that appear further down in this article.

Generating autoincrementals for documents loaded in bulk

When performing bulk uploads in which there are autoincrement-type fields, the following must be considered:

1. Select the Pending processing status

2. Activate the Process documents check on the space

Once the documents have been processed, Athento will assign the corresponding autoincrementals to the documents.

Loading fields that have multiple values

If you need to load values for multi-valued fields, you must do so using the | (pipe) character. Below is an example.

12;blue|red|yellow;October

In this example, the colors (blue. yellow, red) are the different values that will be added to the multi-valued field. Remember that the (;) should only be used to denote new columns.