Why our extensions?
- High Quality, Tested and Approved
- Unlimited Domain License
- Dedicated Support Team
- Free Updates
- Easy to Install and Use

Form to Excel

Questions

How do I set write permissions on the required folder?

How can I edit the "Form2Excel.php" document so that when the email comes through, it has the email address and subject filled out from the user on the form, instead of the default values?

Can the form send a CC to the user as well? We want the user to receive a copy of the email for their records with a "thank you" comment at the top.

Can I use Form to Excel and Mail and Form Captcha in the same form ?

I am getting them email with form submission and the data is being saved in the excel file, but the attachments are not coming through ...why?

Is there any way to see the data on the web or do I have to download the CSV file to see it everytime?

I'm having problems with the encoding of special characters, there is a work around?

Is it possible using this tool to send through multiple selections in the same list box?

I'm not receiving any mail, why?

How can I configure Form2Excel with a different email server and with SMTP authentication?

I'm getting a blank email. Why?

Can I put delivery email address into the php page itself? I don't want it as a hidden field in the HTML on the page.

The data.csv result file is being created / updated in multiple places. There is a way to fix it?

When I double click the MXP file I'm getting this error: "Extension requires more recent version of Macromedia Extension Manager". How can I solve this?

I have problems while downloading the file. How can I download it?

I don't have a credit card. Are there alternative payment options?

Do you offer a multi-domain license?

I'm getting this error message "Is not possible to create data structure.". What's happening?

Can I pay using my credit card ?

Can I use these extensions with MACs ?

I have downloaded the new program, but cannot seem to access it from the command panel.

I'm getting this message "Please define your site first.". What I should do?

This extension works with Dreamweaver CS5?

When I preview my web page after I get this message in my Internet Explorer,"To help protect your security, Internet Explorer has restricted...". What is the problem?

Note about sales taxes.

I'm getting this error: "TypeError: THE_DOM has no properties" . There is a workaround?

I'm getting the error "Can't update menus. Extension will not be installed". What is the solution?

Answers

How do I set write permissions on the required folder?

Form2Excel requires to set write permissions on folder "HDWForm2Excel/saved_forms".

For Linux/Unix servers

FTP programs ("clients") allow you to set permissions for files and directories on your remote host. This function is often called chmod or set permissions in the program menu.

In the first image, look at the last column - that shows the permissions. It looks a bit confusing, but for now just note the sequence of letters:



Right click the folder or files to set permissions, and usually a popup screen will appear (see the second image):



Don't worry about the check boxes. Just delete the 'Numeric value:' and enter the number you need - in this case it's 777 or simply mark all checkboxes. Then click OK.

That's all.

For Windows servers

There should be an option in your web hosting control panel to set write permissions. If it's not present, you may can contact your web hosting service and request the write permissions for the PHP code.



How can I edit the "Form2Excel.php" document so that when the email comes through, it has the email address and subject filled out from the user on the form, instead of the default values?

You can apply the following changes:

Change #1: Subject, line #660:
 
$emailsubject=  $_POST["name-of-the-subject-field-on-your-form"];
 
Change #2: From Name (add this one), line #597:
 
$mail->FromName = $_POST["name-of-the-name-field-on-your-form"];
 
Change #3: From Email, line #598:
 
$mail->From     = $_POST["name-of-the-email-field-on-your-form"];

Replace the strings marked in red with the field names from your form.


Can the form send a CC to the user as well? We want the user to receive a copy of the email for their records with a "thank you" comment at the top.

Yes, it's possible. Add this code at line # 699 (into the PHP file):

send_mail($_POST["clientemail"], $fromaddress, $emailsubject, "Thank you!" . $body, $attachments);

In your form "clientemail" is the name of the field where the client enter his email address.



Can I use Form to Excel and Mail and Form Captcha in the same form ?

To put Form to Excel and Mail and Form Captcha together in the same form, please follow these steps:
  1. Insert Form to Excel and Mail into your form as always.
  2. Once inserted Form to Excel and Mail, insert Form Captcha.
  3. Select the file "HDWForm2Mail/Form2Excel.php" as the page to protect.
  4. Click the "Browse" button to select this file.
  5. Configure others parameters of Form Captcha in the "Insert Captcha" setup window
  6. Update all the files in your web server.
These automatically will generate all the code needed to achieve the functionality.


