8.5.3 Activity: Import Data into Volume Inputs Module

linasuarez

How can I import Volume+inputs.csv into my Rev02 Module? I've been trying different things but I keep having an error.

Can someone help me, please?

error 1.png

error 2.png

AjayM

Hi @linasuarez ,

The csv file contains time values in YYYYMM format. Have you set the time mapping matching this format?

And also that the module is set to MONTH timescale?

If it still doesn't work, please share your time mapping tab from the import action window.

Cheers!

Venki9902

Hi @linasuarez ,

Seems you are loading the wrong file in the Rev02 module.

As per the 2.png your file does not have Location details(mapping is wrong as per 2.png) and it should be mapped to second column and for line item you should select as Fixed line item because there is only one line item.

Volume+inputs.csv file should have data like below:

Kindly check the file once from your side.

Hope this helps.

Regards,

Venkatesh

AjayM

Hi @linasuarez ,

Your time mapping in the action doesn't have an issue.

As @Venki9902 mentioned, please correct the source mapping of other items. 'G3 Location' should be mapped to location code in the file (column 2). And lineitem need not be asked everytime, it has to be fixed.

Cheers!

linasuarez

Hi @AjayM

Thanks for your response. I changed the time mapping but still not working. Attached some pictures.

Thank you so much!

Cheers!

1.png

2.png

3.png

4.png

5.png

6.png

linasuarez

Thank you so much @Venki9902 @AjayM. I changed the mapping for location and it's working now. I was a bit confused because the error mentioned the date format but now Its all good :)

Cheers!