
The_TonyStark asked a question.
Hi All,
We have exchange rate data available in our Fusion source (Exchange Rate Date, Currency and Exchange Rate Value) and would like to import new Exchange Rate Sets into Flexera One using a Business Adapter.
I configured a Business Adapter to test this, but the exchange rate set/rates are not being created in Flexera One. Has anyone successfully imported Exchange Rate Sets and their currency rates through a Business Adapter? If so, could you please advise what may be missing or incorrect in the configuration below?
Business Adapter XML Config part:
<Object Type="Currency" Name="Currency" Update="False" Create="True" OutputField="Currency_ID">
<Property Type="currencycode" Name="Currency Code" Update="Do not blank" ValueType="Field Value" Value="CURRENCY_CODE" UseForMatching="True" Length="32" />
</Object>
<Object Type="CurrencyRateSnapshot" Name="Currency Snapshot" Update="False" Create="True" OutputField="CurrencySnapshot_ID">
<Property Type="snapshotdate" Name="Snapshot Date" Update="Do not blank" ValueType="Field Value" Value="EXCHANGE_DATE" UseForMatching="True" DataType="Date" UseNullValueForMatching="SetPropertyToNull" />
<Property Type="snapshotname" Name="Snapshot Name" Update="Do not blank" ValueType="Field Value" Value="EXCHANGE_DATE" UseForMatching="True" />
</Object>
<Object Type="CurrencyRate" Name="Currency Rate" Update="False" Create="True" OutputField="CurrencyRate_ID">
<Property Type="currencyid" Name="Currency ID" Update="Do not blank" ValueType="Field Value" Value="Currency_ID" UseForMatching="True" />
<Property Type="snapshotid" Name="Snapshot ID" Update="Do not blank" ValueType="Field Value" Value="CurrencySnapshot_ID" UseForMatching="True" />
<Property Type="rate" Name="Exchange Rate" Update="Do not blank" ValueType="Field Value" Value="EXCHANGE_RATE" DataType="Float" />
</Object>
</Import>
</Imports>
</root>