Smart CNC Tools

1
Smart CNC Tools

• Making CNC work for you, not the other way around

2
About Us

• Pastuhov Consulting was founded in Melbourne in
  2003 by an ex-J.D. Edwards Senior Technology
  Consultant
• Offers include CNC Services and Software
  Canned Expertise, if you wish as well as
  Windows / UNIX tools and scripts and Oracle/MS
  SQL database administration
• About a dozen software products on the market
  now, the list is growing
• Many international Customers
• Our vision is to build a competitive,
  Australian-owned company - software vendor for
  this market

3
Such Is Life

• CNC is 2/3 science and 1/3 voodoo.
• (Unknown XXI century philosopher)
• Approximately 1/3 of all implementation issues
  are ultimately CNC-related
• Most of JDE manuals contain misleading or
  incorrect directions
• A huge class of standard tools and APIs are not
  documented
• There are many areas where the provided tools are
  either non-existent or grossly inadequate

4
Common CNC Issues

• Re-using Objects, plus Object copying, backup,
  versioning, upgrade, remote development,
  development in Standalone version
• Automatic printing and e-mailing of reports
• Documenting and comparing Processing Options and
  Data Selections
• Changing certain settings on the fly Print
  Queue Names in Batch Versions, toggling DEBUGLOG
  flag, printing Data Selections on the Cover Page,
  etc.
• Avoiding running jobs with wrong Data Selections
  the need to make Data Selections mandatory
• The lack of built-in FAX capabilities
• Setting up and testing complex security
  configurations
• Issues caused by cached Data Selections on the
  Servers
• Automating Terminal Server Deployment
• Compiling a list of installed Clients along with
  the latest Full and Update Packages deployed on
  them
• Entering multiple translations of Program Titles,
  etc.

5
DebugLog Commander

• Toggle the Debug Logging flag On and Off on the
  fly at runtime, including Server Processes,
  running on Wintel Servers.
• Open JDE.INI, JDE.LOG, JDEDEBUG.LOG.
• Clear JDEDEBUG.LOG.
• Saves time for developers

6
Boomerang - features

• Object Export and Import a better alternative
  to Product Packaging for Remote Development
  Software Distribution.
• Tightly integrated with OneWorld /
  EnterpriseOne - making it do what we want
  through the use of C API calls. Very fast and
  secure.
• Fully automatic, self-configuring software
  reads all necessary settings from your system. No
  training requirements.
• Cross-release compatible (B7333 B9), can work
  with Standalone version.
• Packages are encrypted and compressed.
• Freeware Import-only version Boomerang Lite,
  plus a collectionof Boomerang Packages.
• Saves time and money, offers extraflexibility,
  minimises risks, ensuresbetter software quality

7
Boomerang - uses

• Packaging re-usable code, sharing or selling
  custom development work think Active-X
• Speeding up Upgrades just copy Objects around,
  instead of doing Spec Merge you can continue
  Development even during Upgrades
• Remote Development and QA Testing even in
  Standalone
• Object Backup and Versioning cherry-picking
  SARs from ESUs
• Simple, fast and more reliable than Product
  Packaging, copies entire Objects, including all
  language translations
• General CNC Troubleshooting recovering lost or
  corrupt Objects
• Used by many customers world-widefor its many
  unique features

8
Update Queue Namesin Versions

• Readily change Print Queue Names in Batch
  Versions in seconds.
• Toggle the printing of the Data Selections on the
  cover page to document the actual DS at runtime.
• Saves time, allows to move versions from Queue
  to Queue necessary when renaming or removing
  Queues.
• Makes it possible to assign Versions to Queues by
  the System Code, or by the Version name.
• Our best selling software tool many reference
  sites worldwide.

9
Data Selections Commander

• Easily document Data Selections of your Batch
  Versions
• Output easy-to-read, colour-coded PDF
• Lightning fast and very easy to use
• The tool has data selections to limit the output
  to selected ranges of Batch Program Versions
• The data are read from the Central Objects
  Datasource through OneWorld / EnterpriseOne C
  APIs, so there are no hardware/software
  dependencies
• There are no standard programs to do this in
  OneWorld / EnterpriseOne

10
Data Selections Commander(continued)
11
PO Commander

• Easily document Processing Options of your
  Interactive and Batch Versions
• Output colour-coded PDF, XLS or HTML
• Lightning fast and easy to use
• The tool has an SQL data selection entry field to
  limit the output to selected ranges of Versions
• The data is read directly from the Central
  Objects Datasource, there are hardware/software
  dependencies
• This tools also highlights any corrupt POs, the
  unavoidable result of Upgrades or applications of
  ESUs and Updates, which can cause many problems
• The standard program to do this in OneWorld /
  EnterpriseOne is just not powerful enough

12
PO Commander(continued)
13
PO Commander(continued)
14
Security Commander

• Easily visualise and document your Security
  configuration in a tree-like structure, from the
  Application Security down to Form, Tab, Exit,
  Action and Row / Column security.
