| Table of Contents |
|---|
Table edit functionality
By pressing the right mouse button a list with edit actions appears on the screen. These includes the option to copy and fill in data. The display that pops up after clicking the right mouse button on an equidistant timeseries is shown below (figure 1figures 1, 1.1, 1.2):
figure 1: Timeseries edit options
figure 1.1: Timeseries edit option - submenu Fill Missing Data
figure 1.2: Timeseries edit option - submenu Mark
The options have the following meaning...
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="03218f48-5753-4b2b-bef0-3a4a0e895b98"><ac:plain-text-body><![CDATA[
[Select All] | Select all data displayed in the editor |
]]></ac:plain-text-body></ac:structured-macro>
[Select Column] | Select all data in the column in which the cursor is placed |
[ |
Select Row] | Select all data in the row in which the cursor is placed |
[ |
Save As] | Save selected timeseries to file of format: PI xml, GIN xml, csv, Dutch csv, iBever csv, Hymos transfer DB 4.50 mdb or Hymos transfer DB 4.03 mdb |
]]></ac:plain-text-body></ac:structured-macro>
[Save as special] | Filter selected timeseries by reliability and status and save to file of format: PI xml, GIN xml, csv, Dutch csv, iBever csv, Hymos transfer DB 4.50 mdb or Hymos transfer DB 4.03 mdb (see also |
]]></ac:plain-text-body></ac:structured-macro>
). From 2015.01 [Save As Special] has been merged into [Save As]. | |
[Expand Selection] | Select all data in the row in which the cursor is placed |
]]></ac:plain-text-body></ac:structured-macro>
| Filter by Tree | Possibility to filter the rows in the table so that you only see the rows which meet the filter selection. You can select on comments, validation flags and user edits (if they are different)
|
| Filter by Expression | Possibility to filter the rows in the table that you only see the times and values that meets an expression. With a pop-up message you can define the expression, where the time series are referred to as column A, B, C etc. The expression can look like "A>0"where all times are are listed where the value is larger than 0. Or "A>B" where all times (rows) are listed where the value in column A is larger than the value in column B.
|
[Edit Value] | The cell on which the cursor is place can be edited |
[ |
Cut] | Move the selected data (including the date / time field) to the clipboard |
]]></ac:plain-text-body></ac:structured-macro>
[Copy] | Copy the selected data (included the date / time field) to the clipboard |
[ |
Copy Values Only] | Copy the data values in the selection to the clipboard |
]]></ac:plain-text-body></ac:structured-macro>
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="c0763b16-7185-4c53-811c-722a5b7580bf"><ac:plain-text-body><![CDATA[
[Copy Reliable Values Only] | Copy the data values in the selection classified as reliable to the clipboard |
[ |
Copy Reliable and Doubtful Values Only] | Copy the data values in the selection classified as reliable and doubtful to the clipboard |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="2661fd20-229b-4c03-bdbc-665a91e66b16"><ac:plain-text-body><![CDATA[
[Copy Times Only] | Copy the selected date / time in the selection to clipboard |
[ |
Paste] | Paste the data from the clipboard into the selected fields |
[ |
Clear] | Delete the data values in the selection |
]]></ac:plain-text-body></ac:structured-macro>
[ |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="644579b7-018f-4d85-a2e1-73d436d82214"><ac:plain-text-body><![CDATA[
Clear Doubtfuls] | Delete the data values in the selection classified as doubtful |
]]></ac:plain-text-body></ac:structured-macro>
[Clear Unreliables] | Delete the data values in the selection classified as unreliable |
]]></ac:plain-text-body></ac:structured-macro>
[Block Fill Missing Data] | Fill the selected fields with the last value available value in the same column |
[ |
Lineair Fill Missing Data] | Apply lineair interpolation when filling in the selected fields |
[ |
Fill Missing Data from Clipboard] | Fill in the selected fields with data copied to the clipboard |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="8d553e5f-b618-4210-8c50-14242f28f0f8"><ac:plain-text-body><![CDATA[
[Set maximum fill gap] | Set the maximum gap size to be interpolated |
]]></ac:plain-text-body></ac:structured-macro>
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="a351756d-ab46-447f-977e-219c7b89f8a0"><ac:plain-text-body><![CDATA[
[ |
Moves the selected values in time |
]]></ac:plain-text-body></ac:structured-macro>
[ |
Change the selected values using a regular expression | |
| [Fit values] |
| Fit values into time series from another visible time series | |
Undo trend deviance of the selected values using a calibration timeseries | |
Trends a value to a given target level |
If the selected timeseries is non-equidistant extra options will be shown(figure 2):
figure 2: Extra edit options for non-equidistant seriesThe extra options are:
...
[Edit Time] | Edit an existing date/time for which a value already has been entered |
]]></ac:plain-text-body></ac:structured-macro>
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="d4ec5621-d4d0-4051-b573-dbbd60c56cdf"><ac:plain-text-body><![CDATA[
[Insert Time] | Insert a date/time for which a value can be entered |
]]></ac:plain-text-body></ac:structured-macro>
[Remove Time] | Remove a date/time. NOTE You can only remove a date/time if you have just inserted one using the Insert Time option and if you have not yet applied the change. Once stored in the database the time cannot be removed. If you need to remove values you can set it to missing using the clear option. The time will remain. |
]]></ac:plain-text-body></ac:structured-macro>
Chart edit functionality
It is possible to edit timeseries directly in the chart (when in edit mode). To do this a user must first select the timeseries the user wants to edit. Selecting a timeseries can be done by:
...
figure 3: Selected table header and chart legend
New chart editing functions since 2022.02
Since 2022.02 there are new functions in the graph related to editing:
- Select point by drawing rectangle: Use this option to enable (or disable) the mode in which the user can "draw" a rectangle by left click and dragging the mouse around points to select them (just like and instead of zooming). This can be useful to select outlying data points and edit them all at once. Exactly 1 time series should be selected in order for this function to work.
- Move selected points vertically by dragging: Use this option to enable (or disable) the mode in which the user can drag selected data points up vertically, this can be useful to move selected outlying data points closer to a realistic value
- Mark period: Use this option to enable (or disable) the mode in which the user can select a period to be marked with black vertical lines in the graph and a dark red background in the time column. Marking a period via the graph is done by left clicking and dragging (just like and instead of zooming). This marked period is just visually and has no effect on other functionality. The period will remain marked after the mode is disabled, to remove the marked period, use the unmark option which is located directly below in the menu.
- Unmark period: Remove the marked period from the otpion above.
Expiry time of manually edited values
- A manually edited value will get the expiry time of the timeseriesset it is in, in the filters.xml or displaygroups.xml (depending on from which display the edit session started).
- If there is not expiryTime configured, then the default expirytime from the global.properties file will be taken.
- If this expiry time is not set, a default of 10 days is used.
Persistence of manual edited imported data
When existing imported data is edited a re-import of the data will not rollback the edit. This is not the case for completions and for data that is the result of transformation.