MEDITECH Reports

MEDITECH Client Server Recent Printer List

When the Meditech Client Server Recent Printer List is out of synch with your installed printers on Windows; your Summit or Boston Workstation scripts can get hung up. 

To reset your MEDITECH Recent Printer List, to match the installed Windows Printers, as directed in MEDITECH KB 22530: 

• Close all MEDITECH sessions on the machine.
• Locate the C:\Program Files\Meditech\MagicCS\Data\ folder on your Windows scripting machine.
• Select and enter the site folder.  This folder will likely be the name of your MEDITECH Universe.  In most cases there will be only 1 subfolder here.
• Enter the \Printers\ folder.
• Delete the \Print Data\ folder.

Next time you print from Client Server on this machine, the MEDITECH printer list will match the list on your machine.

SQL Operator: DIFFERENCE for Meditech DR

SQL Server's implementation of the relational DIFFERENCE operator is the EXCEPT operator.

 SELECT AccountNumber
FROM PaymentsMissing
EXCEPT
 SELECT AccountNumber
FROM PaymentsResent

Use EXCEPT like a UNION operator.  Only instead of combining like result sets,   EXCEPT will give you the results from the first query that are not in the second query.

 If you're looking to improve your understanding of database fundamentals, you can't do better than this: SQL & Relational Theory by C.J. Date is good. 

Solution: CS Print Purge for Meditech Client Server

Deleting 50,000 spool files using Windows Explorer can take a long time.  Deleting this many files once, is no problem.  Lately, I've been working on MEDITECH NPRs generating files with sizes measured in GB.  Deleting that many spool files on a daily basis for multiple machines can only be described as: boring.

Now: there's an app for that: CS Print Purge

Experience automated spool file deletion for your larger extracts, select

1. file filter, as in null or no file extension
2. file path for the long running extract, usually located at c:\program files\meditech\print\cs print spool\ with a subfolder of 0, 1, 2, or 3 depending on how many print jobs are going at once
3. file age, as in 180 minutes or 3 hours old

This app is available to you free of charge. Download and click Run.