it depends on what you want to import some fileds are not importable unless using SDK
go into p6
create a project
create any necessary codes you may want to import
create 1 dummy activity and assign each code to this activity
export this 1 activity from p6 to excel and select what items that you want to export this will be used as your template to import your information from excel to p6
open both files in excel and copy the informatin from your old spreadsheet into the newly exported spreadsheet.
note the format for each column will an apostrophe ' character as the leading character in the cell.
Hey Mike - Afraid not. I wish it was that simple. P6 is a complicated tool and is not setup the same way many Microsoft products are. Its a database oriented type of system, not a spreadsheet. But really, its pretty easy to create an import file as decribed below, then just copy and paste all the activities at one time into the import file. The import the revised spreadsheet back in. Literally takes about 3 minutes.
Dont let the copy/paste functions drive your software choice. P6 is by far the most powerful and versatile scheduling tool I've ever used. I wont use anything else now.
Thanks,
Scott Chumley
Check out my blog! Soon I will have P6 training videos and a huge templates download warehouse! If you have suggestions for an article just email me.
I do not use P6 and the more I learn from this forum then I realise why I am better off without it.
Surely you can copy all 2000 texts in Excell and just paste them in one click into the corresponding column in P6?
I will be starting to use P6 next week with my new employer and if the software will not allow simple copy paste between columns then I will be driving for a switch to PowerProiect.
You can, but if you have 2,000 activities it is much faster to import them rather than copying and pasting one at a time. You would still have to apply logic and relationships but at least you dont have to type everything.
It sounds like the Excel spreadsheet you are trying to import is in the wrong format. Export a project to Excel to get the correct format (tab names, column headings, user settings), then delete all data and use this as a template. Paste your programme in to the correct tabs/columns and import to P6 .... should work.
Member for
16 years 3 monthsit depends on what you want
it depends on what you want to import some fileds are not importable unless using SDK
go into p6
create a project
create any necessary codes you may want to import
create 1 dummy activity and assign each code to this activity
export this 1 activity from p6 to excel and select what items that you want to export this will be used as your template to import your information from excel to p6
open both files in excel and copy the informatin from your old spreadsheet into the newly exported spreadsheet.
note the format for each column will an apostrophe ' character as the leading character in the cell.
Member for
8 years 2 monthsThis program will convert
This program will convert microsoft project file to xer
About:
http://eppmsoft.com/articles/p6eppm_admin/P6EPPM_Admin_doc.php
Download 30 day trial (Admin tools):
http://www.eppmsoft.com/downloads.php
Member for
14 years 7 monthsHey Mike - Afraid not. I
Hey Mike - Afraid not. I wish it was that simple. P6 is a complicated tool and is not setup the same way many Microsoft products are. Its a database oriented type of system, not a spreadsheet. But really, its pretty easy to create an import file as decribed below, then just copy and paste all the activities at one time into the import file. The import the revised spreadsheet back in. Literally takes about 3 minutes.
Dont let the copy/paste functions drive your software choice. P6 is by far the most powerful and versatile scheduling tool I've ever used. I wont use anything else now.
Thanks,
Scott Chumley
Check out my blog! Soon I will have P6 training videos and a huge templates download warehouse! If you have suggestions for an article just email me.
Project Controls Network
Member for
19 years 10 monthsHi Scott I do not use P6 and
Hi Scott
I do not use P6 and the more I learn from this forum then I realise why I am better off without it.
Surely you can copy all 2000 texts in Excell and just paste them in one click into the corresponding column in P6?
I will be starting to use P6 next week with my new employer and if the software will not allow simple copy paste between columns then I will be driving for a switch to PowerProiect.
Best regards
Mike Testro
Member for
14 years 7 monthsMike,You can, but if you have
Mike,
You can, but if you have 2,000 activities it is much faster to import them rather than copying and pasting one at a time. You would still have to apply logic and relationships but at least you dont have to type everything.
Thanks,
Scott
Project Controls Network
Member for
19 years 2 monthsMai It sounds like the Excel
Mai
It sounds like the Excel spreadsheet you are trying to import is in the wrong format. Export a project to Excel to get the correct format (tab names, column headings, user settings), then delete all data and use this as a template. Paste your programme in to the correct tabs/columns and import to P6 .... should work.
Andy
Member for
19 years 10 monthsHi Mai Are you saying that
Hi Mai
Are you saying that you cannot just copy/paste between excell and P6 spreadsheets.
Best regards
Mike T.