Solved

Importing Assets - clarifying csv fields and custom field values

  • 19 September 2023
  • 11 replies
  • 176 views
B
Rank
Userlevel 3
Badge +3

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

  1. Retired Date, where does this value in the csv file map?
  2. Is the ‘Last Inventory Date” field in the csv meant to map to the “Last Verification” field in the asset record?

  3. 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?

 

icon

Best answer by NSchroeder 2202fcb arrowhead 18 June 2024, 17:35

View original
Brandon Beaudette

11 replies

B
Rank
Userlevel 3
Badge +3

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.

Brandon Beaudette
Kathryn Carter
Userlevel 7
Badge +13

@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 😄

Kathryn Carter - Community Moderator
N
Badge

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

B
Rank
Userlevel 3
Badge +3

@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.

Brandon Beaudette
Kathryn Carter
Userlevel 7
Badge +13

@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 - Community Moderator
N
Badge

@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.

B
Rank
Userlevel 3
Badge +3

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.

Brandon Beaudette
Kathryn Carter
Userlevel 7
Badge +13

@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 - Community Moderator
N
Badge

@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.

Kathryn Carter
Userlevel 7
Badge +13

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 - Community Moderator
N
Badge

@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. 

 

Reply


Terms & ConditionsCookie settings
Incident IQ logo

Incident IQ is a service management platform built for K-12 school districts, featuring asset management, help ticketing, facilities maintenance solutions, and more.

Corporate Headquarters:
750 Glenwood Ave SE, Suite 320
Atlanta, GA 30316