Service Desk Practitioners Forum
cancel

Loading CMDB Data to "Date" fields

SOLVED
Go to solution
Highlighted
Moxie
Super Contributor.

Loading CMDB Data to "Date" fields

Hi all,

I have been populating a CMDB for the past 3 months or so now and I have never been able to get data to load properly to a date field, not sure why?

I am using a solution where I have the data in Excel, create an XML file via ECW tool and an ODBC conection to the spreadsheet.

Any tips or tricks here would be appreciated!
Do it right the first time
2 REPLIES
Jonathon Druce
Acclaimed Contributor.
Solution

Re: Loading CMDB Data to "Date" fields

What Service Pack are you on?

With Excel make sure that you format the cells that will contain the dates as date fields using what ever date format you like.

Within Service Desk make sure the date format of the account that is importing the data matches what you have in Excel and it all shoul work.
Moxie
Super Contributor.

Re: Loading CMDB Data to "Date" fields

Maybe my attention to detail was a bit off. Interestingly this worked with a short date format (ie: 03/16/06) MM/DD/YY.

However the XML format was more like 2006.03.16.12.00.00

And when loaded, it loaded to 03/16/06 just as I intended.

Strange?
Do it right the first time