Results 1 to 5 of 5

Thread: Unable to import csv file records to leads

  1. #1
    TLGllc is offline Member
    Join Date
    Dec 2008
    Posts
    6

    Default Unable to import csv file records to leads

    When importing the csv file to leads, it only captures the first record.

    Total records being imported = 430

    Have tried to bread up into smaller quantities with no luck. I've previously had no issues importing this number of records or this format into contacts.

    Linux
    Sugar 5.2 - Community
    Apache 1.3.41 (Unix)
    PHP 5.1
    MySQL 5.0.67

    Any insights or assistance is greatly appreciated.

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

    Default Re: Unable to import csv file records to leads

    See if the suggestions in this thread help: http://www.sugarcrm.com/forums/showthread.php?t=43295
    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
    TLGllc is offline Member
    Join Date
    Dec 2008
    Posts
    6

    Default Re: Unable to import csv file records to leads

    No luck still...the odd thing is it gets the first record or row on the csv file correctly matched with fields, then just ends there!?

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

    Default Re: Unable to import csv file records to leads

    Did you try the sample records in my post in the other thread?

    If so, try adding a third record to that sample data. I remember there was a bug in recent versions that caused it to omit the first record for some reason. That's how I came about making that test data set in the first place. I haven't tried it recently, but I thought I had seen a note in bug tracker indicating the problem had been corrected, but I could be mistaken.
    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)
    ______________________________________________

  5. #5
    TLGllc is offline Member
    Join Date
    Dec 2008
    Posts
    6

    Default Re: Unable to import csv file records to leads

    I did try this, and was able to get it to work; however, I got a " before the beginning of the name.

    My csv file is in cells as it was with the last one I imported successfully. How do I get it to a comma state? What happens when I have voids in fields?

    I really appreciate your help with this.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 2008-10-13, 05:55 PM
  2. Replies: 7
    Last Post: 2008-04-21, 11:44 PM
  3. What's format of import leads file ?
    By tinatran in forum General Discussion
    Replies: 2
    Last Post: 2007-12-15, 01:09 AM
  4. CSV File Import of Leads
    By blkr00t in forum Installation and Upgrade Help
    Replies: 2
    Last Post: 2007-09-14, 12:56 PM
  5. Replies: 1
    Last Post: 2005-08-06, 06:38 PM

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
  •