Automate export CSV in VBScript

[FrankStanssens]

Hi,

I'm using VBScript to automate some documentation generation.
One of the actions I want is to export to CSV using a created CSV Specification. (manually by using menu Package - Import/Export - CSV Import/Export)
Can anyone point me in the right direction to do this with VBScript?

Thanks in advance,

Frank

[Arshad]

FYI

You can try this Sparx MDG for Microsoft Office Tools ( Excel Exporter )

Excel Export allows users to publish Enterprise Architect model contents including elements, connectors, tagged values, attributes and operations, as Excel Workbooks. Users also have the flexibility to generate the model contents to a pre-formatted Excel worksheet.It can be used to sync back excel contents with EA.

HTH
Arshad

[Geert Bellekens]

There is no way to use the CSV export/import definitions from scripting.

What you can do is write your own import/export routine. It is really not that difficult.

I have a couple of export script in my VBScript library: https://github.com/GeertBellekens/Enterprise-Architect-VBScript-Library

Geert

[FrankStanssens]

Hi Geert,

Thank you for your quick answer

What a pitty! I already automated HMTL reporting by RunHTMLReport. Thought I could do the CSV export the same way.
Guess it isn't possible using C# neither?

I would actually want to use that specification, so when someone exports manually or by script the result would be the same

Greetings,

Frank

[Geert Bellekens]

C# and VBscript use the same API, so no 

Geert

[FrankStanssens]

Ok, trying it the hard way lol

is there a way you can get an element property by name, like myElement.GetPropertyByName("GUID")

[Geert Bellekens]

Not really.
You can either use the API like myElement.ElementGUID (see https://www.sparxsystems.com/enterprise_architect_user_guide/14.0/automation/reference.html for an API reference) or you can use Repository.SQLQuery() to get your data as a set.

I would probably go for the latter in case of an export. There is a huge difference in performance between the two.

Geert

[qwerty]

Not to forget Repository.GetElementsByQuery.

q.

[FrankStanssens]

ok. Thank you all for your help

Frank