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

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

me.prosenjeet · Post by **me.prosenjeet** » Fri Aug 07, 2009 12:47 pm

kevinp wrote: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.
Kev

That will be so nice Naval, if it can be done...for example remember my cost.php so in the Thank you page it shows the total tentative cost.
Can that be done?

Navaldesign · Post by **Navaldesign** » Fri Aug 07, 2009 2:47 pm

kevinp wrote: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 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.

Change the code to

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 array 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
?>

Note the changed $POST instead of $_POST

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.

The easiest way is to add another include.
Lets suppose that you have created a success page, named "success.php". Write the text that you want to have in the page, and in the place of the variables that need to be merged, place this text (as an example):

'.$Name.'

This can be in the middle of a sentence, in which case it will be something like:

Hello '.$Name.' Thank you for your Submission! '

Obviously, $Name is the variable, EXACTLY as your form field (Name)

AVOID form field names with white spaces, in example "How did you find us", use underscores "How_did_you_find_us". The script will strip the underscores off when mailing you.

Right click the text and add the following in the Before tag of the text html:

<?
echo '

and in the After tag,

';
?>

Now, in Start of page add:

<?
extract($POST, EXTR_OVERWRITE);
?>

Set the form processor as follows:

After Processing Befavior : Include
Immediately the next field:

Page or script to include before script ends: success.php

Published the changed form page and the success page and test.

me.prosenjeet · Post by **me.prosenjeet** » Fri Aug 07, 2009 4:08 pm

Navaldesign wrote:
Set the form processor as follows:

After Processing Befavior : Include
Immediately the next field:

Page or script to include before script ends: success.php

Published the changed form page and the success page and test.

Naval, when I am using the cost.php, it is set at "Page or script to include before script ends:"(where you suggest to put success.php) when "After Processing Befavior" is set to 'Redirect'
So how do I alter the processor to get the $total from the cost.php in the success.php?

Navaldesign · Post by **Navaldesign** » Fri Aug 07, 2009 4:24 pm

Not sure I understand what you are saying.

cost.php should be included as "After Form Data Reception Include". And this ends the issue of calculating the Total cost.

To transmit the data to the success page follow the instructions in my previous post.

kevinp · Post by **kevinp** » Sat Aug 08, 2009 8:55 am

Thanks Naval, that works a treat. The id is stored and the info echo'd on the success page.

I get the following php warning messages at the top of the page;

Code: Select all

Warning: fread() [function.fread]: Length parameter must be greater than 0 in /home/a9368701/public_html/lcccsv/dbts_includes/dbts_functions.php on line 44

and

Code: Select all

Warning: unlink(database.csv) [function.unlink]: Permission denied in /home/a9368701/public_html/lcccsv/dbts_includes/dbts_functions.php on line 68

but it all seems to work OK.

I tried adding

Code: Select all

error_reporting(0); // Turn off all error reporting

to the start of page in the success.php file but this still shows the warnings

Cheers

Kev

kevinp · Post by **kevinp** » Sat Aug 08, 2009 9:04 am

Scrub that, I've sorted it.

Just add

Code: Select all

ini_set('display_errors', 1);
error_reporting(0);

to the start page section of the success.php page.

Thanks again Naval, you're a superstar.

Kev

star57 · Post by **star57** » Sun Aug 09, 2009 2:23 pm

Naval,
Thank you for all the hard work on the Form Processor, really amazing.

I looked through the forum, and PDF and I have a question. Is there a way to have when a user submits the form that it will display on a webpage or pop up with the info for verification before actually submitting the info.

Also, when there is an error in the form, when a user goes back to the form that the info is still filled out! and not blank!

Thanks

Navaldesign · Post by **Navaldesign** » Sun Aug 09, 2009 11:03 pm

Not sure what you mean "interconnected".
You mean that it is a multipage form ?

Anyway, the manual clearly says that you need to add a formid IF you have more than one forms in the same page.

Navaldesign · Post by **Navaldesign** » Sun Aug 09, 2009 11:07 pm

star57 wrote:Naval,
Thank you for all the hard work on the Form Processor, really amazing.

I looked through the forum, and PDF and I have a question. Is there a way to have when a user submits the form that it will display on a webpage or pop up with the info for verification before actually submitting the info.

Also, when there is an error in the form, when a user goes back to the form that the info is still filled out! and not blank!

Thanks

I will soon (probably tomorrow) post an updated version with minor improvements. In the new manual there will also be a "How to" section that will explain how to create preview pages, data merge success pages, and how to avoid the form being blank after a captcha error. Please note that this can NOT be acheived with the WB6 built in captcha, you will need to use the captcha as explained in the tutorial in viewtopic.php?t=6153

star57 · Post by **star57** » Mon Aug 10, 2009 6:41 pm

Awesome Naval! Thank you!

me.prosenjeet · Post by **me.prosenjeet** » Tue Aug 11, 2009 1:12 am

