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

Options
alana.paulatti
alana.paulatti Member, ALL USERS, Partner, Certified Model Builder Posts: 3 New Contributor
in Extensibility

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!

Tagged:

Comments

  • alana.paulatti
    alana.paulatti Member, ALL USERS, Partner, Certified Model Builder Posts: 3 New Contributor
    Thanks, @Misbah!
  • nfernandez
    nfernandez Member, ALL USERS, Community Member Posts: 1 New Contributor

    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

  • Bashobi
    Bashobi Member, ALL USERS, Partner Posts: 4 Occasional Contributor

    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
    kberger1 Member, ALL USERS Posts: 1 New Contributor
    This helped me a lot! I think I now understand how the import maps so much better than I did before. Thank you!
  • mavischen
    mavischen Member, ALL USERS Posts: 1 New Contributor

    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
    Rover10 Member, ALL USERS, Partner, Certified Model Builder Posts: 2 New Contributor

    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
    thai_van_dang@hotmail.com Member, ALL USERS Posts: 4 Occasional Contributor

    Hi all,

     

    Attached is the screenshot which works for me.

     

    Thanks!

  • thai_van_dang@hotmail.com
    thai_van_dang@hotmail.com Member, ALL USERS Posts: 4 Occasional Contributor

    Dear all,

     

    Please find the screenshot below for mapping.

     

     

  • Akumar94an
    Akumar94an Member, ALL USERS, Community Member Posts: 5 Occasional Contributor
    Thanks a lot! This helped
  • Norah
    Norah Member, ALL USERS Posts: 4 New Contributor

    i can not see your column headers

     

Categories