OPIM: AutoPlant Model Name on Iso

Does anyone know how to get the model name (filename) from AutoPlant into the iso using OPIM?

Parents Reply
  • Hello Jamie,

    Change the textnodes. txt as you did earlier to:
    mydsn=Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\ProgramData\Bentley\Plant V8i\Bentley Plant V8i Projects\SAMPLE_METRIC\Projdata\Projdata.mdb;

    00_keytag = DBQUERY ($(mydsn), select keytag from TAG_REG where tag_no='$(LINENUMBER)')

    # this makes a drawing attribute compID that gets the most common value of the component attribute GUID
    compId = *(GUID)

    # This is the query to get the modelname from the project database using compID

    00_PipingModel = DBQUERY ($(mydsn), SELECT D.DOC_NAME FROM DOC_REG AS D INNER JOIN RELATIONSHIPINSTANCE AS R1 ON R1.ID1 = D.DOC_ID WHERE R1.ID2='$(compID)' AND R1.RELATIONSHIPTYPE = 3)

    Now this should work as wanted.
    Please have a look at the updated article:


    communities.bentley.com/.../33318.how-to-get-the-model-name-filename-from-autoplant-into-the-iso-using-opim

    Let me know if this works better for you?

    Berrie Geboers

Children
No Data