www.wysiwygwebbuilder.com

Navaldesign wrote:I'm sorry, I don't have the time to impement third party scripts in my processor, you will need to find out yourself what you are doing wrong. The instructions I gave you (implementing the vrification routine just before the Error Reporing) is correct.

ok, do you see somthing wrong with the verification code?, it do not work
i gues i'm verifing this:

I'v got it working now. Thanks anyways.

HansInChina wrote:DBTS - csv file has unnecessary characters

To George (Navaldesign)

I found unnecessary characters in the csv file. As I am not sure if this is caused by the DBTS Form processor I took the time to copy the contents of the file below.

I would like you to examine the output and let me know whether or not this is by design.
If so, I would like this to be corrected.

Here is a copy of the csv-file contents:
The field headers (these are OK)
Time of Submission,Timestamp,IP Address,Selection,First Name,Last Name,Email,Country,Msg Text,Fileupload

Then the field values

• To easily distinguish the field values from each other, I surrounded them by double quotes.
  The spaces and other characters that should not be there are underscored in red.
  Most (!) values start and end with a space that was not entered by the user.
  Curiously the Timestamp value is not surrounded by spaces.
  Note the double slash in the middle of the URI.
  The last value (of Fileupload) this time ends not with a space but with an end-of-line.
  The last characters at the end of this record are: a space and end-of-line.

"_2012-05-18, 13:54:32 CST (+08:00)_","1337320472","_112.112.190.85_","_question_","_Hans_","_van Unen_","_h@unen.com_","_China_","_This is a live test._","_http://www.my domain-name.com//contact-whcw/986974_testform.txt↵"_↵

Kind regards,

Hans

I'm having the same problem here..did you manage to fix this?

Is there a way with DBTS Form Processor to strip out CR & LF in a text area field, and replace them with a space? Currently the administrator email formatting gets messed up because of user input using CRLF.
DBTS preview seems to quite happily strip out CRLF using '.stripslashes($fieldname)', but I'm lost as to how to do it outside of this to get the email formatting working properly.

Any pointers would be much appreciated!

I'm using DBTS form processor 2.7.5 with WB 9.0.4 and I'm having a problem When DBTS appends additional fields to an existing CSV file.
I've set DBCS to use semicolon and double quotes for the CSV file.

When it appends new field names to the header row, it is inserting them using quotes and spaces as follows:

original csv file row 1:
date;timestamp;IP Address;field1;field2;field3

now the csv file row1 looks like this:
date;timestamp;IP Address;field1;field2;field3;" field4 ";" field5 ";" field6 "

Also notice insertion of leading and trailing spaces whenever double quotes are used for any field contents in the CSV - is this also a bug?

thanks much

Probably the original file was created with a previous version ?

Version 2.7.5.6 uses quotes and also spaces to allow preserving line breaks (as, in example, a text typed in a text area with line breaks) which would otherwise get lost.
You can disable the "Use double quotes" property, but only if your form doesn't allow line breaks.

The additional fields, having been created by the new version, uses this style, whilst the old fields (created by an older version) are kept as they are.

You can download the CSV, edit the first row in Notepad, (not in Excel) then upload it again.

If you are using the file on the server with the DBTS CSV Manager to display content, I suggest that you add quotes and spaces to everything, or remove quotes and spaces completely, as the CSV Manager can only deal with one type of content, not mixed.

When I saw the problem I deleted the CSV file to let the script create a fresh copy. I then did a few form submits:

The first form submit creates the CSV with header row as I expected - no double quotes or spaces, just the semicolon. Row 2 of data has double quotes and spaces - again as I expected.
I then did a second form submit answering different questions on the form so that it would force appending of fields to the header row. These appended field names have the double quotes and spaces.

So if the latest version of DBTS is to use double quotes and spaces everywhere, then the problem seems to be on CSV first instance creation?

Yes, in fact. So please let the script create the file from scratch, but with the full list of fields.

I'm having trouble testing for an empty text box using DBTS preview and need to sanity check that I'm following the right steps:

