Exporting, Modifying, and Importing Data in One Session

CSV files enable you to export data from Performance Scorecard, modify or delete the data, and re-import it into Scorecard in one session.

  To perform a one—session transfer:

  1. Open a command window and change to the directory that contains the import and export commands. By default, these commands are in hps\9.5.0.0\tools\bin.

  2. Enter the export command, using this format:

    export behavior filename.csv [options]

  3. In Microsoft Excel, or other text application, open the CSV file to view the export file.

  4. Edit the data in the CSV file to add, remove or modify any entries. For each row, set the action required to reflect the change:

    • V—No change was made to extract the record, but ignore the row when re-importing data.

    • C—You added a new object, as defined by the row.

    • U—You modified data. Changes are picked up when re-importing data.

    • D— Delete a record specified by name or key.

    Caution!

    Do not leave columns blank.

  5. Change the name. If you are creating objects, remove the Key and ID columns.

  6. Save the file.

  7. In the Run dialog box in Open, type cmd, then click OK.

    The Command window is displayed.

  8. On the command line, enter:
    cdpath to Import.bat .

  9. Enter the import command, using this format:

    export behavior filename.csv [options]

    See Behaviors.

    Any changes, additions or deletions are re-imported into Performance Scorecard.

  10. Launch Performance Scorecard to verify the changes.