Try cutting and pasting the exact same information into another spreadsheet application (like google sheets) that can generate a .csv. Then, see if you get the same error. You might be able to narrow down whether it's Remedy or Excel.
Lee Cullom | Northcraft Analytics IT Metrics Specialist | Business Intelligence for ITSM Direct - 678-438-7244 | http://www.northcraftanalytics.com<http://www.northcraftanalytics.com/> Main - (678) 664-ITSM [Description: Description: http://t0.gstatic.com/images?q=tbn:ANd9GcSo4qhIq-bDh4Z1UzKXet0tiAZqqejjd1BT8lVOHdrzZQwqeZun]<http://www.linkedin.com/in/leecullom>[Description: Description: http://t0.gstatic.com/images?q=tbn:ANd9GcSWE5AoudybparNXkh21Br8ZWGNBqdra5ylZ63igCoZ36o5b5iFEA]<http://twitter.com/#!/NorthcraftIT> What is Northcraft Analytics? Find out in 87 Seconds. <http://www.youtube.com/watch?v=SRNyPNK_HJc> THE CONTENTS OF THIS EMAIL, INCLUDING THE CONTENTS OF ANY ATTACHMENTS HERETO, CONSTITUTES "CONFIDENTIAL INFORMATION" AND IS SUBJECT TO A CONFIDENTIALITY AND NON-DISCLOSURE AGREEMENT BETWEEN THE RECIPIENT AND NORTHCRAFT ANALYTICS LLC (If such an agreement is in place). From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Boyd, Rebecca Sent: Friday, February 21, 2014 4:36 PM To: arslist@ARSLIST.ORG Subject: Re: DMT and extra Zeros ** Thanks, Roger. I tried deleting the first row of data. The new first row generated the same error message. Then I tried loading the spreadsheet with a single row of data. Same error. I've seen variations of this before. For example, when loading people, the Corporate IDs all had a ".0" appended to them. That didn't cause an error so we didn't catch it until it got into the people form. The corporate IDs on the spreadsheet definitely didn't have ".0" at the end. On Fri, Feb 21, 2014 at 4:16 PM, Roger Justice <rjust2...@aol.com<mailto:rjust2...@aol.com>> wrote: ** Since the error message includes the Pentaho application it could be that Pentaho is causing the error. You could attempt to import a single entry directly to the DMT form to isolate the error. -----Original Message----- From: Boyd, Rebecca <boy...@wfu.edu<mailto:boy...@wfu.edu>> To: arslist <arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>> Sent: Fri, Feb 21, 2014 4:12 pm 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<tel:2012-11-06%2013>.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<tel:2012-11-06%2013>.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<tel:2012-11-06%2013>.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<tel:2012-11-06%2013>.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_ _ARSlist: "Where the Answers Are" and have been for 20 years_ -- 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"
<<inline: image001.jpg>>
<<inline: image002.jpg>>
