[opencms-dev] How to store data into database using OAMP WebForm module

[Mario Jäger]

Hi,

To your questions.

To (1) If you want to store the webform data in the database pool "my_db", then you have to configure the module parameter in this way "db-pool=my_db". You also have to configure the "Data target" node in the webform xml content.
In the sub node "Transport", you have to choose either "Database" or "Email&  Database". And you have to set an unique form id in the sub node "Form Id". By default (if the "Data target" node is not added with the plus button) the
submitted data will be sent as an email to the configured "Mail to" address. What database do you use? If you use "Oracle" for example, you also have to set the module parameter "db-provider=oracle".

To (2) The webform data are stored in the tables "cms_webform_data" and "cms_webform_entries". In the "Database Management" in the OpenCms administration view there is the icon "OAMP Webform". If you click on that, than there are
listed all form ids. If you click on one of them, than there are listed all submitted form entries to this form id.

-- 
Kind Regards,
Mario.

-------------------
Mario Jäger

Alkacon Software GmbH  - The OpenCms Experts
http://www.alkacon.com - http://www.opencms.org


Am 06.10.2010 11:28, schrieb raj_iv:
> Hi,
>
> I just started using OAMP Webform 1.3.1 on OpenCms 7.5.3. I want to store
> form data into database when clicked on submit button. I am not using
> default db-pool so i have specified my database in the module parameter as
> db-pool=default,my_db and in opencms.properties file. I also configured the
> settings for my db-pool. I am able to access the table data from my
> database(my_db) as explained in OpenCms wiki page "Using OpenCms's Database
> connection pool" after creating jsp page as mentioned on this page.
>
> So, my problem is: 1)When i am using OMAP Webform, i m not getting my data
> into database and opencms.log file shows this error message "An unexpected
> error occured. java.sql.SQLException: Configuration file not found".
>   2) I am not clear where my data going to be stored in database. Is it in a
> new table because i have not specified any table name in the database where
> it is going to be stored.
>