Email contacts for newsletters

Submitted by Jimvet on Wed, 22/04/2009 - 13:22

General User's Discussion

We have been collecting emails since the start and now want to use this information to send email newsletters. How do we extract the email information and unique customer identifier (customer number) ?

Re: Email contacts for newsletters

Submitted by Tony De Keizer (not verified) on Thu, 23/04/2009 - 00:48.

Hi James,

There is definitely a way to extract emails from the system and include the unique id but it would be via a database query or a report. Do you want to send the email yourself or extract the data for someone else to send the emails ?

Cheers Tony

P.S. This is another scenario we need to address for the adhoc reporting workspace being discussed

On 22/04/09 12:22 PM, "James Thompson" :

> We have been collecting emails since the start and now want to use this > information to send email newsletters. How do we extract the email information > and unique customer identifier (customer number) ? > _______________________________________________ > 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

Data

Submitted by Jimvet on Tue, 28/04/2009 - 13:41.

We want to extract emails for use by a third party to send email newletters (although we would customise the emails).

Re: Data

Submitted by Tony De Keizer (not verified) on Fri, 01/05/2009 - 15:00.

Hi James,

I would suggest this could be very easily done by anyone who has even a small understanding of database access. OpenVPMS uses a industry standard SQL database and with a small amount of knowledge about the database tables we use the third party could extract all the information they need.

If they need any assistance then get them to post any questions here.

Cheers Tony

On 28/04/09 12:41 PM, "James Thompson" :

> We want to extract emails for use by a third party to send email newletters > (although we would customise the emails). > _______________________________________________ > 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

Re: [OpenVPMS Developers] Data

Submitted by atwong (not verified) on Fri, 01/05/2009 - 16:00.

Just curious. Is there a facade or an API instead of having people go directly to the database (would help with future if the database schema changes)?

On Thu, Apr 30, 2009 at 8:11 PM, Tony De Keizer wrote:

> Hi James, > > I would suggest this could be very easily done by anyone who has even a > small understanding of database access. OpenVPMS uses a industry standard > SQL database and with a small amount of knowledge about the database tables > we use the third party could extract all the information they need. > > If they need any assistance then get them to post any questions here. > > Cheers > Tony > > > > > On 28/04/09 12:41 PM, "James Thompson" : > > > We want to extract emails for use by a third party to send email > newletters > > (although we would customise the emails). > > _______________________________________________ > > 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 >

-- Albert T. Wong VetAnyware, Veterinary Business Software Solutions

Re: [OpenVPMS Developers] Data

Submitted by Tony De Keizer (not verified) on Fri, 01/05/2009 - 16:00.

Hi Albert,

Not currently but there is an intention to supply such a façade through a SOAP service and based on the services methods available through our archetype project. In essence the Archetype project is the business layer of the application and as such we hope to provide better access to this.

The second project we would like to undertake is a Archetype Query Language. I.e. An archetype aware SQL syntax. I think Tim is very keen on getting some funding and/or contribution for this.

Cheers Tony

On 1/05/09 2:28 PM, "Albert T. Wong" :

> Just curious. Is there a facade or an API instead of having people go > directly to the database (would help with future if the database schema > changes)? > > On Thu, Apr 30, 2009 at 8:11 PM, Tony De Keizer > wrote: >> Hi James, >> >> I would suggest this could be very easily done by anyone who has even a >> small understanding of database access. OpenVPMS uses a industry standard >> SQL database and with a small amount of knowledge about the database tables >> we use the third party could extract all the information they need. >> >> If they need any assistance then get them to post any questions here. >> >> Cheers >> Tony >> >> >> >> >> On 28/04/09 12:41 PM, "James Thompson" : >> >>> > We want to extract emails for use by a third party to send email >>> newletters >>> > (although we would customise the emails). >>> > _______________________________________________ >>> > 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 > >

Pet Pack newsletters

Submitted by Jimvet on Thu, 10/09/2009 - 16:01.

Is there interest from the OpenVPMS community who use Pet Pack newsletters or who are involved in the Pet Pack box promotion about developing a module to extract email addresses from OpenVPMS for email newsletters ?

Re: Pet Pack newsletters

Submitted by Matt C on Fri, 11/09/2009 - 00:00.

Hey there, Do you need to extract email addresses in a particular format until the reporting stuff is fully explored? It is possible using some back door queries (to get data in spreadsheet format for example) or even a printed list of customers with emails via the current report interface. What criteria or filters would you require?

Matt C

On Thu, 10 Sep 2009 05:01:34 +0000 (UTC), turravet@tech2u.com.au wrote:

> Is there interest from the OpenVPMS community who use Pet Pack newsletters

> or who are involved in the Pet Pack box promotion about developing a > module to extract email addresses from OpenVPMS for email newsletters ? > _______________________________________________ > 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 >

Re: Pet Pack newsletters

Submitted by Tony De Keizer (not verified) on Fri, 11/09/2009 - 09:00.

Hi Guys,

From what I understand the export function would be quite simple and include only basic information such as customer id and email address.

I am sure all it needs is a very simple utility that runs a database query. The utility could be scheduled to run automatically.

I am sure the PetPack team could develop this utility in no time, with our help if they need it, and implement at OpenVPMS sites that use the PetPack service.

Cheers Tony

On 10/09/09 10:20 PM, "Mpcosta@Boroniavet. Au" :

> > Hey there, > Do you need to extract email addresses in a particular format until the > reporting stuff is fully explored? It is possible using some back door > queries (to get data in spreadsheet format for example) or even a printed > list of customers with emails via the current report interface. What > criteria or filters would you require? > > Matt C > > On Thu, 10 Sep 2009 05:01:34 +0000 (UTC), turravet@tech2u.com.au wrote: >> Is there interest from the OpenVPMS community who use Pet Pack > newsletters >> or who are involved in the Pet Pack box promotion about developing a >> module to extract email addresses from OpenVPMS for email newsletters ? >> _______________________________________________ >> 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

Email contacts for newsletters

Comment viewing options