Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Dev in pt-br OS, production is en-us OS = decimal hell

  1. #1
    Join Date
    Feb 2011
    Posts
    840

    Default Dev in pt-br OS, production is en-us OS = decimal hell

    So, my workstation has Windows 8 in pt-br, which uses comma as decimal delimitator. And the first server has a Windows Server something, in en-us, which uses dots as decimal delimitators.

    And even though the field is set to format 0,00#.## with , as decimal and . as group on the add constant values that creates it, the set field value aborts on error if I use 0,06 (6 decimals), on the server. If I run this on my workstation, it goes okay.

    And since the set field value to a constant has conversion mask/format field, but doesn't have decimals and groups field, I'm kinda at a loss...
    ideas?

    - and no, changing anything OS-related is out of the table, not an acceptable solution =/
    Join us on IRC! =)

    Twitter / Google+ / Timezone: BRT-BRST
    BI Server & PDI 5.4 / MS SQL 2012 / Learning CDE & CTools
    Windows 8 64-bit / Java 7 (jdk1.8.0_75)

    Quote Originally Posted by gutlez
    PLEASE NOTE: No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.

    I'm no expert.Take my comments at your own risk.

  2. #2
    Join Date
    Apr 2008
    Posts
    4,690

    Default

    What about setting the locale in a Spoon.bat (eg. spoon-us.bat ) that would then convince it that it was running on a en_US based workstation?

    Add parameters:
    -Duser.language=en -Duser.country=US -Duser.variant=US

  3. #3
    Join Date
    Feb 2011
    Posts
    840

    Default

    since I'm developing in Brazil, wouldn't it make more sense to use those parameters on the server with the english OS so that Kettle thinks it's using pt-br? =p
    Join us on IRC! =)

    Twitter / Google+ / Timezone: BRT-BRST
    BI Server & PDI 5.4 / MS SQL 2012 / Learning CDE & CTools
    Windows 8 64-bit / Java 7 (jdk1.8.0_75)

    Quote Originally Posted by gutlez
    PLEASE NOTE: No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.

    I'm no expert.Take my comments at your own risk.

  4. #4
    Join Date
    Apr 2008
    Posts
    4,690

    Default

    No, using those settings on a server that's already in en_US doesn't make sense...
    However using:
    -Duser.language=pt -Duser.country=BR -Duser.variant=BR

    might make a lot of sense

  5. #5
    Join Date
    Feb 2011
    Posts
    840

    Default

    funny =p
    Join us on IRC! =)

    Twitter / Google+ / Timezone: BRT-BRST
    BI Server & PDI 5.4 / MS SQL 2012 / Learning CDE & CTools
    Windows 8 64-bit / Java 7 (jdk1.8.0_75)

    Quote Originally Posted by gutlez
    PLEASE NOTE: No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.

    I'm no expert.Take my comments at your own risk.

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 - 2019 Hitachi Vantara Corporation. All Rights Reserved.