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

Importing of values into code field of service call item

Highlighted
Venkatesha_1
Esteemed Contributor

Importing of values into code field of service call item

Hello,

Can we import the values for the code field to SD.

The requirement is as follows.
Need to import the values(more than 250 items for each field) for the field "Belongs To" & "Attributed To" from the excel sheet for the service call item. Can this be possible from sd_import or any kind of script to import instead of manually add values to it.

Regards
Venkatesha
7 REPLIES
Mark O'Loughlin
Honored Contributor

Re: Importing of values into code field of service call item

Hi,

you can use data exchange to import the values. There is a full document on Data Excange available at the below link which details in full what needs to be done

http://ovweb.external.hp.com/lpe/doc_serv/
Venkatesha_1
Esteemed Contributor

Re: Importing of values into code field of service call item

Hello,

Can we import the values for the code field to SD?.

Regards
Venkatesha

Re: Importing of values into code field of service call item

Yes you can.
you have to use Data Exchange and in your import mapping process you have to configure a class specifing your code object, template for it and mapping fields...

Look at the documentation mentioned above.

bye bye,
Simone
Venkatesha_1
Esteemed Contributor

Re: Importing of values into code field of service call item

Hello,

I did not see any solution in the document.

For eG, in the excel file i've values like
RED
BLUE
GREEN

i have code field called "color"(A Service Call custom field) that has the value in DB as
PINK
ORRANGE


After import i want the code field "color" to have these values.
RED
BLUE
GREEN
PINK (NEWVALUE)
ORRANGE (NEWVALUE)

Is this possible ?




Regards
Venkatesha
Ramaprasad N
Esteemed Contributor

Re: Importing of values into code field of service call item

Yes, you can import values to code fiels.

In your example, you have a code field named 'Colour' for service calls. Follow these steps to import data to this custom field.
Open the Admin console. Navigate to Data --> Templates --> Colour
In the right pane, right click and create a new template with any suitable name. Assign it to a template group/category and save the template record.
Now, come to Data exchange tasks. Hope you are well aware of data export process. You may have data in an excel sheet. Configure an ini file to export data from excel to an XML document.
In the import mapping, type name, select 'Colour' as your item and select the newly created template as the template for data import. Type in your column name as a value for 'Text' attribute, in the import mapping. Select the same as 'Unique Key' constraint.
Start/run the DE task.

Hope this works for you.

-Ram
Venkatesha_1
Esteemed Contributor

Re: Importing of values into code field of service call item

Hi Ram,

It worked fine. This saves the time of entering lots of values for code field.

-Venky-
Venkatesha_1
Esteemed Contributor

Re: Importing of values into code field of service call item

The solution worked fine !
Thanks alot
//Add this to "OnDomLoad" event