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

Loading CMDB Data to "Date" fields

SOLVED
Go to solution
Highlighted
Moxie
Regular Collector

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
Honored 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
Regular Collector

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
//Add this to "OnDomLoad" event