Orbeon Forms community mailing list

Exporting form data to Excel or CSV

Classic

List

Threaded

18 messages Options

Alphonse Ogulla

Exporting form data to Excel or CSV

Hi good people,

Is it possible to export form data from Orbeon forms to MS Excel or CSV format?
I intend to use Form Builder to create a web form to allow close to 7000 users update their details separately then extract this data for import by another application.
Googling "export excel csv site:orbeon.com" shows that this a future project feature that is not currently part of Orbeon forms.
Are there other methods to extract form data or should I look at alternative tools for my web form project?

Thanks & Regards,
Alphonse Ogulla
Nairobil, Kenya

--
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: Exporting form data to Excel or CSV

Administrator

Alphonse,

There isn't (yet!) any built-in functionality to export the data. But
you can implement this yourself, outside of Form Builder. All the data
you capture with your form created with Form Builder is stored in a
database (say eXist or MySQL), so you can write your own code that
queries the database to generate a CSV file.

Alex

On Mon, May 10, 2010 at 10:36 AM, Alphonse Ogulla <[hidden email]> wrote:

> Hi good people,
>
> Is it possible to export form data from Orbeon forms to MS Excel or CSV
> format?
> I intend to use Form Builder to create a web form to allow close to 7000
> users update their details separately then extract this data for import by
> another application.
> Googling "export excel csv site:orbeon.com" shows that this a future project
> feature that is not currently part of Orbeon forms.
> Are there other methods to extract form data or should I look at alternative
> tools for my web form project?
>
> Thanks & Regards,
> Alphonse Ogulla
> Nairobil, Kenya
>
>
>
> --
> 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

Alan Leavy

RE: Re: Exporting form data to Excel or CSV

Hi Alphonse,

I had a similar requirement recently.
In the end I created a pipeline that used XSL to convert my XML data
into a worksheet file in Excel 2007 / Office Open XML format, zipping it
up with the rest of a template to create the Excel XLSX file. It worked
pretty well, except that versions of Excel 2007 before Service Pack 2
didn't seem to like the file. I think that version didn't like the fact
that rows and columns didn't have absolute references. I was considering
redoing it with a similar approach but using the older Excel 2003 XML
format instead (SpreadsheetML) - Haven't gotten around to that yet.

A bit more detail: First I created a spreadsheet in Excel 2007, a mockup
of what I was aiming for, with formatting and dummy data. Then I renamed
that file to .ZIP and unzipped it. I used the unzipped set of files as a
resource / template in my application, generating and replacing just the
worksheet file before zipping it all up again. My XSL stylesheet
referenced the formatting that was already set-up in my template.

I'm attaching an initial prototype application that I used to get it
working. The XML data is hardwired into the input of the first processor
in the pipeline. That would need to be replaced with an SQL processor to
get the real data to be exported. One other point to note is that the
paths to the template files are hard-wired and absolute. You'd have to
change that to point to the correct location to get it working in your
environment. Otherwise it should run as it is.

Anyway, I hope this is useful. Please let me know how you get on. I'd be
interested to hear how you do it in the end, especially if you use an
easier approach.

Regards,
Alan.

-----Original Message-----
From: Alessandro Vernet [mailto:[hidden email]]
Sent: Tuesday, May 11, 2010 5:12 AM
To: [hidden email]
Subject: [ops-users] Re: Exporting form data to Excel or CSV

Alphonse,

There isn't (yet!) any built-in functionality to export the data. But
you can implement this yourself, outside of Form Builder. All the data
you capture with your form created with Form Builder is stored in a
database (say eXist or MySQL), so you can write your own code that
queries the database to generate a CSV file.

Alex

On Mon, May 10, 2010 at 10:36 AM, Alphonse Ogulla <[hidden email]>
wrote:

> Hi good people,
>
> Is it possible to export form data from Orbeon forms to MS Excel or
> CSV format?
> I intend to use Form Builder to create a web form to allow close to
> 7000 users update their details separately then extract this data for
> import by another application.
> Googling "export excel csv site:orbeon.com" shows that this a future
> project feature that is not currently part of Orbeon forms.
> Are there other methods to extract form data or should I look at
> alternative tools for my web form project?
>
> Thanks & Regards,
> Alphonse Ogulla
> Nairobil, Kenya
>
>
>
> --
> 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

tns-test-excel-export.zip (45K) Download Attachment

gino-m

RE: Re: Exporting form data to Excel or CSV

We also had this requirement. If you're using eXist-db as a backend datastore, you can use a custom XQuery that produces CSV, as we did. Attached is a generic XQuery I've written for fetching data as CSV. Through eXist's REST interface, this may also be accessed directly over HTTP (use caution if public access allowed).

Import this query into your eXist-db (through eXist client for example; should be stored as BINARY to work):
csv-export.xq

The CSV export can be called via HTTP using something like:
http://localhost:8080/orbeon/exist/rest/db/path_to_script/csv-export.xq?q=//row_element&f=col1,col2,col3

