L1 MB - Lesson 8.5.3 Import Data into Volume Inputs Module

Candy
Candy
in Academy Discussions

Hello,

I don't know what I did wrong with mapping source to target.

Error log indicate something to do with Volumes and I check the mapping relating to Volumes and it has been set to 'Fixed line item'.

Back in the Grid View, I can see all the data came across. So I'm confuse now by the error mention in the log. How do I fix it?

 

Error log

Candy_0-1614826394180.png

Candy_1-1614826435962.png

Candy_2-1614826470261.png

Mappings:

Candy_3-1614826516923.png

Candy_4-1614826545495.png

Candy_6-1614826583706.png

Candy_7-1614826620251.png

Candy_9-1614826658789.png

Grid view

Candy_10-1614827170551.png

 

 

Please help! 😊

Thank you.

Candy

 

 

Comments

  • AntonMineev
    AntonMineev

    Hi Candy!

    In the first you must change import mapping for file. You need choose second row as "Header Row".

    Снимок экрана 2021-03-04 в 09.09.36.png

     

    For change it you need open Action - Import Data Source and select your file and click "Edit".

    Try your import again after this changes.

  • Candy
    Candy

    Hi Anton,

     

    Thank you for your advice! 😃

    Just another question on importing again. If I the follow the same process to import the data file again, the system will know to replace the existing data? I wouldn't get duplicates.

     

    Thank you

    Candy

  • AntonMineev
    AntonMineev

    Yes, the system replaces the data in the cells when importing. You can change the import setting so that the system cleans the slice completely. More details can be found here: help 

    Снимок экрана 2021-03-04 в 10.14.01.png

    The only thing is, if you import into a sheet, then you need to check if you have any artifacts from incorrect imports.

    If my answers helped you then please mark one of them as a solution.Thanks you!

Categories