• Replies 12 replies
  • Subscribers 337 subscribers
  • Views 29 views
  • Users 0 members are here
Related

Deleting a CC when a patron requests it

Chris Jensen
$organization

Today a patron requested that we not store her credit card, which had been used previously for a number of orders. A Box Office staffer tried to delete the card in Tessitura, but of course the client complained that it couldn't do that since the CC is referenced "elsewhere in the system".

It is possible to borrow some code from the "Purge Credit Card Account Data" report to do this sort of thing, but we are wondering - what do other orgs do in a case like this? Is there a better way?

TIA for any replies.

  • $organization

    Hi Chris-

    We have a SP that clears out the account information for a single constituent or list, I would be happy to share and will upload the code to my files.

    Is that what you were thinking you would need?

    Thanks,
    Paul 

  • $organization in reply to Paul Kappel

    Unknown said:

    We have a SP that clears out the account information for a single constituent or list, I would be happy to share and will upload the code to my files.

    Is that what you were thinking you would need?

    Hi, Paul-- 

    I do have some code to do this, indeed borrowed from "Purge Credit Card Account Data" and modified for a specific project, but yours sounds more polished. Please share!

    Thanks.

  • $organization

    We inactivate CCs when a patron wants it removed from their account.  Since we can’t delete it as a one off because it’s been used in a transaction, we just inactivate so it can’t be used again.  I love the idea of a utility that will make it possible to completely remove CC accounts individually.  If you don’t mind sharing with us Paul, I’d love a copy of your stored procedure as well.

     

    Teresa

     

    Teresa Dean  Tessitura Systems Director
    2403 Flora Street  Dallas, Texas 75201
    direct line  214-978-2865  fax  214-954-9936    mobile 972-835-3225
    teresa.dean@attpac.org  |  www.attpac.org

     

    Our nonprofit mission: To provide a public gathering place that strengthens community and fosters creativity through the presentation of performing arts and arts education programs.

     

     

    This electronic mail transmission is confidential, may be privileged and should be read or retained only by the intended recipient. If you have received this transmission in error, please immediately notify the sender and delete it from your system.

  • $organization

    We inactivate CCs when a patron wants it removed from their account.  Since we can’t delete it as a one off because it’s been used in a transaction, we just inactivate so it can’t be used again.  I love the idea of a utility that will make it possible to completely remove CC accounts individually.  If you don’t mind sharing with us Paul, I’d love a copy of your stored procedure as well.

     

    Teresa

     

    Teresa Dean  Tessitura Systems Director
    2403 Flora Street  Dallas, Texas 75201
    direct line  214-978-2865  fax  214-954-9936    mobile 972-835-3225
    teresa.dean@attpac.org  |  www.attpac.org

     

    Our nonprofit mission: To provide a public gathering place that strengthens community and fosters creativity through the presentation of performing arts and arts education programs.

     

     

    This electronic mail transmission is confidential, may be privileged and should be read or retained only by the intended recipient. If you have received this transmission in error, please immediately notify the sender and delete it from your system.

  • $organization

    We inactivate CCs when a patron wants it removed from their account.  Since we can’t delete it as a one off because it’s been used in a transaction, we just inactivate so it can’t be used again.  I love the idea of a utility that will make it possible to completely remove CC accounts individually.  If you don’t mind sharing with us Paul, I’d love a copy of your stored procedure as well.

     

    Teresa

     

    Teresa Dean  Tessitura Systems Director
    2403 Flora Street  Dallas, Texas 75201
    direct line  214-978-2865  fax  214-954-9936    mobile 972-835-3225
    teresa.dean@attpac.org  |  www.attpac.org

     

    Our nonprofit mission: To provide a public gathering place that strengthens community and fosters creativity through the presentation of performing arts and arts education programs.

     

     

    This electronic mail transmission is confidential, may be privileged and should be read or retained only by the intended recipient. If you have received this transmission in error, please immediately notify the sender and delete it from your system.

  • $organization

    We inactivate CCs when a patron wants it removed from their account.  Since we can’t delete it as a one off because it’s been used in a transaction, we just inactivate so it can’t be used again.  I love the idea of a utility that will make it possible to completely remove CC accounts individually.  If you don’t mind sharing with us Paul, I’d love a copy of your stored procedure as well.

     

    Teresa

     

    Teresa Dean  Tessitura Systems Director
    2403 Flora Street  Dallas, Texas 75201
    direct line  214-978-2865  fax  214-954-9936    mobile 972-835-3225
    teresa.dean@attpac.org  |  www.attpac.org

     

    Our nonprofit mission: To provide a public gathering place that strengthens community and fosters creativity through the presentation of performing arts and arts education programs.

     

     

    This electronic mail transmission is confidential, may be privileged and should be read or retained only by the intended recipient. If you have received this transmission in error, please immediately notify the sender and delete it from your system.

  • $organization

    We inactivate CCs when a patron wants it removed from their account.  Since we can’t delete it as a one off because it’s been used in a transaction, we just inactivate so it can’t be used again.  I love the idea of a utility that will make it possible to completely remove CC accounts individually.  If you don’t mind sharing with us Paul, I’d love a copy of your stored procedure as well.

     

    Teresa

     

    Teresa Dean  Tessitura Systems Director
    2403 Flora Street  Dallas, Texas 75201
    direct line  214-978-2865  fax  214-954-9936    mobile 972-835-3225
    teresa.dean@attpac.org  |  www.attpac.org

     

    Our nonprofit mission: To provide a public gathering place that strengthens community and fosters creativity through the presentation of performing arts and arts education programs.

     

     

    This electronic mail transmission is confidential, may be privileged and should be read or retained only by the intended recipient. If you have received this transmission in error, please immediately notify the sender and delete it from your system.

  • $organization

    We inactivate CCs when a patron wants it removed from their account.  Since we can’t delete it as a one off because it’s been used in a transaction, we just inactivate so it can’t be used again.  I love the idea of a utility that will make it possible to completely remove CC accounts individually.  If you don’t mind sharing with us Paul, I’d love a copy of your stored procedure as well.

     

    Teresa

     

    Teresa Dean  Tessitura Systems Director
    2403 Flora Street  Dallas, Texas 75201
    direct line  214-978-2865  fax  214-954-9936    mobile 972-835-3225
    teresa.dean@attpac.org  |  www.attpac.org

     

    Our nonprofit mission: To provide a public gathering place that strengthens community and fosters creativity through the presentation of performing arts and arts education programs.

     

     

    This electronic mail transmission is confidential, may be privileged and should be read or retained only by the intended recipient. If you have received this transmission in error, please immediately notify the sender and delete it from your system.

  • $organization

    We inactivate CCs when a patron wants it removed from their account.  Since we can’t delete it as a one off because it’s been used in a transaction, we just inactivate so it can’t be used again.  I love the idea of a utility that will make it possible to completely remove CC accounts individually.  If you don’t mind sharing with us Paul, I’d love a copy of your stored procedure as well.

     

    Teresa

     

    Teresa Dean  Tessitura Systems Director
    2403 Flora Street  Dallas, Texas 75201
    direct line  214-978-2865  fax  214-954-9936    mobile 972-835-3225
    teresa.dean@attpac.org  |  www.attpac.org

     

    Our nonprofit mission: To provide a public gathering place that strengthens community and fosters creativity through the presentation of performing arts and arts education programs.

     

     

    This electronic mail transmission is confidential, may be privileged and should be read or retained only by the intended recipient. If you have received this transmission in error, please immediately notify the sender and delete it from your system.

  • $organization

    We inactivate CCs when a patron wants it removed from their account.  Since we can’t delete it as a one off because it’s been used in a transaction, we just inactivate so it can’t be used again.  I love the idea of a utility that will make it possible to completely remove CC accounts individually.  If you don’t mind sharing with us Paul, I’d love a copy of your stored procedure as well.

     

    Teresa

     

    Teresa Dean  Tessitura Systems Director
    2403 Flora Street  Dallas, Texas 75201
    direct line  214-978-2865  fax  214-954-9936    mobile 972-835-3225
    teresa.dean@attpac.org  |  www.attpac.org

     

    Our nonprofit mission: To provide a public gathering place that strengthens community and fosters creativity through the presentation of performing arts and arts education programs.

     

     

    This electronic mail transmission is confidential, may be privileged and should be read or retained only by the intended recipient. If you have received this transmission in error, please immediately notify the sender and delete it from your system.

  • $organization

    We inactivate CCs when a patron wants it removed from their account.  Since we can’t delete it as a one off because it’s been used in a transaction, we just inactivate so it can’t be used again.  I love the idea of a utility that will make it possible to completely remove CC accounts individually.  If you don’t mind sharing with us Paul, I’d love a copy of your stored procedure as well.

     

    Teresa

     

    Teresa Dean  Tessitura Systems Director
    2403 Flora Street  Dallas, Texas 75201
    direct line  214-978-2865  fax  214-954-9936    mobile 972-835-3225
    teresa.dean@attpac.org  |  www.attpac.org

     

    Our nonprofit mission: To provide a public gathering place that strengthens community and fosters creativity through the presentation of performing arts and arts education programs.

     

     

    This electronic mail transmission is confidential, may be privileged and should be read or retained only by the intended recipient. If you have received this transmission in error, please immediately notify the sender and delete it from your system.