Systems Management

Cvs has to have all the fields and match exactly. Make sure everything cn be mapped. 

If you follow this guide exactly it's a simple process. 

http://www.kace.com/support/resources/kb/article/how-to-import-computer-inventory-data-into-computer-asset-records

I get a monthly sheet from our inventory control department. The screenshot below is a little example of what they send. Some other fields that are included are department name, custodian, PO number.

I modified the computer asset type to match the fields on the csv. 

I then import the csv Asset>Asset Import>Choose File(browse to csv). This will bring up this next screenshot. You will need to match the csv fileds with the asset fields on your csv by clicking the dropdown.  At the top I select "Serial ID" as the primary so that it will match in the Kace inventory. Could be different in your environment.

After that click the "preview" button. This will show all additions, modifications, and records that do not import (in my case machines without a serial ID on the csv since there is no PK). After you import you should now see the info in the computer inventory.

One other thing my monthly list ranges from about 20,000 to about 30,000 records. I have to break this up into groups of 10,000 for the import. Maybe I'm just impatient, but it seems to go a lot quicker this way.