I spotted that openpcl just yesterday (my google skills have never been great, but I'm sure I've never seen it come up before when searching for USERASCII help!) and on their webpage they have an example PCL file to download. It doesn't look anything like my intermediary files that become spooled files so I guess I was mistaken when I said it was PCL. My intermediary file looks a little like PostScript but contains headers that mention PCL so I guess that is what confused me.
We start with a Word document as a template, replacing bookmarks in it with relevant data using a VB program. Then it is printed to an IFS stream file using a postscript HPLJ printer driver (I just remembered this part!) Then it is opened by an RPGLE program and "printed" line by line to a PRTF object which creates the spooled file. The end result is a spooled file, of type *USERASCII, that seemingly can not be read/manipulated in anyway as far as I can work out (CPYSPLF, etc., refuse to work with it). My "solution" at the moment looks to be keeping a copy of the intermediary word document on the IFS somewhere and opening that instead of the spooled file. This system has been around for 15-20 years, only amended once recently when the original VB program couldn't be run on a modern operating system. I am begging management to let me find a brand new solution that doesn't involve VB or *USERASCII spooled files, but it's not looking promising.
If anyone can think of a way that I can get at the (apparently binary) data within the *USERASCII spooled files then maybe I can construct a tool that Frank can incorporate into iSphere.
-Paul.
-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Frank Hildebrandt
Sent: 02 April 2014 17:59
To: 'Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries'
Subject: Re: [WDSCI-L] iSphere's source search
@ Paul
You write you are using *USERASCII spooled files which contain PCL commands.
Here is a link for a open source tool which makes it possible to display PCL based files.
http://openpcl.sourceforge.net/
You could try to display your PCL file created on your PC with this tool. If it works we could embed OpenPCL into iSphere.
Frank
-----Ursprüngliche Nachricht-----
Von: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx] Im Auftrag von Paul Bailey
Gesendet: Montag, 3. Februar 2014 13:31
An: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries
Betreff: Re: [WDSCI-L] iSphere's source search
Thanks Frank. I've upgraded both the client and server side to v1.4 and I am happy to report that the excel export for the search results works fine for me. (Fingers are crossed for the "create member filter..." option in the near future.) One thing: In the exported excel file, is it too much trouble to get the source member description? It would be useful, but not essential.
I also tried out the spooled file viewer, and viewing plain spooled files works great (seems to be quicker than other methods, too!), but we have a ridiculous system here where a windows machine "prints" a word document as a postscript file (or maybe it is a PCL file) which is copied to a stream file on the IFS which is then read and printed line by line to a *USERASCII spooled file (thanks Scott Klement... I think), and those spooled files are not viewable in your system. This isn't a huge problem, as they are not viewable from the OUTQ either, but I was hoping against hope that the option was now available. Do you think this is just a matter of writing my own conversion routine, or is it just an impossibility to view some kinds of spooled files?
-Paul.
-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Frank Hildebrandt
Sent: 03 February 2014 11:16
To: 'Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries'
Subject: Re: [WDSCI-L] iSphere's source search
@ Paul
With the new iSphere Version 1.4.0 it is now possible to export the search results to Excel. The "Create member filter from the search results" stuff will be realized later.
Frank
-----Ursprüngliche Nachricht-----
Von: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx] Im Auftrag von Paul Bailey
Gesendet: Freitag, 29. November 2013 10:26
An: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries
Betreff: [WDSCI-L] iSphere's source search
Hi Frank,
I've been using iSphere for a while and I like some of the additional functionality, and the speedier source search is nice. However, I've wanted a feature in both the iSphere and original RDi source search view for ages
(
http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=33694)
.
I want the ability to create a member filter (or object filter) from the results of a source search. I would also like the ability to export the search results to text file (or CSV) with and without the found source lines included.
Can this be done in iSphere?
-Paul.
PS If anyone wants to know how to create a member filter in RDi/RDp/WDSC using a combination of FNDSTRPDM, windows clipboard, Excel and Notepad, then let me know and I'll write something. It isn't the safest or easiest method, but it's the only way I've found.
-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Frank Hildebrandt
Sent: 28 November 2013 16:18
To: 'Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries'
Subject: Re: [WDSCI-L] WRKBNDDIR plugin for RDi?
Isaac,
iSphere already contains a binding directory editor. You can download iSphere here.
http://www.taskforce-it.de/downloads.php
Frank
-----Ursprüngliche Nachricht-----
Von: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx] Im Auftrag von Isaac Ramirez
Gesendet: Donnerstag, 28. November 2013 16:17
An: wdsci-l@xxxxxxxxxxxx
Betreff: [WDSCI-L] WRKBNDDIR plugin for RDi?
Hi everyone.
Does anyone knows of any free plugin for working with binder directories from RDi, with all the functionality of the wrkbnddir command? I'm planning to create a plugin for this, but I don't want to re-invent the wheel...
Thanks!
Isaac Ramirez
--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list To post a message
email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list To post a message
email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
Scanned by MailDefender - managed email security from intY - www.maildefender.net
Important, this email transmission and any files with it are strictly confidential to the intended recipient and may be legally privileged. Any views or opinions presented are solely those of the author and do not necessarily represent those of BHSF. If you are not the intended recipient, you must not copy, disclose or distribute its contents in any way. If you have received this e-mail in error, please notify the sender and delete the e-mail from your system.
We have taken steps to ensure this email and attachments are free from any virus but do not accept any responsibility once this e-mail has been transmitted. You should scan any attachments for viruses. No contract may be concluded on behalf of BHSF Limited by e-mail.
Registered Office: BHSF Limited, Gamgee House, 2 Darnley Road, Birmingham,
B16 8TE. www.bhsf.co.uk Registered in England number 35500. BHSF is authorised and regulated by the Financial Services Authority.
--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list To post a message
email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list To post a message
email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
Scanned by MailDefender - managed email security from intY - www.maildefender.net
Important, this email transmission and any files with it are strictly confidential to the intended recipient and may be legally privileged. Any views or opinions presented are solely those of the author and do not necessarily represent those of BHSF. If you are not the intended recipient, you must not copy, disclose or distribute its contents in any way. If you have received this e-mail in error, please notify the sender and delete the e-mail from your system.
We have taken steps to ensure this email and attachments are free from any virus but do not accept any responsibility once this e-mail has been transmitted. You should scan any attachments for viruses. No contract may be concluded on behalf of BHSF Limited by e-mail.
Registered Office: BHSF Limited, Gamgee House, 2 Darnley Road, Birmingham,
B16 8TE. www.bhsf.co.uk Registered in England number 35500. BHSF Limited is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and Prudential Regulation Authority.
--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
Scanned by MailDefender - managed email security from intY - www.maildefender.net
Important, this email transmission and any files with it are strictly confidential to the intended recipient and may be legally privileged. Any views or opinions presented are solely those of the author and do not necessarily represent those of BHSF. If you are not the intended recipient, you must not copy, disclose or distribute its contents in any way. If you have received this e-mail in error, please notify the sender and delete the e-mail from your system.
We have taken steps to ensure this email and attachments are free from any virus but do not accept any responsibility once this e-mail has been transmitted. You should scan any attachments for viruses. No contract may be concluded on behalf of BHSF Limited by e-mail.
Registered Office: BHSF Limited, Gamgee House, 2 Darnley Road, Birmingham, B16 8TE. www.bhsf.co.uk Registered in England number 35500. BHSF Limited is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and Prudential Regulation Authority.
midrange.com