• Fast and very easy to use, has some data
  selections to limit the output
• The data are read through OneWorld /
  EnterpriseOne C APIs, so there are no
  hardware/software dependencies.
• What level of Access does a specific User have?
• A visual and interactive, very easy to understand
  display with the ability to save the output in
  colour-coded PDF files for future reference.
• A must for professional security audits there
  is simply no other means to present this
  information in an easily readable format.
• Future versions will offer a reverse
  representation, answering a Who has access to a
  specific Object? question.
• A form of Segregation of Duty Analysis is planned
  for delivery in the future.

15
Report Client Packages

• In companies with many Client computers and
  frequently changing staff, it is easy to have
  Licenses lost.
• Update Packages are defined for specific Parent
  Full Packages and must only be deployed on top of
  these Packages, which makes it important to
  compile reports of the last Full Packages
  deployed to the Clients.
• Update Packages may contain critical fixes, so
  any computers without these fixes must be
  identified ASAP.
• There are a few different ways to report this,
  but none is very reliable.
• The Report Client Packages tool collects this
  information directly from the Client computers.
• Very easy to use, saves time collecting this
  information.
• Both last Full and any last Update Packages are
  reported per PathCode, per Client.
• The output a CSV file can be read in MS Excel.

16
Print Immediate

• This software is not a standalone program, but a
  piece of custom development work done within
  OneWorld and then Exported with Boomerang.
• It has been exhaustively tested and is in
  production use by many customers worldwide.
• The code installs in seconds with our freeware
  Boomerang Lite and can be deployed to the Servers
  within a few more minutes.
• This software allows configuring selected
  UBEVersions to automatically print the PDF file
  to a nominated printer and/or e-mail it to the
  submitting user.
• Saves time and frustration to the users,
  eliminates human errors.

17
Cleanup Data Selections

• This software is a Boomerang Package.
• The common issue it resolves, is deleting of any
  server-cached Data Selections, for the UBE to set
  the desired Data Selections programmatically.
• Without doing this, the DS set programmatically
  are joined with any cached DS for the same
  UBEVER, producing unpredictable results.
• This is a fix for a design bug in OneWorld.

18
Mandatory Data Selections

• Again, this software is a Boomerang Package.
• The common issue it allows to solve is preventing
  users from running UBEVER with incorrect Data
  Selections.
• Without taking any special measures, a job run
  with incorrect DS can produce unpredictable
  results, run a lot longer or corrupt the data,
  which can be very costly to rectify.
• Improves the standard processes, offering a level
  of protection against human mistakes.
• Saves on consulting fees to recover the system.

19
Simple FAX

• This software is a Boomerang Package too.
• It allows faxing of PDF files and any other
  documents directly from OneWorld.
• This code can be combined with our Print
  Immediate software to allow automatic faxing of
  the Invoices and such to your Customers and
  Suppliers.
• Normally, if faxing is required, an expensive
  Forms Printing software is used, but if faxing is
  really all that is required, Simple FAX solution
  is much more cost-effective.

20
FAX Commander

• This software is a standalone Windows console
  program, with a command-line interface.
• It allows faxing of PDF files and any other
  documents from Windows scripts.
• This software can also be used to automatically
  FAX the Invoices and such to your Customers and
  Suppliers.
• Simplifies administration, saves on expensive and
  complex FAX solutions.

21
TSE Commander

• This software is a standalone Windows console
  program, with a command-line interface for
  automated software deployment to Windows TSE.
• As an example, OneWorld Deployment, when done
  manually, can take up to an hour per Server, due
  to the need to
• Disable new connections
• Identify and notify all connected users
• Wait until such users disconnect
• Kill any remaining sessions
• Switch into Install mode
• --- DEPLOY ONEWORLD ---
• Switch back into Execute mode
• Enable new connections
• Imagine how much time (Downtime!) would such
  manual deployment take for 10 Servers? 50
  Servers? All night?
• 50 servers can now be done automatically in an
  hour, possibly keeping the number of temporary
  inactive servers down to a few at a time, to
  minimise any disruption to your operations. Saves
  time and frustration.

22
Translate Program Titles

• There is no standard way to have Program (UBE or
  APPL) Titles translated into different languages,
  although Standard Programs come with
  pre-Translated Titles.
• For multi-language installations, this can be
  considered an issue.
• This tool offers a simple and intuitive way to
  translate such Program Titles, or change any
  existing translations.
• We also have a freeware companion Boomerang
  Package, which delivers modified versions of the
  standard bv and iv programs, that display
  this translated text, based on the current users
  language preference standard OneWorld does not
  do this.
• Offers new functionality.

23
Future directions

• Many development ideas are being evaluated.
• Users input is most welcome.
• Custom-built tools and scripts created for your
  unique Windows, UNIX, Database or CNC
  environment.
• Advanced API / SPEC Programming Training.

24
Questions?