8.5.3 Activity: Import Data into Volume Inputs Module

alancheah
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.

1 ACCEPTED SOLUTION

Accepted Solutions
GONI
Frequent 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

View solution in original post

13 REPLIES 13
GONI
Frequent 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

 

alancheah
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

GONI
Frequent 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

View solution in original post

alancheah
New Contributor

Re: 8.5.3 Activity: Import Data into Volume Inputs Module

TQ so much. Problem solved.
Chmacpherson
Occasional Contributor

Re: 8.5.3 Activity: Import Data into Volume Inputs Module

Thank you! Super helpful
pravin_prabhu
Occasional 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.

 

GONI
Frequent 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

pravin_prabhu
Occasional 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.

ckongpanickul
New Contributor

Re: 8.5.3 Activity: Import Data into Volume Inputs Module

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?

 

ckongpanickul_0-1615015303996.pngckongpanickul_1-1615015354819.png