Author Topic: Excel import MDG Office really slow?  (Read 1838 times)

Hurra

  • EA User
  • **
  • Posts: 132
  • Karma: +0/-0
    • View Profile
    • Find me at LinkedIn!
Excel import MDG Office really slow?
« on: February 28, 2018, 09:17:16 pm »
Hello!

I import 500 elements from an excel. My feeling it is reaaally slow.. about 1 hour or more.

Does it depend on my import profile or is this just the way it is? Can I some how optimize and speed up the import?

Robert

edit: working on a SQL repository through VPN connection
« Last Edit: February 28, 2018, 09:19:22 pm by RWHurra »
always learning!

Arshad

  • EA User
  • **
  • Posts: 207
  • Karma: +15/-1
    • View Profile
Re: Excel import MDG Office really slow?
« Reply #1 on: February 28, 2018, 09:36:28 pm »
Hi RWHurra

Usually it wont take more than an hour for just importing 500 elements with main properties.
 
If you have mapped connector information in profile and checked multiple packages in Additional Packages to Look up section  then it will take some time to process and get the detail from selected packages.In that case too it won't take an hour for 500 elements.

Are you importing from Excel directly using the ribbon or importing from inside EA from extensions ?
Give a try directly from Excel Enterprise Architect Ribbon


BR
Arshad
« Last Edit: February 28, 2018, 09:37:59 pm by Arshad »

Hurra

  • EA User
  • **
  • Posts: 132
  • Karma: +0/-0
    • View Profile
    • Find me at LinkedIn!
Re: Excel import MDG Office really slow?
« Reply #2 on: February 28, 2018, 10:00:32 pm »
Thanks Arshad!

I have no connector information and not additional packages. I import directly in EA. Will try the EA ribbon next time!
always learning!

Hurra

  • EA User
  • **
  • Posts: 132
  • Karma: +0/-0
    • View Profile
    • Find me at LinkedIn!
Re: Excel import MDG Office really slow?
« Reply #3 on: March 01, 2018, 08:51:06 am »
The import is still going strong like 12 hrs later...
always learning!

Arshad

  • EA User
  • **
  • Posts: 207
  • Karma: +15/-1
    • View Profile
Re: Excel import MDG Office really slow?
« Reply #4 on: March 01, 2018, 05:01:00 pm »
Hi RWHurra

Try sharing the profile which you created

Hurra

  • EA User
  • **
  • Posts: 132
  • Karma: +0/-0
    • View Profile
    • Find me at LinkedIn!
Re: Excel import MDG Office really slow?
« Reply #5 on: March 01, 2018, 07:15:14 pm »
always learning!

Arshad

  • EA User
  • **
  • Posts: 207
  • Karma: +15/-1
    • View Profile
Re: Excel import MDG Office really slow?
« Reply #6 on: March 01, 2018, 07:25:00 pm »
Seems you've mapped some parent information in the profile.
Maybe cause of this the time exceeds.

Try importing it without mapping parent information in profile


Arshad


Hurra

  • EA User
  • **
  • Posts: 132
  • Karma: +0/-0
    • View Profile
    • Find me at LinkedIn!
Re: Excel import MDG Office really slow?
« Reply #7 on: March 03, 2018, 12:59:02 am »
Try importing it without mapping parent information in profile

Well, the parent information was important. The import is done hopefully I will not need to do it again. If I have to, I'll do it on a saturday then go back to sleep :D
always learning!