WebSmart 6 Beta Available Soon

The WebSmart 6 development team is putting the finishing touches on the upcoming release of the software, and we are now accepting beta applications. You can request the WebSmart 6 beta at our web site.

WebSmart 6 includes many new features, including these highlights:

  • The inclusion of SmartCharts at no extra cost, allowing you to create dozens of styles of graphs and charts.
  • A powerful interactive debugger fully integrated into the IDE.
  • Improved integration with Nexus.
  • Numerous PML syntax enhancements, as well as improvements to existing functions.
  • Expanded template capabilities and improvements to style sheets.
  • Many improvements for installing and operating in non-English environments.
  • Piping support, to write data to web services, the IFS and email.
For those of you who have participated in previous WebSmart beta programs, you are already familiar with the high quality of both the beta versions and our developers' response to any issues you have encountered. For first-time candidates, we invite you to try us out! By participating in the beta you get the earliest possible access to all the new features, as well as a voice in how the new features will ultimately work in the production release.

If you have any questions about the upcoming release, or any of the new features, please contact Technical Support.

Upcoming WebSmart Training Seminars Scheduled

A WebSmart Fundamentals Public Training Seminar has been tentatively scheduled for June 26-29 in Jacksonville, Florida. If you would like to attend this class, or need additional information, please fill out our Training Request form.

The training seminar will be held at the Sea Turtle Inn in Jacksonville Beach. For additional details about this seminar, or the accommodation, please contact Tech Support

We have also scheduled an Advanced WebSmart Public Training Seminar for June 26-29. Again, if you are interested in attending either this class or another one coming up in the spring/summer please fill out the Training Request form at our web site.

This Advanced seminar will be held at our technical headquarters in Victoria, B.C. Victoria, B.C. is approximately 70 miles North West of Seattle Washington and 40 miles South West of Vancouver, B.C., so you can fly to either city and catch a commuter to the Victoria International Airport from there. For more information on office location, accommodations, and things to do please visit our training page by clicking here. For further details please contact Tech Support.

Seminar dates are currently tentative. Anyone enrolling in the course will be notified on or before June 7 with confirmation of the scheduled dates, allowing over 2 weeks to make the necessary travel plans.

BCD @ iSeries Core Decisions Conferences

BCD will have a sales team at the upcoming iSeries Core Decisions conferences on June 27 in Columbus, OH and June 29 Dallas, TX. If you plan to attend either of these events, we hope to see you there.

For further information on these events, the speakers, and the topics they will be addressing, you can visit the iSeries Network Roadshows page.

BCD will also have a booth at the upcoming Michigan iSeries Technical Education Conference, June 6 in Dearborn, MI.

Clover Feature Profile: Importing and Exporting

One of the most visible differences between Clover programs and the programs generated with WebSmart templates is in the amount of PML visible to work with in the IDE. This is because Clover is primarily targeted at a slightly different audience then WebSmart: rather than tailoring the templates for experienced programmers, we're aiming to make the report design process accessible to anyone at your company with a knowledge of your database, and who has the need to create reports.

As a programmer or a power-user, your initial reaction to this approach may be to think that while it simplifies the complexities involved in the initial development of a program, it also signifies Clover's reliance on wizards. You may think this means that every report has to be started from scratch. In a programming environment, this would be anathema, not to mention a significant waste of time.

Fortunately, this is not the case. Clover includes features that allow you save the SQL you have constructed during the wizard phase of a report's design, and import that information to another, new report, to then be tailored as required using the same wizard screens.

Saving a Query
To use an existing report as the starting point for creating a new one, you first need to save your original query. Here are the SQL attributes for an existing report, and the window from which we can save our SQL:

We accessed this window using the 'SQL' option in the WebSmart IDE Attributes menu. As you can see, our report includes several files and calculated fields, as well as all the other standard elements of the design - the report fields, sorting and level breaks. In the illustration above, we are about to click the Export Query button on the right.

When you export your query, Clover prompts you to save a file with an extension of '.sql', and defaults to the name of your program. For this example, we created a new folder on a shared drive, and save our query to it. After saving our file, we can exit the report.

Importing an Existing Query
The next step is to begin creating a new report. When you create your new report, you will define all your program attributes in the same way as you would for any report. Then, at the Files list, you need to cancel the Add File window that is automatically presented. This allows you to then click the Import Query button and select the SQL file you previously saved:

