Writing file with comma as decimal separator/date formats..

dataservices job design
1

I have trouble writing a file with the correct decimal format (#.##0,0). According to the Dutch standard this is supposed to be a comma, as opposed to the rest of the world… Dots are thousand separators.

In the file format editor a field has data type decimal(12,4). I tried the following:
[list]1. set the locale language to nld, field format to {none}
2. set the format for this field to #.##0,0
[/list]Both methods still write decimal data in the format #,##0.0
Why?

Same with dates. Only setting the default date format in the file format editor to dd-mm-yyyy provides the desired format. The format on the field seems to have no influence at all. Why?

This is on BODS 3.2 (12.2.3)

lamanp :netherlands: (BOB member since 2008-09-02)

2

At least for the Date I can provide an answer for you.

Just goto the DSConfig.txt on your Job Server
(also I believe modify the client machine’s DSConfig.txt too) and search for
[FileFormatDataTypeFormats]

Under that you will have a parameter
date=yyyy-mm-dd
If that is the only format you have then add the other formats you would expect of by a Pipe Delimited values
date=yyyy-mm-dd|yyyymmdd|mm-dd-yyyy|…|… like that

Then you will see these different values in the Dropdown “Date” in the default format tree

I wish Werner would answer the Dutch format because he loves that… :mrgreen:

ganeshxp :us: (BOB member since 2008-07-17)