Excel import/export

The contents of a DDA table can be exported from the “View” dialog, in excel or csv format. The upload dialog can be used to import spreadsheet contents into the DDA table – use an export as a sample to derive the right format for the spreadsheet.

i The field separator is the comma in English, and the semi-column in French.

The contents of the file can either fully replace the current DDA contents, or be merged into it. This option is available in the console :

The import itself is done in two stages :

1.       The file is loaded in ProactivePack (so, it is NOT immediately pushed to the DDA table) and available for viewing. Any data that does not comply with a regular expression verification will be marked in red and a tooltip will provide details :

2.       The data are imported into the cell. If any data was identified as invalid in stage 1, the import remains possible if the user has the permission ImportExcelBlockOnValidationFail set to 0. A warning shows in that case.