Prevent RC from appearing in Google results; .
Skip to content
English
Sign in
Access to metron.energy
  • There are no suggestions because the search field is empty.

Release note Energy Management Module (EMM) 1.3.19

New parameters for ".tocsv" function and corrections

1. Adding parameters to the ".tocsv()" function

The ".tocsv" function is used to send a raw data table in CSV format (see P.107 of EMM Manual #3: JQL Syntax ).

The ".tocsv" function has been enhanced to make it more flexible. It now accepts more optional parameters to specify various aspects of the generated CSV file.

Syntax:

dataset("RefDataSet"). tocsv("name. csv"; @ENTITY; ";" ; false ; "dd/MM/yyyy" ; ",")

- "name. csv": [required] Specifies the name of the CSV file to be generated.

- @ENTITY: [optional] Indicates the entity (or entities) where to store the CSV file once it has been generated. The file will be saved in the documents tab of the chosen entity(ies) (in the case of multiple entities, indicate a list in brackets containing the entities concerned).

- ";": [optional] indicates the column separator to be used in the CSV file.

Allowed values :

"," ";" "  " "\t" "|"
comma semicolon space backslash + t vertical bar

 

- true / false: [optional] indicates whether to keep (true) or remove (false) column names in the CSV.

- dd/MM/yyyy : [optional] specifies the date format to be used in the CSV file.

- "," : [optional] defines the decimal separator to be used in the CSV file ("." or "," )

If the optional parameters are not specified, the system will use the configuration of the logged-in user to generate the CSV file (usual behavior).

 

Corrections

  • When deleting a link type in the configurator, a misleading error message could appear indicating that the deletion had failed. This message was triggered unexpectedly even when the deletion had been carried out correctly.
  • In some particular cases, proportional sum aggregation returned values that differed between DataSet and Worksheet. The behavior has been harmonized between the two approaches to retrieving aggregated data.
  • Fixed a bug that caused some HTML widgets to display incorrectly in kiosk links.