An Oracle blog about BI Publisher

  • RTF
    November 22, 2007

Hard Check Print Security Alternative

Happy Thanksgiving to those readers in the US - for the rest of you Happy Thursday. Before I head off to help eat some monstrous great bird with a group of friends and family I have a great customer tip to share.

You may remember the article I posted last week on a check security solution from Evergreen - they provide the removable hardware that holds the check singatures and micr font, it sits between server and printer. They also now provide the software solution that integrates with Publisher and enables the signatures to be read and pulled into the final document.   

I received a mail from Dustin Frysinger and Keith Preston from the National Lime & Stone Company - they have been working on their own check security solution wanting to come up with a lower cost alternative. They had not invested in a SIMM printer module to hold the check signature images but they still wanted a hardware solution. I have mentioned mounting a USB or memory card as an accessible drive in the past; Dustin and Keith have actually implemented it. They have the check signatures on a memory card that can be kept locked up until a check run needs to be executed. When they are ready, the memory card is inserted into a card reader on the server and its mounted as a drive - I have played with mounting the card on a web server and gotten that working in the past. They took a simpler route and just mounted it as a drive - simpler is always better in my book - I have to kick myself sometime for being too fancy in my solutions.

In their template they have logic to pull in the signature images as required i.e.


Rather than a regular URL they are using the 'file' URI to pull the image in. Of course that drive needs to be accessible from where ever Publisher is running. If the check print is run without the card in place then signatures are of course not pulled in and there is a blank area left. Still a little vulnerable may be - my bank never seems to check my signature until after tha mony has been drawn - maybe things are stricter for a company check. However its not hard to add the logic to put in a 'VOID' image if the signature image is not present - I blogged this a while back ... actually it was back in April 06 that's more than 200 articles ago! If you implement that logic alongside the card method then I think the checks can be as secure as they can be.

Its a nice solution to a tough problem - Im working with a few customers that do already have a printer SIMM module that they need to communicate with via escape sequences. Basically, we need to inject PCL codes into the document prior to sending to the printer to ensure images are pulled in as necessary from the printer module. Its a tough nut to crack because we do not generate PCL ourselves so we need some injection method - Im hoping to be able to publish that soon.

Dustin and Keith have been up to a host of other stuff but I'll save that for another day. If you want to know more about their approach, let me know via comments or mail and I'll hook you up - Im sure they'll be cool with that.

Now, Im off to stuff myself with stuffing, veg out on veggies and maybe eat some turkey - its a tough time of year for the poor old turkey.  

Join the discussion

Comments ( 10 )
  • Ramarao Monday, July 28, 2008
    Hi Tim,
    we are in the process of upgrading to 12i.
    1). Concerns about checks
    a). If using an RTF output, is there security (read only) to prevent a user
    from changing information on the output?
    b). If using a PDF output, is there a way to get past the Adobe limitation
    and move the bottom margin down so that the MICR information lines up
    c). Where does the MICR font need to reside? Server, printer, local PC?
    2.Are there any performance issues when image located in a central location (example application server)?
  • Tim Monday, August 4, 2008
    Hi Ramaro
    a. No security around the RTF output. Use PDF - you are ultimately going to print the checks and PDF is the format that is the best for this
    b. I was not aware of any limitation - you can create a template with no margins if needed and it will be reflected in the output
    c.Needs to sit on the server.
    there is a white paper on this on OTN -
  • Ramarao Tuesday, August 12, 2008
    Hi Tim,
    Are there any performance concerns if the image is small, but there are 1000+ checks that the image must be on? In this type of scenario where should we place the image in DB or Application server?
  • Megan Russell Wednesday, December 9, 2009
    EPIC site!!! I'm definitely looking forward to seeing more posts
  • antique posters melbourne Wednesday, March 10, 2010
    However, in the art market the term is used of old prints - especially earlier 20th century and 19th century examples of lithography, etching or steel engraving. Really old prints (before c1800) are called Old master prints.
  • Norman Seaver Tuesday, September 14, 2010
    I went over this on my site the other day - I'd share the url but then this comment would look like spam
  • Home Security System Wednesday, September 22, 2010
    Wonderful to read!
  • Lyndon Shroyer Wednesday, October 6, 2010
    Once a particular contract is being signed by a client the home security companies start to offer their services very often.
  • Charline Paguirigan Wednesday, October 6, 2010
    There are what are called the home security cameras, which, if installed properly, will give you lasting safety.
  • Shelby Petrie Wednesday, October 6, 2010
    Check that your smoke alarms are working correctly, it is even more important for home security when your property is empty, when there will be an inevitable delay in checking out alarm systems.
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.