Level 2 Conclusion: Activity: Currency Conversion - Import

tonybol
Contributor

Level 2 Conclusion: Activity: Currency Conversion - Import

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

tonybol_0-1617703828449.png

 

tonybol_1-1617703841727.png

but it gives the error

tonybol_2-1617703883975.png

Hope you will help!

 

Thank you,

 

Anton

 

1 ACCEPTED SOLUTION

Accepted Solutions
abhi1017
Super Contributor

Re: Level 2 Conclusion: Activity: Currency Conversion - Import

Hi @tonybol 

 

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

 

Use Custom Fixed-Position Pattern as highlighted in the screenshot below.

abhi1017_0-1617704401518.png

 

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

View solution in original post

14 REPLIES 14
abhi1017
Super Contributor

Re: Level 2 Conclusion: Activity: Currency Conversion - Import

Hi @tonybol 

 

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

 

Use Custom Fixed-Position Pattern as highlighted in the screenshot below.

abhi1017_0-1617704401518.png

 

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

View solution in original post

NatalyaG
Occasional Contributor

Re: Level 2 Conclusion: Activity: Currency Conversion - Import

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

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

Снимок экрана 2021-05-24 в 00.23.50.png

Снимок экрана 2021-05-24 в 00.27.21.png

 Thanks!

 

abhi1017
Super Contributor

Re: Level 2 Conclusion: Activity: Currency Conversion - Import

Hi @NatalyaG ,

 

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

 

~ABhi

NatalyaG
Occasional Contributor

Re: Level 2 Conclusion: Activity: Currency Conversion - Import

Hi @abhi1017 !

Yes, sure, please find screens below:

Снимок экрана 2021-05-24 в 09.35.26.png

Снимок экрана 2021-05-24 в 09.35.48.png

Снимок экрана 2021-05-24 в 09.37.43.png

Снимок экрана 2021-05-24 в 09.38.03.png

Снимок экрана 2021-05-24 в 09.38.36.png

 Thanks!

abhi1017
Super Contributor

Re: Level 2 Conclusion: Activity: Currency Conversion - Import

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
Occasional Contributor

Re: Level 2 Conclusion: Activity: Currency Conversion - Import

Hi @abhi1017 !

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

Снимок экрана 2021-05-24 в 13.02.39.png

Снимок экрана 2021-05-24 в 13.03.16.png

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

 

Снимок экрана 2021-05-24 в 13.05.32.png

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

Снимок экрана 2021-05-24 в 13.09.21.png

 But the importing was resolved in no errors..

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


abhi1017
Super Contributor

Re: Level 2 Conclusion: Activity: Currency Conversion - Import

@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
Occasional Contributor

Re: Level 2 Conclusion: Activity: Currency Conversion - Import

Hi @abhi1017 !

 

I tried to do as you said: I created module dimensioned 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 be Custom fixed-position pattern - YY-MMM?..

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


Screens are below:

Снимок экрана 2021-05-24 в 17.54.30.png

Снимок экрана 2021-05-24 в 17.56.11.png

Снимок экрана 2021-05-24 в 17.56.58.png

Снимок экрана 2021-05-24 в 17.57.22.png

Снимок экрана 2021-05-24 в 17.57.51.png

~ Natalya

 

rajuvendra01
Contributor

Re: Level 2 Conclusion: Activity: Currency Conversion - Import

@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.