1 / 24

Overview: Email Acknowledgement

Overview: Email Acknowledgement. SMTP Server Configuration Email Acknowledgement Exercises LIC006 – LIC008 Objective: To understand how to set up an email configuration with LANSA Composer. Exercise Preview. About LIC006 – Email Acknowledgement

krysta
Download Presentation

Overview: Email Acknowledgement

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. Overview: Email Acknowledgement • SMTP Server Configuration • Email Acknowledgement • Exercises LIC006 – LIC008 Objective: To understand how to set up an email configuration with LANSA Composer.

  2. Exercise Preview About LIC006 – Email Acknowledgement • Add Email Acknowledgement to the Processing Sequence

  3. Email Setup • SMTP Server Configuration

  4. Email Acknowledgement • SMTP Mail Details Configuration

  5. Exercise LIC006 • Add Email Acknowledgement to the Processing Sequence

  6. Exercise Preview About LIC007 – Extract Database to CSV File • Create transformation Map from DB to CSV • Add Database file • Add CSV File • Define map • Create processing sequence to define selections criteria and output filename • Run transformation

  7. Transform Map – Insert Database Define table relations 7

  8. Transform Map - Insert Database • Database relations defined PSLMST=>DEPTAB and DEPTAB => PSLMST

  9. Insert Text File

  10. Define Mapping / SQL Where

  11. Function / Insert Input Output to CSV file if DEPTMENT = input parameter Department_In

  12. Prepare Map

  13. Processing Sequence #1 Add Transform Map and define EARTHSourceConnection parm.

  14. Processing Sequence #2 • Use Map variable iiiTUTMAP03_2 to add an input parameter to Processing Sequence – the Department code to be selected • Second parm, define as FILENAME – will be used by CONCAT to create output path\filename • Give them suitable descriptions • Default Value may be specified

  15. Processing Sequence #3 • Add CONCAT activity • Define inbound parameters values • Path • &FILENAME = value of input parameter FILENAME

  16. Processing Sequence #4 • Output from CONCAT = Map variable “output path/filename”

  17. Exercise LIC007 Extract Database to CSV File • Create transformation Map from DB to CSV • Add Database file • Add CSV File • Define map • Create processing sequence to define selections criteria and output filename • Run transformation

  18. Exercise Preview About LIC008 – Processing via Email • Extend LIC007 - Extract Database to CSV File • Retrieve selection criteria from an email • Transform DB to CSV • Send CSV response as an email attachment

  19. Server Folders • \_EmailSkeletonswill contain a text file which is used to produce the body of the reply email. • \_SentEmailwill be used for output and will contain the reply email text and Employee CSV file. • \iiiReceivedEmailwill be used to save the email message received via POP3

  20. POP3 Mail Configuration

  21. SMTP Mail Details

  22. Email Response Text • Text file which provides a template for the email reply text • %%PARM.TONAME%% and %%PARM.DEPARTMENT%% replaced with variable value at runtime • Save as iii_EmployeeInfo.txt

  23. Processing Sequence

  24. Exercise LIC008 Processing via Email • Extend LIC007 - Extract Database to CSV File • Retrieve selection criteria from an email • Transform DB to CSV • Send CSV response as an email attachment

More Related