Import CIs from a Delimited File
    • 16 Jun 2022
    • PDF

    Import CIs from a Delimited File

    • PDF

    Article summary

    This page allows you to easily import a list of CIs from a .csv file. You can also update existing CIs by reimporting them with updated information.

    ImportCIsfilesImportCIsImportCIs.jpg

    To import a list of CIs:

    1. Create a .csv file with the CIs you would like to import. You can easily create a .csv file using Microsoft Excel (save as CSV). Columns in the .csv are fields to import for each CI, and rows in the .csv are the individual CIs. See the image below for an example.
      A .csv file ready for import into SysAid
      ImportCIsfilesCIscsvCIscsv.jpg
    2. Select the .csv you've created by clicking Choose File.
    3. If your .csv has column headers (like in the picture above) select the Do not import the head line check box.
    4. Select the field delimiter. If you create the .csv in Excel, this is a comma (,) by default.
    5. Select the number of fields to import. The number of fields is equal to the number of columns in your .csv file.
    6. Choose a column as the key field for the import. The importance of the key field is for checking to see if the CIs already exists in your system. If a CI already exists, SysAid updates it instead of creating a new CI. Please make sure to use a field with unique values as the key. If you use a field with values that frequently appear, you will simply overwrite one of your CIs multiple times.
    7. Choose the Default CI Type. Any new CI you import that doesn't have a specified type is created with the type you specify here.
    8. Select each field you are importing in the Field content column. Each field corresponds to one column in the .csv file. The Field content in Position 1 is the left-most column in your .csv.
    9. If you select any date fields, specify the date format in the Format column. You can use either European (dd/mm/yyyy) or US date formats (mm/dd/yyyy).
    10. Click Submit to import your CIs.

    You can verify that your CIs were correctly imported and/or updated from Assets > CMDB > CI List.

    Automatically sync SysAid with a .csv file

    You can set SysAid to automatically sync its CI information with a .csv file. This means that at the intervals you define, SysAid checks the .csv file for changes. If any changes have been made, SysAid imports the file and overrides the existing CI information with the updated information in the .csv file.

    On-Premise users can accomplish this by pointing to the file location of the .csv file or by connecting to the .csv file via the RDS. Cloud users can perform this sync only by connecting to the .csv file via the RDS. The RDS scans the folder and uploads the copy of the .csv file to the server every 10 minutes. The server processes the updated information based on the selected schedule time.

    To automatically sync your CIs with a .csv file via the SysAid server

    1. Check the Schedule box.
    2. In the Start Time field, select a date and time to begin syncing with the file.
    3. From the Rerun Every drop-down list, select if the sync should occur every hour, day, or week.
    4. Select the File path option button.
    5. In the File Path field, enter the file path location of the .csv file.
    6. Click Set scheduled import.

    To automatically sync your CIs with a .csv file via the RDS

    1. Check the Schedule box.
    2. In the Start Time field, select a date and time to begin syncing with the file.
    3. From the Rerun Every drop-down list, select if the sync should occur every hour, day, or week.
    4. Select the File path option button.
    5. Click Set scheduled import.
    6. On your system, add a copy of the .csv file to the RDS folder under WEB-INF/csvCiFiles.
      Important

      Do not attempt to permanently store the original .csv file in this location as the RDS uploads it to the server and removes it from this location.

    7. Access the RDS and open the DiscoveryService.properties file.
    8. Find the "csv.ci.import" parameter and set its value to "true". If the parameter does not exist in the file, add it manually.
    9. Save the file.
    10. Restart the RDS service.

    ImportSysAidUsersfilesScheduleSync1.jpg