AnsweredAssumed Answered

Import not working

Question asked by paul.squires@uk.ibm.com on Jan 8, 2016
Latest reply on Jan 11, 2016 by paul.squires@uk.ibm.com

Hi all,

 

Question on Sugar Community 6.5.22.

 

I have imported a CSV with many fields and many rows. It imported fine.

 

That CSV included three rows which - for the sake of this post - looked like this:

 

Company ID: 1

Company name: Acme Sprockets

Size of company data: (blank)

 

now, I want to fill in the "Size of company data" field to all of the companies. So, I set up a CSV which just contained these three rows and looked like this:

 

Company ID: 1

Company name: Acme Sprockets

Size of company data: 12.34

 

On the "Check for duplicates" page, the only available field is "Company name". If I move this to the "Fields to check" box then Sugar fails to import the records as it believes them to be duplicates. However, if I don't move it and leave it in "Available fields" then it creates three new records.

 

So, I want to just append the existing records with data but can't work out how to.

 

Where am I going wrong?

 

Thanks in advance,

Paul

Outcomes