q is the XPath of nodes to pivot on, each represented by a single row in the CSV output and
f is a comma-separated list of the XPaths of each column, relative to nodes in q.

Trivial example:

If data consists of:

<data>
  <row>
    <col>1</col>
    <col>2</col>
    <col>3</col>
  </row>
  <row>
    <col>A</col>
    <col>B</col>
    <col>C</col>
  </row>
</data>

Accessing the URL:

http://localhost:8080/orbeon/exist/rest/db/myproject/csv-export.xq?q=/data/row&f=col[1],col[2],col[3]

Would return a CSV file containing:

1,2,3
A,B,C

Note that the mime-type is set correctly, so the file should open in Excel by default on most systems.

Before using the file, be sure to set/replace these default values for q= and f= and the collection from which to search for data:

let $default-xpath := "/element"
let $default-fields := ""
let $collection := collection('/db/my/collection/data')

Hope this helps!
-Gino

Gino Miceli
Forest Information Systems Specialist
Food and Agriculture Organization of the United Nations
FAO-Finland Cooperation Programme
Sustainable Forest Management in a Changing Climate
Forest Management Division, Rm. D-406
Viale delle Terme di Caracalla, s.n.c.
00153 Rome, Italy
http://www.fao.org/forestry

Bill Parod

Exception on insert w. spell-checker example ; XBL/dialog issue.

I have a custom XBL component that is modeled on the spell-checker example. It works fine as far as mode/dialog interaction. However, I get an exception when I try to insert a new instance structure bound to the custom XBL component. As a test, I tried the insert with the spell-checker example and it also throws the same exception.

The exception is.

Message: caseBegin is null

File: http://localhost:8080/orbeon/xforms-server/xforms-dialog-yuicalendar-min.js

Line number: 88

Btw, I find that if I remove the <dialog> from the XML component it will insert without a problem. However that defeats the intent of binding the dialog to a source xml context.

Any idea how to fix this?

Here is the slightly abbreviated spell-checker html - with added insert- fyi:

<xhtml:head>

<xhtml:title>Spell checker</xhtml:title>

<xforms:model>

<xforms:instance id="instance">

<text>Ths is a tst with tst spelled incorrectly twice.</text>

</instance>

</xforms:instance>

<xforms:instance id="text-instance"><text>blank text</text></xforms:instance>

</xforms:model>

<xhtml:link type="text/css" rel="stylesheet" href="/ops/yui/logger/assets/logger.css"/>

<xhtml:script type="text/javascript" src="/ops/yui/logger/logger.js"/>

<xhtml:script type="text/javascript" src="/ops/yui/yuitest/yuitest.js"/>

<xhtml:style type="text/css">

.xforms-repeat-selected-item-1 { background-color: transparent }

.block { margin-bottom: 1em }

</xhtml:style>

</xhtml:head>

<xhtml:body>

<xforms:repeat nodeset="text">

<xhtml:div class="block">

<xforms:textarea ref="."/>

<fr:spell-checker ref="."/>

</xhtml:div>

</xforms:repeat>

<fr:button>

<xforms:label>Add text</xforms:label>

<xforms:insert ev:event="DOMActivate" at="last()" position="after" nodeset="text" origin="instance('text-instance')"/>

</fr:button>

</xhtml:body>

Thanks,

Bill

Bill Parod

Library Technology Division - Enterprise Systems

Northwestern University Library

[hidden email]

847 491 5368

--
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

Alistair Miles-2

Re: RE: Re: Exporting form data to Excel or CSV

In reply to this post by gino-m

Hi Gino, this is very cool, thanks for posting it.

Did you also look at transforming CSV to XML? I need to get CSV files
into some sort of XML structure, I'm sure it's straightforward but
would love to know if anyone has code to do this already.

Cheers,

Alistair

On Tue, May 11, 2010 at 06:16:22AM -0700, gino-m wrote:

>
> We also had this requirement. If you're using eXist-db as a backend
> datastore, you can use a custom XQuery that produces CSV, as we did.
> Attached is a generic XQuery I've written for fetching data as CSV. Through
> eXist's REST interface, this may also be accessed directly over HTTP (use
> caution if public access allowed).
>
> Import this query into your eXist-db (through eXist client for example;
> should be stored as BINARY to work):
> http://n4.nabble.com/file/n2173801/csv-export.xq csv-export.xq
>
> The CSV export can be called via HTTP using something like:
> http://localhost:8080/orbeon/exist/rest/db/path_to_script/csv-export.xq?q=//row_element&f=col1,col2,col3
>
> q is the XPath of nodes to pivot on, each represented by a single row in the
> CSV output and
> f is a comma-separated list of the XPaths of each column, relative to nodes
> in q.
>
> Trivial example:
>
> If data consists of:
>
> <data>
> <row>
> <col>1</col>
> <col>2</col>
> <col>3</col>
> </row>
> <row>
> <col>A</col>
> <col>B</col>
> <col>C</col>
> </row>
> </data>
>
> Accessing the URL:
> http://localhost:8080/orbeon/exist/rest/db/myproject/csv-export.xq?q=/data/row&f=col[1],col[2],col[3]
> Would return a CSV file containing:
> 1,2,3
> A,B,C
> Note that the mime-type is set correctly, so the file should open in Excel
> by default on most systems.
>
> Before using the file, be sure to set/replace these default values for q=
> and f= and the collection from which to search for data:
> let $default-xpath := "/element"
> let $default-fields := ""
> let $collection := collection('/db/my/collection/data')
>
> Hope this helps!
> -Gino
>
> -----
>
> Gino Miceli
>
> Forestry Information Systems Specialist
>
> Food and Agriculture Organization of the United Nations
>
> FAO-Finland Cooperation Programme
>
> Sustainable Forest Management in a Changing Climate
>
> Forest Management Division, Rm. D-406
>
> Viale delle Terme di Caracalla, s.n.c.
>
> 00153 Rome, Italy
>
> http://www.fao.org/forestry http://www.fao.org/forestry
>
>
> --
> View this message in context: http://orbeon-forms-ops-users.24843.n4.nabble.com/Exporting-form-data-to-Excel-or-CSV-tp2172669p2173801.html
> Sent from the Orbeon Forms (ops-users) mailing list archive at Nabble.com.

