Using DataEntry to Flag Assets

Forum / Axiom Showcase

Helping you release your data rockstar!
Jeff_Knepper
updated 3 yrs ago
2replies

I've used the Asset Template to display all known assets of 'Wells' in my simulation. Then I used a filter on the Asset Template to show me only those wells that are outside spec.

To the right of the trends is the Data Entry control. This control has been linked to a tag that exists at each well named 'WellStatus_md'. As a well engineer examines each well, they may update the tag from a value of 0 to a value of 1 to clear the well from their list, or a value of 2 to indicate that the well needs additional attention.

At the end of each shift, a report is generated that includes all wells marked as a 2. These nightly reports are archived on the Canary server as well as distributed via email.

Each night at midnight, the 'WellStatus_md' tag resets back to 0, thus resetting the wells and providing for the next day's workflow to begin.

I've included a video of me using the application.

https://youtu.be/32hS_LXIeiQ

- zlarsonee
- 8 mths ago
- Reported - view
Thanks
I saw the video, looked great.

In my application, I would like to do some manual entry capturing in Axiom if practical.
I like the annotations, but I also wanted to look into the manual entry.
I am still testing to see how well it will or will not work.
I have questions.

Reset
Is the reset on the WellStatus_md done from Canary side?
If so, is it a script and it looks at UTC time?

Safe string entry
I wondered about user entered commented to a table in Canary, not just the annotation.
String entry is safe and sanitized?

Timestamp column name renaming
Can I change the auto generated 'Timestamps' column name?
I want to capture both the entry time and manually entered event time.
I want to do this outside of just the annotations to be clear.

License counts concern
Is there a good way to make dummy tags for manual entry which won't count against the license tag count?

Or should I multiplex a half dozen tags for manually entered comments for all my production lines instead of a half dozen for each?
- smason
  
  8 mths ago
  
  Reported - view
  Hi Zachary Larson ,
  
  The WellStatus_md tag is a calc tag that is triggered to run every 24h. No scripting. Everything is stored in UTC under the covers in the historian. That timestamp is then converted to the local timezone of the client consuming the data. In this case, the Calc service is using whatever timezone the server is set to run its calculation.
  
  The Data Entry control has a few security restrictions as to who can use it. You can see more details on it here: https://helpcenter.canarylabs.com/t/m1hvl6d/data-entry-control-version-23. There is no limit for the size of the string, but if it is larger than 1KB, it gets stored differently in the historian. This is not ideal as it could potentially cause performance issues if those strings were very large.
  
  The Data Entry table will always display the latest value and timestamp for the tag.
  
  All tags go against the historian tag count.