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

 

Best Answer

Answers

  • 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!

     

  • Hi @NatalyaG ,

     

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

     

    ~ABhi

  • 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!

  • 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

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


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

     

  • 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

     

  • Hi @rajuvendra01 !

     

    I have already found the same solution!

     

    Thanks a lot anyway!

  • @NatalyaG 

     

    Have you tried using the Anaplan provided Time mapping options or directly used Custom fixed pattern in import action.?

    If directly used Custom option , please try Y-M option provided by default.

    Custom fixed pattern are to be used only when defaults options do not work for mapping because this is like hard coding.

     

    ~ABhi

  • Hi @abhi1017 !

     

    Yes, I just found the solution - using Y-M (and setting language).

     

    Thanks a lot for your help!

  • U should change the language to english in the time tab

  • Use a custom view and type    YY?MMM

     

    With this it works fine.

  • I have done with the import now, may be it helps you moving further on the exercise.

    1st attachment shows the final result once you done with the import.

    To get that import done successfully, please look at the mapping in screen shot 2. Other 2 mappings are easy so just attached the time period mapping.

    But before that you should have sys03 module updated like this in the 3rd screen shot attached.

    To get that overview in SYS03, you should have currency conversion list updated like this. attached screen shot. 

    While importing data into currency conversion list, please keep blank for country mapping and also remove 3 extra euros.

     

    Hope this will helpful?