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) »
  • Can't export a name that is literally "Null"
Pages: [1]

Author Topic: Can't export a name that is literally "Null"  (Read 1309 times)

samarkand

  • Guest
Can't export a name that is literally "Null"
December 04, 2007, 06:20:09 pm
Hi,

A contact whose last name is Null (not the value, but literally N-u-l-l) will, when exported, show up with the Last Name data field blank.

According to the 1990 US Census, only .003 percent of Americans have the last name of Null (ranking #4509 on the list of last name frequency), but it's common enough that if you were to exclude last names that appeared less frequently, you'd be excluding 38% of the American population.

Plus we've got a Null in our database.

This problem has been replicated on the demo by exporting contacts from a Null Group that was created.

The way CiviCRM handles the Null name seems to extend to other data fields; a Null in the City data field was also exported as blank. (Not that there are any cities or towns named Null, but just to illustrate...)

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: Can't export a name that is literally "Null"
December 04, 2007, 06:33:29 pm

please file an issue for this. We'll attempt to fix this in the 2.1 release (since it only happens for 0.003 % of the names). the string 'null' is being used by the base package that we use (DB_DataObject) in a special manner (i.e. make the field null) and hence the fix is not as trivial as it sounds :(

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

ehendricks

  • I’m new here
  • *
  • Posts: 26
  • Karma: 0
  • CiviCRM version: 4.5.8
  • CMS version: Drupal 7.35
  • MySQL version: 5.5
  • PHP version: 5.4.23
Re: Can't export a name that is literally "Null"
January 15, 2014, 01:02:16 pm
I've run into this issue today where someone has the last name of "Null".  I found on the 4.4 demo site that its still a problem.  That when a contact is edited and "Null" is entered as the last name it is blank after saving.  I am using 4.3.8 with Drupal 7.

I've worked around this issue for now by entering the last name with the double quotes.  It would be good if this could be fixed however.

Chris Burgess

  • Ask me questions
  • ****
  • Posts: 675
  • Karma: 59
Re: Can't export a name that is literally "Null"
January 15, 2014, 01:31:38 pm
I'd guess this never got fixed in 2.1 because the issue never made it into the issue tracker (or, it was fixed and later broke again).

Anyway - next step (after identifying that the issue is real, and raising in the forums, so about step 7) is to file an issue in the bug tracker.

https://civicrm.org/bug-reporting (step 7)

That'll put it (back?) on the radar for developers, and hopefully see the issue resolved in a future release.
@xurizaemon ● www.fuzion.co.nz

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: Can't export a name that is literally "Null"
January 15, 2014, 02:52:27 pm

There is an open issue here: http://issues.civicrm.org/jira/browse/CRM-11819

this is not going to be resolved till we switch over to a new DB layer

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

ehendricks

  • I’m new here
  • *
  • Posts: 26
  • Karma: 0
  • CiviCRM version: 4.5.8
  • CMS version: Drupal 7.35
  • MySQL version: 5.5
  • PHP version: 5.4.23
Re: Can't export a name that is literally "Null"
January 20, 2014, 09:01:51 am
Thanks for your reply.  Can you explain to me what "switch over to a new DB layer" means?  It would be very much appreciated  :)

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: Can't export a name that is literally "Null"
January 20, 2014, 09:53:25 am

check:

https://civicrm.org/blogs/kurund/civicrm-and-doctrine-adventure-continues

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
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Can't export a name that is literally "Null"

This forum was archived on 2017-11-26.