Import & Export
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
can select "Activity detail" and "relationship" at the same time. if both option checked, the template will be served for both
Thnxs Mycal
It was wounderfulllll
With regards
Arun.V
Hi Arun,
As I mentioned in my previous post step #1 is only limited. Proceed to step #2.
Go to File Menu --> Export --> Spreadsheet - (XLS), in Export Type, select Activity Relationship, then add a new Template, you can see the Predecessor and Successor Activity Name.
Regards,
Arnold
Hai Arnold
Still Iam facing the same problem .While exporting instead of predessor name I can see only predessor & Successor ID which is really confusing for me ....
Please help Arnold .
With regards
Arun.V
Hi Arun,
There are several ways on how to export or modify your works in Excel.
1. In Activity Window you can simply right click anywhere in the activity table area and select "Export to Excel"
2. In the File Menu --> Export.
3. By using the Primavera utilities (e.g. Dictionary6x.xls, Activity6x.xls, Project6.xls, etc..) with the help of SDK.
4. Copy & Paste to Excel.
The #1 functionality is limited, easy and only available in the Activities Window.
In your case, you can use the #1 however, it is depend in your needs. Display all the required Columns (i.e. Activity ID, Activity Name, Original Duration, etc…) and create a new filter using the below parameters.
(Any of the following)
Where: Activity Name "contains" or "starts with" block
Or: Activity Name "contains" or "starts with" plaster
When done, you can now proceed to step #1. Otherwise, you can go for step #2 and then import it back to P6 by selecting File --> Menu --> Import.
Regards,
Arnold
Nope, no need to export Arun....
BUT.....importing INTO P6 is slightly different, and can be somewhat awkward....
What I have done in the past is to export from P6 into Excel, purely to give me the layout and the specific formatting that Primavera understands. For example, once exported into Excel, you will notice the headings:
task_code status_code wbs_id wbs_name task_name end_date start_date delete_record_flag
Also note that each of the Cells contain prior to the info. Have a play around with this, pasting the correct info into the columns with the headings as described above.
I also believe there may be an easier (and less time consuming) way of doing the import with the SDK tools. Im pretty sure Arnie mentioned something about it a while back so maybe he can chip in and shed some light on the matter. But for now, try the above method, I have definitely got it to work before, and as I said...it can be a bit touch and go.
Good luck
walshy
On export wizard, when screen for item selection prompt, there are 3 tab pages on this window, one is item selection, one for filter and one for sorting order. Input your selection criteria on Filter page
Thnxs Washly
No need to export ???? hw we will import to P6??
With regards
Arun.V
Arun,
I think this is what youre after, and Its very easy, just run a filter on the activities you want to keep, then highlight them and copy.......open Excel and paste, you can remove anything you dont want later.
Walshy