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

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

me.prosenjeet · Post by **me.prosenjeet** » Sat Aug 01, 2009 5:23 pm

Navaldesign wrote: New: Copy values Into a Session Array and From a session array (thus creating Multipage forms just with a few clicks!)

Naval a question not directly related to this extension.

If I create a multipage form which has 4 forms on 4 different pages interrelated and to submit and send email only when the last form in sequence is filled and submitted, do we have submit button on all the forms to move to the next page form or how this happens?
In this same situation, which page will bear this extension? The last one or all?

Navaldesign · Post by **Navaldesign** » Sat Aug 01, 2009 7:25 pm

me.prosenjeet wrote:
Navaldesign wrote: New: Copy values Into a Session Array and From a session array (thus creating Multipage forms just with a few clicks!)
Naval a question not directly related to this extension.

If I create a multipage form which has 4 forms on 4 different pages interrelated and to submit and send email only when the last form in sequence is filled and submitted, do we have submit button on all the forms to move to the next page form or how this happens?
In this same situation, which page will bear this extension? The last one or all?

All pages will have the extension. ALL pages will need the submit button.

Each form page will have as success page the next form page except the last one that will send the user to the success page.

First Form will have the Copy in Session enabled.

Intermediate form pages will have BOTH Copy From Session AND Copy in Session.

Last form page only needs the Copy From Session enabled.

Only the Last page should have mails and eventually storage enabled.

me.prosenjeet · Post by **me.prosenjeet** » Sun Aug 02, 2009 5:14 am

Navaldesign wrote: All pages will have the extension. ALL pages will need the submit button.

Each form page will have as success page the next form page except the last one that will send the user to the success page.

First Form will have the Copy in Session enabled.

Intermediate form pages will have BOTH Copy From Session AND Copy in Session.

Last form page only needs the Copy From Session enabled.

Only the Last page should have mails and eventually storage enabled.

That works perfect Naval! One issue, remember you helped me with the cost.php that calculated the cost...that is not showing. I tried various permutation combination but no success. The multi foerm can be viewed here :
http://lucknowwebs.com.au/page1.php

Since the fields covered in cost.php comes on the second page of the form, I had set the "After form data reception include" to cost.php in the second form. And on form three(the final submit page) the field "Page or Script to be include before script end" as cost.php.

Navaldesign · Post by **Navaldesign** » Sun Aug 02, 2009 5:48 am

Page three has nothing to do with it as the values that contribute to the cost calculation only exist in the second form.

The include i made for you was for a single page form, not a multipage one.

You should change the ending part as follows:

.....................................
if ($_POST['Ecommerce_enable_$200'] == "Yes"){
$total += 200;
}
$POST['Total_Cost'] = "$". $total;
$fieldname[] = "Total Cost";
$fieldvalue[] = "$". $total;

?>

As you see only the last part changes.

me.prosenjeet · Post by **me.prosenjeet** » Sun Aug 02, 2009 6:48 am

Since the fields covered in cost.php comes on the second page of the form, I had set the "After form data reception include" to cost.php in the second form. And on form three(the final submit page) the field "Page or Script to be include before script end" as cost.php.

The settings remain as mentioned above?
I am getting this error when I submit page 2:

Warning: Cannot modify header information - headers already sent by (output started at /home2/lucknoww/public_html/lucknowwebs.com.au/cost.php:46) in /home2/lucknoww/public_html/lucknowwebs.com.au/page2.php on line 503

and the browser is not moving to page3.php

Navaldesign · Post by **Navaldesign** » Sun Aug 02, 2009 7:12 am

1. Yes
2. This is --I believe-- because you had a white line in the cost.php script AFTER the closing ?> tag which resulted in a screen output.

I fixed it for you (still have your login details.....) please test it

However, practical feedback is the only way to test. Based on your experience i found out that the Autoresponder email might NOT be sent if the email field isn't in the last page. So i updated the extension.

Please download and install again version 1.9

Having updated it, you might now be receiving the Total Cost twice, if that is the case revert back to the previous cost.php version.

jerryco · Post by **jerryco** » Sun Aug 02, 2009 7:33 am

Can you make a Captcha error appear above the Captcha field without losing visitor input?

Navaldesign · Post by **Navaldesign** » Sun Aug 02, 2009 7:57 am

Jerry82 wrote:Can you make a Captcha error appear above the Captcha field without losing visitor input?

