BatchCom and Database Reporting

drbowen wrote on Wednesday, September 26, 2007:

Does anyone use BatchCom?

What do you use it for?

How about Database Reporting?

What do you use it for?

Sam Bowen, MD

sunsetsystems wrote on Thursday, September 27, 2007:

Sam, offhand I don’t know anyone using BatchCom but I think its purpose it to send out bulk mailings (email or paper) to patients selected by various critera.  I’m sure there are situations where that is useful.

Database Reporting is just a way to invoke phpMyAdmin for various administrative tasks including raw database queries.  Normal users should not have access to this.  As a developer I use it a lot for debugging and collecting information.

Rod
www.sunsetsystems.com

aperezcrespo wrote on Friday, September 28, 2007:

Hi guys
  Actually several of my clients use BatchCom to send reminders to their patients.  One uses the CVS option with mailmerge to send letters.  phpMyAdmin is a nice to have.  Considering you have to be logged into OEMR to use it keeps it nice and secure.  At least there’s not a version running outside of OEMR and this gives the client a sense of security about access to it.

My 2 cents (Which over the years has lost value and is now worth .5 cents)

Thanks
Alfonso

voipbound wrote on Sunday, August 31, 2008:

How does one set this up exactly?

ahmed_optom wrote on Thursday, December 04, 2008:

batchcom doesnt appear to be working still. I get the following error:

ERROR: query failed: SELECT DISTINCT patient_data.* , MAX( cal_events.pc_endDate ) AS last_ap, MAX( forms.date) AS last_visit, (DATEDIFF(CURDATE(),patient_data.DOB)/365.25) AS pat_age FROM patient_data, forms LEFT JOIN openemr_postcalendar_events AS cal_events ON patient_data.pid=cal_events.pc_pid LEFT JOIN forms AS forms2 ON patient_data.pid=forms2.pid GROUP BY patient_data.pid ORDER BY patient_data.postal_code

Error: Unknown column ‘patient_data.pid’ in ‘on clause’

Im using xp, with xampp. All latest versions, 2.9.0 etc.