Skip to content
ProjectControls.com
Oracle Primavera - PM6

Global Change P6.1

In the Open Standard
Leo NicholsonMember for 20 years 7 months
Created
4
1
0

I need to modify user fields on some 30 several saved updates (XER) of a project with a large set of conditional changes.

The changes are in a series:

If a unit activity code is 100 rename to 100 xxx
If a unit activity code is 110 rename to 110 yyy
.
.
.


I can change with global change, but only with multiple executions. What is best way, outside of excel, to do this? Is there a way to set up a single global change, use SQL, etc. ?

I have tried using Excel, but have memory errors on import, even with dividing the xls files.  I am an Xbase programmer, but not conversant in SQL.

Save Follow Follow forum Report
Reply New topic

4 replies

Oldest first
  1. 0
    Zoltan Palffy ·
    #1

    why not open all 30 projects

    why not open all 30 projects at athe same time and do it all at once  ?

    Report
  2. 0
    Leo Nicholson ·
    #2

    Each project has 35,000

    Each project has 35,000 activities.

    Report
  3. 0
    David Kelly ·
    #3

    You cannot use Global Change

    You cannot use Global Change to set the value of an activity code to anything other than an actual value currently in the dictiionary.  So in your example you cannot concatenate the current value with anything, e.g. xxx or yyy.

     

    DEpending on how many values you have, Group and Sort by the existing value and "fill down" (remembering to set "auto arrange" off first!) is not a bad way to do it. 

     

    I would expect issues using the built in Import/Export to excel routines with 35k activities, but divided up into smaller sections, even 10k, should work? You are not missing any activity code dictionary values before you start? Import/export cannot create dictionaries and will not import code values unless they are present in the dictionary.

    Report
  4. 0
    Leo Nicholson ·
    #4

    Thanks for the

    Thanks for the thoughts.

    Finally gave up and wrote a program to parse and rebuild the XER's to include my UDF fields. Only takes about five minutes per XER.

    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?