Using WB 12.3.1 Form and PHP processor

Issues related to forms.
Post Reply
User avatar
bry
 
 
Posts: 331
Joined: Fri Jan 11, 2008 8:44 pm

Using WB 12.3.1 Form and PHP processor

Post by bry » Sun Jan 21, 2018 8:09 pm

I have CSV set for my form and I get a csv data file I the home folder of the website. Is there anyway to have the CSV mailed to an email address??? That is a very important feature for me. Even if I have to go out and buy a form program, I need the CSV data somewhere other than the website folder.

http://www.test12.info/membercontactinf ... /index.php

Also, it seems that only one file is written to the website folder and it gets over-written. Surely this is not the case but it does seem to be what is happening - although I have not gotten the form working as I want yet.

Thanks for any suggestions.

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

Re: Using WB 12.3.1 Form and PHP processor

Post by Navaldesign » Sun Jan 21, 2018 9:11 pm

The file is unique. It gets updated each time a new submission takes place.
If you need to receive a file with only the data of each single submission, you will have to modify the script.
If you analyse the DBTS Form Processor code, to see how it uses attachments, you can modify it to do as follows:

1. Create the CSV file with only the data of the specific submission
2. Attach it in the Admin's email
3. Delete the file from the server.
www.dbtechnosystems.com

User avatar
bry
 
 
Posts: 331
Joined: Fri Jan 11, 2008 8:44 pm

Re: Using WB 12.3.1 Form and PHP processor

Post by bry » Sun Jan 21, 2018 10:18 pm

Thanks so much!! I will examine and make the change you suggest. What a great idea!!!

User avatar
bry
 
 
Posts: 331
Joined: Fri Jan 11, 2008 8:44 pm

Re: Using WB 12.3.1 Form and PHP processor

Post by bry » Sun Jan 21, 2018 10:20 pm

When you say attach it to the admins email, you mean send it to the admin,.. correct?? I would like to send individual CSV files to an email address.

thanks!!

User avatar
bry
 
 
Posts: 331
Joined: Fri Jan 11, 2008 8:44 pm

Re: Using WB 12.3.1 Form and PHP processor

Post by bry » Sun Jan 21, 2018 10:41 pm

Navaldesign wrote:
Sun Jan 21, 2018 9:11 pm
The file is unique. It gets updated each time a new submission takes place.
If you need to receive a file with only the data of each single submission, you will have to modify the script.
If you analyse the DBTS Form Processor code, to see how it uses attachments, you can modify it to do as follows:

1. Create the CSV file with only the data of the specific submission
2. Attach it in the Admin's email
3. Delete the file from the server.
Are you referring to class.phpmailer.php code? If not, any hints????

thanks

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

Re: Using WB 12.3.1 Form and PHP processor

Post by Navaldesign » Mon Jan 22, 2018 8:22 pm

No, you need to create custom code to perform the operations I described and then include it in the DBTS Form Processor.
www.dbtechnosystems.com

User avatar
bry
 
 
Posts: 331
Joined: Fri Jan 11, 2008 8:44 pm

Re: Using WB 12.3.1 Form and PHP processor

Post by bry » Tue Jan 23, 2018 12:14 am

If you analyze the DBTS Form Processor code, to see how it uses attachments, you can modify it to do as follows:

1. Create the CSV file with only the data of the specific submission
2. Attach it in the Admin's email
3. Delete the file from the server.
Where is the attachment code in DBTS Form Processor? Is it ...

/////////////////////////////////////////////////
// CLASS METHODS, ATTACHMENTS
/////////////////////////////////////////////////

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

Re: Using WB 12.3.1 Form and PHP processor

Post by Navaldesign » Tue Jan 23, 2018 3:26 pm

You will have to create the necessary code yourself, create a .php file and save it on the server. Then you will need to "call" it through the "Custom processing" section of the DBTS Form Processor properties with a simple

include(filename.php);

command.
www.dbtechnosystems.com

User avatar
bry
 
 
Posts: 331
Joined: Fri Jan 11, 2008 8:44 pm

Re: Using WB 12.3.1 Form and PHP processor

Post by bry » Tue Jan 23, 2018 4:25 pm

Hi George,

Would you take a look at http://www.test12.info/membercontactinf ... /index.php and also the wbs file in the root, demoupdaterform.wbs.

I am sending you a private email in regard to this.

Thanks,
bry

User avatar
bry
 
 
Posts: 331
Joined: Fri Jan 11, 2008 8:44 pm

Re: Using WB 12.3.1 Form and PHP processor

Post by bry » Wed Jan 24, 2018 2:30 pm

I'm feeling better this morning. There for awhile I thought I was going to have emergency surgery for gall bladder. I have never had a problem with gall bladder before but I guess time marches on.

Anyway, your form is brilliant NavalDesign!!! That is so logical,.. so well designed. I love it. I have to run to appt but can't wait to work on it later today. Thanks so much!!

Post Reply