Potential Address Book Bug

mike-h30 wrote on Thursday, August 14, 2008:

I am comparing the Address Book in 2.8.3 on my production box with the Address Book in 2.9.0 on my test box and noticed quite a bit of discrepancies in the output.    The 2.9.0 displays less individuals then the 2.8.3 Address Book.

I am using the same data ( I copied my production data over to my test box).  There are 157 entries in the users table on both the production and test databases.

What has changed in the logic for displaying the Address Book entries?

-Mike

sunsetsystems wrote on Thursday, August 14, 2008:

The address book no longer shows local users who are not practitioners (authorized).  It shows only local doctors, and those who you have otherwise specifically added to it.  Hopefully this is an improvement!

Rod
www.sunsetsystems.com

mike-h30 wrote on Thursday, August 14, 2008:

I see.  We use our address book for everyone that has anything to do with the clinic.   The drug reps, the medical supply vendors, attorneys that represent our workers comp patients, therapists, physicians, and employees. 

-Mike

mike-h30 wrote on Thursday, August 14, 2008:

We do want all of the individuals from our 2.8.3 Address Book to display in 2.9.0.  It seems that there are a couple of ways to get users to display in the 2.9.0 Address Book by updating the data in table "Users."

1.)  Setting the field “authorized” = 1.
2.)  Setting the field “username” = ’ ’  ( that is a blank).  Those users not displaying in the 2.9.0 Address Book have the value “NULL” in the “username” field.

Which is the recommended value to update in the database to get our 2.8.3 contacts visible in the 2.9.0 Address Book?

-Mike

sunsetsystems wrote on Friday, August 15, 2008:

You can just modify interface/usergroup/addrbook_list.php.  Change line 16 from:

  $query = "SELECT * FROM users WHERE active = 1 AND ( authorized = 1 OR username = ‘’ ) ";

to:

  $query = "SELECT * FROM users WHERE active = 1 ";

Rod
www.sunsetsystems.com

mike-h30 wrote on Thursday, May 28, 2009:

I forgot about this change and was wondering why some of our address book individuals were missing.  I went back to edit the SQL per Rod.

Is it possible to make a setting in the Admin section  to choose  Address Book individuals that one would like to be displayed?  We have individuals ( pharm reps, vendors, attorneys) that are not physicians who we would like to keep contact information available in the Address Book.

-Mike