Archi Forum

Archi => Share your Models, Templates and Reports => Topic started by: JoeKr on January 31, 2019, 10:19:20 AM

Title: Merge of Models via CSV-Import (elements only)
Post by: JoeKr on January 31, 2019, 10:19:20 AM
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
Title: Re: Merge of Models via CSV-Import (elements only)
Post by: Phil Beauvoir on January 31, 2019, 10:23:01 AM
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",""
Title: Re: Merge of Models via CSV-Import (elements only)
Post by: JoeKr on January 31, 2019, 14:01:48 PM
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