× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Hi Dan
using the following procedure (this works for portrait - not for landscape)
Add AFP Printer driver to your PC

Go to ‘Start’, ‘Settings’, ‘Printer and Faxes’,
Click ‘Add a Printer’ (follow the wizard)
Select ‘Local printer attached to this computer’
Select ‘FILE: (Print to file)’ for ‘Use the following Port’
Choose ‘IBM’ and ‘IBM Infoprint 20 AFP’
Continue to click ‘Next’, accepting the defaults until you can click
‘Finish’

Saving .XLS document as an overlay document

Open .xls document
Select ‘File’, ‘Print’
Choose ‘IBM Infoprint 20 AFP’ from the dropdown
Check box ‘Print to File’
Click on ‘Properties’ to the right of printer name
Select ‘Overlay’ from the dropdown box under ‘Output Type’

Click ‘OK’ to close ‘…Advanced Properties…’
Click ‘OK’ again to accept all changes
Input ‘Output file name’ (include entire path)


Your file is ready to be imported to the AS400







Creating an Overlay

Login to iSeries Navigator
Expand the IP address of the system you would like to create the overlay
Follow the path below:



Right click on ‘Overlay’ and select ‘Import’
The following screen appears:



‘Browse’ to the location of the Overlay
Enter in the ‘Resource Name’ (8 character name for overlay)
Enter in the ‘Library Name’ to save the Overlay
Add a ‘Description’
Choose ‘Object Authority’
Keep the default ‘Data Type’ as ‘AFPDS’
Click ‘OK’ – Overlay is now located in the LIB you specified above



Alan Shore
Programmer/Analyst, Distribution
E:AShore@xxxxxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill



"Dan Kimmel"
<dkimmel@rjssoftw
are.com> To
Sent by: "Midrange Systems Technical
midrange-l-bounce Discussion"
s@xxxxxxxxxxxx <midrange-l@xxxxxxxxxxxx>
cc

12/04/2008 02:06 Subject
PM RE: Lets Talk about Overlays


Please respond to
Midrange Systems
Technical
Discussion
<midrange-l@midra
nge.com>







You don't need AFP. AFP Workbench is a PC tool that comes packed in Ops
Nav (iNav, whatever). You can (and obviously are) applying an overlay to
an SCS file. However you approach it, you are creating a *OVL object.
Then you apply the overlay object to the spool file through a print file
or overriding a print file. How are you moving the spreadsheet to your
i?

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Shore
Sent: Thursday, December 04, 2008 11:05 AM
To: Midrange Systems Technical Discussion
Subject: RE: Lets Talk about Overlays

Thanks for your reply Dan
however, there's the kicker
we don't have AFP on our system
I'm hoping that the PTF that Jim Franz mentioned
(SF99347 PRINT GROUP PTF FOR V5R4M0)
will rectify the problem



Alan Shore
Programmer/Analyst, Distribution
E:AShore@xxxxxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill

midrange-l-bounces@xxxxxxxxxxxx wrote on 12/04/2008 11:51:12 AM:


I assume you're "printing" the spreadsheet to the printer driver in
AFP Workbench and specifying *OVL as the type.

Use the AFP Workbench tools to rotate the image. Open the .ovl file
with AFP Workbench, rotate it, and save. I'm quoting this from memory,

I can't try it right now.


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Shore
Sent: Thursday, December 04, 2008 10:17 AM
To: Midrange Systems Technical Discussion
Subject: RE: Lets Talk about Overlays

Thanks for your reply Dan
I know I haven't had my 16th cup of coffee yet, but I'm not following
your directions (forgive me, the moron gene in me is quite strong) I
have created the overlay in landscape (in Microsoft Excel 2002, Page
Setup, Page Tab, choose landscape) How do you rotate it back to
portrait?



Alan Shore
Programmer/Analyst, Distribution
E:AShore@xxxxxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill

midrange-l-bounces@xxxxxxxxxxxx wrote on 12/04/2008 10:41:07 AM:

Alan,

You need to produce the overlay in landscape then rotate it back to
portrait before you save it to the i.

Your print file specs below will invoke COPRR (computer output print

reduction rotation). The i print drivers rotate the printed image
and THEN apply the overlay. So your overlay needs to be in portrait
with the text running up and down the length of the page sideways on

8.5 x
11 (or
A2) paper. If you find the job log for the print job, I think you'll

find that the overlay doesn't match the page dimensions.

