CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviContribute (Moderator: Donald Lobo) »
  • Need to export civicrm_address.name to get Billing Name
Pages: [1]

Author Topic: Need to export civicrm_address.name to get Billing Name  (Read 642 times)

DamonKirkpatrick

  • I post occasionally
  • **
  • Posts: 58
  • Karma: 0
  • One job but so many responsibilities.
    • Friends of Georgia State Parks
  • CiviCRM version: 4.5.2
  • CMS version: Drupal 7.35
  • MySQL version: 5.1.48
  • PHP version: 5.3.8
Need to export civicrm_address.name to get Billing Name
May 06, 2011, 07:40:44 am
I've spent the past few days configuring an export of contributions and have managed to get everything I needed to show in the export EXCEPT billing name.  I can get the entire billing address, the contact address etc.  But if the name in the billing section is different than the name for the contact, it is stored as a concatenated name in the address table under the field Name. 

I've searched all over for a way to pull this out but can not find anything.  The billing name shows on contribution records but is not available for export (at least not that I can find). 

Any suggestions?

DamonKirkpatrick

  • I post occasionally
  • **
  • Posts: 58
  • Karma: 0
  • One job but so many responsibilities.
    • Friends of Georgia State Parks
  • CiviCRM version: 4.5.2
  • CMS version: Drupal 7.35
  • MySQL version: 5.1.48
  • PHP version: 5.3.8
Re: Need to export civicrm_address.name to get Billing Name
May 07, 2011, 06:11:06 am
Ok, I've dug around some more into the export.php file and a few other files and can't figure out where the fields list is created.

It seems like I need to:

On the export page, make civicrm_address.name available as an option under the "Individual" field names.  That doesn't seem like it should be difficult but I can't find where that field list comes from. 

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Need to export civicrm_address.name to get Billing Name
May 07, 2011, 07:31:44 am

I assume u mean by selecting fields in the export list.

all this stuff is controlled via the xml files (the xml files are not distributed as part of the package) and then generated. I took a quick look and realized that for address name to appear, it has to be editable, u might want to set that in the url:

q=civicrm/admin/setting/preferences/address&reset=1

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

jessedw

  • I’m new here
  • *
  • Posts: 1
  • Karma: 0
  • CiviCRM version: 3.4.4
  • CMS version: Joomla 1.5.23
  • MySQL version: 5.0.92-community
  • PHP version: 5.2.17
Re: Need to export civicrm_address.name to get Billing Name
October 17, 2011, 07:38:38 am
 I'm also looking to generate a report and show both the Individual Name and the Billing Name.

I was wondering if you ever found a solution to this?  Lobo's answer, to make it editable, does not make sense to me, as the page he refer's to does not have the option to make the name itself editable.

Thanks
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviContribute (Moderator: Donald Lobo) »
  • Need to export civicrm_address.name to get Billing Name

This forum was archived on 2017-11-26.