Okay, if you look under the Defaults.pm file you will see a section under the comment "CustomerUser stuff". The customer is configured there starting with the line "Self->{CustomerUser}". The line that says "Map => [" is the start of parameters for the customer user. All you have to do is add a line for the expiration date as well as add the field into your database. Sorry I am unsure about the rest of the question. Having it change a customer to be invalid automatically is beyond my knowledge but possible you could create a GenericAgent that could do this that will run once every night. Hope that helps. Dan King Software Developer Canadian Resident Matching Service 613.237.0075 ext. 241 (Toll free) 877.CARMS.42 171 Nepean Street, Suite 300 Ottawa, ON, CAN K2P 0B4 www.carms.ca http://www.carms.ca ------------------------------------------------------------------------------------ This e-mail message, including any attachments, is for the sole use of the intended recipients and may contain confidential and or privileged information. If you are not the intended recipient or this information has been forwarded in error, please contact the sender by reply e-mail and destroy copies of the original message. Ce message (incluant toute pièce jointe) s'adresse uniquement au(x) destinataire(s) prévu(s) ou à une personne autorisée à le recevoir en son (leur) nom. Il pourrait contenir des renseignements confidentiels ou protégés. Si vous l'avez reçu par erreur, nous vous prions d'en informer l'auteur dans les meilleurs délais, de ne pas divulguer son contenu et de le supprimer de votre système. Merci. ________________________________ From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Jonathon Sent: August 2, 2007 2:45 PM To: 'User questions and discussions about OTRS.org' Subject: [otrs] Adding a database field I need to add an expiration date to the customer_user table. I need to figure out how to add the expiration date to the Customer_User interface and automatically set a user to invalid when that date arrives? Any ideas from anyone on how to do this?