Will the Kettle loader do an update?

Is the kettle loader able to update a record?

I am trying to work around a bug in Kettle's Access connectivity (its losing chinese characters because its not translating the UTF16 used by Access into UTF8).

It turns out that I can keep the chinese if I export from Access into XML and then read from the XML into Kettle. I want to use the OPV Loader to update the label field in the product record so my mapping is as follows:

This appears to work - ie no error messages and the etl_log shows what I would expect (ie the id field contains the ids of the product records that should be updated).  However, if I go and look at the products that should have had their label fields updated, they are unchanged.  If I intentionally screw up the contents of the oIID variable, then the loader reports that it cannot find the product.medication record - just as I would expect.  So its as though it can reference the record but not modify the label field to the the value in ItemLabel.

[Note that its not the end of the world it the OPV Loader will not update a field - I think I can put together the necessary SQL.  However, it would be nice it it could - and it opens up other possibilities like doing price updates.]

Regards, Tim

 

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: Will the Kettle loader do an update == YES

Stupid me - my error - the field called "label" is the boolean "Dispensing Label" checkbox.  The label text goes into "dispInstructions".  When I corrected this, it updates as expected.

Apologies, Tim

Syndicate content