Printing and Creating Images from the Database

Navigation:  Automating >

Printing and Creating Images from the Database

Previous pageReturn to chapter overview

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 999 Master\HIPAA999Master.exe" ,QF,,Select * from TransactionResponse where Ack_ID = '1357'"

 

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

 

Example 2

 

"C:\Program Files\HIPAAsuite\HIPAA 999 Master\HIPAA999Master.exe" ,QP,,Select * from ImplementationAck where FileName = 'SMITHinfo',Lexmark X 500 Series,T"

 

This example will print all Implementation Acknowledgments in the test database where the file's name is "SMITHinfo" to the Lexmark X500 Printer.