Programming by Design

Committed and dedicated to optimal, timely, customer-facing solutions.

Andrew J Walker - and Associates : Specialist Solution Finders for ERP Client Requirements.


I have over 40 years experience of working on Protos and Tropos products.

I specialise in client-side customisations - particularly TroposForm, TroposActive, TIGI (Incoming Generic Interface) Applications, Application Designer (html and javascript), designing and maintaining database objects (views, functions, packages) for ERP and CODA, on SQLServer and Oracle databases, designing and maintaining Web Applications and Desktop applications on SQLServer and Oracle databases. (This last area requires the customer to have acquired an appropriate licence from the owning company.) I often work in conjunction with ergoErp.

So, what does this mean? and how may I be able to help you?
The White Paper Printing product ("wpp"): ajform (also known as TroposForm).

This product uses data files output by various print-orientated transactions (Sales Invoices, Despatch Notes (Bill of Lading), Purchase Orders - and a hundred more) and formats them for printing, emailing, EDI ... or wherever they are to be directed.
As the original author of this product, I am highly experienced in design, development, and problem-solving. I like to generate documents with a professional appearance.
  • You might want to use consistent fonts to replace the common package document format of a random mixture of Arial and Times New Roman. You might want to use a proportional font on Intermec labels, and not the standard fixed-width font.
  • You might want higher quality logos on documents when using pcl5 or pcl6 - or you might want a colour logo on emails.
  • You might want to print to any type of printer - Zebras? Brothers? ... (using available printer drivers), and not just the officially supported HPLasers and Intermec printers.
  • You might want to "      right-justify" fields.
  • You might want to conditionally override the DPMT output parameters.
  • You might want to create entirely new variants of existing documents, or create documents from transactions that don't produce documents as a rule - via TroposActive.
  • You might want to sort data into an eccentric sequence.
  • You might want ... - why not let me know?
Tropos Active - or TroposActive

Tropos Active can be used to respond to an update transaction being executed in Tropos and can trigger four (yes "four" - some sources say "three") different event types: the sending of emails, the execution of a Tropos transaction (or a "family" of Tropos transactions defined via TBPA/TIAD, nestling together as part of one interface), the generation of a document or documents via TroposForm, and executing system commands. There can be any number of these events triggered by a Tropos update transaction - the only limit is that there can be only one "family" of transactions that actually gets executed.
[I included the system-command option when I developed TroposActive in 2002 - and, lo and behold, it proved useful/vital for the first time this year!]

I specialise in designing, developing, amending and debugging 'TroposActive' workflow routines triggered by database transactions including the definition of rules, procedures for database access and message formats.
I also specialise in developing and customising other client-side elements:
  • Designing and maintaining TIGI parameters.
  • Designing, developing and amending Application Designer (html and javascript) Applications.
  • Designing and maintaining database objects (views, functions, packages) for ERP and CODA, on SQLServer and Oracle databases.
  • Designing and maintaining Web Applications and Desktop applications on SQLServer and Oracle databases.
  • Designing and maintaining scripts for Telnet sfdc applications. [This product is now a little passé. Once upon a time it was the only client-side-customisable client - when the product platform was UNIX(!).]
Recent testimonials from customers: "Perfection!" (SQ), "That man's a genius!" (AE).
For more information please contact Andrew Walker via email: info@programmingbydesign.com
or call +44 (0)7703 320978
    
TroposForm ajform Tropos Form TroposActive "Tropos Active" Application Designer ERP Protos AppDes TDK TDDK epicor