How can we help?

Import Data into vSEC:CMS

Anthony - Versasec Support
Anthony - Versasec Support
  • Updated


External data can be imported to vSEC:CMS via XML or CSV file(s). This imported data can then be made available as vSEC:CMS variables to be used in workflows as required.

Data imported using this mechanism is stored in the local file system on the server where vSEC:CMS is installed. Typically this is located here c:\Program Files (x86)\Versasec\vSEC_CMS S-Series\cms_db\data if vSEC:CMS was installed to the default installation location. Additionally, it is important to be aware that the content of this folder is not included in standard vSEC:CMS backups.

This article will explain how to import generic data into vSEC:CMS and how to use such data once imported.

Data Import

As mentioned in the Introduction above there are 2 ways that data can be imported, via XML or CSV file. We will divide the mechanism into 2 different sections below, XML Import and CSV Import.

XML Import

The format of XML import file should be like below:

<?xml version="1.0" encoding="UTF-8"?>
<e id="7C4E934E963F06EB7DA0FCBC">
<v name="rfid.uid" value="UID_1"/>
<v name="CMS-Rfid-CSN" value="rfid.csn"/>

Where an <e> XML node is referencing one unique entity to be imported and the id= attribute will be the id that vSEC:CMS will search this entry for later (CSN in this example). Each entity can contain several variable values <v> node(s) with name= attribute containing vSEC:CMS variable name and value= attribute containing variable value.

To import a XML file of this format the file needs to have an .in extension and will be copied into c:\Program Files (x86)\Versasec\vSEC_CMS S-Series\cms_db\import folder. vSEC:CMS service will pick it up automatically and import it. The result of the import process will be to put into the c:\Program Files (x86)\Versasec\vSEC_CMS S-Series\cms_db\import folder with the same filenames as the imported file with appended timestamp and result. For example, putting a file into c:\Program Files (x86)\Versasec\vSEC_CMS S-Series\cms_db\import will result in these files being created


CVS Import

The CSV import is working as an additional prepartoon step to the XML import as described above.

The file will have to contain a header and lines with the data to be imported.


The header is containing vSEC:CMS variable name(s).

The CSV file for import needs to be put into c:\Program Files (x86)\Versasec\vSEC_CMS S-Series\db_import folder and then the CsvImportTool.exe needs to be used to convert the CSV file into XML format and put it into c:\Program Files (x86)\Versasec\vSEC_CMS S-Series\cms_db\import folder to be imported to vSEC:CMS.

1. Close vSEC:CMS console.

2. Copy the prepared CSV file to the folder db_import where vSEC:CMS application was installed to (typically C:\Program Files (x86)\Versasec\vSEC_CMS S-Series).

3. Browse to the location where vSEC:CMS application was installed to (typically C:\Program Files (x86)\Versasec\vSEC_CMS S-Series) and double click the file CsvImportTool.exe.

4. Click the Import button.

5. If the entries in the CSV file are configured correctly and the import is successful a success dialog will appear similar to below.

6. Start vSEC:CMS console and browse to Options – Variables page.

7. Click the Add button. Select Imported from Add Variable drop-down field and select the Variable name from the drop-down list. Select the Parameter to be associated with this new variable, for example, ${RfidCsn} in this example.

Click Ok to save and close.