Book a Demo

Author Topic: NDG MS Office. Export to Excel Run States  (Read 3153 times)

XGala

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
NDG MS Office. Export to Excel Run States
« on: October 31, 2019, 07:17:03 pm »
Hello! I am new to using EA so I need your help. I use EA v 15. I need to transfer a lot of data from EXCEL to EA. I try to do it using MDG MS Office. I can not import the value Run States  of the object from EA into EXCEL. Is it possible? And how to do it? Thank.

Sunshine

  • EA Practitioner
  • ***
  • Posts: 1353
  • Karma: +121/-10
  • Its the results that count
    • View Profile
Re: NDG MS Office. Export to Excel Run States
« Reply #1 on: November 01, 2019, 10:23:38 am »
Don't think its possible using MDG Office nor the CSV Import/Export features in Sparx EA. However after importing you objects via MDG Office or CSV Import you could import your spreadsheet into a table in the DB. If its eapx file you can use MS Access to import excel table.
Once you have the data in a table in the DB you can use SQL statement to update/add the necessary field in the table where the run-time states are stored. Sorry don't know what table and field the run-time states are stored you'll have to discover that yourself.
Happy to help
:)