Configure xml import to Essential OS

Post Reply
dhaya.karuthedathu
Posts: 5
Joined: 24 Jul 2022, 11:48

Hi,

A newbie here looking for some handholding.
I got the essential OS downloaded and got the viewer and import utility up and running.
I also published the baseline essential_baseline_v6.15.zip from protege 3.5.

Before modifying classes and slots, I would like to make the automated data import from our cmdb system.
I can extract the data as CSV/XML or direct DB connections from the cmdb system, however I am yet to determine how to import the data automatically into the essential viewer.
I would like to use Protege for class modifications and publish it, where as import utility for data imports.

CSV is a bit easier for me instead of xml but cant seem to figure out the import specifications configuration. Appreciate if anyone can send me a screenshot for the technology_node class data import specification with Excel/csv columns (id, name,short_name)
I also tried the Automated XML data import by suing the reportXML.xml with a old copy of xsl from https://enterprise-architecture.org/sha ... no_html,1/ However i get standardfunctions.py is missing error.

Basically I can make cmdb system generate xml or CSV data outputs which I need to regularly import into Essential viewer, any step by step guide on the xsl transform for xml or excel import specification would be great.
Thanks very much in advance.
User avatar
neil.walsh
Posts: 444
Joined: 16 Feb 2009, 13:45
Contact:

Hi,

You might want to start with Essential Launchpad which will provide you with a full spreadsheet and import specification for the most common aspects people capture. You can then copy and adapt it if necessary or just study the patterns for building your own.

Just request Launchpad to import the Excel, register here https://enterprise-architecture.org/ess ... nchpad.php and the team will send you a pack.

Once you have the import specification built and tested, you can then use the Import Utility API to create an automated import.

https://enterprise-architecture.org/dow ... pec_v2.pdf

If you have more sophisticated requirements, you can contact EAS for commercial support and training.

Cheers

Neil
dhaya.karuthedathu
Posts: 5
Joined: 24 Jul 2022, 11:48

Thanks Neil, i will have a look
Post Reply