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 2 - ProjeQtOr
 

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

More
21 Oct 2015 10:00 #7 by babynus

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

Babynus
Administrator of ProjeQtOr web site

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

More
21 Oct 2015 16:17 #8 by soyelsimo

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.

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

More
21 Oct 2015 17:02 #9 by babynus

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.

Babynus
Administrator of ProjeQtOr web site

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

More
21 Oct 2015 17:06 #10 by soyelsimo
not a problems if theres other contributor ;) thank a lot for hearing ideas :D

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

More
22 Oct 2015 21:06 #11 by babynus

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 ?

Babynus
Administrator of ProjeQtOr web site

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

More
22 Oct 2015 22:28 #12 by soyelsimo
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
Attachments:

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

Moderators: babynusprotion
Time to create page: 0.041 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.