8.5.3 Activity: Import Data into Volume Inputs Module

alancheah

Dear all, 

 

I am having trouble importing data with selecting the source for Target No.4 which is REV02 Volume Inputs Line Items.

I have tried all options on the drop down menu on the left (refer attachment).

 

Pls advise or comment. Thanks.

GONI

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

 

alancheah

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

GONI

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

alancheah

TQ so much. Problem solved.

Chmacpherson

Thank you! Super helpful

pravin_prabhu

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.

 

GONI

Hi Pravin,

 

Could you share the Mapping screen. Also what is period format in your data?

 

Regards,

Basavaraj Goni

pravin_prabhu

Hi Basavaraj - please find attached. Please download the attachment files and open it.

ckongpanickul

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?

 

 

olgaitskova

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.

Tanok

Thank you for the details. I was stuck on this part for so long.

jdatz86

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? 

mbiswas

Hi! 

 

I was able to get past this and import, but all my volumes are appearing as 0. 

 

 

Praveen37

im receiving below error can anyone please help me in fixing it 

Pranoti

When you upload the file, Mark the Header as "2"

 

danielletomaz

Thank you! Helped me a lot

warmok

Thanks

ddesai

Hello Team,

I am still facing the same issue. Kindly let me know how to fix it. I am stuck on it for very long time.

Thanks and regards,

Dhaval

ddesai

Issue resolved. Current fiscal year settings changed somehow. Changed number of past years and no of future years.