Author Topic: Developer needed for custom extension  (Read 1077 times)

Offline rminkov

  • I’m new here
  • *
  • Posts: 16
  • Karma: 0
  • CiviCRM version: 4.4
  • CMS version: Drupal 6
  • MySQL version: 5.1
  • PHP version: 5.3
Developer needed for custom extension
« on: March 18, 2015, 01:59:28 am »
We urgently need and will sponsor a custom extension for the functionality explained below.

1. Existing situation

During the process of registering for an event (ex. http://www.ceps.eu/civicrm/event/register?id=831&reset=1), we collect usual details, plus Organization name, job title and department.

If there is a existing database contact which is a match (first and last names and email) of the data entered, then the data entered will overwrite the existing database contact. The problem is that people use small caps, or ALL CAPS, or enter EC instead of European Commission, etc.

For example:
Existing contact:
Richard Pools, Personal assistant to the CEO, European Commission, richard.pools@ec.eu

After Richard fills up the form registering for an event it becomes:
richard pools, pa to the ceo, EC, richard.pools@ec.eu

The resulting record could not be used for badges nor for list of participants, so the secretary has to go through the whole list of registrations and fix where needed, and she has to do this for every event (2-3 per week).

2. What should be done (via civicrm extension)

The current event registration procedure is:
- when a match is found - update the existing data with the data entered
- when no match is found - create new record

We need it changed to:
- when a match is found
     - check if an event registration exists, if do not create another
     - leave the existing data as is
- when no match is found - create new record


Additional information:

1. We use an unsupervised dedupe rule that matches first name, last name and email address.
The problem is that the contact record already in the database gets overwritten with anything submitted via the form.

2. We use hashed links in our mass emails so that when user reach the registration his/her details are pre-filled.

3. It is not possible to make our contacts log-in to the website and thus have their forms pre-filled. We tried it in the past, didn't work.

Offline xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Developer needed for custom extension
« Reply #1 on: March 18, 2015, 04:22:50 am »
Hi,

Interesting need! What's your timeline on how you need it?

You might benefit from this extension (at least no matter if rick types RICHARD or richard, it will be Richard at the end), but won't solve the job title issue. On the other hand, what if Rickie got a new job title and you keep his old title? isn't  this worse?

https://github.com/TechToThePeople/civicrm-normalise

Offline rminkov

  • I’m new here
  • *
  • Posts: 16
  • Karma: 0
  • CiviCRM version: 4.4
  • CMS version: Drupal 6
  • MySQL version: 5.1
  • PHP version: 5.3
Re: Developer needed for custom extension
« Reply #2 on: March 18, 2015, 04:30:56 am »
Hi Xavier,

We need it now.

We are using the extension https://github.com/TechToThePeople/civicrm-normalise
We do really big job on keeping the database up to date and do not rely on user input for this.
Just the opposite - user input makes the things worse - that is why we need an extension to change the default Civi behavior.
I am sure many people will welcome such an option.

Cheers,
Rado

Offline 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: Developer needed for custom extension
« Reply #3 on: March 18, 2015, 12:16:40 pm »
Are you wanting an extension that will work with 4.1? or are you planning to upgrade?

And to confirm, the problem eg for Richard described below is not as a result of him clicking the checksum/hashtag presumably?
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

Offline rminkov

  • I’m new here
  • *
  • Posts: 16
  • Karma: 0
  • CiviCRM version: 4.4
  • CMS version: Drupal 6
  • MySQL version: 5.1
  • PHP version: 5.3
Re: Developer needed for custom extension
« Reply #4 on: March 19, 2015, 03:29:32 am »
Are you wanting an extension that will work with 4.1? or are you planning to upgrade?

Sorry, I forgot to update my profile. We are on Civi 4.4.6 with plans to upgrade to 4.5.

Quote
And to confirm, the problem eg for Richard described below is not as a result of him clicking the checksum/hashtag presumably?
No, clicking on checksum works. Problem arises when we have a registration page with empty fields.

Offline JohnFF

  • I post frequently
  • ***
  • Posts: 235
  • Karma: 6
  • CiviCRM version: 4.4.13
  • CMS version: Drupal 7.28
  • MySQL version: 5.5.31-1
  • PHP version: 5.3.27
Re: Developer needed for custom extension
« Reply #5 on: August 08, 2015, 11:48:24 am »
Why not try caps correct? It corrects 500 names a day, and you can set more if you want.
If you like empowering charities in a free and open way, then you're going to love Civi.

Email Amender: https://civicrm.org/extensions/email-amender
UK Phone Validator: https://civicrm.org/extensions/uk-phone-number-validator
http://civifirst.com
https://twitter.com/civifirst