Hi,
we have people entering address in different ways.
Did anyone of you try to change the address in same format.
I understand this to be a web validation ..
but if we can have something scheduled each nite to change the new address in the same format.
Kindly reply me if you have suggestions.
We downloaded the Auto Address Correction script from TASK - It is a shared report, Solution 99 in the Reference Materials Project, created through the Washington National Opera. Here is a brief summary of its functionality:
This procedure provides auto address correction and formatting during data entry.
Spells out most abbreviation and fixes case, punctuation etc for names and addresses.
Primarily written for data entry online by patrons, but also used in-house. An
attribute of “auto address correction” to “no” suppresses routine for a particular
patron, should the algorithms not work correctly.
Have a look at it, this has worked wonders for us (Thank you Brian!), as there was no consistent formatting that came in with records from our old system during Tessitura implementation. The script was initially run over our whole database to make corrections on addresses already there and automatically formats new addresses upon creation.