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 Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Problems exporting the fields that have the same label
Pages: [1]

Author Topic: Problems exporting the fields that have the same label  (Read 1191 times)

rhrueda

  • I post occasionally
  • **
  • Posts: 45
  • Karma: 0
  • CiviCRM version: 4.4.3
  • CMS version: Drupal Pressflow 6.22
  • MySQL version: 5.5.22
  • PHP version: 5.3.10
Problems exporting the fields that have the same label
March 07, 2013, 03:43:09 am
Hi,

It seems there´s no way to export all the fields of a contact that have the same labels (work, home, mobile, fax......), I haven´t found it here in the forum.

For example

For a contact I have three emails for work, and three phone numbers for work, something like:

- email1 @ whatever.com - work
- email2 @ whatever.com - work
- ....
- phonenumber1 - work - mobile
- phonenumber2 - work - mobile
- ....

If I select a mapping to export, I introduce email - work three times, and phone - work - mobile three times as well. The result is that is always exporting just the primary fields, and I want all this information.

Is there a way to accomplish this?

Many thanks!

Michael McAndrew

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1274
  • Karma: 55
    • Third Sector Design
  • CiviCRM version: various
  • CMS version: Nearly always Drupal
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Problems exporting the fields that have the same label
March 07, 2013, 08:04:02 am
this is a limitation of the export (it likes to export one row per person. you *might* be able to accomplish what you want to do with the contact detail report. otherwise i can't think of another way that you could do this out of the box - I think it would require some tinkering
Service providers: Grow your business, build your reputation and support CiviCRM. Become a partner today

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Problems exporting the fields that have the same label
March 07, 2013, 08:24:32 am
Quote from: Michael McAndrew on March 07, 2013, 08:04:02 am
I think it would require some tinkering

It could be done in SQL. I am not necessarily recommending that--just mentioning it. :)
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Problems exporting the fields that have the same label
March 07, 2013, 10:35:49 am
This doesn't sound right to me if we are talking 'exports' from Adv Search rather than from Reports. Not clear to me which you are trying.
If you have Contacts selected - and go to Export, i would expect you to be able to specify
- Phone HOME
- Phone WORK
- Phone OTHER
- Email HOME
etc
Can you confirm that the above is not possible for you - and if so can you set up a wee mapping on demo and provide the details. thanks
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

rhrueda

  • I post occasionally
  • **
  • Posts: 45
  • Karma: 0
  • CiviCRM version: 4.4.3
  • CMS version: Drupal Pressflow 6.22
  • MySQL version: 5.5.22
  • PHP version: 5.3.10
Re: Problems exporting the fields that have the same label
March 08, 2013, 01:42:11 am
I´ve attached an screenshot from the contact information. As you can see, this person should be able to have several mobile numbers at work, or several email addresses at work. I should be able then to export all of them, but seems impossible. Even if I specify three times a mapping of "email - work" , or "phone - work - mobile"

I should be able to export a complete list of contacts information with all these fields... but I don´t know how :(

Many thanks

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: Problems exporting the fields that have the same label
March 08, 2013, 08:02:03 am

if i had to guess, this is a limitation in civi's query building code right now

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

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Problems exporting the fields that have the same label
March 08, 2013, 11:08:28 am
In case adding some comparisons helps - same site

3.4.7 Export mapping includes
- Home-Phone-Phone, Work-Phone-Phone
- Home-Email, Billing-Email

All works as expected ie I get 4 cols of data, with different phones and different emails exported


4.2.8 Export mapping includes
- Home-Phone-Phone, Work-Phone-Phone
- Home-Email, Billing-Email

All works as expected ie I get 4 cols of data, with different phones and different emails exported

Has any one confirmed this is failing on Demo?
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Problems exporting the fields that have the same label
March 08, 2013, 11:38:06 am
sorry - just reread - you have several versions of the same PHone / Location
eg
email 1 = work
email 2 = work

no that has never been possible and i think is going down the wrong approach to be honest
i think if you want to allow people to have multiple work emails then you should be setting up multiple work Locations eg
Location Types
- Work1
- Work2
- Work3

Otherwise you will hit constraints in all sorts of places such as profiles for collecting the data etc
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

TLange

  • I’m new here
  • *
  • Posts: 20
  • Karma: 0
  • President of California Clean Money Campaign
    • California Clean Money Campaign
Re: Problems exporting the fields that have the same label
June 21, 2013, 10:45:40 pm
I'm having the same problem that rhrueda was having.  The problem is that you can't use petednz's approach of creating a separate Location type when you're using the Merge Duplicates function.  If you're merging two duplicate contacts and they have a different email address or phone number, if you don't want to lose one of the two, you have to select the "Add New" option.

That makes it so the resulting merged contact has two emails or phone numbers for the same location -- and unless there's something I'm missing, there's no way to export the second one.

Is there any solution to this problem?

Thanks,

- Trent
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Problems exporting the fields that have the same label

This forum was archived on 2017-11-26.