Data Export and Import

About Data Export and Import

Data Export and Import are simple utilities for managing data Users, Roles and Cost Centers to CSV file.

Data Export page is accessible from all pages under Actions in Users section.

Data Export

On the left side of Data Export page administrator can select character encoding, on the right side of Data Export page user can select scope of data to export. Export will be saved in csv file format.

images/download/attachments/153632498/2016-08-03_16_37_18-Roles.png

CSV character encoding

CSV file will be created according to selected encoding listed below.

Action

Description

UTF-8

Data will be exported in UTF-8 encoding

Windows-1250

Data will be exported in Windows-1250 encoding

Windows-1252

Data will be exported in Windows-1252 encoding

ISO-8859-1

Data will be exported in ISO-8859-1 encoding

ISO-8859-2

Data will be exported in ISO-8859-2 encoding

Other

Administrator can select another encoding type

Scope of data to export

CSV data will be exported according to selected sources listed below.

Action

Description

Export Users

Export all users to csv.file

Export Cost Centers

Export all cost centres to csv.file

Export Roles

Export all roles to csv.file

Data that are exported encrypted are marked with prefix do_not_convert@@. When Dispatcher Paragon Management Service imports data from CSV file via Data Import it looks for this prefix when it tries to decide if input value must be converted via currently set conversion method or not.

Data Import

On the upper of the Data import page there is a basic file scructure for CSV files. In bottom part there is a CSV file character encoding and path to CSV file with data to import.

images/download/attachments/153632498/image2016-7-15_12_49_10.png

CSV character encoding

CSV file will be created according to selected encoding listed below.

Action

Description

UTF-8

Data will be exported in UTF-8 encoding

Windows-1250

Data will be exported in Windows-1250 encoding

Windows-1252

Data will be exported in Windows-1252 encoding

ISO-8859-1

Data will be exported in ISO-8859-1 encoding

ISO-8859-2

Data will be exported in ISO-8859-2 encoding

Other

Administrator can select another encoding type

CSV files format

  • Add/update/delete users – [100;add|del;username[,alias,...];name;surname;[card number, ...];cost center number;email;[home directory];[password]]

  • Add/update/delete users with PIN code – [100;add|del;username[,alias,...];name;surname;[PIN%pin_code%,...];cost center number;email;[home directory];[password]]

  • Add/delete card numbers – [200;add|del|clear;username[;card number]]

  • Add/delete PINs – [200;add|del|clear;username[;PIN%pin_code%]]

  • Add/update/delete cost centers – [300;add|del;cost center number[;cost center name]]

  • Add/update/delete roles – [400;add|del;role name[;role description]]

  • Set email address for user – [201;username;email address]

  • Set cost center for user – [202;username;cost center number]

Data that are exported encrypted (for example PIN codes or passwords) are marked with prefix do_not_convert@@. When Dispatcher Paragon imports data from CSV file it looks for this prefix when it tries to decide if input value must be converted via currently set conversion method or not.

CSV separator used for separating columns is confugurable value located in System > Reports > Primary separator in files for export/import, defaulted to semicolon ';'.

CSV separator used for separating multiple values within one column is confugurable value located in System > Reports > Secondary separator in files for export/import , defaulted to comma ','.

Additional rules and limitations

Add/update/delete users

  • If the user with given username already exists, the user record will be overriden.

  • Aliases and card numbers can only be added, but not changed or removed.

  • Username, name, surname and costcenter must not be empty.

  • Email must be a valid email address.

CSV files examples

  • 300;add;5;Communication

  • 300;add;7;Enterprise and Industry

  • 100;add;villevirtanen;Ville;Virtanen;PIN5555;5;villevirtanen@test.com;;4MV0b

  • 100;add;jeandupont;Jean;Dupont;268742;7;jeandupont@test.com;\\share\users\jeandupont;B27Kf

  • 200;add;villevirtanen;268743

  • 200;add;jeandupont;PIN7777

  • 200;add;johndoe;do_not_convert@@PINb59c67bf196a4758191e42f76670ceba

  • 400;add;marketing

  • 400;add;human resources;All the employees from Human Resources department

  • 400;del;sales