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 · Accepted solution]

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?