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.

MS Excel & Importing into SureTrak

2 replies [Last post]
Sat, 2008-02-09 14:22
Shane Pouch
User offline. Last seen 12 years 47 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
Top

Replies

Thu, 2008-05-01 16:48
#1
Tamara Sutton
User offline. Last seen 8 years 23 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,
Top
Thu, 2008-02-28 17:30
#2
Ernesto Puyana
User offline. Last seen 7 years 34 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?
Top