ARRAYS

Is there a easy of importing excel file into DeltaV ARRAY?

7 Replies

  • Have you looked into bulk importing?

     

    http://www3.emersonprocess.com/systems/support/bol1131/source/extfile/b_theory/html/import_export.htm

     

    Array values are defined as MODULE/PARAMETER[x]Yes.CV

    where x is row and y is the column numbers.

     

    Youssef El-Bahtimy | Systems Integration Technologist
    PROCONEX | 103 Enterprise Drive | Royersford, PA 19468 USA
    Proconex Office: 610 495 2970 | Cell: 267 275 7513



    From: mnizami [bounce-mnizami@community.emerson.com]
    Sent: Thursday, March 13, 2014 11:33 AM
    To: DeltaV@community.emerson.com
    Subject: [EE365 DeltaV Track] ARRAYS

    Is there a easy of importing excel file into DeltaV ARRAY?

  • In reply to Youssef.El-Bahtimy:

    I have tried Bulk Editing not Bulk Import, it didn't work

  • What didn't work?  Did you get an error message?


    From: mnizami [bounce-mnizami@community.emerson.com]
    Sent: Thursday, March 13, 2014 11:56 AM
    To: DeltaV@community.emerson.com
    Subject: RE: [EE365 DeltaV Track] ARRAYS

    I have tried Bulk Editing not Bulk Import, it didn't work

  • In reply to Youssef.El-Bahtimy:

    I should said creating format spec file looked a formidable, I'll give it one more try

  • I see.  Creating the format spec file means having to define each element of the array first, via the GUI.

     

    You can manually edit the .fmt to potentially make this go faster, but it is probably not any faster than the GUI.

     

    Youssef El-Bahtimy | Systems Integration Technologist
    PROCONEX | 103 Enterprise Drive | Royersford, PA 19468 USA
    Proconex Office: 610 495 2970 | Cell: 267 275 7513

  • In reply to Youssef.El-Bahtimy:

    thanks, I finally successfully created the format spec file and now using it, saving 10 times the amount of time I was manually entering the field values. Although bit of work to convert native excel file format to format spec file format, as all the fields in the spec file shows up in a row, but it is still lot better than entering each value manually. Thanks again

  • In reply to mnizami:

    Great news.  Good luck.