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.

@bbeaudette Thank you for submitting your question to our Community. 

1. The retire date is in column “O” of the CSV; as for the field it shows up, it is a custom field you need to create.
2. Yes.
3. You will add true/false to that field.
4. The CSV template doesn’t require everything that shows on the asset details page. Additionally, that information you want to bring into iiQ via the CSV, you can just create the column and map it to that field. Or, if we don’t have it, you can create a custom field and map it to that field.

I hope this helps 

Can the csv import update fields such as “Expected Lifetime (years)”? Is there any way to mass update those type of fields?

@NSchroeder 2202fcb arrowhead Manually enter your data (all your fields) for one asset. Export that asset to a csv. The csv should have all fields. If so, delete your asset. Then, upload your csv to recreate the asset. Confirm which fields were populated. If it works, you’ve just created a csv template to mass upload/update. I recall this process worked for me in order to add additional fields that are not included in the vanilla csv template.

@NSchroeder 2202fcb arrowhead Great question! If you already have the Custom Field created in iiQ, you can create a column that matches that name and bulk update via CSV. Make sure you map those fields when checking the import. I hope this helps 

@Kathryn Carter @bbeaudette The export process doesn’t work because the depreciation information fields are not columns that are available to export. For the same reason, the csv import doesn’t work for depreciation fields because the system isn’t able to map them. It should work, but for some reason the system doesn’t let you map those fields.

Confirmed @NSchroeder 2202fcb arrowhead’s issue. Those new asset fields are not ex/importable. Sure looks like a bug. Did you submit a support ticket to IIQ? That looks like next steps.

@NSchroeder 2202fcb arrowhead Confirmed next steps from @bbeaudette!

What is the custom field type and the name of the custom field? There are a few that are funky that I can help dig a little deeper. 

@Kathryn Carter The ones I’m asking about are not custom fields, they are iiQ fields. If you try editing an asset and look for the depreciation area, it’s those fields that I’m inquiring about.

I reached out to our product owner, and it looks like these fields are not importable or exportable now. However, that would be a great enhancement for these depreciation fields. You can add those here: https://community.incidentiq.com/ideas

@Kathryn Carter I did create an idea topic, but I’ve been posting in each discussion that is related to this issue so that we can get more eyes and upvotes on improving the fuctionality of the feature. Here is the link to my idea thread. 

What format does “Last Inventory Date” need to be in? I’ve tried a number of different date formats and can’t get it to update the Last Verification field.

​@SMaza_ADM 1307f1d tahomasd I have not been able to find documentation with that specific date format but as far as I am aware it should be month/date/4 digit year. Is this how all your dates are populating upon import? 

yes, that is the format I’ve used, and the verification field does not update. 

​@smaza This might be a silly question, but have you mapped the field correctly? As for matching the names of those 2 information to one? 

Yep! Mapped correctly!

​@smaza Thank you for that screenshot. The Last Inventory Date will NOT automatically adjust the Last Verification Date since that data is typically created internally within iiQ. This would need to be an enhancement request, however, I found another similar to your request to update the the Last Verification Date via CSV import: