Follow

Adding & Updating multiple records

Sometimes it is more convenient to update multiple records at the same time, for example if you want to update the status of issues, update task progress percentages or re-assign multiple issues.  Also, when adding a number of similar items, PPO provides functionality that makes this a lot easier than adding the items individually.

On the action panel on all project related entity list pages you will find an action icon which will take you to this functionality. The caption of the icon will differ depending on the entity, e.g. "Edit Risks" is the caption for the Risk entity.

Note that this functionality is currently not available for projects, employees or programmes, mainly because of the large number of fields generally associated with these entities which make a tabular editing format impractical.  These entities are generally also updated less frequently than project related entities. This functionality is also not available for documents, mainly because physical documents need to be uploaded to PPO, and this cannot be done via the multiple edit functionality page.

The risks entity has been used in this article as an example, but the principles can be applied to all project related entities.

Edit_Risks.jpg

In the example above, to add or edit multiple risks, click on the Edit Risks icon from the Risk >> List page.

kb_basic_step19.png

The Risks >> Edit page will open.

Risks_Edit_Page.jpg

Note that the items shown on the Risks >> Edit page, will be the same items as on the Risks >> List page, for e.g if you filtered the Risks >> List page to only see Risks assigned to Ravi Naidoo and then clicked on the Risks >> Edit icon,
you will also only see the Risks assigned to Ravi Naidoo. Also note that if there are more than 100 items, you will receive a warning that only the first 100 items are shown.

By default all required fields, are displayed as columns on the Risks >> Edit page, so to add non-required fields as columns to the Risks >> Edit page, click on the Show / Hide List Columns icon in the top right hand corner of the page.

kb_basic_step14.png

Note that if a field is added or removed after changes have been made on the multiple edit page, all changes will be lost. Therefore, be sure to add all required columns before starting the update.

kb_basic_step15.png

To edit a record, simply click on the record you want to edit and make the required changes. 

Click_to_Edit.jpg

To add a new record, click on the green plus at the bottom of the multiple edit page.

Add_a_new_line.jpg

A new line will open so that you can supply the information for the new record.

New_Line_added.jpg

To copy an existing record, first select a specific line as per the screenshot below:

Click_to_Edit.jpg

and then click on the Copy icon at the bottom of the multiple edit page.

Copy_the_row.jpg

A copied line will be displayed, with the information of the previously selected line. You can then change only the fields that are different.  This is useful for example, where you have to create a record for every month of the year, or you want to assign the same item to multiple users.

Please note that when using the copy functionality, only the columns that are displayed will be copied. Other non-required fields will be left blank.

Copied_Line.jpg

Once all changes have been made, click on the Submit icon to return to the Risk >> List page.

Access the following video which will explain the multiple adding and updating functionality, as shown above.

Important: When adding or editing multiple items it is easy to lose track of time.  If you take longer than the timeout that has been configured (currently 60 minutes) your session will have expired and you will be logged out of PPO and you will lose your changes.  Therefore, make sure that you submit your progress frequently.

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request
Article is closed for comments.
Start a 30 Day Free TrialClick ClickNo Credit Card and No Obligation
Powered by Zendesk