Importing Data via the Interface

After creating your custom table, you can import data in order to populate it.

To do so via the user interface, go to the 'Imports' application (Data > Imports) and click on 'Create an import'.

Good to know

Importing data is also possible with Custom Tables APIs.

Choose the type of custom table in which you want to import data. You'll be redirected to the import wizard.

tip

It is also possible to start an import from the 'Tables data' app by selecting a table then 'Import data' from the 'More' button.

Creating an import

1. General data

First, give a name to the import. It will help you find the import execution in the 'In progress' and 'Finished' tabs. This name must therefore be unique.

Then select the entity of the custom table in which you will import data. This will also be the entity of the import.

Finally, select the table in which you want to import data. Only tables stores on the previously selected entity are displayed in the dropdown.

2. Upload file

You will have to upload an import file containing the data that you want to push in your table.

The file can be a CSV or an Excel file. Various separators and formats are available, but must be specified.

• Compression: ZIP, GZIP or None

tip

Compressing the file is not mandatory but can hold more data. Please try to zip your file if your CSV is bigger than the limit of 100MB

• Format: Select if your are import an Excel or a CSV file with semi-colon, comma or tab separator

• Encoding: The supported encodings are UTF-8, UTF 16 Little Endian, ISO-8859-1 and CP1252

File format - specifications

Your file must follow specific constraints in order to be accepted.

• Column names in the file must be identical to the technical name of the fields in Actito (case sensitive)
• The order of the columns is not important
• Mandatory columns must be found in the file. Optional ones can be omitted
• Each column must be unique

tip

Click on the 'Download an example' to download an illustration file containing the structure of your table and the expected value type for each column.

You will obtain a practical example of the format expected for this file.

Good to know

Columns with the technical attributes "creationMoment", "updateMoment" and "id" are ignored during the import.

This means that if you need to carry out a migration of data from one table to another, you can export table data and import them afterward without having to modify the file.

Messages in the interface

If the columns of your file do not match the attributes of your table, the import will not be accepted and an error message will be displayed.

3. Loading parameters

You will consequently need to specify the import parameters, which means defining the behavior of existing records.

• Hybrid mode "Update/Creation": All lines are taken into account. If an existing row is found, it is updated. If no corresponding row is found, a new row is created.
• "Creation only": Only lines leading to the creation of a new line are taken into account. You will therefore only add new records to the database.
• "Update only": Only lines that lead to a row update are taken into account. This mode can be used for tables for which a data update is relevant.

4. Summary

The last step gives you a summary of the previous steps. It notably gives you all the information of the file uploaded at step 2, such as its format, the number of rows and the headers of the columns.

This lets you double check that you uploaded the correct file before you launch the import.

Checking your import results

After launching your import, it will appear in the 'In progress' tab until it is completed. This can take between a few seconds to a few minutes, depending on the volume of imported data.

To check the import results and analyse the possible error files, please see the Finished execution section in the Data imports section.