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 Import (Moderator: Yashodha Chaku) »
  • How to disable Suffix as a dropdown menu- turn into text field?
Pages: [1]

Author Topic: How to disable Suffix as a dropdown menu- turn into text field?  (Read 1136 times)

The Next Wave

  • I post occasionally
  • **
  • Posts: 111
  • Karma: -9
  • I'm just here to change the world.
  • CiviCRM version: 4.4.4
  • CMS version: Wordpress 3.8.1
  • MySQL version: 5.1.72-cll
  • PHP version: 5.4.25
How to disable Suffix as a dropdown menu- turn into text field?
February 20, 2014, 05:43:45 pm
I've got a state database with data entered by idiots.
Suffix is supposed to be what is on your birth certificate. Title is what you earn later.
These idiots have MD, PhD, DC, DVM etc. in the field. It kills my import with errors.
I want to set this up to run automatically- I don't care if the data in the Suffix field isn't perfect- I'm not German.
I can't find any place to edit this- instead- I just get the instruction:
" CiviCRM is pre-configured with standard options for individual contact name suffixes (e.g. Jr., Sr., II etc.). You can use this page to customize these options and add new ones as needed for your installation."

Gee- thanks CiviCRM-  I can't keep adding these on the fly. I don't really care- but I do need them- since Jr. and II and III are different people with the same name.

Can anyone point me in the right direction. Civi 4.4.4

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: How to disable Suffix as a dropdown menu- turn into text field?
February 21, 2014, 07:46:38 am
Hi,

I do get that you despise the people that worked on the database you import, that you don't like germans, that you consider incompetents the ones that wrote the help instructions on civicrm and are upset with civi not doing what you want.

What I fail to understand is what kind of help you are expecting, and how you think your tone is going to help.

Want to try again asking?

Some readings that might help you getting what you're looking for:
http://www.catb.org/~esr/faqs/smart-questions.html
http://en.wikipedia.org/wiki/Politeness_maxims

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

The Next Wave

  • I post occasionally
  • **
  • Posts: 111
  • Karma: -9
  • I'm just here to change the world.
  • CiviCRM version: 4.4.4
  • CMS version: Wordpress 3.8.1
  • MySQL version: 5.1.72-cll
  • PHP version: 5.4.25
Re: How to disable Suffix as a dropdown menu- turn into text field?
February 21, 2014, 08:04:45 am
Hi Xavier, pretty please with sugar on it, can someone point how to disable the drop down for Suffix and make it an open text field?
I guess sarcastic humor isn't appreciated.

and please note- someone else asked nicely about this back in 2009 or so- and no one helped them either.
http://forum.civicrm.org/index.php/topic,10948.msg135942.html#msg135942

JonGold

  • Ask me questions
  • ****
  • Posts: 638
  • Karma: 81
    • Palante Technology
  • CiviCRM version: 4.1 to the latest
  • CMS version: Drupal 6-7, Wordpress 4.0+
  • PHP version: PHP 5.3-5.5
Re: How to disable Suffix as a dropdown menu- turn into text field?
February 21, 2014, 09:16:20 am
You could
a) make a custom field "Suffix" and use a template override to put it next to the name/hide the original suffix field.
b) Use an ETL tool like Kettle to move non-approved suffixes to a new field, or, as I've done, use it to create new suffixes on the fly.  I can send you an example transform if you go that route.

There's probably other options, but those are the two that come to mind.
Sign up to StackExchange and get free expert CiviCRM advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

The Next Wave

  • I post occasionally
  • **
  • Posts: 111
  • Karma: -9
  • I'm just here to change the world.
  • CiviCRM version: 4.4.4
  • CMS version: Wordpress 3.8.1
  • MySQL version: 5.1.72-cll
  • PHP version: 5.4.25
Re: How to disable Suffix as a dropdown menu- turn into text field?
February 21, 2014, 10:56:58 am
Hi Jon-
Thanks for the response-
Kettle looks interesting, but I think it is beyond my skill set. However I think the Extraction, Transformation, and Loading (ETL) capabilities could come in handy for other issues that I've encountered.
I think that others may go that route.

I'm still trying to figure out how to configure the batch import via SSH- as outlined here: https://civicrm.org/blogs/xavier/api_batch_tools
Once I figure this out- then I want to make a CRON job to fetch the data from the State site-- and then do a batch update.

For me- the first solution looks like the easiest- since this isn't easily changed in Civi via normal field rule assignment.
If anyone else has ideas- I'd love to hear them.

The Next Wave

  • I post occasionally
  • **
  • Posts: 111
  • Karma: -9
  • I'm just here to change the world.
  • CiviCRM version: 4.4.4
  • CMS version: Wordpress 3.8.1
  • MySQL version: 5.1.72-cll
  • PHP version: 5.4.25
Re: How to disable Suffix as a dropdown menu- turn into text field?
February 24, 2014, 09:39:54 am
Hi Jon- a friend showed me Open Refine, formerly Google Refine- made it easy to conform the suffix's via the fractal function on the field.
http://openrefine.org/

Still searching for a way to do a big import- I use WP not Drupal.
Ideally- I'd like a script that pulls the voter list weekly from the Secretary of States office-
conforms the bad data-
and then runs an update using the rules that I have for dedupe-
- if this was all through the civi interface- even better.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • How to disable Suffix as a dropdown menu- turn into text field?

This forum was archived on 2017-11-26.