Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Excel Export for 'P...
 
Notifications
Clear all

Excel Export for 'Planning' or "Global Planning"

7 Posts
2 Users
0 Reactions
5,622 Views
(@mte)
Posts: 10
Active Member
Topic starter
 
[#6805]

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


 
Posted : 06 Jul 2020 20H04
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

You have it in Reports > Planning > Gant Planning.
You get a CSV export that will open in Excel.


 
Posted : 08 Jul 2020 11H24
(@mte)
Posts: 10
Active Member
Topic starter
 

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" ?


 
Posted : 08 Jul 2020 17H33
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

We have export of planned work in reports.
But not exportable to CSV or Excel.


 
Posted : 09 Jul 2020 19H12
(@mte)
Posts: 10
Active Member
Topic starter
 

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.


 
Posted : 09 Jul 2020 20H02
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

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 😉


 
Posted : 10 Jul 2020 12H12
(@mte)
Posts: 10
Active Member
Topic starter
 

clear 🙂


 
Posted : 10 Jul 2020 13H06
Share:

Scroll to Top