CSV export problem

[AnonimusMax]

Hi, I have another problem.

I have a TI process that generates a .CSV file.
This TI process is executed using ExecuteCommand and a technical user.
If I execute this process using my user (local settings in Windows is set to English) all the values are exported using dot decimals. For example: 120.34
If I use this technical user, the exported value will be: 120,34
This is a issue for the performed export because intead of 1 column, using technical user will result in 2 columns.
I have tried to change the local setting for this technical user, but is defined just in Cognos, and not in Windows.
Is there a way to control the export?
Please note that I use as data source a TM1 cube.

Thank you

[Wim Gielis]

Did you have a look at this in TI ? For example:

DatasourceASCIIDelimiter = Char(9);
DatasourceASCIIQuoteCharacter = '';
DatasourceASCIIDecimalSeparator = ',';
DatasourceASCIIThousandSeparator = '';
DatasourceASCIIHeaderRecords = 1;

[AnonimusMax]

Hi,

i have used this and it is not working. also with '.', ',';
DatasourceASCIIDelimiter = Char(9);
DatasourceASCIIQuoteCharacter='';
DataSourceASCIIDecimalSeparator='.';
DatasourceASCIIThousandSeparator='';

0,002877239
0,4165

The values are still exported with comma delimiter...
I have this problem only when running this with ExecuteCommand.

[gtonkin]

It may be worthwhile checking/changing the decimal symbol in the Regional settings for the user who starts your TM1 instance.

[lotsaram]

1/ You haven't said how you are doing the number to sting conversion; NumberToString, NumberToStringEx or Str. You haven't said whether you are using AsciiOutput or TextOutput. That would both seem to be pretty important information.

2/ I recall having seen something similar and I think there is already an existing APAR for this issue

[AnonimusMax]

Hi,

i am using AsciiOutput and NumberToString.
Do you have the link ? because I didn t find the existing APAR for this issue.

Thank you,

[AnonimusMax]

Hi,

Anyone has another solution?

Thank you

[Piotr Rajtar]

i am using AsciiOutput and NumberToString.

Try using NumberToStringEx instead to explicitly specify decimal character:

Code: Select all

# adjust precision to your needs
sFormatString = '#.####';
sDecimalSeparator = '.';
sThousandsSeparator = '';
sValue = NumberToStringEx(nValue, sFormatString, sDecimalSeparator, sThousandsSeparator);

NumberToString will implicitly use the regional settings of the user executing the TI process. I am not sure whether it is by design or a bug but I remember it changed at some point and even one of the TM1 Application Web TI processes (}tp_util_update_hierarchy) was prone to this behavior.

[AnonimusMax]

Yes, this is working thank you,

Nut now this is creating another problem, I am using ViewExtractSkipZeroesSet and if i use NumbertostringEX now the export is generating also the lines with '0'.
Before I used this replace the export was generated with out zeroes.

Thank you