In the default asset csv download, there are some fields that do not map to the asset record in IIQ:Retired Date, where does this value in the csv file map? Is the ‘Last Inventory Date” field in the csv meant to map to the “Last Verification” field in the asset record? Finally, if I have a “OnOff” field in the asset record and want to add that field to the csv file import, what value to I provide in the csv? Are these yes/no or 0/1?

I hate to jump my own post, but I just noticed something else….The following fields are present in the IIQ asset record but not the csv template:Invoice NumberVendorInsurance Expiration DateInsurance InfoIs this intended? If so, why? I’m adding it to my csv template but wondering why it was omitted.

Question

Importing Assets - clarifying csv fields and custom field values

1 day ago
19 September 2023
1 reply
3 views

B

Userlevel 2

bbeaudette
Contributor
36 replies

In the default asset csv download, there are some fields that do not map to the asset record in IIQ:

Retired Date, where does this value in the csv file map?
Is the ‘Last Inventory Date” field in the csv meant to map to the “Last Verification” field in the asset record?
Finally, if I have a “OnOff” field in the asset record and want to add that field to the csv file import, what value to I provide in the csv? Are these yes/no or 0/1?

1 reply

B

Userlevel 2

bbeaudette
Author
Contributor
36 replies
1 day ago
19 September 2023

I hate to jump my own post, but I just noticed something else….The following fields are present in the IIQ asset record but not the csv template:

Invoice Number
Vendor
Insurance Expiration Date
Insurance Info

Is this intended? If so, why? I’m adding it to my csv template but wondering why it was omitted.

Reply

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded