Skip to content
ProjectControls.com
Oracle Primavera - PM6

Mass Resource Import

In the Open Standard
Claire LepoutreMember for 15 years 8 months
Created
7
3
0

Hi

I am trying to upload into P6 a library of resources (1500 resources) from some estimating software (Candy) - this is info that is not held on any planning software.

I have created an resource export file in P6 and used this file to create a P6 import file with the new resources.  I have tried importing this several ways but nothing works.

Does anyone know how I can mass import resources using a spreadsheet so that I do not need to manually add 1500 resources!

Thanks

Claire

Save Follow Follow forum Report
Reply New topic

7 replies

Oldest first
  1. 0
    Andy Power ·
    #1

    Claire You should be able to

    Claire

    You should be able to import resources through Excel import, if you have a template exported from P6 with the resources data type and the fields you require, you should be able to paste your data on to it and then import the new resources.

    NOTE:  Don't make any changes to the tab names, column headings or on the USERDATA tab just change the data below on the RSRC tab.  Also, I make sure the resource ID's don't already exist in P6.

    I find a better way to do it is by using the SDK and the Dictionary6x.xls or Dictionary6v7.xls (depending on P6 version) to import that way.  The SDK is a bit more reliable!

    Hope that helps.

    Andy

    Report
  2. 0
    Raymund de Laza ·
    #2

    Hi Andy, I have

    Hi Andy,

    I have activity6x.xls and dictionary6x.xls. Do you posses a file for the wbs export? I appreciate much if you could share the file as I need  it so badly.

     

    Thanks in advance.

     

    Regards,

    Raymund

    Report
  3. 0
    Vladimir Liberzon ·
    #3

    Hi Claire, I am curious what

    Hi Claire,

    I am curious what is info that is not held on any planning software?

    Best Regards,

    Vladimir

    Report
  4. 0
    Raymund de Laza ·
    #4

    Hi Andy,   Here is my email

    Hi Andy,

     

    Here is my email add: rpl5000@hotmail.com

    I am so thankfull for your contineous support.

     

    Thanks in advance,

     

    Raymund

    Report
  5. 0
    Raymund de Laza ·
    #5

    Hi Claire, Let me have your

    Hi Claire,

    Let me have your email add and I will send toyou the excel files you need to import the resources to P6.

     

    Reagrds,

     

    Raymund

    Report
  6. 0
    Claire Lepoutre ·
    #6

    Andy   Thanks very much for

    Andy

     

    Thanks very much for you help.  It have installed the SDK and dictionary.  You have saved me loads of work.

     

    Claire

    Report
  7. 0
    Liu Yi ·
    #7

    I had made a programme by

    I had made a programme by powerbuilder V9,then can import a lot of resources by once.but,the first work is filled by a kind of form

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?