TOPIC:

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.

I think you should be fine now. Thx for the heads up.

BTW, just a clarification. With the new dedicated db table, each email template is now stored in its own individual record in the table as opposed to being lumped together with all the others for a club.

I tweaked this a little bit. Now there is a checkbox (checked by default) in the Save Template dialog that allows you to save or not save the email subject in the template. When you load the template, it will only load the subject if it is not blank in the template. This gives you the option of having it either way... saving the email subject in the template or not saving it.