Printing and Creating Images from the Database

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 Premium Payment Master\HIPAAPremiumPaymentMaster.exe" ,QF,,Select * from EDI_Payments where PaymentID = '1'"

 

This example will create an image file with the default naming convention from the Payment Record with the ID of "1."

 

Example 2

 

"C:\Program Files\HIPAAsuite\HIPAA Premium Payment Master\HIPAAPremiumPaymentMaster.exe" ,QP,,Select * from EDI_Payments where PayerName = 'SMITH',Lexmark X 500 Series,T"

 

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