My form uses DBTS form processor & DBTS reCAPTCHA.
I have a textbox named field1. Initial value of field1 is set to <?php echo $field1;?> so that I can preserve the data should the user make a reCAPTCHA error.
On submit, I redirect to a success page with DBTS preview and am using a custom layout using '.$Field1.' text.

What I want to do is to test whether field1 has data in it or has been left blank. So I have set the text object HTML as follows: However this If statement does nothing. I've also tried isempty() and strlen() tests but none of these work. Any advice on what I am doing wrong?

thanks

But why are you doing this ?

DBTS Form Processor allows you to do this automatically: Properties, Section D. Behavior -> Null fields text
You must also set the property "Include null fields" to "Yes" instead of the default "No"

So the processor will "pass" to the Preview Page, the value "No data entered" (or whatever else you wish) for field1.

Thanks Navaldesign - I appreciate the help.

I did have the null fields set to No in Section D, so I've now set this to Yes. I also added "no entry" text. I've also temporarily set the DBTS preview to show me the field table.
What I'm seeing now is that the blank fields remain blank in DBTS preview. The admin email however does show the "no entry" text.
Is there another setting I've missed?

regards

UPDATE: I've created a 1 page website with 1 field to illustrate my problem, so if you would like me to upload it somewhere to take a look at this problem let me know.

Navaldesign wrote:But why are you doing this ?

DBTS Form Processor allows you to do this automatically: Properties, Section D. Behavior -> Null fields text
You must also set the property "Include null fields" to "Yes" instead of the default "No"

So the processor will "pass" to the Preview Page, the value "No data entered" (or whatever else you wish) for field1.

Any update on this please? I am not seeing this on DBTS preview - null fields remain blank and are not picking up "no data entered" from DBTS form processor section D. This could be why I haven't been able to test for empty / null text boxes (see my post above). If I test for known values of text boxes, everything is fine, but no matter what I try, I can't seem to test for an empty field so that I can substitute it with meaningful text on success page.

At the moment, I can't recall if DBTS preview takes into account null fields or not.

But due to personal work, un update on this will not be available soon.

Hi Navaldesign
I understand and appreciate your position - DBTS is a terrific extension and I expect that a large number of people are in your debt for your excellent contributions to WB.

Furthemore, I don't immediately need DBTS preview to pickup the null fields and populate with the replacement text from form processor. This can wait.

My problem is more specific and I was hoping it's just my poor PHP skills coming into play:
I know the input box contents are being passed to the page with DBTS preview because I can test for specific content and it works fine. Thus if I type "123" into the input box and test for that content, the PHP if statement works fine. It's when the input box is in an empty state that none of my attempts to test for this condition works. I've tried isset, empty, is_null, zero string length with trim etc and none of these resolve correctly. So maybe somebody else with better PHP skills than me can do a quick test? I've built a 1-pager WB site with a single field to illustrate my point - so it's would just be a matter of checking if my logic is wrong. Any takers?

thanks
Tony

Please email me your project as well as the specific URL of the published page.

Hi, i read all posts in this, but not found working solution. I made something wrong.
I need add to form random item VS, that is filled from php code.
As initial value to VS i define <?php echo $VS;?> (I try <?php echo $VSRND;?> too)
I need, by this random text stay visible in form editbox for user (this editbox i planing set to read only)
I define variable $VSRND = "RANDOM TEXT" and put the code $POST["VS"] = $VSRND; to Start od Script Custom Processing and to After Form Data Reception Custom Processing.
But after I fill for, the item VS is blank, not filled from $VSRND.
What I made wrong?

Sorry, but I don't understnd what you need to do.
If the random text must be adedn a for field, why shuld you add code in the procssor ? add it directly in the form field or as a hidden field.

I need add to this RANDOM text some data selected from other one typed filled, then i need add this code to form processor.

Sorry, but since I don't understand what exactly you need to do, I can't be of much help.

OK, many thanks for you support.

