Resource Assignment
Featured Partner
Top Posters
Mattvtek
0 posts
Gareth Evans
3 posts
PP Admin
3, 129 posts
Rajkamal Tangirala
5 posts
Rahul Kumar
1 posts
blake333_
0 posts
Jeamiell Ostrovsky
2 posts
Hamzah Ahmed
0 posts
Quinton van Eeden
3 posts
Sunchana Johnston
12 posts
Our Partners
Thanks Joanne.
I cant find such an option in the Global Edit window. May be I am using an older version? 2.5b :699 OPP
Regards
Rajeev
Have you clicked "Share with others"? that should be an option when you create or edit a Global Edit.
Thanks Joanne!The word document helped me very much.
Another one to bother you, I want to have a couple Global edit specification avaliable in all projects. I tried using the manage library copying it from project to system and viceversa. All the other features(calculated fields, filters etc) becomes available in other projects, while the Global edit doesnot become available in a a new project. A global edit saved in a single project disappears from the list when I close and reopen it. However, I can copy it again from the System and do my work, but usually i have to do changes in around 150-170 projects at a time and trying to always copy the spec from the system wastes a lot of time. Am I missing something to save the Global edit specs in each project?
Much appreciate if could help.
Thanks in advance.
Many thanks Joanne.
I would like to see the word document.
yes...you can create a transfer.dat entry to load in your activity data. If you want to load in Code Assignments, you must first load the Code File data.
Save your excel file as a csv, then in transfer.dat type
IMPORT csv Import Activities from Excel
TABLE ACT
FIELD ACT_ID
FIELD DESCRIPTION
FIELD ORIG_DUR
FIELD Cn (where n = the code field you want to import the data into)
If you send me a private message with your e-mail address, I can send you a word document I created which has the most frequently used fields I use for importing.
Regards
Joanne
Is there a similar script for adding activities?
Suppose you have some 500 activities with IDs, descriptions, codes in an excel spreadsheet, is there a easier way to just import it into OPP?
Thanks for the detailed reply Joanne. I will try it and let you know.
Cheers
Rajeev
OPen Plan has nothing to do with P3 - they are different software packages
Hi
Sorry for that I could not recogized you .
as i was extremly involved wat we were discussing.
any how thanks a lot for your responses.
Last time i visited this site i found it is other than p3.
can you look into wat i am looking for.
i mean xls scripting
thanks
thatd be MS Joanne Foster...Joanne is a female name :)
Open Plan Professional (OPP) is scheduling software, competition to P3. More info can be found on www.welcom.com
Hi
MR.
Joane Foster
Thankds for reply
can i have some thing about
OPP
Wat is this
is it other than p3 or p4.1( Enterprise)
where do i fine it
have u done scripting in XLS for Importing and exporting Data
thanks
you need to search in the directory where OPP is installed (this might not even be you c:/)
it could be under c:/program files/welcom/open plan professional 3.1/
Do a search on the directory which OPP is installed for the transfer.dat file
Joanne
Hi
Joanne Foster
wher do i find c:\program files\welcom\OPP31
I AM USING WINDOW XP
CAN YOU GIVE SOME MORE DETAILS
WHERE I CAN FIND THE OTHER SCRIPS
THANKS A LOT
Hi Rajeev
If you are trying to import the Resource File you need to set up excel with the following columns (* = Mandatory, all others are options columns)
- Resource ID*
- Resource Description
- Resource Category eg Labour, Material, Subcontract, Other Direct Costs
- Resource Type eg Normal, Consumable, Perishable, Resource Pool
Save this as a csv file.
You then need to locate the transfer.dat file (normally located in C:\Program Files\Welcom\OPP31\ open the file in Notepad and add the following to the bottom of this file
IMPORT txt Import Resource File
TABLE RES
FIELD RES_ID
FIELD DESCRIPTION
FIELD RES_CLASS
FIELD RES_TYPE
When you log into OPP next, open your project (make sure your project is selected) you will find under File > Import > General and item called "Import Resource File", click that, and the select OK, it will ask you to locate your csv file, locate it, click Open then it should all import.
If you have an existing Resource File which you want to update, then your transfer.dat entry should be
IMPORT txt Import Resource File
TABLE RES
UPDATE
FIELD RES_ID
FIELD DESCRIPTION
FIELD RES_CLASS
FIELD RES_TYPE
If you are trying to import the Resource Assignment you need to set up excel with the following columns (* = Mandatory, all others are options columns)
- Activity ID*
- Resource ID*
- Level*
- Curve
- Period
- Offset
You then need to locate the transfer.dat file (normally located in C:\Program Files\Welcom\OPP31\ open the file in Notepad and add the following to the bottom of this file
IMPORT txt Import Resource Assignment
TABLE ASG
UPDATE
FIELD ACT_ID
FIELD RES_ID
FIELD RES_LEVEL
FIELD LEV_TYPE
FIELD RES_OFFSET
FIELD RES_PERIOD
When you log into OPP next, open your project (make sure your project is selected) then you will find under File > Import > General and item called "Import Resource Assignment", click that, and the select OK, it will ask you to locate your csv file, locate it, click Open then it should all import.
Once you have imported, check your log to make sure it loaded correctly, View > Log Viewer > Import/Export tab.
Hope this helps and doesnt confused you further. All else fails, I think the Developers Guide Chapter 3 has information on transfer.dat.
Regards
Joanne
yes Dear
there is script that can run in excel envirnment by which you can cutomize the p3 data item in very friendly and time saving way.
u send me your project.give me your required data items to be exported i will send you xls file
You can even work in excel and SET the data in p3.
Customized Reports of Resources/cost can also be.....
[email protected]