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

Thanks in advance!

Comments

Misbah

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

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

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.

Kabir

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

kberger1

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

mavischen

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

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

thai_van_dang@hotmail.com

Hi all,

Attached is the screenshot which works for me.

Thanks!

History_Volumes_Line_items_136235.jpg

History_Volumne_136235.jpg

Mapping_136235.jpg

thai_van_dang@hotmail.com

Dear all,

Please find the screenshot below for mapping.

History_Volumes_Line_items_136239.jpg

Mapping_136239.jpg

History_Volumne_136239.jpg

Akumar94an

Thanks a lot! This helped

Norah

i can not see your column headers

Quick Links

Recent release news

July 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our July 2025 official release notes. The information below offers supplemental information to that post. Planning experience External URL navigation button Page builders can configure navigation action buttons to link to external URLs, including non-Anaplan…
Recording now available! July 30 platform release event
If you missed our July 30, 2025 platform release event, the recording is now available! In this webinar, we highlight the most recent feature releases and how to take advantage of these in your environment. Our expert-led session demonstrated new features and innovations, provided a technical deep-dive and “how-to”,…