Forum Sponsor:

An innovation in P6 Professional training from RPCuk in partnership with Oracle. All the topics that matter to you in workshops customised to your role and industry.  Now get superior training value when you book our Blended Learning Bundle. Learn more here.

Viewer for .xer, xml and xls schedule files Schedule Reader™Free Trial

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.

MS Excel & Importing into SureTrak

2 replies [Last post]
Shane Pouch
User offline. Last seen 8 years 16 weeks ago. Offline
Joined: 9 Feb 2008
Posts: 7
Groups: None
Hello,

I am new to this forum. Have used P3, SureTrak, and MSProject off and on over the 20 years I’ve been in the construction industry.

I am currently using SureTrak 3.0b version 2, and my issue right now is with using MS Excel and trying to import activities back into SureTrak.

I am tryint to use the Copy Activity function to first copy to MS Excel so that all the columns are established. Then I simply work in MS Excel to make my additions/changes, etc. Then I highlight the data in the spreadsheet and copy it. Then I go back into SureTrak and position the cursor at the activity where I want to insert my activities and use the Paste Activity function.

Here’s where the problem comes in. Why don’t the predeccessors/successors show up?

Any help will be greatly welcomed and appreciated.
Thanks,
Shane

Replies

Tamara Sutton
User offline. Last seen 3 years 44 weeks ago. Offline
Joined: 8 Feb 2001
Posts: 28
Groups: None
Probably too late in the game for this, but anyway . . . I’ve found that when you group by predecessors or successors, you can then paste the relationships into Suretrak. It’s not perfect, you can only add one predecessor or successor per line, but it’s better than nothing.

Regards,
Ernesto Puyana
User offline. Last seen 3 years 3 weeks ago. Offline
Joined: 12 Jan 2001
Posts: 111
Groups: None
I’ve used the exact procedure you describe, to import resource assignments, but once i tried to import predecessors, what i got was a duplicate FS relation for each activitiy.

By the way, have you tried using the pivot table. I’m getting an illegal function message every way i try it. Can you help me?