Loading...
Quick Links

Reply To: Enterprise Custom Field/Resource Custom Field Question

Home Forums Discussion Enterprise Custom Field/Resource Custom Field Question Reply To: Enterprise Custom Field/Resource Custom Field Question

#6894
CommunityCommunity
Keymaster

Laurel, here’s an off the cuff process that you might consider. Off the cuff means that I don’t actually have the process written down from a job aid so test it first: 1. Open the resource pool in MS Project and copy the custom field column to an excel spreadsheet. This is used to update the resource pool with original entries. 2. If you can’t open the lookup table you can get the entries directly from this excel file by viewing only unique entries, otherwise open the lookup table and copy the entries to another excel sheet 3. Rename the current custom field and lookup table 4. Create a new lookup table and copy the entries from your excel sheet 5. Create a new custom field with the same attributes as your original 6. Open the resource pool again (same way, same sort sequence) and copy the entries back to the new resource custom field 7. Make sure it all works and delete the original lookup table and custom field. You will need to recreate any MS Project or PWA resource views that use this column, and any BI reports. “Off the cuff” that should be close. I’m not sure why or to what extent it is corrupted but this is a basic process that would create a new custom field and preserve previous entries. But then again, someone might have this written in a job aid. Good luck…