I hope this is not too dumb a question:
I use DBTS reCAPTCHA on my forms. I'm seeing more sites these days with reCAPTCHA based on numbers versus the very difficult to read words. Will I automatically get the benefit with DBTS reCAPTCHA or does the extension need to be updated?

thanks

Reading posts on the net seems like Google is automating the displayed content based on evaluations made at the moment of the captcha request. I have not been able to find a way to set captcha to serve numbers, it is the recaptcha server that "decides" what to serve.

I have a question that probably was already asked one million times : it's possibile to use with WB 9.2 this extension ? I have tried to install it but don't see in the extension list..:

thx in advace.

Michele

Yes, it can be installed and used with WWB 9.2. Maybe you have installed too many extensions, so it will not appear ?

Did you install it through the Extension Manager ?

Navaldesign wrote:Yes, it can be installed and used with WWB 9.2. Maybe you have installed too many extensions, so it will not appear ?

Did you install it through the Extension Manager ?

Yes with the Extension Manager but I don't see it probably for too many extension..any suggestion to fix this?

No, I'm afraid not. Try removing extensions that you normally don't use.

I have uninstalled older exensions not used and cancelled the form processor files (wbx) from the folder ../system/extension. I have reinstalled the extension from the Extension Manager but nothing change....I am a bit stressed

@ Navaldesign not hijacking your thread in anyway....@ milux the maximum extensions you can have installed in 200, if you have this then please remove as many as possible that yiou are not using. When installing extension it is always best to install from the extension manager. If you have change the path of were the extensions are stored then you will alsoneed to ensure this path is the same flor allextensions used/installed. This needs to be asked are you using a legal version of the program? have you ever used a illegal version of the program in the past if so this could explain why the extension is not working. Also I am not sure only Navaldesign can answer what version of the extension builder was used to build the extension? if it was the latest build then the extension may only work in WB9 and not earlier versions of the program.

Please also read the following urls
How to trouble shoot Web Builder Extension issues?
viewtopic.php?f=10&t=7234
What to do when extensions no longer work in version 8.5?
viewtopic.php?f=10&t=50825
Location of user content in WB8 & WB9
viewtopic.php?f=10&t=30276

BaconFries wrote:@ Navaldesign not hijacking your thread in anyway....@ milux the maximum extensions you can have installed in 200, [/quote)

actually I have 55 extension installed

BaconFries wrote:If you have change the path of were the extensions are stored then you will alsoneed to ensure this path is the same flor allextensions used/installed.

I have checked : in Option/ Default Document folder is correct.

BaconFries wrote:This needs to be asked are you using a legal version of the program? have you ever used a illegal version of the program in the past if so this could explain why the extension is not working. Also I am not sure only Navaldesign can answer what version of the extension builder was used to build the extension? if it was the latest build then the extension may only work in WB9 and not earlier versions of the program.

