Hi there,
I'm having trouble importing data for insight using csv file import.
I'm either getting this error:
or this one:
I followed exactly what's in the documentation.
Could you please let me know what's wrong?
It seems like a straightforward process but unfortunately is not!
This is my sample file format:
Key,Name,Type,SN
, Test import, test, Furniture
Thanks,
Pegi
I had spent an hour with various combinations, but still getting the missing attribute: Key error.
Tried with :
a. no key for the new records that supposed to be created by insight
b.moved the key column to the end in attribute configuration as Name (or Label) field attribute is unique (I made it unique in configuration) and also in the csv file to match the columns one to one between the configuration and the file header.
c. used the attribute IDs in the header instead of name.
d. kept only four records to import for a sample.
So frustrating to see such a simple import process is not handled by an add on and also the import documentation and trouble shooting page is not helpful.
If anyone successfully imported at least once can help to solve the issue. Thanks.
Nailed it. Uploaded some records successfully though it failed on me on reference objects a few times. If anyone is having similar issue, I can help. Thanks.
I'm having similar issues. I can't get it to create new Objects. How did you resolve?
Name:Key
39 - Sales Management:
Request failed for storeObject() with tenantId dbf8b6d5e45f1646e3aef3ae88eaf44fc5! Status: 400, Message: {"errorMessages":[],"errors":{}}
Name:Department Number:Key
Sales - Management:39:
Request failed for storeObject() with tenantId dbf8b6d5e45f1646e3aef3ae88eaf44fc5! Status: 400, Message: {"errorMessages":[],"errors":{"rlabs-insight-attribute-69":"At least one value must be set"}}
Name:Department Number:Key
Sales Management:39:1234
Cannot update a nonexistent object having key 1234
Tim,
The import works as both create and update. If the key value is not provided, it creates a record and if we have a key and if the key exists, then it updates the record using the key.
For every asset, Insight can create it's own key and you can keep the id for the 'Department Number' column (as referred in your message) as a separate column as Department ID and use '39' as the value to refer the record in this case.
So, at the end, Key is the Asset Key as referred by Insight. In your case, it is trying to update the record with the key of 39, but it could not find.
Also, save the file as csv and not as csv with utf-8.
Guhan,
The first two examples I gave have a key column, but no key values in an attempt to create new objects. The issue was CSV UTF-8 as you mentioned. Once I saved the CSV w/o UTF-8 the objects created on import.
According to the documentation, MS Excel is not supported for editing CSVs, but appears to work for CSV saved w/o UTF-8.
Thanks for your help!
-tim
Recommended Learning For You
Level up your skills with Atlassian learning
Redesign your workweek
Configure your calendar to prioritize high-impact work and goals. You'll learn how to set daily priorities, prioritize essential meetings, and schedule focus time.
How to run effective meetings
Lead efficient meetings that have clear goals, keep your attendees actively engaged, and use the Atlassian Playbook to improve meeting success.
How to build strategic guidance
Build a high-performing, effective team by providing clarity, defining success, and making it clear who will benefit from your efforts — a technique we call strategic guidance.