You are here: Primavera Unifier Administration Mode > Cost Management Setup > About Currencies and Exchange Rates > Importing and Exporting Exchange Rates

Importing and Exporting Exchange Rates

You can create and update exchange rates through a CSV file. For example, you can import the exchange rates you are using in your enterprise resource planning (ERP) system into Primavera Unifier so that the rates match in both systems.

You can import exchange rates with a CSV file by doing the following:

• Export a copy of the CSV file structure.
• Populate the CSV file with currency rate information.
• Import the CSV file into Primavera Unifier.

To export a copy of the CSV file structure

1 Go to theCompany Workspacetab and switch to Admin mode.
2 In the left Navigator, clickStandards & Libraries > Exchange Rates. The Exchange Rates log opens
3 Choose File > Export. A confirmation window opens. You export the active exchange rates. Do one of the following:
• Click Open to open the file in Excel (or other editor that supports CSV files). You can save the file from here after previewing.
• Click Save to save the file to your local drive. Enter a name for the file and click Save.

To populate the CSV file with exchange rate information

1 Open Microsoft® Excel (or other program compatible with the CSV format), and open the exported CSV file.
2 Enter currency exchange rate information in the spreadsheet. The fields are discussed in the following table.

In this column:

Do this:

Currency Name

Enter the name of the currency. For example, United States Dollar. This currency name is not validated and is for reference only.

Currency Code

Enter a valid currency code. Only the Currency Code is required and validated.

1.0 Base Currency =

Enter the exchange rate for the currency. The number you enter rounds at ten decimal place. Enter numbers and decimal points only; do not enter special characters.

 

Note the following:

• Do not delete or change the order of the columns.
• Successful import creates a currency exchange rate set with the Active status.
• Only the currency code is validated, but Primavera Unifier will add to the exchange rate set the values you specify in the CSV upload file.
• Only the absolute value for the exchange rate is considered. If you enter a negative value, the negative sign is dropped and only the value is considered.
• You can enter new rates, or update existing rates.
• Only the first five decimal values of the exchange rate are imported; if less than five decimal values are entered, zeros are added during the import to add up to five values.
• If you remove an exchange rate from the CSV file, the rate is retained in Primavera Unifier, and is not deleted.
• If there are errors in the CSV file Primavera Unifier will not import the CSV file.
3 Save in CSV format.

To import the CSV file into Primavera Unifier

1 Go to theCompany Workspacetab and switch to Admin mode.
2 In the left Navigator, clickStandards & Libraries > Exchange Rates. The Exchange Rates log opens
3 Choose File> Import to import the completed CSV file.
4 Click Browse and navigate to where you saved the file.
5 Click OK to import.

Only files with exchange rate information in the correct format will be imported. If the upload fails, the CSV file will contain an error message that explains why the upload failed. The user who imported the CSV file is listed in the Audit log as the User.

To fix import errors

1 Re-open the CSV file.
2 Delete rows that were successfully imported.
3 Fix the rows that were not imported correctly.
4 Re-import the file.

To export exchange rates to your desktop

1 Go to theCompany Workspacetab and switch to Admin mode.
2 In the left Navigator, clickStandards & Libraries > Exchange Rates. The Exchange Rates log opens
3 Choose File > Export. A confirmation window opens. Do one of the following:
• Click Open to open the file in Excel (or other editor that supports CSV files). You can save the file from here after previewing.
• Click Save to save the file to your local drive. Enter a name for the file and click Save.

 

 

 

 

Oracle Corporation

Primavera Unifier 9.10 • Copyright © 1998, 2012, Oracle and/or its affiliates. All rights reserved.

Copyright Information