Level 2 - Sprint: Activity import Data into DAT03 Historic Volumes Module

[alana.paulatti]

Hi guys,

I've been trying to inport the 'Historic volume.csv' to the DAT03 Historic Volume Module for the past 2 hours. I already watched all the videos about importing data to module, etc. But I keep receiving this error, "invalid line item identifier", and I don't know what else I can try. Could someone give me a hint?

 

   

Thanks in advance!

[Misbah · Accepted solution]

@alana.paulatti 

I think there is a clear mapping issue with line items. Change the mapping for line items from Column 4 to Column Headers. You should be good.

Also Keep Time Mapping on Match Names instead of Custom.

Hope that helps

Misbah

[alana.paulatti]

Thanks, @Misbah!

[RongF]

@Misbah 

Hi, I still got problems after following the step..

[RongF]

I figured out the problem by changing column4 to fix line item, and choose volumes at the fix line item bar.

[ChadnrarACMA]

Thanks for you all

[Bashobi]

This worked, yes. I still wonder why it is 'Fixed Line Item' for Volumes. I thought Fixed line item would be used for say, importing only for a certain criteria, say a certain SKU or ACCOUNT.

--cheers.

[nfernandez]

I'm receiving the error: Expected character in date/period: Week 1 FY19. This is after following the custom fixed-position patter below. ?????WW???YY

[Kabir]

In case anyone stumbles on this page and has the same issue as nfernandez, it's just Match Names.