This extension has nothing to do with the captcha.

Anyway, i will answer you: though it is possible to do what you are asking, it is not possible to do it with WB6's built in captcha. Further more, to acheive such a task, you would need to use Javascript or Ajax. Since spammers and bots have Javascript disabled, in order to overide whatever validation you might have set, this validation will also be disablesd.

So your only 100% sure solution, in order not to lose the filled in values (exeption made for the upload fields, where this is not possible anyway) would be to follow my instructions as seen in this thread: viewtopic.php?t=14938

However, if you want real visitors(which normally have Javascript enabled) to get an alert on the page itself (as the other WB6 built in validations) then a further extension would be able to do it. I might have a look if i have some time.

jerryco · Post by **jerryco** » Sun Aug 02, 2009 8:09 am

Thank you for your quick reply. Would an ajax check work if a visitor has javascript disabled?

Navaldesign · Post by **Navaldesign** » Sun Aug 02, 2009 8:15 am

No.

Ajax is based on a Javascript event listener, to trigger the HTTPRequest. If Javascript is disabled it will not work.

me.prosenjeet · Post by **me.prosenjeet** » Sun Aug 02, 2009 8:17 am

Naval...
http://lucknowwebs.com.au/check/page1.php
The settings for each page as under(screenshots):
http://lucknowwebs.com.au/cheeck/page1.jpg
http://lucknowwebs.com.au/cheeck/page2.jpg
http://lucknowwebs.com.au/cheeck/page3.jpg
This trial system is in a folder 'cheeck' and the cost.php is kept in it.

The issue is when the form is finally being submitted, the data from page1.php is not coming in the email and the page2.php data is starting with the total cost (which is supposed to go at the end of page2.php data)and the submit button of page2 is being displayed as a field.

See the screen shot of the mail here:
http://lucknowwebs.com.au/cheeck/mailtoadmin.jpg

Navaldesign · Post by **Navaldesign** » Sun Aug 02, 2009 8:26 am

Did you update the extension / republished as i advised ?

me.prosenjeet · Post by **me.prosenjeet** » Sun Aug 02, 2009 8:28 am

Yes, I suppose this is the latest update you uploaded and when I uploaded it to the trial folder, I did a 'full upload'

me.prosenjeet · Post by **me.prosenjeet** » Sun Aug 02, 2009 8:49 am

:Update:
Naval,
Actually if you look at the mail screen shot...

http://lucknowwebs.com.au/cheeck/mailtoadmin.jpg

it is sending the data of all the three forms but in a different order...
page2.php first (starting with the total value)
page1.php second (starting from 'Name')
page3.php third (starting from 'Need hosting at.....')

Further, after rectifying this anyway I can highlight the text or the field "Total cost" in the HTML email?

Navaldesign · Post by **Navaldesign** » Sun Aug 02, 2009 9:02 am

I update the extension approx 40 mins ago based on your remarks.

Did you update in the last 40 mins ???

me.prosenjeet · Post by **me.prosenjeet** » Sun Aug 02, 2009 9:25 am

Oh no I didnt do it before 40mins... I will do it now and come back to you again

me.prosenjeet · Post by **me.prosenjeet** » Sun Aug 02, 2009 9:44 am

Ok, I updated kept the settings of all the pages same as in the earlier posts..(check the jpeg)
http://lucknowwebs.com.au/cheeck/page1.jpg
http://lucknowwebs.com.au/cheeck/page2.jpg
http://lucknowwebs.com.au/cheeck/page3.jpg

Still not correct...this is the mail I got:
http://lucknowwebs.com.au/cheeck/mailtoadmin2.jpg
Please check that...it doesnt send the total cost and the page1.php part of the form is missing

Further in the settings, I have 'Yes' for sending mail to admin and automail on the page1.php and page2.php, I suppose I need to remove that. It is sending a mail moment any of the pages are submitted.

Navaldesign · Post by **Navaldesign** » Sun Aug 02, 2009 9:53 am

Sure....
You changed folder and you didn't copy the "cost.php" file.

And, in page 1, you have NOT set the "Copy in Session" to be "Yes" . You have set the "Copy From Session" to be "Yes".

me.prosenjeet · Post by **me.prosenjeet** » Sun Aug 02, 2009 10:29 am