Once you have imported the query, you can continue to work through the standard wizard screens to design your report. However, instead of having to build everything from scratch, you'll be using your saved query as a starting point.

When you save your sql, the following information is included in the file:
  1. The SQL statement
  2. Each field and whether it is visible, subtotaled and/or a level break.
  3. Each calculated field and its attributes, description, formula and type (derived or summary).
  4. Each input value work field (the parms), with its description, attributes and type.
Clover 1.13 is now in General Availability. You can download the software from the Free Software Downloads area of our site. If you have any questions about Clover 1.13, please contact Technical Support.

Nexus 3 Feature Profile: User Groups

While 'groups' have existed in Nexus since earlier releases, in Nexus 3 we have greatly enhanced the functions available through the creation and management of user groups. The changes and new features include:
  1. You can now grant authority to group managers to create users and subgroups. This allows the site administrator to share the duties involved in creating and managing the site's users.
  2. Group inheritance allows you to work with your users in a tree-structure where you can structure branches that are dynamically updated when users are added or removed.
  3. Support for a group-within-group structure makes it much easier to establish and manage authorities, and users in general.
  4. You can establish group 'ceilings' whereby you can isolate branches from each other, effectively allowing you to manage groups of users as if they were part of entirely different sites.
  5. There is also a group setting that allows you to separate a group from others on the same branching level.
Here is an illustration of the group details window at the Wholesale Harmonics site:

To work with this page yourself, you can visit the Wholesale Harmonics Nexus 3 Demo Site and log in as user 'chopin', password 'martin'. Then click on the Manage Site link, and from the page presented, the Manage Groups link.

Here are few of the key features:

Tree View
In the upper left of the list is a tree view of your groups and subgroups, that also allows you to quickly switch to working with any group.

Working with Users

New BCD Business Partner: NewServ AG
Winterthur, Switzerland and Vienna, Austria
www.newserv.ch, www.newserv.at

NewServ Ltd. was founded in 1999, and our business coverage includes Switzerland, Austria and Germany.

Our Business strategy is to provide strategic IT consulting services to Business Partners, ISVs and end users for investment protection, with a particular focus on adding value to any kind of iSeries Solutions/Packages, and the integration of the iSeries server into open and heterogeneous networks in the i5 and Linux environment.

NewServ has been well recognized in the local market as a service and solution provider, and we have a comprehensive product portfolio to enhance iSeries applications and system functionality. We currently have a local customer base of over 80 ISVs and application developers, as well as approximately 200 prestigious enterprises including banks, manufacturers, IT Businesses (such as IBM), conglomerates and government departments using our enhancement tools and services.

In our relationship with BCD, our product focus for the local market is WebSmart, to work on extending existing iSeries applications to the growing demands of today's customer needs - extending the functionality of installed packages to the flexibility of WEB based solutions without having to reinvent the wheel.

Our credo to all customers and prospects: "we are providing tools and services helping our customers to reach their goals"

For additional information about NewServ Ltd, please contact Werner Neumann by email at info@newserv.ch, or phone 0041(0)52-224 04 40.

For information in German please see the NewServ Ltd. Products and Services list (PDF).

The menu on the left allows the group manager to create new users and work with existing ones. When you select the 'Users' link, the list displayed is color coded to show you which users were created directly within the group, and which users are members by inheritance.

Group Ceiling
The Group Ceiling checkbox allows you to set this group as a 'ceiling' to all other subgroups below it, effectively splitting this branch of the groups tree from all other Nexus users in the site. This is relevant to document and portlet authorities, as well as communication portlets (chatting, messaging).

Non-peer Group
This checkbox allows you to also separate this group from other subgroups at the same branching level of the tree. This means, for example, that even though you have sets of employees at your company on the same hierarchical level with regards to a management group, they don't also need to share authorities to documents and links.

These group features and others will make your Nexus 3 user groups a powerful tool for effectively and securely structuring the content of your site.

If you have any questions about Nexus 3, or would like a walk through of the new features, please contact Technical Support.

Nexus 3 Demo Site Now Online

As mentioned in the article above, the Nexus 3 version of the Wholesale Harmonics demo site is now accessible online. The updated demo site demonstrates many of the new features available in the upcoming Nexus 3. The site is updated nightly, so feel free to log in and play around with the features and make as many changes as you like.

