Trouble with input files when using German regional settings
When saving [I].csv[/I] files on computers with certain regional settings (e.g., German, Dutch) the files can no longer be used as input files in DirectRT. This is a solution summary contributred by one of our users in Germany. -Blair
[I][edited from support email][/I]
[quote]
We have discovered we have to have German regional settings to use the MediaLab Experiment Editor (otherwise the file type mismatch error message appears) but then we are unable to alter DirectRT csv files.
The DirectRT csv files are ONLY editable with USA settings. Even if we alter only one word of the full functioning sample file and save the change using the german settings, it won't work anymore. Our original file (which looks fine, but won't work, as you might recall) is somehow victim of those usa/germany switches.
If we open csv files (e.g. the sample files) using the American settings, they are presented in cells and columns and stuff (just the way you are used to it, while working with excel). If we on the other hand open them using German settings it's one line, separated with commas, which is hard and time consuming to edit (and which won't work). So making a long story short:
[LIST=1][*]We need US settings to alter csv files (which makes it impossible to use the editor)[*]We need the German settings to use the MediaLab editor (which makes it impossible to alter DirectRT input files)[*]Somehow the switching of regional settings is can sometimes lead to errors when translating the original file[*]The impact of switching regional settings seems like it may be related to the regional settings you use while installing MediaLab and DirectRT (and is independent of the ML or DRT version we use)[/LIST]Please let me know what you think about this and if there is an easy way to avoid these problems (perhaps in installing the programs with the American regional settings?).
[/quote]
Trouble with input files when using German regional settings
Just changing German regional settings into American settings did not work.
But removing DirectRT, changing German settings into American and reinstalling DirectRT works fine! :-)
Please inform other German users about it because it took me some sleepless nights to find out! Do not wish that to others!
Andrea
No need to change regional setting w Open office
Located in Sweden I suffered from the same problem. Found very simple solution:
Install Open office (Oo) (my version is 3.3), it is free.
When you open a csv in Oo, the program will automatically ask you about the formatting instead of automatically changing it as in excel - choose separated by commas as in attached picture.
No regional settings change needed!!!
Jarvis - why not recommend Open office as default. It's free and obviously works better with DirectRT. Info on this matter and on the settings issue would have saved me a lot of pain for sure.
[IMG]http://static.tumblr.com/ndedsly/Smjluhqc3/settings.jpg[/IMG]