Orbeon Forms community mailing list

XLS Generator

Classic

List

Threaded

9 messages Options

Ryan Puddephatt-3

XLS Generator

Hi all,

I’ve made some modifications to the XLS generator processor, so it doesn’t require an upload form and thought I would share it.

Alex/Erik,

It would be great if this could be put in the Orbeon code stream so it can be maintained internally

Thanks

Ryan

-----------------------------------------------

Ryan Puddephatt

FIX Developer

Fidessa LatentZero

1 Alfred Place

London WC1E 7EB

Office: +44 (0) 20 7462 4200

Direct: +44 (0) 20 7323 6112

Blackberry: +44 (0) 79 8539 2458

Fax: +44 (0) 20 7462 4242

Email: [hidden email]

Web: http://www.latentzero.com

XLSGenerator.zip (3K) Download Attachment

ricetrac

RE: XLS Generator

Hello,

What are the modification you made ?

De : Ryan Puddephatt [mailto:[hidden email]]
Envoyé : dimanche 28 septembre 2008 18:33
À : [hidden email]
Objet : [ops-users] XLS Generator

Hi all,

Ive made some modifications to the XLS generator processor, so it doesnt require an upload form and thought I would share it.

Alex/Erik,

It would be great if this could be put in the Orbeon code stream so it can be maintained internally

Thanks

Ryan

-----------------------------------------------

Ryan Puddephatt

FIX Developer

Fidessa LatentZero

1 Alfred Place

London WC1E 7EB

Office: +44 (0) 20 7462 4200

Direct: +44 (0) 20 7323 6112

Blackberry: +44 (0) 79 8539 2458

Fax: +44 (0) 20 7462 4242

Email: [hidden email]

Web: http://www.latentzero.com

_______________________________________________________________________
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.

_____________________________________________________________________
This e-mail has been scanned for viruses by Verizon Business Internet Managed Scanning Services - powered by MessageLabs. For further information visit http://www.mci.com

This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.

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

Ryan Puddephatt-3

RE: RE: XLS Generator

I changed it so it takes a config input, which is the URL of the file i.e.

</config>

This can be any url supported by the url-generator

Thanks

Ryan

-----------------------------------------------

Ryan Puddephatt

FIX Developer

Fidessa LatentZero

1 Alfred Place

London WC1E 7EB

Office: +44 (0) 20 7462 4200

Direct: +44 (0) 20 7323 6112

Blackberry: +44 (0) 79 8539 2458

Fax: +44 (0) 20 7462 4242

Email: [hidden email]

Web: http://www.latentzero.com

From: Bittard, Julien [mailto:[hidden email]]
Sent: 29 September 2008 08:46
To: [hidden email]
Subject: [ops-users] RE: XLS Generator

Hello,

What are the modification you made ?

De : Ryan Puddephatt [mailto:[hidden email]]
Envoyé : dimanche 28 septembre 2008 18:33
À : [hidden email]
Objet : [ops-users] XLS Generator

Hi all,

I’ve made some modifications to the XLS generator processor, so it doesn’t require an upload form and thought I would share it.

Alex/Erik,

It would be great if this could be put in the Orbeon code stream so it can be maintained internally

Thanks

Ryan

-----------------------------------------------

Ryan Puddephatt

FIX Developer

Fidessa LatentZero

1 Alfred Place

London WC1E 7EB

Office: +44 (0) 20 7462 4200

Direct: +44 (0) 20 7323 6112

Blackberry: +44 (0) 79 8539 2458

Fax: +44 (0) 20 7462 4242

Email: [hidden email]

Web: http://www.latentzero.com

_______________________________________________________________________
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.

_____________________________________________________________________
This e-mail has been scanned for viruses by Verizon Business Internet Managed Scanning Services - powered by MessageLabs. For further information visit http://www.mci.com

This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________

Alessandro Vernet

Re: XLS Generator

Administrator

In reply to this post by Ryan Puddephatt-3

Ryan,

On Sun, Sep 28, 2008 at 9:33 AM, Ryan Puddephatt
<[hidden email]> wrote:
> I've made some modifications to the XLS generator processor, so it
> doesn't require an upload form and thought I would share it.

