8.5.3 Activity: Import Data into Volume Inputs Module
Comments
-
Hi Alancheah,
You have to choose as 'Fixed line item' under target 4, and under 5th tab select as 'Volumes' from drop-down.
The main reason selecting volumes here is that, data belongs to Volumes and same thing you can verify from first row in excel data.
Hope it helps.
Regards,
Basavaraj
9 -
Hi Basavaraj,
I have tried fixed line item as suggested by you and selecting volumes but I have this error (refer attachment).
Thanks for your help.
And I am open for others to advise/assist me if any of had this problem.
Alan Cheah
0 -
Hi Alan,
The error is because wrong formatting of date/period.
On the same mapping window, select time tab and mention as YYYYMM, This is because we have data in this format 201901, 201902..so on.
Stay Safe,
Basavaraj
17 -
TQ so much. Problem solved.0
-
Thank you! Super helpful0
-
Hi Basavaraj,
I am getting an error '
Invalid period for format YYYYMM'
Updated - 26076
Failed - 52152
I followed all of the instructions in this thread.
1 -
Hi Pravin,
Could you share the Mapping screen. Also what is period format in your data?
Regards,
Basavaraj Goni
0 -
Hi Basavaraj - please find attached. Please download the attachment files and open it.
3 -
I am running into the same issue. Did you solve this?
Details show Invalid format with YYYYMM and 202001. This seems strange to me. Does anyone know what I'm missing here?
0 -
I had the same issue, and for me the problem was that Current Fiscal Year in Time settings changed to FY21 for some reason (it was supposed to be 2020). Since the number of past years is 1, the data for 2019 couldn't be imported.
3 -
Thank you for the details. I was stuck on this part for so long.0
-
I think I did this correctly but I technically got a different success import back. I ignored a few instances in my
I think the red line is supposed to incorporate the "Time YYYYMM". I manually inserted them to get the correct answer. How do I ignore the volume line and move the red down to the YYYYMM second column?
0 -
Hi!
I was able to get past this and import, but all my volumes are appearing as 0.
0 -
-
When you upload the file, Mark the Header as "2"
0 -
Thank you! Helped me a lot1
-
Thanks
0