Navigation:  Automating > Printing and Creating Images from the Database

Can I print directly from the database?

You can print directly from the database. You can also create image files from database records:

 

The command line arguments for this are as follows:

 

oFirst argument — This should be blank.

oSecond argument — This could be one of three options ("QP" to print records, "QT" to create TIFF files, or "QF" to create PDF files).

oThird argument — This is the image file name used only if an application is configured to create one result file (the same argument we use to generate image files from a file).

oFourth argument — This is your query.

oFifth argument — This is the custom printer name; it can be omitted if the default printer is used.

oSixth argument — This is the database connection type (Test or Production), with the default being Production.

 

Example 1

 

"C:\Program Files\HIPAAsuite\HIPAA Claim Master\HIPAAClaimMaster.exe" ,QF,,Select * from EDI_Claims where ClaimID = '1357'

 

This example will create an image file with the default naming convention from the claim with the ID of '1357'.

 

Example 2

 

"C:\Program Files\HIPAAsuite\HIPAA Claim Master\HIPAAClaimMaster.exe" ,QP,,Select * from EDI_Claims where SubscriberLast = 'SMITH',Lexmark X 500 Series,T

 

This example will print all claims in the test database where the subscriber's last name is 'SMITH' to the Lexmark X500 Printer.