You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.
View groupJoin the community to find out what other Atlassian users are discussing, debating and creating.
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
Hello,
I created an object type with Name, Type and SN attributes in Default/Text format. Used your example with copy/paste. And the import was successful.
Are you using text attributes? How many lines do you have in your file?
Cheers
Hakan
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Does your team need an operational reset? Ever feel like your team has too many meetings? Or don't know why you're even having a meeting? Ever get the dreaded Zoom fatigue? Are the r...
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.