## Exporting data to TESSy CSV format

This feature is not yet available for the CDI or ICU modules.

You can also export data for a given hospital and survey in a TESSy CSV (comma-separated values) file. TESSy (The European Surveillance System) is ECDC’s online system for upload and analysis of data for different networks for surveillance of communicable diseases, and can only be accessed by nominated national/regional contact points. The format of the exported data is defined in the CDI / ICU / PPS protocol, and in the supporting documents on the TESSy website at https://tessy.ecdc.europa.eu/TessyWeb.

Some variables need to be added to the TESSy format, such as the data source (usually the national surveillance institute) or the network ID (for example, if there is more than one surveillance network for the same disease in the same country). It is possible for any user to enter values for the variables Network identifier and Data Source. In general, this specific information is not known at the hospital level, and so these variables can be left empty, e.g. until entry by the nominated contact points. The freeware tool csved can be used to add the information to the CSV file.

To export data in TESSy format:

1. Click Data Export in the main menu.

The Export form opens.

2. Click the TESSy export tab to open the corresponding form.

3. Enter the Network identifier and Data source, if known.

Usually, this information is not known at the hospital level, in which case these variables should be left empty and subsequently entered by the nominated contact points.

4. Click the Browse button (… to the right of the Path field), to locate the folder to which you want to send the exported file. You can either use an existing folder or create a new folder by clicking Make New Folder to create e.g. C:\HWN2\Export. You can also open the selected path by clicking the Open button.

5. In the Protocol field, select the protocol for the file to export.

6. In the data grid, select the code for the hospital(s) for which you are exporting the data. You can select more than one hospital-survey by holding down the control button, and then clicking on each hospital code you wish to select or select all hospitals by clicking Select all.

Make sure that the start and end dates are defined for your PPS.

7. Click Export for TESSy.

The CSV export may take some time to finish. HWN generates five CSV files, with following names:

Standard protocol:

• 1.HAIPPS.csv

• 2.HAIPPSPT.csv

• 3.HAIPPSPTAM.csv

• 3.HAIPPSPTINF.csv

• 4.HAIPPSPTINFRES.csv

Light protocol:

• 1.HAIPPSLIGHT.csv

• 2.HAIPPSLIGHTDENO.csv

• 3.HAIPPSLIGHTDENOAM.csv

• 3.HAIPPSLIGHTDENOINF.csv

• 4.HAIPPSLIGHTDENOINFRES.csv

The numbers at the beginning of the file names designate the level of the data in the hierarchical database, for example, the first level 1.HAIPPS.csv file contains the hospital data.

Note: Values for national and some hospital variables are not included in the first level export file (1.HAIPPS.csv). These values should be completed by the National/Regional PPS Co-ordinating Centre before uploading to TESSy HAIPPS: DataSource, NetworkID, HospitalLocation (NUTS1 code) and SampleHospital (which specifies whether this hospital belongs to a national sample for the PPS/survey).

Warning: The file names do not contain the hospital code or the time stamp, so when data are exported for a second hospital, any previous TESSy export csv files in the same directory are overwritten.

To prevent this, compress the files into a zip file and include the name of the hospital in the file name, before sending the data to the national/regional PPS coordinating centre. It is also recommended that you transfer the TESSy export files together with the Access database export file.

More:

Converting to TESSy CSV using Stata

HelicsWin.Net v2.2 Online User Guide v20160330
© European Centre for Disease Prevention and Control, 2016
Reproduction is authorised, provided the source is acknowledged