Difference between revisions of "Export to CSV"

From ECHSA Congenital Database
Jump to navigationJump to search
m (Table linking)
(Table linking)
Line 40: Line 40:
 
===Table linking===
 
===Table linking===
  
[[Image:Linked_tables_diagram.png|framed|left|Table linking diagram. The three main tables: patient, admission and operation are linked as shown above.]]
+
[[Image:Linked_tables_diagram.png|Table linking diagram. The three main tables: patient, admission and operation are linked as shown above.]]
 +
 
 +
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]]

Revision as of 23:21, 6 November 2005

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

Table linking

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

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