Importing a csv file

About this task

After you have created a csv file and an import template,you can use the import file function to add the data from your file into the Remote Control database. This is useful for adding numerous records of data to the database at once instead of having to add the items individually.

To add the data into the database, complete the following steps :

Procedure

  1. Click Admin > Import Data > Import File.
    The Import Existing Data screen is displayed
  2. Choose the appropriate method for selecting your csv file.
    1. Click Browse to navigate to and select the required csv file.
    2. Type in the path and name of the file that you wish to import

      for example : c:\myfiles\test.csv  on Windows™ systems

                         /myfiles/test.csv on UNIX®-based systems

  3. If your file has no header row, select an import template from the list that will be used to map your data to the relevant database table.
    Note: If your file has a header in it, it will match automatically with a defined template and therefore no selection is required.
  4. Click Submit
    The message File has been queued for processing is displayed

Results

Your data is added to the database. You can check this by displaying the relevant report for this data. For example if you have added user data, you can use the All users report to check that the data has been added correctly.