Hitachi Vantara Pentaho Community Forums
Page 3 of 4 FirstFirst 1234 LastLast
Results 21 to 30 of 40

Thread: Convert Zulu to a date time value

  1. #21
    Join Date
    Apr 2017
    Posts
    26

    Default

    We are running Java 1.7

  2. #22
    Join Date
    Jun 2012
    Posts
    5,304

    Default

    I'm afraid we are running in circles.

    Please, attach a screenshot of the result of the attached transformation.
    Minimize the preview dialog, so the forum's image compression doesn't kick in.
    I want to be sure that your Kettle doesn't use some old Java version found on your system.
    Attached Files Attached Files
    pdi-ce user
    java 1.8.0_131 (OpenJDK)
    ubuntu 16.04 LTS (x86_64)
    timezone CET / CEST
    contemplative reading SSCCE
    sig updated 2017-08-16

  3. #23
    Join Date
    Apr 2017
    Posts
    26

    Default

    Thanks for your help. We are using the BMC Remedy based version of Spoon (Atrium Integrator) and you can only connect to a Remedy server. I could not find a way to just open this file.

  4. #24
    Join Date
    Jun 2012
    Posts
    5,304

    Default

    Essentially, my transformation adds the Java version string to the stream - ${java.version}
    The Kettle version is available in a variable, too - ${Internal.Kettle.Version}

    You can inspect my transformation in your text editor or even your web browser.
    pdi-ce user
    java 1.8.0_131 (OpenJDK)
    ubuntu 16.04 LTS (x86_64)
    timezone CET / CEST
    contemplative reading SSCCE
    sig updated 2017-08-16

  5. #25
    Join Date
    Apr 2017
    Posts
    26

    Default

    Unfortunately my expertise is Remedy development and I use Spoon for just one reason - extract people data from a ID vault to import into Remedy. These two fields (record create date and last modified date) are important to import. Having very limited knowledge of Spoon and Java does not help. I was hoping it was just a simple field setting. I may have to come up with an other way. Not sure why this would not be simple.

  6. #26
    Join Date
    Apr 2008
    Posts
    4,397

    Default

    Try doing a brand new transformation with "Get Variables"
    Just get the variables that marabu suggested

  7. #27
    Join Date
    Apr 2017
    Posts
    26

    Default

    Here is a screen shot showing the LDAP input and the field settings.
    Attached Images Attached Images

  8. #28
    Join Date
    Apr 2008
    Posts
    4,397

    Default

    You have nothing in the format column.
    You need to set it, or PDI has no way to know HOW to convert it.

    Try setting it, and posting the images again.
    Attached Images Attached Images

  9. #29
    Join Date
    Apr 2017
    Posts
    26

    Default

    I have tried every date format in that column and none of them change the value.
    Attached Images Attached Images

  10. #30
    Join Date
    Apr 2008
    Posts
    4,397

    Default

    In the box in your latest screenshot, you have yyyy/MM/dd HH:mm:ss.sss
    You also covered up the section of the log that tells us what it tried to parse the value with

    Why are you not willing to try the value that we have advised that you need to use? Reminder: yyyyMMddHHmmssX
    To prove that this works, set up a CSV file with a set of random time values that you want to use.
    Use a CSV input, connected to a Select Values, and use the select values step to convert it to Date.
    If you believe that doesn't work, export the transform that you created, and post it with the sample CSV file. Yes, you can do this with Atrium, as several other users have done so.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2017 Pentaho Corporation. All Rights Reserved.