Dan

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Shore
Sent: Thursday, December 04, 2008 9:20 AM
To: Midrange Systems Technical Discussion
Subject: Re: Lets Talk about Overlays

Hi James
here is my CL
PGM PARM(&PBNUMX)
DCL VAR(&PBNUMX) TYPE(*CHAR) LEN(7)
DCL VAR(&PBNUM) TYPE(*DEC) LEN(7 0)
CHGVAR VAR(&PBNUM) VALUE(&PBNUMX)
OVRPRTF FILE(PCKLIST) DEVTYPE(*AFPDS) PAGESIZE(60 +
132) LPI(8) CPI(15) PAGRTT(90) +
OUTQ(WPVLSR1) COPIES(1) SAVE(*YES) +
OVRSCOPE(*JOB) +
FRONTOVL(AXSLIB/OVERLAY3)
CALL PGM(ORD220EE) PARM(&PBNUM)
ENDPGM

The report from the above CL prints as the FRONTOVL overlay is
portrait

Here is the CL that doesnt print
PGM PARM(&PBNUMX)
DCL VAR(&PBNUMX) TYPE(*CHAR) LEN(7)
DCL VAR(&PBNUM) TYPE(*DEC) LEN(7 0)
CHGVAR VAR(&PBNUM) VALUE(&PBNUMX)
OVRPRTF FILE(PCKLIST) DEVTYPE(*AFPDS) PAGESIZE(60 +
132) LPI(8) CPI(15) PAGRTT(90) +
OUTQ(WPVLSR1) COPIES(1) SAVE(*YES) +
OVRSCOPE(*JOB) +
FRONTOVL(AXSLIB/OVERLAY4)
CALL PGM(ORD220EE) PARM(&PBNUM)
ENDPGM

The OVERLAY4 is the same as OVERLAY3 except 4 is in landscape format

and
3 is in portrait format



Alan Shore
Programmer/Analyst, Distribution
E:AShore@xxxxxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill
midrange-l-bounces@xxxxxxxxxxxx wrote on 12/04/2008 10:06:37 AM:

Please include the OVRPRTF command as well as the device
description

that you are printing to, this will help in figuring this out.

Also include the "regular" atrributes of the printfile like the
length

& width, CPI & LPI if they aren't specified in the OVRPRTF.

Thanks.
James Salter
Systems Programmer
American Cast Iron Pipe Company
phone (205) 325-3033
fax (205) 307-3833



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

message: 7
date: Thu, 4 Dec 2008 09:48:12 -0500
from: Alan Shore <AlanShore@xxxxxxxx>
subject: Re: Lets Talk about Overlays

Hi James
thanks for your reply
It looks like I didn't explain my predicament clearly My program
produces a report in landscape format, which I can print.
I have created an overlay (via Microsoft Excel 2002),
unfortunately in

portrait format.
This was uploaded to the AS/400 via a certain procedure.
The same program was run with the same data, this time applying my

overlay in the OVRPRTF command This report was then printed to the

same printer.
This is where I realized the mistake I made where the overlay was
in

the wrong format.
I recreated the overlay (again using Microsoft 2002) this time in
landscape format.
I uploaded the new version (as a different name) to the AS/400,
re-ran

the same program with the same data applying the new overlay in
the OVRPRTF.
I cannot get the new spool file to print to the same printer, no
matter what I try. The status goes to PND.
If anyone can point out what I am doing wrong, it would be much
appreciated

Thanks in advance



Alan Shore
Programmer/Analyst, Distribution
E:AShore@xxxxxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill

midrange-l-bounces@xxxxxxxxxxxx wrote on 12/03/2008 05:56:14 PM:

_________Confidentiality Notice_______________________ This e-mail

and

any files transmitted with it is confidential and is intended
solely

for the use of the individual(s) or entity(ies) to whom this
e-mail is

addressed. If you are not the intended recipient or the person
responsible for delivering the e-mail to the intended recipient,
be advised that you have received this e-mail in error, and that
any use,

disclosure, dissemination, forwarding, printing, retention or
copying of this e-mail is strictly prohibited. If you have
received

this e-mail in error, please immediately return this e-mail to the

sender and delete the e-mail from your system.
Thank you.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please
take a moment to review the archives at
http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing

list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please
take a moment to review the archives at
http://archive.midrange.com/midrange-l.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please
take a moment to review the archives at
http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l..



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l..


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.