Import Product Compliance Information into Your Database

Before you import a new file from an information source, you should delete all unnecessary entries from your database. This will help prevent duplicate entries from being created after the new file is imported. Also, if any of the primary keys in your database have changed since you last imported the file, a new import might create multiple entries for these products.

1. 

   Navigate to Product Compliance.

2.  Systems Management Server
      Site Database (site code - site name)
        Product Compliance

3. Right-click Product Compliance, and then click Import Product Compliance Data.
4. In the Import Product Compliance Data dialog box, enter the file name and path or the universal naming convention (UNC) path of the ASCII tab-delimited text file you want to import, and then click OK.

SMS compares the information in each line of the imported file against each line of your current product compliance database. Any items whose primary keys match an imported text line is replaced with new information. Any lines remaining after the comparison is made are appended to the compliance database text file.

Related Topics

View Product Compliance Results

Export Product Compliance Information from Your Database

Customize the Product Compliance Database

About Primary Keys

About Product Compliance Types and Levels

Product Compliance Overview