CiviCRM Community Forums (archive)

Can anyone out there walk me through exposing the supplemental_address_3 field?  I need a fourth address line, and when I found that it exists in the database, I was very happy.  However, it's still not showing up, even after I've added it in as many places as I could find.

I've looked all over, and found a mention from lobo that it's fairly easy (http://forum.joomla.org/viewtopic.php?f=294&t=77752).  Any help will be appreciated!

Mr. Greenberg, thanks for your response.  I've given those suggestions a shot, and supplemental_address_3 still doesn't show up.  I also did a site-wide find for "supplemental_address", and added 'supplemental_address_3' to any file where there was already a supplemental_address_1 and 2.  Still no dice.  I'm not sure why that's not working, as it seems like any file where the address fields are referenced have been altered to include supplemental_address_3 - any other suggestions?  Thanks again.

Hello Mr. Lobo, thanks for your response.  Below is further information.  Hopefully this will be helpful...

1. http://www.decadentphilistine.com/crm/

2. api/Location.php, api/utils.php, v2/Location.php, Preferences/Address.php, BAO/Query.php, Form/Address.php, View/Vcard.php, CRM/Contribute/Form/Task/Export.php, Core/Form.php, BAO/Address.php, BAO/Mapping.php, BAO/Preferences.php, BAO/UFGroup.php, BAO/Event.php, CRM/Event/Form/Task/Export.php, CRM/Member/Form/Task/Export.php, Form/Field.php, Form/Preview.php, Utils/Address.php
(supplemental_address_3 was already in DAO/Address.php, but edited beginning with line 374 to mimic code for supplemental_address_2)

3. Added supplemental_address_3.tpl in sites/all/modules/civicrm/templates/CRM/contact/form/address/ and modified code to reflect addt'l address 3.

4. I've got the Trace module running off and on within Drupal, set to capture  SELECT, INSERT, UPDATE, DELETE, and "Other" queries.  No mention of any of the supplemental addresses - just street_address.  Is there a better way to watch for retrieval?

Ok, I had to put this on a shelf for a little while, as it was driving me crazy.  However, a friend looked into it, and realized there was a record missing in the civicrm_option_value table.  Although supplemental_address_3 exists in the civicrm_address table, the code is looking for it in the civicrm_option_value table.  This table is also a place to modify the labels for the address fields (which was also tripping me up). 

Here's the sql command to insert the Address 3 record into the civicrm_option_value table:

insert into civicrm_option_value (option_group_id,label,value,weight,is_active) values (19,'Address 3', 12,12,1)

So, it seems like doing everything already discussed in this thread, plus adding the right record to the right table will work.  At least it did for me.  Thanks for the ideas!