Recent posts

#21
General Archi Discussion / Re: Import elements from CSV f...
Last post by Xiaoqi - May 20, 2023, 19:20:10 PM
Hi Oysteino,

I've recoreded one short video here https://youtu.be/YaSxrXofo24 with using the latest Archi 5.0.2, on how to export and import model from CSV, for your reference.

My experience is need specific notice on the first column in Elements.csv, which you should ensure that's employ with do not miss the ";", and alos the last two columns are normally empty but don't miss the enough ";".

And, suggest to edit CSV in some code IDE, like VS Code, prevent to use Excel. Just my two cents input. Good luck!

Regards, Xiaoqi
#22
General Archi Discussion / Re: Import elements from CSV f...
Last post by oysteino - May 20, 2023, 10:34:21 AM
Okay, so I've found a workaround. I created an excel macro, but I hope someone can help with an easier fix as it is somewhat cumbersome.

1) Define the elements as described in the video above (or similarly for properties and relations)
2) Mark all the cells you want included in csv
3) Press "Generate CSV"
4) Write exact output. E.g. "C:\Archimate\elements.csv"

QuotesCSV.xlsm
#23
General Archi Discussion / Re: Import elements from CSV f...
Last post by oysteino - May 20, 2023, 09:13:11 AM
Okay, seeing the issue now. All of the above attempts give some error in the quotation marks.
Either
  • Double, e.g. ""ID""
  • None, e.g. ID

Correct representation should be single quotation marks around all of them.

Import issue.PNG

Issue remains the same, though. I want to quickly manipulate elements, properties and relationsships in excel. Anyone see what I'm doing wrong?
#24
General Archi Discussion / Import elements from CSV file ...
Last post by oysteino - May 20, 2023, 07:58:47 AM
Hi, I've been trying to import CSV-file for elements generated in Excel following this tutorial

I'm getting "Incorrect Header in Elements file" error for Archi 5.0.2 no matter whether I'm trying elements, relations or properties-file

I'm getting "Incorrect record size" error for Archi 4

Using Windows 64-bit

I've tried
  • Manually creating file and saving as UTF-8 CSV
  • Exporting existing file, delimiting, and importing
  • Exporting, manipulating exactly 1 character, and re-importing
  • Exporting, and directly re-importing to another model. This works, but gives no value

exportAndDelimited-elements.csv
exportAndReimportThatWorks-elements.csv
manualCSV-elements.csv 
exportAndReimportModified-elements.csv 
#25
General Archi Discussion / Re: [Share] Archi usage tips d...
Last post by Xiaoqi - May 17, 2023, 16:43:13 PM
Thanks Phil, it's my honor to get chance to learn and share ;-)
#26
General Archi Discussion / Re: [Share] Archi usage tips d...
Last post by Phil Beauvoir - May 17, 2023, 16:04:23 PM
Hi Xiaoqi,

many thanks to you for creating and sharing these videos, they are very helpful. I tweeted the link on Twitter.

Regards,

Phil
#27
Other Plug-ins / Re: Database plugin
Last post by JoCriSem - May 17, 2023, 12:50:23 PM
Thanks.  got it.
#28
Other Plug-ins / Re: Database plugin
Last post by Phil Beauvoir - May 17, 2023, 09:59:04 AM
#29
Other Plug-ins / Database plugin
Last post by JoCriSem - May 17, 2023, 09:46:02 AM
Probably a stupid question, but the database plugin has no 'jar' in the GitHub repo.
I can't remember I needed to compile or am I getting old ;-)

Thanks.
Johan.
#30
General Archi Discussion / Re: [Share] Archi usage tips d...
Last post by Xiaoqi - May 17, 2023, 01:18:17 AM
Hi Phil,

Thanks greatly for your encouragement and all of the help to me and our team when adopting Archi tool, I must say you (and JB) are running our forum here making it with top level on response & problem fixing effeciency!

From my first recorded video on ArchiSurance case study till now, one month passed so fast, today I'm glad to share that I've completed all of the views modeling, here Archi Tool Modeling Practice - ArchiSurance is the full list, with total 44 videos.

Archi modeling is one exciting learning journey, when reading this ArchiSurance again (last time was some years ago already when preparing the ArchiMate exam), it really teaches you more if you do the hands-on modeling piece-by-piece. Practice is the only way for anyone to learn one new language, that's same to ArchiMate, and our Archi tool creates one comfortable & no-gapping environment for you to "speak" this language with the author of the case study.

I do hope to share this with you, while you are watching, the most important thing is you open the Archi and do modeling yourself at the sametime. After every phase, I also added one video to show the summarized modeling pattern from the views in that phase. Know that's not the complete pattern but just use this way to making one level abstraction, you can use that as one basis for making other models.

After every video / video, I've saved the Archi model into one snapshot file, you can visit the Github repository on ArchiSurance_Practice to get all of those snapshot models separately. That will help you start your modeling from any of the views in this case study, which already includes the elements/relationships done in previous views in accumulated manner.

During this learning, I also document some tips and investigations, which putting together in the Videos List on Archi Tool Tips, feel free to check that as well. (This is kept adding new findings if any).

This is my first series modeling practice captured in video, I believe there're numbers of mistakes or some areas can be done in more effective way, really hope to get your comments and suggestions, and moving forward, I'd like to keep adding more practices on our tool platform.

Thanks for all of your experience and supporting!
Xiaoqi