Export to CSV

A CSV file is a text file, with fields delimited with comma "," or semicolon ";". Other delimiters are also allowed, but rarely used. The text fields can be quoted, most often by the double quote mark. The example CSV file would look like this:

hospital_code,ID,First name,Last name
ABC,1,John,Doe
ABC,2,Mary Jane,Smith

After reading this file in spreadsheet application like OpenOffice or MS Excel, you would get something like:

Hospital code	ID	First name	Last name
ABC	1	John	Doe
ABC	2	Mary Jane	Smith

Table linking

The three main tables: patient, admission and operation are linked like this: