We at International Spectrum (Nathan, Tracey, Clif, and Nicholas) would like to wish you a happy and safe holiday season. We appreciate your readership and participation in the MultiValue Market and in International Spectrum events.

We hope you have a Merry Christmas! Happy Hanukah! Joyous Kwanzaa! and a Happy New Year!

Since the introduction of wIntegrate 6.0 in December of 2004, IBM has released two major patches for wIntegrate. wIntegrate 6.0.1 was released on June 24, 2005. wIntegrate 6.0.2 was released on April 25, 2006. These patches have provided substantial additional function for wIntegrate's users including:

Query Builder supports UNLIKE operator

The Query Builder has a dialog to specify selection criteria for host items. This dialog now supports the UNLIKE operator.

The Script Monitor has an email button

If an error occurs in a script, the script monitor dialog appears. This dialog now has an email button. If a MAPI-compliant email client is running, a new email is generated and displayed, ready for the user to send. The email contains details of the script error and a bitmap of the application screen.

Type-ahead in dialogs

All GUI dialogs now support type-ahead. This applies to the local-install version, the Windows thin client and the Java client.

Java client improvements

The Java client has many enhancements, particularly for host-driven GUI applications. Some specific improvements are:

• Java client can copy bitmaps to Clipboard
• Prompts to allow SSL certificate which cannot be verified by the Java client

Java client and SSL certificates

wIntegrate Server configuration now supports SSL to secure communications with the Windows or Java thin clients.

Support for Thai Language

The emulation screen supports Thai in the display and keyboard input.

The Setup Terminal dialog has a new option "Thai for Host Encoding". Multiple sessions can be run at the same time, each with a different language, for example English, Chinese and Thai. The Windows and Java thin clients do not support Thai.

PDF output for report writing

The Query Builder and Report Wizard can create reports in PDF format. A Format button lets you choose page size/orientation, fonts, etc.

High speed data transfer using UniObjects

wIntegrate now supports UniObjects for data transfer. This is an alternative to FTP. UniObjects has the added advantage of supporting SSL for secure connections.

Get a trial version

Attend the Premier MultiValue User Event
March 6 - 9, 2007

Get the most value packed week of Training in some of the following topics:

• IT Management
• Database Administration
• Web Development
• Business Intelligence
• Tools and Connectivity

More Info...

Execu-Sys, ltd - Positions Available

Growing manufacturing company in Orange County, CA has an opening for an experienced PICK programmer; EPICOR experience highly preferred. Salary 70-90K (local candidates only); excellent opportunity to crosstrain Web & Datawarehouse technologies.

For additional information contact Matt Hart @ (800)423-1964 x302 or mh@eslny.com
 

Unidata-System Builder Programmer / Technical Analyst / Project Manager Position in Chino, CA

Tools set:
Unidata, UniBasic, System Builder, AIX, Data Warehousing (specifically MITS Data Warehouse)

Primary Focus:
Maintaining MITS data warehouse, report writing using System Builder & UniBasic or other tools
Data validation of our Unidata database & MITS, Unidata File Sizing, Application Integration with main business application (Unidata Database) and third-party bolt-ons, Data Uploads & Data Extractions
Assisting with upgrades & new module rollouts, special projects as they arise (portions of e-commerce & EDI), automating procedures. Project management of outside contractor/programmers.

Soft Skills:
Collaborative team player, Independent judgment. Written & Verbal communication.

Benefits:
Fun Environment
Appreciation of work
Internal growth – lots of diversity over time
Vacation (2 weeks; 5 years = 3 weeks; 15 years = 4 weeks), Holidays (7 annual days), Sick Pay
Health Insurance (Medical, Dental, Vision)
Life Insurance
401 (k) Plan
Profit Sharing at employer’s discretion

Contact Candace Bywater, Information Technology Applications Manager (cbywater@hipco.com)

Harrington Industrial Plastics, LLC
14480 Yorba Avenue, Chino, CA 91710 (800) 669-8641

We have all written programs to create comma delimited files for import into Excel. Check this .csv out.

"Product","Qty","Dollar","Extend Dollar"
"500-12","12","$100.00","$1200.00"
"389-HW","1","$50.00","$50.00"
"9088-9","2","$75.00","$150.00"
"19879-FIL","1","$20.00","$20.00"
"9876-98","1","$10.00","$10.00"
"75-P","3","$5.00","$15.00"
"","","=SUM(C2:C7)","=SUM(D2:D7)"

Quite ordinary wouldn't you say? But examine the last line. Instead of adding the Dollar and Extend Dollar columns in the program, insert the Excel formula to do the calculation in the spreadsheet. Those with keen eyes will notice that the same thing could be done for the Extend Dollar column.

Lee H. Burstein, President
Dynamic Systems, Inc.