DRV Technologies will be closed on Friday, July 3rd, 2009 in observance of the Independence Day.

In This Issue

• News From the Lab
• Customer Testimonial
• Answers to your Questions
• Training Schedule for July/August
• Recent Additions to the DRV Family of Customers

News From the Lab

Current version 4.4.8 was released on June 30, 2009
Enhancement List See what is new in the latest version
Update Instructions Follow these instructions to upgrade your SpoolFlex/FormFlex software.

API Highlight - Spool Page Extraction - SFAEXTR

Have you ever needed to print a specific page or pages from one of your spooled files?
You probably found that IBM does not make it easy to select just those pages for printing. The SpoolFlex Extraction API (SFAEXTR), which is included in the SpoolFlex Advanced Utilities, may be just what you need. The API lets you select which spooled file to search through and what search criteria to use for page selection. It will search through the spooled files and will select out pages that only meet the selection criteria. The search would result in a new spooled file that you can use for printing or converting to PDF.

Pam, at Marinette County in Wisconsin, uses the extraction tool to avoid mailing Billing Statements back to county employees. ”Due to the nature of our clientele, some of the Billing Statements are sent to an internal social worker instead of directly to the client. Every month we were printing the statement on custom self-sealing mailers, and then paying postage to mail the statements to ourselves,” Pam said. Using SFAEXTR, they were able to pull statements containing certain search criteria, and e-mail the statements to appropriate workers. “This saves roughly $1.00 per statement, per billing cycle, per impacted client,” Pam said. Problem solved, and money and time saved.

If you would like more information about the Extraction API, please call our tech support team at 866-378-3366 or (678) 417-1521 and someone will be happy to address all your questions.

Answers to your Questions

• Q: I am creating a form which will be used by all of our hospitals. Is there a way to have a variable field for the hospital name?
  A: FormFlex allows you to create a data map definition in which you can map a field and store its value in the definition. You can then use FormFlex commands SDMOVE, SDCOPY, and SDDELT to move, copy and suppress the spool data respectively.
   
• Q: Can I use SpoolFlex/FormFlex commands in my CL program?
  A: You can use SpoolFlex/FormFlex commands in your CL program.
   
• Q: What are width and length limitations that SpoolFlex has for converting to PDF or Excel?
  A: SpoolFlex does not have any limitations, but IBM limits a spooled file to 378 characters wide. Versions of Excel older than 2007 have a limit of 65,000 rows. With Excel 2007, the limit has been raised to over 1 million rows.

Training Schedule for July and August

SpoolFlex Basic Training

If you purchased one-time training and have not yet attended, or if you have purchased our one-year unlimited training, we hope you can join us in one of the upcoming sessions. You can register by clicking on one of the links below, or you can check the upcoming training schedule by logging into our Customers page and then clicking on the “Training Schedule” link located on the right side of the page.

(PREREQUISITE: Familiarity with AS400 environment and commands)

SpoolFlex basic training will give you the tools to start converting reports to e-Formats. This basic overview of the product is designed for new SpoolFlex users. If you have been using SpoolFlex for an extended period of time and have specific questions regarding your spooled files, please give us a call and we will be happy to help you one-on-one.

SpoolFlex features covered in this training session:

• Overview of the SpoolFlex Main Menu
• How to manage Spooled Files Menu option
• Converting reports to PDF using Manage Spooled Files Menu option
• E-mailing reports using Manage Spooled Files Menu option
• Output Definition
• Converting reports to Excel
• Address Books
• Spooled Data Map
• Report Distributions
• Spool Sentry

***IMPORTANT***: Before registering for our Webinar, please check all your e-mail spam filters to make sure that all CITRIXONLINE.COM correspondence is allowed to go through. Upon registering, make sure you receive a confirmation e-mail by the end of next business day. The e-mail states “Thank you for registering for:” and contains a link to join the Webinar. If you have any problems, please contact DRV Tech Support at support@drvtech.com.

July Schedule

Session 1: Thursday - July 9, 2009  10:00 AM - 12:00 PM EST
*REGISTER HERE* for this date

Session 2: Thursday - July 30, 2009  3:00 PM - 5:00 PM EST
*REGISTER HERE* for this date

August Schedule

Session 1: Thursday - August 13, 2009  10:00 AM - 12:00 PM EST
*REGISTER HERE* for this date

Session 2: Thursday - August 27, 2009  3:00 PM - 5:00 PM EST
*REGISTER HERE* for this date

SpoolFlex Advanced Training

Using SDF in the e-mail subject: This class will demonstrate how to include data from your spooled file in the subject of the e-mail that you send through SpoolFlex’s Report Distribution tool. This is a short class that is designed for users who already have experience creating Output Definition, Report Distribution, Spool Sentry and now would like to further their knowledge of advanced features.

SpoolFlex features covered in this Training Session:

• Address Book
• Spool Data Map
• Output Definition
• Report Distribution
• Spool Sentry

July Schedule
Thursday, July 16, 2009  3:00 - 3:30 PM EST
*REGISTER HERE*

System Requirements:
PC based attendees: Windows® 2000, XP Home, XP Pro, 2003 Server, or Vista
Macintosh®-based attendees: Mac OS® X 10.3.9 (Panther® ) or newer

Recent Additions to the DRV Family of Customers

• Alleson Athletic
• Canada Power Technology Ltd.
• City of Bountiful
• Easley Combined Utilities
• Far Northern Regional Center

• Hudson Valley Bank
• Jackson County School Board
• Lasco Fittings, Inc.
• Lawrence Transportation Company
• YMCA of Greater Louisville

SpoolFlex automates delivery of reports electronically to eliminate printing and manual distribution. SpoolFlex AS400 Excel and PDF conversion gets data where users need it, without hardware, and at the speed of light

FormFlex (the native iSeries software) lets you print electronic forms and checks on standard HP-compatible laser printers using plain cut sheet paper. It also allows you to copy them to PDF to automatically e-mail, fax and electronically file to network file servers. No PC hardware or custom programming is required.

ReportFlex allows you to reformat reports into easy-to-read and easy-to-manage reports without any programming. Its features include changing column headings, inserting lines, and inserting page breaks.

eSign, an electronic signature software, allows you to electronically sign your documents to print on laser printers.

Call for a FREE demonstration, or go to http://www.drvtech.com/evaluation.html

Not currently subscribed? Click here to receive future editions of our newsletter.
To remove your name from our e-newsletter mailing list, click here.
Questions or comments? E-mail them to us at editor@drvtech.com or call (678) 417 1521.
© 2009 DRV Technologies, Inc.