Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Importing data to Insight: no label column

Sergei Gridnevskii
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 15, 2021

I have a CSV that does not have a column Name (which is a label for an object type). However I have a column Email which is unique for this object type. Is it possible to map CSV records to objects using Email instead of Name? Also there can be several objects with same Name, I have no idea how would import behave in such a case.

 

When I run the wizard, it automatically adds Name column to import configuration even if it does not find it in CSV. Moreover I cannot delete Name from import configuration.

 

The only possible workaround would be to export data from Insight, map Name with Email for new import and proceed with import. But it is not practical. Also I do not want to make Email the label column for this object type.

 

Do you have any suggestions how to perform import from CSV without Name column?

2 answers

1 vote
Sergei Gridnevskii
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 16, 2021

I found solution, thanks Mayur.

I have to add the check box to Email in first column and remove checkbox from Name, then delete Name row.

Untitled.png

Mayur Jadhav
Community Champion
September 16, 2021

Hope my answer helps you to understand.

If yes please hit the accept button.

0 votes
Mayur Jadhav
Community Champion
September 16, 2021

Hi @Sergei Gridnevskii 

As per your discription I can understand that you want all the object's map to email address instead of Name right??

Then you need to the objecType attributes section then rename the name to email. 

Then try to mapping the column or attributes while importing.

 

Hope this will help you.

Thanks,

Mayur

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events