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.

P3.1

18 replies [Last post]
Tue, 2009-12-08 11:20
Santhosh kumar
User offline. Last seen 15 years 19 weeks ago. Offline
Joined: 20 Sep 2008
Posts: 29
Groups: GPC Qatar, Petro-Chem / Oil & Gas
Is it possible to export WBS description and activity code description to Excel and then import that to P3.1?
Top

Replies

Tue, 2010-01-12 04:21
#1
ATIF ALI
User offline. Last seen 15 years 20 weeks ago. Offline
Joined: 10 Dec 2009
Posts: 13
Groups: GPC Qatar, Petro-Chem / Oil & Gas
Thanks for reply anbin
It working
Top
Tue, 2009-12-22 05:52
#2
Anbin Ponnith
User offline. Last seen 9 years 14 weeks ago. Offline
Joined: 8 Jun 2009
Posts: 158
Groups: Civil Engineering
Hai
U Can Try This
1.File - Open - Select The Project(XXXX)-Project Overview-Target-Delete The Target

Regards
Anbin Ponnith
Top
Mon, 2009-12-21 07:08
#3
ATIF ALI
User offline. Last seen 15 years 20 weeks ago. Offline
Joined: 10 Dec 2009
Posts: 13
Groups: GPC Qatar, Petro-Chem / Oil & Gas
Dear Anbin,
Thanks a lot Anbin, really appreciated your help & it did work, although i have Excel 2003.
I was working on a Schedule for which i have defined the Target Project & when i Backup this schedule & want to open it as INdividual Project it again Ask for Target Project. Is there any option we can Disbale the Target project requirement like any other Unique Project & it start Opne without Asking Target Project

Regards,

ATIF
Top
Sun, 2009-12-20 08:06
#4
Anbin Ponnith
User offline. Last seen 9 years 14 weeks ago. Offline
Joined: 8 Jun 2009
Posts: 158
Groups: Civil Engineering
Hai Atif
Sorry for the Late Reply,I also found the same error in my System.I rectified it by the following Steps:
1.In the RA Application Folder u Can See These two Files
i.COMDLG32.OCX
ii.REFEDIT.DLL
2.Just Copy Those two Files & Paste it in ur System
C:\Windows\System32
3.Restart ur System
4.Now open Excel2007->Developer->VisualBasic->Tools-Reference->Missing XXXXXXXXX->Browse->C:\Windows\System32\COMDLG32.OCX
5.Restart ur System

Regards
Anbin Ponnith
Top
Mon, 2009-12-14 01:59
#5
Anbin Ponnith
User offline. Last seen 9 years 14 weeks ago. Offline
Joined: 8 Jun 2009
Posts: 158
Groups: Civil Engineering
Dear Atif,

The RA application excel sheet runs with Active X controller.Please enable it or prompt it.Also make the macro security level low in our excel function.



With Thanks & Regards,

Anbin Ponnith
Top
Mon, 2009-12-14 01:29
#6
Anbin Ponnith
User offline. Last seen 9 years 14 weeks ago. Offline
Joined: 8 Jun 2009
Posts: 158
Groups: Civil Engineering
Dear Atif,

Do you have RA application in your P3 CD that you have installed?

If not give me your mail id I will sent you.



With Thanks & Regards,

Anbin Ponnith
Top
Mon, 2009-12-14 00:57
#7
ATIF ALI
User offline. Last seen 15 years 20 weeks ago. Offline
Joined: 10 Dec 2009
Posts: 13
Groups: GPC Qatar, Petro-Chem / Oil & Gas
Dear Anbin,

its

"Could not load an object becauz its not available on this machine"
Top
Sun, 2009-12-13 01:24
#8
Anbin Ponnith
User offline. Last seen 9 years 14 weeks ago. Offline
Joined: 8 Jun 2009
Posts: 158
Groups: Civil Engineering
Dear Atif,

Could you please show which error message are you getting.So that I can sort it out.


With Thanks & Regards,

