Database import/export

 

The contents of the same tables can be exported into a CSV file for editing and importing into the same or another server. These features are available to users with Admin privileges.

 

The tables supporting the import and export features are the following:

 

Reading locations (Admin/Settings/Reading Locations page)

Scheduler tables, except Scheduler/Order table

 

The file must conform to the required format, as follows:

 

Row

Format

Description

1

 “COLID”[,”COLID”…]\n The four-letter column ID (COLID) for a database field. COLID values can be found on the Customize Labels page (Admin/Settings/Customize Labels)

2-N

 “Value”[,”Value”…]\n Values assigned to the respective COLID field, separated by commas and terminated with a newline character. Values must be in DICOM-compliant format and the number of values in each row must equal the number of COLID’s defined in Row 1.

 

 

To initialize one of the supported database tables, do the following:

 

  1. On the applicable page, click the Import button.
  2. In the popup window, click Browse.
  3. Find the CSV file and click Open.
  4. Click Import.

 

Imported records are appended to existing records. No validation is performed on the imported data, including checks for duplicate or existing entries. A formatting error in any row means no records are imported. Import attempts are logged in the system log with Level=OTHER and Action=Import Table.

 

To export the contents of one of the supported database tables, do the following:

 

  1. On the applicable page, click one of the following buttons:
    1. Export – export the database records in CSV format
    2. Export Raw – export the database records with DICOM formatting removed
  2. When prompted by your browser, save the file to a folder on your workstation.