Merge of Models via CSV-Import (elements only)

Started by JoeKr, January 31, 2019, 10:19:20 AM

Previous topic - Next topic

JoeKr

Dear all,

I defined a model and exported the set of elements to: elements.csv

ID,"Type","Name","Documentation"
45d909a8-238a-4a51-bcbd-5c002b706f36,"ArchimateModel","MyModel",""
78117ebe-d813-4961-ade7-81805df16bba,"Resource","MyR",""
67391dd0-97a3-4b19-91ca-0add2685cb9d,"BusinessRole","MyBR",""

Then I want to merge elements from the csv-file try.elements.csv into the model using:

ID,"Type","Name","Documentation"
45d909a8-238a-4a51-bcbd-5c002b706f36,"ArchimateModel","MyModel",""
,"BusinessEvent","MyEvent",""
,"BusinessRole","MyRole",""

But it always lead to the error message:

Incorrect record size.

What is going wrong?

Regards,

Joe

Phil Beauvoir

January 31, 2019, 10:23:01 AM #1 Last Edit: January 31, 2019, 10:33:57 AM by Phil Beauvoir
Looks like missing quotes on ID header and IDs. The exported CSV will have quotes around them. Also, you are missing IDs.

Correct:

"ID","Type","Name","Documentation"
"45d909a8-238a-4a51-bcbd-5c002b706f36","ArchimateModel","MyModel",""
"","BusinessEvent","MyEvent",""
"","BusinessRole","MyRole",""
If you value and use Archi please consider making a donation! https://www.archimatetool.com/donate

JoeKr

Dear Phil,

thank you for your quick answer. The (real) file was almost correct. The problem coming with using Microsoft tools, which include double qoutes twice, on both side of the ID, Type, .. This was not neither visible in Notepad, nor in Excel.

The csv-file file looked in a plain-texteditor like this:

""ID"",""Type"",""Name"",""Documents""

etc.

i.e. double qoutes twice, which lead to the error message.

I hope its a help for everyone using Windows, having problems with an import

Thank you and regards,

Joe