Hi all,
Has anyone gone down the PDF route to print/email documents such as invoices
directly from U2.
I've seen lots of packages out there that allow dynamic pdf prints based on
data passed.
Some require a VB.net shell which reads the data file then builds the pdf
document.
As an example
Does anyone know if I can call a SQL stored procedure using the
SQLExecDirect command?
Thanks
Graham
Graham Forbes| Trading Systems | BT Global Services | Tel:+44 (0)20
7176| Mob:+44 (0)77407 38550 | Fax:+44 (0)20 7177 | E:
[EMAIL PROTECTED] | www.bt.com/globalservices
-Original
Andy,
its not the exact solution you describe but it may be simpler to use
from BASIC. We sell a native PDF generator for U2 (no shells, or
external programs just BASIC subroutines to call).
Have a look at www.cross.net.au/pdf.asp if you are interested.
regards,
Craig Bennett
---
Oh no - not again - no meeting in Sundbyberg, Sweden ! ;^)
-- mats
Results wrote:
George:
Full(er) details at http://www.Intl-Spectrum.com. Here's the list:
Cincinnati, OH
Sept. 25 - 26
Kings Island Resort
Sponsor: Ashwood Computer Services http://www.ashwoodcomputer.com/
Seattle,
Is this a limitation on I-types in SQL selects?
It would seem so based on your report. What does support have to say?
Has anyone come across this problem before and is there a work around?
I haven't, but I haven't tried large orderded SELECTs on four I-types.
Alternatively, can someone
I assumed a RetrieVe SELECT, which IS forbidden while a transaction is active.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Is this a limitation on I-types in SQL selects?
It would seem so based on your report. What does support have to say?
Seems like... VAR support is next port o' call.
Has anyone come across this problem before and is there a work
around?
I haven't, but I haven't tried
Yes, you can call a stored procedure using the SQLExecDirect function, provided
everything has been set up right (variables bound to the arguments and result
columns, etc.). Note that there are two syntaxes, one with curly braces, the
other with CALL. Your database may expect one or the other
Hey Andy - I have used the unix utils that convert a txt file to a
postscript (txt2ps) file and then a postscript to a pdf (ps2pdf) . These
where for fairly simply formatted text files. You can also run an xsl
against an xml (using xsltproc) to reformat it, and perhaps run one of the
above tools
Andrew
Check out mvPDF at www.brianleach.co.uk
This creates PDFs directly from U2 applications, using a number of potential
routes: in order of complexity -
- Capturing existing spool jobs and render as PDF (quick and simple)
- Capture and render exisiting prints against watermark pages
Stuart,
UniVerse SQL SELECT DISTINCT and RetrieVe SELECT ... SAVING UNIQUE ...
(which are semantically identical queries) need the UniVerse parameter
ALLOWMARKS=1 to work with medium-large queries. This parameter is set by
default = 0.
There is an enhancement request at IBM for documenting this
Many thanks.
Cheers,
Stuart
__
UniVerse SQL SELECT DISTINCT and RetrieVe SELECT ... SAVING UNIQUE
...
(which are semantically identical queries) need the UniVerse parameter
ALLOWMARKS=1 to work with
Take a look at PlanetPress Suite: http://www.objectiflune.com/ We've been
using it for a couple of years for forms and notice generation.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Andrew Lakeland
Sent: Wednesday, June 28, 2006 2:18 AM
To:
FYI, documentation says SELECT (RetrieVe), SELECT (SQL) and SSELECT are
valid to be executed during a transaction, this documentation for
10.1.11, I wonder if they fixed that in a recent release? Still curious
though why doing this during UO NET session would blow up, must be
calling another verb
I have a Purchase Order XML file that I need to load into UniData, the problem
is that it has 4 levels to it.
I can read it to the SVM level (3) with the extraction file, but what do I do
about level 4?
I tried using two extraction files, one for the 'Header' information. And one
for the
Andrew
We use the open source Apache Formatting Objects Processor, freely available
here: http://xmlgraphics.apache.org/fop/
Chris Reeves
Entrinsik, Inc.
919.848.4828 x114
[EMAIL PROTECTED]
http://www.entrinsik.com
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
We use Esker Software's VSI-FAX product. It has a setting that selects
TIFF or PDF formats when items are emailed. We typically pass all sorts of
things to it either as standard faxes or emails with pdf attachments. It's
been a very nice addition.
I wrote a BASIC program to monitor it that makes
The College for Creative Studies (CCS) in Detroit, Michigan is
currently
accepting applications for the position of Database
Administrator/Analyst.
Working in conjunction with the department director, this position
will
be responsible primarily for database administration of Datatel's
Colleague
Admittedly, the cheque testing centre seems to be hyper-critical. We've
had them fail cheques that clients have been sending to the banks
without issue for years.
Generally, we do the cheque here (preferably with samples of their
cheque stock - although some clients will only send photocopies).
I set up a document server ( web service ) for a customer that accepts
an xml doc that can be saved , emailed ( as body or attachment ) ,
faxed or printed.
It supports multiple output formats for saved / attached documents such
as - .pdf .htm .xls .rpt .rtf and can handle any combination of
Angelo
No, Unidata on Windows to SQL 2005. I haven't tried it yet, but when I
do I will post an example here.
Regards
Graham
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Angelo Collazo
Sent: Wednesday, June 28, 2006 2:50 PM
To:
Doesn't U2 XML support SAX or DOM access to the document? I'm sure I
remember reading something of that nature. IMHO, any direct XML parser that
limits itself to 3 levels of nodes is not worth the memory and disk it takes
to store it. :P Most of the live data formats I've worked with require
Does anyone have, or can you direct me to, a PCL command reference to
print barcodes? I need to print them on an HP laser.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Colin:
Your point is well made. :-)
Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, June 28, 2006 7:17 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] MICR fonts with UniData
[snipped]
I just wanted to
This information is 10 years old but you can give it a try:
STARTBC: \027)s0p8.1h12.0v0s0b0T\027)0Y\014\042
ENDBC: \042\015
SPACEBC: \044
A WIKI page appears to have current links to HPs documents:
http://en.wikipedia.org/wiki/Printer_Control_Language
You have a barcode font cartridge
Does anyone have, or can you direct me to, a PCL command reference to
print barcodes? I need to print them on an HP laser.
There is supposed to be a barcode font built into PCL 5 and up, but I could
never make it work on our printers.
I do have some UV code you can have that will print CODE39
if you need Code-128, There should be a subroutine where U2
files are stored. It works very niceley. By Dave Church.
If you need this, I can forward it to you. It will return the
PCL coding to produce the barcode for Code-128 (a,b and c
subsets).
George
-Original Message-
From: [EMAIL
if you need Code-128, There should be a subroutine where U2
files are stored. It works very niceley. By Dave Church.
If you need this, I can forward it to you. It will return the
I don't know about the original poster, but I'd like to see that.
Barry Brevik
---
u2-users mailing list
I thought this was in the U2 file section, but it's not.
Here is a link to get it.
http://www.carcarealert.com/CODE128.TXT
George
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Barry Brevik
Sent: Wednesday, June 28, 2006 1:31 PM
To:
I definitely used soft fonts since it was totally impossible to purchase
special font cartridges for all printers required
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, June 28, 2006 1:17 PM
To:
I updated the file just now to include the following code (shown as comments)
*
* GG: tHE FOLLOWING CODE WAS ADDED TO ALLOW PRINTING OF THE
* NEW POSTAL CODE-128 BARCODES. sO THE START CHARACTER
* WILL BE PRINTED.
*
! IF (CODE.FLD = CODEC) THEN
! POS = 103
! GOSUB
I would get a plug-in module (hardware) from HP.
--Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Ray Buchner
Sent: Wednesday, June 28, 2006 12:04 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Barcode PCL Commands
Does anyone have, or can you
Hi,
I have a multi-value attribute that's made up of free text remarks.
However, we put a couple of system messages there as well. I need to
extract the 6 digit number that follows the COMBO YS in the line
below, but I'm having trouble setting up the conversion code in the
dictionary.
Hi Pamela,
Personally, I would setup a SUBR type dict and then just do a loop:
SUBROUTINE SUB.GET.NBR(RETURN.VALUE, DATA.ITEM)
C = DCOUNT(DATA.ITEM,@VM)
RETURN.VALUE =
FOR I = 1 TO C
IF DATA.ITEM1,I[1,8] = COMBO YS THEN
RETURN.VALUE = FIELD(DATA.ITEM1,I,' ',3)
RETURN
END
NEXT I
FIELDS(ATTNAME,REUSE(YS ),2) or is it FIELDS(REUSE(YS),2,ATTNAME)
I forget which format is used in the DICT I desc. I haven't tested
this. I believe the REUSE needs to be there...
George
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
Pamela J
This will print Code 39 / Code 128 with a PCL printer in GL/2 mode. I can
supply the files if you need them.
Also forces the required quiet zones flanking the bar code.
HPBARS39
001 SUBROUTINE HPBARS39(X,Y,HEIGHT,STRING,WIDTH,RATIO)
002 OPEN BARS39 TO BARS39 ELSE RETURN
003 PRINT TR0;
004 IF
I'm interested in the NJ meeting.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of u2ug
Sent: Tuesday, June 27, 2006 12:09 PM
To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED]
Subject: [U2] A Generous Offer
All,
We need your feedback. I just received
If I'm in town, I will attend the meeting. Not sure, I might taking
a floating class that week.
George
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
Burwell, Edward
Sent: Wednesday, June 28, 2006 3:31 PM
To: 'u2-users@listserver.u2ug.org'
Subject:
Is there any other number in there? If not, why not simply use the
MCN conversion?
-Kevin
[EMAIL PROTECTED]
http://www.PrecisOnline.com
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Pamela J
Robbins
Sent: Wednesday, June 28, 2006 1:01 PM
To:
I would do it in a subroutine called from an I Type.
1: I
2: SUBR('GET.NUMBER',fieldname)
...
The subroutine could walk the values of the field and find the COMBO YS
and pick off the number.
SUBROUTINE GET.NUMBER(ANS,FIELDNAME)
ANS = ''
VM.CNT = DCOUNT(FIELDNAME,@VM)
FOR I = 1 TO VM.CNT
The xml parser handles any number of levels - it is when you want to map
that data back into a record, we are limited to attributes, values and
subvalues.
I have used the approach you mention of having two EXT files to solve this
and have had it working fine. If you are not getting seperate
No luck...
I looked at the dictionary for all of the entries with 'MD1'. Most of them
had an S in field eight.
I changed the S to a blank character for all of these and then, following
Debster's comment, did a CD.
Further suggestions would be appreciated.
Regards,
--Bill
-Original
Under very specific scenarios, something like this should work. But if
the string 'COMBO YS' exists more then once, it will only retrieve the
first value. And the syntax must be very consistent.
1 I
2 INDEX(@RECORD999,COMBO YS,1);IF @1 0 THEN
@RECORD999[EMAIL PROTECTED]9,6] ELSE
Good
From the docs : if delimiter evaluates to more than one character, the
first character is used.
1 reuse is not required.
2 fields works on FM delimited data so should be
lower(FIELDS(raise(ATTNAME),YS ,2))
3 this won't work either way as the delimiter will be Y not COMBO YS
-Original
I learned how to float in boot camp.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of George Gallen
Sent: Wednesday, June 28, 2006 3:48 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] A Generous Offer
If I'm in town, I will attend the meeting. Not
This would be Boat camp...
It's a 4-day continuing education seminar being held on a cruise ship,
go to class in the morning, and have fun in the late afternoon/evening
andit's tax deductable.
The cost isn't much more than a traditional hotel.
George
-Original Message-
From:
Oh dude... Where do I sign up??
-Kevin
[EMAIL PROTECTED]
http://www.PrecisOnline.com
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of George Gallen
Sent: Wednesday, June 28, 2006 2:47 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] A Generous
Arthur,
I have a Purchase Order XML file that I need to load into UniData, the
problem is that it has 4 levels to it.
I can read it to the SVM level (3) with the extraction file, but what do I do
about level 4?
I tried using two extraction files, one for the 'Header' information. And one
Under very specific scenarios, something like this should work. But
if
the string 'COMBO YS' exists more then once, it will only retrieve
the
first value. And the syntax must be very consistent.
1 I
2 INDEX(@RECORD 999,COMBO YS,1);IF @1 0 THEN
@RECORD 999[EMAIL
49 matches
Mail list logo