Attaching excel file automatically

conradcliff · Sep 5th, 2009, 1:52 AM

Hey guys, I just spent the last couple of hours installing version 1.5 only to find out there is a much more powerful version to be had so that has me a little bummed (the reason why it took me so long is because I have no idea what I'm doing with websites yet). What I'm wondering before I switch over to the newer version is if I can have it automatically attach the excel file of the form submittals when It emails me. I want to be able to open the file in google docs to automatically/partially fill out our customer contracts.

If there is anyway to do this and anyone has a clue on how it would be done and would like to share those clues I would be much obliged.

Thanks a ton!

***Ben*** · Sep 7th, 2009, 9:37 AM

Hi Conrad,

Welcome to the forums! Sorry you missed the fact that FT2 was out - I've been intending to set ft2.formtools.org as the main formtools.org domain, but there's just been too much to do. Soon!

Regarding your requirement, sure, this is no problem. However, you will need to send your emails with SMTP using the Swift Mailer module. I'd recommend asking your hosting providers if they offer SMTP (most do, these days).

And here's the documentation on how to attach files to your emails.
http://modules.formtools.org/swift_maile...ttachments

Good luck! Smile

- Ben

conradcliff · Sep 7th, 2009, 2:38 PM

Wow, thanks so much for the info!! That's just excellent! So, do I need to upgrade to the latest and greatest to do this or will the old form do the job...and if it will do the job do you think I should upgrade anyway though this is all I really need?

Thanks again for the help!!

***Ben*** · Sep 8th, 2009, 6:54 PM

Hey Conrad,

Unfortunately, the old Form Tools (1.5.1 or earlier) won't work, so you'll probably need to upgrade. ALSO unfortunately, there's no smooth way to upgrade - they're very different scripts, despite the name. You can check out this module, though:
http://modules.formtools.org/ft1_data_im...tation.php

It's for porting data from an old Form Tools 1 database into Form Tools 2. It's not perfect, but it's a start!

Anyway, all the best.

Ben

conradcliff · Sep 11th, 2009, 6:24 AM

Sounds good, I don't really have anything important in the database at this point so I'm cool with starting over. Do I just need to delete the form tools folder off my server and that will take care of the uninstall?

***Ben*** · Sep 13th, 2009, 9:59 AM

Huh! You know, in all the years I've done this project I've never even thought *once* about uninstallation. I'm kinda surprised...

In case you haven't already done so, install FT2 and port over your forms using that module I mentioned and reconfigure them to point to F2 instead of 1. Once that's done, and your forms now being stored propertly in FT2, yes, you can delete the old Form Tools folder. You'll probably want to delete the old database tables, too.

Ben

FORUMS