Could you tell us more about this change? Looking quickly at the code, I
see that the config input is not declared. It would be good to update
the documentation for this. What about backward compatibility? If you
want, you can create a page on the Wiki for this, and copy what is
relevant from our existing documentation.

Alex
--
Orbeon Forms - Web 2.0 Forms, open-source, for the Enterprise
Orbeon's Blog: http://www.orbeon.com/blog/
Personal Blog: http://avernet.blogspot.com/
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

Ryan Puddephatt-3

RE: Re: XLS Generator

Alex,
I say it's a change, I think it would be considered more of a new processor. The config input takes xml similar to the URL generator

<config>
<url>path/to/file</url>
</config>

So it doesn't have to work form an upload form. Using an upload form you could provide the Url to the processor and get the same results, but it would break current implementations.

I had thought about improving it further so it could take a binary output from the URL generator (or any other source) and create the XML from that.

I also made a change to the XML output, but nothing too drastic

If you'd like I'll make the above changes and resubmit my code as a separate processor, then add the documentation to the wiki and orbeon site?

Thanks

Ryan

-----------------------------------------------
Ryan Puddephatt
FIX Developer
Fidessa LatentZero
1 Alfred Place
London WC1E 7EB
Office: +44 (0) 20 7462 4200
Direct: +44 (0) 20 7323 6112
Blackberry: +44 (0) 79 8539 2458
Fax: +44 (0) 20 7462 4242
Email: [hidden email]
Web: http://www.latentzero.com

-----Original Message-----
From: Alessandro Vernet [mailto:[hidden email]]
Sent: 02 October 2008 23:23
To: [hidden email]
Subject: [ops-users] Re: XLS Generator

Ryan,

On Sun, Sep 28, 2008 at 9:33 AM, Ryan Puddephatt <[hidden email]> wrote:
> I've made some modifications to the XLS generator processor, so
> it doesn't require an upload form and thought I would share it.

Could you tell us more about this change? Looking quickly at the code, I see that the config input is not declared. It would be good to update the documentation for this. What about backward compatibility? If you want, you can create a page on the Wiki for this, and copy what is relevant from our existing documentation.

Alex
--
Orbeon Forms - Web 2.0 Forms, open-source, for the Enterprise Orbeon's Blog: http://www.orbeon.com/blog/ Personal Blog: http://avernet.blogspot.com/ Twitter - http://twitter.com/avernet

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________

_______________________________________________________________________
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.

_____________________________________________________________________
This e-mail has been scanned for viruses by Verizon Business Internet Managed Scanning Services - powered by MessageLabs. For further information visit http://www.mci.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

Raholijaona, Cedric

Exporting Xform to PDF

Hi everyone,

I initially tried using Open Office export XForm to PDF. However, I faced issues with like the business rules did not exported correctly in PDF/FDF file.

Now I am evaluating Orbeon mainly with respect to the following features

1- Do the business rules written in Orbeon Form designer get translated correctly for PDF/FDF?
2- Does Orbeon Forms provide feature for digitally signing the PDF?
3- What are the other formats apart from PDF (e.g. HTML, BIB, TEX) provided by Orbeon?

Thank you for the response!

Regards

_________________________________________________________

Cédric Raholijaona / Capgemini I&D / Paris La Défense
Consultant en technologie & architecture / P&I / A&I
Com1: +33 6 18 71 52 93 / www.capgemini.com
Coeur défense - Tour A, la défense 4
110 esplanade du général de Gaulle
92231 Paris la défense cedex
Assistante : Djamila Zaid +33 1 49 67 48 99
Together. Free your energies
_________________________________________________________

Capgemini is a trading name used by the Capgemini Group of companies which includes Capgemini Industrie & Distribution, registered in Nanterre, France (RCS 479 766 842) whose registered office is Coeur Défense Tour A - La Défense 4 - 110, Esplanade du Général de Gaulle - 92931 PARIS LA DEFENSE Cedex.

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

Erik Bruchez

Re: Exporting Xform to PDF

Administrator

