Hi, The Data Management in 8.x is more specific and requires exact formatting for the conversions to occur (in AI Excel conversions):
Reported Date String : couldn't convert string [2013/03/22 15:08:35.000] to a date using format [MM/dd/yyyy HH:mm:ss] You need to supply the date in the format as specified, dropping any additional information: E.g. "2013/03/22 15:08:35:00" needs to be in the format "03/22/2013 15:08:35". You should also store all the data (date) in the Excel spreadsheet as text and no other format (Excel adds additional information for other formats). _____ Kind Regards, Carl Wilson http://www.missingpiecessoftware.com/ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Hennigan, Sandra Sent: 24 March 2013 21:18 To: [email protected] Subject: DM - Loading Incidents - couldn't convert string error ** All, I am at wit's end trying to load Incidents using Data Management. ITSM 8.1 Windows 2008 SP2 Oracle 11g We are retiring our 8.0 and I need to move Incidents to the 8.1. I downloaded the Excel file from Data Management & filled it according to directions. At the Load process, the file errors with - Reported Date String : couldn't convert string [2013/03/22 15:08:35.000] to a date using format [MM/dd/yyyy HH:mm:ss] I have tried to fix the format date/time fields - in Excel, the data appear correctly. Yet I cannot get past the error. Any tricks I should use to correct the formatting? Any assistance is appreciated. Thank you, Sandra Hennigan Remedy Developer _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
