L1 Model building - error when import data to modules

stephw229
stephw229
in Integrations and extensibility

Hi, 

 

I am still in the training course and now in lesson 7.2.3

When I tried to import the data to the module, I couldn't map most of the fields and got a lot error message 

stephw229_0-1614757281901.png

So basically all the empty fields are not catching up with the source file. 

stephw229_1-1614757327240.png

Does anyone have similar issues? Thanks!

Tagged:

Best Answer

  • stephw229
    stephw229
    Answer ✓

    Solved. the date fields are due to formatting in the target source. 

    Other two columns which are not auto mapped so need manual map during the import process. 

Answers

  • Misbah
    Misbah

    @stephw229 

     

    Looks like your mapping is incorrect. Can you please share your mapping screenshot.

     

    Line items have to be Column Headers I believe

     

     

  • ChrisAHeathcote
    ChrisAHeathcote

    @stephw229 

    Also ensure that the line items in the module are formatted correctly with the relevant list format.

     

    You need to map the date columns too so that Anaplan is able to correctly allocate the start and leave dates. Review the formatting in your source csv and select the corresponding mapping in the mapping set up.

  • stephw229
    stephw229

    Hi Chris, 

     

    Thank you for replying. I have checked the format and it is what the training course required. 

    stephw229_0-1614789762613.png

     

  • stephw229
    stephw229

    Hi Misbah, 

     

    Thank you for replying. 

     

    Here is the screenshot of the mapping tab when I tried to import the data

    stephw229_1-1614790048875.png

     

     

  • Glamorous
    Glamorous


    Thanks for the update and quick reply. I'll be sure to keep an eye on this thread. Bumped into your thread. Thanks for creating it. Looking forward for solution.

  • dedrashores
    dedrashores

    I am having the same issue. Line item format is date, however still cannot get it to import.  Did you reformat the source data?

Categories