Perhaps I'm alone in this one, but I (sometimes) have data that writes trash into the database. I try to keep it out, but, well, then a sensor breaks lose and is swinging around in the wind writing a bunch of garbagy numbers into something.
The way I used to do this, as described in a previous thread, was to use the Legacy Point Details screen to export (all) the data from the sad point as an excel file. Into excel it goes, with Standard Excel Stuff Applied to find the points to delete. I would then take the modify (add/delete) column, copy'n'paste as values (so the math and stuff doesn't go back into the import file), and save that as an excel, then use the Legacy UI Data Point Import screen to load that back in.
This worked reliably until I upgraded to 3.7.7.. Now, when I do that process, I see the following message:
Error importing row 12, Invalid text in modify column, add or delete only allowed
The modify columns in question, in fact, contain only the word delete or nothing at all. This has worked in the past.
I know with the V4.0 rollout the Legacy UI is going away entirely; Is there still a way to do this sort of "all the data out, filter it, and load it back in" style of feature? Has this function been removed somehow in 3.7.7? Is there a better way to do this?
I realize that I can filter more with metapoints, and set extreme import sets, and lots of other things when the data is first polled into the system. That's all fine and good. But, well, things happen, and sensors go crazy, and sometimes you're left with a big stack of gibberish that needs some hand-adjusting to straighten out. I don't like doing this, since it's a pain in the butt, but, well, sensors do fail in ways that can't easily be filtered on the input.
This particular example relates to a temperature sensor issue: The sensors were damaged somehow, and the values (although in a valid input range) are clearly changing in ways that are not physically possible. We've identified the problem, and fixed it, but I have a reasonable amount of records in the system that need deleting or adjusting to make this data point usable. Any advice here?
I've got a message into customer support: I'll post here when I get a response (unless they respond here first).