CSV Import Service
The RL6 CSVA Comma Separated Values file. Each row in the file represents a record. When opened in Microsoft Excel®, each value appears in its own cell; when opened in Notepad®, however, the record’s values are separated by commas. Import Service allows you to import CSV files directly into the database to update lookup (Medication, Equipment, Physician,Staff and Patient) information.
What is a CSV file?
CSV stands for Comma Separated Value file and is sometimes called “comma delimited”. CSV files can be opened in a variety of applications, such as Microsoft Excel® or Notepad®. When opened in Excel, each field appears in its own cell; when opened in Notepad, fields are separated by commas. Each row of a CSV file represents one record.
How are CSV files used in RL6?
CSV files are often used as a simple way to transfer a large volume of data between programs or repositories, without worrying about special file types or interfaces. The CSV file is placed in a folder on an FTP site or in a directory on the server where RL6 has been installed or a network share, through either a manual or automated process.
RL6 polls this directory at a predefined interval. When a new file is found, the records it contains are processed and inserted into the RL6 database. It is recommended that a new file is created at regular frequencies (daily).
See: