US and Worldwide: +1 (866) 660-7555
Page 3 of 3 FirstFirst 123
Results 21 to 26 of 26

Thread: Convert Zulu to a date time value

  1. #21
    Join Date
    Apr 2017
    Posts
    19

    Default

    We are running Java 1.7

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

    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-7.0.0.0-25
    java 1.8.0_131 (OpenJDK)
    ubuntu 16.04 LTS (x86_64)
    timezone CET / CEST
    contemplative reading SSCCE
    sig updated 2017-05-15

  3. #23
    Join Date
    Apr 2017
    Posts
    19

    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,041

    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-7.0.0.0-25
    java 1.8.0_131 (OpenJDK)
    ubuntu 16.04 LTS (x86_64)
    timezone CET / CEST
    contemplative reading SSCCE
    sig updated 2017-05-15

  5. #25
    Join Date
    Apr 2017
    Posts
    19

    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,257

    Default

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

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
  •