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

In this section you can share self-made extensions with other users of WYSIWYG Web Builder.

There are already more than 250 extensions available!
User avatar
wbdesigner
 
 
Posts: 30
Joined: Mon Apr 28, 2008 10:59 pm
Location: Santa Cruz, CA USA
Contact:

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

Post by wbdesigner » Thu Apr 12, 2012 6:18 pm

You will love this form processor there just isn't anything so easy to run and yet so powerful if you want to go further with it.
click on the DTBS form processor in your extensions go to anywhere on the page ( I put mine at the top.. but it doesn't matter where you put it) and draw a box the processor will appear click on it and fill out the fields.

itsme
 
 
Posts: 49
Joined: Wed Feb 09, 2011 7:02 pm
Location: Spain

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

Post by itsme » Thu Apr 12, 2012 6:24 pm

thanks wbdesigner for your prompt reply, i actually read about it a lot, but i am not able to understand the mechanism,
do you mean just put the fields and everything needed from wbb form control stuff in the page and include the form processor dbts icon on the page? what box you mean? anybox? so how this box will know that this is part of the form that will be processed with this dbts form processor?! what about checkboxes and radiobuttons, is it the same issue with the built in (putting them as q[1] q[2] and use their built-in validation issues? i think yet im missing the principles in this regard, sorry :(

User avatar
Navaldesign
 
 
Posts: 903
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by Navaldesign » Thu Apr 12, 2012 6:35 pm

From the manual (Page 15):


The Form and its settings:
DBTS Form Processor does NOT create the form for you!
You need to create a form in your page using the WB Form Wizard or the WB form
tools. Once you have created the form, make sure to respect the following
settings:
The form page MUST be published as PHP.
The form action MUST be set to be “<?php echo basename(__FILE__);?>
The form encoding type MUST be “multipart/form-data”
The submit button MUST be named “submit” though its value can be anything
(like “Send”, “Send Info Now” or anything else).


Differences berween the Built in form Processor and the DBTS Form Processor ?

A LOT !

Too many to list here. If you read the manual you will see that the DBTS Form Processor does things that even commercial products that cost more than $100 simply can't do:

Particular "from" email address structure to guarantee deliverability
Custom named "email" field
Timezone and time formatting
Further posting
Storing values in SESSION (allows to create preview - confirmation pages, multipage forms, preserve values when going back after an error)
User defined behavior after processing
Custom processing and includes in user defined position (allows tou to embed practically any type of custom code in the processor)
Exclude fields if necessary.
Include or exclude null fields
Include or exclude info in the autoresponder mail
Include or exclude server detected info (time, IP address, etc)
Attach one or more files in the autoresonder mail
Send email to specific departments(example sales or support or anything else)
Ban IP addresses
Set the script behavior for spam mails and banned IP addresses
Send HTML emails (fully customizable) with your logo if you like
Select mail engine (PHP mail() or SMTP or Sendmail or Qmail) . Send mails through your Gmail, Yahoo, AOL or other accounts
Of course Database and CSV storing, settable through the processor.

and much more..........

Of course it is more complicated, because it does a LOT more..... However, it is very intuitive and well documented.
www.dbtechnosystems.com

itsme
 
 
Posts: 49
Joined: Wed Feb 09, 2011 7:02 pm
Location: Spain

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

Post by itsme » Thu Apr 12, 2012 6:44 pm

Navaldesign! you are genious dear, i read most of your replies in this post, i really appreciate all ur help to ppl here, including help me few minutes ago, i was reading the manual and didn't notice that information, i see other information now in page 15, however, this is really great and it is EXACTLY what i needed to know :) thanks a lot again dear, much appreciated. also thanks wbdesignser

i will try this invention in details :)

warm regards

User avatar
wbdesigner
 
 
Posts: 30
Joined: Mon Apr 28, 2008 10:59 pm
Location: Santa Cruz, CA USA
Contact:

SQL DB to store records

Post by wbdesigner » Tue Jun 12, 2012 6:14 pm

First of all thanks again for the form processor it's the best ever!

I filled out the DB section with all of my info
but then I'm not sure how I fillout my form which field names are which in the DB

In other words I have a field named 'title' in my DB where do I put 'title' in the form?
Patti

User avatar
Navaldesign
 
 
Posts: 903
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by Navaldesign » Tue Jun 12, 2012 9:21 pm

# Patti: the processor will create columns with names depending on the form field names. So I'm unsure what you are asking me.

@ Hans: I will have to check this, no, it is not by design.
www.dbtechnosystems.com

User avatar
wbdesigner
 
 
Posts: 30
Joined: Mon Apr 28, 2008 10:59 pm
Location: Santa Cruz, CA USA
Contact:

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

Post by wbdesigner » Tue Jun 12, 2012 10:34 pm

where in the form do I put the form field names for a table I already have field names for?

User avatar
Navaldesign
 
 
Posts: 903
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by Navaldesign » Wed Jun 13, 2012 6:37 am

The processor will create (if not already existing) a column in the database that will have the name of the field, all lowercased, (ex. field name Title will create a column in the database named "title") and will replace whitespaces with underscores (ex. Field name Your Hobbies will give place in a column named "your_hobbies")

Order is not important.
www.dbtechnosystems.com

User avatar
wbdesigner
 
 
Posts: 30
Joined: Mon Apr 28, 2008 10:59 pm
Location: Santa Cruz, CA USA
Contact:

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

Post by wbdesigner » Wed Jun 13, 2012 7:21 am

but if I already have a MySql DB all set up with fields and I have my DBTS form all working where in the wb5 form fields do I put the name of the DB field that I already have.

when I look at the properties of the form field there's a place for a title is that where it goes?

User avatar
Navaldesign
 
 
Posts: 903
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by Navaldesign » Wed Jun 13, 2012 11:19 am

No. As I said, it is each form field name that defines the column name in the database.
So, if you already have a column in the database named (in example) "contact_by" , your form field that should capture this piece of info, MUST be named the same way (contact_by)
www.dbtechnosystems.com

User avatar
Navaldesign
 
 
Posts: 903
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by Navaldesign » Thu Aug 09, 2012 8:55 am

The reason why the visitor's email doesn't appear in the "from" is that many email addresses belong to blacklisted domains. Also many hosting companies, disallow emails from "free" (gmail, yahoo, aol, hotmail etc) email providers as they are used for spamming.

However, the "reply to" is set to be the visitor's email address! so if you click on "Reply", the reply email will actually be sent to the correct (the visitor's) email address.
www.dbtechnosystems.com

User avatar
Navaldesign
 
 
Posts: 903
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by Navaldesign » Thu Aug 09, 2012 10:30 am

First, you can use the built in autoresponder, instead of using an external autoreply tool. The built in autoresponder can also attach files (if you need to send an attachment).

With this said, you can use the following trick: in the "From" property, type

".$_POST['email']."

(including the quotes)

. This, on the assumption that the user's email address field is named email . If not, use the actual field name.
www.dbtechnosystems.com

User avatar
Navaldesign
 
 
Posts: 903
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by Navaldesign » Thu Aug 09, 2012 11:18 am

I meant the DBTS Form Processor autoresponder, not the WWB built in form processor autoresponder. Why would you want to use both ??
www.dbtechnosystems.com

User avatar
Navaldesign
 
 
Posts: 903
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by Navaldesign » Sat Aug 11, 2012 10:46 am

A link to the form please ? Does the email arrive correct ?
Did you enable the "Store in CSV file?
Do NOT create the CSV (delete it from the server). The script will create it automatically. If the file structure is not correct, no values will be stored.
www.dbtechnosystems.com

User avatar
Patrik iden
 
 
Posts: 513
Joined: Wed Mar 24, 2010 9:07 pm
Location: Sweden

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

Post by Patrik iden » Sat Oct 06, 2012 11:11 am

Hello im using the DBTS Formprocessor and i'm trying to make my own captcha like function.
I have one edit box with the name: captcha_code and this value to get random code: <?php $random = substr(number_format(time() * rand(),0,'',''),0,6); echo $random?>
this field is set to red only. Then i have a second edit box named: captcha_answer this edit box is set to Data required Min:6 Max:6 and to have the same value as the first edit box.
Now averything semes to work but in the recived mail there are no data only Header and Footer.
Can you think of somthing pleas?

Regards

//Patrik Iden

Post Reply