You are not logged in.

interpretation of decimal-separator

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

J_RECKMANN

Trainee

  • "J_RECKMANN" started this thread

Posts: 2

Date of registration: Aug 25th 2006

  • Send private message

1

Friday, August 25th 2006, 2:14pm

interpretation of decimal-separator

I imported about 2 million values by using PALO.SETDATA-Worksheetformula and "Import-Assistent". Some values "lost" their decimal-separator, for example 10.000,23 was imported as 1.000.023. I identified one single example-value to verifiy the problem but when I imported only this one value it worked perfect.
Any idea about it?

v_malicevic

Palo Team

  • "v_malicevic" is male

Posts: 453

Date of registration: Oct 26th 2005

Location: Germany

  • Send private message

2

Monday, August 28th 2006, 9:33am

RE: interpretation of decimal-separator

Hi!
Where does the data come from CSV, DB or Cube? Could you please upload one snippet(10-20 records) to forum?
Mit freundlichen Gruessen/ With kind Regards / Meilleures salutations

Vladislav Malicevic
Head of Research and Development

Jedox AG

J_RECKMANN

Trainee

  • "J_RECKMANN" started this thread

Posts: 2

Date of registration: Aug 25th 2006

  • Send private message

3

Monday, August 28th 2006, 10:54am

RE: interpretation of decimal-separator

The data comes from a txt-file using tab as element-separator.
Here is the extract.
Thanks in advance.
J_RECKMANN has attached the following file:
  • EXTRACT.txt (821 Byte - 238 times downloaded - latest: May 1st 2013, 12:14pm)

Aisakos

Sage

  • "Aisakos" is male

Posts: 82

Date of registration: Aug 9th 2006

Location: Berlin

  • Send private message

4

Monday, August 28th 2006, 3:30pm

RE: interpretation of decimal-separator

Hi,

I have the same problem by importing a big number of data by a text-file. The first part of the data are imported the right way, but after a specific number of data, it seems happens when the system is loading the next data-package, there is a switch, afterwards the decimal-separator does not work any more.

Best Regards

Roland

v_malicevic

Palo Team

  • "v_malicevic" is male

Posts: 453

Date of registration: Oct 26th 2005

Location: Germany

  • Send private message

5

Tuesday, August 29th 2006, 10:01am

RE: interpretation of decimal-separator

Ok,
we will keep an eye on this issue. Thank you for reporting it.
Mit freundlichen Gruessen/ With kind Regards / Meilleures salutations

Vladislav Malicevic
Head of Research and Development

Jedox AG

v_malicevic

Palo Team

  • "v_malicevic" is male

Posts: 453

Date of registration: Oct 26th 2005

Location: Germany

  • Send private message

6

Tuesday, September 12th 2006, 11:54am

RE: interpretation of decimal-separator

Hi!
Could you please confirm that you are using the latest Palo 1.0c version?
Could you also let me know which OS and Excel version are you using?
Mit freundlichen Gruessen/ With kind Regards / Meilleures salutations

Vladislav Malicevic
Head of Research and Development

Jedox AG

v_malicevic

Palo Team

  • "v_malicevic" is male

Posts: 453

Date of registration: Oct 26th 2005

Location: Germany

  • Send private message

7

Wednesday, September 13th 2006, 2:28pm

RE: interpretation of decimal-separator

Hi!
Aisakos: could you please tell us with which version of Palo are you experiencing this issue?
Mit freundlichen Gruessen/ With kind Regards / Meilleures salutations

Vladislav Malicevic
Head of Research and Development

Jedox AG

Aisakos

Sage

  • "Aisakos" is male

Posts: 82

Date of registration: Aug 9th 2006

Location: Berlin

  • Send private message

8

Wednesday, September 20th 2006, 5:35pm

Versions

Hi,

my Excel-Version: 2003 SP1 and my Palo-Version: 1.0c.

Best Regards

v_malicevic

Palo Team

  • "v_malicevic" is male

Posts: 453

Date of registration: Oct 26th 2005

Location: Germany

  • Send private message

9

Thursday, September 21st 2006, 11:40am

RE: Versions

Ok .... thanks!
Mit freundlichen Gruessen/ With kind Regards / Meilleures salutations

Vladislav Malicevic
Head of Research and Development

Jedox AG

h_schmieder

Professional

  • "h_schmieder" is male

Posts: 23

Date of registration: May 24th 2006

  • Send private message

10

Thursday, September 28th 2006, 2:13pm

I couldn't recreate the problem with the extract.txt.

to J_RECKMANN:

This sounds like a bug wich was fixed in Version 1.0b

Version 1.0b-2606 15.05.2006

- Add-in: Fixed issues in import for data rows containing the 1000 separator

Can you send me a file where the last line contains 10.000,23 and with which
the error occurs (with the lats line).

Can you also tell me how the according Excel cell is formated and which
are the language settings, escpecially for numbers.

to Aisakos:

This sound related to a bug which was fixed in 1.0c.

Can you send me a file with more than 10000 lines where the last line shows this error.

Can you also tell me how the according Excel cell is formated and which
are the language settings, escpecially for numbers.


Hendrik Schmieder
Jedox GmbH

v_malicevic

Palo Team

  • "v_malicevic" is male

Posts: 453

Date of registration: Oct 26th 2005

Location: Germany

  • Send private message

11

Thursday, October 19th 2006, 6:17pm

Hi!
FYI: This problem is now solved and the fix for it will be available in the next public release.
Mit freundlichen Gruessen/ With kind Regards / Meilleures salutations

Vladislav Malicevic
Head of Research and Development

Jedox AG
Rate this thread