What version of openvpms are you running? There should be a file named etl.log in the directory where you ran kettle. Are there any errors in there?

-Tim

bernd@hey.za.net wrote:

> Hi I am trying to transform data from a xBase based system to > OpenVPMS. I have managed to setup Kettle and the OpenVPMS Loader, and > am getting Kettle to complete a transformation without reporting errors. > > The medications (I started with those) are however not being loaded > into OpenVPMS. > > I have selected 1 record to copy the logged details here, but the > messages are the same for all of the transformation. > > 2009/03/22 09:06:43 - root: > org.openvpms.component.business.domain.im.product.Product@367c1e66[ > productPrices=[] > details={dispensingVerb=org.openvpms.component.business.domain.im.datatypes.basic.TypedValue@caf6c322} > > classifications=[] > identities=[] > sourceEntityRelationships=[] > targetEntityRelationships=[] > active=true > archetypeId=product.medication.1.0 > description= > lastModified= > linkId=ffd4d715-16af-11de-bb3d-eb05870cf0d3 > name= > uid=-1 > version=0 > ] parent: > org.openvpms.component.business.domain.im.product.Product@367c1e66[ > productPrices=[] > details={dispensingVerb=org.openvpms.component.business.domain.im.datatypes.basic.TypedValue@caf6c322} > > classifications=[] > identities=[] > sourceEntityRelationships=[] > targetEntityRelationships=[] > active=true > archetypeId=product.medication.1.0 > description= > lastModified= > linkId=ffd4d715-16af-11de-bb3d-eb05870cf0d3 > name= > uid=-1 > version=0 > ] name: sourceEntityRelationships index: 0 > 2009/03/22 09:06:43 - Medication Loader.0 - Failed to process row 505: > org.openvpms.component.business.service.archetype.ArchetypeServiceException: > Failed to create object for archetype with short name product.medication. > > Running the same transformation into a text file gives me the > following fields for row 505 > > DESCRIPTION;UNIT;COSTPRICE;GROUP;PRICE;MARKUP;IDCODE;ID > ALFAXAN INJECTION ;ML ;000017.50;D;000028.00;060;DRUG505 ; 505 > > I am only trying to load the following in Medication Loader > > # Field name Map to > 1 DESCRIPTION name > 2 COSTPRICE prices[0]cost > 3 PRICE prices[0]price > 4 MARKUP prices[0]markup > > I have tried setting the id Field Name in the OpenVPMS loader to both > ID and IDCODE with the same results > > I hope this information is enough for someone to let me know what I am > doing wrong. > _______________________________________________ > OpenVPMS Developers Mailing List > developers@lists.openvpms.org > To unsubscribe or change your subscription visit: > http://lists.openvpms.org/mailman/listinfo/developers > Posts from this mailing list can be viewed online and replied to in > the OpenVPMS Developer's forum- http://tinyurl.com/openvdf >

_______________________________________________ OpenVPMS Developers Mailing List developers@lists.openvpms.org To unsubscribe or change your subscription visit: http://lists.openvpms.org/mailman/listinfo/developers Posts from this mailing list can be viewed online and replied to in the OpenVPMS Developer's forum- http://tinyurl.com/openvdf