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.

Primavera 6

4 replies [Last post]
Wed, 2009-10-14 13:24
Timmanna Huilgol
User offline. Last seen 12 years 1 day ago. Offline
Joined: 30 Mar 2008
Posts: 6
Groups: GPC Qatar
how to import activity codes & code details from excel to p6
Top

Replies

Sat, 2009-10-17 08:57
#1
sachin sangai
User offline. Last seen 10 years 5 weeks ago. Offline
Joined: 8 Oct 2005
Posts: 12
Groups: GPC Qatar, Petro-Chem / Oil & Gas
Sorry Walshy it doesnt work.
Becasue the Activity codes are not defined, it gives an error while u import.

Thanks Arnold for the help PATTLNK_632006_536xerFileParser&Builder.xls works just fine.

Sachin
Top
Thu, 2009-10-15 10:44
#2
Neal Walsh
User offline. Last seen 4 years 36 weeks ago. Offline
Joined: 16 Sep 2007
Posts: 49
Groups: Civil Engineering
Timmanna,

An easy way of doing this (if you have one) is to export a programme with Activity Codes to Excel. The result will show you what format the Excel needs to be in to allow Primavera to understand it. Then, delete the Activity codes and replace with the ones you need before importing into P6. I have done this successfully with Activity ID’s / Names and dates / durations etc....but not with Activity coes, although in theory it should work. I know Primavera requires the ’ at the beginning of each cell data.
Good luck

Walshy
Top
Thu, 2009-10-15 04:43
#3
sachin sangai
User offline. Last seen 10 years 5 weeks ago. Offline
Joined: 8 Oct 2005
Posts: 12
Groups: GPC Qatar, Petro-Chem / Oil & Gas
hi Arnold

can u elaborate more on how to use PATTLNK_632006_536-xerFileParser&Builder or guide us to a place we can find more information on this because i see for many quarries this seems to be the answer.

Cheers

Sachin
Top
Wed, 2009-10-14 14:11
#4
Arnold Puy
User offline. Last seen 10 years 20 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Hi Timmanna,

You have Three ways to perform with:

1. You need to have SDK (Dictionary6x.xls).
2. You can use the PATTLNK_632006_536-xerFileParser&Builder.
3. You can also link or connect to the database using MS Access or MS Excel.

Regards,

Arnold
Top