Importing Data Points for a Rating Table

Import data for a points table from an external csv file.

Caution

The imported data will replace all the existing data in the points table. You cannot reverse this process, and the previous points table will NOT be available as a retired revision. Consider exporting the original table to a spreadsheet as a backup before you import the new points table.

To import data points for a rating table:

  1. In the Rating Tables module, select the rating table for which you want to import data.
  2. On the Points tab, click Import to open the Import Points tool.
  3. Select the import file and specify which columns contain the data to import. The import tool imports the data and displays it in the Preview Points screen.
  4. Check the imported data. You can Add, Delete or Modify the imported points in the preview screen.
  5. Click Save to import the data.

Import file format

The import file must be a csv (comma separated values) file with the data for importing in two columns. The import tool will ignore a single text header row if one is present, but will import any other text with an error. You can remove this error row manually during the import process.