• Replies 5 replies
  • Subscribers 412 subscribers
  • Views 136 views
  • Users 0 members are here
Related

Changing a Special Activity date on mass

Joshua Forward
$organization

Hi guys,

We recently had to change the date of a planned special activity, but already had the special activity in everyone's profile on a now incorrect date. Are we able to change the date of an activity for everyone or will this have to be a manual process?

Thanks,

Josh

 

  • $organization

    Hi Josh,

    The Manage Special Activity utility has an update mode. The utility documentation says that it updates the activity records with the selected Activity Type and Date for all constituents on the selected list. The Host and Number of Attendees fields are only updated if there is not already an existing value in those fields on the existing activity record.

    Michele

  • $organization in reply to Michele Keutsch

    Hi Michele,

     

    Thanks but this didn't work for us, as it demands providing the date as criteria for finding the event to update, if that makes sense. Am I missing something? Using the manage special activity in reports and utlities.

    Thanks,

    Josh

  • $organization in reply to Joshua Forward

    Sorry that didn't work.  The only way that it could be mass updated then would be to create some sql code to do the update.

    Michele

  • $organization

    Hi, this is a thought, but would it work for you to create a new activity with the new date and correct information?  We have a status of canceled.  If you do not have it, that status can be added to the format table for special activity. You could then update the old activity date with that status and not include status type in any reports that are run. 

     

    Michelle Wohlers

    Tessitura and Data Services Manager

     

    2014/2015 International Season:

    La bohème, Don Giovanni, Nixon in China,

    50th Anniversary Celebration Concert

    http://www.sdopera.com/tickets/onsale

    San Diego Opera
    233 A Street, Suite 500

    San Diego, CA  92101

    Phone: (619) 232-7636 

    Fax: (619) 231-6915

    www.sdopera.com

     

     

     

     

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Michele Keutsch
    Sent: Tuesday, March 24, 2015 7:46 AM
    To: Michelle Wohlers
    Subject: Re: [Tessitura Development Forum] Changing a Special Activity date on mass

     

    Sorry that didn't work.  The only way that it could be mass updated then would be to create some sql code to do the update.

    Michele

    From: Joshua Forward <bounce-joshuaforward2767@tessituranetwork.com>
    Sent: 3/23/2015 6:41:22 PM

    Hi Michele,

     

    Thanks but this didn't work for us, as it demands providing the date as criteria for finding the event to update, if that makes sense. Am I missing something? Using the manage special activity in reports and utlities.

    Thanks,

    Josh




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

  • $organization in reply to Joshua Forward

    Hi Joshua,

    This happens to us occasionally and I do it with e bit of quick and easy SQL code.  Happy to supply this if you like.

    Martin