Difference between revisions of "Export to CSV"
From ECHSA Congenital Database
Jump to navigationJump to search| Line 1: | Line 1: | ||
{{manual-infobox}} | {{manual-infobox}} | ||
| + | |||
| + | ==How to export to CSV== | ||
To export your data to CSV file, please run the Software and select from the menu: | To export your data to CSV file, please run the Software and select from the menu: | ||
| − | + | ===Select "Complete data export"=== | |
| − | |||
[[Image:CsvExportHowTo-1.png]] | [[Image:CsvExportHowTo-1.png]] | ||
| + | ===Confirm export of personal data=== | ||
[[Image:CsvExportHowTo-2.png]] | [[Image:CsvExportHowTo-2.png]] | ||
| + | ===Choose the file type=== | ||
| + | ====1==== | ||
[[Image:CsvExportHowTo-3.png]] | [[Image:CsvExportHowTo-3.png]] | ||
| + | ====2==== | ||
[[Image:CsvExportHowTo-4.png]] | [[Image: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: | 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: | ||
Revision as of 15:34, 4 November 2005
Contents
How to export to CSV
To export your data to CSV file, please run the Software and select from the menu:
Select "Complete data 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:
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:
