Reminder mail export to CSV

Donate to this project

Development Project Status: Completed

Total cost estimate (ex-Tax): 
$850
Due date for completion of this stage: 
20/04/2013
Release: 
1.7
Current Percentage Funded: 
100.00%
Project funding: 

Public pledges can be made to this forum topic or email me directly by clicking here (link only works in the forum). Development will not commence until fully funded.

Project description: 

This project will add support to export reminders that need mailing to a CSV file, instead of printing them.

This can be sent to a third party to perform the reminder mail-out.

The CSV file will contain:

  • customer identifier
  • customer title
  • customer first name
  • customer surname
  • customer street address
  • customer suburb
  • customer state
  • customer postcode
  • customer phone number (SMS phone number, or preferred phone if not available)
  • patient identifier
  • patient name
  • patient species
  • patient breed
  • patient sex
  • patient colour
  • patient date of birth
  • reminder type id
  • reminder type name
  • due date
  • reminder count
  • reminder last sent date

To determine if a reminder should be printed or exported, the entityRelationship.reminderTypeTemplate archetype will have a new boolean "export" node. If true, and the reminder is to be mailed, it will be exported instead of printed.

The CSV file will be downloaded to the browser for the user to save on completion of reminder generation.

Tab separated files will also be supported, to avoid the need to escape fields containing commas.

The type of export will be configurable at the practice level.

JIRA: https://openvpms.atlassian.net/browse/OVPMS-1308

Comments

Comment viewing options

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

Re: Reminder mail export to CSV

Could I suggest a few more fields to allow more customisation. I would suggest

Client: mobile number (to be able to use for sms), email address (to allow to use for emails), first name, surname, title

Patient: breed, sex, species, dob

I am really keen to get this up for 1.7

Re: Reminder mail export to CSV

Could we get a price on this one please.

Re: Reminder mail export to CSV

Companion Animal Veterinary Hospital will fund this project smiley

Syndicate content