Query re automatic link generation by OPV loader plugin
I have been polishing & expanding my Kettle Loader documentation (see http://www.openvpms.org/documentation/openvpms-loader-plugin-pentaho-kettle ).
In it there are examples like the following:
I have a vague recollection that someone commented in an earlier post that the 3rd mapping in the above is unnecessary and that the loader will automatically generate this entry. That is, the loader will see line 2, look for a node in the product.service archetype that links to the entityRelationship.productTypeProduct archetype, finds "type" and will automatically fill in the value so as to link back to the entityRelationship.productTypeProduct being generated by lines 1 & 2.
Can someone confirm that this is or is not the case. If it is the case, I will adjust the Kettle Loader article. Can they also comment on whether the line should be omitted (because of better performance) or should be included (because of better performance).
Regards, Tim
Re: Query re automatic link generation by OPV loader plugin
My OpenVPMSLoader plugin memory is rusty, but the first two mappings create a relationship between the product type and the service product.
The third mapping is adds the relationship created by the first two mappings to the the service product again, so it is in effect redundant.
-Tim A
Re: Query re automatic link generation by OPV loader plugin
Tim A - thanks. I also ran last night's dataload with the transforms that link the invoice items and medication to the visits set like this, and it works - around 1.2 million records correctly linked. I will update the documentation.
Regards, Tim G