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

------------------------------------------------------------------------------------

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?