Emerson Exchange 365

Export data from DeltaV Explorer in text/xml/json

Hi Experts,

I am trying to export the data from the level with yellow mark (Please see picture attached):

I have tried the existing export function, unfortunately I can only export the "structure" but not all the elements and data.

Do you think DeltaV has such kind of "export-all-element" feature ? Or any possible way to retrieve the data by access to the database where DeltaV Explorer connecting ?

Thank you very much !

 

• deltav explorer

engwei

• 21 Aug 2015 12:50 AM
• Cancel

11 Replies

• Youssef.El-Bahtimy

  

  • 21 Aug 2015 3:52 AM

  Let me clarify; you wish to export an operation, and for the full definition of the phase classes assigned to the operation to be exported with it. Unfortunately, the export function at the operation level does not work this way (unlike how an export of a module with a linked composite will also export the content of the composite).
  
  You can export the entire database; that contains the operations and the phases. You can even convert the fhx file to xml using the fhxtoxml.exe, or a number of 3rd party converters.
  If the whole database fhx is too big, you could also just export the entire operations folder, export the entire phase classes folder, then simply append the two fhx text files and parse the smaller file.

  • Cancel
• engwei

  

  • 21 Aug 2015 5:14 AM

  In reply to Youssef.El-Bahtimy:

  Thanks for your reply :)
  
  "you wish to export an operation, and for the full definition of the phase classes assigned to the operation to be exported with it." ==> Yes
  Thanks for the info about exporting the database with operations and phases.
  It will be great if I can get the full definition of a selected operation. Still have no clue about it but I am curious if Emerson has an API for that.

  • Cancel
• Tinh Phan

  

  • 21 Aug 2015 5:24 AM

  In reply to engwei:

  Have you try using Bulk Edit user define export? It can be exported into excel. Here is the link for more info on Bulk Edit.
  http://www2.emersonprocess.com/siteadmincenter/PM%20DeltaV%20Documents/Whitepapers/WP_Bulk_Edit.pdf
  
  Hope this helps

  • Cancel
• engwei

  

  • 21 Aug 2015 6:16 AM

  In reply to Tinh Phan:

  This is something that I exactly wanted :)
  Unfortunately, it only support a small part of the extraction.
  In the operation, there are Recipe Parameter, Step and Transition. By using Bulk edit user define export, only Recipe Parameter is supported.
  For my case, most of the data are store in Step and Transition.
  
  Thank you.

  • Cancel
• gamella

  

  • 21 Aug 2015 6:39 AM

  Maybe you can use RecipeExchange to generate XML fromat recipe definition. This includes STEPS and TRANSITIONS along with parameters.
  
  You can find some code samples using RecipeExchange API on a DeltaV Pproplus C:\DeltaV\samples\RecipeExchange folder.
  Documentation about RecipeExchange API is also available on DeltaV Books Online, under BATCH->Batch Reference->Appendix G - The Recipe Exchange Control
  and under Integration->SOA Web Services

  • Cancel
• engwei

  

  • 21 Aug 2015 9:24 AM

  In reply to gamella:

  Thanks for your reply. This is a good suggestion.
  I tried the delivered application: Recipe Exchange WCF Client, Large Export function
  By enter the desired Operation name, and "Large Export", I am able to export the the list of all "Recipe Parameter, Step and Transition".
  But in the batch parameter property, some information is not being extracted.
  Only "Parameter category" info is extracted. Description, Type, Category, Origin, Value, Named set, Named state are missing. I am not sure if all these infomation can be extracted by modify the code of Recipe Exchange WCF Client at the moment.

  • Cancel
• gamella

  

  • 21 Aug 2015 12:45 PM

  In reply to engwei:

  Operation, Unit Procedure and Procedure XML Recipe excjhange export does not include all parameters info.
  I think (not sure) you should export a FORMULA defined for that particularOperation, Unit Procedure or Procedure to get that info.
  
  I will check that but will need to bring back to live a Virtual Machine I have somewhere....

  • Cancel
• Jack_France

  

  • 22 Aug 2015 9:22 AM

  If you export whole database or just a part of it, have a look to <this tool> able to convert FHX to XML file; because the emerson utility doesn't works correctly ... when it works.

  Regards. Jack

  • Cancel
• engwei

  

  • 22 Aug 2015 10:36 AM

  In reply to Jack_France:

  I think my blocking point is to get all the parameter info in the lowest level. As soon as FHX contain the info, I will proceed to your suggestion. Thank you.

  • Cancel
• engwei

  

  • 22 Aug 2015 10:38 AM

  In reply to gamella:

  I guess the operation name is unique, but not the next lower level ..

  • Cancel
• engwei

  

  • 24 Aug 2015 1:01 AM

  In reply to engwei:

  To clarify, in this hierarchy for example,
  Recipes--> Operations--> Operation--> Step--> Batch Parameter
  
  I need to access to all properties in Batch Parameter, write it to a text file. But the "Recipe Exchange WCF Client, Large Export function" only give me value of the Batch Parameter. Other properties are missing ..

  • Cancel