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

Highlighted
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!

5 REPLIES 5
Highlighted
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

Highlighted
New Contributor

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

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

 

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

Highlighted
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