• |
Creates the asset: If the Primary Key value does not match an existing value, the asset is created. |
• |
Updates the asset: If the Primary Key value matches an existing value, the asset information is updated. |
• |
Flags the asset as a duplicate: If multiple records for the Asset Type match the value of the CSV field chosen as the Primary Key, OR if multiple records match the associated asset, the asset is flagged as a duplicate. Duplicate records are not imported. |
You can import asset data, such as software license data, using CSV (comma separated value) files.
Verify that asset data is appropriate and formatted properly before importing it.
1. |
3. |
5. |
You can import license data from prepared CSV files.
If you want to assign the imported assets to an Asset Subtype, add the subtype before you import the assets. See Add Asset Subtypes and select Device Detail page preferences.
4. |
a. |
Log in to the KACE SMA Administrator Console, http://KACE_SMA_hostname/admin. Or, if the Show organization menu in admin header option is enabled in the appliance General Settings, select an organization in the drop-down list in the top-right corner of the page next to the login information. |
b. |
5. |
6. |
If the CSV file contains a header row, as it does in this example, select the File Header Row check box, then click Next. |
a. |
b. |
NOTE: In this example, the Asset Subtype, Productivity, has been added to the License Asset Type. The Subtype drop-down list is empty if you have not added subtypes for the License Asset Type. During import, all assets are assigned to the selected subtype. |
c. |
8. |
In the CSV Fields drop-down list, select the fields that correspond to the appliance Required Standard Fields and Required Asset Fields. The mapping of these fields depends on the contents of your CSV file and the Asset Type. For the example in this section, use the following values: |
◦ |
Asset Name=Asset Name |
◦ |
License Count=License Count |
◦ |
Applies to Cataloged Software=Software Catalog |
◦ |
License Mode=Mode |
9. |
10. |
If the assets you are importing use barcodes, in the Barcode Fields area, indicate how you want to import the barcodes. |
The field in the CSV file that contains the barcode format. For example, UPC-A, Code 11, or UPC-E. |
11. |
12. |
13. |
You can import asset data, such as software license data, using CSV (comma separated value) files.
Verify that asset data is appropriate and formatted properly before importing it.
1. |
3. |
5. |
You can import license data from prepared CSV files.
If you want to assign the imported assets to an Asset Subtype, add the subtype before you import the assets. See Add Asset Subtypes and select Device Detail page preferences.
4. |
a. |
Log in to the KACE SMA Administrator Console, http://KACE_SMA_hostname/admin. Or, if the Show organization menu in admin header option is enabled in the appliance General Settings, select an organization in the drop-down list in the top-right corner of the page next to the login information. |
b. |
5. |
6. |
If the CSV file contains a header row, as it does in this example, select the File Header Row check box, then click Next. |
a. |
b. |
NOTE: In this example, the Asset Subtype, Productivity, has been added to the License Asset Type. The Subtype drop-down list is empty if you have not added subtypes for the License Asset Type. During import, all assets are assigned to the selected subtype. |
c. |
8. |
In the CSV Fields drop-down list, select the fields that correspond to the appliance Required Standard Fields and Required Asset Fields. The mapping of these fields depends on the contents of your CSV file and the Asset Type. For the example in this section, use the following values: |
◦ |
Asset Name=Asset Name |
◦ |
License Count=License Count |
◦ |
Applies to Cataloged Software=Software Catalog |
◦ |
License Mode=Mode |
9. |
10. |
If the assets you are importing use barcodes, in the Barcode Fields area, indicate how you want to import the barcodes. |
The field in the CSV file that contains the barcode format. For example, UPC-A, Code 11, or UPC-E. |
11. |
12. |
13. |
You can import asset data, such as software license data, using CSV (comma separated value) files.
Verify that asset data is appropriate and formatted properly before importing it.
1. |
3. |
5. |
You can import license data from prepared CSV files.
If you want to assign the imported assets to an Asset Subtype, add the subtype before you import the assets. See Add Asset Subtypes and select Device Detail page preferences.
4. |
a. |
Log in to the KACE SMA Administrator Console, http://KACE_SMA_hostname/admin. Or, if the Show organization menu in admin header option is enabled in the appliance General Settings, select an organization in the drop-down list in the top-right corner of the page next to the login information. |
b. |
5. |
6. |
If the CSV file contains a header row, as it does in this example, select the File Header Row check box, then click Next. |
a. |
b. |
NOTE: In this example, the Asset Subtype, Productivity, has been added to the License Asset Type. The Subtype drop-down list is empty if you have not added subtypes for the License Asset Type. During import, all assets are assigned to the selected subtype. |
c. |
8. |
In the CSV Fields drop-down list, select the fields that correspond to the appliance Required Standard Fields and Required Asset Fields. The mapping of these fields depends on the contents of your CSV file and the Asset Type. For the example in this section, use the following values: |
◦ |
Asset Name=Asset Name |
◦ |
License Count=License Count |
◦ |
Applies to Cataloged Software=Software Catalog |
◦ |
License Mode=Mode |
9. |
10. |
If the assets you are importing use barcodes, in the Barcode Fields area, indicate how you want to import the barcodes. |
The field in the CSV file that contains the barcode format. For example, UPC-A, Code 11, or UPC-E. |
11. |
12. |
13. |
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité