Data export to external systems - CustomerID

Export Tools

Overview

With Export Tool commands you are able to export organizations, users and roles from Ubisecure CustomerID.

Running

The tools are located at C:\Program Files\Ubisecure\customerid\tools
For example:
Run command export-users.cmd 

cd C:\Program Files\Ubisecure\customerid\tools
export-users.cmd > users.export

Users can be also exported to CSV (Comma-separated values) format with csv-parameter.

export-users.cmd csv > users.csv

Export Data Filter

Overview

CSV Filter is used to parse selected columns from the exported CSV data. REST interface includes all users' and organizations' attributes to the export file when used as default. CSV filter takes export data as input and parses selected columns and removes the rest.

Running

CSV Filter is as default located at C:\Program Files\Ubisecure\customerid\ tools\csv-filter
CSV Filter must be used with REST interface's CSV data and properties file that includes numbers of selected columns. For example: 

cd C:\Program Files\Ubisecure\customerid\tools
export-users.cmd csv | filter.cmd examples\csv-filter\fields.properties > users.csv

fields.properties (is located in csv-filter folder): 

1 4 5

In this example, all users are imported from the Ubisecure CustomerID and columns 1, 4 and 5 are saved to users.csv file.

Export Data Encryption

Overview

Pretty Good Privacy (PGP) is a cryptographic application that is used for signing, encryption and decrypting text, files and directories. PGP encryption uses a combination of hashing, data compression, symmetric-key cryptography and public-key cryptography with several supported algorithms.

GNU Privacy Guard is a GPL Licensed alternative to PGP software. GnuPG can be downloaded from http://www.gnupg.org/ .

Using GnuPG with Data Export

It is possible to encrypt exported data from Ubisecure CustomerID with PGP. For example: 

cd C:\Program Files\Ubisecure\customerid\tools
export-users.cmd csv | gpg -e -r Bob > users.csv.gpg