Notifications
Clear all
Topic starter
Does anyone know of a way to extract a listing of the Global Quick Text?
Thanks,
Judy
Posted : November 11, 2016 9:31 am
Alliance of Chicago has a report that can either print out the global quicktext, or get a specific users quicktext. I don't know how they did it, but it is possible.
Sorry I can't be more help.
Posted : November 11, 2016 9:56 am
It's not pretty, but the easy way:
Just go to Administration, export clinical kit, and choose quicktext. Edit the files in something like Notepad.
Posted : November 11, 2016 10:11 am
In Administration, you should be able to go to System => Export Clinical Kits. Choose "Quick Text" and click the Add...>> button. From the Quick Text list choose <Global List> and click OK. Then click Export Clinical Kit... button, and fill in the Kit Name and Location fields, and click OK. This should export a text file containing all the quick text.
Posted : November 11, 2016 10:11 am
If you have access to the SQL database and prefer a SQL Script, you should also be able to use this,
SELECT TRIGTEXT,EXP
FROM [CentricityPS].[dbo].[TEXTMACROS]
where USERID = 0
Posted : November 11, 2016 10:15 am
I have a crystal report formatted to export so I can dump into Excel. I can send you if it helps. I run it outside the EMR but you could probably import it. I've attached to the post but if you can't get it, I can email it to you. Thx. [email protected]
Posted : November 11, 2016 11:48 am
I use the following SQL script. I have actually created an SSRS report with it and have placed a link to it in our Centricity, so our users can generate this report any time they want to find an existing Global Quick Text:
select tm.TRIGTEXT Abbrev, tm.EXP 'Replace With'
from TEXTMACROS tm
where tm.USERID = 0
and tm.TRIGTEXT <> ''
order by tm.TRIGTEXT
Posted : November 15, 2016 4:22 am