>
> --
> 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

--
Alistair Miles
Head of Epidemiological Informatics
Centre for Genomics and Global Health <http://cggh.org>
The Wellcome Trust Centre for Human Genetics
Roosevelt Drive
Oxford
OX3 7BN
United Kingdom
Web: http://purl.org/net/aliman
Email: [hidden email]
Tel: +44 (0)1865 287669

--
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

gino-m

RE: RE: Re: Exporting form data to Excel or CSV

Glad it was helpful. I haven’t done anything like that yet, but eventually may. One way we could do would be using XSL. Potential hint/solution here: http://andrewjwelch.com/code/xslt/csv/csv-to-xml_v2.html

-Gino

Fabien GUENEGO

Re: RE: RE: Re: Exporting form data to Excel or CSV

Take a look to this archive...

http://orbeon-forms-ops-users.24843.n4.nabble.com/Xpath-2-Orbeon-and-me-td1575600.html#a1579989

Fabien

Le 12/05/2010 13:51, gino-m a écrit :

Glad it was helpful. I haven’t done anything like that yet, but eventually may. One way we could do would be using XSL. Potential hint/solution here: http://andrewjwelch.com/code/xslt/csv/csv-to-xml_v2.html

-Gino

Gino Miceli
Forestry Information Systems Specialist

Food and Agriculture Organization of the United Nations
FAO-Finland Cooperation Programme
Sustainable Forest Management in a Changing Climate
Forest Management Division, Rm. D-406
Viale delle Terme di Caracalla, s.n.c.
00153 Rome, Italy
http://www.fao.org/forestry

View this message in context: RE: RE: Re: Exporting form data to Excel or CSV
Sent from the Orbeon Forms (ops-users) mailing list archive at Nabble.com.

Alessandro Vernet

Re: Exception on insert w. spell-checker example ; XBL/dialog issue.

Administrator

In reply to this post by Bill Parod

Hi Bill,

Good catch. As you've noticed, the dialog in a repeat couldn't be
added to the repeat. I.e. those there when the page loads worked fine,
but you couldn't add new one, and this was unrelated to XBL. This has
never been supported, as in general you don't put dialogs inside a
repeat; it just makes more sense to do so if this isn't done directly,
but through an XBlL component. I just pushed to GitHub the code for
this, and it will be in the next nightly build. You'll let me know if
this works for you. And for reference, the bug is:

http://forge.ow2.org/tracker/index.php?func=detail&aid=314998&group_id=168&atid=350207

Alex

On Tue, May 11, 2010 at 8:48 AM, Bill Parod <[hidden email]> wrote:

> I have a custom XBL component that is modeled on the spell-checker example.
> It works fine as far as mode/dialog interaction. However, I get an exception
> when I try to insert a new instance structure bound to the custom XBL
> component. As a test, I tried the insert with the spell-checker example and
> it also throws the same exception.
> The exception is.
> Message: caseBegin is null
> File:
> http://localhost:8080/orbeon/xforms-server/xforms-dialog-yuicalendar-min.js
> Line number: 88
> Btw, I find that if I remove the <dialog> from the XML component it will
> insert without a problem. However that defeats the intent of binding the
> dialog to a source xml context.
> Any idea how to fix this?
> Here is the slightly abbreviated spell-checker html - with added
> insert-  fyi:
>    <xhtml:head>
>    <xhtml:title>Spell checker</xhtml:title>
>    <xforms:model>
>    <xforms:instance id="instance">
>    <instance>
>    <text>Ths is a tst.</text>
>    <text>Ths is a tst with tst spelled incorrectly
> twice.</text>
>    </instance>
>    </xforms:instance>
>    <xforms:instance id="text-instance"><text>blank
> text</text></xforms:instance>
>    </xforms:model>
>    <xhtml:link type="text/css" rel="stylesheet"
> href="/ops/yui/logger/assets/logger.css"/>
>    <xhtml:script type="text/javascript"
> src="/ops/yui/logger/logger.js"/>
>    <xhtml:script type="text/javascript"
> src="/ops/yui/yuitest/yuitest.js"/>
>    
>    <xhtml:style type="text/css">
>    .xforms-repeat-selected-item-1 { background-color: transparent }
>    .block { margin-bottom: 1em }
>    </xhtml:style>
>    </xhtml:head>
>    <xhtml:body>
>    <xforms:repeat nodeset="text">
>    <xhtml:div class="block">
>    <xforms:textarea ref="."/>
>    <fr:spell-checker ref="."/>
>    </xhtml:div>
>    </xforms:repeat>
> <fr:button>
> <xforms:label>Add text</xforms:label>
> <xforms:insert ev:event="DOMActivate" at="last()" position="after"
> nodeset="text" origin="instance('text-instance')"/>
> </fr:button>
>    </xhtml:body>
> Thanks,
> Bill
>
> Bill Parod
>
> Library Technology Division - Enterprise Systems
> Northwestern University Library
> [hidden email]
> 847 491 5368
>
>
>
>
> --
> 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