Yes I have a legal version of the software (the 1st was version and the last version 9 purchased at 18/06/2013 (actually upgraded to 9.2). This is the only extension that I cannot install ; for all the others no problems.

BaconFries wrote: Please also read the following urls

I have read all this topics a lot time..

Thx for your support.

Hi Navaldesign, I using Success URL = sucess.php and this working fine. Data from post has been stored to DB. It`s possible on this sucess.php page get again some data from form ?
I need identify this "last record", to GET data from DB and provide next functions.
I have set Copy in Session on form page to yes and Clear Session to no, but when i can get data on sucess.php using $_POST['Email'], I get always "empty" string. Can you please help me, what made I wrong?

I've seen where you can send an sms text with phpmailer and I wanted to know if this is possible with this extension? I've been using this extension for some time now but I wasn't sure if this is possible. Please let me know. Thanks!

**I got it to send the text, but it doesn't display the entire message. It only displays about 7 lines and cuts the rest off. Any ideas?

Maybe it is a limitation of the host that actually sends the sms ?

The processor will POST (send using the POST mehod) all the data it receives from the form, so I can only guess that the receiver server limits the length of the SMS text.

Hello, I updated to WWB 9.4.2 and pubiched a page that i have the form processor on, it worked before but now i get to the thank you page, so thats ok. But i dont recive any emails. Do you know of any problems whit form processor and the WWB 9.4.2? Thank you.

Hi Patrik, just thought I would let you know Update WWB 9.4.3 has just been released.

There are no known issues with WWB 9.4.2 or other version. However, please update to the last WWB version so if you still have issues we can talk based on the same WWB version.

Hello, i having a problem when i setup the form processor to save form data to Databse, i use ÅÄÖ åäö in some of the fields, but in databse i dont get åäö i get strage carracters like i have an address that shoul read Sågvägen but in DB it reads like this: SÃ¥gvägen.

I have UTF8 in webpage so that the page will show åäö, so i also set the form processor to utf8 and in WWB form i also set utf8.
Any ideas please?
Thank you.

Try setting also the Form charset to UTF8

Navaldesign wrote:Try setting also the Form charset to UTF8

I have the WWB Form setup to UTF8, I have the DBTS Form processor setup to UTF8, And i got the page setup to UTF8. But still the same result. Any other ideas?

Thank you.

Hi,
I have problem sending email. I followed to the letter all pdf document and in particular the paragraph "The Form and its settings".
I have enabled debug mode and got below log :
thanks in advance

Notice: Undefined index: POST in C:\xampp\htdocs\Prova\index.php on line 17

Notice: Use of undefined constant RecursiveMkdir - assumed 'RecursiveMkdir' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 2

Notice: Use of undefined constant ValidateEmail - assumed 'ValidateEmail' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 11

Notice: Use of undefined constant array_trim - assumed 'array_trim' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 19

Notice: Use of undefined constant report_error - assumed 'report_error' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 33

Notice: Use of undefined constant rewrite_captcha - assumed 'rewrite_captcha' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 64

Notice: Use of undefined constant allowurls - assumed 'allowurls' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 90

Notice: Use of undefined constant WriteToFile - assumed 'WriteToFile' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 97

Notice: Use of undefined constant WriteToMySQL - assumed 'WriteToMySQL' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 151

Notice: Use of undefined constant db_connect - assumed 'db_connect' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 205

Notice: Use of undefined constant get_labels - assumed 'get_labels' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 222

Notice: Use of undefined constant create_entry - assumed 'create_entry' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 235

Notice: Use of undefined constant update_record - assumed 'update_record' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 264

Notice: Use of undefined constant get_record_from_db - assumed 'get_record_from_db' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 300

Notice: Use of undefined constant check_unique_in_db - assumed 'check_unique_in_db' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 316

Notice: Use of undefined constant check_pass_strength - assumed 'check_pass_strength' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 334

Notice: Use of undefined constant getRealIpAddr - assumed 'getRealIpAddr' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 348

Notice: Use of undefined constant post - assumed 'post' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 367

Notice: Use of undefined constant check_credit_card - assumed 'check_credit_card' in C:\xampp\htdocs\Prova\dbts_includes\dbts_functions.php on line 395

Notice: Use of undefined constant date_default_timezone_set - assumed 'date_default_timezone_set' in C:\xampp\htdocs\Prova\index.php on line 48

Notice: Undefined variable: total_attach_size in C:\xampp\htdocs\Prova\dbts_includes\dbts_formprocessor.php on line 187

Notice: Undefined index: department in C:\xampp\htdocs\Prova\dbts_includes\dbts_formprocessor.php on line 195

Notice: Undefined index: in C:\xampp\htdocs\Prova\dbts_includes\dbts_formprocessor.php on line 196

Notice: Undefined variable: department_names in C:\xampp\htdocs\Prova\dbts_includes\dbts_formprocessor.php on line 197

Notice: Undefined variable: dep_mailtos in C:\xampp\htdocs\Prova\dbts_includes\dbts_formprocessor.php on line 205

Notice: Undefined variable: upload_Name in C:\xampp\htdocs\Prova\dbts_includes\dbts_formprocessor.php on line 220

Notice: Undefined variable: logo_valign in C:\xampp\htdocs\Prova\dbts_includes\admin_email.php on line 35

Notice: Undefined variable: upload_Name in C:\xampp\htdocs\Prova\dbts_includes\admin_email.php on line 55

Notice: Undefined variable: upload_Name in C:\xampp\htdocs\Prova\dbts_includes\admin_email.php on line 55

Notice: Undefined variable: upload_Name in C:\xampp\htdocs\Prova\dbts_includes\admin_email.php on line 55

Notice: Undefined variable: upload_Name in C:\xampp\htdocs\Prova\dbts_includes\admin_email.php on line 76

Notice: Undefined variable: upload_Name in C:\xampp\htdocs\Prova\dbts_includes\admin_email.php on line 155

Notice: Undefined variable: upload_Name in C:\xampp\htdocs\Prova\dbts_includes\admin_email.php on line 155

Notice: Undefined variable: upload_Name in C:\xampp\htdocs\Prova\dbts_includes\admin_email.php on line 155

Notice: Undefined variable: upload_Name in C:\xampp\htdocs\Prova\dbts_includes\admin_email.php on line 160

Deprecated: Function set_magic_quotes_runtime() is deprecated in C:\xampp\htdocs\Prova\dbts_includes\class.phpmailer.php on line 1471

Deprecated: Function set_magic_quotes_runtime() is deprecated in C:\xampp\htdocs\Prova\dbts_includes\class.phpmailer.php on line 1475

Notice: Undefined variable: upload_Name in C:\xampp\htdocs\Prova\dbts_includes\dbts_formprocessor.php on line 360

Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\Prova\dbts_includes\dbts_formprocessor.php:205) in C:\xampp\htdocs\Prova\dbts_includes\dbts_formprocessor.php on line 460

Is the script running on a web server or on a local system (xampp) ?

If running on a local system, there is not much I can do, as mail sending issues may depend on your xampp settings.

Patrik iden wrote:

Navaldesign wrote:Try setting also the Form charset to UTF8

I have the WWB Form setup to UTF8, I have the DBTS Form processor setup to UTF8, And i got the page setup to UTF8. But still the same result. Any other ideas?

Thank you.

I'm sorry, I don't know why this doesn't work for you.

Is the script running on a web server or on a local system (xampp) ?

If running on a local system, there is not much I can do, as mail sending issues may depend on your xampp settings.

which xampp settings should I check?
Thanks

Do you have somthing like this somewhere in your Formprocessor code:

mysql_query('SET NAMES UTF8');

mysql_query('SET COLLATION_CONNECTION=UTF8_GENERAL_CI');

@Navaldesign

Online work..

Thanks

Whats the current version?

Patrik iden wrote:Whats the current version?

Current version is 2.7.5.6

Patrik iden wrote:

Navaldesign wrote:Try setting also the Form charset to UTF8

I have the WWB Form setup to UTF8, I have the DBTS Form processor setup to UTF8, And i got the page setup to UTF8. But still the same result. Any other ideas?

Thank you.

I use WWB to generate pages in Czech language. We have many special characters ěščřžýáíé, ĚŠČŘŽÍÁÍÉ and more.
I have had the same problem and use in page properties and DBTS Character Set UTF-8 and all it`s OK.

Hello, for some reason when I publish a new form it works fine the first time ONLY. if I refresh the page or go back to the page with the form, my entire website gets shifted down and right above the website some php code is displayed:
It will only go away if I republish the page. Then as soon as I've submitted the form (which does work), it will not work again. The php code is right back at the top of the page. Any idea as to what I am doing wrong? Thanks!

Here is the page in case you want to see first hand: http://www.harvilleappliancerepair.com/ ... equest.php

Please set the property "Rerwrite Captcha" to No, and republish the page.

Thank you Navaldesign! It's been a while since I've used web builder. I must be getting rusty. I thought saying yes to that option was required if you were using the WB Captcha?
Thanks for getting back so quickly!