Skip to content

Latest commit

 

History

History
35 lines (22 loc) · 1.29 KB

README.md

File metadata and controls

35 lines (22 loc) · 1.29 KB
Raw

Excel importer

This tool supports you in importing MS Excel tables into your Axon Ivy project. The imported table is added as an entity to a project UI, where it is not only displayed but also made editable.

final-dialog

Demo

  1. Initiate the Excel imported via menu File > Import > Axon Ivy > App Dialog from Excel. importer

  2. Pick a project, where the Excel records should be imported to as Entity with a Dialog. wizard

  3. The importer will create the EntityClass, that represents entries in the Database. generated-entity

  4. A simple process will be created, leading to a Dialog to explore your imported Entities. final-dialog

  5. Furthermore, the Dialog allows you to modify, delete and add new entries. final-dialog

Setup

In the project, where the Excel data should be managed:

  1. Create a persistence unit under /config/persistence.xml
  2. Add the properties
  • hibernate.hbm2ddl.auto=update (to allow schema changes)
  • hibernate.id.new_generator_mappings=false (to use classic sequence)
  1. Set the Data source to a valid database. If there is none, set it up under /config/databases.yaml