View ProjeQtOr On SourceForge.net
ProjeQtOr free project management software - Excel Export for 'Planning' or "Global Planning" - ProjeQtOr
 

Excel Export for 'Planning' or "Global Planning"

More
06 Jul 2020 18:04 - 06 Jul 2020 18:17 #1 by MTE
Is it possible to add a button "Export Excel" in "Global Planning" or "Planning" ?
I'd like to have a file with this columns :

idAssignment, idProject, ProjectName, RefId, ActivityName, IdResource, ResourceName, WorkedDays, PlannedDays, Date

Last edit: 06 Jul 2020 18:17 by MTE.
The topic has been locked.
More
08 Jul 2020 09:24 #2 by babynus
You have it in Reports > Planning > Gant Planning.
You get a CSV export that will open in Excel.

Babynus
Administrator of ProjeQtOr web site
The topic has been locked.
More
08 Jul 2020 15:33 #3 by MTE
Thank you for your answer.
This export (Report/Planning/Gantt Planning) doesn't meet my need for 2 reasons :
- i need the detail for each day
- I need the detail for each resource
The export we can find in "Timesheets" is good...but only for the "work" : is it possible to have also the "planned work" ?
The topic has been locked.
More
09 Jul 2020 17:12 #4 by babynus
We have export of planned work in reports.
But not exportable to CSV or Excel.

Babynus
Administrator of ProjeQtOr web site
The topic has been locked.
More
09 Jul 2020 18:02 - 09 Jul 2020 18:05 #5 by MTE
I know, i know :-)
I use it, with a copy past in excel + a VBA Code to put the datas in table...
But i have to do my action for each month of my project.
Last edit: 09 Jul 2020 18:05 by MTE.
The topic has been locked.
More
10 Jul 2020 10:12 #6 by babynus

I use it, with a copy past in excel + a VBA Code to put the datas in table...
But i have to do my action for each month of my project.

... and you'll possibly have to do it until you or someone else sponsors the evolution to export in the format you need ;)

Babynus
Administrator of ProjeQtOr web site
The topic has been locked.
Moderators: babynusprotion
Time to create page: 0.040 seconds