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):
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:
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.
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:
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.
Dernière mise à jour
Cet article vous a-t-il été utile ?
