View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - CSV export time units on day but projeqtor is set to hours - Page 3 - ProjeQtOr
 

CSV export time units on day but projeqtor is set to hours

More
23 Oct 2015 09:24 - 23 Oct 2015 09:25 #13 by babynus
Replied by babynus on topic CSV export time units on day but projeqtor is set to hours
Weird indeed : both files work fine for me.
They were correctly imported, with comma or dot, including decimal part.
(I just changed Activity Type and Project in order to import the 2 lines)





I sse that you run a V5.0, which version exactly ?
What OS for server ?
What version of MySql ?
Babynus
Administrator of ProjeQtOr web site
Attachments:
Last edit: 23 Oct 2015 09:25 by babynus.

Please Log in or Create an account to join the conversation.

More
23 Oct 2015 09:43 #14 by babynus
Replied by babynus on topic CSV export time units on day but projeqtor is set to hours
I also had a doubt about DB, and tested with PostgreSql : works fine...
Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
23 Oct 2015 09:56 #15 by babynus
Replied by babynus on topic CSV export time units on day but projeqtor is set to hours
I Think I found : in you locale format, thouthand separator is ".", so it is removed to formt numeric.
Try and replace function formatNumericInput($val), line 2640 in /model/Importable.php with this one :
function formatNumericInput($val) {
  global $browserLocale;
  $fmt = new NumberFormatter52 ( $browserLocale, NumberFormatter52::DECIMAL );
  $from = array (
      $fmt->decimalSeparator,
      ' ' 
  );
  $to = array (
      '.',
      '' 
  );
  return str_replace ( $from, $to, $val );
}
Tell me if it works better.

More accurate solution will be provided in V5.1
Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
26 Oct 2015 21:07 #16 by soyelsimo
Replied by soyelsimo on topic CSV export time units on day but projeqtor is set to hours
well I couldn't make that fix on the code, but now it works perfect on the 5.1 version :D thaks a lot!

Please Log in or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.080 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form