Import PPM Resources
Import a batch of Resources instead of creating them individually.
At initial set up of Cherwell PPM, most Administrators will choose to import a batch of Resources. An Automation Process will create daily resource time records through the end of the current calendar year and next year.
Importing a batch of Resources in bulk requires significant processor speed and memory to run concurrent Automation Processes and cache queued automation requests (when a Resource is added, an Automation Process creates time summary records for each remaining day in the current calendar year and all of the following calendar year). Run this bulk import using server resources. If Cherwell Services are running on a laptop instead of a server, we recommend adding Resources one at a time and waiting three minutes between each addition to allow the automation processes to complete.
In benchmark testing, importing 300 Resources took 4.5 hours.
To import resources:
- Enter your Resource information in a CSV that will be imported.
- Open CSM Administrator.
- Select the Database option under Categories.
- Select the Run a one-off data import (CSV files) link.
- Follow the prompts in the Import Data Wizard.