Making a relational database...Is it correctly linked and working?.

CONTENTS DELETED

Hi Leo,

I am looking at your orbeon.log, but I don't see any error, and as you're saying data gets stored in the database. What do you mean by "i don't know how to create a relational database"? Is anything not working for you? What problem are you trying to resolve?

Alex

CONTENTS DELETED

Hi Leo,

The data is stored as XML in the relational database, in the "xml" column of "orbeon_form_data". If you need to have that in a "relational table format", you could write a trigger that extracts the data when inserted, per:

https://github.com/orbeon/orbeon-forms/wiki/Installation-~-Relational-Database-Setup#manual-relational-table-setup-with-mysql

Is this something that could work for you?

Alex

CONTENTS DELETED

Hi Leo,

Ah, I think that we changed the root element on that example to be <form>, as it is on all forms, so the XPath expressions in the trigger should be /form/details/title and /form/details/author (instead of /book/…). Could you try with those updated expressions? And you can also look at the XML in the tool you're using, to see if the XPath expression is correct. You'll let me know if this works for you, and I can then fix the doc accordingly.

Alex

CONTENTS DELETED

CONTENTS DELETED

CONTENTS DELETED

Hi Leo,

You're saying that "it looks like i can get the data language, author, title". So is the trigger working? Where are you with this?

Alex