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 too have downloaded the procedure created by the Washington National Opera. However, we modified it to not correct entries made by certain security groups (development). Often times development may want to have a salutation or address done in a way outside the paramter of the script, so we let them. Overall, for our institution the script has helped to normalize our data essential for mailings etc.. I would recommend it for your institution.
Christian @ The Tech Museum
I have succesfully downloaded the funtion,now I am unable to determine in which stored procedure ,I should run the funtion inorder to update the address in the t_address table. Also,should I schedule to run the stored produre every day inorder to update the new coustomer addresses.
kindly assist me.
Thank you,
Revanth Kumar Anne
Revanthe,
Like I said, we took the original procedure and customized it. We have the routine set to run in a nightly job.
Here is what our job is set to do:
lp_tech_cleanup_nameandaddress_nightly@list_no = 155,@list_no_exclude = 166,@update_sals = 'Y',@increment = 1
I'll have to download the original again and see what the procedure name is. But essentially, you need to create a job and have it execute the procedure with any required parameters.
Christian