1 / 14

Automating Processes

Automating Processes. Let Informer do the heavy lifting…. PRESENTER: Tim Nicholson | Title & Organization | Date. Automating Processes. Using TCL/ECL Using the Scheduler. TCL/ECL. U2 only Executes database commands Query statements Paragraphs BASIC programs OS Scripts

licia
Download Presentation

Automating Processes

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Automating Processes Let Informer do the heavy lifting… PRESENTER: Tim Nicholson| Title & Organization| Date

  2. Automating Processes Using TCL/ECL Using the Scheduler

  3. TCL/ECL U2 only Executes database commands • Query statements • Paragraphs • BASIC programs • OS Scripts Matt Rees, Entrinsik

  4. Automating Letter Generation Past due notices Previously required user interaction Eliminated the need for user interaction Automatically generated based on the schedule

  5. Compound Condition using the “At least one of…” as a condition selector

  6. In the first section of the compound condition, we entered a TCL command to remove all entries from the previous run

  7. In the second section, we entered another Compound Condition, this time using the “All of…” as a condition selector.

  8. This is the criteria used to obtain our list of overdue clients.

  9. Execute a series of TCL commands. • The third statement takes the records selected by Informer and sends them to SEMtek process LETTER.PRINT.AUTO using the STATEMENT parameter. • Here our letters are generated.

  10. Results are returned back to Informer for final reporting.

  11. Results The Informer report shows the clients which had a statement generated. The actual statement was generated from within SEMtek We plan to offer this feature to our SEMtek clients in the near future. We also have ideas that can simplify this even more. * Actual figures used come from test database

  12. Next Phase Automatically email letters Eliminate human intervention Free up valuable internal resources.

  13. Scheduler Run reports off-line Email results Export results • File • Savelist (U2 only) Susan Fenn, Wake Tech

  14. Thank you! Any questions?

More Related