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.
Go to Solution.
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)
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!
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.
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.
Thanks. It took a bit of digging, but I finally figured out where to find the YYYYMM format setting.