delete relationships

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

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.

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

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

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

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.