***UPDATED*** DB Technosystems Form Processor 02/09/2011

Navaldesign · Post by **Navaldesign** » Sun Jul 12, 2009 3:57 pm

You can do this yourself setting the max filesize, in the extension. However i will add the ability to send attachments, then each one can decide for himself....

star57 · Post by **star57** » Sun Jul 12, 2009 7:23 pm

Guys, My Form works with Captcha - Goes to a differant page but still works great!

Navaldesign · Post by **Navaldesign** » Sun Jul 12, 2009 11:01 pm

Further Update:

Added Ability to send uploaded files as attchments.
Added ability to limit the total attachments size so the mail will not be blocked by ISPs.

Uploaded files storage on server is now optional.

Added Includes! You can now add your own code in 6 different points of the script. This way you can add custom validation, or further mailing, or submitting to yet another script using CURL, or creating and including a Preview Page, or checking specific fields, or creating custom emails, or.... anything you can think of!

The PHP code will also be soon available for anyone that desires to analyze the script for creating his own custom code.

Database storage is scheduled for some time next week.

BaconFries · Post by **BaconFries** » Sun Jul 12, 2009 11:55 pm

What can I say......

thanks.....

kevinp · Post by **kevinp** » Mon Jul 13, 2009 9:38 am

As usual this is genius and extremely useful.

I've added the line

Code: Select all

date_default_timezone_set('Europe/London');

as you can see below to give me the correct local time.

Code: Select all

<?php
// This script was created by DBTECHNOSYSTEMS.com ----
// Â© DBTechnosystems.com http://www.dbtechnosystems.com
// You may use this script but please leave author details here

// *****I've added the line below to correct the server time to my local time*****
date_default_timezone_set('Europe/London');

if($_SERVER['REQUEST_METHOD'] == 'POST')

{
error_reporting(55);

Just one question.

I've added some code to create a unique ID (Below)

Code: Select all

//set the random id length 
$random_id_length = 8; 

//generates a random id encrypt it and store it in $rnd_id 
$rnd_id = crypt(uniqid(rand(),1)); 

//removes any slashes that might have been generated
$rnd_id = strip_tags(stripslashes($rnd_id)); 

//Removing any . or / and reversing the string 
$rnd_id = str_replace(".","",$rnd_id); 
$rnd_id = strrev(str_replace("/","",$rnd_id)); 

//finally take the first 8 characters from the $rnd_id 
$rnd_id = substr($rnd_id,0,$random_id_length); 
// I've added this later in the echo and e-mail
//echo "When contacting us please quote: $rnd_id"; 
//Converts the reference to uppercase
$rnd_id = strtoupper($rnd_id);

and I'm able to echo this into the headers, mail ends etc by adding $rnd_id to the text but it does not save in the CSV file (presumably because it isn't a form field).

Is there a way to include it or do I need something like a prefixed autonumber field as a edit box on the form itself.

Thanks for sharing your brilliant work.

Navaldesign · Post by **Navaldesign** » Mon Jul 13, 2009 10:12 am

Why do you add all this in the code ?

As you might have seen, the script supports includes.

So you can simply create an external php file:

Code: Select all

<?
date_default_timezone_set('Europe/London');

//set the random id length 
$random_id_length = 8; 

//generates a random id encrypt it and store it in $rnd_id 
$rnd_id = crypt(uniqid(rand(),1)); 

//removes any slashes that might have been generated 
$rnd_id = strip_tags(stripslashes($rnd_id)); 

//Removing any . or / and reversing the string 
$rnd_id = str_replace(".","",$rnd_id); 
$rnd_id = strrev(str_replace("/","",$rnd_id)); 

//finally take the first 8 characters from the $rnd_id 
$rnd_id = substr($rnd_id,0,$random_id_length); 
// I've added this later in the echo and e-mail 
//echo "When contacting us please quote: $rnd_id"; 
//Converts the reference to uppercase 
$rnd_id = strtoupper($rnd_id);

$_POST['Submission ID'] = $rnd_id; // This line adds in the POST superglobal the unique ID you created
$autoresponderend .= "\nWhen contacting us please quote: $rnd_id"; // This line adds to the autoresponder footer the message with the quote ID
?>

