Importing data

Once your data is formatted on the Excel 2003 XML spreadsheet, you can import it into the AlarmPoint database using the web interface.

To import a spreadsheet:
  1. On the Import Data page, enter the following information into the form:
Import Data page details

Detail

Description

Import

Name and location of the Excel 2003 XML spreadsheet you want to import. Type a path and a file name into the field, or click Browse to locate a spreadsheet file on your system.

Default Site

Site to which all Users will be assigned, unless otherwise specified in the spreadsheet.

Default Role

Role to which all Users will be assigned, unless otherwise specified in the spreadsheet.

Default LDAP Domain LDAP domain to which all Users will be assigned (this setting is available only if there is at least one LDAP domain defined).

Default Time Zone

Time Zone to which all Groups will be assigned, unless otherwise specified in the spreadsheet.

Default Observer Role

Observer Role which will be assigned to all Groups, unless otherwise specified in the spreadsheet.

  1. Click Upload to import the spreadsheet data into AlarmPoint.
    1. AlarmPoint attempts to upload the data and import it into the database. If the import process is successful, AlarmPoint displays a success message at the top of the Import Data page.
    2. If the import process failed for any reason, AlarmPoint displays a failure message.
    3. You can click the Download Results button to generate and view an Excel 2003 spreadsheet with more information about the errors.