• …
• …
• …

Test data sets for populating test versions of the kvalobs database:

• March-December, 2007, paramid=110

Note the above is a plain text file. The .doc extension is used since only a limited set of extensions can be uploaded to the wiki . The text file comprises data extracted from the operational or historic kvalobs database in the form of lines such as:

17741;2007-04-02 06:00:00;-1;110;2007-10-03 16:39:21;402;0;0;-1;1110000000001000;7000000000000000;NULL

and may be loaded into a test version of the kvalobs database with:

$ psql kvalobs

kvalobs=# COPY data FROM //Full-path-of-text-file// USING DELIMITERS ';' WITH NULL AS 'NULL';