I am trying to use VI to import new WT, and am getting errors that make no sense. The header and steps import, but the materials / details fail with an error that is... wrong.
Testing on v2024.3 Standard with PMZ data, no system modifications. (Client is on v2024 Premium... same results for both).
Letting the Sage Perform Logic do it's thing (converting Step# into Step Line Key)... I point both the WT StepNo and the L.StepLineKey to the same column in the source.
Results:
The L data shows it correctly set the StepLineKey from the associated Step (WT log record immediately above), but the line failed?!?!?!?
Testing after I remove the Sage Perform Logic, and calculating the key using a temp field...
And the results are the same.
Again, the StepLineKey is set correctly, but the L records fail saying it is required?!?
Has anyone been able to successfully import WT materials (with multiple steps) using Visual Integrator? We were able to do it once, with everything hard-coded as step 000000, but for this client their templates have multiple steps.
Before anyone asks, yes I did try to re-shape my source data so H, WT, L data is on separate lines. The error is the same.
I am OK with a two step import, but I cannot seem to import materials in the same job (as the Steps are imported), or in a separate job afterwards. The error is the same each time.
L Record Invalid or Write Failed. The Work Ticket Step Line Key is required.
TIA for any assistance.
------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------