Thanks Naval,
Thanks for pointing out the errors ...it seems to work perfect only that the first form Submit button (Button1 Submit) is coming as a field in the email.(Wonder why it is coming while the same button on form 2 isnt coming that way!)
Also please tell me how I can highlight the field "Total Cost" in the email...with some colour in text or background maybe.
Please see the screen shot of the email:

http://lucknowwebs.com.au/cheeck/mailtoadmin3.jpg

Navaldesign · Post by **Navaldesign** » Sun Aug 02, 2009 10:58 am

The button is included in the fields because you didn't name it "submit" as the manual instructs, you have left the default name "Button1"

If it is the same in the other pages too, only one value is received, so check also your other pages.

There is no way to highlight a specific cell of the HTML email directly from the script settings as this is not a planned function.

You can, however, try this, in your "cost.php"

$fieldvalue[] = "<font style=\"background-color:#FFFF00\">."$". $total."</font>";

me.prosenjeet · Post by **me.prosenjeet** » Sun Aug 02, 2009 12:01 pm

Naval,
Renamed it to submit and that was rectified!
I wonder how you seem to know everything...Thanks a lot!

One thing....

Navaldesign wrote:You can, however, try this, in your "cost.php"

$fieldvalue[] = "<font style="background-color:#FFFF00">."$". $total."</font>";

Getting this error with this line:

Code: Select all

Parse error: syntax error, unexpected '$' in /home2/lucknoww/public_html/lucknowwebs.com.au/cheeck/cost.php on line 41

Line 41 is the line that was edited

Navaldesign · Post by **Navaldesign** » Sun Aug 02, 2009 12:43 pm

Sorry, my mistake:

$fieldvalue[] = "<font style=\"background-color:#FFFF00\">$". $total."</font>";

me.prosenjeet · Post by **me.prosenjeet** » Sun Aug 02, 2009 12:50 pm

Thanks let me try that

me.prosenjeet · Post by **me.prosenjeet** » Sun Aug 02, 2009 4:12 pm

Naval,
There is an issue with that code you sent.
Whenever, I tried replacing the original -

$fieldvalue[] = "$". $total;

with this-

$fieldvalue[] = "<font style=\"background-color:#FFFF00\">$". $total."</font>";

--First, the mail that comes after submitting the form is going to the spam folder and thats not good.
--Second, the added background colour is not showing and it shows as it was before

Any suggestions?

Navaldesign · Post by **Navaldesign** » Sun Aug 02, 2009 4:37 pm

I can't answer you on why it goes to the spam folder simply because we add a background color to a field text! It makes no sense.

I have still your login details, I'll check for myself.

me.prosenjeet · Post by **me.prosenjeet** » Sun Aug 02, 2009 4:51 pm

Check it after 5 minutes form now, I just changed the code. Uploading the one with the edit you suggested in 2 minutes.
Update: You may try now

Navaldesign · Post by **Navaldesign** » Sun Aug 02, 2009 6:08 pm

I can't know about the issue with the mail ending up in your spam folder. In my email it is all ok.

I fixed the background, download from your server the updated cost.php file.

I was forgetting that this is the second page, so it was the $POST[] =...... line that needed the background added.

me.prosenjeet · Post by **me.prosenjeet** » Sun Aug 02, 2009 6:27 pm

Wow !!!!!!!!
It worked thanks a load once again...you are a Saviour for sure

me.prosenjeet · Post by **me.prosenjeet** » Sun Aug 02, 2009 8:18 pm

Sandyfishgirl wrote:I'm just trying this form and ok, until I get to the "I. Mail Engine Settings". Up to this point, I am following instructions to build the form - but I don't know anything about this section. Checking websites for this information, is not helping me a lot.

I "think" I should just leave the setting as Mail() function. I will not allow uploads or data storage.

Is there a place where I can read more on the subject of mail engine settings - in SIMPLE terms? Then I will know the correct information for my form.

Under "Visual Settings" the color picker is WAY

- - it JUST hit me what this extension does - I was thinking it WAS A FORM, with the auto responder built-in ha ha
Now, that I'm with the "program" I think I still need the first issue (mail engine settings) answered. BUT now, I should also know - - WHERE on my page should this extension be placed in relation to my form? Next to it? on top of it? Within the "grid"? Under the kitchen sink?

THANK YOU!!

