Skip to Content
avatar image
Former Member

How to export a list of entities list from a Powerdesigner repository?

I'm trying to export a list with all entities of my powerdesigner repository using a VB script. Somebody know how to do this?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Dec 02, 2016 at 04:23 PM

    You can access the Repository via the RepositoryConnection global property, then iterate through the Folders and Documents it contains. I haven't tried it myself.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 06, 2016 at 04:28 PM

    set fldr = RepositoryConnection.FindChildByPath("FDW_MODEL", Cls_RepositoryFolder)

    for each fold in fldr.ChildObjects 'Level1 - Folders
    for each br in fold.ChildObjects 'Level2 - Projects
    for each pr in br.ChildObjects 'Level3 - Models
    if pr.classname = "Logical Data Model" then
    for each ent in pr.ChildObjects 'Level3 - Entities
    if ent.classname = "Entity" then
    output ent.name
    end if
    next
    end if
    next
    next
    next

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 06, 2016 at 06:07 PM

    Thank you Rafal,

    I was trying to do what George said and now, with your tip, i'm having success!

    Best regards!

    Marco

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 07, 2016 at 12:57 PM

    No problem! Please mark the post as answered

    Add comment
    10|10000 characters needed characters exceeded