Difference between revisions of "Export to CSV"
From ECHSA Congenital Database
Jump to navigationJump to searchm (+link) |
|||
| (8 intermediate revisions by the same user not shown) | |||
| 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: | ||
| + | |||
| + | ===Select "Complete export"=== | ||
| + | [[Image:CsvExportHowTo-1.png]] | ||
| + | |||
| + | ===Confirm export of personal data=== | ||
| + | [[Image:CsvExportHowTo-2.png]] | ||
| + | ===Choose the file type=== | ||
| + | ====1==== | ||
| + | [[Image:CsvExportHowTo-3.png]] | ||
| + | ====2==== | ||
| + | [[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: | ||
| − | + | ID,First name,Last name | |
| − | + | 1,John,Doe | |
| − | + | 2,Mary Jane,Smith | |
After reading this file in spreadsheet application like [http://www.openoffice.org OpenOffice] or MS Excel, you would get something like: | After reading this file in spreadsheet application like [http://www.openoffice.org OpenOffice] or MS Excel, you would get something like: | ||
| Line 11: | Line 26: | ||
{|border="1" cellpadding="3" | {|border="1" cellpadding="3" | ||
|- | |- | ||
| − | |||
!ID | !ID | ||
!First name | !First name | ||
!Last name | !Last name | ||
|- | |- | ||
| − | |||
|1 | |1 | ||
|John | |John | ||
|Doe | |Doe | ||
|- | |- | ||
| − | |||
|2 | |2 | ||
|Mary Jane | |Mary Jane | ||
|Smith | |Smith | ||
|} | |} | ||
| − | === | + | ===Tables join=== |
| − | The three main tables: patient, admission and operation are | + | |
| + | 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]] | ||
| − | |||
[[category:terminology]] | [[category:terminology]] | ||
[[category:technical support]] | [[category:technical support]] | ||
Latest revision as of 13:30, 11 January 2006
Contents
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
