Description

Choose one of the following options:

• Nothing - no action is performed. The file remains in the folder it was placed in originally. This is selected by default.
• Delete - the file is deleted after a successful import.
• Move To - if UNC operation is enabled, this option allows you to move the CSV file to a folder in your local directory. When you select this option, a Move-to destination field is displayed directly below this field. Type the folder name or path to which the CSV file should be saved after a successful import (e.g. C:\RLSolutions\CSVImport \Successful).
• Note: If a UNC operation is not enabled, and an FTP connector is used to import files, no Move-to destination field is displayed. Instead, the file is archived to a folder reserved for successful imports in the FTP site from which it was imported. A timestamp of the import will be added the original file name.

Choose one of the following options:

• Nothing - no action is performed. The file remains in the folder it was placed in originally. This is selected by default.
• Delete - the file is deleted after a failed import.
• Move To - if a UNC operation is enabled, this option allows you to move the CSV file to a folder in your network share directory. When you select this option, a Move-to destination field is displayed directly below this field. Type the folder name or path to which the CSV file should be saved after a failed import (e.g. C:\RLSolutions\CSV Import\Failed).
• Note: If a UNC operation is not enabled, and an FTP connector is used to import files, no Move-to destination field is displayed. Instead, the file is archived to a folder reserved for failed imports in the FTP site from which it was imported. A timestamp of the import will be added to the original file name.

Check this box to save detailed information (i.e. including PHI data) into the HL7 import log during CSV file import. If unchecked, no PHI data will be included and only the Header and Identifier will be saved in the log.

Note: This option affects CSV imports for HL7 only.

The CSV Import service converts patient data into HL7 messages and sends them to HL7 Listener service for processing. This field contains the default HL7 message template used for CSV imports containing patient data.

Note: Modifications to the HL7 template may cause errors which prevent the HL7 Listener from processing the message.

If FTP connectors have been defined, choose an option from the drop-down menu to import files from an FTP location.. See Creating an FTP Connector for more information.

Note: Alternatively, if a UNC operation is enabled in the system, you can use the Import folder path field to import files from an application server folder.

If a UNC operation is enabled, use this field to enter the application server folder name and path from which the CSV files are imported. The system looks for files in this location that conform to a predefined naming convention that includes a prefix, date format, optional postfix and extension (e.g. DATA20190130.csv).

Note: This field is only displayed if a UNC operation is enabled in the system. For more information, contact RLDatix support.

Import files must begin with a prefix defined here. By default, the prefix is set to "DATA" but this can be changed to your preference or the type of profile.

Like a prefix, you can also append characters to a file name (i.e. following the date and before the extension) for import files. This field is optional.

Import files must include the date in the file name in the format defined here. By default, this is set to "YYYYMMDD".

Note: The system will recognize only standard date format strings.

This option allows you to select a time zone for the CSV import schedule. By default, the application time zone is selected.

Import files must be in the file format defined here. By default, this is "CSV".

Check this box to indicate that the first row in the import file is a column header. Unchecked, the first row in the import file will be treated as a data record.

The character delimiter used to separate values. By default, commas (,) are used.

The character used for field quotes. By default, the quotation character (") is used.

Note: Quotation marks are not allowed in strings that are delimited by quotation marks.

Enter the allowable number of errors to occur during an import before aborting the process. The value entered must be an integer. The default value is 0.

Check this box to set up an automated schedule. Then, go to the Run every # days and define the frequency.

Note: If you do not enable the CSV Import Service to run on an automated schedule, you can run it manually. See Running the CSV Import Manually.

If Enable schedule is checked, enter a number to determine the frequency (i.e. number of days) at which the import service will run.

Note: The value cannot be null or zero and must be a whole number.

The IP address where the RL6 HL7 Listener service resides.

The port number on which RL6 HL7 Listeners service receives data.

This field contains the default HL7 datetime format (i.e., yyyyMMddHHmmss) when a new Patient/HL7 CSV Import profile is created.