Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Error Importing Organization Data into SD !

Highlighted
Thiwanka
Regular Collector

Error Importing Organization Data into SD !

Dear All,

I am trying to import a batch of "Organizations" into SD DB.
Org fields are : [Searchcode],[Name1],[telephone],[Email1],[street1]

***Export INI File :

[DSN]
NAME=DSNORG
USR=
PWD=

[SYSTEM]
LOG=TRUE
XML=TRUE
LOG_FILE=org_excel.log
XML_OUTPUT_FILE=org_excel.xml
APPLICATION_NAME=org_excel

[CLASSES]
NAME=org_import

[org_import]
SOURCE=ORG
ATT=[Searchcode],[Name1],[telephone],[Email1],[street1]
COLUMNS=[Searchcode],[Name1],[telephone],[Email1],[street1]
LOADTABLE=TRUE

*** XML File Attached Herewith

I am getting the following error (error logs attached)
--------------------------------

Following problems encountered while loading entities:
======================================================
Processing org_import (id = 1)
com/hp/itsm/po/cl/WFTelephoneSet

while processing attribute TELEPHONE
com/hp/ifc/wf/AppEntitySet

while processing attribute STREET1
Inserting new instance of org_import
While processing org_import (id = 1):
com.hp.ifc.ext.ExternalException: For organization the following fields are required: telephone number.

Pls help/advice me to resolve this error !!!

Thanks,

Thiwanka.
IT is Great !
3 REPLIES
Thiwanka
Regular Collector

Re: Error Importing Organization Data into SD !

Dear All,

I have attched the mapping file as well !
IT is Great !
Mihai Tita
Occasional Visitor

Re: Error Importing Organization Data into SD !

Hi,

It is necessary a class for (organization) telephone number, for example PHONE class.
The PHONE class will be imported to the
Telephone item in Service Desk.
The PHONE class is mapped
to the item called Telephone in Service Desk. The phone template is
used for this class.
The attributes in the ATT line are mapped to fields that are available in the default template. In your case [SEARCHCODE]
will be mapped to the Organization field and [TELEPHONE] mapped to the
Number field. Both attributes are unique keys.

Regards,
Mihai
Mihai Tita
Occasional Visitor

Re: Error Importing Organization Data into SD !

Hi,

Same situation for organization street.
You need another class, for example STREET class.
The Address template is
used for this class.
In your case [SEARCHCODE]
will be mapped to the Organization field and [STREET1] mapped to the street1. Both attributes are unique keys.
If you need more details, I can attach some files.

Regards,
Mihai
//Add this to "OnDomLoad" event