Naval,
Just one request...
Whenever you update the extension...please change the main topic like other extension developers do..
example:
Bacon's -- "***UpDated*** HighSlide JW Player 10/08/09"
This way it is easier for all to know that a new update has been made thats because when we enter the forum and search for new posts, your extension post will be visible with the update notice.

Great work mate, please keep it up!

star57 · Post by **star57** » Thu Aug 13, 2009 11:12 pm

Naval ,
Started using the new extension, Got to the point of Combbox, which is States or (State) in the name feild, I put
><?
If($State= ""){
echo '<option value="'.$State'">'. $State'</option>'
><
?

When Viewing the page I get

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ',' or ';' in /home/star7com/public_html/contactus.php on line 957

I took this out and the page shows up! So I used the Captcha from the PDF and works great but when I enter the wrong code or do not enter the code, I get the correct error, but the form is blank when going back.

I think I have everything set right?

In the code above, I see that in the PIc on the PDf it is differant than the code in the sentance
><?
If($State= ""){
echo '<option value="'.$State'">'. $State'</option>'
}
?

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

Thanks

Navaldesign · Post by **Navaldesign** » Sat Aug 15, 2009 11:18 am

Correct Code:

><?
If($State != ""){
echo '<option value="'.$State.'">'. $State.'</option>'
}
?

You have missed "!" before the first "=" and the dots

Is there a mistake in the Manual?

star57 · Post by **star57** » Sat Aug 15, 2009 11:37 am

Thanks Fabry,
The code does let the page load, as for it working I dont know.

Naval, the manual is right Periods and Exclamation points in the " I assumed was fairgame. I put the new code in and I continue to get the error on the page.

I tested the form with Fabry code, and I left the captcha off. I got the correct error page, but when I went back to the form. Nothing was there just a blank form.

I then tested it again and put everything in and submitted with correct verification page. I am still working on that this morning.

I am starting over on the instructions and watching everything.

Thanks

Navaldesign · Post by **Navaldesign** » Sat Aug 15, 2009 11:52 am

You can send me your wb project if you like,i will have a look.

star57 · Post by **star57** » Sat Aug 15, 2009 12:03 pm

I sent it Naval!

Update, I corrected all the feilds with Under scores and took out the special charactors. The State will not work with the code, I take it out and it submits.

star57 · Post by **star57** » Sat Aug 15, 2009 2:25 pm

Naval, Questions from the manual, Section Creating Multiple forms.
I dont have multiple forms but would like a Verificatin page.

"Not to do anything at all?
I take it as the only thing that needs checked on that formprocessor is "Copy in session" to yes.

Now, I am lost here as shold there be a Submit button to "Preview.php" or just a next button. Now on "Preview.php" I have the varibles, as a test from the manual. Also, the confirmation page info html object.

So , On the form page itself, what shold the FP be set at?
What does the form and Submit button be?
Does the Verification page have a FP also?

Sorry for all the questions, Naval.

Thanks

Navaldesign · Post by **Navaldesign** » Sat Aug 15, 2009 2:31 pm

Keith please wait 10 minutes, your project is almost ready.

star57 · Post by **star57** » Sat Aug 15, 2009 2:40 pm

Navaldesign wrote:Keith please wait 10 minutes, your project is almost ready.

Thanks

Navaldesign · Post by **Navaldesign** » Sat Aug 15, 2009 3:24 pm

The extension has been updated to fix logical bugs.
The bugs were relevant to the advanced features: Preview and Data Merge Confirmation Pages as well as Form preserving the submitted values after wrong Captcha Submission.

Please download and install again.

The updated manual also contains updated instructions on creating Preview and Data Merge Confirmation Pages as well as preserving the submitted values after wrong Captcha Submission.

star57 · Post by **star57** » Sat Aug 15, 2009 4:07 pm

Navel, Works Great Thank you so much for the hard work and instructions. Man I need to buy you a drink!

zinc · Post by **zinc** » Sat Aug 15, 2009 4:30 pm

star57 wrote:Navel, Works Great Thank you so much for the hard work and instructions. Man I need to buy you a drink!

ditto!!! Maybe we could all meet up in Italy!!!

Eddy · Post by **Eddy** » Sat Aug 15, 2009 5:04 pm

He das have a paypal

on the download page

download page

zinc · Post by **zinc** » Sat Aug 15, 2009 5:05 pm

Eddy wrote:He das have a paypal on the download page

download page

LOL Very good Eddy!!!!!

Navaldesign · Post by **Navaldesign** » Sat Aug 15, 2009 6:10 pm

Eddy wrote:He das have a paypal on the download page

download page

Veeery good! I might replace the PayPal button (hehe)

me.prosenjeet · Post by **me.prosenjeet** » Sun Aug 16, 2009 3:41 am

Or you may buy from here for as low as $3
http://www.flashcomponents.net/componen ... tions.html

See this one specifically:
http://www.flashcomponents.net/componen ... globe.html

Or use this free one:
http://www.fotosearch.com/BSM002/glo979895/

Navaldesign · Post by **Navaldesign** » Sun Aug 16, 2009 6:30 am

This is the one I had customized for me.

As it is it had background and shadow, which i didn't want
Flash components in most cases have to be opened in flash to be customized.

But if i correctly understand, Gary needs hi own logo transformed in 3D flash.

Navaldesign · Post by **Navaldesign** » Sun Aug 16, 2009 5:56 pm

The extension has been updated. Actually , a new, addon extension has been added, DBTS Preview.

DBTS Preview is a fully customizable extension to automatically create a table for previewing the info submitted by your visitor.
This way you can either create a Confirmation Page, that will display the user submitted info, OR a Preview Page where the user can review his info before final submission.
It will also allow you to have in your page available the submitted values, just in case you want to create a free layout or embed the submitted info in other text of your own.

Please refer to the updated manual. Of course, you will need to install the DBTS Preview extension before this feature becomes available within your WB6.

Fot those that have installed the DBTS Form processor Extension before August 15, it wil be a good occasion to install also the updated DBTS Form Processor Extension.

zinc · Post by **zinc** » Sun Aug 16, 2009 6:10 pm

George;

Do you have a demo/preview for the new addon extension?

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

Demo at http://www.dbtechnosystems.com/wb6/forms/smtp/

zinc · Post by **zinc** » Sun Aug 16, 2009 6:18 pm

Navaldesign wrote:Demo at http://www.dbtechnosystems.com/wb6/forms/smtp/

Nice! Thank you.

me.prosenjeet · Post by **me.prosenjeet** » Sun Aug 16, 2009 8:36 pm

Naval, a sincere request....the field names used in the extension and that in the manual doesnt match sometimes thereby creating confusions...
for example :
[quote]Creating multipage forms:
This is a very easy task with the DBTS Form Processor.
Create your forms as you would normally do. Please follow the steps described
below:
Add the DBTS Form processor object in all forms that contain forms.
Set the form processor NOT to do anything at all, in all pages except the last
one.
In the first form, set the â€œCopy in Sessionâ€

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

Me, I think that anyone with a minimum of experience will understand the manual instructions compared to the script. Since this has taken more than 300 hrs of work, and this is a minor (in my opinion) issue, i will do it when i have the time.
Regarding your issue, probably you have set the "Clear session" to Yes, in the first two pages, so the values are not passed through.

This is a new feature added and by default has the value of "Yes". If you didn't notice it, and is set (by default) to "Yes" the values are not passed from page to page.

me.prosenjeet · Post by **me.prosenjeet** » Sun Aug 16, 2009 9:11 pm

I agree and appreciate your efforts. Please do the change when updating the pdf next time.

By the way I checked and changed "Clear session" from 'Yes' to 'No' still its not sending data of the first two forms.

Navaldesign · Post by **Navaldesign** » Sun Aug 16, 2009 9:22 pm

A link to the form please ?

me.prosenjeet · Post by **me.prosenjeet** » Sun Aug 16, 2009 9:24 pm

Navaldesign wrote:A link to the form please ?

http://lucknowwebs.com.au/quote

Ok, got it right....played with the settings. Thanks for the help

Navaldesign · Post by **Navaldesign** » Sun Aug 16, 2009 9:40 pm

Tested your form and i received the autoresponder mail with all the values of all 3 forms. So it must have been the "Clear Session" setting

me.prosenjeet · Post by **me.prosenjeet** » Sun Aug 16, 2009 9:45 pm

Navaldesign wrote:Tested your form and i received the autoresponder mail with all the values of all 3 forms. So it must have been the "Clear Session" setting

Yes I changed it to 'No' in the first 2 forms but forgot on the last page!

Naval you are always appreciated. The reason I pointed out the flaw in the pdf was not to be rude or something...well, this is a perfect extension and if the small errors are taken care of, it will be simple for the newbies as well to understand than ask questions.

Navaldesign · Post by **Navaldesign** » Sun Aug 16, 2009 9:50 pm

me.prosenjeet wrote:
Yes I changed it to 'No' in the first 2 forms but forgot on the last page!

? In the last page it SHOULD be set to "yes" so it clears the session.

star57 · Post by **star57** » Mon Aug 17, 2009 10:08 pm

George, I wanted to thank you again for the wonderful extension... An APLUS Extension.....

www.wysiwygwebbuilder.com

UPDATED DB Technosystems Form Processor 02/09/2011

Re: Question about mail engine settings

Re: Question about mail engine settings

UPDATED DBTS FormProcessor Extension 15/8/2009

* UPDATED DB Technosystems Form Processor 16/08/2009 *

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

Re: Question about mail engine settings

Re: Question about mail engine settings

***UPDATED*** DBTS FormProcessor Extension 15/8/2009

*** UPDATED DB Technosystems Form Processor 16/08/2009 ***

UPDATED DB Technosystems Form Processor 02/09/2011

UPDATED DBTS FormProcessor Extension 15/8/2009

* UPDATED DB Technosystems Form Processor 16/08/2009 *