Results 1 to 4 of 4

Thread: import contacts not working in 5.0.0b

  1. #1
    agcilantro is offline Sugar Community Member
    Join Date
    Nov 2007
    Posts
    45

    Default import contacts not working in 5.0.0b

    I am using 5.0.0b community on a shared server with 1and1. I can import accounts (up to 300 at a time) from a csv file, but the import module for contacts isn't working at all with more than 10 (!) contacts at a time.
    When I go back to a version 4.5 there is no problem with either module.

    MySql is 5.0, php is 5.2.4

    Thanks for any help on this.

  2. #2
    Angel's Avatar
    Angel is offline Sugar Community Member
    Join Date
    Jul 2005
    Location
    Los Angeles
    Posts
    4,813

    Default Re: import contacts not working in 5.0.0b

    I haven't tried this myself, but others have reported a bug in the import process related to having quotes in the account name of a record to be imported.

    Make sure that the company/account name on the contacts you are trying to import do not include a quote symbol.
    Regards,

    Angel Magaņa
    Co-Author: Implementing SugarCRM 5.x (Packt Publishing -- Sept. 2010)
    Blog: http://cheleguanaco.blogspot.com.
    Twitter: @cheleguanaco.

    ________
    | Projects: |_____________________________________
    |
    | CandyWrapper (.NET Wrapper for SugarCRM SOAP API). Source now available on GitHub!
    | GoldMine to SugarCRM Express Conversion. Latest: 1.0.1.7 (Nov. 3, 2009)
    | CRM SkyDialer (Skype Integration). Latest: 1.0.2 (Feb. 17, 2010)
    | Round Robin Leads Assignment
    | Phone Number Formatter
    | CaseTwit (Twitter Integration)
    ______________________________________________

  3. #3
    agcilantro is offline Sugar Community Member
    Join Date
    Nov 2007
    Posts
    45

    Default Re: import contacts not working in 5.0.0b

    Quote Originally Posted by Angel
    I haven't tried this myself, but others have reported a bug in the import process related to having quotes in the account name of a record to be imported.

    Make sure that the company/account name on the contacts you are trying to import do not include a quote symbol.

    I am doing a csv export from Cardscan, using the excel export template for cvs. I don't know if there are quotes in the flile, I will try to open it in a text editor to see.

    So, for 5.0.0b I can't merge duplicate accounts, can't delete accounts from the front end, and can't import contacts to associate with the accounts.

  4. #4
    boseng is offline Member
    Join Date
    Jan 2008
    Posts
    6

    Default Re: import contacts not working in 5.0.0b

    a quick fix we did:
    take the file (.csv) that you're trying to import into sugar 5 and open it up in excel
    find the COLUMN that lists the account names for the contacts that you're trying to import.
    highlight the whole column (only the accounts name column should be highlighted)
    hit ctrl + f to do a find

    search for '
    and search for "

    do a replace on all the ones you find (you can leave the replace blank and it will replace any ' or " with no space (it will remove them).

    break your file up into chunks of 300 - 500 and try the import again.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Account import to leads or contacts?
    By agcilantro in forum Help
    Replies: 10
    Last Post: 2008-03-04, 10:00 AM
  2. link contacts with custom modules at import
    By juancarlos.delrio in forum Developer Help
    Replies: 0
    Last Post: 2007-11-13, 01:15 AM
  3. Contacts disapear after import
    By patwarn in forum Help
    Replies: 1
    Last Post: 2007-10-16, 06:48 PM
  4. Import a single file into Both Contacts AND Accounts
    By tjadams in forum Feature Requests
    Replies: 0
    Last Post: 2006-05-22, 03:15 PM
  5. Import Individual Contacts problem
    By garfield in forum Help
    Replies: 0
    Last Post: 2005-08-08, 06:33 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •