search

MangoAutomation / ma-core-public

Mango Automation Core public code
Other
78 stars 50 forks source link

Updating or Deleting when importing history from xls file does not work #175

Closed Joelhaggar closed 10 years ago

Joelhaggar commented 10 years ago

Adding new data works but deleting or updating does not.

terrypacker commented 10 years ago

I was able to delete and add numeric points using the H2 datastore. The modify column has changed to only allow 'add' or 'delete' keywords. This may or may not be what you were experiencing.

If 'add' is selected it and your data store is SQL it is possible to end up with multiple point values at the same time, if using Time Series storage the point value will be replaced.

I found some additional problems with the upload page.

  1. The error messages are not cleared out on multiple uploads
  2. The Combo box is set to on-change so it is not possible to re-select the same file type without changing it to something else first
  3. There is an error with the Servlet on Jetty 9, Error 500 response.
  4. Boolean values seem to be getting exported as Formulas (at least in OpenOffice on a Mac).
  5. Adding annotations does work, only the point value gets saved. We need to implement a Set Point Source for the Importer that will apply the annotations to the points on save.
terrypacker commented 10 years ago

This was a bug on the NoSQL data store. Fixed.