Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

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.

delete relationships

8 replies [Last post]
Tue, 2005-05-31 21:41
Eckart Schenck
User offline. Last seen 4 years 41 weeks ago. Offline
Joined: 25 May 2005
Posts: 28
Groups: None
Good morning!

Can anybody help?

I have a project with about 2500 activities. Now I want to delete all Successors and Predecessors. I’ve tried xls export amd import. But there you can only add new relationships or modifies the existing ones.

Do you know of another automated way?

Thanks
Heinz
Top

Replies

Tue, 2005-07-05 03:34
#1
Sukumaran Subaram...
User offline. Last seen 9 years 19 weeks ago. Offline
Joined: 2 Mar 2005
Posts: 229
Groups: GPC Malaysia
Guys,

Finally, to delete the relationships within 5 minutes in a schedule with greater number of activities. Please refer to the below posting:
http://www.planningplanet.com/forum/forum_post.asp?Cat=2&Top=12799.

Regards
Top
Wed, 2005-06-01 04:46
#2
Jaco Stadler
User offline. Last seen 18 years 7 weeks ago. Offline
Joined: 8 Sep 2004
Posts: 299
Groups: None
Another way maybe very simple is

1) Make a Copy
2) Export all The date
3) Delete all Activities
4) Import all the Data

But this might seem strange why would anybody want to do such a thing.


Top
Wed, 2005-06-01 03:18
#3
Philip Jonker
User offline. Last seen 16 years 4 days ago. Offline
Joined: 7 Nov 2004
Posts: 852
Groups: None
Hi Joshi,

In my posting I stated the fields (columns), in brackets, that needs to be exported in order to set up a complete activity files upon re-importing.
These are for activity files: Activity id (ACT), Activity description (TITLE), original duration (OD), Calendar (CAL), Activity Codes (this will export all your activity codes). Obviously if you are using WBS, Logs you need to export them as well, and if the project is in progress you will need to include actual start and finish dates as well as percent complete. One thing to make sure of is that in the export setup, make sure that the activity description length is set to 48 characters long.

For resource files you need: Activity id (ACT), Resource (RES) and Budget quantity (BQ).

In the case of Heinz, who wants to delete reltionships, the only reason to use excel would be to check if all the information was correctly exported, if so, just close the file again and import after deleting the activities (which will delete the relationships as well). If you need to add activities, or edit the activities, in excel, it is advised that a new file (spreadsheet ) is opened, and that the activity data, including field names are copied to this file, and when complete make sure to save this file as a .dbf. One problem is that you must understand some basic rules for database (.dbf) files. file names must be 8 characters or less and must not contain blanks or any other funny characters ( try to stick to alpha or numeric characters). There is rules for field names, however, in this instance stick to the field names you have exported from P3. By the way, a field in daatabase terminology is thing same as a column in spreadsheet terminology. And in dbf a xls line is called a record.
This might all sound a bit archaic, but .dbf files stem from the days when dos was still in use, however, as most applications that are database based, still prefer this format when importing, even a program like Access.

Hope this explains what you want to know. The rest is simple enough to work out for yourself.

Regards

Philip
Top
Wed, 2005-06-01 02:32
#4
Joshi Niraj
User offline. Last seen 19 years 25 weeks ago. Offline
Joined: 12 Feb 2005
Posts: 27
Groups: None
Hi Jonker

you say

"The best way to export/import is via .dbf (database) files. It is a five minute job and not very complicated."

Can u specifically brief the five minute procedure especially for

a) import from Excel with each column (links, resources etc.)

b) Export from P3 with each column


File> Tools> import.....

I have tried all the methods mentioned in this forum by different planners but all the methods are fake not fully compatible for import and export of all columns from P3 to excel and from excel to P

So if you have any best way to import or export file from P3 to EXCEl, please mention here for our guidance

Thanks
Top
Wed, 2005-06-01 01:05
#5
Eckart Schenck
User offline. Last seen 4 years 41 weeks ago. Offline
Joined: 25 May 2005
Posts: 28
Groups: None
Thank you!
Top
Wed, 2005-06-01 00:51
#6
Philip Jonker
User offline. Last seen 16 years 4 days ago. Offline
Joined: 7 Nov 2004
Posts: 852
Groups: None
Hi Guys,

As a matter of interest, it can be done by export/import. Export all the basic activity data (Activity id, description, original duration, calendar and activity code fields) and resource data (act id, resource, Budget quantity) if the schedule is resourced. Make sure you export activity data and resource data to seperate files. Then delete all activities, and import the exported data. Voila, no more relationships.

A Tip: The best way to export/import is via .dbf (database) files. It is a five minute job and not very complicated.

Regards

Philip
Top
Tue, 2005-05-31 23:25
#7
Bill Guthrie
User offline. Last seen 8 years 29 weeks ago. Offline
Joined: 14 Mar 2005
Posts: 262
Groups: Petro-Chem / Oil & Gas
Sukumaran, very good approach. outstanding

other ways but this is most effective.
Top
Tue, 2005-05-31 22:18
#8
Sukumaran Subaram...
User offline. Last seen 9 years 19 weeks ago. Offline
Joined: 2 Mar 2005
Posts: 229
Groups: GPC Malaysia
Hi,

Go to Edit > Select All > Unlik Activities. It will remove the contiguous finish to start relationships.

In order to remove all relationships go to P3.INI file, change UnlinkAllRels=0 to 1. Then go to Edit > Select All > Unlik Activities. It will unlink all relationships.

Regards.
Top