Here are some of the highlights to look for:
  • When you log in as the site manager, Chopin Martin, you'll see a rich sampling of graphs and charts created with SmartCharts (available as part of Nexus 3) included in portlets.
  • The main page also includes a WebSmart portlet with a program over the invoices file.
  • Finally, in the bottom left is a portlet with the ECM navigator, which you can use to access much of the rest of the site content. As you use the navigator, notice the breadcrumbs in the header. Take a few minutes to experiment with navigating around the site using the breadcrumbs and the ECM manager.
  • Another key feature in Nexus 3 is 'Edit my Pages' option. When you click on this link (in the upper right of the page) Nexus reloads the entire page in Edit mode. In edit mode you can reorganize your page by dragging and dropping the portlets (using their headers) to a different location. You can also use the icons to edit your portlet settings. When you're done making changes, click on the My Pages option to return to the normal view.
  • It's also worth clicking on the Manage Site link and reviewing the new management options.
  • Finally, try logging in as a mere user (Wolfgang Collings) to see how you can control a user's access to various features and options.
Nexus 3 is currently in beta, and scheduled to be released soon. If you are interested in receiving a copy of the newest version of Nexus, you can request the beta below.

Nexus 3 Beta Available

The first wave of Nexus 3 betas has already shipped, and the installations have all gone smoothly. Over the next several weeks we will be releasing the Nexus 3 to a broader audience, so if you would like to participate in the Nexus 3 beta, please visit our web site to sign up.

Nexus 3 includes exciting changes in several main areas, including the Enterprise Content Manager (ECM; previously the WOW), group management, a new skins feature, a long list of user interface additions and enhancements, and a greatly improved calendar. For a more detailed overview of the features, please refer to the article in the April Tech Update.

Participate in the Nexus 3 Beta!
For further information about the Nexus Beta, please contact Technical Support, or directly visit the Nexus 3 Beta Request Form. By participating in the beta, you'll get early access to all these new features (most of which have been up and running in our internal portal for a few months now), and be in an ideal position to request modifications or further enhancements to better suit your own usage of the product.

If you have any questions about the upcoming release, or any of the new features, please contact Technical Support.

Catapult 6 Beta Available

The Catapult 6 Beta is now available for download. If you would like to participate in the Catapult 6 Beta, please fill out the form at our web site.

Catapult 6 is a major new release which includes many significant new features, including:
  • Support for polling PC directories and distributing PC files using the same grab rule features that you apply to iSeries files.
  • Grab-rule security, to specify who is authorized to view and edit specific grab rules.
  • CC and BCC emailing support.
  • Updated Console and Poller Configuration UI.
  • Support for retrieving distribution/mailing list values from outside files.
  • Support for mail group entry replacement values.
Support for polling network directories has been in particularly high demand, and we're sure you'll enjoy trying this feature out. Depending on the formats of the files you select, not only can you distribute them with Catapult, but you can also split and extract other data from them, just as you do with your iSeries reports.

If you have any questions about the upcoming release, or any of the new features, please contact Technical Support.

uniPHARM Wholesale Drugs Launches Wireless Handheld Device application

uniPHARM Wholesale Drugs is a cooperative organization, wholly owned by its shareholder customers. It is committed to satisfying the business, marketing and professional requirements of independent member pharmacies by providing one-stop shopping for high quality pharmaceuticals and consumer products at the best possible prices.

About the Project
In mid May, 2005 uniPHARM Wholesale Drugs contracted the BCD Consulting Group to develop a browser based application to replace their PC based Electronic Order Book System. Working with uniPHARM's IT staff, the consulting group delivered the application in just two months, it went live in early July, 2005. Now, one year since development began, uniPHARM member pharmacies use the system everyday. Jim McGrath, Manager of Information Technology with uniPHARM, says "The application has more than replaced an out-of-date system, it has delivered additional functionality based on our shareholder's business requirements. The adoption of the web-based ordering system has been very impressive."

Since the initial application was rolled out, uniPHARM and the BCD Consulting Group have worked on several user driven enhancements. These have included new modules to generate labels, enter and process claims, web reporting, enhanced search and credit stop functionality.

