Difference between revisions of "Export to CSV"

From ECHSA Congenital Database
Jump to navigationJump to search
m (Table linking)
m (+link)
 
(3 intermediate revisions by the same user not shown)
Line 38: Line 38:
 
|Smith
 
|Smith
 
|}
 
|}
===Table linking===
+
===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.
 +
 
 +
[[Image:Linked_tables_diagram.png|Table joining diagram. The three main tables: patient, admission and operation are related as shown above.]]
 +
 
 +
Table linking diagram. The three main tables: patient, admission and operation are related as shown above.
 +
 
 +
'''See also'''
 +
 
 +
*[[Data export]]
  
[[Image:Linked_tables_diagram.png|framed|left|Table linking diagram. The three main tables: patient, admission and operation are linked as shown above.]]
 
  
 
[[category:terminology]]
 
[[category:terminology]]
 
[[category:technical support]]
 
[[category:technical support]]

Latest revision as of 13:30, 11 January 2006

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

How to export to CSV

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

Select "Complete export"

CsvExportHowTo-1.png

Confirm export of personal data

CsvExportHowTo-2.png

Choose the file type

1

CsvExportHowTo-3.png

2

CsvExportHowTo-4.png

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 joining diagram. The three main tables: patient, admission and operation are related as shown above.

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

See also