Bill Parod

Re: Re: Exception on insert w. spell-checker example ; XBL/dialog issue.

Hi Alex,

Thank you _so_ much. This is great news.

I look forward to trying it out and I'll be sure to let you know how it works.

Best,

Bill

On May 12, 2010, at 7:14 PM, Alessandro Vernet wrote:

Hi Bill,

Good catch. As you've noticed, the dialog in a repeat couldn't be
added to the repeat. I.e. those there when the page loads worked fine,
but you couldn't add new one, and this was unrelated to XBL. This has
never been supported, as in general you don't put dialogs inside a
repeat; it just makes more sense to do so if this isn't done directly,
but through an XBlL component. I just pushed to GitHub the code for
this, and it will be in the next nightly build. You'll let me know if
this works for you. And for reference, the bug is:

http://forge.ow2.org/tracker/index.php?func=detail&aid=314998&group_id=168&atid=350207

Alex

On Tue, May 11, 2010 at 8:48 AM, Bill Parod <[hidden email]> wrote:
I have a custom XBL component that is modeled on the spell-checker example.
It works fine as far as mode/dialog interaction. However, I get an exception
when I try to insert a new instance structure bound to the custom XBL
component. As a test, I tried the insert with the spell-checker example and
it also throws the same exception.
The exception is.
Message: caseBegin is null
File:
http://localhost:8080/orbeon/xforms-server/xforms-dialog-yuicalendar-min.js
Line number: 88
Btw, I find that if I remove the <dialog> from the XML component it will
insert without a problem. However that defeats the intent of binding the
dialog to a source xml context.
Any idea how to fix this?
Here is the slightly abbreviated spell-checker html - with added
insert-  fyi:
   <xhtml:head>
   <xhtml:title>Spell checker</xhtml:title>
   <xforms:model>
   <xforms:instance id="instance">
   <instance>
   <text>Ths is a tst.</text>
   <text>Ths is a tst with tst spelled incorrectly
twice.</text>
   </instance>
   </xforms:instance>
   <xforms:instance id="text-instance"><text>blank
text</text></xforms:instance>
   </xforms:model>
   <xhtml:link type="text/css" rel="stylesheet"
href="/ops/yui/logger/assets/logger.css"/>
   <xhtml:script type="text/javascript"
src="/ops/yui/logger/logger.js"/>
   <xhtml:script type="text/javascript"
src="/ops/yui/yuitest/yuitest.js"/>
   
   <xhtml:style type="text/css">
   .xforms-repeat-selected-item-1 { background-color: transparent }
   .block { margin-bottom: 1em }
   </xhtml:style>
   </xhtml:head>
   <xhtml:body>
   <xforms:repeat nodeset="text">
   <xhtml:div class="block">
   <xforms:textarea ref="."/>
   <fr:spell-checker ref="."/>
   </xhtml:div>
   </xforms:repeat>
<fr:button>
<xforms:label>Add text</xforms:label>
<xforms:insert ev:event="DOMActivate" at="last()" position="after"
nodeset="text" origin="instance('text-instance')"/>
</fr:button>
   </xhtml:body>
Thanks,
Bill

Bill Parod

Library Technology Division - Enterprise Systems
Northwestern University Library
[hidden email]
847 491 5368

--
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

Bill Parod

Library Technology Division - Enterprise Systems

Northwestern University Library

[hidden email]

847 491 5368

Alistair Miles-2

Re: Re: RE: RE: Re: Exporting form data to Excel or CSV

In reply to this post by Fabien GUENEGO

Wonderful, thank you Fabien and Gino.

On Wed, May 12, 2010 at 03:17:08PM +0200, Fabien GUENEGO wrote:

> Take a look to this archive...
>
> http://orbeon-forms-ops-users.24843.n4.nabble.com/Xpath-2-Orbeon-and-me-td1575600.html#a1579989
>
> Fabien
>
> Le 12/05/2010 13:51, gino-m a écrit :
> >
> >Glad it was helpful. I haven't done anything like that yet, but
> >eventually may. One way we could do would be using XSL.
> >Potential hint/solution here:
> >http://andrewjwelch.com/code/xslt/csv/csv-to-xml_v2.html
> >
> >-Gino
> >
> >*Gino Miceli*
> >/Forestry Information Systems Specialist/
> >
> >Food and Agriculture Organization of the United Nations
> >FAO-Finland Cooperation Programme
> >Sustainable Forest Management in a Changing Climate
> >Forest Management Division, Rm. D-406
> >Viale delle Terme di Caracalla, s.n.c.
> >00153 Rome, Italy
> >http://www.fao.org/forestry
> >
> >------------------------------------------------------------------------
> >View this message in context: RE: RE: Re: Exporting form data to
> >Excel or CSV <http://orbeon-forms-ops-users.24843.n4.nabble.com/Exporting-form-data-to-Excel-or-CSV-tp2172669p2195916.html>
> >Sent from the Orbeon Forms (ops-users) mailing list archive
> ><http://orbeon-forms-ops-users.24843.n4.nabble.com/> at
> >Nabble.com.
>

Bill Parod

Re: Re: Exception on insert w. spell-checker example ; XBL/dialog issue.

In reply to this post by Alessandro Vernet

Hi Alex,

I tried the build dated May 13 6:47 pm. It didn't seem to fix the problem. I've attached a spell-checker.xhtml with an insert trigger, for convenience as it's a concise example of a dialog inside a repeat as well. Does it work with your build?

Thanks again - very much! - for all your help on the list.

Bill

On May 12, 2010, at 7:14 PM, Alessandro Vernet wrote:

Hi Bill,

Good catch. As you've noticed, the dialog in a repeat couldn't be
added to the repeat. I.e. those there when the page loads worked fine,
but you couldn't add new one, and this was unrelated to XBL. This has
never been supported, as in general you don't put dialogs inside a
repeat; it just makes more sense to do so if this isn't done directly,
but through an XBlL component. I just pushed to GitHub the code for
this, and it will be in the next nightly build. You'll let me know if
this works for you. And for reference, the bug is:

http://forge.ow2.org/tracker/index.php?func=detail&aid=314998&group_id=168&atid=350207

Alex

On Tue, May 11, 2010 at 8:48 AM, Bill Parod <[hidden email]> wrote:
I have a custom XBL component that is modeled on the spell-checker example.
It works fine as far as mode/dialog interaction. However, I get an exception
when I try to insert a new instance structure bound to the custom XBL
component. As a test, I tried the insert with the spell-checker example and
it also throws the same exception.
The exception is.
Message: caseBegin is null
File:
http://localhost:8080/orbeon/xforms-server/xforms-dialog-yuicalendar-min.js
Line number: 88
Btw, I find that if I remove the <dialog> from the XML component it will
insert without a problem. However that defeats the intent of binding the
dialog to a source xml context.
Any idea how to fix this?
Here is the slightly abbreviated spell-checker html - with added
insert-  fyi:
   <xhtml:head>
   <xhtml:title>Spell checker</xhtml:title>
   <xforms:model>
   <xforms:instance id="instance">
   <instance>
   <text>Ths is a tst.</text>
   <text>Ths is a tst with tst spelled incorrectly
twice.</text>
   </instance>
   </xforms:instance>
   <xforms:instance id="text-instance"><text>blank
text</text></xforms:instance>
   </xforms:model>
   <xhtml:link type="text/css" rel="stylesheet"
href="/ops/yui/logger/assets/logger.css"/>
   <xhtml:script type="text/javascript"
src="/ops/yui/logger/logger.js"/>
   <xhtml:script type="text/javascript"
src="/ops/yui/yuitest/yuitest.js"/>
   
   <xhtml:style type="text/css">
   .xforms-repeat-selected-item-1 { background-color: transparent }
   .block { margin-bottom: 1em }
   </xhtml:style>
   </xhtml:head>
   <xhtml:body>
   <xforms:repeat nodeset="text">
   <xhtml:div class="block">
   <xforms:textarea ref="."/>
   <fr:spell-checker ref="."/>
   </xhtml:div>
   </xforms:repeat>
<fr:button>
<xforms:label>Add text</xforms:label>
<xforms:insert ev:event="DOMActivate" at="last()" position="after"
nodeset="text" origin="instance('text-instance')"/>
</fr:button>
   </xhtml:body>
Thanks,
Bill

Bill Parod

Library Technology Division - Enterprise Systems
Northwestern University Library
[hidden email]
847 491 5368

--
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

Bill Parod

Library Technology Division - Enterprise Systems

Northwestern University Library

[hidden email]

847 491 5368

spell-checker.xhtml (4K) Download Attachment

Alessandro Vernet

Re: Re: Re: Exception on insert w. spell-checker example ; XBL/dialog issue.

Administrator

Hi Bill,

