Results 1 to 4 of 4

Thread: Many to Many confusion

  1. #1
    twick100 is offline Sugar Community Member
    Join Date
    Jun 2011
    Posts
    30

    Default Many to Many confusion

    Ok, this is kind of driving me crazy. I really need to create the Many to Many relationship on import.

    I can do this fine with a One to Many but when I try to import Many to Many there is no field to map to (On the import wizard), to relate to the other Module I am trying to relate to.
    NOTE: I have the subpanels showing for moth modules but no way to import the relationships. (Doing this manually would take a very long time)
    If there is a step by step tutorial for this, that would be awesome but so far in google and forum search I am coming up short.

    I hope that makes sense...
    Last edited by twick100; 2011-07-26 at 01:35 AM.

  2. #2
    andopes's Avatar
    andopes is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Jul 2006
    Location
    São Paulo - Brazil
    Posts
    8,335

    Default Re: Many to Many confusion

    Sugar is not able to import a Many to Many relationship.
    You only can import One to Many relationship, specifically the weak entity ("Many" side of relationship).
    In the weak module there is a relate button, so you can select it.
    In the strong module ("One" side of relationship) there is a subpanel instead, so no way to select a single entry to import.

    Regards
    André Lopes
    DevToolKit / Project of the Month - June 2009
    Lampada Global Services- Open Source Solutions
    Avenida Ipiranga, 318
    Bloco B - CJ 1602
    São Paulo, SP 01046-010
    Brazil
    Office: +55 11 3237-3110
    Mobile: +55 11 7636-5859
    e-mail: andre@lampadaglobal.com

    Lampada Global delivers offshore software development and support services to customers around the world.
    Lampada is proud to be a SugarCRM Gold Partner, revolutionizing Customer Relationship Management.

    I DO NOT answer questions through PM and Email. If you need some help post your question into SugarForum.

  3. #3
    twick100 is offline Sugar Community Member
    Join Date
    Jun 2011
    Posts
    30

    Default Re: Many to Many confusion

    Thanks for the reply. That news is unfortunate. Now a lot of manual work is going to be required

  4. #4
    rafael.q.g@hotmail.com's Avatar
    rafael.q.g@hotmail.com is offline Sugar Community Member
    Join Date
    Jun 2011
    Location
    Florianópolis - Brazil
    Posts
    782

    Default Re: Many to Many confusion

    Once I did a complex importation into sugar, that of course include many to many situations, and I use the tool http://www.jitterbit.com/, it is very powerful and friendly use tool, maybe ity helps you.
    Rafael Queiroz Gonçalves
    Advanced OMG UML Certified Professional
    Sun Certified Enterprise Architect for the Java Platform
    Sun Certified Programmer for the Java 2 Platform
    IBM Certified Advanced Application Developer - Lotus Notes and Domino
    IBM Certified Application Developer - IBM WebSphere Portlet Factory
    Computer Science Mastering / UFSC - PPGCC

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Relationships Confusion
    By tomcdonnell in forum Help
    Replies: 2
    Last Post: 2010-05-23, 10:44 PM
  2. SOAP Confusion
    By Dave0101 in forum Developer Help
    Replies: 5
    Last Post: 2007-06-19, 11:34 PM
  3. Customization Confusion
    By Headjoog in forum Developer Help
    Replies: 2
    Last Post: 2006-05-18, 10:53 AM
  4. End User Confusion
    By atheimer98 in forum General Discussion
    Replies: 1
    Last Post: 2006-04-12, 07:08 PM
  5. Schema Confusion
    By rcreamer in forum General Discussion
    Replies: 1
    Last Post: 2006-04-11, 09:29 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
  •