MySQLTalk.org MYSQL discussions groups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Any easy ideas how to mass close issues?          MySQLTalk.org Forum Index -> Eventum General Discussion View previous topic :: View next topic   Author Message Minick, Robert Guest Posted: Mon May 07, 2007 3:00 am    Post subject: Any easy ideas how to mass close issues? I have a issue with EVentum where I have hundreds of issues that remain open, and need to be closed in one mass swoop. I don't want to delete them because the information containted in them is slightly important. Anyway, does anyone have a script handy that can do this? I'm not an expert in SQL to say the least, and looking at it all, I get a bit lost.. Thanks in advance.. This e-mail transmission contains information that is confidential and may be privileged. It is intended only for the addressee(s) named above. If you receive this e-mail in error, please do not read, copy or disseminate it in any manner. If you are not the intended recipient, any disclosure, copying, distribution or use of the contents of this information is prohibited. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please erase it from your computer system. Your assistance in correcting this error is appreciated. Back to top Barry Benowitz Guest Posted: Mon May 07, 2007 5:24 pm    Post subject: RE: Any easy ideas how to mass close issues? Hi Robert, If you permissions are high enough, you should have access to the bulk update screen. I am not sure if close is an option, though. Barry -----Original Message----- From: Minick, Robert [mailto:Robert.Minick (AT) 53 (DOT) com] Sent: Sunday, May 06, 2007 6:00 PM To: eventum-users (AT) lists (DOT) mysql.com Subject: Any easy ideas how to mass close issues? I have a issue with EVentum where I have hundreds of issues that remain open, and need to be closed in one mass swoop. I don't want to delete them because the information containted in them is slightly important. Anyway, does anyone have a script handy that can do this? I'm not an expert in SQL to say the least, and looking at it all, I get a bit lost.. Thanks in advance.. This e-mail transmission contains information that is confidential and may be privileged. It is intended only for the addressee(s) named above. If you receive this e-mail in error, please do not read, copy or disseminate it in any manner. If you are not the intended recipient, any disclosure, copying, distribution or use of the contents of this information is prohibited. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please erase it from your computer system. Your assistance in correcting this error is appreciated. -- Eventum Users Mailing List For list archives: http://lists.mysql.com/eventum-users To unsubscribe: http://lists.mysql.com/eventum-users?unsub=barry.benowitz (AT) raritan (DOT) com Back to top Minick, Robert Guest Posted: Mon May 07, 2007 7:21 pm    Post subject: RE: Any easy ideas how to mass close issues? Its not. :( I can change who it's assigned to and whatnot, but that's not an option. Back to the drawing board I suppose.... or closing them all by hand. :( -----Original Message----- From: Barry Benowitz [mailto:barry.benowitz (AT) raritan (DOT) com] Sent: Monday, May 07, 2007 8:24 AM To: Minick, Robert; eventum-users (AT) lists (DOT) mysql.com Subject: RE: Any easy ideas how to mass close issues? Hi Robert, If you permissions are high enough, you should have access to the bulk update screen. I am not sure if close is an option, though. Barry -----Original Message----- From: Minick, Robert [mailto:Robert.Minick (AT) 53 (DOT) com] Sent: Sunday, May 06, 2007 6:00 PM To: eventum-users (AT) lists (DOT) mysql.com Subject: Any easy ideas how to mass close issues? I have a issue with EVentum where I have hundreds of issues that remain open, and need to be closed in one mass swoop. I don't want to delete them because the information containted in them is slightly important. Anyway, does anyone have a script handy that can do this? I'm not an expert in SQL to say the least, and looking at it all, I get a bit lost.. Thanks in advance.. This e-mail transmission contains information that is confidential and may be privileged. It is intended only for the addressee(s) named above. If you receive this e-mail in error, please do not read, copy or disseminate it in any manner. If you are not the intended recipient, any disclosure, copying, distribution or use of the contents of this information is prohibited. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please erase it from your computer system. Your assistance in correcting this error is appreciated. -- Eventum Users Mailing List For list archives: http://lists.mysql.com/eventum-users To unsubscribe: http://lists.mysql.com/eventum-users?unsub=barry.benowitz (AT) raritan (DOT) com -- Eventum Users Mailing List For list archives: http://lists.mysql.com/eventum-users To unsubscribe: http://lists.mysql.com/eventum-users?unsub=robert.minick (AT) 53 (DOT) com This e-mail transmission contains information that is confidential and may be privileged. It is intended only for the addressee(s) named above. If you receive this e-mail in error, please do not read, copy or disseminate it in any manner. If you are not the intended recipient, any disclosure, copying, distribution or use of the contents of this information is prohibited. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please erase it from your computer system. Your assistance in correcting this error is appreciated. Back to top Anthony Chivetta Guest Posted: Mon May 07, 2007 8:25 pm    Post subject: Re: Any easy ideas how to mass close issues? * Minick, Robert <Robert.Minick (AT) 53 (DOT) com> [2007-05-06 18:00:17 -0400]: Quote: I have a issue with EVentum where I have hundreds of issues that remain open, and need to be closed in one mass swoop. I don't want to delete them because the information containted in them is slightly important. Change the status you want to set them to to not repersent a closed issue (in the admin interface). Use the bulk update tool, change the status back to representing a closed issue. Hope that helps. -- Anthony Chivetta Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         MySQLTalk.org Forum Index -> Eventum General Discussion All times are GMT Page 1 of 1   Jump to: Select a forum MySQL----------------MySQL and JavaMySQL AnnouncementsMySQL++MySQL and .NETMySQL ODBCMySQL and PerlDatabase BenchmarksMySQL BugsMySQL Cluster DiscussionMySQL CommunityMySQL DocumentationEventum DevelopmentEventum General DiscussionMySQL General DiscussionMySQL GUI ToolsMySQL InternalsMySQL CommitsMaxDBMySQL PackagersMySQL Replication DiscussionBrisbane MySQL Users GroupMySQL on Win32  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.