Resource Assignment

Have you clicked "Share with others"? that should be an option when you create or edit a Global Edit.

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

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

that’d 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 doesn’t confused you further. All else fails, I think the Developer’s 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.....



engriqbal@yahoo.com