Hi Mark,

You can utilise the openvpms data migration tool and Kettle to import from any data source including a spreadsheet. Just need to develop the transform to do it using the Kettle Spoon graphical design tool ... A learning curve but not too difficult

Cheers Tony

On 26/03/09 11:40 AM, "mark@tvg.com.au" :

> Hi Tony, > > I am up to the inventory portion of my installation. I don't want to transfer > the inventory listing from the old system due to obselete lines and work > arounds that have been built into it. I can however get a list of recent > products from our wholesaler in a spreadsheet. Is there any way that I will > be able to insert this data into the OpenVPMS database without having to > manually enter everything? > > I can get the following fields. > (supplier code, description, manufacturer, price(ex), nett(ex)) > > Inputting this data will give me a good start on the inventory. If it is not > too hard to import it would probably be easier to add data to the xls before > import. > > Thanks > Mark > _______________________________________________ > OpenVPMS User Mailing List > users@lists.openvpms.org > To unsubscribe or change your subscription visit: > http://lists.openvpms.org/mailman/listinfo/users > Posts from this mailing list can be viewed online and replied to in the > OpenVPMS User's forum- http://tinyurl.com/openvfu

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