It is working for me here with the latest code. Now our build server
was offline for a little while, and I wondering if you could have
gotten a build which doesn't have that fix. Could you please try this
again with the latest nightly build?

Alex

On Fri, May 14, 2010 at 9:50 AM, Bill Parod <[hidden email]> wrote:

> Hi Alex,
> I tried the build dated May 13 6:47 pm. It didn't seem to fix the problem.
> I've attached a spell-checker.xhtml with an insert trigger, for convenience
> as it's a concise example of a dialog inside a repeat as well. Does it work
> with your build?
> Thanks again - very much! - for all your help on the list.
> Bill
>
>
>
> On May 12, 2010, at 7:14 PM, Alessandro Vernet wrote:
>
> Hi Bill,
>
> Good catch. As you've noticed, the dialog in a repeat couldn't be
> added to the repeat. I.e. those there when the page loads worked fine,
> but you couldn't add new one, and this was unrelated to XBL. This has
> never been supported, as in general you don't put dialogs inside a
> repeat; it just makes more sense to do so if this isn't done directly,
> but through an XBlL component. I just pushed to GitHub the code for
> this, and it will be in the next nightly build. You'll let me know if
> this works for you. And for reference, the bug is:
>
> http://forge.ow2.org/tracker/index.php?func=detail&aid=314998&group_id=168&atid=350207
>
> Alex
>
> On Tue, May 11, 2010 at 8:48 AM, Bill Parod <[hidden email]>
> wrote:
>
> I have a custom XBL component that is modeled on the spell-checker example.
>
> It works fine as far as mode/dialog interaction. However, I get an exception
>
> when I try to insert a new instance structure bound to the custom XBL
>
> component. As a test, I tried the insert with the spell-checker example and
>
> it also throws the same exception.
>
> The exception is.
>
> Message: caseBegin is null
>
> File:
>
> http://localhost:8080/orbeon/xforms-server/xforms-dialog-yuicalendar-min.js
>
> Line number: 88
>
> Btw, I find that if I remove the <dialog> from the XML component it will
>
> insert without a problem. However that defeats the intent of binding the
>
> dialog to a source xml context.
>
> Any idea how to fix this?
>
> Here is the slightly abbreviated spell-checker html - with added
>
> insert-  fyi:
>
>    <xhtml:head>
>
>    <xhtml:title>Spell checker</xhtml:title>
>
>    <xforms:model>
>
>    <xforms:instance id="instance">
>
>    <instance>
>
>    <text>Ths is a tst.</text>
>
>    <text>Ths is a tst with tst spelled incorrectly
>
> twice.</text>
>
>    </instance>
>
>    </xforms:instance>
>
>    <xforms:instance id="text-instance"><text>blank
>
> text</text></xforms:instance>
>
>    </xforms:model>
>
>    <xhtml:link type="text/css" rel="stylesheet"
>
> href="/ops/yui/logger/assets/logger.css"/>
>
>    <xhtml:script type="text/javascript"
>
> src="/ops/yui/logger/logger.js"/>
>
>    <xhtml:script type="text/javascript"
>
> src="/ops/yui/yuitest/yuitest.js"/>
>
>    
>
>    <xhtml:style type="text/css">
>
>    .xforms-repeat-selected-item-1 { background-color: transparent }
>
>    .block { margin-bottom: 1em }
>
>    </xhtml:style>
>
>    </xhtml:head>
>
>    <xhtml:body>
>
>    <xforms:repeat nodeset="text">
>
>    <xhtml:div class="block">
>
>    <xforms:textarea ref="."/>
>
>    <fr:spell-checker ref="."/>
>
>    </xhtml:div>
>
>    </xforms:repeat>
>
> <fr:button>
>
> <xforms:label>Add text</xforms:label>
>
> <xforms:insert ev:event="DOMActivate" at="last()" position="after"
>
> nodeset="text" origin="instance('text-instance')"/>
>
> </fr:button>
>
>    </xhtml:body>
>
> Thanks,
>
> Bill
>
> Bill Parod
>
> Library Technology Division - Enterprise Systems
>
> Northwestern University Library
>
> [hidden email]
>
> 847 491 5368
>
>
>
>
> --
>
> 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
>
> Bill Parod
>
> Library Technology Division - Enterprise Systems
> Northwestern University Library
> [hidden email]
> 847 491 5368
>
>
>
>
> --
> 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

Bill Parod

Re: Re: Re: Re: Exception on insert w. spell-checker example ; XBL/dialog issue.

Hi Alex,

I just downloaded the latest, tried it, and it works great. Thank you so much!

Bill

On May 14, 2010, at 5:03 PM, Alessandro Vernet wrote:

Hi Bill,

It is working for me here with the latest code. Now our build server
was offline for a little while, and I wondering if you could have
gotten a build which doesn't have that fix. Could you please try this
again with the latest nightly build?

Alex

On Fri, May 14, 2010 at 9:50 AM, Bill Parod <[hidden email]> wrote:
Hi Alex,
I tried the build dated May 13 6:47 pm. It didn't seem to fix the problem.
I've attached a spell-checker.xhtml with an insert trigger, for convenience
as it's a concise example of a dialog inside a repeat as well. Does it work
with your build?
Thanks again - very much! - for all your help on the list.
Bill

