PC-iRoute case study
Extracting sales order details from an Excel spreadsheet to interface into an orders database on the iSeries.
Business requirement
Sales orders are received from certain customers as Excel spreadsheet attachments in emails. The data contained in these spreadsheets needs to be transfered to the iSeries for interfacing into the order processing system.
Using PC-iRoute
- A PC-iRoute script is created on the PC server to extract the required order information from the spreadsheet to append to an existing file on the iSeries
- Mail options are specified so that incoming emails with the order attachments are automatically detected, the attachment is saved to a file and the script is automatically executed
- An iSeries post processing option is specified so that a sales order interface routine is automatically run
Benefits of using PC-iRoute
- Achieved with no programming knowledge and in a very small time scale.
Back to PC-iRoute case studies
