|
banshee
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
shots
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,
of ginHOWEVER,
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,
I saved the spreadsheet by choosing "to fit to 1 page wide by 1 pageattack
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
my problem from that direction.list
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 toremote printer with AFPDS. Congratulations on finding the combination
a
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
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,list
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
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 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.