Author Topic: Sync Excel and EA  (Read 10676 times)

EA_enthusiast

  • EA User
  • **
  • Posts: 172
  • Karma: +0/-0
  • I'm a lifelong learner
    • View Profile
Sync Excel and EA
« on: December 09, 2020, 01:51:03 pm »
Hello, EA experts,

I can import Excel to EA but after importing, how can I sync EA with the changes made to the Excel sheet?

Thank you so much!
Mo   
Thank you to all the contributors who spread their knowledge and experience!

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13304
  • Karma: +557/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Sync Excel and EA
« Reply #1 on: December 09, 2020, 04:01:22 pm »
You can do that with the excel importer tool I made

https://bellekens.com/ea-excel-import-export/

Geert

EA_enthusiast

  • EA User
  • **
  • Posts: 172
  • Karma: +0/-0
  • I'm a lifelong learner
    • View Profile
Re: Sync Excel and EA
« Reply #2 on: December 10, 2020, 03:51:36 am »
Thank Greet. I will try it!

I am curious to know how I can sync using the MDG Integration for Microsoft Office.
Thank you to all the contributors who spread their knowledge and experience!

Richard Freggi

  • EA User
  • **
  • Posts: 487
  • Karma: +18/-7
    • View Profile
Re: Sync Excel and EA
« Reply #3 on: December 10, 2020, 01:40:38 pm »
Read my past posts if you want some info on the Office Integration MDG. 
Geert's Excel importer is much easier to use and has far better performance for large datasets.  I use both regularly.

EA_enthusiast

  • EA User
  • **
  • Posts: 172
  • Karma: +0/-0
  • I'm a lifelong learner
    • View Profile
Re: Sync Excel and EA
« Reply #4 on: December 11, 2020, 03:55:35 am »
Thank you, Richard for the advice. I will do  :)
Thank you to all the contributors who spread their knowledge and experience!

EA_enthusiast

  • EA User
  • **
  • Posts: 172
  • Karma: +0/-0
  • I'm a lifelong learner
    • View Profile
Re: Sync Excel and EA
« Reply #5 on: December 26, 2020, 05:39:48 pm »
Geert and Richard, thank you.

Geert's tool worked very well for importing enumerations and their associalted attributes.
Thank you to all the contributors who spread their knowledge and experience!