Data export - Revision history

HubertCzobodzinski: EACTS -> ECHSA

2022-01-26T23:28:37Z

EACTS -> ECHSA

MaciejBlizinski: /* Export to EACTS Database */

2006-12-19T09:56:27Z

‎Export to EACTS Database

MaciejBlizinski: /* Export to EACTS Database */

2006-12-19T09:47:38Z

‎Export to EACTS Database

MaciejBlizinski: +interchange

2006-01-11T11:28:43Z

+interchange

MaciejBlizinski: /* Complete export */ Formatting

2006-01-02T11:16:38Z

‎Complete export: Formatting

MaciejBlizinski: /* Complete export */

2006-01-02T11:12:24Z

‎Complete export

MaciejBlizinski: /* CSV file format */

2005-11-04T13:17:18Z

‎CSV file format

MaciejBlizinski: /* Table linking */

2005-11-04T13:13:35Z

‎Table linking

MaciejBlizinski: /* CSV file format */

2005-11-04T13:11:09Z

‎CSV file format

MaciejBlizinski: /* CSV file format */

2005-11-04T10:18:50Z

‎CSV file format

@@ Line 3: / Line 3: @@
 Data export is being done on demand, which means that whenever you want to export the data, you will need to tell the program do to so, by clicking the option in the menu.
-== Export to EACTS Database ==
+== Export to ECHSA Database ==
 === Patient names ===
-Export to EACTS Database is an '''anonymous''' export, where names of patients and surgeons are not exported. The export file is a clear-text file, which can be inspected even with a simple text editor such as Notepad. To save bandwidth, the file is compressed with gzip. You can see the clear text after you uncompress the file.
+Export to ECHSA Database is an '''anonymous''' export, where names of patients and surgeons are not exported. The export file is a clear-text file, which can be inspected even with a simple text editor such as Notepad. To save bandwidth, the file is compressed with gzip. You can see the clear text after you uncompress the file.
 To see the file contents, you can export the data to your hard disk, open it with an archive manager (such as WinZip), extract the XML file and examine it with an XML or simple text editor (Notepad). You can see that there are no names. You can afterwards submit your file to our database.
@@ Line 15: / Line 15: @@
 === How to export ===
-To export data to EACTS Database, to the [[central database]], click on the menu bar on top, labeled ''EACTS Database tools'', then ''Export to EACTS Database''. You can export data using your keyboard, by pressing <tt>CTRL+E</tt>.
+To export data to ECHSA Database, to the [[central database]], click on the menu bar on top, labeled ''ECHSA Database tools'', then ''Export to ECHSA Database''. You can export data using your keyboard, by pressing <tt>CTRL+E</tt>.
-To upload a file with data, go to [http://www.eactscongenitaldb.org/upload the upload website], select the file from the disk and press ''Submit''.
+To upload a file with data, go to [http://www.echsacongenitaldb.org/upload the upload website], select the file from the disk and press ''Submit''.
 == Complete export ==
@@ Line 64: / Line 64: @@
 The <tt>patient</tt> table uses <tt>patient_id</tt> as an unique identifier. Analogously, the <tt>admission</tt> and <tt>operation</tt> tables have the <tt>*_no</tt> fields.
-The numbers are statically attached to the patients, admissions and operations and will remain the same across all of the exports. However, if you perform another installation of EACTS Database Software and transfer data there, tha patient numbers will change.
+The numbers are statically attached to the patients, admissions and operations and will remain the same across all of the exports. However, if you perform another installation of ECHSA Database Software and transfer data there, tha patient numbers will change.
 === ODBC access ===

@@ Line 4: / Line 4: @@
 == Export to EACTS Database ==
 Export to EACTS Database is an '''anonymous''' export, where names of patients and surgeons are not exported. The export file is a clear-text file, which can be inspected even with a simple text editor such as Notepad. To save bandwidth, the file is compressed with gzip. You can see the clear text after you uncompress the file.
 To export data to EACTS Database, to the [[central database]], click on the menu bar on top, labeled ''EACTS Database tools'', then ''Export to EACTS Database''. You can export data using your keyboard, by pressing <tt>CTRL+E</tt>.

@@ Line 5: / Line 5: @@
 == Export to EACTS Database ==
-Export to EACTS Database is an anonymous export, where names of patients and surgeons are not exported.
+Export to EACTS Database is an '''anonymous''' export, where names of patients and surgeons are not exported. The export file is a clear-text file, which can be inspected even with a simple text editor such as Notepad. To save bandwidth, the file is compressed with gzip. You can see the clear text after you uncompress the file.
-To export data to EACTS Database, to the [[central database]], click on the menu bar on top, labeled ''EACTS Database tools'', then ''Export to EACTS Database''. You can export data using keyboard, by pressing <tt>CTRL+E</tt>.
+To export data to EACTS Database, to the [[central database]], click on the menu bar on top, labeled ''EACTS Database tools'', then ''Export to EACTS Database''. You can export data using your keyboard, by pressing <tt>CTRL+E</tt>.
 To upload a file with data, go to [http://www.eactscongenitaldb.org/upload the upload website], select the file from the disk and press ''Submit''.

@@ Line 68: / Line 68: @@
 Direct access to the database is possible with OpenOffice and JDBC. Read the instructions:
 * [[OpenOffice and JDBC for data access]]
 [[category:terminology|Export]]

@@ Line 15: / Line 15: @@
 The complete export allows you to export all of the data into a disk file.
-{|style="border: 2px solid gray;"
+{|style="border: 2px solid gray; width: 100%;"
-|-style="background-color: #FFC;"
+|-style="background-color: #FFC; text-align: center;"
+|
 '''Personal data''', including patients' and staff's '''names''' are being exported when using complete export!

@@ Line 48: / Line 48: @@
 ==CSV file 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:
+''see article: [[Export to CSV]]''
 == Import to relational databases ==

@@ Line 75: / Line 75: @@
 ===Table linking===
 The three main tables: patient, admission and operation are linked like this:
-[[Image:TableLinks.png]]
 == Import to relational databases ==

@@ Line 50: / Line 50: @@
 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
+  hospital_code,ID,First name,Last name
-,John,Doe
+  ABC,1,John,Doe
-,Mary Jane,Smith
+  ABC,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: