Register

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

alana.paulatti
New Contributor

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

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?

print 1.JPG

print2.JPG

print3.JPG

print4.JPG

   

Thanks in advance!

10 REPLIES 10
Misbah
Moderator

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

@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
New Contributor

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

Thanks, @Misbah!
RongF
Occasional Contributor

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

@Misbah 

 

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

RongF_0-1590371666633.png

 

RongF
Occasional Contributor

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

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

ChadnrarACMA
Contributor

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

Thanks for you all

Bashobi
New Contributor

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

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.

kberger1
New Contributor

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

This helped me a lot! I think I now understand how the import maps so much better than I did before. Thank you!
mavischen
New Contributor

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

That's very helpful. Thank you, Misbah. Just wondering when should we consider using Column Headers and when to use the specific column? Thanks in advance. 

nfernandez
New Contributor

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

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