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

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!

8 REPLIES 8
Master Anaplanner/Community Boss

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

New Contributor

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

Thanks, @Misbah!
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

 

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.

Occasional Contributor

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

Thanks for you all

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.

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

Occasional Contributor

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

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