Book a Demo

Author Topic: Number format error in Project Management view?  (Read 3957 times)

Tage Korsdal Nielsen

  • EA Novice
  • *
  • Posts: 19
  • Karma: +0/-0
    • View Profile
Number format error in Project Management view?
« on: March 11, 2014, 07:05:51 pm »
EA revision: 10.0.1009

The field Element->Project Management->Effort.time seems to have a problem with ',' and '.'

Try:

1. Create an effort "A" and set time to "1"
2. Save it
3. Click on another effort
4. Click back on "A" - time now reads 1,000000 - ok.
5. Now edit effort to e.g. "Aa" and click save
6. Click on another effort
7. Click back on effort "Aa" - time now reads 1000000,000000

Maybe a locale issue?

I use english windows with locale set to Denmark.
Decimal symbol is set to ','
Digit grouping symbol is '.'

I have not come accross this elsewhere in EA.

Rgds Tage



Tage Korsdal Nielsen

  • EA Novice
  • *
  • Posts: 19
  • Karma: +0/-0
    • View Profile
Re: Number format error in Project Management view
« Reply #1 on: April 01, 2014, 10:16:29 pm »
Further investigations reveal that this only happens on my MySQL DB based repository.

My guess is that the update SQL format sends the value as it is shown in the dialog e.g. "1,000000", and it is then converted to 1e6 for the double value in the table, since the DB uses "," for thousands seperator.

I haven't found anywhere to change this  in the MySQL server or ODBC driver - apparently, with Oracle DB you can. But in any case, I think the update SQL commands from EA should convert this on the client site - SW teams may be international. :-)

Rgds
Tage

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Number format error in Project Management view
« Reply #2 on: April 02, 2014, 12:28:00 am »
You should send a bug report (link bottom right).

q.

Tage Korsdal Nielsen

  • EA Novice
  • *
  • Posts: 19
  • Karma: +0/-0
    • View Profile
Re: Number format error in Project Management view
« Reply #3 on: April 02, 2014, 06:21:00 pm »
Ok Q - will do! :-)