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 Profiles (Moderator: Dave Greenberg) »
  • Does anyone automatically correct letter cases for entered through a profile?
Pages: [1]

Author Topic: Does anyone automatically correct letter cases for entered through a profile?  (Read 746 times)

joanne

  • Administrator
  • Ask me questions
  • *****
  • Posts: 852
  • Karma: 83
  • CiviCRM version: 4.4.16
  • CMS version: Drupal 7
Does anyone automatically correct letter cases for entered through a profile?
July 30, 2012, 01:31:59 am
In the profiles on our membership sign up or event registration forms, people often enter their name and address without using uppercase letters eg .

mary moriarty
12 smith road
blackrock

Although this is how thay have chosen to enter the info, it looks rather unprofessional if emails, professional developement certificates and items we post to them have the name and address written like that.

It would be great if when someone clicks on Confirm Payment at the bottom of a contribution page, "something"  ( a hook??) would  change the first letters of the first_name and last_name to uppercase, Title Case the street address and ( for our needs a least) convert the entire city field to upper case.

People would then have the chance to add further changes eg if their surname is McNeil and they enter mcneil and on the confirmation page they see Mcneil, perhpas they would be prompted to go back and change it to McNeil.

There would be negatives ( eg van den Hoff would become Van den Hoff) but overall it would be an improvement on the mess we currently get.

Has anyone done anything like this?

If not how do you deal with people entering everything in lowercase.


Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Does anyone automatically correct letter cases for entered through a profile?
July 30, 2012, 01:48:45 am
We currently do not correct this, but it is a valid point. Worth an issue in the Issue Tracker?
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Does anyone automatically correct letter cases for entered through a profile?
July 30, 2012, 04:21:07 am
Hi,

We have done something like that (mix of js & hook), but was specific for a client. Would be great to push it as an extensions. Would you have the dev resources to adapt our code (or budget to let us do it)?

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

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: Does anyone automatically correct letter cases for entered through a profile?
July 30, 2012, 01:10:45 pm
Some problems that affect this, especially with last names, is that it is valid to have lowercase eg 'van der Hofen' or 'de la Cruz' 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

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Does anyone automatically correct letter cases for entered through a profile?
July 30, 2012, 01:22:16 pm
What I did if I recall was to check if it was all lowercase or all uppercase, and in the js uppercase the first letter (so the contact can see what we want and fix)

on the hook, did the same. So as long as you have one upper and one lower, it's not corrected, otherwise it is.

For the org, we had a slightly modified rule (so ACME goes through).
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

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: Does anyone automatically correct letter cases for entered through a profile?
July 30, 2012, 01:24:02 pm
sounds like a very useful solution then
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

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Does anyone automatically correct letter cases for entered through a profile?
July 30, 2012, 11:26:32 pm
It does indeed X, can you make it available or should we take this on board in the sprints?
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Profiles (Moderator: Dave Greenberg) »
  • Does anyone automatically correct letter cases for entered through a profile?

This forum was archived on 2017-11-26.