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.

ES, LS, Mandatory Start & Finish constraints remov

6 replies [Last post]
Thu, 2004-02-05 06:35
Gary Lister
User offline. Last seen 6 years 36 weeks ago. Offline
Joined: 17 May 2001
Posts: 18
Groups: Petro-Chem / Oil & Gas
I have just recieved a copy of programme with 4000 activities, I am going to use this programme as a template fro two other platforms, i have removed the actual start & finish dates and the percentages using global change but cannot remove the constraints ( 1500 of them) i have exported to excel and re-imported but the constraints are still there, Is there any way to remove constraints without removing every one individually.

Top

Replies

Sat, 2004-02-21 09:30
#1
MK TSE
User offline. Last seen 3 years 47 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
RA is available long long time ago, but I disn’t notice what RA stand for, may be Remote Access (kidding). RA ia just some programming work to run some data communication connection from P3 to some other software, like Excel, Access, FoxPro, etc.
In most situation, we use export/import to get data from/to P3, the limitation is only part of P3 data can be "touch", by RA, you have more.
I remember on CD, there ia a P3 data map. It helps much on establish add-on solution.
Top
Wed, 2004-02-18 18:32
#2
Ronald Winter
User offline. Last seen 3 years 7 weeks ago. Offline
Joined: 4 Jan 2003
Posts: 928
Groups: None
It is funny, but although I have been using RA for years, I don’t know what it stands for either. I went back to the P3 3.1 installation disk and looked in the Ra help file (it doesn’t seem to rate a manual, only help files and samples.) The introduction does not define it and even the glossary only says what it does, not why it is called, “RA”.

RA is another method of accessing P3 schedules and the data in them other than using P3 itself. It is like Batch, only much different. You use OLE to access the RA API (Application Program Interface) which then accesses your P3 data using P3 rules. You can use Excel or Visual Basic to make the OLE connection to RA.

Don’t look to the manuals on the P3 installation disk for help. Instead use Explorer and access the CD’s “RA” directory. There you will find the RA help file and a series of confused samples and unrelated documents. Put them together, stir them around, and you have yourself a very programmable interface into P3! Good luck!
Top
Wed, 2004-02-18 05:49
#3
Zq qz
User offline. Last seen 12 years 15 weeks ago. Offline
Joined: 6 Jun 2003
Posts: 163
Groups: None
Hello, can you elaborate what RA means
Top
Sat, 2004-02-14 07:53
#4
MK TSE
User offline. Last seen 3 years 47 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
Or by RA, the fill the value for constraint is "DELETE"
Top
Fri, 2004-02-06 09:35
#5
Steven Oliver
User offline. Last seen 11 years 23 weeks ago. Offline
Joined: 8 Nov 2002
Posts: 313
Groups: None
What about a Global Change, with the line SNE EQ " " (for Early Start Constraint, MF for mandatory finish etc)
Top
Fri, 2004-02-06 05:43
#6
Paul Harris
User offline. Last seen 1 year 5 weeks ago. Offline
Joined: 11 Apr 2001
Posts: 618
Groups: Content Moderators, GPCCAR Editors
Gary

The easiest way is to open the file with SureTrak, display the constraints in a column and then use the Cell Copy and Paste to remove them.

If you do not have a copy of SureTrak, I recommend you get one as it has some very neat features that P3 does not have, like copy & paste from Excel, Group by Activity ID, Predessor and Successor, Constraints & Log in Columns.

Regards

Paul E Harris
Eastwood Harris
Top