Export to CSV

From EACTS Congenital Database

User's manual

Quickstart Overview Single user installation Network installation Database structure Export to CSV

Data entry

Staff, Patients, Diagnoses, Non cardiac abnormalities, Admissions, Operations, Procedures

Contents 1 How to export to CSV 1.1 Select "Complete export" 1.2 Confirm export of personal data 1.3 Choose the file type 1.3.1 1 1.3.2 2 2 About CSV format 2.1 Tables join

How to export to CSV

To export your data to CSV file, please run the Software and select from the menu:

Select "Complete export"

Confirm export of personal data

Choose the file type

1

2

About CSV format

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:

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

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

ID	First name	Last name
1	John	Doe
2	Mary Jane	Smith

Tables join

If you import the CSV files into a relational database, to perform any useful report, you need to join patient, admission and operation tables.

Table linking diagram. The three main tables: patient, admission and operation are related as shown above.

See also

• Data export