The current exchange rate upload into our system is a manual process and following steps are involved.
Step 1 - daily exchange rates are received via email
Step 2 - copy and paste the data into an upload template
Step 3 - Upload template into our system
We are keen to have an automatic upload of the information from the email into upload template therefore reducing the manual copy and paste function which may casue errors.
This template should also have the function to clear the previous/old data for each completed upload. This will therefore only require creation of one single template for each upload.
The following atatchements are included for refernce purposes.
1. Copy of daily email advice with exchange rates
2. Copy of the current upload template
3. Copy of the completed template for upload
The template can be either in Excel (xls) format and or Tab delimted (Txt) format.