> I initially tried using Open Office export XForm to PDF. However, I
> faced issues with like the business rules did not exported correctly
> in PDF/FDF file.
>
> Now I am evaluating Orbeon mainly with respect to the following
> features
>
> 1- Do the business rules written in Orbeon Form designer get
> translated correctly for PDF/FDF?

No, the PDF output is read-only, so it doesn't need business rules.
For an example, go to:

http://www.orbeon.com/ops/forms/

Then select "View PDF". You will see that the resulting document is a
read-only document. What Orbeon Forms does in this example, and also
in Form Runner, is either:

* Produce a PDF automatically by doing a conversion of HTML+CSS to PDF
* Take a PDF template and overlay information, either by coordinates
or by filling-out Acrobat form fields

> 2- Does Orbeon Forms provide feature for digitally signing the PDF?

Not at the moment. It would be a good feature to support though.

> 3- What are the other formats apart from PDF (e.g. HTML, BIB, TEX)
> provided by Orbeon?

Out of the box, HTML. The data itself is available as XML, and can
easily be converted to CSV and such formats as well. We have also done
quite a lot of work to handle Word XML documents, in particular in
this open source project called IBD:

http://ibd.wiki.sourceforge.net/

I hope this helps,

-Erik

--
Orbeon Forms - Web Forms for the Enterprise Done the Right Way
http://www.orbeon.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

Alessandro Vernet

Re: RE: Re: XLS Generator

Administrator

In reply to this post by Ryan Puddephatt-3

Ryan,

On Fri, Oct 3, 2008 at 1:53 AM, Ryan Puddephatt
<[hidden email]> wrote:
> So it doesn't have to work form an upload form. Using an upload form you could provide the Url to the processor and get the same results, but it would break current implementations.
>
> I had thought about improving it further so it could take a binary output from the URL generator (or any other source) and create the XML from that.

What you did sounds like a good idea. My feeling is that we should (1)
keep the old code and make it available in a "legacy" processor (so
people relying on the old behavior don't have to change too much of
their code right away, and can just change the name of the processor in
their XPL) and (2) have your implementation be the "default" processor.

Does anyone here using the XLS Generator have an opinion about this?

Alex
--
Orbeon Forms - Web 2.0 Forms, open-source, for the Enterprise
Orbeon's Blog: http://www.orbeon.com/blog/
Personal Blog: http://avernet.blogspot.com/
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

Arun Batchu

Re: Exporting Xform to PDF

In reply to this post by Raholijaona, Cedric

Use libraries like itext to provide a pdf representation of your
content . Much easier and much reusable.

Thx via my iPhone ,
Arun 612-501-6345 [hidden email]

On Oct 3, 2008, at 5:02 AM, "Raholijaona, Cedric" <[hidden email]
> wrote:

> Hi everyone,
>
> I initially tried using Open Office export XForm to PDF. However, I
> faced issues with like the business rules did not exported correctly
> in PDF/FDF file.
>
> Now I am evaluating Orbeon mainly with respect to the following
> features
>
> 1- Do the business rules written in Orbeon Form designer get
> translated correctly for PDF/FDF?
> 2- Does Orbeon Forms provide feature for digitally signing the PDF?
> 3- What are the other formats apart from PDF (e.g. HTML, BIB, TEX)
> provided by Orbeon?
>
> Thank you for the response!
>
> Regards
>
> _________________________________________________________
>
> Cédric Raholijaona / Capgemini I&D / Paris La Défense
> Consultant en technologie & architecture / P&I / A&I
> Com1: +33 6 18 71 52 93 / www.capgemini.com
> Coeur défense - Tour A, la défense 4
> 110 esplanade du général de Gaulle
> 92231 Paris la défense cedex
> Assistante : Djamila Zaid +33 1 49 67 48 99
> Together. Free your energies
> _________________________________________________________
>
>
>
> Capgemini is a trading name used by the Capgemini Group of companies
> which includes Capgemini Industrie & Distribution, registered in
> Nanterre, France (RCS 479 766 842) whose registered office is Coeur
> Défense Tour A - La Défense 4 - 110, Esplanade du Général de
> Gaulle - 92931 PARIS LA DEFENSE Cedex.
>
>
> --
> 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