Export to CSV - Revision history

MaciejBlizinski: +link

2006-01-11T11:30:33Z

+link

2005-11-07T09:30:21Z

‎Tables join

2005-11-07T09:29:58Z

‎Table linking

2005-11-06T21:21:07Z

‎Table linking

2005-11-06T21:15:39Z

‎Table linking

2005-11-04T13:36:16Z

‎About CSV format

2005-11-04T13:35:36Z

‎Select "Complete data export"

2005-11-04T13:34:52Z

2005-11-04T13:26:24Z

2005-11-04T13:18:03Z

@@ Line 45: / Line 45: @@
 Table linking diagram. The three main tables: patient, admission and operation are related as shown above.
 [[category:terminology]]
 [[category:technical support]]

@@ Line 42: / Line 42: @@
 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 joined as shown above.]]
+[[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 linked as shown above.
+Table linking diagram. The three main tables: patient, admission and operation are related as shown above.
 [[category:terminology]]
 [[category:technical support]]

@@ Line 38: / Line 38: @@
 |Smith
 |}
-===Table linking===
+===Tables join===
-[[Image:Linked_tables_diagram.png|Table linking diagram. The three main tables: patient, admission and operation are linked as shown above.]]
+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 linked as shown above.

@@ Line 40: / Line 40: @@
 ===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.]]
 [[category:terminology]]
 [[category:technical support]]

@@ Line 39: / Line 39: @@
 |}
 ===Table linking===
-[[Image:Linked_tables_diagram.png]]
+[[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:technical support]]

@@ Line 18: / Line 18: @@
 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
+  ID,First name,Last name
-  ABC,1,John,Doe
+,John,Doe
-  ABC,2,Mary Jane,Smith
+,Mary Jane,Smith
 After reading this file in spreadsheet application like [http://www.openoffice.org OpenOffice] or MS Excel, you would get something like:
@@ Line 26: / Line 26: @@
 {|border="1" cellpadding="3"
 |-
 !ID
 !First name
 !Last name
 |-
 |1
 |John
 |Doe
 |-
 |2
 |Mary Jane

@@ Line 5: / Line 5: @@
 To export your data to CSV file, please run the Software and select from the menu:
-===Select "Complete data export"===
+===Select "Complete export"===
 [[Image:CsvExportHowTo-1.png]]
 ===Confirm export of personal data===
 [[Image:CsvExportHowTo-2.png]]

@@ Line 1: / Line 1: @@
 {{manual-infobox}}
 To export your data to CSV file, please run the Software and select from the menu:
-Export and Import -> Complete export
+===Select "Complete data export"===
 [[Image:CsvExportHowTo-1.png]]
 [[Image:CsvExportHowTo-2.png]]
 [[Image:CsvExportHowTo-3.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:

←Older revision		Revision as of 13:26, 4 November 2005
Line 1:		Line 1:
	{{manual-infobox}}		{{manual-infobox}}
		+
		+	To export your data to CSV file, please run the Software and select from the menu:
		+
		+	Export and Import -> Complete export
		+
		+	[[Image:CsvExportHowTo-1.png]]
		+	[[Image:CsvExportHowTo-2.png]]
		+	[[Image:CsvExportHowTo-3.png]]
		+	[[Image:CsvExportHowTo-4.png]]

	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:

←Older revision		Revision as of 13:18, 4 November 2005
Line 1:		Line 1:
		+	{{manual-infobox}}
		+
	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: