[Ask] Import/Export attributes of each class - Done

[demian824]

Hello Professors,

I am looking for how to import or edit/sync attributes in classes. I tried to use a 'EA Excel import-export' from bellekens.com.
However, all attributes are not imported from the excel file. Only I can import classes.

Could you please help to solve this issue?

Thanks,

WonChul Choi

[Richard Freggi]

it means you are not filling in the excel sheet with the correct values.  For example you need the eaguid to import attributes, so you would need to run the importer for classes only, then export the classes with their eaguid, add the attributes and then import the attributes.  The importer is very reliable and never had any issues (importing 400K total of objects and attributes)

[demian824]

Hello Richard

I used VBA tool 'Export' and 'Import' on the excel file, but it occurred the run time error '-2146232576 (80131700)'.
when I used MDG importer, I filled up GUID and Parents Element name with other information on excel file. However, attributes were not imported. Only classes are imported

ps: Both functions 'eaConn.getPackageTreeIDString(parentPackage)' and 'importAttribute(properties As Dictionary, owner As EA.element, datatypes As Dictionary, pos As Integer)' on VBA are causes of run time error on Export-import excel tool.

Thanks,

WonChul Choi

[Richard Freggi]

Maybe Geert is on holiday, need his input.
You need the Excel importer from the github respository for the 64 bit version of EA 16: the one in bellekens.com does not work in 64 bit.
Geert will fill in info when he's back.

[Geert Bellekens]

Maybe Geert is on holiday, need his input.
You need the Excel importer from the github respository for the 64 bit version of EA 16: the one in bellekens.com does not work in 64 bit.
Geert will fill in info when he's back.

Not on holidays yet. There's no issue with the 64 bit, but a change in the API that doesn't allow to create attributes with an empty name anymore, but I'm not sure if that runtime error would be due to that.
It might also be an issue with the reference to the EA.Interop.dll

Geert

[demian824]

Hello,

To me, I only can use tagged value on Version 5. I can import classes & attribute on 4.2.
Is there anyway to create tagged values when I import elements by the file version 4.2?

Thanks,

WonChul Choi 

[Geert Bellekens]

Hello,

To me, I only can use tagged value on Version 5. I can import classes & attribute on 4.2.
Is there anyway to create tagged values when I import elements by the file version 4.2?

Thanks,

WonChul Choi

Why can't you create attributes with version 5?
Is there an error?

Geert

[demian824]

On version 4, there is no issue to use to me.

However, on version 5, Export_Import functions are not worked.
When I import the data, it keep making run time error that 'Name cannot be blank' although I filled all fields.
When I try to export from Sparx it made runtime error too. It said 'Automation error'

Only Tagged values functions are worked well.

Thanks,

WonChul Choi

[Geert Bellekens]

The "name cannot be blank" error can be fixed by adding a dummy name in the code. Look for attributes.AddNew("" and replace with attributes.AddNew("dummy"

I'll publish a new version once finished.

Geert

[demian824]

Hello Geert,

Now, I can import data. However exporting still does not working to me. It made a run time error on excel or sparx.
I already mentioned the run time error from excel.
Another case, Sparx showed me the message that 'Microsoft Acess Database Engine[0x80004005] The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect'
Do I make a mistake to use the export function?

Thanks,

WonChul Choi

[Geert Bellekens]

Hello Geert,

Now, I can import data. However exporting still does not working to me. It made a run time error on excel or sparx.
I already mentioned the run time error from excel.
Another case, Sparx showed me the message that 'Microsoft Acess Database Engine[0x80004005] The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect'
Do I make a mistake to use the export function?

Thanks,

WonChul Choi

In that case you'll have to adapt the SQL query in the configuration tab. There might be an issue with something like "Default" or similar.

Geert

[qwerty]

Look into %appdata%...Sparx where's a dberror.txt. That should contain the bad SQL.

q.

[demian824]

Where can I find the dberror.txt file? I cannot find any error log file in my program directory.

Thanks,

WonChul Choi

[qwerty]

It's %appdata%. Just type that (with the surrounding % chars) in the (uhm, it's not Finder; was it Explorer?) where you type the path (like C:\ or so). That will bring you somewhere where you find a Sparx directory (I'm currently with no access to Windoze to this is from memory).

q.

[demian824]

Hello all,

Thanks for giving me advices! I finished all task!

Thanks,

WonChul Choi