Service Desk Practitioners Forum
cancel

import data from excel error

Highlighted
rahul sood_1
Contributor.

import data from excel error

hi,

I am using Hp Ov 4.5.
While trying to import data from excel i am getting following error :
warning: Attribute not defined: NAME 1 on entity CMDB (id = 1)
warning: Attribute not defined: CATEGORY on entity CMDB (id = 1)
warning: Attribute not defined: SERIAL NUMBER on entity CMDB (id = 1)
warning: Attribute not defined: STATUS on entity CMDB (id = 1)
ERROR: Parser error: java.lang.NumberFormatException: 5555.0
at java/lang/Integer.parseInt
at java/lang/Integer.
at com/hp/ifc/ext/imp/AppLoadHandler.characters
at com/jclark/xml/sax/Driver.flushData
at com/jclark/xml/sax/Driver.endElement
at com/jclark/xml/parse/EntityParser.parseContent
at com/jclark/xml/parse/EntityParser.parseDocumentEntity
at com/jclark/xml/parse/DocumentParser.parse
at com/jclark/xml/parse/base/ParserImpl.parseDocument
at com/jclark/xml/sax/Driver.parse
at com/hp/ifc/ext/imp/AppImpTaskParser.parseFile
at com/hp/ifc/ext/imp/AppImpTaskParser.XmltoObject
at com/hp/ifc/ext/imp/AppImpTaskParser.parseChunk
at com/hp/ifc/ext/imp/AppImpTaskParser.parseSerial
at com/hp/ifc/ext/imp/AppImpTaskParser.parse
at com/hp/ifc/ext/imp/ImportXmlCim.startImportTask
at com/hp/ifc/ext/imp/ImportXmlCim.startImportTask
at com/hp/ifc/ext/imp/ImportXmlCim.main
java.lang.NumberFormatException: 5555.0
warning: fatal_error occurred while processing CMDB.xml_1.xml

4 REPLIES
Err_1
Acclaimed Contributor.

Re: import data from excel error

Hi,

Two possible reasons:

1. Make sure that have mapped properly the fields, so you are not passing a numeric value into a non-numeric field.
2. Go to Excel and change the format of the column that holds the value 5555.0, remove the decimals from the column format; SD seems to be expecting an Integer value, and you are sending a floating value.

Points are welcome for the help.

Regards;
Randall Barrantes
SW Support Delivery Manager
rahul sood_1
Contributor.

Re: import data from excel error

hi,


the above error was solved. Now it gives a new error mesasage.

pl see the attached log and the import mapping.

thnx.
rahul sood_1
Contributor.

Re: import data from excel error

hi,

its working fine now... there were spaces in the column names.

Thanx for the help.

Rahul
rahul sood_1
Contributor.

Re: import data from excel error

solution found