Quantcast

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

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

amit bhosale
This post has NOT been accepted by the mailing list yet.
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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

inanda.menezes
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

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

amit bhosale
This post has NOT been accepted by the mailing list yet.
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
Loading...