Author Topic: EA Excel VBA Importer not loading AttributeType (Read 3673 times)

David Ingleton · « **on:** January 29, 2020, 10:31:42 pm »

I am using the Bellekens Excel importer to load new columns into tables in a database model. The columns are added OK, but the datatype is empty after load. I have set the AttributeType and AttributeLength columns on the spreadsheet. Can anyone help? I have a lot of updates to make!

Geert Bellekens · « **Reply #1 on:** January 29, 2020, 10:49:40 pm »

David,

Have you tried with the newest version? 5.0?
I published this version yesterday.
https://bellekens.com/ea-excel-import-export/

I don't think the older versions properly support precision and scale, which you need for database models.

Geert

David Ingleton · « **Reply #2 on:** January 29, 2020, 10:59:20 pm »

Thanks Geert! There are a lot of new columns in this version, do you have any documentation yet?

Geert Bellekens · « **Reply #3 on:** January 30, 2020, 01:25:43 am »

The documentation is on the same webpage: https://bellekens.com/ea-excel-import-export/

This new version works based on the header name, not on the position in the sheet like the previous version.
You can delete the columns you don't need.

Geert

David Ingleton · « **Reply #4 on:** January 30, 2020, 04:04:25 am »

I have set up the import to create 3 columns on an existing table (Action Update table, create each column). It seems to run OK but nothing is updated in EA. It did finish very quickly, as soon as I pressed OK it returned with the Finished message.

Geert Bellekens · « **Reply #5 on:** January 30, 2020, 05:14:18 am »

If you send met the excel file I can have a look.
(maybe save it as a macro free excel, otherwise the email clients won't let it go through)

[email protected]

Geert

David Ingleton · « **Reply #6 on:** January 30, 2020, 10:33:56 pm »

Import is working OK now. Thanks for your help Geert.

Sparx Systems Forum

News: