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?
Thanks in advance!
Comments
-
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
21 -
Thanks, @Misbah!0
-
I figured out the problem by changing column4 to fix line item, and choose volumes at the fix line item bar.
14 -
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
0 -
Thanks for you all
0 -
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.
0 -
In case anyone stumbles on this page and has the same issue as nfernandez, it's just Match Names.
5 -
This helped me a lot! I think I now understand how the import maps so much better than I did before. Thank you!
0 -
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.
0 -
Hi guys . My import is successful but the values are not getting displayed .Kindly let me know what is the error
0 -
Hi all,
Attached is the screenshot which works for me.
Thanks!
0 -
Dear all,
Please find the screenshot below for mapping.
0 -
Thanks a lot! This helped0
-
i can not see your column headers
0