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>