Dictionary6x.xls

Sundar email sent

You can download the latest tool available called RANGA, link below

https://prevara.tech

download the latest sdk from here

http://www.eh.com.au/software.html

Arnold,

good day to you. i cannot find activity 6x.xls, project6x.xls in my CD as well as website. If you donot mind, can you please forward these files to my following mail id.

sssingh_sks@hotmail.com

thanks in advance arnold.

Arnold,



Thank you very much for your help, have a good days.

Arnold;



Thanks again. Tried to find you on LinkedIn. Will try to link to you here - not sure how.



You are a great resource.

Hi Dennis,



Sir, I really appreciate your post in AACE Intenational, I am also a member of the said forum. Anyway, thanks for the pleasure.



Here is the link:



http://knowledgebase.primavera.com/attachment/PATTLNK_1172008_031-WBS.x…



Thanks & Regards,



Arnold

Arnold;



I second the endorsement from Jose. Could I trouble you for the link to the WBS file? I tried replacing Activity6x with WBS (uc & lc) to no avail.



Pat yourself on the back. You are great resource even though you work in the dirt - hydrocarbons are ever so much cleaner and healthier.

You are welcome Jose.

Hey Arnold,



Thank you for your help. I Am glad Planning Planet has members like you, willing to help. Thank you again, and have a great day....

Hi Jose & Dennis,



Here are the following links:



1. http://knowledgebase.primavera.com/attachment/PATTLNK_7272009_2049-acti…



2. http://knowledgebase.primavera.com/attachment/PATTLNK_5232007_229-PROJE…



Regards,



Arnold

Hello Arnold Puy,



I been trying to locate this two .xls utilities but I search for them on POINT but the search engine cann’t seem to locate them would you be so kind to send me the links for the two files below: (I already have the Dictionary6x and the WBS one and they work super).



1. PATTLNK_7272009_2049-activity6x.xls

2. PATTLNK_5232007_229-PROJECT.xls



Thanks again, Arnold…..

Milind;



Thanks, somethings just slip right by. As soon as you mentioned it, I slapped myself upside my head - duh.

Arnold;



Any idea where I find it? Looked in POINT and only reference was to the file on the 6.1 CD. Looked at the P6.7 download files and nothing jumped out. Any thoughts appreciated. Thanks.



Any insights into Project.xls and WBS.xls? First time I have heard of them. Activity6x.xls could have real value.

Hi Dennis,



The formerly "PMSDK" in P6x is now "Primavera P6 SDK" in P6 v7.



With regards to the following utilities:



1. Activity6x.xls

2. Dictionary6x.xls

3. PROJECT.xls

4. WBS.xls



You can still use these the same as the previous version.



Regards,



Arnold

Has anyone got Activity6x.xls and/or Dictionary6x.xls to work with P6.7? The update removes PMSDK, I believe. Is there a workaround? Thanks.

Milind,



Thank you for this. My bad, i thought it was the same feature installed in the P6.



Thanks again.

Hey Izam,



I believe Milind was talking about the FILE>IMPORT/EXPORT utility of the P6. It’s not a stand alone executable file.

Milind



Is it possible for me to have it? "utility for import and Export

importExport.exe" as quote from your post below.

I can be reached via my email aizam.zakaria@sbmoffshore.com

That is a great idea. Just recently I have successfully imported all data using MS SQL, basically everything. In the dictionary.xls there are columns that are read only and we have been trying to figure out how we can update those columns. My theory is those columns can’t really be updated using excel but MS SQL or ACCESS.



I would like to see the ACCESS files and perhaps we can work on it.

Hi Hannes,



That’s really great! Actually, I have been working out with that but unfortunately NO success especially with Excel. I can use Activity.xls but I am not satisfied with the result.



Can you please send me a copy to my email address: primavera6@live.com after translating.



Thanks in advance.



Regards,



Arnold

Hi Adrianne



yes it can be linked as well to Excel as to Access. It is even quit easy. I wrote an article about it, but it is in german. Ill try to translate it this week and will post it here



Hannes

Hi Adrianne,



As far as I know, unfortunately No.



Regards,



Arnold

Thanks for the reply arnold. This is the way I am doing it but I was just wondering if by using the SDK the resource type can be changed.



I guess, those methods that you mentioned are the only ones applicable.



By the way, is there a way these can be linked to MS ACCESS? I mean, the whole database.



Thanks again.

Hi Adrianne,



There are two options to do this.



1. Using Resource --> Replace in PM Module

2. Using Excel Sheet



Considering PM Module:



If you want to change the resource type from material to labor then the best thing to do:



1. Create a new resource.

2. Resource Type "Labor".

3. Select all the activities you wanted to change the resource type.

4. Go to "Assign Resources" located at the right corner of your monitor.

5. Select the current assigned resource and select ’Replace".

6. Then select the newly created resource then assign.



Note: You cannot replace resource those activities already has actual.



Regards,



Arnold

I know it’s for P6.



Anyway, is there a way to link P6 to MS Access or Oracle?



I know nothing with MS SQL thus.

sorry ..i got the activity6x.xls...



my bad.

Thanks arnold. One thing that I would like to know about those columns with ’READ ONLY’ note. I understand you cannot modify it from the excel sheet if that’s the case. Is there a way to do that?



Let’s say the resource type to be changed to something else like materials to labor or vice versa...



Also, is there an excel file counterpart of ACTIVITY.XLS of P3 for P6?



Thanks again.

Hi Milind,



Activity5x.xls does not work with P6x. There is a Solution ID: prim4617 in Primavera Online Interaction (Point), there you can download 6.x version



1. PATTLNK_7272009_2049-activity6x.zip

2. PATTLNK_5232007_229-PROJECT.xls



Regards,



Arnold

Hi Milind,



Here’s the link to Primavera Online Interaction (POINT): This IS the latest version.



http://knowledgebase.primavera.com/attachment/PATTLNK_5112009_2037-Dict…



Regards,



Arnold

Hi Milind,



This is available in Primavera Online Interaction (POINT).



Regards,



Arnold