and load it on the server as (just an example name) "start.php"

then add it's url (simply "start.php" , if it is in the same folder as the form page) in the "After Form Data Reception Include URL"

I have not tested it but it SHOULD work!

Navaldesign · Post by **Navaldesign** » Mon Jul 13, 2009 10:22 am

Yes, Just tested it and it does work.

Test it yourself at http://www.dbtechnosystems.com/wb6/forms/index1.php

kevinp · Post by **kevinp** » Mon Jul 13, 2009 10:25 am

Ahh. I wasn't using the latest version. You updated it again last nite. My fault, I wasn't paying attention (heavy workload at the moment).

Thanks again

star57 · Post by **star57** » Mon Jul 13, 2009 11:20 am

Naveldesign, This is a great extension! Thank you for all the hard work on this. I for one highly appreciate it and look forward to other enhancements, like the logo portion!

Again Thanks!

Navaldesign · Post by **Navaldesign** » Thu Jul 16, 2009 5:19 pm

A new version has been uploaded. It has the following FEATURES ADDED:

1. Logo inclusion in the mails
2. Added Timezone setting
3. Added automatic CSV file column addition
4. Added file type validation for Uploaded files.

The Manual has also been updated with the new features.

You can test in http://www.dbtechnosystems.com/wb6/forms to receive the autoresponder mail and see for your self.

me.prosenjeet · Post by **me.prosenjeet** » Thu Jul 16, 2009 5:22 pm

Simply WOW!!!!

"All hale Naval, hale to thee"

star57 · Post by **star57** » Thu Jul 16, 2009 7:01 pm

Ok, I need to buy you a whiskey shot and a beer, GREAT WORK

zinc · Post by **zinc** » Thu Jul 16, 2009 7:03 pm

I second what these guys have said. My client was so chuffed about this as the booking form was the only part that made his site interesting thanks to you. Once again THANK YOU George!

P.S. Love the LOGO feature!!! Really cool!

star57 · Post by **star57** » Thu Jul 16, 2009 7:27 pm

Naveldesign, I am so sorry. But the auto responder feature is not working on this version. My setting with Autoresponder and Customer Email field is correct. Course I could be doing something wrong!

http://www.star57.com/contactus.php

I followed the new manual and tested with differant 3 emails, I get the Administrative email, but not the customer email.

Thanks Naveldesign (George)

Logo Feature is the best , Your da man...

me.prosenjeet · Post by **me.prosenjeet** » Thu Jul 16, 2009 7:32 pm

Wonder if I did something wrong!
My forms were working perfect with the first version of this extension. Now when I upgraded to the latest with logo, when the form is submitted, the admin is getting a mail but no details only an attachment called 'noname' and when I download that it turns out to be a zip file and inside it is a file (with no extension) called "noname' it is about 7kb in size and the recepient isnt getting any mail.

By the way, I dont need data in CSV/CSV for Excell on the server, how to turn that off??

These are my settings, please diagnose whats wrong where...my otherwise working form is stuck!

This is the form link : http://au.lucknowwebs.net/getaquote.html
There are three forms there...I have tried the 2nd (I would like to interact with visitors) and 3rd one (I would like to transact business, I want advanced features like ecommerce capability?)

Navaldesign · Post by **Navaldesign** » Thu Jul 16, 2009 7:43 pm

Star:

Since i can't see your settings, I can't know what you might have been doing wrong. Just to be on the safe side, i installed the extension directly from the uploaded zip and i tested it again and it works just fine.

Make sure that you have set the Autoresponder to "Yes"

prosenjeet: this might be an issue with the form, not the processor. Your forms action is null ?? action = ""

Edit and test. Since this is a form in frame, you might need to set the form action manually, to be the form page itself.

me.prosenjeet · Post by **me.prosenjeet** » Thu Jul 16, 2009 7:50 pm

Navaldesign wrote: prosenjeet: this might be an issue with the form, not the processor. Your forms action is null ?? action = ""

Edit and test. Since this is a form in frame, you might need to set the form action manually, to be the form page itself.

