Links

Import your data (Excel, Csv)

Importing data into Dastra

Dastra allows you to easily import your own data in spreadsheet format directly into the application.
Imports are possible in the following modules:
  • import of the record
  • import of actors
  • import of assets
  • import of datasets
  • import of fields
  • import of security measures
  • import of categories of persons concerned
  • import of audit responses
  • import of audit models (to come)
  • import of risk types
  • import of rights exercise requests
  • import of data breaches
  • import of tasks
In each import, the process is the same.
It is done in 4 steps:

1. Preparation of the data file

Dastra supports the following data formats:
  • Excel (.xlsx)
  • Flat files (.csv, .txt) with separator; and UTF-8 encoding (encoding is important to have accents)
  • JSON (Only for the import of the complete record and the treatment models)
To access the data import menu, click on the "import" button under each arrow of the create button.
Select Excel if asked:

2. Download the template file

Then, download a file template by clicking on the "Download file template" button:
The template file is a CSV file that you can easily edit with a Libre Office, Wordpad, Excel or Google Sheet.
This will contain all the necessary columns with sample data.
Example file (for the record):
Line 2 contains example data that must be replaced

Fill in the file template

Fill the downloaded file with your data.
For each data file, you will be able to display the expected values on the columns:
Expected values for the record import file

Load the file

Once your data file is ready, you may need to specify an organizational unit. All imported files will be placed in this organizational unit.
Only object imports that can be attached to organizational units are concerned. For example, the processing record or data breaches. Actors, measures or datasets are not concerned.

Update data via import

It's proposed to check a box allowing to update the existing data.
This feature allows you to update data in Dastra from the data in the Excel file.
By default, the import will create new objects. If the object already exists (an actor for example), the import will not create a new object.
It's possible to update an existing object (for example an actor). In this case, select the "Update to existing data" box and choose the matching field. This field will be the key to identify the fields to be updated.
By clicking on the "Overwrite matched row" button, the corresponding data will be replaced by the data from the import.

Send the file

Send the file by clicking in the zone:
You can also upload your files by dragging and dropping them into the file upload area

3. Check your data

The following utility allows you to validate and possibly choose the columns of your Excel file on the columns expected in import format.
If everything seems to be in order, you can start the data import.

4. Import the data

Start the data import by clicking on the continue button. The import process will then start.

5. That's it!

Congratulations! You have reached the end of this guide! We recommend that you verify that the data has been imported into the tool.