Order Entry via Wireless Handheld Device
Most recently, uniPHARM's Executive (based on input from a number of member pharmacies) requested the ability to be able to log onto and add orders via a wireless handheld device. The device, a Symbol MC50 equipped with barcode reader, is used by staff at uniPHARM member pharmacies. Pharmacy staff access the "Web Ordering" application via a secure login program written with WebSmart using the browser on the MC50. The device connects directly to uniPHARM's iSeries Apache server. The login and subsequent WebSmart programs have been written to work using the smaller screen resolution of a handheld device. As the staff member walks around the store checking product levels on shelves, they scan the barcode of inventory items that need to be ordered and enter order quantities in the handheld. They can later view and confirm the order on their PC's browser or complete the order and submit it to uniPHARM directly using the handheld device.

Project Development
Initial reactions by uniPHARM's IT staff to the request by the member pharmacies to use a handheld device were mixed. Most thought it would involve a considerable investment to make it happen. The initial step was to contact the BCD Consulting Group to discuss the project and to contract them to build a proof of concept application. Jim McGrath adds, "The initial Proof of Concept took only 6 hours to complete - this is another example of the rapid application development processes that BCD effectively employs, to the benefit of their customers". This proved that the application was feasible. Following the initial prototype, BCD was given the nod to do the application development. In total the process took less than 16 hours to complete!

Initial Reactions
The application has now been rolled out as a pilot project to a few of the member pharmacies who would best be able to test the new technology that facilitates this functionality. Things have progressed very well and uniPHARM expects to make this option available to many of their member pharmacies in the near future.

For further information about how this application was developed or for details on our consulting services, please contact Kevin Cronin.

 Summary List of Recent Updates

ProGen Plus 8.05
These are the latest ProGen Plus updates (all these require V5R1 or later):
  • PG8A005 - April 25, 2006 - Accum 5, for release 8.04. (Note: You must upgrade to 8.04 first before you upgrade to this release). Upgrade 8.05 includes updates PG8R0046-55 (7.62 Mb).

  • PG8R057 - 2006/05/15 - Fix issue where multiple /INCLUDE statements in usrcod was not permitted.
  • PG8R056 - 2006/05/01 - Fixed parameter list for ZDLTPDF which resolved the user code CALLSBR being inadvertently deleted.
Please visit the ProGen Plus Updates page for further information on the available updates.

WebSmart 5.27, PC Build 8756
WebSmart Build 8756 (2006/05/02) includes the following fixes and new features:
  • Hovering over a field will show its attributes
  • Improved klist tool-tipping
  • Better library list handling in SQL tool
  • Support for variable length fields
  • New wrtdta function (similar to wrthtml, but doesn't trim)
  • New template directive: Increment
  • New cool icon
  • A few other additional minor fixes
For additional information on this and other updates, please visit the WebSmart Updates page.

Catapult 5.71
Catapult 5.71 is now available for download from our web site. Version 5.71 includes the following features and fixes:
  • Resolved an exodus problem that sometimes caused message overflow errors to occur.
  • Resolved a problem during PDF creation that added a '\' character before parentheses.
  • Fixed an access violation that occurred while trying to modify a rule if you did not have a default printer installed in windows 2000 and 2003.
  • Extracted Data Values will now work correctly when the rule is run using ZRUNRULE.
  • In certain circumstances unassigned split segments were trying to send with a return address of **D-O-N-T-S-E-N-D**. This has been fixed.
  • A problem using Catapult on ports other than 2015 has been resolved.
  • The Console will no longer hang if you try and view a spoolfile that includes '{' and '}' characters that aren't part of formatting tags.
  • PDF and RTF documents will no longer convert a slash followed by numerics into their octal ASCII equivalents.
  • Resolved a problem where the port numbers in the exodus system list were not displaying correctly in the console configuration.
Please visit the Catapult updates page for further information.

File-Flash Plus 4.02
The following File-Flash Plus updates have been recently made available:
  • FFP40010 - 2006/04/27 - This update drastically reduces the wait time in building the result set when using the OPNQRYF on a non-keyed file in File Flash.
  • FFP40009 - 2006/01/19 - Allows you to properly export negative values to a CSV file. Please note, for this to work the "Choice for editing numeric fields" must be set for "File Flash Editing".
Please visit the File-Flash Plus Updates page for further information on the available updates.

© 2006 ExcelSystems Software Development, Inc.
ProGen WebSmart and ProGen Plus are Registered Trademarks in the US and Canada, and Trademarks in all other countries.
[an error occurred while processing this directive]