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!

1 ACCEPTED SOLUTION

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

View solution in original post

11 REPLIES 11
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

View solution in original post

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

Rover10
New Contributor

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

Hi guys . My import is successful but the values are not getting displayed .Kindly let me know what is the error