Skip navigation
DandyDahlia
DandyDahlia
119 posts
Apr 12, 2012
Currently Being Moderated

Updating Customers (import) errors??

Jul 31, 2012 8:01 PM

Tags: #support #bug_report #contacts #business_catalyst #crm #business_catalyst_error

Hi,

 

We have done this before with no dramas but today on updating our contacts in mass (5975)  it's just not working.

 

It keeps coming up saying "

 

Error
  ERROR: [ The username is already in use. (123gifts).]. Import process failed on record: [2] Please ensure 1) mandatory columns are present, 2) all products have Product Codes defined, which should be unique (if importing products) 

 

But this is the username they already have. (They have the same email too). We have only updated other fields. So I'm 100% confident our data is fine. Username is a mandatory field too so can't be left blank.

 

 

We have followed the instructions BC has:

Mandatory Fields that must be imported to avoid wiping out an existing value:

  • Title
  • First name
  • Last name
  • DOB
  • Username
  • Password (ignore as doesn't update anymore)
  • Email
  • Customer Type
  • Lead Source Type
  • Industry Type
  • Rating Type

 

 

Has anyone seen this before or know how to fix it?

 

Thank you

446 Views   7 Replies   Latest reply: Steve @ Lightplay, Aug 29, 2012 12:57 AM
 
Replies
  • DandyDahlia
    119 posts
    Apr 12, 2012
    Currently Being Moderated
    1. DandyDahlia,
    Jul 31, 2012 8:09 PM   in reply to DandyDahlia
    Report

    Adding on to the above - I just tried deleting the username column as a test on some lines as the problem lies with the username coloumn but it deletes the username that's already on the card so wont work.

     
    |
    Mark as:
  • DandyDahlia
    119 posts
    Apr 12, 2012
    Currently Being Moderated
    2. DandyDahlia,
    Jul 31, 2012 8:27 PM   in reply to DandyDahlia
    Report

    Feel like i'm talking to myself... but if anyone else has this issue, the only way to fix it is upload the contacts with no username then reupload with with a username. It's riskier but will work.

     

    I've lodged a bug request too.

     
    |
    Mark as:
  • Steve @ Lightplay
    Currently Being Moderated
    3. Steve @ Lightplay,
    Aug 28, 2012 10:50 PM   in reply to DandyDahlia
    Report

    Hey DD, I've been having this problem also, it was supposed to be fixed on the latest update but I believe it's still happening.

    See http://forums.adobe.com/message/4652837#4652837

     
    |
    Mark as:
  • DandyDahlia
    119 posts
    Apr 12, 2012
    Currently Being Moderated
    4. DandyDahlia,
    Aug 28, 2012 11:34 PM   in reply to Steve @ Lightplay
    Report

    Hi Steve,

    I got some long winded reply from BC that I wasn't confident doing (see italics below)

    Haven't needed to upload again since but will in the next month - so hopefully will be right by then.

     

    The only way I got it was upload with no username then reload with username. It did work but I hated doing it as a bit risky. But it did work if you are desperate.

     

    DD

     

     

    What I've mentioned in my message when I first contacted you was to use an ID for each customer and then change what fields you need to change because otherwise the import will fail with the same error you saw.

    So this time I did a short recording showing that the import / update process functions correctly and that you need to use the ID's in order to have a successful import / update process.

    You can see the recording here: http://screencasteu.worldsecuresystems.com/Cristi/2012-08-08_1318.swf

    (without the 1 in the ID field for the customer it will return the same error)

     

    ** ie create ID's but when I exported the records there were NO Id's so if i created some I was worried it would relabel all the cards I had = a year worth of work data could be compromised **

     
    |
    Mark as:
  • Steve @ Lightplay
    Currently Being Moderated
    5. Steve @ Lightplay,
    Aug 28, 2012 11:50 PM   in reply to DandyDahlia
    Report

    Hey DD,

     

    Thanks for your reply, we are using the ID field, this isn't the problem though. It's the dreaded username bug ( Reported Bug # 3313655 ).

    I like your creative idea of uploading without usernames and then again with usernames but these are drastic measures and I'm hoping BC will fix the problem before I have to use your method, but if we get desperate we might have to resort to this.

     

    Cheers,

     

    Steve

     
    |
    Mark as:
  • Liam Dilley
    4,232 posts
    Feb 28, 2012
    Currently Being Moderated
    6. Liam Dilley,
    Aug 29, 2012 12:36 AM   in reply to Steve @ Lightplay
    Report

    Hi Steve, I see BC got back to you in your other thread and Cristian mentioned you had duplicate contacts in your spreadsheet.

     
    |
    Mark as:
  • Steve @ Lightplay
    Currently Being Moderated
    7. Steve @ Lightplay,
    Aug 29, 2012 12:57 AM   in reply to Liam Dilley
    Report

    Hi Liam, yes there were duplicates, support kindly removed them and were able to upload successfully, however when I tried with the same file but also adding to the Secure Zone it failed at the same point, I checked the import and the system and there are no duplicates of this username. The plot thickens!

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points