I'm an ex-System Architect user and am keen to give Essentials a go here (new place). Unfortunatly I don't have much xml/xls experience, so any pointers much appreciated.
I've a load of source hardware data in excel format.
To limit my learning curve i'm trying to manipulate the data within excel and export the data in suitable xml format to import using the essentials integration tab and the standard importEssentialInstances.xsl.
I have succesfuly imported a series of hardware nodes, such as the xml example:
Code: Select all
<?xml version="1.0" ?>
<knowledge_base
xmlns="http://protege.stanford.edu/xml"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://protege.stanford.edu/xml http://protege.stanford.edu/xml/schema/protege.xsd">
<simple_instance>
<name>ExcelSpreadsheetNameAndLineRef1</name>
<type>Technology_Node</type>
<own_slot_value>
<slot_reference>description</slot_reference>
<value value_type="string">s/n USE548N0T3</value>
</own_slot_value>
<own_slot_value>
<slot_reference>name</slot_reference>
<value value_type="string">CALLMANAGER01</value>
</own_slot_value>
</knowledge_base>
I've hit a wall trying to expand on this to include links to other (existing) instances within the repository; in this case linking the Technology_Node 'CALLMANAGER01' to the site 'Gratham Road', which I already have defined.
I'm appended the following lines:
Code: Select all
<?xml version="1.0" ?>
<knowledge_base
xmlns="http://protege.stanford.edu/xml"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://protege.stanford.edu/xml http://protege.stanford.edu/xml/schema/protege.xsd">
<simple_instance>
<name>ExcelSpreadsheetNameAndLineRef1</name>
<type>Technology_Node</type>
<own_slot_value>
<slot_reference>description</slot_reference>
<value value_type="string">s/n USE548N0T3</value>
</own_slot_value>
<own_slot_value>
<slot_reference>name</slot_reference>
<value value_type="string">CALLMANAGER01</value>
</own_slot_value>
<own_slot_value>
<slot_reference>technology_deployment_located_at</slot_reference>
<slot_reference>name</slot_reference>
<value value_type="string">Gratham Road</value>
</own_slot_value>
</simple_instance>
</knowledge_base>
(I think I should have something stating the 'type' is 'site' but i've tried many concertations with no sucess. I also tried the 'importTechNodes' example xml/xsl combo, but it failed with
)javax.script.ScriptException: Traceback (innermost last):
File "<unknown>", line 5, in ?
IOError: File not found - standardFunctions.txt (The system cannot find the file specified)
Many thanks for any input,
Matt