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 appliance Administrator Console, https://appliance_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. |
◦ |
If one or more asset import operations are scheduled, the Import Assets list page appears, listing the import operations. To import assets from an CSV file, click Choose Action > New to start the Import Assets wizard. |
◦ |
If there are no scheduled asset imports on the appliance, the Import Assets wizard appears. |
5. |
Select this option to complete a one-time asset import from a CSV file. Then, click Browse or Choose File, then select the CSV file. | |||||||||||||||||||||
|
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. |
7. |
Scheduled asset imports only. On the Asset Import Selection Schedule page that appears, create a schedule for importing the CSV file. |
a. |
b. |
c. |
Run in combination with an event rather than on a specific date or at a specific time. | |||||||||||
Every n hours |
|||||||||||
Run daily at a specified time, or run on a designated day of the week at a specified time. | |||||||||||
Run on the nth of every month/specific month at HH:MM |
Run on the same day every month, or a specific month, at the specified time. | ||||||||||
Run on the nth weekday of every month/specific month at HH:MM |
Run on the specific weekday of every month, or a specific month, at the specified time. | ||||||||||
Run according to a custom schedule. Use standard 5-field cron format (extended cron format is not supported): Use the following when specifying values:
|
8. |
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. |
9. |
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=Name |
◦ |
Location=Location |
◦ |
Asset Status=Asset Status |
◦ |
License Count=License Count |
◦ |
Applies to Cataloged Software=Software Catalog |
◦ |
License Mode=Mode |
10. |
11. |
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. |
12. |
13. |
One-time imports only. Complete the following steps. |
a. |
b. |
14. |
Scheduled imports only. Complete one of the following steps: |
◦ |
Click Save to save your newly created scheduled import. The Import Assets list page appears, showing the scheduled import entry in the list. |
◦ |
Click Run Now to import assets from the CSV file, and to save your scheduled import settings. |
When the import is complete, the assets appear in the Assets list. If the titles of the software matched titles in the Software Catalog inventory, the assets are associated with the inventory items and you can view them on the Software Catalog Detail page for the items.
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 appliance Administrator Console, https://appliance_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. |
◦ |
If one or more asset import operations are scheduled, the Import Assets list page appears, listing the import operations. To import assets from an CSV file, click Choose Action > New to start the Import Assets wizard. |
◦ |
If there are no scheduled asset imports on the appliance, the Import Assets wizard appears. |
5. |
Select this option to complete a one-time asset import from a CSV file. Then, click Browse or Choose File, then select the CSV file. | |||||||||||||||||||||
|
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. |
7. |
Scheduled asset imports only. On the Asset Import Selection Schedule page that appears, create a schedule for importing the CSV file. |
a. |
b. |
c. |
Run in combination with an event rather than on a specific date or at a specific time. | |||||||||||
Every n hours |
|||||||||||
Run daily at a specified time, or run on a designated day of the week at a specified time. | |||||||||||
Run on the nth of every month/specific month at HH:MM |
Run on the same day every month, or a specific month, at the specified time. | ||||||||||
Run on the nth weekday of every month/specific month at HH:MM |
Run on the specific weekday of every month, or a specific month, at the specified time. | ||||||||||
Run according to a custom schedule. Use standard 5-field cron format (extended cron format is not supported): Use the following when specifying values:
|
8. |
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. |
9. |
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=Name |
◦ |
Location=Location |
◦ |
Asset Status=Asset Status |
◦ |
License Count=License Count |
◦ |
Applies to Cataloged Software=Software Catalog |
◦ |
License Mode=Mode |
10. |
11. |
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. |
12. |
13. |
One-time imports only. Complete the following steps. |
a. |
b. |
14. |
Scheduled imports only. Complete one of the following steps: |
◦ |
Click Save to save your newly created scheduled import. The Import Assets list page appears, showing the scheduled import entry in the list. |
◦ |
Click Run Now to import assets from the CSV file, and to save your scheduled import settings. |
When the import is complete, the assets appear in the Assets list. If the titles of the software matched titles in the Software Catalog inventory, the assets are associated with the inventory items and you can view them on the Software Catalog Detail page for the items.
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 appliance Administrator Console, https://appliance_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. |
◦ |
If one or more asset import operations are scheduled, the Import Assets list page appears, listing the import operations. To import assets from an CSV file, click Choose Action > New to start the Import Assets wizard. |
◦ |
If there are no scheduled asset imports on the appliance, the Import Assets wizard appears. |
5. |
Select this option to complete a one-time asset import from a CSV file. Then, click Browse or Choose File, then select the CSV file. | |||||||||||||||||||||
|
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. |
7. |
Scheduled asset imports only. On the Asset Import Selection Schedule page that appears, create a schedule for importing the CSV file. |
a. |
b. |
c. |
Run in combination with an event rather than on a specific date or at a specific time. | |||||||||||
Every n hours |
|||||||||||
Run daily at a specified time, or run on a designated day of the week at a specified time. | |||||||||||
Run on the nth of every month/specific month at HH:MM |
Run on the same day every month, or a specific month, at the specified time. | ||||||||||
Run on the nth weekday of every month/specific month at HH:MM |
Run on the specific weekday of every month, or a specific month, at the specified time. | ||||||||||
Run according to a custom schedule. Use standard 5-field cron format (extended cron format is not supported): Use the following when specifying values:
|
8. |
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. |
9. |
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=Name |
◦ |
Location=Location |
◦ |
Asset Status=Asset Status |
◦ |
License Count=License Count |
◦ |
Applies to Cataloged Software=Software Catalog |
◦ |
License Mode=Mode |
10. |
11. |
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. |
12. |
13. |
One-time imports only. Complete the following steps. |
a. |
b. |
14. |
Scheduled imports only. Complete one of the following steps: |
◦ |
Click Save to save your newly created scheduled import. The Import Assets list page appears, showing the scheduled import entry in the list. |
◦ |
Click Run Now to import assets from the CSV file, and to save your scheduled import settings. |
When the import is complete, the assets appear in the Assets list. If the titles of the software matched titles in the Software Catalog inventory, the assets are associated with the inventory items and you can view them on the Software Catalog Detail page for the items.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Termini di utilizzo Privacy Cookie Preference Center