My form action is set to <? Echo $_SERVER[â€˜PHP_SELFâ€™];?>
Encoding is - Multipart/form-data
My form target = "_parent" this is put in "inside tag" as suggested by you sometime back for opening inline forms success page on parent page.

Funny part is, this same form was working with the first release of your extension perfectly and I didnt change any settings in the form but updated your extension.
Any help will be appreciated

star57 · Post by **star57** » Thu Jul 16, 2009 7:51 pm

Navel,
http://www.star57.com/form.txt
Double checked the items upi listed//

Thanks

Navaldesign · Post by **Navaldesign** » Thu Jul 16, 2009 7:57 pm

me.prosenjeet wrote:
Navaldesign wrote: prosenjeet: this might be an issue with the form, not the processor. Your forms action is null ?? action = ""

Edit and test. Since this is a form in frame, you might need to set the form action manually, to be the form page itself.
My form action is set to <? Echo $_SERVER[â€˜PHP_SELFâ€™];?>
Encoding is - Multipart/form-data
My form target = "_parent" this is put in "inside tag" as suggested by you sometime back for opening inline forms success page on parent page.

Funny part is, this same form was working with the first release of your extension perfectly and I didnt change any settings in the form but updated your extension.
Any help will be appreciated

The action results null for some reason. Manually set each form action to be the page itself. In example, if the form page is "form.php" set the action to be "form.php"

me.prosenjeet · Post by **me.prosenjeet** » Thu Jul 16, 2009 8:09 pm

As suggested by you, I chaged the form action from <? Echo $_SERVER[â€˜PHP_SELFâ€™];?> to the form page name.
See the form settings I have and uploaded in the same way but still the submit email is same as I mentioned earlier.

Navaldesign · Post by **Navaldesign** » Thu Jul 16, 2009 8:38 pm

There doesn't seem to be anything wrong with your settings. It is also true that the extension sends out email normally, i tested it so many times, and other users here might also confirm this.

Please make sure that the email field is named "email" . If you can, send me your page (form page) code.

star57 · Post by **star57** » Thu Jul 16, 2009 8:41 pm

Navaldesign wrote:There doesn't seem to be anything wrong with your settings. It is also true that the extension sends out email normally, i tested it so many times, and other users here might also confirm this.

Please make sure that the email field is named "email" . If you can, send me your page (form page) code.

Star or me. ?

If for ME. I confirm mine works great, expect the autoresponder... Thanks

me.prosenjeet · Post by **me.prosenjeet** » Thu Jul 16, 2009 8:46 pm

Naval,
Sent the forms to you at your "info" ID please check

me.prosenjeet · Post by **me.prosenjeet** » Thu Jul 16, 2009 9:26 pm

Any luck Naval?

Navaldesign · Post by **Navaldesign** » Thu Jul 16, 2009 10:40 pm

Prosenjeet: Please check your mailbox

me.prosenjeet · Post by **me.prosenjeet** » Fri Jul 17, 2009 12:55 am

Thanks Naval,
I tried that and the result I have mailed to you.
Issue is with the email that the admin is getting ...it is all HTML code. However, the form submitter email is working, showing all the details and the logo. However, the link on the logo is not the link that I set ...when the logo is clicked, it is opening the logo in a new window and not going to the site/url that I set it to go.
Try the form here : http://au.lucknowwebs.net/getaquote.html

star57 · Post by **star57** » Fri Jul 17, 2009 1:51 am

Naval, Works great thank you so much! Like Me. Stated the URL does not work on the Logo, But I dont use that anyway.. GREAT JOB !!! Just Amazing... Thank You!

Navaldesign · Post by **Navaldesign** » Sat Jul 18, 2009 6:38 am

July 18 update:

Fixed : issue with Gmail online email viewer
Fixed : Logo link issue (pointing to the image itself instead of the desired URL)
Fixed : file extensions not always correctly recognized

Please re-download and re-install the extension.

star57 · Post by **star57** » Sat Jul 18, 2009 6:24 pm

Navel, All I get in Inbox.com and Yahoo is the code for the submission! Plain Text. The email before it is in HTML and the one behind is Html.

Navaldesign · Post by **Navaldesign** » Sat Jul 18, 2009 9:35 pm

