UPDATED FEATURE - Email Templates code updated for new storage

When I initially implemented the Email Templates feature, I did not anticipate that it would become as popular as it seems to have become. At this point, I see that 1676 clubs are using this feature.

When I first implemented the feature, I used a simplistic storage mechanism. That storage mechanism has since needed to be changed to allow for more storage usage (and more email templates), and I have completed an update that accomplishes this. This was no small feat. I had to convert all of your data for the email templates into a totally new storage mechanism in the FTH database in addition to creating updated code for accessing it. I have been working on this conversion over the last few months.

Now email templates are stored in a dedicated table in our database. I have also made a few very minor changes to the implementation that you may notice:

1. The selection drop-down in the in pop-ups for the email templates tools is now sorted.
2. The Delete Email Template tool was added ... it was broken out of the Save Email Template tool for this.
3. The Email Templates implementation now saves and restores the *Subjects* of emails in templates along with the email bodies. Keep this in mind so that you do not accidentally overwrite an email subject that you just typed in.

*** Let me know if you run into any problems with your email templates. I have kept the data in the old storage in case I needed to do a data recovery after the switch over to the new data storage... keep that in mind. I will delete that old data storage in about a month or two, but I have it for now.

So excited to see these upgrades. Thank you!

Hey, we are seeing our templates duplicated in club 1928. Any chance you imported the data twice? Or maybe the select out of the database is causing this?

Are you able to just delete the duplicates?

I could try to do the data conversion again, but I do not want to lose any new data created in the new data table.

I didn't want to do anything until you reviewed it and determined the problem.

If you are confirming there are duplicates in the database based on titles, then I will attempt to delete them if you wish.

I agree that I don't want you to do the migration again since that will wipe out some changes I have made.

I need a club number to do anything. You have posted 45 times in the forums, yet still no club number. Not helpful. You could just put it in your forum signature... that would be simple.

I included club 1928 in the initial post. And thanks for the suggestion to add it to my signature. Done. If there is anything else I can do to help, just let me know.