View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Ordering Excel export in Work / Activities ? - ProjeQtOr

Prochaines sessions de formation

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

 
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

 
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

 

 

 
 

Ordering Excel export in Work / Activities ?

More
01 Fév 2017 18:18 #1 by phil-bzh
hello,

From "Work" / "Activities" screen, I'm using Excel export. The export seems ordered by Id.

I would like having it ordered as displayed on the screen, which means by WBS (it's a more "logical" order, as far as I'm concerned).

Maybe you could do that in a future version if you find it useful ? But if you have time to look at it and know where I could add something like " ORDER BY WBS" in an SQL request in a PHP file, it would be great ! (if not, I will write tomorrow a macro-command in Excel to reorder in Excel like it is ordered in ProjeQtOr window).

Sincerely.

(I hope all my questions today were not too boring ;))

Please Connexion or Create an account to join the conversation.

More
01 Fév 2017 23:50 #2 by babynus
Just define a Filter with attribute=WBS and operator=order...
This will sort list on WBS.
CSV Export respect order in the list...

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
03 Fév 2017 13:49 - 03 Fév 2017 13:51 #3 by phil-bzh
Hello,

Thank you for your answer. I didn't know about filters and moreover it was not clear for me that the export takes it into account.

But my need seems still there : ordering "WBS ascending" make activities sorted in "numerical" order (like would do an automatic filter in Excel) and not "hierarchical numeric" order (which is the natural order for displaying ProjeQtOr activities, and which would lead me to build a macro in Excel for reordering).

In other words if I'm not clear : my need is that activity 1.10 is between 1.9 and 1.11 and not between 1.1 and 1.2

Another idea ? ;-)

Sincerely.
Last edit: 03 Fév 2017 13:51 by phil-bzh.

Please Connexion or Create an account to join the conversation.

More
03 Fév 2017 20:58 #4 by babynus
It's righ that sort on WBS on filter is Wrong. :(
Issue recorded as Ticket #2537.

A workaround : don't use filter.
Just display the WBS column in the list and click on column header to sort on WBS : this time, order is correct.
And when you export, this order is preserved :evil: :evil:

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
06 Fév 2017 10:53 #5 by phil-bzh
Hello,
Great : with the workaround, it does exactly what I expect : WBS "naturally" sorted :-)
Thank you.

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.044 seconds

Paramétrages de cookies

×

Cookies fonctionnels

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

Veuillez vous connecter pour voir vos activités!

Autres cookies

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