Navigation:  Admin Panel > DataStore > DataStore: Existing Parameters >

Automated import

Previous pageReturn to chapter overviewNext page

We described on the previous page a manual import. Importing can also be automated, where SSP will look for file(s) on a given location, and use them to maintain the entries of the datastore Parameter.

clip0446

The following fields need to be completed:

Enable : when checked, SSP will look for the files and process them, on the set interval
Folder : specify the location where the files are placed. Please make sure that the SSP IIS & DB servers have access to this folder if it is a network folder.
When no files found : Specify what SSP needs to do when no files are present:

 - Skip import : do not perform any action

 - Continue import : perform the action, this will result in an empty Parameter!

Import action: Specify which actions SSP needs to do when files are present:

 - 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.

When import done : what to do after a succesful import:

 - Remove files : delete the imported files

 - Keep filer : do not delete the imported files

 - Move files : specify the folder where SSP needs to copy the files after import (for example, a folder called 'successful imports')

When import failed : what to do when the import of a file failed:

 - Remove files : delete the imported files

 - Keep filer : do not delete the imported files

 - Move files : specify the folder where SSP needs to copy the files after import (for example, a folder called 'failed imports')

Start date & time : Set the timestamp when the automated import needs to start working
Interval : set the interval when SSP needs to perform the automated import. This can be set in : minutes, hours, days, weeks.
Next import date & time : the next import date & time is displayed here
Is importing : this field indicates if the import is currently running. Values are 'yes' or 'No'.

 

Bottom buttons:

clip0447

- Cancel : disregard any changes

- OK : save the changes and return to the Datastore homepage

- Save : save the changes and remain on the same screen

- Save & import on next scheduler run : save the changes, the automated import will run on the set interval, depending on the SSP scheduler (that runs by default every 5 minutes).

- Save & import now: save the changes and run the import immediately.