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