Anbin Ponnith
Top
Thu, 2009-12-10 11:44
#9
ATIF ALI
User offline. Last seen 15 years 20 weeks ago. Offline
Joined: 10 Dec 2009
Posts: 13
Groups: GPC Qatar, Petro-Chem / Oil & Gas
Dear Anbin
i tried this new Option on ma system & it getting an error Message " Could not load an object becauz its not available on this machine"
I have P3.1 already installed on ma machine so kindly give me some solution.

Regards,

ATIF
Top
Thu, 2009-12-10 03:02
#10
Santhosh kumar
User offline. Last seen 15 years 19 weeks ago. Offline
Joined: 20 Sep 2008
Posts: 29
Groups: GPC Qatar, Petro-Chem / Oil & Gas
Dear Anbin,

Thanx a lot.I got it.


Best Regards,

Santhosh

Top
Thu, 2009-12-10 01:19
#11
Anbin Ponnith
User offline. Last seen 9 years 14 weeks ago. Offline
Joined: 8 Jun 2009
Posts: 158
Groups: Civil Engineering
Dear Santhosh,

After opening the Project.xls. It will show a security warning.Just enable it.

Then enter your P3 user name& password.

Then there is a box Get WBS Dictionary.Just click it.It asks the project to be opened.Just give your project location.You will get the details.

After you change any details click the box.Set WBS Dictionary.
once again it asks the project to bet set.Give the location.It will automatically get updated in the project.

Regards,

Anbin Ponnith
Top
Wed, 2009-12-09 11:13
#12
Santhosh kumar
User offline. Last seen 15 years 19 weeks ago. Offline
Joined: 20 Sep 2008
Posts: 29
Groups: GPC Qatar, Petro-Chem / Oil & Gas
Dear Anbin,

Thanx for the reply.
But could you please tell me ,how i can export the WBS description & activity code description from P3.1 to excel and then import the same to another P3.1 project.


Best Regards,

Santhosh
Top
Wed, 2009-12-09 09:13
#13
Anbin Ponnith
User offline. Last seen 9 years 14 weeks ago. Offline
Joined: 8 Jun 2009
Posts: 158
Groups: Civil Engineering
Dear Santhosh,

It comes along with P3 CD.Its in the folder RA Application.

Its a excel file developed with macros.

regards,

Anbin Ponnith
Top
Wed, 2009-12-09 08:27
#14
Santhosh kumar
User offline. Last seen 15 years 19 weeks ago. Offline
Joined: 20 Sep 2008
Posts: 29
Groups: GPC Qatar, Petro-Chem / Oil & Gas
Dear Anbin,

Could you please elaborate upon that?
Is that a batch file?


Best Regards,
Santhosh
Top
Wed, 2009-12-09 07:13
#15
Anbin Ponnith
User offline. Last seen 9 years 14 weeks ago. Offline
Joined: 8 Jun 2009
Posts: 158
Groups: Civil Engineering
Dear Santhosh,

We can get WBS description and Activity code description using RA applications. (Project .xls)


With Thanks & Regards,

Anbin Ponnith
Top
Wed, 2009-12-09 01:16
#16
Shah. HB
User offline. Last seen 1 year 27 weeks ago. Offline
Joined: 25 Nov 2008
Posts: 773
Groups: GPC Malaysia, GPC Qatar, Planning, Claims & Contracting, TILOS
you r right , description have to be done manually as of i knew
Top
Wed, 2009-12-09 01:09
#17
Santhosh kumar
User offline. Last seen 15 years 19 weeks ago. Offline
Joined: 20 Sep 2008
Posts: 29
Groups: GPC Qatar, Petro-Chem / Oil & Gas
Hi Shahul,

You can export Activty codes and WBS ,but iam talking about activity code description and WBS description.
Top
Wed, 2009-12-09 00:51
#18
Shah. HB
User offline. Last seen 1 year 27 weeks ago. Offline
Joined: 25 Nov 2008
Posts: 773
Groups: GPC Malaysia, GPC Qatar, Planning, Claims & Contracting, TILOS
Hi

You could do it that option is available in export
Top