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

Data exchange question

Highlighted
The observer
Acclaimed Contributor

Data exchange question

Hello,

i have a question about a problem i have when i want to compare 2 xml files with Reconciliation. The item/object I want to treat is "Configuration item" category printer

1) i have defined an ini file, for this I configured an import mapping where i defined a value mappings for example BRAND
H.P. => HEWLETT PACKARD
S.T. => STORAGETEK
The value will be in the view V_VALUEMAPPING

2) i have configured an export ini file for the export CMDB.
The problem is that here are BRAND defined where never a valuemapping has been created.

When i want to reconciliate the data now
import xml with export xml.... i have a problem:

For example:

I have a printer X123 who has as a BRAND "Peregrine Systems"
So i will not find the value "P.S." but the full brand name "Peregrine Systems" when I do an export of the CMDB...
in my import xml file i will find "P.S."
So a difference will be found

Does anyone has an idea how i can solve this?

Greetings



1 REPLY
Jonathon Druce
Honored Contributor

Re: Data exchange question

The XML files need to have the same data attributes both in name and values for the records to be seen as the same. In your case all records are different and you are "manipulating" the brand data during the import.

Why not manipulate the data during the export. For example if your data source is SQL you can use a statement like;

case upper([data].[brand]) \
when 'H.P.' THEN 'HEWLETT PACKARD' \
when 'S.T.' THEN 'STORAGETEK' \
else [data].[brand] end \
AS [brand]

Just add a line for each brand. This is easier to view and edit than import mappings and your XML records will allways have the correct data for this attribute.
//Add this to "OnDomLoad" event