Printing to Excel using OIPI? (OpenInsight 32-Bit) [Revelation On-Line Wiki]

OpenInsight 32-Bit, John Bouley, Richard Bright, Bob Carten, Bruce Cameron, Richard Guise

Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

At 16 JUN 2004 11:43:18AM John Bouley wrote:

Is it possible to use OIPI to output a report to a CSV file? or does this involve custom programming to support this?

Thanks,

John

At 16 JUN 2004 05:05PM Richard Bright wrote:

John,

This feature has been flaged as in the forthcomming OIv7.1.

At 17 JUN 2004 10:24AM John Bouley wrote:

Thats all well and good but my customer needs the feature now.

I was hoping that there was some undocumented feature of OIPI that would allow me to save the data in a different format. Not just HTML, PDF, RTF.

Oh well, it will just cost them more money…

John

At 17 JUN 2004 03:23PM Bob Carten wrote:

John

An Rlist callback procedure is a good way to do this.

See RLIST_EQUATES

Bob

At 17 JUN 2004 04:43PM John Bouley wrote:

Bob,

If I understand this correctly, this only works for Rlist Reports not for custom reports where Set_printer is used?

I know that Slist already has a CSV output option but this doesn't help us for any "custom" programs. We currently have to modify the reports to OSWrite to a csv file to accomplish this.

Thanks,

John

At 17 JUN 2004 05:51PM Bob Carten wrote:

You are correct John.

BTW

Have you tried saving as HTML then just opening the result in Excel?

At 19 JUN 2004 03:23PM Bruce Cameron wrote:

John,

If you are in a bind I have something that may help you out.

I have an F5 Stacker utility and a standalone subroutine

that will create the file. My info is in the developers network section under Alternative Systems.

At 21 JUN 2004 02:00PM John Bouley wrote:

Thanks Bruce,

I think I have it working but what is a Stacker utility?

John

At 22 JUN 2004 01:37PM Richard Guise wrote:

The handling of multivalued data for reporting is, of course, quite different from handling it for export to CSV, Excel, etc. Arev had a sort of ASCII Exporter but I soon created my own.

This migrated to OI and was rebuilt about five years ago as a variant of my T-List Report Writer (which is a bit different from the RTI and Sprezz reporting facilities as it addresses rather different requirements).

I could probably package up the "T-Export" variant if this would get you out of a fix. If this is worth considering please email me at rg@tornadopropsys.co.uk.

Richard Guise

Tornado Property Systems Ltd.

View this thread on the Works forum...