Orbeon Forms community mailing list

not able to connect the mysql database wth orbeon ........

Classic

List

Threaded

25 messages Options

vidhyanatarajan

not able to connect the mysql database wth orbeon ........

hi....
thanks for the answer u have send for mysql database support in orbeon form builder....
i have done the same thing what u have said previously...every thing going fine but if i put the line
"<property as="xs:anyURI" name="oxf.fr.persistence.app.uri.*.*.*" value="/fr/service/mysql"/>"
in the file "properties-local.xml" the "publishit" button is not working.......so am not able to publish it ..
even the sample like "bookshelf appl" the value is not stored in mysql databse......
am installing the mysql databse using apt-get-install mysql (linux machine)...

pappleby

Out of Office AutoReply: not able to connect the mysql database wth orbeon ........

I am out of the office until 26th July

***********************************************************************************************

This email, including any attachment, is confidential and may be legally privileged. If you are not the intended recipient or if you have received this email in error, please inform the sender immediately by reply and delete all copies from your system. Do not retain, copy, disclose, distribute or otherwise use any of its contents.

Whilst we have taken reasonable precautions to ensure that this email has been swept for computer viruses, we cannot guarantee that this email does not contain such material and we therefore advise you to carry out your own virus checks. We do not accept liability for any damage or losses sustained as a result of such material.

Please note that incoming and outgoing email communications passing through our IT systems may be monitored and/or intercepted by us solely to determine whether the content is business related and compliant with company standards.

***********************************************************************************************

The Stationery Office Limited is registered in England No. 3049649 at 10 Eastbourne Terrace, London, W2 6LG

karthik Jayaraman

Re: not able to connect the mysql database wth orbeon ........

In reply to this post by vidhyanatarajan

In my version of the orbeon form publish button will be disabled until you save the form. First try to save the form. See whether you get an entry in orbeon_form_data. If not, open a file called orbeon in logs folder of tomcat .. You will get an idea of what went wrong. Anyway i have given the procedure for mysql support in orbeon. Make sure you followed these steps!

1. Run the following data definition statements to create the tables:

create table orbeon_form_definition (
created timestamp,
last_modified datetime,
username varchar(256),
app varchar(256),
form varchar(256),
deleted char(1),
xml mediumtext
);
create table orbeon_form_definition_attach (
created timestamp,
last_modified timestamp,
username varchar(256),
app varchar(256),
form varchar(256),
deleted char(1),
file_name varchar(256),
file_content longblob
);
create table orbeon_form_data (
created timestamp,
last_modified timestamp,
username varchar(256),
app varchar(256),
form varchar(256),
document_id varchar(256),
deleted char(1),
xml mediumtext
);
create table orbeon_form_data_attach (
created timestamp,
last_modified timestamp,
username varchar(256),
app varchar(256),
form varchar(256),
document_id varchar(256),
deleted char(1),
file_name varchar(256),
file_content longblob
);

2. Download mysql-connector-java-5.1.12-bin.jar and place it in apache-tomcat\lib folder

3. In the conf.xml insert the database details

e.g

<Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource"
initialSize="3" maxActive="10" maxIdle="20" maxWait="30000"
driverClassName="com.mysql.jdbc.Driver"
poolPreparedStatements="true"
username="orbeon"
password="orbeon"
url="jdbc:mysql://localhost:3306/orbeon"/>

4. Navigate to properties-local.xml file in \orbeon\WEB-INF\resources\config. Initially you have to rename properties-local.xml.template file to properties-local.xml and insert the following line

<property as="xs:anyURI" name="oxf.fr.persistence.service.mysql.datasource" value="mysql"/>

the value attribute is same as resource name mentioned in the previous step(excluding jdbc/)

5. Add the following line to the same file to denote that all forms you create through orbeon uses mysql database

<property as="xs:anyURI" name="oxf.fr.persistence.app.uri.*.*.*" value="/fr/service/mysql"/>

Thts it ! After you make these changes you should construct a form, save it , publish it. Then you shld check the table you created. The form will be stored as xml in the database!

karthik Jayaraman

Re: not able to connect the mysql database wth orbeon ........

And moreover please do not start another thread for the reply ! Continue your discussion in the same thread !

Han Ming Low

Help on implementing some future features

Hi,

I would like to implement some of the future features listed on
http://wiki.orbeon.com/forms/welcome/form-builder-direction
http://wiki.orbeon.com/forms/projects/form-builder-future-features

Basically, what I would like to implement is to have sort of the next page
or page flow in a Form Builder and/or allow the previous form data posted to
be available to the form's "input:instance".
I'm thinking if this is the feature listed on
http://wiki.orbeon.com/forms/projects/form-builder-future-features
- Next/prev doc when viewing a form
- [ #314761 ] FR: RFE: Ability to POST form data to a particular URL upon
send

If my understanding is correct, I would just like to know if anyone can give
any high level direction on where to proceed with the changes.
I think I can get some resources to contribute to the implementation, but
would greatly appreciate if some high level help can be given so that save
significant amount of time by reading the code from scratch.

Please let me know if it's possible.

Thanks.

Han Ming

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws

Alessandro Vernet

Re: Help on implementing some future features

Administrator

Han,

The "Next/prev doc when viewing a form" feature might be different
from what you have in mind. This one makes sense when form are like
records. Say in the Bookshelf example, this would allow you to
navigate through books from the detail page by hitting a "next" or
"previous" button, which would be equivalent to going back to the
details page, and choosing the next (or previous) book. Now regarding
submitting and receiving XML:

1. Submitting XML is a feature we would like to add. It could come in
two flavors: submit (POST) to a page you are "going to" (i.e. you POST
XML to that page, and it returns HTML shown to users), or submit to a
REST/web service.
2. Receiving XML that you use as the instance is already something you
can do today. See the section "Initial instance posted to the New Form
page" on:

http://wiki.orbeon.com/forms/doc/developer-guide/configuration-properties/configuration-properties-form-runner

Alex

On Sun, Jul 25, 2010 at 11:05 PM, Han Ming <[hidden email]> wrote:

> Hi,
>
> I would like to implement some of the future features listed on
> http://wiki.orbeon.com/forms/welcome/form-builder-direction
> http://wiki.orbeon.com/forms/projects/form-builder-future-features
>
> Basically, what I would like to implement is to have sort of the next page
> or page flow in a Form Builder and/or allow the previous form data posted to
> be available to the form's "input:instance".
> I'm thinking if this is the feature listed on
> http://wiki.orbeon.com/forms/projects/form-builder-future-features
> - Next/prev doc when viewing a form
> - [ #314761 ] FR: RFE: Ability to POST form data to a particular URL upon
> send
>
>
> If my understanding is correct, I would just like to know if anyone can give
> any high level direction on where to proceed with the changes.
> I think I can get some resources to contribute to the implementation, but
> would greatly appreciate if some high level help can be given so that save
> significant amount of time by reading the code from scratch.
>
> Please let me know if it's possible.
>
> Thanks.
>
>
>
> Han Ming
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing
> list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> OW2 mailing lists service home page: http://www.ow2.org/wws
>
>

--
Orbeon Forms - Web forms, open-source, for the Enterprise -
http://www.orbeon.com/
My Twitter: http://twitter.com/avernet

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws

--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet

Han Ming Low

Re: Re: Help on implementing some future features

Hi Alex,

Thanks for the reply and clarification on my misunderstanding. :p

I will need to read up more on it.

Can I ask if I would like to implement some simple page flow, does it means
that it can be achieved by changing the config to
1) post the form data to the url of a second form
2) allow the 2nd form to receive data as initial instance

As you mentioned that submitting XML is not implemented yet, but I "thought"
I have created a submit button on a Form Builder's form by editing the
source through the Edit source menu to define a button with
xforms:submission to post to another form url
e.g.
http://localhost:8080/orbeon/fr/test/Form2/new

By the same token, does it means for the submitting XML to work, I will need
to edit the form's Save button to post the form instance to a defined url?
If so, I might be able to do it with some guidance. :)

Thanks for any advice.