Update:

A further version is uploaded.

It SHOULD resolve all issues with Inbox, yahoo and ALL other webmail providers as well as desktop email clients.

The mailing engine has been replaced and now the famous phpmailer class is used to guarantee correct emailing.

Using PHPMAiler has also allowed to embed the Logo image in the mail, so your users will not need to unblock the logo image anymore. As a result of using PHPMailer, the Logo image path has become RELATIVE instead of absolute (if the logo.jpg image is in the same folder, the path should be simply "logo.jpg")

Please note that now the script will create a subfolder named "dbts_includes" with the PHPMailer Class files.

This is normal, do NOT worry!

PHPMailer also allows SMTP authentication whenever necessary, which we will add as soon as possible.

Please download and replace the extension with the new one.

me.prosenjeet · Post by **me.prosenjeet** » Sun Jul 19, 2009 12:37 am

Hi Naval,
Thanks for this update. Works great but the Logo isnt coming in mail.
The path to my logo is set as : http://au.lucknowwebs.net/images/Logo.png
Do I need to change?
I am getting this image at the logo place in the email:

When right clicking on it to see location or image details it shows: "Not Available" but when I chk the extension again, the logo link is placed correct

Navaldesign · Post by **Navaldesign** » Sun Jul 19, 2009 5:45 am

As mentioned in my abobe post, you must ONLY place the RELATIVE path to the image (please also look at UPDATED instructions in the Manual)

So in the Image field you should ONLY type : images/Logo.png

star57 · Post by **star57** » Sun Jul 19, 2009 12:41 pm

Navel, Everything is working great, thank you so much!

K

Navaldesign · Post by **Navaldesign** » Mon Jul 20, 2009 9:48 am

Date, IP address and Bowser are hardcoded. Though it is possible to take them out, it must be implemented (as Administrator options) in the next update.

The next update will include the following features:

1. Database storing: you will be able to store the info in a database. The script also will offer automatic table and columns creation as well as automatic addition of new columns (if new fields are added in the form in a second time)

2. Sendmail (or Qmail) or SMTP mailing engine. These are standard features of the PHPMailer class (used by the script as mailing engine) but have not yet been implemented in the processor. Implementing them will solve issues with hosting companies that don't support the mail() function.

3. Option for HTML or Text Only mails. Text only emails garantee maximum deliverability and require less resources. However, the HTML email, as designed, will give practically zero issues, as the Logo image is embedded in the email and not an externally linked image.

Estimated release date: Fri July 24 2009.

me.prosenjeet · Post by **me.prosenjeet** » Mon Jul 20, 2009 3:32 pm

Naval,
The Auto responder mail that the form submitter gets with all the entries, is there a way we add a line with a link in it for these visitors in that email?

Navaldesign · Post by **Navaldesign** » Mon Jul 20, 2009 4:06 pm

Yes, you can easily do it.

In the Autoresponder footer text, type, in example:

Thank you for contacting us!Visit <a href=\"http://www.dbtechnosystems.com\"> DB Technosystems.com </a>

Note how double quotes must be escaped (backslash)

me.prosenjeet · Post by **me.prosenjeet** » Mon Jul 20, 2009 4:20 pm

Navaldesign wrote:Yes, you can easily do it.

In the Autoresponder footer text, type, in example:

Thank you for contacting us!Visit <a href="http://www.dbtechnosystems.com"> DB Technosystems.com </a>

Note how double quotes must be escaped (backslash)

<?php
$myString = "Hello Naval!";
echo $myString;
echo "<h5>You are a darling, Thank you Again!</h5>";
?>

star57 · Post by **star57** » Mon Jul 20, 2009 4:39 pm

For myself, I dont see a reason for this. As the user would have filled out the form anyway from the site. For now the form processor is everything I would need for a response. I save my emails in my customer folders, not outlook so I dont need a Database or CVS file. Most people just want you to get back with them.

me.prosenjeet · Post by **me.prosenjeet** » Mon Jul 20, 2009 4:43 pm

star57 wrote:For myself, I dont see a reason for this. As the user would have filled out the form anyway from the site. For now the form processor is everything I would need for a response. I save my emails in my customer folders, not outlook so I dont need a Database or CVS file. Most people just want you to get back with them.

