8.5.3 Activity: Import Data into Volume Inputs Module

Highlighted
New Contributor

8.5.3 Activity: Import Data into Volume Inputs Module

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.

8 REPLIES 8
Highlighted
Contributor

Re: 8.5.3 Activity: Import Data into Volume Inputs Module

Hi Alancheah,

GONI_0-1604508525008.png

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

 

Highlighted
New Contributor

Re: 8.5.3 Activity: Import Data into Volume Inputs Module

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

Highlighted
Contributor

Re: 8.5.3 Activity: Import Data into Volume Inputs Module

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.

GONI_0-1604557816153.png

 

Stay Safe,

Basavaraj

Highlighted
New Contributor

Re: 8.5.3 Activity: Import Data into Volume Inputs Module

TQ so much. Problem solved.
Highlighted
Occasional Contributor

Re: 8.5.3 Activity: Import Data into Volume Inputs Module

Thank you! Super helpful
Highlighted
New Contributor

Re: 8.5.3 Activity: Import Data into Volume Inputs Module

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.

 

Highlighted
Contributor

Re: 8.5.3 Activity: Import Data into Volume Inputs Module

Hi Pravin,

 

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

 

Regards,

Basavaraj Goni

Highlighted
New Contributor

Re: 8.5.3 Activity: Import Data into Volume Inputs Module

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