Imports

Imports work from CSV files (and only CSV files on actual version V1.3.0).

The first line of the file must contain de name of the fields : look into the database, or in the Model class : the names are the same.
You may or may not add an "id" column to the file :
- if column "id" exists and "id" is set for a line, the import will try to update the corresponding element, and will fail if it does not exist
- if column "id" does not exists or if "id" is not set for a line, the import will create a new element from the data.

In any case, columns with no data will not be updated : then you can update only one filed on an element.
To clear a data, enter the value "NULL" (not case sensitive).

For columns correponding to linked tables ("idXxxx"), you can indicate as the column name :
- either "idXxxx" : the code of the element in the linked table is expected
- either "Xxxx" (without "id") : the name of the element in the linked table is then expected, bringing better readability to the file.

Names of columns can contain spaces (to have better readability) : the spaces will be removed to get the name of the column.

Insertion into "Planning" elements (activity, project), automatically inserts an element in the table PlanningElement : the data of this table can be inserted into the import file (working from version V1.3.0).

Have great imports !

Is there a bug? Where could I find more information on the import function?

In the online manual

You can also have description of expected format on the import screen, using the help button.

Another helpfull way is to export an existing list, using CSV export from list view : it is directly importable

'Comma' Separated File is default format.
In France, default separator for csv is semi-column.

The separator can be choosen in the Global parameters screen.