Highlighted
Contributor.. Contributor..
Contributor..
285 views

trying to import business applications from a .xls files.

but when I do I get the following errors

 

<execution jobId="BusinessApps" destinationid="22b58b2753748c6eef73fe27542c4eec" max_store_sent_results="2147483647">
	<destination>
		<destinationData name="ip_domain"></destinationData>
		<destinationData name="hostId"></destinationData>
		<destinationData name="id">22b58b2753748c6eef73fe27542c4eec</destinationData>
		<destinationData name="ip_address"></destinationData>
	</destination>
	<params>
		<param param_name="integer_list_delimiter" param_value="," />
		<param param_name="runInSeparateProcess" param_value="true" />
		<param param_name="set_empty_value" param_value="false" />
		<param param_name="JOB_ID" param_value="BusinessApps" />
		<param param_name="taskType" param_value="regular" />
		<param param_name="file_name" param_value="j:\hp\ucmdb\ciimports.xls" />
		<param param_name="relationship_attr_delimiter" param_value="|" />
		<param param_name="maxThreadRuntime" param_value="900000" />
		<param param_name="remoteJVMClasspath" param_value="%minimal_classpath%;../lib/dom4j.jar;../runtime/probeManager/discoveryResources/geronimo-stax-api_1.0_spec-1.0.jar;../runtime/probeManager/discoveryResources/poi-3.7-beta1-20100620.jar;../runtime/probeManager/discoveryResources/poi-ooxml-3.7-beta1-20100620.jar;../runtime/probeManager/discoveryResources/poi-ooxml-schemas-3.7-beta1-20100620.jar;../runtime/probeManager/discoveryResources/xmlbeans-2.3.0.jar" />
		<param param_name="string_list_delimiter" param_value="," />
	</params>
	<log start="11:13:29" severity="info">Execution current time:2017/10/26 11:13:29</log>
	<log start="11:13:29" severity="debug">Excel file to process:j:\hp\ucmdb\ciimports.xls</log>
	<log start="11:13:29" severity="debug">file j:\hp\ucmdb\ciimports.xls exists</log>
	<log start="11:13:29" severity="debug">Excel 97-2003 format</log>
	<log start="11:13:32" severity="info">	------------------------------------------------------------------</log>
	<log start="11:13:32" severity="info">	Process all tabs and create OSH from them; Root containers and links will be created lately</log>
	<log start="11:13:32" severity="info">	------------------------------------------------------------------</log>
	<log start="11:13:32" severity="debug">Processing worksheet: Grid's rowdata</log>
	<log start="11:13:32" severity="debug">
Traceback (most recent call last):
  File "import_from_excel", line 264, in processWorkbook
  File "xlsutils", line 193, in getTypeDefs
ValueError: CIT: "Grid's rowdata" not found in UCMDB class model
</log>
	<log start="11:13:32" severity="info">	------------------------------------------------------------------</log>
	<log start="11:13:32" severity="info">	Process root containers from early created OSHes</log>
	<log start="11:13:32" severity="info">	------------------------------------------------------------------</log>
	<log start="11:13:32" severity="debug">Processing references of worksheet: Grid's rowdata</log>
	<log start="11:13:32" severity="info">	------------------------------------------------------------------</log>
	<log start="11:13:32" severity="info">	Report OSH to vector</log>
	<log start="11:13:32" severity="info">	------------------------------------------------------------------</log>
	<log start="11:13:32" severity="debug">reported 0 objects</log>
	<log start="11:13:32" severity="info">	------------------------------------------------------------------</log>
	<log start="11:13:32" severity="info">	Process relationships</log>
	<log start="11:13:32" severity="info">	------------------------------------------------------------------</log>
	<log start="11:13:32" severity="info">	No relationships tab was found for processing</log>
	<log start="11:13:32" severity="info">Execution current time:2017/10/26 11:13:32</log>
</execution>

 

Anyone got any Ideas on how to resolve this?

0 Likes
2 Replies
Highlighted
Super Contributor.. Super Contributor..
Super Contributor..

Re: trying to import business applications from a .xls file

Hi Jim!

You need to name the worksheets correct.

If you have Business Application, the correct name of the worksheet should be business_application which is the name of the ci type Business Application.

And then you create a new worksheet named relationships, where you call for BusinessApplication1 in column A and for instance usage (linktype) in column B and finally BusinessApplication2 in column3. I have some more settings for Changing the name of the link and I also create a comment in data_note of the link. But I think you find this in the documents.

 

Wbr / Fredrik

0 Likes
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

Re: trying to import business applications from a .xls files.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.