Asset upload from CSV with department assignment

Asset upload from CSV with department assignment

 Greetings,

We're using ServiceDesk Plus 7.5.  When I upload non-IT assets via CSV upload, it works unless I try to assign the asset to a department (in this case, department "CWI").  Here's my data:

Product Type,Product Name,Asset Name,Department
Database,MSSQL,CWI_ECD_DB,CWI
Database,MSSQL,CWI_ECQ_DB,CWI


I am mapping column 4 to "Assigned Department".  When I import I get these errors:

RECORD : Database,MSSQL,CWI_ECD_DB,CWI
Error  : java.lang.NullPointerException

RECORD : Database,MSSQL,CWI_ECQ_DB,CWI
Error  : java.lang.NullPointerException

But, if I import without mapping column 4, the import succeeds.  In this case the name of the department is CWI; I have also tried filling the CSV with the primary key of the departmentdefinition field (e.g. 981) but I got the same error.

Has anyone gotten this (assignment of assets to departments during CSV upload) to work successfully?  An example CSV would be awesome.

                  New to ADSelfService Plus?