Han Ming

--------------------------------------------------
From: "Alessandro Vernet" <[hidden email]>
Sent: Tuesday, July 27, 2010 8:49 AM
To: "ops-users" <[hidden email]>
Subject: [ops-users] Re: Help on implementing some future features

> Han,
>
> The "Next/prev doc when viewing a form" feature might be different
> from what you have in mind. This one makes sense when form are like
> records. Say in the Bookshelf example, this would allow you to
> navigate through books from the detail page by hitting a "next" or
> "previous" button, which would be equivalent to going back to the
> details page, and choosing the next (or previous) book. Now regarding
> submitting and receiving XML:
>
> 1. Submitting XML is a feature we would like to add. It could come in
> two flavors: submit (POST) to a page you are "going to" (i.e. you POST
> XML to that page, and it returns HTML shown to users), or submit to a
> REST/web service.
> 2. Receiving XML that you use as the instance is already something you
> can do today. See the section "Initial instance posted to the New Form
> page" on:
>
> http://wiki.orbeon.com/forms/doc/developer-guide/configuration-properties/configuration-properties-form-runner
>
> Alex
>
> On Sun, Jul 25, 2010 at 11:05 PM, Han Ming <[hidden email]> wrote:
>> Hi,
>>
>> I would like to implement some of the future features listed on
>> http://wiki.orbeon.com/forms/welcome/form-builder-direction
>> http://wiki.orbeon.com/forms/projects/form-builder-future-features
>>
>> Basically, what I would like to implement is to have sort of the next
>> page
>> or page flow in a Form Builder and/or allow the previous form data posted
>> to
>> be available to the form's "input:instance".
>> I'm thinking if this is the feature listed on
>> http://wiki.orbeon.com/forms/projects/form-builder-future-features
>> - Next/prev doc when viewing a form
>> - [ #314761 ] FR: RFE: Ability to POST form data to a particular URL upon
>> send
>>
>>
>> If my understanding is correct, I would just like to know if anyone can
>> give
>> any high level direction on where to proceed with the changes.
>> I think I can get some resources to contribute to the implementation, but
>> would greatly appreciate if some high level help can be given so that
>> save
>> significant amount of time by reading the code from scratch.
>>
>> Please let me know if it's possible.
>>
>> Thanks.
>>
>>
>>
>> Han Ming
>>
>>
>> --
>> You receive this message as a subscriber of the [hidden email] mailing
>> list.
>> To unsubscribe: mailto:[hidden email]
>> For general help: mailto:[hidden email]?subject=help
>> OW2 mailing lists service home page: http://www.ow2.org/wws
>>
>>
>
>
>
> --
> Orbeon Forms - Web forms, open-source, for the Enterprise -
> http://www.orbeon.com/
> My Twitter: http://twitter.com/avernet
>

>
> --
> You receive this message as a subscriber of the [hidden email] mailing
> list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> OW2 mailing lists service home page: http://www.ow2.org/wws
>

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws

vidhyanatarajan

Re: not able to connect the mysql database wth orbeon ........

In reply to this post by karthik Jayaraman

sorry for the disturbance...
yea for me also the publish wil be disabled until save the form ......after you save the form the publish button will be enabled but ...it is not working ....and one more ....
am using kubuntu 8.04 o.s with mysql installed by ap-get-install-mysqlserver ...and i have done the same what u previously told...but not the form is saved in the database...
pls give ne a correct solution for that ...wat version of orbeon you are using ....for database connection ...whether the is saved in your my sql database or not....

--- On Mon, 26/7/10, karthik Jayaraman [via Orbeon Forms (ops-users)] <[hidden email]> wrote:

From: karthik Jayaraman [via Orbeon Forms (ops-users)] <[hidden email]>
Subject: Re: not able to connect the mysql database wth orbeon ........
To: "vidhyanatarajan" <[hidden email]>
Date: Monday, 26 July, 2010, 10:02 AM

In my version of the orbeon form publish button will be disabled until you save the form. First try to save the form. See whether you get an entry in orbeon_form_data. If not, open a file called orbeon in logs folder of tomcat .. You will get an idea of what went wrong. Anyway i have given the procedure for mysql support in orbeon. Make sure you followed these steps!

1. Run the following data definition statements to create the tables:

create table orbeon_form_definition (
created timestamp,
last_modified datetime,
username varchar(256),
app varchar(256),
form varchar(256),
deleted char(1),
xml mediumtext
);
create table orbeon_form_definition_attach (
created timestamp,
last_modified timestamp,
username varchar(256),
app varchar(256),
form varchar(256),
deleted char(1),
file_name varchar(256),
file_content longblob
);
create table orbeon_form_data (
created timestamp,
last_modified timestamp,
username varchar(256),
app varchar(256),
form varchar(256),
document_id varchar(256),
deleted char(1),
xml mediumtext
);
create table orbeon_form_data_attach (
created timestamp,
last_modified timestamp,
username varchar(256),
app varchar(256),
form varchar(256),
document_id varchar(256),
deleted char(1),
file_name varchar(256),
file_content longblob
);

2. Download mysql-connector-java-5.1.12-bin.jar and place it in apache-tomcat\lib folder

3. In the conf.xml insert the database details

e.g

<Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource"
initialSize="3" maxActive="10" maxIdle="20" maxWait="30000"
driverClassName="com.mysql.jdbc.Driver"
poolPreparedStatements="true"
username="orbeon"
password="orbeon"
url="jdbc:mysql://localhost:3306/orbeon"/>

4. Navigate to properties-local.xml file in \orbeon\WEB-INF\resources\config. Initially you have to rename properties-local.xml.template file to properties-local.xml and insert the following line

<property as="xs:anyURI" name="oxf.fr.persistence.service.mysql.datasource" value="mysql"/>

the value attribute is same as resource name mentioned in the previous step(excluding jdbc/)

5. Add the following line to the same file to denote that all forms you create through orbeon uses mysql database

<property as="xs:anyURI" name="oxf.fr.persistence.app.uri.*.*.*" value="/fr/service/mysql"/>

Thts it ! After you make these changes you should construct a form, save it , publish it. Then you shld check the table you created. The form will be stored as xml in the database!

View message @ http://orbeon-forms-ops-users.24843.n4.nabble.com/not-able-to-connect-the-mysql-database-wth-orbeon-tp2298146p2301897.html
To unsubscribe from not able to connect the mysql database wth orbeon ........, click here.

vidhyanatarajan

regarding orbeon...+ mysql database

In reply to this post by karthik Jayaraman

Hi ,

I will tell you clearly what i have done....for connecting mysql database with orbeon...

i have installed orbeon-3.8-C.E on my apache tomcat-6.0.18....

Operating System used--------kubuntu 8.04..

Then i installed mysql on my machine using ap-get-install-mysqlserver

Then i have create a database with name “orbeon” on mysql.
Then i will create a table what u have said..
create table orbeon_form_definition (
created timestamp,
last_modified datetime,
username varchar(256),
app varchar(256),
form varchar(256),
deleted char(1),
xml mediumtext
);
create table orbeon_form_definition_attach (
created timestamp,
last_modified timestamp,
username varchar(256),
app varchar(256),
form varchar(256),
deleted char(1),
file_name varchar(256),
file_content longblob
);
create table orbeon_form_data (
created timestamp,
last_modified timestamp,
username varchar(256),
app varchar(256),
form varchar(256),
document_id varchar(256),
deleted char(1),
xml mediumtext
);
create table orbeon_form_data_attach (
created timestamp,
last_modified timestamp,
username varchar(256),
app varchar(256),
form varchar(256),
document_id varchar(256),
deleted char(1),
file_name varchar(256),
file_content longblob
);
Then i have also creatted one more table in mysql / orbeon database with name orbeon_details having two fields with name firstname and lastname.
Then i downloaded mysql-connector-java-5.1.12-bin.jar and place it on apache-tomcat\lib folder
Then you said that, in the conf.xml insert the database details

e.g

<Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource"
initialSize="3" maxActive="10" maxIdle="20" maxWait="30000"
driverClassName="com.mysql.jdbc.Driver"
poolPreparedStatements="true"
username="root"
password="root123"
url="jdbc:mysql://localhost:3306/orbeon"/>

(usrname and pswd for mysql db is root and root123...)

but i dont have any conf.xml on apachetomcat/orbeon . So i put these lines in server.xml file under /apache-tomcat/conf..(is it correct or not).

Then Navigate to properties-local.xml file in \orbeon\WEB-INF\resources\config. Initially you have to rename properties-local.xml.template file to properties-local.xml and insert the following line

<property as="xs:anyURI" name="oxf.fr.persistence.service.mysql.datasource" value="mysql"/>

the value attribute is same as resource name mentioned in the previous step(excluding jdbc/)
then , Add the following line to the same file to denote that all forms you create through orbeon uses mysql database

<property as="xs:anyURI" name="oxf.fr.persistence.app.uri.*.*.*" value="/fr/service/mysql"/>

then in go to http://localhost:8080/orbeon ..in that i click the form builder in the left hand side thn it wil give the app name and form name ...then it wil ask the form name and section name i gave thn created 2 fields with name firstname and lastname (because i have created one table which is having 2 fields with name firstname and last name) thn i click save button until i clicked the save button the pubish button is disabled...thn i test the form ...i can able to fill the form after the testing is finioshed the publish button will not be enabled ...if give refresh it enabled but if i click the publish it wont do any action...(thats my problem...)
pls give me good solution for it....

with thanks and regards,
srividhya.N

--- On Mon, 26/7/10, karthik Jayaraman [via Orbeon Forms (ops-users)] <[hidden email]> wrote:

From: karthik Jayaraman [via Orbeon Forms (ops-users)] <[hidden email]>
Subject: Re: not able to connect the mysql database wth orbeon ........
To: "vidhyanatarajan" <[hidden email]>
Date: Monday, 26 July, 2010, 10:02 AM

In my version of the orbeon form publish button will be disabled until you save the form. First try to save the form. See whether you get an entry in orbeon_form_data. If not, open a file called orbeon in logs folder of tomcat .. You will get an idea of what went wrong. Anyway i have given the procedure for mysql support in orbeon. Make sure you followed these steps!

1. Run the following data definition statements to create the tables:

create table orbeon_form_definition (
created timestamp,
last_modified datetime,
username varchar(256),
app varchar(256),
form varchar(256),
deleted char(1),
xml mediumtext
);
create table orbeon_form_definition_attach (
created timestamp,
last_modified timestamp,
username varchar(256),
app varchar(256),
form varchar(256),
deleted char(1),
file_name varchar(256),
file_content longblob
);
create table orbeon_form_data (
created timestamp,
last_modified timestamp,
username varchar(256),
app varchar(256),
form varchar(256),
document_id varchar(256),
deleted char(1),
xml mediumtext
);
create table orbeon_form_data_attach (
created timestamp,
last_modified timestamp,
username varchar(256),
app varchar(256),
form varchar(256),
document_id varchar(256),
deleted char(1),
file_name varchar(256),
file_content longblob
);

2. Download mysql-connector-java-5.1.12-bin.jar and place it in apache-tomcat\lib folder

3. In the conf.xml insert the database details

e.g

<Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource"
initialSize="3" maxActive="10" maxIdle="20" maxWait="30000"
driverClassName="com.mysql.jdbc.Driver"
poolPreparedStatements="true"
username="orbeon"
password="orbeon"
url="jdbc:mysql://localhost:3306/orbeon"/>

4. Navigate to properties-local.xml file in \orbeon\WEB-INF\resources\config. Initially you have to rename properties-local.xml.template file to properties-local.xml and insert the following line

<property as="xs:anyURI" name="oxf.fr.persistence.service.mysql.datasource" value="mysql"/>

the value attribute is same as resource name mentioned in the previous step(excluding jdbc/)

5. Add the following line to the same file to denote that all forms you create through orbeon uses mysql database

<property as="xs:anyURI" name="oxf.fr.persistence.app.uri.*.*.*" value="/fr/service/mysql"/>

Thts it ! After you make these changes you should construct a form, save it , publish it. Then you shld check the table you created. The form will be stored as xml in the database!

View message @ http://orbeon-forms-ops-users.24843.n4.nabble.com/not-able-to-connect-the-mysql-database-wth-orbeon-tp2298146p2301897.html
To unsubscribe from not able to connect the mysql database wth orbeon ........, click here.

Alessandro Vernet

Re: Re: Re: Help on implementing some future features

Administrator

In reply to this post by Han Ming Low

Han,

Let me precise what I said: you *can* have the instance containing the
data entered by users posted to another page using the workflow-send.
See:

http://wiki.orbeon.com/forms/doc/developer-guide/configuration-properties/configuration-properties-form-runner#TOC-Workflow-send-button

However, the code getting the initial instance expects the XML
document to be posted differently (base64 encoded in a request
parameter, instead of the XML being in the body). And even if you
could get form B to receive the instance from form A, the XML
documents for A and B would need to have exactly the same format,
which would limit the application of this technique. Maybe you can
tell us what you'd like to achieve, at a higher level.

Alex

On Mon, Jul 26, 2010 at 6:52 PM, Han Ming <[hidden email]> wrote:

> Hi Alex,
>
> Thanks for the reply and clarification on my misunderstanding. :p
>
> I will need to read up more on it.
>
> Can I ask if I would like to implement some simple page flow, does it means
> that it can be achieved by changing the config to
> 1) post the form data to the url of a second form
> 2) allow the 2nd form to receive data as initial instance
>
> As you mentioned that submitting XML is not implemented yet, but I "thought"
> I have created a submit button on a Form Builder's form by editing the
> source through the Edit source menu to define a button with
> xforms:submission to post to another form url
> e.g.
> http://localhost:8080/orbeon/fr/test/Form2/new
>
> By the same token, does it means for the submitting XML to work, I will need
> to edit the form's Save button to post the form instance to a defined url?
> If so, I might be able to do it with some guidance. :)
>
> Thanks for any advice.
>
>
> Han Ming
>
>
>
> --------------------------------------------------
> From: "Alessandro Vernet" <[hidden email]>
> Sent: Tuesday, July 27, 2010 8:49 AM
> To: "ops-users" <[hidden email]>
> Subject: [ops-users] Re: Help on implementing some future features
>
>> Han,
>>
>> The "Next/prev doc when viewing a form" feature might be different
>> from what you have in mind. This one makes sense when form are like
>> records. Say in the Bookshelf example, this would allow you to
>> navigate through books from the detail page by hitting a "next" or
>> "previous" button, which would be equivalent to going back to the
>> details page, and choosing the next (or previous) book. Now regarding
>> submitting and receiving XML:
>>
>> 1. Submitting XML is a feature we would like to add. It could come in
>> two flavors: submit (POST) to a page you are "going to" (i.e. you POST
>> XML to that page, and it returns HTML shown to users), or submit to a
>> REST/web service.
>> 2. Receiving XML that you use as the instance is already something you
>> can do today. See the section "Initial instance posted to the New Form
>> page" on:
>>
>>
>> http://wiki.orbeon.com/forms/doc/developer-guide/configuration-properties/configuration-properties-form-runner
>>
>> Alex
>>
>> On Sun, Jul 25, 2010 at 11:05 PM, Han Ming <[hidden email]> wrote:
>>>
>>> Hi,
>>>
>>> I would like to implement some of the future features listed on
>>> http://wiki.orbeon.com/forms/welcome/form-builder-direction
>>> http://wiki.orbeon.com/forms/projects/form-builder-future-features
>>>
>>> Basically, what I would like to implement is to have sort of the next
>>> page
>>> or page flow in a Form Builder and/or allow the previous form data posted
>>> to
>>> be available to the form's "input:instance".
>>> I'm thinking if this is the feature listed on
>>> http://wiki.orbeon.com/forms/projects/form-builder-future-features
>>> - Next/prev doc when viewing a form
>>> - [ #314761 ] FR: RFE: Ability to POST form data to a particular URL upon
>>> send
>>>
>>>
>>> If my understanding is correct, I would just like to know if anyone can
>>> give
>>> any high level direction on where to proceed with the changes.
>>> I think I can get some resources to contribute to the implementation, but
>>> would greatly appreciate if some high level help can be given so that
>>> save
>>> significant amount of time by reading the code from scratch.
>>>
>>> Please let me know if it's possible.
>>>
>>> Thanks.
>>>
>>>
>>>
>>> Han Ming
>>>
>>>
>>> --
>>> You receive this message as a subscriber of the [hidden email] mailing
>>> list.
>>> To unsubscribe: mailto:[hidden email]
>>> For general help: mailto:[hidden email]?subject=help
>>> OW2 mailing lists service home page: http://www.ow2.org/wws
>>>
>>>
>>
>>
>>
>> --
>> Orbeon Forms - Web forms, open-source, for the Enterprise -
>> http://www.orbeon.com/
>> My Twitter: http://twitter.com/avernet
>>
>
>
>
>>
>> --
>> You receive this message as a subscriber of the [hidden email] mailing
>> list.
>> To unsubscribe: mailto:[hidden email]
>> For general help: mailto:[hidden email]?subject=help
>> OW2 mailing lists service home page: http://www.ow2.org/wws
>>
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing
> list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> OW2 mailing lists service home page: http://www.ow2.org/wws
>
>

--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet

Han Ming Low

Re: Re: Re: Re: Help on implementing some future features

Alex,

Thanks for explaining.

What I'd like to achieve, is for example, I would like to create a series of forms for company registration.

1st form will let the user to enter personal particular, then when he submits, it will show the 2nd form.

The 2nd form will let the user to enter the company particular, then when he submits, this time instead going directly to 3rd form, it will be submitted to a backend servlet to do some backend validation and then forward the request to the 3rd form url.

So, the information of the 1st, 2nd, 3rd form should be captured as linked in some ways.

Is this possible?

I understand that the 1st to 2nd form submission may be merged as a tab form, but would just like to see the possiblity of achieving it.

And, as I'm writing this example, just thought of a problem, which is, what if the backend validation fails and send back to the form 2?

Thanks a lot for your patience in answering to all the queries.

Han Ming

On Fri, Jul 30, 2010 at 9:11 AM, Alessandro Vernet <[hidden email]> wrote:

Han,

Let me precise what I said: you *can* have the instance containing the
data entered by users posted to another page using the workflow-send.
See:

http://wiki.orbeon.com/forms/doc/developer-guide/configuration-properties/configuration-properties-form-runner#TOC-Workflow-send-button

However, the code getting the initial instance expects the XML
document to be posted differently (base64 encoded in a request
parameter, instead of the XML being in the body). And even if you
could get form B to receive the instance from form A, the XML
documents for A and B would need to have exactly the same format,
which would limit the application of this technique. Maybe you can
tell us what you'd like to achieve, at a higher level.

Alex

On Mon, Jul 26, 2010 at 6:52 PM, Han Ming <[hidden email]> wrote:
> Hi Alex,
>
> Thanks for the reply and clarification on my misunderstanding. :p
>
> I will need to read up more on it.
>
> Can I ask if I would like to implement some simple page flow, does it means
> that it can be achieved by changing the config to
> 1) post the form data to the url of a second form
> 2) allow the 2nd form to receive data as initial instance
>
> As you mentioned that submitting XML is not implemented yet, but I "thought"
> I have created a submit button on a Form Builder's form by editing the
> source through the Edit source menu to define a button with
> xforms:submission to post to another form url
> e.g.
> http://localhost:8080/orbeon/fr/test/Form2/new
>
> By the same token, does it means for the submitting XML to work, I will need
> to edit the form's Save button to post the form instance to a defined url?
> If so, I might be able to do it with some guidance. :)
>
> Thanks for any advice.
>
>
> Han Ming
>
>
>
> --------------------------------------------------
> From: "Alessandro Vernet" <[hidden email]>
> Sent: Tuesday, July 27, 2010 8:49 AM
> To: "ops-users" <[hidden email]>
> Subject: [ops-users] Re: Help on implementing some future features
>
>> Han,
>>
>> The "Next/prev doc when viewing a form" feature might be different
>> from what you have in mind. This one makes sense when form are like
>> records. Say in the Bookshelf example, this would allow you to
>> navigate through books from the detail page by hitting a "next" or
>> "previous" button, which would be equivalent to going back to the
>> details page, and choosing the next (or previous) book. Now regarding
>> submitting and receiving XML:
>>
>> 1. Submitting XML is a feature we would like to add. It could come in
>> two flavors: submit (POST) to a page you are "going to" (i.e. you POST
>> XML to that page, and it returns HTML shown to users), or submit to a
>> REST/web service.
>> 2. Receiving XML that you use as the instance is already something you
>> can do today. See the section "Initial instance posted to the New Form
>> page" on:
>>
>>
>> http://wiki.orbeon.com/forms/doc/developer-guide/configuration-properties/configuration-properties-form-runner
>>
>> Alex
>>
>> On Sun, Jul 25, 2010 at 11:05 PM, Han Ming <[hidden email]> wrote:
>>>
>>> Hi,
>>>
>>> I would like to implement some of the future features listed on
>>> http://wiki.orbeon.com/forms/welcome/form-builder-direction
>>> http://wiki.orbeon.com/forms/projects/form-builder-future-features
>>>
>>> Basically, what I would like to implement is to have sort of the next
>>> page
>>> or page flow in a Form Builder and/or allow the previous form data posted
>>> to
>>> be available to the form's "input:instance".
>>> I'm thinking if this is the feature listed on
>>> http://wiki.orbeon.com/forms/projects/form-builder-future-features
>>> - Next/prev doc when viewing a form
>>> - [ #314761 ] FR: RFE: Ability to POST form data to a particular URL upon
>>> send
>>>
>>>
>>> If my understanding is correct, I would just like to know if anyone can
>>> give
>>> any high level direction on where to proceed with the changes.
>>> I think I can get some resources to contribute to the implementation, but
>>> would greatly appreciate if some high level help can be given so that
>>> save
>>> significant amount of time by reading the code from scratch.
>>>
>>> Please let me know if it's possible.
>>>
>>> Thanks.
>>>
>>>
>>>
>>> Han Ming
>>>
>>>
>>> --
>>> You receive this message as a subscriber of the [hidden email] mailing
>>> list.
>>> To unsubscribe: mailto:[hidden email]
>>> For general help: mailto:[hidden email]?subject=help
>>> OW2 mailing lists service home page: http://www.ow2.org/wws
>>>
>>>
>>
>>
>>
>> --
>> Orbeon Forms - Web forms, open-source, for the Enterprise -
>> http://www.orbeon.com/
>> My Twitter: http://twitter.com/avernet
>>
>
>
>
>>
>> --
>> You receive this message as a subscriber of the [hidden email] mailing
>> list.
>> To unsubscribe: mailto:[hidden email]
>> For general help: mailto:[hidden email]?subject=help
>> OW2 mailing lists service home page: http://www.ow2.org/wws
>>
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing
> list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> OW2 mailing lists service home page: http://www.ow2.org/wws
>
>

--
Orbeon Forms - Web forms, open-source, for the Enterprise -
http://www.orbeon.com/
My Twitter: http://twitter.com/avernet

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws

vidhyanatarajan

Re: not able to connect the mysql database wth orbeon ........

In reply to this post by karthik Jayaraman

Hi ,

I will tell you clearly what i have done....for connecting mysql database with orbeon...

i have installed orbeon-3.8-C.E on my apache tomcat-6.0.18....

Operating System used--------kubuntu 8.04..

Then i installed mysql on my machine using ap-get-install-mysqlserver

Then i have create a database with name “orbeon” on mysql.
Then i will create a table what u have said..
create table orbeon_form_definition (
created timestamp,
last_modified datetime,
username varchar(256),
app varchar(256),
form varchar(256),
deleted char(1),
xml mediumtext
);
create table orbeon_form_definition_attach (
created timestamp,
last_modified timestamp,
username varchar(256),
app varchar(256),
form varchar(256),
deleted char(1),
file_name varchar(256),
file_content longblob
);
create table orbeon_form_data (
created timestamp,
last_modified timestamp,
username varchar(256),
app varchar(256),
form varchar(256),
document_id varchar(256),
deleted char(1),
xml mediumtext
);
create table orbeon_form_data_attach (
created timestamp,
last_modified timestamp,
username varchar(256),
app varchar(256),
form varchar(256),
document_id varchar(256),
deleted char(1),
file_name varchar(256),
file_content longblob
);
Then i have also creatted one more table in mysql / orbeon database with name orbeon_details having two fields with name firstname and lastname.
Then i downloaded mysql-connector-java-5.1.12-bin.jar and place it on apache-tomcat\lib folder
Then you said that, in the conf.xml insert the database details

e.g

<Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource"
initialSize="3" maxActive="10" maxIdle="20" maxWait="30000"
driverClassName="com.mysql.jdbc.Driver"
poolPreparedStatements="true"
username="root"
password="root123"
url="jdbc:mysql://localhost:3306/orbeon"/>

(usrname and pswd for mysql db is root and root123...)

but i dont have any conf.xml on apachetomcat/orbeon . So i put these lines in server.xml file under /apache-tomcat/conf..(is it correct or not).

Then Navigate to properties-local.xml file in \orbeon\WEB-INF\resources\config. Initially you have to rename properties-local.xml.template file to properties-local.xml and insert the following line

<property as="xs:anyURI" name="oxf.fr.persistence.service.mysql.datasource" value="mysql"/>

the value attribute is same as resource name mentioned in the previous step(excluding jdbc/)
then , Add the following line to the same file to denote that all forms you create through orbeon uses mysql database

<property as="xs:anyURI" name="oxf.fr.persistence.app.uri.*.*.*" value="/fr/service/mysql"/>

then in go to http://localhost:8080/orbeon ..in that i click the form builder in the left hand side thn it wil give the app name and form name ...then it wil ask the form name and section name i gave thn created 2 fields with name firstname and lastname (because i have created one table which is having 2 fields with name firstname and last name) thn i click save button until i clicked the save button the pubish button is disabled...thn i test the form ...i can able to fill the form after the testing is finioshed the publish button will not be enabled ...if give refresh it enabled but if i click the publish it wont do any action...(thats my problem...)
pls give me good solution for it....

with thanks and regards,
srividhya.N

--- On Mon, 26/7/10, karthik Jayaraman [via Orbeon Forms (ops-users)] <[hidden email]> wrote:

From: karthik Jayaraman [via Orbeon Forms (ops-users)] <[hidden email]>
Subject: Re: not able to connect the mysql database wth orbeon ........
To: "vidhyanatarajan" <[hidden email]>
Date: Monday, 26 July, 2010, 10:02 AM

In my version of the orbeon form publish button will be disabled until you save the form. First try to save the form. See whether you get an entry in orbeon_form_data. If not, open a file called orbeon in logs folder of tomcat .. You will get an idea of what went wrong. Anyway i have given the procedure for mysql support in orbeon. Make sure you followed these steps!

1. Run the following data definition statements to create the tables:

create table orbeon_form_definition (
created timestamp,
last_modified datetime,
username varchar(256),
app varchar(256),
form varchar(256),
deleted char(1),
xml mediumtext
);
create table orbeon_form_definition_attach (
created timestamp,
last_modified timestamp,
username varchar(256),
app varchar(256),
form varchar(256),
deleted char(1),
file_name varchar(256),
file_content longblob
);
create table orbeon_form_data (
created timestamp,
last_modified timestamp,
username varchar(256),
app varchar(256),
form varchar(256),
document_id varchar(256),
deleted char(1),
xml mediumtext
);
create table orbeon_form_data_attach (
created timestamp,
last_modified timestamp,
username varchar(256),
app varchar(256),
form varchar(256),
document_id varchar(256),
deleted char(1),
file_name varchar(256),
file_content longblob
);

2. Download mysql-connector-java-5.1.12-bin.jar and place it in apache-tomcat\lib folder

3. In the conf.xml insert the database details

e.g

<Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource"
initialSize="3" maxActive="10" maxIdle="20" maxWait="30000"
driverClassName="com.mysql.jdbc.Driver"
poolPreparedStatements="true"
username="orbeon"
password="orbeon"
url="jdbc:mysql://localhost:3306/orbeon"/>

4. Navigate to properties-local.xml file in \orbeon\WEB-INF\resources\config. Initially you have to rename properties-local.xml.template file to properties-local.xml and insert the following line

<property as="xs:anyURI" name="oxf.fr.persistence.service.mysql.datasource" value="mysql"/>

the value attribute is same as resource name mentioned in the previous step(excluding jdbc/)

5. Add the following line to the same file to denote that all forms you create through orbeon uses mysql database

<property as="xs:anyURI" name="oxf.fr.persistence.app.uri.*.*.*" value="/fr/service/mysql"/>

Thts it ! After you make these changes you should construct a form, save it , publish it. Then you shld check the table you created. The form will be stored as xml in the database!

View message @ http://orbeon-forms-ops-users.24843.n4.nabble.com/not-able-to-connect-the-mysql-database-wth-orbeon-tp2298146p2301897.html
To unsubscribe from not able to connect the mysql database wth orbeon ........, click here.

vidhyanatarajan

how sign the output xml file in orbeon for security purpose...

In reply to this post by karthik Jayaraman

hi,
Is it oissible to sign the form which is developed in orbeon form builder for security purpose.....
For example, i have developed a form in orbeon form builder ..any button is there to sign the form (where it will store and how can i see dat output file...)

--
with thanks and regards,
Srividhya.N

Alessandro Vernet

Re: Re: Re: Re: Re: Help on implementing some future features

Administrator

In reply to this post by Han Ming Low

Han,

I would do all this with one Form Builder form. What you describe as
being on form 1, 2, and 3 would be on different sections of that Form
Builder form. You would have visibility rules determining what section
to show when, and implement your custom buttons to go from one section
to the next, with only one section visible at any given time. I know
you would need more information on this to be able to do it, and
unfortunately I don't have the time right now to really document this
thoroughly - sorry about that!

Alex

On Thu, Jul 29, 2010 at 9:19 PM, Han Ming Low <[hidden email]> wrote:

> Alex,
>
> Thanks for explaining.
>
> What I'd like to achieve, is for example, I would like to create a series of
> forms for company registration.
> 1st form will let the user to enter personal particular, then when he
> submits, it will show the 2nd form.
> The 2nd form will let the user to enter the company particular, then when he
> submits, this time instead going directly to 3rd form, it will be submitted
> to a backend servlet to do some backend validation and then forward the
> request to the 3rd form url.
> So, the information of the 1st, 2nd, 3rd form should be captured as linked
> in some ways.
>
> Is this possible?
>
> I understand that the 1st to 2nd form submission may be merged as a tab
> form, but would just like to see the possiblity of achieving it.
>
> And, as I'm writing this example, just thought of a problem, which is, what
> if the backend validation fails and send back to the form 2?
> Thanks a lot for your patience in answering to all the queries.
>
>
>
> Han Ming
>
>
> On Fri, Jul 30, 2010 at 9:11 AM, Alessandro Vernet <[hidden email]>
> wrote:
>>
>> Han,
>>
>> Let me precise what I said: you *can* have the instance containing the
>> data entered by users posted to another page using the workflow-send.
>> See:
>>
>>
>> http://wiki.orbeon.com/forms/doc/developer-guide/configuration-properties/configuration-properties-form-runner#TOC-Workflow-send-button
>>
>> However, the code getting the initial instance expects the XML
>> document to be posted differently (base64 encoded in a request
>> parameter, instead of the XML being in the body). And even if you
>> could get form B to receive the instance from form A, the XML
>> documents for A and B would need to have exactly the same format,
>> which would limit the application of this technique. Maybe you can
>> tell us what you'd like to achieve, at a higher level.
>>
>> Alex
>>
>> On Mon, Jul 26, 2010 at 6:52 PM, Han Ming <[hidden email]> wrote:
>> > Hi Alex,
>> >
>> > Thanks for the reply and clarification on my misunderstanding. :p
>> >
>> > I will need to read up more on it.
>> >
>> > Can I ask if I would like to implement some simple page flow, does it
>> > means
>> > that it can be achieved by changing the config to
>> > 1) post the form data to the url of a second form
>> > 2) allow the 2nd form to receive data as initial instance
>> >
>> > As you mentioned that submitting XML is not implemented yet, but I
>> > "thought"
>> > I have created a submit button on a Form Builder's form by editing the
>> > source through the Edit source menu to define a button with
>> > xforms:submission to post to another form url
>> > e.g.
>> > http://localhost:8080/orbeon/fr/test/Form2/new
>> >
>> > By the same token, does it means for the submitting XML to work, I will
>> > need
>> > to edit the form's Save button to post the form instance to a defined
>> > url?
>> > If so, I might be able to do it with some guidance. :)
>> >
>> > Thanks for any advice.
>> >
>> >
>> > Han Ming
>> >
>> >
>> >
>> > --------------------------------------------------
>> > From: "Alessandro Vernet" <[hidden email]>
>> > Sent: Tuesday, July 27, 2010 8:49 AM
>> > To: "ops-users" <[hidden email]>
>> > Subject: [ops-users] Re: Help on implementing some future features
>> >
>> >> Han,
>> >>
>> >> The "Next/prev doc when viewing a form" feature might be different
>> >> from what you have in mind. This one makes sense when form are like
>> >> records. Say in the Bookshelf example, this would allow you to
>> >> navigate through books from the detail page by hitting a "next" or
>> >> "previous" button, which would be equivalent to going back to the
>> >> details page, and choosing the next (or previous) book. Now regarding
>> >> submitting and receiving XML:
>> >>
>> >> 1. Submitting XML is a feature we would like to add. It could come in
>> >> two flavors: submit (POST) to a page you are "going to" (i.e. you POST
>> >> XML to that page, and it returns HTML shown to users), or submit to a
>> >> REST/web service.
>> >> 2. Receiving XML that you use as the instance is already something you
>> >> can do today. See the section "Initial instance posted to the New Form
>> >> page" on:
>> >>
>> >>
>> >>
>> >> http://wiki.orbeon.com/forms/doc/developer-guide/configuration-properties/configuration-properties-form-runner
>> >>
>> >> Alex
>> >>
>> >> On Sun, Jul 25, 2010 at 11:05 PM, Han Ming <[hidden email]> wrote:
>> >>>
>> >>> Hi,
>> >>>
>> >>> I would like to implement some of the future features listed on
>> >>> http://wiki.orbeon.com/forms/welcome/form-builder-direction
>> >>> http://wiki.orbeon.com/forms/projects/form-builder-future-features
>> >>>
>> >>> Basically, what I would like to implement is to have sort of the next
>> >>> page
>> >>> or page flow in a Form Builder and/or allow the previous form data
>> >>> posted
>> >>> to
>> >>> be available to the form's "input:instance".
>> >>> I'm thinking if this is the feature listed on
>> >>> http://wiki.orbeon.com/forms/projects/form-builder-future-features
>> >>> - Next/prev doc when viewing a form
>> >>> - [ #314761 ] FR: RFE: Ability to POST form data to a particular URL
>> >>> upon
>> >>> send
>> >>>
>> >>>
>> >>> If my understanding is correct, I would just like to know if anyone
>> >>> can
>> >>> give
>> >>> any high level direction on where to proceed with the changes.
>> >>> I think I can get some resources to contribute to the implementation,
>> >>> but
>> >>> would greatly appreciate if some high level help can be given so that
>> >>> save
>> >>> significant amount of time by reading the code from scratch.
>> >>>
>> >>> Please let me know if it's possible.
>> >>>
>> >>> Thanks.
>> >>>
>> >>>
>> >>>
>> >>> Han Ming
>> >>>
>> >>>
>> >>> --
>> >>> You receive this message as a subscriber of the [hidden email]
>> >>> mailing
>> >>> list.
>> >>> To unsubscribe: mailto:[hidden email]
>> >>> For general help: mailto:[hidden email]?subject=help
>> >>> OW2 mailing lists service home page: http://www.ow2.org/wws
>> >>>
>> >>>
>> >>
>> >>
>> >>
>> >> --
>> >> Orbeon Forms - Web forms, open-source, for the Enterprise -
>> >> http://www.orbeon.com/
>> >> My Twitter: http://twitter.com/avernet
>> >>
>> >
>> >
>> >
>> >>
>> >> --
>> >> You receive this message as a subscriber of the [hidden email]
>> >> mailing
>> >> list.
>> >> To unsubscribe: mailto:[hidden email]
>> >> For general help: mailto:[hidden email]?subject=help
>> >> OW2 mailing lists service home page: http://www.ow2.org/wws
>> >>
>> >
>> >
>> > --
>> > You receive this message as a subscriber of the [hidden email]
>> > mailing
>> > list.
>> > To unsubscribe: mailto:[hidden email]
>> > For general help: mailto:[hidden email]?subject=help
>> > OW2 mailing lists service home page: http://www.ow2.org/wws
>> >
>> >
>>
>>
>>
>> --
>> Orbeon Forms - Web forms, open-source, for the Enterprise -
>> http://www.orbeon.com/
>> My Twitter: http://twitter.com/avernet
>>
>>
>> --
>> You receive this message as a subscriber of the [hidden email] mailing
>> list.
>> To unsubscribe: mailto:[hidden email]
>> For general help: mailto:[hidden email]?subject=help
>> OW2 mailing lists service home page: http://www.ow2.org/wws
>>
>
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing
> list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> OW2 mailing lists service home page: http://www.ow2.org/wws
>
>

--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet

Han Ming Low

Re: Re: Re: Re: Re: Re: Help on implementing some future features

Hi Alex,

Thanks for the reply.

I understand there is no through documentation on this.

However, is there any notes to mention about customize button and visibility rules?

Thanks.

Han Ming

On Sat, Jul 31, 2010 at 9:44 AM, Alessandro Vernet <[hidden email]> wrote:

Han,

I would do all this with one Form Builder form. What you describe as
being on form 1, 2, and 3 would be on different sections of that Form
Builder form. You would have visibility rules determining what section
to show when, and implement your custom buttons to go from one section
to the next, with only one section visible at any given time. I know
you would need more information on this to be able to do it, and
unfortunately I don't have the time right now to really document this
thoroughly - sorry about that!

Alex

On Thu, Jul 29, 2010 at 9:19 PM, Han Ming Low <[hidden email]> wrote:
> Alex,
>
> Thanks for explaining.
>
> What I'd like to achieve, is for example, I would like to create a series of
> forms for company registration.
> 1st form will let the user to enter personal particular, then when he
> submits, it will show the 2nd form.
> The 2nd form will let the user to enter the company particular, then when he
> submits, this time instead going directly to 3rd form, it will be submitted
> to a backend servlet to do some backend validation and then forward the
> request to the 3rd form url.
> So, the information of the 1st, 2nd, 3rd form should be captured as linked
> in some ways.
>
> Is this possible?
>
> I understand that the 1st to 2nd form submission may be merged as a tab
> form, but would just like to see the possiblity of achieving it.
>
> And, as I'm writing this example, just thought of a problem, which is, what
> if the backend validation fails and send back to the form 2?
> Thanks a lot for your patience in answering to all the queries.
>
>
>
> Han Ming
>
>
> On Fri, Jul 30, 2010 at 9:11 AM, Alessandro Vernet <[hidden email]>
> wrote:
>>
>> Han,
>>
>> Let me precise what I said: you *can* have the instance containing the
>> data entered by users posted to another page using the workflow-send.
>> See:
>>
>>
>> http://wiki.orbeon.com/forms/doc/developer-guide/configuration-properties/configuration-properties-form-runner#TOC-Workflow-send-button
>>
>> However, the code getting the initial instance expects the XML
>> document to be posted differently (base64 encoded in a request
>> parameter, instead of the XML being in the body). And even if you
>> could get form B to receive the instance from form A, the XML
>> documents for A and B would need to have exactly the same format,
>> which would limit the application of this technique. Maybe you can
>> tell us what you'd like to achieve, at a higher level.
>>
>> Alex
>>
>> On Mon, Jul 26, 2010 at 6:52 PM, Han Ming <[hidden email]> wrote:
>> > Hi Alex,
>> >
>> > Thanks for the reply and clarification on my misunderstanding. :p
>> >
>> > I will need to read up more on it.
>> >
>> > Can I ask if I would like to implement some simple page flow, does it
>> > means
>> > that it can be achieved by changing the config to
>> > 1) post the form data to the url of a second form
>> > 2) allow the 2nd form to receive data as initial instance
>> >
>> > As you mentioned that submitting XML is not implemented yet, but I
>> > "thought"
>> > I have created a submit button on a Form Builder's form by editing the
>> > source through the Edit source menu to define a button with
>> > xforms:submission to post to another form url
>> > e.g.
>> > http://localhost:8080/orbeon/fr/test/Form2/new
>> >
>> > By the same token, does it means for the submitting XML to work, I will
>> > need
>> > to edit the form's Save button to post the form instance to a defined
>> > url?
>> > If so, I might be able to do it with some guidance. :)
>> >
>> > Thanks for any advice.
>> >
>> >
>> > Han Ming
>> >
>> >
>> >
>> > --------------------------------------------------
>> > From: "Alessandro Vernet" <[hidden email]>
>> > Sent: Tuesday, July 27, 2010 8:49 AM
>> > To: "ops-users" <[hidden email]>
>> > Subject: [ops-users] Re: Help on implementing some future features
>> >
>> >> Han,
>> >>
>> >> The "Next/prev doc when viewing a form" feature might be different
>> >> from what you have in mind. This one makes sense when form are like
>> >> records. Say in the Bookshelf example, this would allow you to
>> >> navigate through books from the detail page by hitting a "next" or
>> >> "previous" button, which would be equivalent to going back to the
>> >> details page, and choosing the next (or previous) book. Now regarding
>> >> submitting and receiving XML:
>> >>
>> >> 1. Submitting XML is a feature we would like to add. It could come in
>> >> two flavors: submit (POST) to a page you are "going to" (i.e. you POST
>> >> XML to that page, and it returns HTML shown to users), or submit to a
>> >> REST/web service.
>> >> 2. Receiving XML that you use as the instance is already something you
>> >> can do today. See the section "Initial instance posted to the New Form
>> >> page" on:
>> >>
>> >>
>> >>
>> >> http://wiki.orbeon.com/forms/doc/developer-guide/configuration-properties/configuration-properties-form-runner
>> >>
>> >> Alex
>> >>
>> >> On Sun, Jul 25, 2010 at 11:05 PM, Han Ming <[hidden email]> wrote:
>> >>>
>> >>> Hi,
>> >>>
>> >>> I would like to implement some of the future features listed on
>> >>> http://wiki.orbeon.com/forms/welcome/form-builder-direction
>> >>> http://wiki.orbeon.com/forms/projects/form-builder-future-features
>> >>>
>> >>> Basically, what I would like to implement is to have sort of the next
>> >>> page
>> >>> or page flow in a Form Builder and/or allow the previous form data
>> >>> posted
>> >>> to
>> >>> be available to the form's "input:instance".
>> >>> I'm thinking if this is the feature listed on
>> >>> http://wiki.orbeon.com/forms/projects/form-builder-future-features
>> >>> - Next/prev doc when viewing a form
>> >>> - [ #314761 ] FR: RFE: Ability to POST form data to a particular URL
>> >>> upon
>> >>> send
>> >>>
>> >>>
>> >>> If my understanding is correct, I would just like to know if anyone
>> >>> can
>> >>> give
>> >>> any high level direction on where to proceed with the changes.
>> >>> I think I can get some resources to contribute to the implementation,
>> >>> but
>> >>> would greatly appreciate if some high level help can be given so that
>> >>> save
>> >>> significant amount of time by reading the code from scratch.
>> >>>
>> >>> Please let me know if it's possible.
>> >>>
>> >>> Thanks.
>> >>>
>> >>>
>> >>>
>> >>> Han Ming
>> >>>
>> >>>
>> >>> --
>> >>> You receive this message as a subscriber of the [hidden email]
>> >>> mailing
>> >>> list.
>> >>> To unsubscribe: mailto:[hidden email]
>> >>> For general help: mailto:[hidden email]?subject=help
>> >>> OW2 mailing lists service home page: http://www.ow2.org/wws
>> >>>
>> >>>
>> >>
>> >>
>> >>
>> >> --
>> >> Orbeon Forms - Web forms, open-source, for the Enterprise -
>> >> http://www.orbeon.com/
>> >> My Twitter: http://twitter.com/avernet
>> >>
>> >
>> >
>> >
>> >>
>> >> --
>> >> You receive this message as a subscriber of the [hidden email]
>> >> mailing
>> >> list.
>> >> To unsubscribe: mailto:[hidden email]
>> >> For general help: mailto:[hidden email]?subject=help
>> >> OW2 mailing lists service home page: http://www.ow2.org/wws
>> >>
>> >
>> >
>> > --
>> > You receive this message as a subscriber of the [hidden email]
>> > mailing
>> > list.
>> > To unsubscribe: mailto:[hidden email]
>> > For general help: mailto:[hidden email]?subject=help
>> > OW2 mailing lists service home page: http://www.ow2.org/wws
>> >
>> >
>>
>>
>>
>> --
>> Orbeon Forms - Web forms, open-source, for the Enterprise -
>> http://www.orbeon.com/
>> My Twitter: http://twitter.com/avernet
>>
>>
>> --
>> You receive this message as a subscriber of the [hidden email] mailing
>> list.
>> To unsubscribe: mailto:[hidden email]
>> For general help: mailto:[hidden email]?subject=help
>> OW2 mailing lists service home page: http://www.ow2.org/wws
>>
>
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing
> list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> OW2 mailing lists service home page: http://www.ow2.org/wws
>
>

--
Orbeon Forms - Web forms, open-source, for the Enterprise -
http://www.orbeon.com/
My Twitter: http://twitter.com/avernet

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws

vidhyanatarajan

How can i see the submitted data in orbeon

In reply to this post by karthik Jayaraman

hi,
I have developed a form through orbeon form builder then i have save it, then test it and publish it then the form opens in summary page by accessing http://localhost:8080/orbeon/fr/application-1/form-1/new then i fill the form and save it..then how can i see output xml file.....pls tell me.

thanks and regards,
srividhya.N

--- On Mon, 26/7/10, karthik Jayaraman [via Orbeon Forms (ops-users)] <[hidden email]> wrote:

From: karthik Jayaraman [via Orbeon Forms (ops-users)] <[hidden email]>
Subject: Re: not able to connect the mysql database wth orbeon ........
To: "vidhyanatarajan" <[hidden email]>
Date: Monday, 26 July, 2010, 10:02 AM

In my version of the orbeon form publish button will be disabled until you save the form. First try to save the form. See whether you get an entry in orbeon_form_data. If not, open a file called orbeon in logs folder of tomcat .. You will get an idea of what went wrong. Anyway i have given the procedure for mysql support in orbeon. Make sure you followed these steps!

1. Run the following data definition statements to create the tables:

create table orbeon_form_definition (
created timestamp,
last_modified datetime,
username varchar(256),
app varchar(256),
form varchar(256),
deleted char(1),
xml mediumtext
);
create table orbeon_form_definition_attach (
created timestamp,
last_modified timestamp,
username varchar(256),
app varchar(256),
form varchar(256),
deleted char(1),
file_name varchar(256),
file_content longblob
);
create table orbeon_form_data (
created timestamp,
last_modified timestamp,
username varchar(256),
app varchar(256),
form varchar(256),
document_id varchar(256),
deleted char(1),
xml mediumtext
);
create table orbeon_form_data_attach (
created timestamp,
last_modified timestamp,
username varchar(256),
app varchar(256),
form varchar(256),
document_id varchar(256),
deleted char(1),
file_name varchar(256),
file_content longblob
);

2. Download mysql-connector-java-5.1.12-bin.jar and place it in apache-tomcat\lib folder

3. In the conf.xml insert the database details

e.g

<Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource"
initialSize="3" maxActive="10" maxIdle="20" maxWait="30000"
driverClassName="com.mysql.jdbc.Driver"
poolPreparedStatements="true"
username="orbeon"
password="orbeon"
url="jdbc:mysql://localhost:3306/orbeon"/>

4. Navigate to properties-local.xml file in \orbeon\WEB-INF\resources\config. Initially you have to rename properties-local.xml.template file to properties-local.xml and insert the following line

<property as="xs:anyURI" name="oxf.fr.persistence.service.mysql.datasource" value="mysql"/>

the value attribute is same as resource name mentioned in the previous step(excluding jdbc/)

5. Add the following line to the same file to denote that all forms you create through orbeon uses mysql database

<property as="xs:anyURI" name="oxf.fr.persistence.app.uri.*.*.*" value="/fr/service/mysql"/>

Thts it ! After you make these changes you should construct a form, save it , publish it. Then you shld check the table you created. The form will be stored as xml in the database!

View message @ http://orbeon-forms-ops-users.24843.n4.nabble.com/not-able-to-connect-the-mysql-database-wth-orbeon-tp2298146p2301897.html
To unsubscribe from not able to connect the mysql database wth orbeon ........, click here.

vidhyanatarajan

Orbeon form with Digital signature support

In reply to this post by karthik Jayaraman

hi,
Is it possible to sign the form which is developed using orbeon for security purpose.....
For example, i have developed a form in orbeon. Is there any signature button available to sign the output xml file. (where it will store and how can i see that output file...)

with thanks and regards
Srividhya

View message @ http://orbeon-forms-ops-users.24843.n4.nabble.com/not-able-to-connect-the-mysql-database-wth-orbeon-tp2298146p2301897.html
To unsubscribe from not able to connect the mysql database wth orbeon ........, click here.

vidhyanatarajan

Re: not able to connect the mysql database wth orbeon ........

In reply to this post by karthik Jayaraman

hi,
This is srividhya working as JRF in OTC-NIC and am exploring orbeon form for xforms. Am using orbeon 3.8 C.E version in apache tomct. In this orbeon given many examples including open sign..i want to know the
(i) purpose of this form((opensign), i think it is for signature (right (or) wrong)
(ii)How to work in this opensign and what it will give and what i have to do to explore this one.
(iii) I have explored this , but it is not working properly...if some one know pls help me to explore.

with thanks and regards
Srividhya

vidhyanatarajan

Reg exploring opensign in orbeon

In reply to this post by karthik Jayaraman

hi,

This is srividhya working as JRF in OTC-NIC and am exploring orbeon form for xforms. Am using orbeon 3.8 C.E version in apache tomct. In this orbeon given many examples including open sign..i want to know the

(i) purpose of this form((opensign), i think it is for signature (right (or) wrong)
(ii)How to work in this opensign and what it will give and what i have to do to explore this one.
(iii) I have explored this , but it is not working properly...if some one know pls help me to explore.

with thanks and regards
Srividhya

Alessandro Vernet

Re: Help on implementing some future features

Administrator

In reply to this post by Han Ming Low

Han,

At this point, we don't yet have documentation describing how you can
provide your own buttons in Form Runner. But in essence, you'll edit
your form (if from Form Builder, in the bar, under Advanced, Edit
Source), and under the <fr:body> (i.e. after the closing tag
</fr:body>), you'll add something along these lines:

<fr:bottom>
<fr:buttons-bar>
<fr:buttons>
<fr:button>
<xforms:label>My button</xforms:label>
<xforms:action ev:event="DOMActivate">...</xforms:action>
</fr:button>
</fr:buttons>
</fr:buttons-bar>
</fr:bottom>

This opens to you all the power of XForms, but of course requires you
to know more about XForms.

Alex

On Monday, August 2, 2010, Han Ming Low <[hidden email]> wrote:

> Hi Alex,
>
> Thanks for the reply.
>
> I understand there is no through documentation on this.
>
> However, is there any notes to mention about customize button and visibility rules?
>
> Thanks.
>
>
> Han Ming
>
>
>
> On Sat, Jul 31, 2010 at 9:44 AM, Alessandro Vernet <[hidden email]> wrote:
> Han,
>
> I would do all this with one Form Builder form. What you describe as
> being on form 1, 2, and 3 would be on different sections of that Form
> Builder form. You would have visibility rules determining what section
> to show when, and implement your custom buttons to go from one section
> to the next, with only one section visible at any given time. I know
> you would need more information on this to be able to do it, and
> unfortunately I don't have the time right now to really document this
> thoroughly - sorry about that!
>
> Alex
>
>
>
> On Thu, Jul 29, 2010 at 9:19 PM, Han Ming Low <[hidden email]> wrote:
>> Alex,
>>
>> Thanks for explaining.
>>
>> What I'd like to achieve, is for example, I would like to create a series of
>> forms for company registration.
>> 1st form will let the user to enter personal particular, then when he
>> submits, it will show the 2nd form.
>> The 2nd form will let the user to enter the company particular, then when he
>> submits, this time instead going directly to 3rd form, it will be submitted
>> to a backend servlet to do some backend validation and then forward the
>> request to the 3rd form url.
>> So, the information of the 1st, 2nd, 3rd form should be captured as linked
>> in some ways.
>>
>> Is this possible?
>>
>> I understand that the 1st to 2nd form submission may be merged as a tab
>> form, but would just like to see the possiblity of achieving it.
>>
>> And, as I'm writing this example, just thought of a problem, which is, what
>> if the backend validation fails and send back to the form 2?
>> Thanks a lot for your patience in answering to all the queries.
>>
>>
>>
>> Han Ming
>>
>>
>> On Fri, Jul 30, 2010 at 9:11 AM, Alessandro Vernet <[hidden email]>
>> wrote:
>>>
>>> Han,
>>>
>>> Let me precise what I said: you *can* have the instance containing the
>>> data entered by users posted to another page using the workflow-send.
>>> See:
>>>
>>>
>>> http://wiki.orbeon.com/forms/doc/developer-guide/configuration-properties/configuration-properties-form-runner#TOC-Workflow-send-button
>>>
>>> However, the code getting the initial instance expects the XML
>>> document to be posted differently (base64 encoded in a request
>>> parameter, instead of the XML being in the body). And even if you
>>> could get form B to receive the instance from form A, the XML
>>> documents for A and B would need to have exactly the same format,
>>> which would limit the application of this technique. Maybe you can
>>> tell us what you'd like to achieve, at a higher level.
>>>
>>> Alex
>>>
>>> On Mon, Jul 26, 2010 at 6:52 PM, Han Ming <[hidden email]> wrote:
>>> > Hi Alex,
>>> >
>>> > Thanks for the reply and clarification on my misunderstanding. :p
>>> >
>>> > I will need to read up more on it.
>>> >
>>> > Can I ask if I would like to implement some simple page flow, does it
>>> > means
>>> > that it can be achieved by changing the config to
>>> > 1) post the form data to the url of a second form
>>> > 2) allow the 2nd form to receive data as initial instance
>>> >
>>> > As you mentioned that submitting XML is not implemented yet, but I
>>> > "thought"
>>> > I have created a submit button on a Form Builder's form by editing the
>>> > source through the Edit source menu to define a button with
>>> > xforms:submission to post to another form url
>>> > e.g.
>>> > http://localhost:8080/orbeon/fr/test/Form2/new
>>> >
>>> > By the same token, does it means for the submitting XML to work, I will
>>> > need
>>> > to edit th

--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet