× 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.





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.

This thread ...

Follow-Ups:

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.