docaltmed wrote on Monday, June 22, 2015:
How do I produce a list of patient names and emails, preferably one
which can be exported as a csv file?
docaltmed wrote on Monday, June 22, 2015:
How do I produce a list of patient names and emails, preferably one
which can be exported as a csv file?
visolveemr wrote on Tuesday, June 23, 2015:
Hi,
You may need to fine tune the report under Reports->Clients->List to pull the email address of patients. Currently it list out the patients, their address and phone numbers which could be exported as CSV.
Thanks,
ViSolve
services@visolve.com
Would it be possible to give us a hint where to go to ‘fine tune’ the fields included in the client list?
hi @Chrys_Ostrander, you could add the email field to the sql statement, openemr/patient_list.php at master · openemr/openemr · GitHub
and then add the sql to the report, openemr/patient_list.php at master · openemr/openemr · GitHub
this is the development tip of code so your version like 5.0.1 will vary slightly and not have support for the csvEscape()
function
Thanks. I’ll give that a try. Mine is v5.0.2.