Author Topic: Bellekens EA Excel Importer Not Working (Read 4831 times)

iDavid · « **on:** October 21, 2020, 06:28:04 pm »

Hi, I am trying to import classes but even though the excel addin runs with no errors, nothing is added to EA.
I am running importer v4.2 and EA v15.2.
I have used an earlier version of the importer with EA v15.0 with no problems, and rely heavily on this tool! Any help appreciated.

Geert Bellekens · « **Reply #1 on:** October 21, 2020, 06:55:29 pm »

If you send me an sample file I would be happy to have a look.

Geert

iDavid · « **Reply #2 on:** October 21, 2020, 11:55:24 pm »

Hi Geert, happy to send the excel, but how do I attach it here?

Type     Name     Stereotype   Description
class     Test1 Yardi
attribute    Yardi Entity Id        HMY
attribu Property Holder Id HPROP

Geert Bellekens · « **Reply #3 on:** October 21, 2020, 11:58:51 pm »

Quote from: iDavid on October 21, 2020, 11:55:24 pm

Hi Geert, happy to send the excel, but how do I attach it here?

Type     Name     Stereotype   Description
class     Test1 Yardi
attribute    Yardi Entity Id        HMY
attribu Property Holder Id HPROP

You can't. But you can send me an email.

Geert

Richard Freggi · « **Reply #4 on:** October 22, 2020, 02:26:04 am »

The importer works extremely well for me (around 3,000 classes and 270,000 attributes a couple of times a month). But you must use *.eap file! I don't know if it works with other model databases.

iDavid · « **Reply #5 on:** October 22, 2020, 02:30:36 am »

I did try importing into an .eapx version, but still didn't work! Which version of EA are you using?

Sunshine · « **Reply #6 on:** October 22, 2020, 07:26:01 am »

Perhaps trying creating an element within Sparx EA then exporting using the Excel exporter to see what the format looks like then add the new elements and attributes and import using excel importer.

iDavid · « **Reply #7 on:** October 22, 2020, 06:28:56 pm »

Thanks for the suggestion, but I did try that and the export failed! Am wondering if this is something to do with EA 15.2 compatibility as it worked fine with 15.0

PS I have now tried running on EA v15.0 and get the same error. So the only other variable is that I have a new laptop running Windows 10.

iDavid · « **Reply #8 on:** October 23, 2020, 02:46:32 am »

Problem solved. When running the Excel importer-exporter v5.0 the export and import both failed with Runtime Error - -2146232576 (80131700). It seems the problem was that I needed to turn on .Net framework 3.5 (includes 2.0 and 3.0). After rebooting, the export worked fine.
Thanks to all who offered suggestions.

Geert Bellekens · « **Reply #9 on:** October 23, 2020, 04:21:48 am »

Good to know you figured it out.

I should maybe add that as a requirement on the website. I tend to use .Net's ArrayList quite often, and that is from .net 3.5

Geert

Sparx Systems Forum

News: