Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: Import Opportunites Error

  1. #1
    cperko is offline Sugar Community Member
    Join Date
    Oct 2009
    Posts
    16

    Default Import Opportunites Error

    I am running 5.2.0j and when I try to import a .csv full of opportunity info, i get this error:

    NOTICE: [8] Undefined index: SugarFeed on line 5013 in file .../.../SugarBean.php

    It loads the first opportunity just fine, and dies after that.

    Any ideas?

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

    Default Re: Import Opportunites Error

    Can you post the first 3 lines of your source CSV?

    Problems like this are usually the result of improperly formatted data.
    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
    cperko is offline Sugar Community Member
    Join Date
    Oct 2009
    Posts
    16

    Default Re: Import Opportunites Error

    Account Name,State,JDID,opp_name,DO_NOT_USE
    Aiken,SC,sc_aiken,"Aiken, SC",Aiken
    Alamogordo,NM,nm_alamogordo,"Alamogordo, NM",Alamogordo

    The first line is the header.

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

    Default Re: Import Opportunites Error

    As suspected, you'll need to massage your data a bit.

    The data needs to be uniform, does it work if you import this:

    Code:
    Account Name,State,JDID,opp_name,DO_NOT_USE
    Aiken,SC,sc_aiken,Aiken SC,Aiken
    Alamogordo,NM,nm_alamogordo,Alamogordo NM,Alamogordo
    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
    cperko is offline Sugar Community Member
    Join Date
    Oct 2009
    Posts
    16

    Default Re: Import Opportunites Error

    I see what you mean by taking the quotes off. Sadly, this still did not work. I don't understand why it still only imports the first line of info (ie. creates an opportunity for Aiken).

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

    Default Re: Import Opportunites Error

    Does it still give you an error or does it fail silently?
    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)
    ______________________________________________

  7. #7
    cperko is offline Sugar Community Member
    Join Date
    Oct 2009
    Posts
    16

    Default Re: Import Opportunites Error

    Still giving the same error. I tried disabling the Sugar Feed, and it gives an error box with nothing in it

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

    Default Re: Import Opportunites Error

    I just tried the modified records on my test install of 5.2j and it worked fine.

    Have you customized the Opportunities module in any way?
    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)
    ______________________________________________

  9. #9
    cperko is offline Sugar Community Member
    Join Date
    Oct 2009
    Posts
    16

    Default Re: Import Opportunites Error

    I do have custom fields in the Opportunities module. I am new to this, and the person who set all of this up at my work has recently left for a couple of weeks (his wife just had twins!).

  10. #10
    cperko is offline Sugar Community Member
    Join Date
    Oct 2009
    Posts
    16

    Default Re: Import Opportunites Error

    Could there be something in the Sugar Feed that needs modifying?

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Probleme maj opportunités
    By drinkpet in forum Français
    Replies: 1
    Last Post: 2009-05-15, 01:53 PM
  2. Changing the EditView for Opportunites
    By moonliver in forum Developer Help
    Replies: 1
    Last Post: 2009-02-18, 03:39 PM
  3. Inserting Opportunites
    By emanresu in forum Help
    Replies: 1
    Last Post: 2007-05-01, 07:00 PM
  4. Restoring my Opportunites???
    By danccg in forum Help
    Replies: 4
    Last Post: 2007-04-10, 10:07 PM

Tags for this Thread

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
  •