On May 12, 2010, at 7:14 PM, Alessandro Vernet wrote:

Hi Bill,

Good catch. As you've noticed, the dialog in a repeat couldn't be
added to the repeat. I.e. those there when the page loads worked fine,
but you couldn't add new one, and this was unrelated to XBL. This has
never been supported, as in general you don't put dialogs inside a
repeat; it just makes more sense to do so if this isn't done directly,
but through an XBlL component. I just pushed to GitHub the code for
this, and it will be in the next nightly build. You'll let me know if
this works for you. And for reference, the bug is:

http://forge.ow2.org/tracker/index.php?func=detail&aid=314998&group_id=168&atid=350207

Alex

On Tue, May 11, 2010 at 8:48 AM, Bill Parod <[hidden email]>
wrote:

I have a custom XBL component that is modeled on the spell-checker example.

It works fine as far as mode/dialog interaction. However, I get an exception

when I try to insert a new instance structure bound to the custom XBL

component. As a test, I tried the insert with the spell-checker example and

it also throws the same exception.

The exception is.

Message: caseBegin is null

File:

http://localhost:8080/orbeon/xforms-server/xforms-dialog-yuicalendar-min.js

Line number: 88

Btw, I find that if I remove the <dialog> from the XML component it will

insert without a problem. However that defeats the intent of binding the

dialog to a source xml context.

Any idea how to fix this?

Here is the slightly abbreviated spell-checker html - with added

insert-  fyi:

   <xhtml:head>

   <xhtml:title>Spell checker</xhtml:title>

   <xforms:model>

   <xforms:instance id="instance">

   <instance>

   <text>Ths is a tst.</text>

   <text>Ths is a tst with tst spelled incorrectly

twice.</text>

   </instance>

   </xforms:instance>

   <xforms:instance id="text-instance"><text>blank

text</text></xforms:instance>

   </xforms:model>

   <xhtml:link type="text/css" rel="stylesheet"

href="/ops/yui/logger/assets/logger.css"/>

   <xhtml:script type="text/javascript"

src="/ops/yui/logger/logger.js"/>

   <xhtml:script type="text/javascript"

src="/ops/yui/yuitest/yuitest.js"/>

   

   <xhtml:style type="text/css">

   .xforms-repeat-selected-item-1 { background-color: transparent }

   .block { margin-bottom: 1em }

   </xhtml:style>

   </xhtml:head>

   <xhtml:body>

   <xforms:repeat nodeset="text">

   <xhtml:div class="block">

   <xforms:textarea ref="."/>

   <fr:spell-checker ref="."/>

   </xhtml:div>

   </xforms:repeat>

<fr:button>

<xforms:label>Add text</xforms:label>

<xforms:insert ev:event="DOMActivate" at="last()" position="after"

nodeset="text" origin="instance('text-instance')"/>

</fr:button>

   </xhtml:body>

Thanks,

Bill

Bill Parod

Library Technology Division - Enterprise Systems

Northwestern University Library

[hidden email]

847 491 5368

--

You receive this message as a subscriber of the [hidden email] mailing

list.

