Skip to Content

Script to import excel sheet as data item in Power Designer

Hi

Has anyone written a script to import an excel worksheet as a data item within power designer - using extended attributes. Am trying to do so but no idea where to even start.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 12 at 08:15 AM

    You don't need to write a script, the standard Excel import extension will import Data items, including extended attributes. Take a look at this video -

    https://www.youtube.com/watch?v=JoAkFVrWKzE

    It's a few years old, but still relevant.

    Add comment
    10|10000 characters needed characters exceeded

    • The video shows you how to import into a new model. To import Data Items into an existing model, start the wizard in a slightly different way:

      • attach the Excel Import model extension to your model (in the Help, see Core Features Guide > Modeling with PowerDesigner > Customizing Your Modeling Environment > PowerDesigner Resource Files > Extension Files > Attaching Extensions to a Model)
      • right-click a blank area of a diagram (or the model name in the Browser), and select "Import Excel File"

      You can also read about the Excel import wizard in the PowerDesigner Help:

      Core Features Guide > Modeling with PowerDesigner > Objects > Importing Objects from Excel Files

  • Apr 12 at 09:56 AM

    Hi, thanks for the suggestion - I can do the manual import without an issue - but I need to automate the process in the longer term, hence the attempt at creating a script that I can call which would do the exact same thing as what one would do manually.

    Add comment
    10|10000 characters needed characters exceeded