Emerson Exchange 365

• Not Answered

Bulk Edit Existing History Collection

We have a new DeltaV system on site with the configuration from Emerson already imported.  By default, all history collection was enabled for all points.  In general this is fine, except we have a situation where we have too many tags now.

1) We have Profinet couplers talking to VIMs, therefore we have Landing Modules configured.  These landing modules have many spares located inside them (not connected to a true data point at the other end).  History collection was enabled for all these spares.

2) Soft CMs were created for many of the analog points that are coming into landing modules.  History collection is enabled both in the landing module and the soft CM, creating duplication of history collection (and license use).

3) The descriptions of tags coming into the landing modules are all just the name of the landing module and not associated with what data the tag is pulling in (e.g. equipment ID-temp).

4) we are using the Advanced Continuous Historian (with two historian servers set up for full "redundancy").

We need to clean these up but are unsure of the best way to do this.  Can a bulk export of the landing modules be done, update the history collection enable/disable and the descriptions, then re-import?  Should these be manually changed (there are thousands of tags)?

Any advice would be appreciated!

Christiana Spencer

• History Collection
• bulkedit
• Continuous Historian
• ACH
• DeltaV

Christiana Spencer

• 4 Dec 2018 12:17 PM
• Cancel

4 Replies

• Maarten van der Waal

  

  • 5 Dec 2018 10:09 PM

  Bulk editing can be usefull for a set of control modules where parameters having the same name are to be changed. In your case the modules are unique.
  So, unfortunately the History Collection has to be changed manually for each individual parameter.
  As Emerson supplied this configuration and history collection is useless for (most of) these modules, I would suggest to tell Emerson to change this configuration.

  • Cancel
• Matt Forbis

  

  • 5 Dec 2018 10:40 PM

  It is possible to do a bulk edit of all parameters that are being historized in a single bulk edit file, per plant area.
  
  You can do a user defined export, select the plant area where they reside, and use the HistoryDataPoint.fmt format file that is included with DeltaV. Note: Do not click the Select All button. If you select the area and click Select All, all history data points are duplicated in the export file. Search for "Bulk edit history collection" in Books Online and there are a few pages of info that talk about it more in detail.
  
  This will probably work pretty well for the situation you have identified.

  • Cancel
• Andre Dicaire

  

  • 6 Dec 2018 12:26 AM

  In reply to Matt Forbis:

  Matt, It is my understanding that Bulk Edit will not delete any configured items, it simply adds or updates them. Please confirm if this wrong.
  
  I think one approach is to use the History Collection view per Plant Area. From here you can delete unwanted History points and they will be removed from the module. However, it is one tag at a time. But since this is the same interface as the module, you save having to move from module to module.
  
  The other approach is to export and remove all the History tag definitions. But unless you write a script, deleting manually in the FHX and re-importing would introduce risk. But if you had a script that deleted all History tag definitions from the FHX, you could do a bulk export to Excel, where you could use Excel tools to remove select history definitions and prepare a Bulk Import of the desired tags. Then, export the database and remove all history tags and reimport these modules. Then run the Bulk import to redefine the desired tags, and there you are.
  
  But I'm thinking using the History Collection dialog is the safest and cleanest approach, though maybe a bit laborious. It does not allow you to multi select tags. It's one at a time.

  Andre Dicaire

  • Cancel
• Matt Forbis

  

  • 6 Dec 2018 2:03 PM

  In reply to Andre Dicaire:

  Andre,
  
  I did look into it more and see that unfortunately you cannot delete tags in the bulk edit. It would still be a viable option for making the description changes and other history collection settings in bulk, though you would have to still delete the duplicates manually.

  • Cancel