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.
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.
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.
Each project has 35,000 activities.
why not open all 30 projects at athe same time and do it all at once ?