I am getting them email with form submission and the data is being saved in the excel file, but the attachments are not coming through ...why?

Please add the enctype="multipart/form-data" and method="post" attribute for uploads

<form action="/HDWForm2Excel/Form2Excel.php" method="post" enctype="multipart/form-data">

These attributes are requiredin order to upload files using the form.


Is there any way to see the data on the web or do I have to download the CSV file to see it everytime?

We have a little script that allow you to check the CSV directly on the web. You will find it into the folder "utils (optional)" into the downloaded file. Just upload the "viewcsv.php" into the folder that contains the CSV file.


I'm having problems with the encoding of special characters, there is a work around?

Follow these steps:

  1. Add the char-set that you are using into your <FORM ...> tag, example:

    <form
    accept-charset="iso-8859-1" ...

  2. Open the file "HDWForm2Mail/Form2Excel.php" and put SPECIAL_CHARACTERS to true on line #92:

    define('SPECIAL_CHARACTERS', true);
  3. Specify your char-set again on line #93:

    define('CHAR_SET', "iso-8859-1");
Sample charsets:
  • utf-8
  • windows-1256
  • iso-8859-1


Is it possible using this tool to send through multiple selections in the same list box?

Yes, you can use <select multiple="multiple" ...> and <select multiple ...> tags.

In PHP, to be able to post select multiple fields you need to add the characters [] at the end of the field's name, example:

<select name="items[]" size="5" multiple="multiple">


I'm not receiving any mail, why?

Most probably it's due to a spam filter in your email server. Check your spam filter settings to avoid being classified as spam (adding the "from" email into the address book or into the "trusted" list).


How can I configure Form2Excel with a different email server and with SMTP authentication?

If you want to use an external email server, you can do the following:

STEP 1- Go to Line #823 and configure the Form2Excel.php file to send primary via SMTP:
 
    var $Mailer            = "mail";
 
...change by:
 
    var $Mailer            = "smtp";
 
Note: This first step is required only in a few servers, in most cases Form2Excel detects automatically that the available method is SMTP.
 
STEP 2- Go to Line #59 and put there your SMTP server address if is different than "localhost"
 
  define('SMTP_SERVER', 'localhost');
 
 
Note: STEPS 3 and 4 are required only if your server required authentication. If authentication is not required, please ignore these steps:
 
STEP 3- Go to Line #63 to activate authentication:
 
  define('USE_SMTP_AUTHENTICATION', false);
 
...change by:
 
  define('USE_SMTP_AUTHENTICATION', true);
 
STEP 4- On the lines #64 and #65 put your username and password.



I'm getting a blank email. Why?

Some hosting services (like Yahoo Hosting Servers) have some restrictions for HTML formatted emails. Using plain text email will solve this problem. Follow these steps:
  1. Open the Form2Excel.php file
  2. Go to line #91
  3. Set the USE_HTML_FORMATTING constant to false:

    define('USE_HTML_FORMATTING', false);
That's all.


Can I put delivery email address into the php page itself? I don't want it as a hidden field in the HTML on the page.

Yes, it's possible. The PHP file is open for edition. For this change, go to the line #653 (into the PHP file) and change this line:

$emailaddress= getHDWForm2MailParam(HDW_F2M_EMAIL);

...by this one:

$emailaddress= "your-own-email@yourdomain.com";



The data.csv result file is being created / updated in multiple places. There is a way to fix it?

That happens if your website appears under various canonical domain names or IP addresses. To solve that problem open the Form2Excel.php file, go to the line #99 and fix the folder postfix there, example:

define('FOLDER_POSTFIX', '8n5f');



When I double click the MXP file I'm getting this error: "Extension requires more recent version of Macromedia Extension Manager". How can I solve this?

Download the most recent version of the Adobe/Macromedia Extension Manager or the version related to your Dreamweaver version:

http://www.adobe.com/exchange/em_download/

After installed open the MXP file from the Extension Manager menu to be sure that you are installing the extension using the correct Extension Manager.



I have problems while downloading the file. How can I download it?

If you purchased the product using Google Checkout, the instructions for accessing your purchase will appear in a yellow box at the top of your Order Receipt page (into your Google Checkout account):



After accessing that link you will get a copy of the product and a copy of the download link will be sent to your email address. If you have not received the email, please check your spam/bulk mail folder.

If you lost both download links, please contact our support service and we will send you a new download link. Please include the email used for payment in your message;


