Our build lab approached me about creating an automated process of entering new Configuration Item entries for multiple machines (hundreds at a time). I belive (and hope) this can be accomplished using Data Exchange.
For testing purposes in my Dev environment, I have created a simple ini file that grabs 3 pieces of data: SEARCHCODE (asset number), CISHORTTEXT1 (Node number), and SERIALNUMBER.
I am able to export this data with no problems. I then created an Import Mapping entry to relate the data above to the proper fields.
After exporting, I deleted the CI record of an existing device, then attempted the Import Data task using my xml file and the Import Mapping entry I created. I get no errors, but the log file shows no entries were imported. There are no errors within the log file.
Anyone have any ideas ? See attached file for data info.
Hi, 1st of all, in all the locations in your excel file, ini file and in your data exchange, all the name be same. In the excel file where you store the CIs, select all the data and define a name. Give the same name in ini file, and for the data exchange also. follow these steps. I am sure u can successfully bulk load the CIs.
Could the problem also be with my wanting to create a new entry, vs. updating an existing one ? I noticed that when I export to my xml file, it has 2 entries for 'ID' - one, I'm guessing, is used internally for Service Desk to track that item. The other is what is visible to the end user when they look up that Configuration Item. When I am importing the xml file, I am deleting both of those, since I won't have that information for new entries.