Objectives

• To learn how to use the LANSA User Agent to send and receive a CSV (comma separated values) file from a PC to a LANSA function running on an IBM i or Windows Server.

• To learn how to upload data from an Excel spreadsheet to an IBM i or Windows Server.

• To create a server side RDML function that receives the CSV or Excel file sent by the LANSA User Agent, reads the data, processes it, and sends back a response to the LANSA User Agent.

• To show how the LANSA User Agent can be executed in batch mode.

To achieve these objectives, you will complete the following:

• Concepts
• Step 1. Create a User Agent Solution and edit Host Properties file
• Step 2. Create a CSV file with Column Headings to Send
• Step 3. Create a Server Function iiiFN03
• Step 4. JSMDirect Service Configuration
• Step 5. Test iiiFN03 function
• Step 6. Ignore the Column Headings
• Step 7. Using a CSV without Column Headings
• Step 8. Sending an Excel spreadsheet. Optional
• Step 9. Invoke User Agent in Batch Mode. Optional
• Summary