Results 1 to 8 of 8

Thread: New Module not appearing in Relate Field dropdown

  1. #1
    avadtechnologies is offline Sugar Community Member
    Join Date
    Sep 2007
    Posts
    28

    Default New Module not appearing in Relate Field dropdown

    We created a new module called Vendors because we wanted to seperate our Customer Accounts from our Vendor accounts completely and have a different layout for each.

    We want the ability to link a contact to a vendor.

    Currently we can add contacts to a vendor using the sub panel. But when we add a contact there is no field like the "account" field to link it to a vendor.

    I have tried adding a relate field in the contacts module however the only options I can choose are the default ones. My vendors module does not appear in the list. I have done a repair relationships in the admin and created the relationship in the Vendors module to accounts.

    Is there any way to accomplish this?

  2. #2
    Superman's Avatar
    Superman is offline Sugar Community Member
    Join Date
    Oct 2005
    Location
    Kazakhstan
    Posts
    852

    Default Re: New Module not appearing in Relate Field dropdown

    After you've added modifications to vardefs.php file of Contacts module you should run Repair Database, so that it could create field in contacts table 'vendor_id' (if you've indicated it so).
    Farkhad Rakhimzhanov
    E-mail: farkhad@gmail.com
    Skype: rakikama

    SuperTimesheet and Invoicing — timesheet tool with invoicing for SugarCRM.
    Book time against Cases, Project Tasks and Projects.
    Create invoice regarding booked time, print it in PDF or HTML,
    customize template as you like.

  3. #3
    avadtechnologies is offline Sugar Community Member
    Join Date
    Sep 2007
    Posts
    28

    Default Re: New Module not appearing in Relate Field dropdown

    Do I have to manually add changes to the file itself or is that done through creating relationships in the module builder?

    Thanks for advice I will dig around and see if I can figure it out.

    ** Edit **

    I added the following to the vardefs file for contacts. I then repaired the database which completed with no errors, however I can not see the new field anywhere. Also, Vendors is still not a selectable option when I try to create a relate type field. I am not sure if I entered in the correct information or not either; code is usually interpreted as martian by me.

    PHP Code:
        'vendors_id' =>
            array (
                
    'name' => 'vendors_id',
                
    'rname' => 'id',
                
    'id_name' => 'vendor_id',
                
    'vname' => 'LBL_VENDOR_ID',
                
    'type' => 'relate',
                
    'table' => 'vend1_ven_accounts',
                
    'isnull' => 'true',
                
    'module' => 'Vendors',
                
    'dbType' => 'id',
                
    'reportable'=>false,
                
    'source' => 'non-db',
                
    'massupdate' => false,
                
    'duplicate_merge'=> 'disabled',
                
    'hideacl'=>true,

            ), 
    Last edited by avadtechnologies; 2008-01-08 at 06:39 PM.

  4. #4
    Superman's Avatar
    Superman is offline Sugar Community Member
    Join Date
    Oct 2005
    Location
    Kazakhstan
    Posts
    852

    Default Re: New Module not appearing in Relate Field dropdown

    so you are talking actually about that you've tried to add Relate Field in Contacts module via Studio?
    Farkhad Rakhimzhanov
    E-mail: farkhad@gmail.com
    Skype: rakikama

    SuperTimesheet and Invoicing — timesheet tool with invoicing for SugarCRM.
    Book time against Cases, Project Tasks and Projects.
    Create invoice regarding booked time, print it in PDF or HTML,
    customize template as you like.

  5. #5
    avadtechnologies is offline Sugar Community Member
    Join Date
    Sep 2007
    Posts
    28

    Default Re: New Module not appearing in Relate Field dropdown

    Yes. In the contacts module there is a relate field for Accounts. When you select it pulls up possible accounts to "match" the contact up with.

    I want a similair field you can select to link it to a "Vendor".

    I created the vendor module in 5.0 using module builder and selected account for the type. I also created a relationship in the module builder to Contacts. I can add contacts to the vendor via sub panel in the vendors module.

    When I use studio to add a custom field to the "contacts" module, and select "relate" as the type. It gives me the option of choosing any of the default modules. However the custom module I built and deployed does not appear in that list.

  6. #6
    avadtechnologies is offline Sugar Community Member
    Join Date
    Sep 2007
    Posts
    28

    Default Re: New Module not appearing in Relate Field dropdown

    Here is an image showing exactly where and what I am trying to add and the problem I am having. Vendors is not listed in the modules drop down list. Go go MS Paint skills.


  7. #7
    Superman's Avatar
    Superman is offline Sugar Community Member
    Join Date
    Oct 2005
    Location
    Kazakhstan
    Posts
    852

    Default Re: New Module not appearing in Relate Field dropdown

    You need to add manually Vendors module in that dropdown list.
    But please, do not ask what is the name of that dropdown, i do not know
    Find it yourself.
    Farkhad Rakhimzhanov
    E-mail: farkhad@gmail.com
    Skype: rakikama

    SuperTimesheet and Invoicing — timesheet tool with invoicing for SugarCRM.
    Book time against Cases, Project Tasks and Projects.
    Create invoice regarding booked time, print it in PDF or HTML,
    customize template as you like.

  8. #8
    jspencer is offline Sugar Community Member
    Join Date
    Jun 2007
    Location
    Orlando, Fl
    Posts
    85

    Default Re: New Module not appearing in Relate Field dropdown

    I think the dropdown in question is 'parent_type_display', but just adding an entry for my module didn't fully work. It showed up in the related to box, but hitting select just brought up a blank white popup (where the default modules normally show a list of their items).

    I have a post on this in another thread but so far nobody has answered it...
    -Jeff

    SugarCRM CE 5.0a - Ubuntu 6.04 - Apache 2 - PHP 5 - Mysql 5

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Relate to Custom Module in 5.0 RC
    By dogfuel in forum Developer Help
    Replies: 5
    Last Post: 2007-11-20, 03:41 AM
  2. Replies: 1
    Last Post: 2007-09-10, 12:17 AM
  3. Cannot add custom field to custom module
    By longnv in forum Developer Help
    Replies: 0
    Last Post: 2007-03-10, 12:30 PM
  4. add custom field relate other fields
    By longnv in forum Developer Help
    Replies: 6
    Last Post: 2007-02-26, 07:33 AM
  5. Replies: 0
    Last Post: 2006-06-21, 07:47 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
  •