Excel- ER Model Import Plug-in

Create ER Models with an Excel Import

  • Version: 1.0.2 (Updated October 30, 2014)
  • For use in: Astah Professional (6.8 or later) - Download
  • Created By: Change Vision, Inc
  • Get: Source Code

This Plug-in enables you to import Entities, their Attributes, and Domains for ER Diagrams directly from Excel. This plug-in builds on the existing feature of exporting ER diagrams into Excel. This enables round trip engineering of exporting from Astah to Excel, modifying the Excel file, and then importing the changed file back into Astah.

How to use

  1. Download the Excel Import Plug-in (.jar file) from here.
  2. Run Astah and go to [Help] - [Plugin List] menu and click [Install] button.
    anycode plugin
  3. Select the .jar file and restart Astah.
    anycode plugin
  4. Now [Import ER Domain/ER models from Excel] menus are added under [Tool] - [ER Diagram] (To activate these menus, an ER diagram needs to be created/opened in a project.)
    image 1

    To Import ER Domains

    1. Select [Import ER Domain from Excel], a dialog box will appear.
      image 3
    2. Select the file you want to import and then click [Import].

    Notes

    1. Items that can be imported by [Import ER Domains from Excel] are:
      • Logical name / physical name / Data Type / Definition
    2. The supported format is the Entity Definition Report exported by Astah (Export one from [Tool] – [ER Diagram] – [Export Entity Definition Report or download template). If you customize the format, you will need to specify the rows and columns to import items correctly.
      image 4

    To Import Entities and its Attributes

    1. Select [Import ER Model from Excel], a dialog box will appear.
      image 5
    2. Select the file you want to import and then click [Import].
      You can choose which information to load as the Entity’s logical name:
      • Excel's sheet name (Choose the first option – ON by default) -OR-
      • Specific columns (Choose the second option and specify the row and column
      image 6

    Notes

    1. Items that can be imported by [Import ER Model from Excel] are:
      • Entities with logical name / physical name
      • Attributes with logical name / physical name / Primary Key / Not NULL / Default value / Data Type / Length / Precision / Definition
    2. The supported format for importing models is the Astah’s Entity Definition Report exported by Astah (Export one from [Tool] – [ER Diagram] – [Export Entity Definition Report or download template). If you customize the format, you need to specify the row and columns to import items correctly.
      image 7
  5. When you’ve finished importing, a confirmation dialog opens, click [OK].
    image 8
  6. Imported models will now appear in the structure tree.
    image 9
  7. To show these models in the Diagram Editor, select them and drag them over on to the Diagram editor or select [Auto Create ER Diagram] menu from ER Model's context menu in the Structure Tree.
    Currently this plug-in does not import relationship information between entities, so you need to manually add relationships.
    image 10

This Plug-in works with Astah Professional