Level 2 Conclusion: Activity: Currency Conversion - Import

[tonybol]

Hello,

Please, help me

I have created the module FX01 Currency Rates, but I'm troubling the import data to the module.

I have the following selections, don't understand why it does not work

but it gives the error

Hope you will help!

Thank you,

Anton

[abhi1017 · Accepted solution]

Hi@tonybol

The error is due to the Timescale in CSV not getting mapped to the Anaplan Timescale.

UseCustom Fixed-Position Patternas highlighted in the screenshot below.

In the Box you need to type the same format as it's in the CSV.

In this case format should be :-YY-MMM

Edit the Action , update and RUN.

~ABhi

[NatalyaG]

Hi@abhi1017!
I have the same problem and I tried to solve it as you said - by usingCustom Fixed-Position Pattern-YY-MMM.

But it is still an error. Could you please help me find the mistake? Please see screens below.

 Thanks!

[abhi1017]

Hi@NatalyaG,

Pls share screenshot of the Mapping tab in the import action to help you better.

~ABhi

[NatalyaG]

Hi@abhi1017!

Yes, sure, please find screens below:

 Thanks!

[abhi1017]

Hi@NatalyaG

Everything seems fine as per depicted in screenshot.

Could you pls. share screenshot of the module where you are trying the import the FX data.

Just want to check:-

1. If you are not importing data while in blue print view.

2. Are the dimensions pivoted properly for import.

~ABhi

[NatalyaG]

Hi@abhi1017!

Yes, sure, please find screens below: 
Regarding 1st assumption: it's not blueprint view.. :

Maybe the problem is in the list "Country Currency" used in a module?
This list looks like:

 When importing Country local Currencies.csv into the Country Currency List maybe there was a problem with duplicate values.. Please see my mapping there:

 But the importing was resolved in no errors..

So for now I have no other assumptions on what can be wrong..

[abhi1017]

@NatalyaG

Is it mentioned in the course that currency is a child of country.?

Check this.

I think you just need to create a module dimensioned by currency list (Flat list) ,time and rates(lineitem).

The country data is provided to map country to the local currency.

~ABhi

[NatalyaG]

Hi@abhi1017!

I tried to do as you said: I created moduledimensioned by currency list (I created Flat list), time and rate (line item).

But there is still an error.. I'm desperate..

Are you sure it should beCustom fixed-position pattern -YY-MMM?..

I even don't know what else can be wrong..

Screens are below:

~ Natalya

[rajuvendra01]

@NatalyaG

Please set Time tab as Periods and Patterns with Separators as Y-M in import screen. Reason is if we open the currency rate file in notepad then we can see date format is like '19-Jan , 19-Feb' hence format should be Y-M.