We are in the middle of a migration of going from On-Premise 10.2.700 to SaaS. Right now in our On-Premise environment we have a lot of open order and quote lines which have been configured by the product configurator. These order and quote lines, including their configuration have to be migrated to the new SaaS environment as well.
I’m thinking of a way to migrate the product configurator data from the on-premise to the SaaS environment.
What I’ve tried so far to test the possibilities:
- In On-Premise, export both the PcValueGrp and PcValueSet tables for a specific OrderLine.
- In SaaS, create an Epicor Function with DB read/write access.
- Inside this Epicor Function, create a new PcValueSet and PcValueGrp record with hardcoded values based on the export in step 1, and make sure the RelatedSysRowID is equal to a configurable Sales Order in the SaaS environment.
- Run the Function
The records get created correctly, i can see them with a BAQ. But when i open the configurator from the related Sales Order line it won’t show the values that i have imported.
I do know there is also the PcInputValue table (or SQL view?). This table remains empty in the SaaS environment for the specific Sales Order line.
Am i missing some steps or does anyone have experience with this?
Thanks in advance,