Yes, quite a good description and I believe the answer at this stage
is no, it is not implemented. The reason for this is that the
implementation done within OpenOffice.org currently is based on the
XForm 1.0 standards set whereas the repeatable field is based on the
XForm 1.1 set if I remember correctly. The 1.1 set also introduced
others options such as looping and conditional displays which would
also be useful, but that is destined for a future version of
OpenOffice.org I would think.
Regards
Jonathon
On 12/07/2007, at 8:28 AM, Andrew Douglas Pitonyak wrote:
Excellent description, thanks.
Swanson, Dennis wrote:
A repeating field is one that is bound just once on a form to an xml
attribute, but you want to repeat for each time the xml element
appears in
your document. Mainly because when designing your template, you
don't know
how many times something will appear in the list.
Think of a grocery list... you have your items that you purchased
listed
along with the price of each item.
You might have xml that looks like this.
<data>
<itempurchased>
<Name>toothpaste</Name>
<price>$2</price>
</itempurchased>
<itempurchased>
<Name>watermelon</Name>
<price>$5</price>
</itempurchased> <itempurchased>
<Name>Apples</Name>
<price>$3</price>
</itempurchased>
</data>
But on your document, you want it look something like this:
ITEM PRICE
Toothpaste $2
Watermelon $5
Apples $3
You wouldn't want to create 3 different fields for toothpaste,
watermelon,
and Apples (what if the person bought 4 items?). Instead you'd
want to
create field and just have it repeat for each time that element is
found in
the xml.
Hope that makes sense... Dennis
-----Original Message-----
From: Andrew Douglas Pitonyak [mailto:[EMAIL PROTECTED] Sent:
Tuesday, July 10, 2007 10:27 PM
To: [email protected]
Subject: Re: [users] XForms repeating fields
I will repeat the original question from [EMAIL PROTECTED]
What do you mean by repeating fields?
I assume that you mean that you want a single set of fields to
then represent multiple data rows (as in mailing labels), but I am
only guessing.
As for security:
Much would depend on your security model for your EJBs and J2EE.
How do you authenticate? How does an EJB know that it is allowed
to do something? If you have already authenticated, using the
method of your choice, then in your secure location (I am assuming
a multi-tiered setup) you can do your stuff after you have already
verified your users...
that said, Yes, Base can access other database systems such as MYSQL.
Swanson, Dennis wrote:
I looked at it... but my understanding (correct me if I'm wrong
cuz I'm
pretty new to OpenOffice) is that OpenOffice Base basically
allows you to
just get the data directly from the database. That won't work
for us
because all of our security, processing, etc is done in EJB's in
a J2EE
architecture. So hitting the database directly basically by-
passes all of
that. Unless OpenOffice Base allows you to use something other
than a
database as its source (like xml, a webservice, etc.) it won't
work for
us.
That's why we were looking at the OpenOffice Writer XForm
functionality
for
what we need. But like I said, I'm an OpenOffice-newbie so I
could have
very well missed something that could make Base work for us.
-----Original Message-----
From: S Perry [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 10,
2007 3:19 PM
To: [email protected]
Subject: Re: [users] XForms repeating fields
Have you checked OpenOfficeBase's REPORT capability?
Repeating fields is how you make a sheet of labels with the same
address.
You do not use NEXT RECORD for the second and subsequent labels
if you
want
a sheet that has the same address on every label, such as your
return
address labels.
If you want to make a sheet of mailing labels that are all
different,
you
use the fields you want for each label for the first label, then
NEXT
RECORD
for the subsequent labels.
[EMAIL PROTECTED] wrote:
Not quite sure what you mean - could you give an example of
repeating
fields?
Quoting "Swanson, Dennis" :
We are interested in using OpenOffice xforms to create some
reports based
off of xml that we pass to the document. The problem we're
running into
now
is that it doesn't appear that OpenOffice currently supports
repeating
fields with xforms (to display more than one record of
something). Can
someone confirm this?
Also, if OOo does not currently support repeatable fields with
xforms, my
next question is: I see that a report designer is being planned
for OOo
3.0 next year, does anyone know if it will include this capability?
Thanks,
Dennis
--------------------------------------------------------------------
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------
Get the free Yahoo! toolbar and rest assured with the added
security of
spyware protection.
--------------------------------------------------------------------
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info: http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
------------------------------------
Jonathon Coombes - Cybersite Consulting
MySQL Consulting + Training Partner
Authorised MySQL Training Centre
http://www.cybersite.com.au
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
