Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

P6 Timesheet Data Automation

1 reply [Last post]
Tue, 2020-03-31 08:34
Jordan Benjamin-S...
User offline. Last seen 1 year 50 weeks ago. Offline
Joined: 9 Mar 2020
Posts: 5
Groups: None

Hello,

I am a project planner from the UK looking to try and automate the company i work for timeshet process to improve efficiency. Currently we work on a basis in which the individual alters there timesheet on excel and pdfs there timesheet on a weekly basis. From there I then input the data manually into P6. However I sometimes question my accuracy with this and I would ideally like to find an automated solution. I have tried to reserch the process of an API which looks between excel and P6 and automatically fills the data however there doesnt seem to be much information in regards to this on the internet. I also heard about an SDK software called P6XL Bridge, but again I do not know how to use this. So in short, would anyone be able to point me in the right direction or alternativley does anyone have past experience which this and would be able to physically design it for me.

Thanks,

Jordan.

Top

Replies

Thu, 2020-05-21 22:14
#1
Patrick Mullen
User offline. Last seen 3 years 38 weeks ago. Offline
Joined: 15 May 2020
Posts: 19
Groups: None

Hey Jordan,

If you already have the team providing their timesheets in excel, you could strip out the actual dates and do an excel import into P6. You just need to make sure you have the activity ID to reference, WBS code, actual start, actual finish, % complete, and remaining duration. 

Depending on the excel form that they provide, you could create some sort of an excel template where you could "dump" the excel information from the file they provide you into your own excel template to auto-format the data into an importable format.

I've messed around with P6XL bridge, but from my experience, importing from excel was just as fast if you develop a good system extracting the data into an importable format.

I wrote an article about importing actual dates into P6 here: https://jobsessions.com/post/51069F09-83B8-5B82-6D39-69B32B578BD2

Regards,

Patrick

Top