I don't have a credit card. Are there alternative payment options?

We accept Paypal and MoneyBookers, both services allow (indirect) payments through bank transfers.

Moneybookers is accepted in almost all countries.


Do you offer a multi-domain license?

All extensions have an unlimited domain license. You can use them in all your web sites.


I'm getting this error message "Is not possible to create data structure.". What's happening?

Please, change the "Links relative to" setting in the site configuration options (Dreamweaver 8 or later).

If this setting does not solve the problem, then follow these steps:

  1. Restart Dreamweaver
  2. Be sure that you have a local web site defined in Dreamweaver
  3. Open the page where you want to insert the extension(this page must be saved previously into your web site)
  4. Try to insert the extension again


Can I pay using my credit card ?

Yes, Paypal allows you to pay directly using your credit card.

We also accept MoneyBookers (accepts credit cards when uploading funds).


Can I use these extensions with MACs ?

Yes, you can. These extensions are tested in all actual browsers and used from Dreamweaver on both platforms, PC and MAC.


I have downloaded the new program, but cannot seem to access it from the command panel.

Did you restart Dreamweaver after double clicking the MXP file? Please remember to restart Dreamweaver after double clicking the MXP file.


I'm getting this message "Please define your site first.". What I should do?

It's required to define a working site in Dreamweaver because Dreamweaver needs to know where to place the files.

Download here a PDF document with help about defining a site in Dreamweaver.



This extension works with Dreamweaver CS5?

Yes, all our extensions are compatible with the most recent Dreamweaver versions, including Dreamweaver MX, Dreamweaver MX 2004, Dreamweaver 8, Dreamweaver CS3, Dreamweaver CS4 and Dreamweaver CS5.


When I preview my web page after I get this message in my Internet Explorer,"To help protect your security, Internet Explorer has restricted...". What is the problem?

If you are testing your page directly from your local hard disk in IE 7, this message appears:

"To help protect your security, Internet Explorer has restricted this webpage from running scripts or ActiveX controls that could access your computer. Click here for options."

In IE 7 this message appears when you test a web page that contains a script or Flash item directly form your local hard disk. When you upload your page to an online web server that message does not appear.

The address from a web server must start with http:// or https:// . On the other hand if the address starts with C:\ or file:// then you are testing it from your local hard disk.

Just upload your web page to your web site and you will see that the error disappears.



Note about sales taxes.

No sales tax is charged when you purchase via PayPal. You can order via PayPal with a credit card even if you do not have a PayPal account. PayPal's status as a financial institution exempts PayPal orders from sales tax. CodePeople will be the retailer of record. CodePeople is based in Switzerland and does not have any US sales tax obligations.


I'm getting this error: "TypeError: THE_DOM has no properties" . There is a workaround?

Please follow these steps:
  1. Check if  you have defined a local web site at dreamweaver.
  2. Check if you have saved the page into your local web site.
  3. If you are using Dreamweaver templates, check if your templates allow an "Editable Region" in the <HEAD> section of the HTML code.
  4. Mark the "Use case-sensitive link checking" option in the site settings and recreate your site cache.
  5. After these checks, please restart your Dreamweaver and try again.
If the above actions don’t solve the problem, then probably the reason is a wrong HTML structure in the page that you are trying to use the product, in this case, please check the page’s HTML structure and if you cannot find the problem then contact our support service.


I'm getting the error "Can't update menus. Extension will not be installed". What is the solution?

That's due to a bug in the Adobe Extension Manager that sometimes corrupts the "Menus.xml" file. That file can be found in the following location:

Windows users: C:\Documents and Settings\[UserName]\Application Data\Macromedia\Dreamweaver [version]\Configuration\Menus\menus.xml

Mac users: HD:Users:username:Library: Application Support:Macromedia:Dreamweaver [version]:Configuration:Menus:Menus.xml

To fix this problem close your Dreamweaver and try the following:

  1. Un-install all your extensions and then re-install them one at a time. This will work in most cases.
  2. If the above doesn't work then delete the "Menus.xml" file. After this you will need to disable and enable your extensions in order to get the menu entries again.
  3. If none of the above works then there is more than one file corrupted, the solution in this case will be to completely uninstall Dreamweaver and reinstall it again.


CATEGORYPRODUCTS
  • Dreamweaver Extensions
  • Dreamweaver Templates
  • Services
  • More Extensions & Products
  • Support