ProjeQtOr always works with days, even if it can display hours.
So export and import, which are technical tools, always work in internal technical format.
This avoids to wonder what was the unit used to export a file and how it should be imported : it's always days.
This way, you can export from an instance and import into another without messing with units.
Also, as you can define different units for Worklod (on activities) and Real work input, it would really be a mess to guess wich one to use on import.
So remeber : ProjeQtOr always work with days, and provides possibility to display hours.

ok I understand now, well there's a round up or down issue, not big deal.
Thanks for your help

Hi there i'm back, I got an issue importing validated work.
When I modify or set validated work from a csv, I need to set for example 0.50 day of work for an activity whichs should mean 3.5h. from a 7h per day work.

Well I got two issues:
first in spanish format we comma "," as decimal separator. Projeqtor can read that from the computer system and use the same format for export. But It's not allowed to read it from a csv file importation. to avoid that I set the english format for numbers on the excel sheet, but would be nice not having this format issues if it can export with comma would be reasonable to import it as well

The second issue is that I use the English format with dot "." as decimal separator, but projeqtor doesn't read it. The for a 0.50 days activity instead of 3.5h I got
350h as the two decimals aren't read at all it reads 050 days so that means 350h.

I'm not allowed to import work for a frame smaller tha a day?
thank you

[Other question is some activities not all have locked the field of validated work after import. like the capture attached.] sorry I solved it, it was set as parent activity of other one.

May I suggest to add progress section of projects and activities to multiple update for mass input of data. And add massive confirmation option to multiple update, if I want to delete several activities which has resources affection I have to do it one by one.

Projeqtor can read that from the computer system and use the same format for export. But It's not allowed to read it from a csv file importation. to avoid that I set the english format for numbers on the excel sheet, but would be nice not having this format issues if it can export with comma would be reasonable to import it as well

No, export is always done with . as decimal separator !!!
Excel displays it as your own separator (comma) but export ted format is always a point.
Try and open an exported file with text editor...
ProjeQtOr does not export nor import numbers with comma.

The second issue is that I use the English format with dot "." as decimal separator, but projeqtor doesn't read it. The for a 0.50 days activity instead of 3.5h I got
350h as the two decimals aren't read at all it reads 050 days so that means 350h.

I'll have a look at thos one. May be a bug on import.
Ticket #1822 recorded

May I suggest to add progress section of projects and activities to multiple update for mass input of data.

I don't thing all data in progress section should be changed in "multiple mode", as most of them are calculated...
What is exactly your need ?

And add massive confirmation option to multiple update, if I want to delete several activities which has resources affection I have to do it one by one.

Request recorded as Ticekt #1823

No, export is always done with . as decimal separator !!!
Excel displays it as your own separator (comma) but export ted format is always a point.
Try and open an exported file with text editor...
ProjeQtOr does not export nor import numbers with comma.

Ok I see, on a text editor I can see the dot in the exported file and in the file I use to import, so might be a issue.

I don't thing all data in progress section should be changed in "multiple mode", as most of them are calculated...
What is exactly your need ?

Well actually not all fields you are right. I'm using csv to set validated work and cost to several activities that are the same activity but recurrent. As we do TV shows, each episode is the same process and budget.

Outside progress, other recurrent thing I do one by one is setting resource assignment. As I may assign 50 episodes to the same resource with the same budget of hours, is there anyway to do it massively?

And another thing I do one by one is setting predecessor and successor element. the same way I can set "is sub-project of" and "parent activity" massively from the csv, it would be nice.

As suggestion of translation to spanish, Predecessor element = elemento predecesor. Eficiencia = efficiency
I think it could be confusing.

Thank a lot for your help.

Well actually not all fields you are right. I'm using csv to set validated work and cost to several activities that are the same activity but recurrent. As we do TV shows, each episode is the same process and budget.

Request recorded as Ticket #1824

Outside progress, other recurrent thing I do one by one is setting resource assignment. As I may assign 50 episodes to the same resource with the same budget of hours, is there anyway to do it massively?

Interesting idea. Request recorded as Ticket #1825

And another thing I do one by one is setting predecessor and successor element. the same way I can set "is sub-project of" and "parent activity" massively from the csv, it would be nice.

Also Interesting idea. Request recorded as Ticket #1826

As suggestion of translation to spanish, Predecessor element = elemento predecesor. Eficiencia = efficiency
I think it could be confusing.

Taken into account.
Hope it will not be over written by translation contributor for V5.1 translations.

not a problems if theres other contributor 😉 thank a lot for hearing ideas 😀

The second issue is that I use the English format with dot "." as decimal separator, but projeqtor doesn't read it. The for a 0.50 days activity instead of 3.5h I got
350h as the two decimals aren't read at all it reads 050 days so that means 350h.

Could not reproduce : ProjeQtOr is able to import numeric data, formated with "." (point) or with locale decimal separator (for instance, works fine for me with "," (comma). Both formats work fine.
Could you try on demo and provide imported file ?

I'm not allowed to import on the online demo, am I?

I reproduced it again in my copy. I created a project called "prueba" then two subactivities called "a" and "b". I downloaded the complete csv file from activity tab filtering the project "prueba"
I fill the filed work validated on "a" = 0,5 on "b"=1,3

then importedthe file. This time it imported the file with comma format, but didn't read the separator I tried the file with dot format and same result.

I attached the files, if there any way I can recreate this on the demo I'll give it a try

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 ?

I also had a doubt about DB, and tested with PostgreSql : works fine...

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

well I couldn't make that fix on the code, but now it works perfect on the 5.1 version 😀 thaks a lot!