Question 1

What is the proper Excel file format for this solution?

Run our free Update Category Generator solution to create a sample Excel file for the existing Category you want to Update.

Question 2

Does the Populate Category solution preserve existing Workfront information?

If the Category being (re)populated is already in use, any existing data be preserved PROVIDING each Parameter is still listed in the Excel File. If a Calculated Expression is modified in the Excel file, the new result will be recalculated (optional). CAUTION: an existing Parameter is NOT listed in the Excel file, that Parameter will be DROPPED from the Category along with any DATA that currently exists for that Parameter!

Question 3

Does this solution create new Categories, Parameter Groups, and/or Parameters?

No: it only updates existing Categories (although they can be empty) using existing Parameter Groups and Parameters

Answer 1

To quickly manipulate and realign Categories to better match the business, including adding, removing, and reordering Parameters and Parameter Groups, as well as adjusting Calculated Parameter formulas.

Answer 2

This AtApp lets you select an Excel file. Run it to upload the Excel file and process its Category tab, which reconstructs the Category using the instructions in the Excel file, and (optionally) recalculates the Custom Data Expressions. The cost is per Execution.

CAUTION: an existing Parameter is NOT listed in the Excel file, that Parameter will be DROPPED from the Category along with any DATA that currently exists for that Parameter!

Answer 3

$5.00/App Run

to a maximum of:
$49.00/Day
$199.00/Week
$499.00/Month
$2,499.00/Year

Answer 4

What is the proper Excel file format for this solution?
Run our free Update Category Generator solution to create a sample Excel file for the existing Category you want to Update.
Does the Populate Category solution preserve existing Workfront information?
If the Category being (re)populated is already in use, any existing data be preserved PROVIDING each Parameter is still listed in the Excel File. If a Calculated Expression is modified in the Excel file, the new result will be recalculated (optional). CAUTION: an existing Parameter is NOT listed in the Excel file, that Parameter will be DROPPED from the Category along with any DATA that currently exists for that Parameter!
Does this solution create new Categories, Parameter Groups, and/or Parameters?
No: it only updates existing Categories (although they can be empty) using existing Parameter Groups and Parameters

Answer 5

How To Detect and Correct Formula Errors.jpg (749 KB)

How To Use the Update Category AtApp.jpg (198 KB)

Answer 6

Update Category Generator

Update Category

Challenge

Solution

Cost

Frequently Asked Questions

Related Files

Related Solutions