With that, be advised of keeping the link between the main ticket and the attachment ticket alive if you archive. We hit a limit on our Centralized Attachment Pool, so we do a sort of reverse archiving now. We have created attachment pools by year, and built into our workflow, depending on when the ticket was created, (actually when an attachment was added), that it reference the form associated with that year. I could go into more details, but just food for thought right now.
Darrell E Reading II Contact Center Development Wal-Mart 45739 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ################## ################## ################## ################## ################## ################## ################## ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bryan Waters Sent: Friday, December 14, 2007 11:12 To: [email protected] Subject: Re: How many attachments? ** Kevin, I would recommend that you store attachments in a separate centralized data table. This will provide 3 main benefits: 1) The load time of a ticket will be less since the attachments do not have to be fetched when querying. 2) You are not bound to a finite number of attachments. Use a GUID value to relate the data ticket to the attachment records. This will allow a "n" number of attachments. 3) You can reuse the centralized attachment form for other applications Cheers, Bryan From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Amen, Kevin Sent: Friday, December 14, 2007 11:26 AM To: [email protected] Subject: How many attachments? ** Are there any "gotchas" with having 20 attachment fields in an attachment pool? Kevin Amen Novartis Vaccines & Diagnostics Information Technology 510.923.3691 (Office) / 510.520.4060 (Cell) __20060125_______________________This posting was submitted with HTML in it___ Email Disclaimer This email has been sent from the TuringSMI Group This message is subject to and does not create or vary any contractual relationship between TuringSMI, SMI Technologies, SMI Telco, its subsidiaries or affiliates and you. Internet communications are not secure and therefore the TuringSMI Group does not accept any legal responsibility for the contents of this message. Any views or opinions expressed are those of the author. This message is intended for the addressee(s) only and its contents and any attached files are strictly confidential. If you have received it in error, please contact the sender on the number above. __20060125_______________________This posting was submitted with HTML in it___ ----------------------------------------- ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error destroy it immediately. ********************************************************************** Wal-Mart Confidential ********************************************************************** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
