how to store form data into user specific table (oracle database)

Hello All,

I have installed Orbeon PE trial version.  I am understanding work flow of this tool (novice user). I have created a form  and i want to store all form information into user specific table after pressing button (custom button)   (table is  having same number/type of fields present on form). (currently storing form data into orbeon specific tables as xml)

Can you please let me know how to achieve this process? (links, or steps , video links)

actually we are analyzing business scenarios, if this tool satisfy our requirements we are going to purchase this tool.  

Thanks & Regards,
-Amit

Hi,


1-You can find the crud.xpl file in orbeon/WEB-INF/lib/orbeon-form-runner.jar
Folder: apps/fr/persistence/oracle/crud.xpl

2-Create this same path in your orbeon and copy this file, so you can make your changes to this file.

It seems that you just want to change the name of the table. So, you should change the following variable:
<xsl:variable name="table-name" as="xs:string" select="concat(
                                    if ($is-data) then '<b>orbeon_form_data' else 'orbeon_form_definition',
                                    if ($is-attachment) then '_attach' else '')"/>


Inanda Menezes

Hello Inanda Menezes ,

Thanks for your reply.

I will follow mentioned steps and let you know the  results.

Actually i have created few tables in database (oracle)

Form and table is having one to one relationship.
 
table A ==>  FORM 1( so all fields present on that form is stored in table A)

Can i achieve this using form builder?

Thanks & Regards,
-Amit