See I have 4 forms on my site and this is for a form that is for contact only prompting the visitor to another form if he has missed that one...try this : http://au.lucknowwebs.net/contactus.php

iamafireman · Post by **iamafireman** » Sat Jul 25, 2009 3:06 am

How do you set the timezone. USA, central time zone

i keep getting this:
Fatal error: Call to undefined function: date_default_timezone_set() in /test/index.php on line 90

star57 · Post by **star57** » Sat Jul 25, 2009 3:22 am

America/Indiana/Knox

use the above

Navaldesign · Post by **Navaldesign** » Sat Jul 25, 2009 4:56 am

iamafireman2 wrote:How do you set the timezone. USA, central time zone

i keep getting this:
Fatal error: Call to undefined function: date_default_timezone_set() in /test/index.php on line 90

This means that your hosting account php version doesn't support this function or it has it disabled. Which version of php are you running ?

If there is no way to enable it you might have to wait later today, when the new version (some more cool features...) will be uploaded, which will be disabling this feature if the function doesn't exist.

BaconFries · Post by **BaconFries** » Sat Jul 25, 2009 3:13 pm

Another update...things do get better

great work as always....thanks

iamafireman · Post by **iamafireman** » Mon Jul 27, 2009 8:08 pm

well i tried America/Indiana/Knox and that didnot work so i guess that feature is the enabled. i am running 4.3.11 i ran the phpinfo file on the server to see if that feature was enabled but wasnt sure what its called. i didnot see a time/date feature. i guess i'll patiently wait till the update comes out thanks nav

zinc · Post by **zinc** » Mon Jul 27, 2009 8:16 pm

Navaldesign; Sorry did you say there was a way to hide the technical data from the footer (IP address, etc,....)? or this is something you are implementing.

BTW, my client loved the result of the form. Thank you again.

Navaldesign · Post by **Navaldesign** » Mon Jul 27, 2009 8:20 pm

Implemented but not released yet, probably later today or tomorrow morning.

zinc · Post by **zinc** » Mon Jul 27, 2009 8:21 pm

Navaldesign wrote:Implemented but not released yet, probably later today or tomorrow morning.

Cheers!

Navaldesign · Post by **Navaldesign** » Mon Jul 27, 2009 9:24 pm

Ok, the new release is uploaded.

New / Improved Features:

New: Database Storage.
New: SMTP, Sendmail, Qmail mail engine (and the mail() as standard)).
New: tecnical info can be excluded
New: Copy values Into a Session Array and From a session array (thus creating Multipage forms just with a few clicks!)

Improved: Mail can now be either HTML or Text, set by the administrator
Improved: HTML emails now have Alternative text with the same info
Improved: Timezone setting backward compatible with those servers that don't support the date_default_timezone_set() function

Please visit the Original Post in this very same thread to download.

zinc · Post by **zinc** » Mon Jul 27, 2009 9:41 pm

Navaldesign wrote:Ok, the new release is uploaded.

New / Improved Features:

New: Database Storage.
New: SMTP, Sendmail, Qmail mail engine (and the mail() as standard)).
New: tecnical info can be excluded
New: Copy values Into a Session Array and From a session array (thus creating Multipage forms just with a few clicks!)

Improved: Mail can now be either HTML or Text, set by the administrator
Improved: HTML emails now have Alternative text with the same info
Improved: Timezone setting backward compatible with those servers that don't support the date_default_timezone_set() function

Please visit the Original Post in this very same thread to download.

Superb George. Thank you.

Navaldesign · Post by **Navaldesign** » Fri Jul 31, 2009 9:49 pm

You

1. Uncheck the "Use Built in Form Processor" and set the action and encoding type as per manual
2. Drag the DBTS Form Processor object, anywhere in your page, doesn't need to be on the form.
3. Add the hidden field "formid" and give it whatever value you want.
4. Double click the DBTS Form Processor object so that the Properties window opens, and setup the processor as you like.

Save, Publish, Refresh your browser, Test

www.wysiwygwebbuilder.com

UPDATED DB Technosystems Form Processor 02/09/2011