Lesson 8.5.3 Volumes Data Inport REV02

wgallip
wgallip
in Academy Discussions

Don't quite understand how to point to the volume data.  I believe I have the Time, G3 Location and P2 Products sources set correctly, but not sure what to do with the REV02 Volume Inputs.  When I run the import I receive the error below.

Comments

  • Sumon16
    Sumon16

    Hey @wgallip , 

     

    As I can see from your first screenshot your mapping for the Target for:

     

    Time (is correct)

    G3 Location (is correct)

    P2 Product Code (is correct)

    but in

     

    REV02 Volume Inputs Line Items (Volumes) try to use Fixed Line Item

     

    and in the REV02 Volume Inputs Line Items Tab:

    under Marked as (Fixed Target Item) in the Mapping tab; please specify a value select the Volume.

     

    I guess this might solve your error. Feel free to connect if you still have any issues.

     

    All the best!

     

     

    Regards

     

    Sumon Dutta

  • wgallip
    wgallip

    Sulman,

     

    Still erroring out.  Attached is the screenshot for setting the fixed line item to Volumes.  I don't know if I am supposed to be seeing anything besides this.  Error log is also attached.

     

    Thanks.

  • andre.lie
    andre.lie

    @wgallip 

     

    The error message indicates something related to date or timescale.  As the file to be loaded has Time in Y-M format, you need to choose mapping in Time tab that matches with this pattern.

  • wgallip
    wgallip

    Thanks.  It took a bit of digging, but I finally figured out where to find the YYYYMM format setting.

  • JosephA
    JosephA

    This is an error that beats me, everything loaded but when Iooked at the output, I'm missing two months. please see screenshot. Not sure if there is bug in the module or what but not all my data came through

    2020-12-02_18-49-23.png

  • Chichi
    Chichi
    Hi,

    where exactly did you find the YYYYMM setting? I'm encountering the same error.
  • dhinayadav
    dhinayadav

    dhinayadav_0-1632636409595.png

     

    dhinayadav_1-1632636460349.png

    why some values are getting failed

     

  • Shirletan
    Shirletan

    In the mapping setting, go to time tab, the first section "How to map the source data into the timescale", choose "Periods", then in the "Fixed Position Patterns", select "YYYYMM'. 

    it should work.

  • an.gorskaya
    an.gorskaya

    Hi Joseph!

     

    I have the same problem. Do you remember what was wrong in your case?

Categories