External Relationship Not Shown When Exported to Excel
Forum Sponsor
Top Posters
Aidar Kurmantayev
0 posts
Noe Radovan
8 posts
GeoVe
0 posts
James Williams
74 posts
Johannes Vandenberg
14 posts
Soheil Barekat
4 posts
Peter Holroyd
51 posts
Neil Atkinson
5 posts
Trian Asmoro
1 posts
Erkan Polater
9 posts
The key is in "I select the project I want to export".
You can only export one project at a time using the excel functionality, so there is no way to get the external relationships.
You need to use the XER export to get relationships to other projects and even then all the projects have to be open at the same time (as Ron said).
The XER parser tool is very useful to manipulate data. Its not as easy to use as the Excel import/export but it is much more powerful. Its available on the knowledgebase.
Ian
http://www.emerald-associates.com
Hi Ronald,
I am respecting the two points that you mentioned but still the exported Excel file does not show the external relationships.
By the way, for making the export I use the following while opening all linked projects into P6 :
go to menu File -> Export -> Spreadsheet-(XLS) -> Activity Relationships -> I select the project I want to export -> select the template (without specifying any filter inside it) ->.....
Richard,
If Excel export works the same as P6 export, then you need to do two things to get P6 to export external relationships to Excel.
1) The schedule has to have its CPM optional calculation settings set to not ignore external relationships.
2) You need to open all of the ‘external’ schedules at the same time as you open the one schedule you want to export.
These two things tell P6 that you also want to export the ‘open’ relationships. Good luck!