If you read the pdf thats enclosed along with the download that may sort some of the questions in mind.
Regarding your last question whether to place the extension under the kitchen sink, yes you may do that and still it will work...thats the beauty of this extension just put it on any damn place on the form page and wallah! it fires!

Navaldesign · Post by **Navaldesign** » Sun Aug 02, 2009 8:58 pm

Sandyfishgirl wrote:I "think" I should just leave the setting as Mail() function. I will not allow uploads or data storage.

mail() will be ok in most cases. Just in those "difficult" cases where SMTP authentication is required or the mail() is not enabled, you should use SMTP.
Last, for those rare cases where everything else will fail, Sendmail is the last alternatice.

Under "Visual Settings" the color picker is WAY

- - it JUST hit me what this extension does - I was thinking it WAS A FORM, with the auto responder built-in ha ha
Now, that I'm with the "program" I think I still need the first issue (mail engine settings) answered. BUT now, I should also know - - WHERE on my page should this extension be placed in relation to my form? Next to it? on top of it? Within the "grid"? Under the kitchen sink?

Under the sink is as good as any other place. In other words, anywhere.

To be honest, This form processor is actually an evolution of ABVFP. The next update, will allow php validations:

required field, list of values, text , number, email, zip codes, passwords, password strength, equal fields, credit cards, and probably more.

The Includes allow advanced users to embed their own code in the script so it can perform calculations, validations, cross checks, create files, update multiple database tables, whatever other task you can think of, that can be performed using php code. It also allows for preview pages and multipage forms. It allows (just as me.prosenjeet did) to create a calculation script and add it's results in the mail. And much more!

jerryco · Post by **jerryco** » Mon Aug 03, 2009 8:04 am

Navaldesign wrote:No.

Ajax is based on a Javascript event listener, to trigger the HTTPRequest. If Javascript is disabled it will not work.

What about 'sending' the info to the next page with the error message. Would that be a watertight solution?

Navaldesign · Post by **Navaldesign** » Mon Aug 03, 2009 9:11 am

Jerry82 wrote: What about 'sending' the info to the next page with the error message. Would that be a watertight solution?

I'm not sure what the purpose of this would be. I mean, as i said, Javascript (or Ajax) validation is fine as long as the user is not a spammer / hacker.

When it comes to those, only PHP validation can really protect you.
And PHP validation will be the next implementation to the form processor.

However, PHP validation means that the script finds the errors, and displays an error page which reports the errors, it then has a "Back" button to get the user back to the form page.
Or, it can also return the user back to the form page, and display the errors in a "error" div.
Now, assuming that the form also has a captcha, this means that most probably the values that the user had filled in will be lost. So you need to implement a mechanism that will allow to keep these values.

There are many ways to aceive this, from using sessions to posting back the values (others too, more complicated)

Al of these solutions require some experience from the user, as they are not of standard implementation.

DBTS Form processor has two cool features that makes this implementation easier: the Copy in Session tool, and the User Includes. The first will automatically copy the submitted values in the $_SESSION superglobal, so they can be retrieved easily. The second will allow advanced users to include in the processor whatever code snippet of their own, to acheive similar tasks.

Of course, you will need to add some code in the original WB form, in order to make it retrieve these values from the SESSIOn array or the POST array.

I plan to publish some tutorials on how to perform all of these tasks using DBTS Form Processor Extension, but it requires quite some time....

jerryco · Post by **jerryco** » Mon Aug 03, 2009 9:28 am

Thank you for explaining that.

heg · Post by **heg** » Thu Aug 06, 2009 3:12 am

Wow! this is great!!! Thanks Navaldesign... Tested and working!

kevinp · Post by **kevinp** » Fri Aug 07, 2009 7:57 am

What a fantastic script. It seems the posibilities are endless.

I've added the file below to 'After Form Data Reception Include URL' on the includes section.

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); 

$_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 
?>

which adds a unique ID to each email. This works fine but the ID doesn't save to the csv file. Is there a way to make the script include $rnd_id when it creates the CSV.

Also, If I wanted to echo some of the form fields to the success page as a confirmation of the submission is this possible using the Copy in or Copy from session options. I can't seem to identify the correct $names to show the fields.

Cheers
Kev

www.wysiwygwebbuilder.com

UPDATED DB Technosystems Form Processor 02/09/2011

Re: Question about mail engine settings

Re: Question about mail engine settings