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

Ordering Excel export in Work / Activities ?

More
01 Feb 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 Log in or Create an account to join the conversation.

More
01 Feb 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 Log in or Create an account to join the conversation.

More
03 Feb 2017 13:49 - 03 Feb 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 Feb 2017 13:51 by phil-bzh.

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

More
03 Feb 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 Log in or Create an account to join the conversation.

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

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

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