Force JMP preferences (Windows specific) in jsl script

[#1]

Dear JMP community,

After weeks trying to find out how to import properly data coming from an Excel file (the only workaround I found was to save data as .txt but I was not satisfied to have two files instead of one), I may have found a path to solve my issue: forcing JMP Windows specific preferences. Indeed, when disabling "Use JMP language rather than system local settings for number, date and currency formats" option, it prevents JMP from incorrectly interpreting data from my XL file and I finally get all data with the right format (see secreenshot enclosed).

Now, in order to make my script work for every JMP user of my company, I need to force this setting in my jsl script. Any idea what the command would be? I guess it would be something like: Preferences( Pref( "value" ) ).

Thanks and regards!

Jérôme

[#2 · Accepted solution]

Unless you are in a position to decide how everyone in your company uses JMP, I would suggest that do not change the settings without changing them backbecause changes like this might break something else.

Something like this should work (test it before implementing):

Names Default To Here(1);
//Get Preferences(); get all preferences

orig_pref = Get Preferences("Use JMP Locale Settings");
Set Preference(Use JMP Locale Settings(0));
//do you thing
//
//
//return orig_pref
Eval(orig_pref);

[#3]

Thank you, exactly what I was looking for.