Hello,
We are trying to produce accurate analytics data, one of the issues we are running into is our razors edge conversion into tesS threw data all over the place (contributions dated in 2009 showing up in 2016 campaigns etc) i tried to delete some of these old campaigns but im assuming once they have contributions registered to them they cannot be deleted. Is there a option to completely wipe the tess database and if so what are some of the consequences once done? Please let me know!
Thanks,
Julian
Hi Julian,
We had some similar conversion errors from razor's edge with contributions going in the wrong campaign and I was successful in doing some clean up of that using SQL UPDATE statements directly in SSMS - although depending on the exact nature of the errors that may or may not be as simple or useful to you as it was for me (thankfully ours were pretty much one to one errors - so I could take all contributions with a specific combination of fund and campaign and update them to the correct campaign). You should of course make sure that the Fund/Campaign structure and dates in Tessitura are correct for the updates you're going to make first.
I'm by no means an expert on any of this (a SQL beginner myself!) but I would think you should be able to get your data cleaned up without anything as drastic as "wiping" the database!
Best of luck,
Sarah Covie
Thank you! I will see what i can do in SSMS its a start!
Great! Just make sure you're narrowing down your WHERE clause as much as possible (by date range, fund, etc) so you only affect the contributions with errors, and DEFINITELY make sure you try it out in TEST first!
Hi Julian -
Before making any kind of direct database updates we always recommend testing them in your Test environment first and checking with all stakeholders (finance, development, etc.) to ensure that the data looks good and that you can still interact with the related contributions in the application without error. Database updates to financial transactions can be very tricky and are typically not advised at all.
That all being said, it may be good to open a support ticket with us to review the data, especially if the Network was involved in the data conversion. While the exact fixes may be outside the scope of standard support, a support agent would be happy to point you in the right direction.
Patrick