Okay
I revisited the creation of the spreadsheet from Excel, by saving the
spreadsheet, AFTER I had resized the cells to adjust to 100% of actual
size.
I printed this spreadsheet and confirmed that it DID in fact fit on one
legal size paper in landscape format
Saved the spreadsheet as an overlay
Imported it into the AS/400
Printed using the new overlay
LARGE EXASPERATED SIGH, followed by the excruciating wailings of a banshee
NO @#$%^&*() GO
I then remembered I had the same spreadsheet but in letter sized
(landscape)
Using the same procedures as above, I printed the report using the letter
size overlay
It prints (overlay smaller than I want) - thus confirming that the legal
size overlay is somehow larger than the legal size paper
I then used the letter sized spreadsheet and created a new legal sized
overlay
blah blah blah
LARGE EXASPERATED SIGH, followed by the excruciating wailings of a banshee
NO @#$%^&*() GO
Thank god there are no windows in this building for me to jump out of
Not that it would do me any good, after all we ARE on the ground floor
Again - if anyone has nay suggestions, ideas, thoughts pints of beer, shots
of gin
It would be MUCH appreciated
Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill
__________________
Thanks for your reply Dan
I'll give Generic IBM 300dpi AFP a try as well
What you said about "The message you get usually means you're trying to
print something
beyond the page limits. Usually that's the overlay."
got me to thinking.
I created the spreadsheet in Excel, and printed it from Excel to ensure
that it would in fact ONLY be one page. The print was successful, HOWEVER,
I saved the spreadsheet by choosing "to fit to 1 page wide by 1 page tall
in the page setup property"
I am now wondering if this is what is causing my problem
I have to clear some other things out of the way, but I am going to attack
my problem from that direction.
I'll keep you all informed of the outcome
Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
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/03/2009 06:03 Subject
PM RE: CPF6DF2 error
Please respond to
Midrange Systems
Technical
Discussion
<midrange-l@midra
nge.com>
I use Generic IBM 300dpi AFP. On advanced settings, Paper Size:Legal,
Orientation:Landscape, Output Type:Overlay, Inline Form Definition:On,
ClipLimits:<Default>, Image Options: <Default, but make sure Color
Option is Black / White>, Print Text as Graphics:On.
The message you get usually means you're trying to print something
beyond the page limits. Usually that's the overlay. Check in your
OVRPRTF for something about the origin of the overlay. I vaguely
remember that has to be set to something in y,x coordinates instead of
x,y since you've changed the PAGRTT.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Shore
Sent: Thursday, December 03, 2009 3:05 PM
To: Midrange Systems Technical Discussion
Cc: Midrange Systems Technical Discussion;
midrange-l-bounces@xxxxxxxxxxxx
Subject: RE: CPF6DF2 error
Thanks for your reply Dan
I agree - this IS complicated (and exasperating, and mind-numbing etc.)
This project has turned out to be a real albatross around my neck The
reason why I "didnt give enough information"
I wasnt too sure what was required and if I started to write what I
thought was required, too many people would have been switching off
I do realize that the PAGRTT doesnt rotate the overlay - only the data
on the page, but you may be onto something about doing something special
to the overlay so that it would be as landscape.
I created the overlay in excel, to fit a legal paper, in landscape
format, then used a procedure to create an overlay from this.
More and more it looks like that procedure may be incorrect for this
type of overlay
Here is the procedure that I use to create an overlay - I deleted the
couple of screen captures so that (hopefully) this e-mail will go
through 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 Paper Size
Select Orientation
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
Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
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/03/2009 02:41
Subject
PM RE: CPF6DF2 error
Please respond to
Midrange Systems
Technical
Discussion
<midrange-l@midra
nge.com>
Alan,
I'm afraid no one responded because it's complicated and you didn't give
enough information about your setup to determine the way to go.
From the information you've given now, we can see you're using HPT to a
remote printer with AFPDS. Congratulations on finding the combination
that gets it rotated at the right resolution.
Now you're going to have to rotate the overlay. The error you're getting
now says the overlay doesn't fit on the page. Your overlay is probably
8.5 x 14 while your page length now is only 8.5 as rotation made the
width the length. You're going to have to scan an overlay at 14 x 8.5.
In other words PAGRTT doesn't rotate the overlay. This is particularly
true with HPT. I think some of the drivers for AFP printers might do it,
but not HPT.
Dan Kimmel
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Shore
Sent: Thursday, December 03, 2009 12:44 PM
To: Midrange Systems Technical Discussion
Subject: CPF6DF2 error
Hi guys
unfortunately, it seems that nobody else has had this problem, but I
have persevered.
I started from scratch, changing my OVRPRTF command on the LPI,CPI one
parameter at a time until I eventually arrived at the following
OVRPRTF FILE(PICKLGL) DEVTYPE(*AFPDS) PAGESIZE(8.5 +
14 *UOM) LPI(8) CPI(16.7) FRONTMGN(.7 +
1.0) PAGRTT(90) +
OUTQ(RMTIBM) SAVE(*YES)
This produced data printed on legal size paper, landscape format that
looked close to where I want the data to print
I then changed the above to include my overlay
OVRPRTF FILE(PICKLGL) DEVTYPE(*AFPDS) PAGESIZE(8.5 +
14 *UOM) LPI(8) CPI(16.7) FRONTMGN(.7 +
1.0) PAGRTT(90) FRONTOVL(AXSLIB/PICKLGL5) +
OUTQ(RMTIBM) SAVE(*YES)
which resulted in the report NOT printing, and the error messages
AFP data stream in user space not valid.
Error occurred while transforming data.
Send request failed for spooled file PICKLGL.
Obviously the culprit is the overlay. The question What in the overlay
is causing this problem, and how can it be rectified?
Again, if anyone has any ideas, help or guidance, it is always MUCH
appreciated
Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill
__________________
Hi guys
I'm having a problem with attempting to print to legal size paper in
landscape mode The result is that instead of printing the full 14 inches
width, I can only print up to 11 inches wide no matter what I do with
CPI etc on the ovrprtf command Investigating the problem shows that I
get the error message CPF6DF2 which translates to AFP data stream in
user space not valid.
Now I've googled CPF6DF2, and the answers I obtain don't help me to
determine the cause of this problem.
I was wondering if anyone else had encountered this message id and how
they rectified it
As always, any help and/.or guidance is MUCH appreciated
Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill
--
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.