The Import tab allows to update a Parameter using Excel uploads.
The different options are - the option needs to be selected before selecting the file.
When entries are compared, it is done against the field 'DATA_ID' and not any of the columns.
|•||Delete all current entries, then add new and replace existing : the Parameter is emptied before adding the new entries. Entries that were present before, and are found back, are also edited. Entries that were in the Parameter, but no longer in the uploaded file, are removed. |
|•||Remove entries : when the DataStore finds a match (using DATA_ID) between an existing Entry and the Excel sheet, the Entry will be deleted|
|•||Add new & Replace existing: when the DataStore finds a match between an existing Entry and the Excel sheet, the Entry will be updated. When no match is found, the new Entry is added. Any other existing entry is not changed or removed.|
|•||Add all as new (ignore "data_id" column) : all rows in the excel will be added as new. This can be used when a parameter is copied from one environment to another, then the exported file can be just uploaded and no editing is required. If you want to delete first the current entries, select the first option.|
|•||Only update existing (no new entries are added): when DataStore finds a match (using DATA_ID), the existing Entry is updated. When no match is found, no changes are applied. |