To unsubscribe: [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: [hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws

Bill Parod

Library Technology Division - Enterprise Systems
Northwestern University Library
[hidden email]
847 491 5368

--
You receive this message as a subscriber of the [hidden email] mailing
list.
To unsubscribe: [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

Bill Parod

Library Technology Division - Enterprise Systems

Northwestern University Library

[hidden email]

847 491 5368

Alessandro Vernet

Re: Re: Re: Re: Re: Exception on insert w. spell-checker example ; XBL/dialog issue.

Administrator

Bill,

Excellent. (I'm reassured!) Thank you for confirming this,

Alex

On Fri, May 14, 2010 at 3:23 PM, Bill Parod <[hidden email]> wrote:

> Hi Alex,
> I just downloaded the latest, tried it, and it works great. Thank you so
> much!
> Bill
>
> On May 14, 2010, at 5:03 PM, Alessandro Vernet wrote:
>
> Hi Bill,
>
> It is working for me here with the latest code. Now our build server
> was offline for a little while, and I wondering if you could have
> gotten a build which doesn't have that fix. Could you please try this
> again with the latest nightly build?
>
> Alex
>
> On Fri, May 14, 2010 at 9:50 AM, Bill Parod <[hidden email]>
> wrote:
>
> Hi Alex,
>
> I tried the build dated May 13 6:47 pm. It didn't seem to fix the problem.
>
> I've attached a spell-checker.xhtml with an insert trigger, for convenience
>
> as it's a concise example of a dialog inside a repeat as well. Does it work
>
> with your build?
>
> Thanks again - very much! - for all your help on the list.
>
> Bill
>
>
>
> On May 12, 2010, at 7:14 PM, Alessandro Vernet wrote:
>
> Hi Bill,
>
> Good catch. As you've noticed, the dialog in a repeat couldn't be
>
> added to the repeat. I.e. those there when the page loads worked fine,
>
> but you couldn't add new one, and this was unrelated to XBL. This has
>
> never been supported, as in general you don't put dialogs inside a
>
> repeat; it just makes more sense to do so if this isn't done directly,
>
> but through an XBlL component. I just pushed to GitHub the code for
>
> this, and it will be in the next nightly build. You'll let me know if
>
> this works for you. And for reference, the bug is:
>
> http://forge.ow2.org/tracker/index.php?func=detail&aid=314998&group_id=168&atid=350207
>
> Alex
>
> On Tue, May 11, 2010 at 8:48 AM, Bill Parod <[hidden email]>
>
> wrote:
>
> I have a custom XBL component that is modeled on the spell-checker example.
>
> It works fine as far as mode/dialog interaction. However, I get an exception
>
> when I try to insert a new instance structure bound to the custom XBL
>
> component. As a test, I tried the insert with the spell-checker example and
>
> it also throws the same exception.
>
> The exception is.
>
> Message: caseBegin is null
>
> File:
>
> http://localhost:8080/orbeon/xforms-server/xforms-dialog-yuicalendar-min.js
>
> Line number: 88
>
> Btw, I find that if I remove the <dialog> from the XML component it will
>
> insert without a problem. However that defeats the intent of binding the
>
> dialog to a source xml context.
>
> Any idea how to fix this?
>
> Here is the slightly abbreviated spell-checker html - with added
>
> insert-  fyi:
>
>    <xhtml:head>
>
>    <xhtml:title>Spell checker</xhtml:title>
>
>    <xforms:model>
>
>    <xforms:instance id="instance">
>
>    <instance>
>
>    <text>Ths is a tst.</text>
>
>    <text>Ths is a tst with tst spelled incorrectly
>
> twice.</text>
>
>    </instance>
>
>    </xforms:instance>
>
>    <xforms:instance id="text-instance"><text>blank
>
> text</text></xforms:instance>
>
>    </xforms:model>
>
>    <xhtml:link type="text/css" rel="stylesheet"
>
> href="/ops/yui/logger/assets/logger.css"/>
>
>    <xhtml:script type="text/javascript"
>
> src="/ops/yui/logger/logger.js"/>
>
>    <xhtml:script type="text/javascript"
>
> src="/ops/yui/yuitest/yuitest.js"/>
>
>    
>
>    <xhtml:style type="text/css">
>
>    .xforms-repeat-selected-item-1 { background-color: transparent }
>
>    .block { margin-bottom: 1em }
>
>    </xhtml:style>
>
>    </xhtml:head>
>
>    <xhtml:body>
>
>    <xforms:repeat nodeset="text">
>
>    <xhtml:div class="block">
>
>    <xforms:textarea ref="."/>
>
>    <fr:spell-checker ref="."/>
>
>    </xhtml:div>
>
>    </xforms:repeat>
>
> <fr:button>
>
> <xforms:label>Add text</xforms:label>
>
> <xforms:insert ev:event="DOMActivate" at="last()" position="after"
>
> nodeset="text" origin="instance('text-instance')"/>
>
> </fr:button>
>
>    </xhtml:body>
>
> Thanks,
>
> Bill
>
> Bill Parod
>
> Library Technology Division - Enterprise Systems
>
> Northwestern University Library
>
> [hidden email]
>
> 847 491 5368
>
>
>
>
> --
>
> 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
>
> Bill Parod
>
> Library Technology Division - Enterprise Systems
>
> Northwestern University Library
>
> [hidden email]
>
> 847 491 5368
>
>
>
>
> --
>
> 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
>
> Bill Parod
>
> Library Technology Division - Enterprise Systems
> Northwestern University Library
> [hidden email]
> 847 491 5368
>
>
>
>
> --
> 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

smedrick

RE: Re: Exporting form data to Excel or CSV

In reply to this post by gino-m

If I were to use Gino's excellent script to export csv from a form created by Form Builder, where on the server would I store this script?

Erik Bruchez

Re: RE: Re: Exporting form data to Excel or CSV

Administrator

My understanding is that that script was meant to be stored into
eXist. You can use the eXist client to store it somewhere. This might
require learning a bit about eXist!

-Erik

On Fri, Oct 21, 2011 at 6:38 PM, smedrick <[hidden email]> wrote:

> If I were to use Gino's excellent script to export csv from a form created by
> Form Builder, where on the server would I store this script?
>
> --
> View this message in context: http://orbeon-forms-ops-users.24843.n4.nabble.com/Exporting-form-data-to-Excel-or-CSV-tp2172669p3927228.html
> Sent from the Orbeon Forms (ops-users) mailing list archive at Nabble.com.
>
>
> --
> 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
>
>

smedrick

Re: RE: Re: Exporting form data to Excel or CSV

Yeah, I guess I had to learn something new to solve my problem. For anyone initially as confused as I was, go to http://exist.sourceforge.net/download.html and download the exe. This will install a very easy to use eXist client.