[Back to tutorial main page]

Time series data stored in the database can be edited or deleted by clicking on the icons to edit or to delete data. You have to click in the time series data overview on the link "Details" of the respective dataset you wish to edit.

• In the metadata section of the dataset you have the possibility to edit the data in case you have the required authorization rights. For editions the data entry form appears. Now you can edit the entry fields. If you want to clear all entries use the button "Reset". Finally click on "Submit" to update the data entry form. You are getting informed when processing has been successful.
• A datasheet can only be deleted completely when no other data are linked to it. You may only delete a data sheet having no dependencies on other data. After clicking the delete button you are getting informed when deletion has been successfully.

Add new data

If you wish to add new data to a time series, select first the dataset. Click on "Details" in the row of the dataset where you want to add data. Go further to the section "TS Data". At the end of the form you will find the button "add data".

The form "Upload timeseries data" appears. Time series should be available in a text or CSV file and should only contain data, i.e. date of measurement and values. Additional metainformation in the header needs to be set up as comment. At the end of the file (below data entries) there must not be any comment. Text files need to agree with the following rules:

• comments need to be introduced with # or *
• data needs to be listed in ascending order
• TAB serves as column delimiter (text file)
• the first entry needs to be a measurement value
• measurements needs to be numeric
• decimal delimiter is "," or "."
• data for missing entries needs to be consistent

In this form you have to upload the input file. Then you need to select the number of columns (do not count the date column) and specify the file format, date format, values for missing data and time step. You can tick the checkbox "Time shift" if you want to use this function. It corrects the given input time. The time shift in a time interval will be corrected. The reference for shifting is the first time given.

Example: 5-minutes avlues: 12:30 12:35 12:41 12:48 will be shifted to 12:30 12:35 12:40 12:50.

Further you need to specify the used character for the beginning of a comment line. To finish the import click "Send file". After the successful import the form for the edition of metadata will open automatically. At this stage you have to specify the type of uploaded data.

Import of time series data

For the