Hi, All data in the DMT spreadsheets is required to be stored as text (with the latest version) - this is due to Excel converting all other formats to what it thinks the value should be, thus the additional ".0".
Convert the cells to text only, then put the date in as straight text . It can be a pain to do initially, but that way you will not get Excel appending the ".0". _____ Kind Regards, Carl Wilson http://www.missingpiecessoftware.com/ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Boyd, Rebecca Sent: 21 February 2014 21:13 To: [email protected] Subject: DMT and extra Zeros ** Hello everyone, I am trying to load incidents using the HPD_LoadHelpDesk tab of the Transactional_Incident spreadsheet. The job is erroring out on the Load step because it can't convert a date. The date looks correct on the spreadsheet, but when Remedy reports the error, it always reports an extra zero for the seconds. 2014/01/02 00:00:00.00 - Spreadsheet data 2014/01/02 00:00:00.000 - Remedy error I have typed the date in fresh. I've changed the date & time. I've re-formatted the cell. I've created new jobs every time only to get the same 'ol error message. 8.1 Clean Install, Oracle 11g Here's a truncated version of the error message: 2014/02/21 15:36:17 - Transactional_Incident - Start of job execution 2014/02/21 15:36:17 - Convert Dates.0 - ERROR (version 4.1.0, build 1 from 2012-11-06 13.20.53) : Unexpected error : 2014/02/21 15:36:17 - Convert Dates.0 - ERROR (version 4.1.0, build 1 from 2012-11-06 13.20.53) : org.pentaho.di.core.exception.KettleValueException: 2014/02/21 15:36:17 - Convert Dates.0 - ERROR (version 4.1.0, build 1 from 2012-11-06 13.20.53) : Reported Date String : couldn't convert string [2014/01/02 00:00:00.000] to a date using format [MM/dd/yyyy HH:mm:ss] 2014/02/21 15:36:17 - Transactional_Incident - Transactional_Incident 2014/02/21 15:36:17 - Transactional_Incident - ERROR (version 4.1.0, build 1 from 2012-11-06 13.20.53) : Errors detected! 2014/02/21 15:36:18 - Transactional_Incident - Job execution finished -- Rebecca Boyd Application Administrator Wake Forest University _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"
