Results 1 to 5 of 5

Thread: Importing leads

  1. #1
    jthorn is offline Member
    Join Date
    Feb 2006
    Posts
    6

    Thumbs down Importing leads

    Hi,

    I am getting the following error when I try to import leads

    SQL Error : [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near ','..

    any help will be appreciated


    Thanks

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

    Default Re: Importing leads

    Errors at import time are usually the result of a problem with the formatting of the source data file. See this post on my blog for some more insight on that point: http://cheleguanaco.blogspot.com/200...-problems.html

    Try importing a simpler form of the data to see if it makes a difference.
    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
    jthorn is offline Member
    Join Date
    Feb 2006
    Posts
    6

    Default Re: Importing leads

    Thanks Angel,

    I looked at your blog and I did tried by using the simpler form but still get the same error, I don't think the issue is with format

    Thanks

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

    Default Re: Importing leads

    Hmm...

    Can you post the simpler version that gave you trouble?
    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
    jthorn is offline Member
    Join Date
    Feb 2006
    Posts
    6

    Default Re: Importing leads

    See the attached file


    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 2009-12-02, 08:49 PM
  2. Importing leads
    By DutchDude in forum General Discussion
    Replies: 3
    Last Post: 2009-05-05, 10:28 AM
  3. Importing Leads stops at 220 leads
    By gerald29 in forum Help
    Replies: 0
    Last Post: 2008-04-05, 05:01 AM
  4. Importing Leads v4.5
    By dbcrazy in forum Help
    Replies: 0
    Last Post: 2008-03-07, 07:56 PM
  5. CSV not importing to Leads
    By Braddock in forum Help
    Replies: 0
    Last Post: 2007-10-03, 04:52 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
  •