Message from Matt Young matt@companionanimalvet.com.au

Thanks Tim,

I have drupal setup to collect the information via a webform and store it in a table. I have had a bit of a play around with kettle, I can get the data into kettle from the table in the drupal database but I'm not sure how to use the plugin and get it into openvpms. Does the plugin use some sort of nomenclature to map the data?

Thanks in advance,
Matt.

On 21/01/2012, at 12:23 AM, Tim Anderson wrote:

> That would be a nice extension to OpenVPMS.
>
> You might be able to do a lot of what you want using Drupal and Kettle with the OpenVPMS plugin.
> 1. Use Drupal forms to capture customer and patient data to a table. The data would be flagged "unapproved"
> 2. Provide Drupal admin page that can flag data as "approved" or delete it
> 3. Use Kettle to import the approved data from the table to OpenVPMS
>
> -Tim
>
> On 19/01/2012 10:40 PM, matt@cavh.com.au wrote:
>> Hi all,
>>
>> I would like to be able to have new clients access a webform via our website
>> and then directly enter their own details and their pet's details and then
>> have that information be able to be passed into openvpms to create a new
>> client and new patient there.
>>
>> I have currently implemented this to some extent where clients can submit a
>> form via our website, then the results are emailed to us. We then have to
>> copy and paste the information into OpenVPMS which defeats the purpose to
>> some extent, although the information does tend to be more accurate compared
>> to it being hand-written by the client and then interpreted and typed by a
>> nurse.
>>
>> What would be the best way of going about this? I was thinking that either:
>>
>> 1) some sort of web services/ API could be setup to allow external websites
>> to authenticate and add clients, contacts, patients, etc.
>> 2) a separate application could be written purely for the purposes described
>> which would directly add a client and patient to the database.
>>
>> Ideally some sort of approval queue could be used so that any new submissions
>> can be checked by a real person before being accepted.
>>
>> I find that there is alot of misinterpretation of people's handwriting and we
>> end up with incorrect data. This could eliminate it as we could have clients
>> directly enter the data themselves via a computer terminal/laptop/tablet in
>> the waiting room or at home prior to their appointment.
>>
>> Matt Y.
>>
>
> _______________________________________________
> OpenVPMS User Mailing List
> users@lists.openvpms.org
> To unsubscribe or change your subscription visit:
> http://lists.openvpms.org/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/listinfo/users
Posts from this mailing list can be viewed online and replied to in the OpenVPMS User's forum- http://tinyurl.com/openvfu