Printing and Creating Images from the Database

<< Click to Display Table of Contents >>

Navigation:  Automating >

Printing and Creating Images from the Database

Previous pageReturn to chapter overviewNext page

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 Authorizer\HIPAAAuthorizer.exe" ,QF,,Select * from EDI_AuthorizerDetails where HeaderID = '17'"

 

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 Authorizer\HIPAAAuthorizer.exe" ,QP,,Select * from EDI_AuthorizerHeader where SubscriberName = '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.