Create / Edit departments in bulk

Before starting

The following help sheet will show you how to import or edit departments in bulk.

Find the department's import module

Go to the cogwheel, then click on "Import". Then choose the "Departments" part: 

mceclip0.png

Create departments in bulk

For creating new departments, a CSV file must be put together with columns for the departments set out according to the tree structure (identified with the "levels") and a column with the codes of these establishments.

Here is an example: 

mceclip2.png

You can now import the file.

Editing departments in bulk

Before editing the departments, you must find those which have already been configured. To do this, add the following text to your Lucca database URL (after ilucca.net): /api/v3/departments?fields=id,name,code,level,isactive 

Here is an example of the result (obtained thanks to a json viewer installed on the internet browser): 

mceclip3.png

You can then copy all the data to an Excel spreadsheet (using a JSON-TO-CSV program that is easy to find online). Here is an example of the result: 

mceclip4.png

The format is different from that of the import, as the ID is used to find the department to be edited. Similarly, the notion of archiving only makes sense for a re-import.

Here are the explanations column by column: 

  • A: It is very important, because it is used to recognize the department concerned
  • B: It indicates the name of the departments
  • C: It indicates the department code
  • D: It identifies the level of the department
  • E: It specifies whether the department is active (true) or if it is to be archived (false)

You can now import the file.

Page content

Was this article helpful?
0 out of 1 found this helpful