Is there a quick way to print out a full list of all the quick texts on the global list? Or should I just start cutting and pasting them one by one?
Thanks
This report will return the quick text for a particular user by their login, or comment out the select to get everyone.
Thanks so much for the report. I've put it into the reports folder and selected the pathname of report but when I run it, it comes up empty. Is there something else I need to do? Apologies if this is a silly question! I've just started dipping my feet in these waters.
It's set up to pull for one particular user. Comment out the select criteria for every user.
Here is the sql to get all the global quick texts:
select trigtext, exp from ml.textmacros where USERID = '0' order by userid,trigtext
This will get you all personal quick texts:
select firstname, lastname, trigtext, exp from ml.textmacros, ml.usrinfo where userid = pvid order by lastname
David Shower
OU Tulsa School of Community Medicine
There is an easier way. Export the Global List Quick Texts into your c-drive and open the GLOBALLI.TXM File with wordpad and then copy into a Word Document to Edit and done! You can follow this same step with personal lists as well if you have providers needing the print out.
I know this is an older thread, but I am hoping someone can explain how to "Export the Global List Quick Texts". I've been looking all over for a way to do this, with no success.
We are on CPS 12, SP 9.
Thanks in advance!
Bentley
Cascade Eye Center
Oregon
I have a crystal report that I got from here a few years ago that will list ALL of the quicktext sorted by username.
You can then export it's results to a document or spreadsheet.
I am trying to do the same thing? By export do you mean a clinical kit? Do you mean a SQL query?
Nevermind. You export the clinical kit. Looks like there is going to be a lot of editing but it's a start.
thanks, STephanie