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

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

More
07 Oct 2015 16:43 #1 by soyelsimo
Hi there, well I got this surprise. My time unit for work is H but when I got exported to excel the activities or projects the fileds set to H comes as days. This is not very usefull for me ashe platform is set to hours, and to do mass import I have to divide by 7 all hours on each activity.

Wouldn't be more logic that if the platform is set on hours projeqtor should expect hours to be imported as I expect hours exported from projeqtor?

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

More
09 Oct 2015 09:01 #2 by babynus
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.

Babynus
Administrator of ProjeQtOr web site

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

More
13 Oct 2015 16:55 #3 by soyelsimo
ok I understand now, well there's a round up or down issue, not big deal.
Thanks for your help

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

More
20 Oct 2015 18:24 #4 by soyelsimo
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
Attachments:

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

More
20 Oct 2015 20:17 - 20 Oct 2015 20:19 #5 by soyelsimo
[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.
Attachments:
Last edit: 20 Oct 2015 20:19 by soyelsimo.

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

More
21 Oct 2015 09:57 #6 by babynus

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

Babynus
Administrator of ProjeQtOr web site

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

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