Navigate Here: Utilities > Currencies > Browse Actual Exchange Rates; click the Import icon or
Utilities > Entity Data Management > Import Entity Data
Instead of adding actual exchange rates into CIPAce system one by one, you can import a batch of actual exchange rates into the CIPAce system from an Excel file.
Add an Excel template
Before you start importing actual exchange rates, you must first create a template if there is no existing one in the system. Go to the Add Excel Data Template page through the entrance: Utilities > Templates > Excel Data Templates > click the Add icon.
First, enter a Template Name for the template.
Then, select "Currency Exchange Rate" as the Entity (you can check "Is Default" if you want to set the current template as the default Excel template for the selected entity). As soon as you finish selecting the Entity, all required attributes will be automatically loaded in the below grid. If you want to add more attributes (non-required ones), you can click the Add icon to add those attributes. If you want to remove some attributes (non-required ones), you can select them and click the Delete icon. You can also select one or many attributes and click the Up or Down icons to adjust their order.
Finally, click the Save button to save the template. System will then go to the Browse Excel Data Templates page. You can click the Download icon on that page to download the Excel template you just created.
Create a data file
Now, open the downloaded template in Microsoft Excel and fill in all the actual exchange rates you want to be imported into the CIPAce system. Please DO NOT enter "Exchange Rate Set Name" for actual exchange rates though it has been marked as required. Also please make sure that the "Currency Code" you entered exists in CIPAce and has been used as a currency of your organization. Otherwise, those records will fail to be imported.
Import exchange rates
After you finish creating the Excel file that contains the actual exchange rates, you can start to import those exchange rates. Access the Import Excel Data page through either of the following two entrances:
Entrance 1: Utilities > Currencies > Browse Actual Exchange Rates; click the Import icon
Entrance 2: Utilities > Excel Data Management > Import Excel Data; choose "Currency Exchange Rate" as the Entity
To import your actual exchange rates, take the following steps:
First, select a template. Please note that the selected template must be the one used by your Excel file to be imported.
Then, click the Browse button to select the excel file you have created from your local machine.
Then, modify the default email address that comes from your account in CIPAce if necessary, and you can also add more addresses.
Then, decide whether to include list of failed or successful records as email attachment (they were checked by default).
Then, decide the default handling of duplicate records: Ignore (checked by default) or Replace.
Finally, click the Import button to start importing the actual exchange rates. After some time, system will finish importing exchange rates from the uploaded file, and a notification email will also be sent to the specified email addresses.