Thanks Everyone Phase one worked for me! I managed to export all data to XML. But next step failed, which is populating SD :-(
I get the following message: warning: Attribute not defined: TRA APPROVAL on entity LICENCE_CLASS (id = 28) ERROR: Parsing error occurred at: file:/C:/Documents and Settings/Administrator/Application Data/Hewlett-Packard/OpenView/Service Desk/tmp/YJ_Radio_Licenses.xml_1.xml_Entities.str, line 8: character not allowed warning: fatal_error occurred while processing YJ_Radio_Licenses.xml_1.xml
Ok Thanks for everyone for contributing to my issue. I managed to progress, but let me give you my findings (inspired of everyone's feedback): 1) First Problem: Some of the columns did not export to XML. The reason is that the ATTRIBUTE name should match the COLUMN name (including the spaces and spelling). Weired, but it works. For example: I had an attribute called Serial Number. So, in the INI file, I called it SERIAL NUMBER.
2) Regarding Data import to Service desk. Service Desk does not like to see spaces in the PROPERTY NAME for the Field mapping.
So, what I had to do is: After I created the XML, I edited it to match the entries in the XML with the field mapping PROPERTY.
For example: The XML had SERIAL NUMBER. So, I changed it to SERIALNUMBER and I changed the property to SERIALNUMBER as well.
Now, I ran into another issue :-) I think it's minor.
For some of the fields like SERIAL NUMBER. The number is large 10812701999
When it's imported to service desk, it looks like: 1.0803461999E10 (Exponential format).
The customer field is STRING (40), so why it looks this way? Also the XML has the value similar way (Which makes me think that it's caused be EXCEL)?!! Any clue there?