Chapter 10: Utilities

• Import
• User Activity

Import

To import your data, press the CSV Source File button, navigate to the desired file, and open it. The Source table (at the top of the import screen) is populated with the contents of the file.

Next, select the object type to be imported from the Import As drop-down list, below the table. As a result, the table below this drop-down will show the mapping from the CSV fields to the POMS fields for the nominated object type. The To POMS Field column of this table is editable. If you want to change a target field, click on the cell and select from the drop-down list that appears. You can avoid this extra step by ensuring that the field headings in your CSV file match the field names supported by POMS, in which case the mapping is automatically worked out by POMS. The field names supported for each type are:

• Projects:
  • Name
  • Traffic Light
  • Category
  • Status
  • Priority
  • Calendar
  • Run By
  • For Client
  • Dependencies
  • Required Start
  • Start Date
  • Required Finish
  • Finish Date
  • Est. Effort
  • Plan Effort
  • Est % Complete
  • Plan % Complete
  • Plan Duration
  • Description
  • Project Manager
  • Sponsor
• Test Cases:
  • Title
  • Instructions
  • Project
  • Module
  • Category
  • Type
  • Phase
  • Priority
  • Expected Result
• Issues:
  • Title
  • Description
  • Project
  • Module
  • Build
  • Type
  • Severity
  • State
  • Priority
  • Progress
• Risks:
  • Title
  • Description
  • Project
  • Impact
  • Likelihood
  • State
  • Review
  • Progress

If your data contains date values, the Date Format drop-down list allows you to specify the date format for the source data.

If you tick the Update Pick Lists tick box then data imported into fields that are pick lists is compared against the pick list values and, if not present, is added to the pick list.

Finally, either press the Import All button, or select only the rows you want to import from the Source table and press the Import Selected button. When the import is completed, you'll be asked if you want to view the result. Also, any row in the source table that fails to import will show the actual error in the Import Error column so that you can view and rectify it.

User Activity

When you select the User Activity node, a search screen is displayed. You can search for activities based on user, activity type, and a date range. The latter is limited to a maximum of 30 days. Press Find to start the search. The matching records are displayed in the table below the search criteria.

For each activity, the following are displayed:

• The activity ID.
• The user who Performed the activity.
• The Activity name.
• The Object ID for the object affected by the activity.
• The Date/Time for the activity.
• The activity Duration in milliseconds.
• Extra information (depending on activity type).

To view the search result in a web browser, press the View/Print button.