Complete the following steps to add or change a currency conversion:
- For each currency conversion that you want to add or change, or to add a new EMU currency, use the following line in a mass loadable file:
<curconvert curconvert_id="-21" storeent_id="-1" fromcurr="USD" tocurr="CAD" factor="1.26" multiplyordivide="M" bidirectional="Y" updatable="N"/>
where:
- curconvert_id
- is a generated unique number specified in the CURCONVERT_ID column in the CURCONVERT table.
- storeent_id
- is the store or store group ID.
- fromcurr
- is the three-character ISO 4217 currency code representing the original currency. This code must appear in the SETCCURR column of the SETCURR table.
- tocurr
- is the three-character ISO 4217 currency code representing the converted currency. This code must appear in the SETCCURR column of the SETCURR table.
- factor
- is the conversion rate.
- multiplyordivide
- indicates whether to multiply (M) or divide (D).
- bidirectional
- indicates whether the conversion is bi-directional (Y) or unidirectional (N).
- updatable
- indicates whether the conversion rate can be changed (Y) or not (N).
- Load the data to the WebSphere Commerce database. For instructions on how to load the data to the database, see Loading the data to the WebSphere Commerce database.