Service Desk Practitioners Forum
cancel

Data exchange question

Highlighted
The observer
New Member.

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
Acclaimed 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.