Data export

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

To export data to EACTS Database, to the CentralDatabase, click on the menu, EACTS Database tools, then Export to EACTS Database. You can export data using keyboard, by pressing

CTRL+E

.

To upload a file with data, go to the upload website, select the file from the disk and press Submit.

Complete export

The CompleteExport allows you to export all of the data into a disk file.

||<#FFFF80> /!\ Personal data, including patients' and staff's names is being exported when using CompleteExport! ||

The CompleteExport writes a file in the XML format which is a modern and portable data exchange format. It is also a transparent format, which means that you can easily look inside, read it and use it.

XML file can read in programs like Notepad, or any text editor. The file is intended for integration with external computer systems, and data import from XML always require some programming. It is not intended for direct end-user usage.

XML and XSLT transformation

attachment:XmlAndXslt.png

XSLT Stylesheet allows to transform a XML file into other formats for, example:

• HTML (also multiple HTML files)
• Plain text
• CSV
• SQL scripts

With knowledge on how to write XSLT, you are able to write your own stylsheet and transform the data into formats compatible with various scientific software:

• • GNU Octave (free software under GNU GPL)
  • R project (free software under GNU GPL)
  • Scilab (under Scilab license)
  • Matlab
  • Splus

Export to relational databases

CSV files

It is also possible to export the CSV files, directly from the tables of the local database. You should be able to import them into other relational databases, if you have knowledge on how to do it.

Please read more on: ../ExportToCsv

ODBC access

Although it's not tested yet, it should be possible to run a standalone Cloudscape server and connect to it via ODBC.

/!\ If you use ODBC access with possibility to write to the database, you should be careful! You can easily corrupt the database when working directly on the database.

JDBC access

Direct access to the database is possible with OpenOffice and JDBC. Read the instructions:

• OpenOffice and JDBC for data access

---

See also

• [[../DataExportFormat]]