RE: [U2] Printing Graphics from UniVerse

2008-12-01 Thread John Hester
> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Adam Taylor
> Sent: Monday, December 01, 2008 1:50 PM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Printing Graphics from UniVerse
> 
> Hey folks,
> 
> 
> 
> I've got a multi-part question.  Does anyone have a good method of
> printing graphics from UV programs other than the 2-bit black 
> and white?
> We'd like to expand into color logos on some of our document 
> and wanted
> to know if anyone had come up with a method of including those on
> reports/invoices/etc.  As well, does anyone have a good method of
> "printing" graphics and reports to file instead of to hardcopy?
> Obviously we can print straight text to the &HOLD& file, but we'd also
> like to include graphics in some documents we print to file.

There is a free, open-source tool named pdftk (pdf toolkit) that will
let you do this in conjunction with Adobe Acrobat Pro.  I just finished
a project to do something similar last month.  We're sending the output
to a laser printer, but there's actually one less step involved if you
just want to store the file as a pdf on disk.  I haven't experimented
with color, but I don't think that would be a problem.  We're just
printing a 1 or 2 page packing list, however.  I think a multi-page
report might be possible, but probably not via this exact process.  This
is our process:

1) Design a form in the latest version of Adobe Acrobat Pro and create
form fields where your variable UV data will go.  Be sure to leave the
"allow rich text formatting" box unchecked.  You'll probably also want
to remove the borders.

2) Enter some character in each field that will never appear in your
actual data (I used "~").  You need to do this because Acrobat won't
export xml definitions for empty fields, and it makes filling in the
fields with data much easier.

3) Save your pdf, then export your field data and definitions as an xfdf
file.  The latter is an xml representation of the variable data that
will go in your form.  Save the files somewhere where you can access
them as records in a UV type 19 file.

4) Write a program to make a copy of the xfdf file, replacing the "~"
(or whatever placeholder you used) with your data.  My method for doing
this is to initially parse the xml field names into a dynamic array,
assign a corresponding value array using LOCATE, then READSEQ each line
of the original xml line replacing "~" with the associated field value.

5) EXECUTE the pdftk command to merge your new xfdf file back into your
form:

pdftk originalForm.pdf fill_form newData.xfdf output newForm.pdf flatten

When you view the merged pdf document in Acrobat reader, you'll see your
UV data inserted where the placeholder characters used to be.

The pdftk software is available for download here:

http://www.accesspdf.com/article.php/20041130153545577 (Windows, Debian,
Suse)
http://rpm.pbone.net/index.php3 (most other linux distros)


If you want to go one step further and send the pdf to a printer, you
can use the linux pdf2ps command to convert your pdf to a postscript
file which can be sent directly to a postscript laser printer.  I think
pdf2ps is included in most linux distros.

-John
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Printing Graphics from UniVerse

2008-12-01 Thread wagnersm
Adam

Take a look at the printer documentation.  I remember seeing in HP's PCL5 
documentation that you can upload a raster graphic like a TIFF from a computer 
into the printer memory, and then print it using esc sequences.  

Steve

-Original Message-
>From: Adam Taylor <[EMAIL PROTECTED]>
>Sent: Dec 1, 2008 4:50 PM
>To: u2-users@listserver.u2ug.org
>Subject: [U2] Printing Graphics from UniVerse
>
>Hey folks,
>
>
>
>I've got a multi-part question.  Does anyone have a good method of
>printing graphics from UV programs other than the 2-bit black and white?
>We'd like to expand into color logos on some of our document and wanted
>to know if anyone had come up with a method of including those on
>reports/invoices/etc.  As well, does anyone have a good method of
>"printing" graphics and reports to file instead of to hardcopy?
>Obviously we can print straight text to the &HOLD& file, but we'd also
>like to include graphics in some documents we print to file.
>
>
>
>Thanks.
>
>
>
>Adam Taylor
>
>Sr. Programmer Analyst
>
>INX Inc.
>
>6401 Southwest Freeway
>
>Houston,  Texas  77074
>
>Phone: 713/795-2352
>
>[EMAIL PROTECTED]
>---
>u2-users mailing list
>u2-users@listserver.u2ug.org
>To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Printing Graphics from UniVerse

2008-12-01 Thread Tony G
Agreed.  I can provide some a couple BASIC code examples that
show how to get PrintWizard to position text, draw boxes, add
color, position and size images, draw lines anywhere on the page,
and position barcodes.  One of the examples shows a multi-page
timesheet with data positioned in an overlay, along with a FAX
coversheet.  PrintWizard takes this direct from the spooler and
faxes it to number provided in the code.  The same output can be
sent to PDF and emailed if desired.  "Cool" is an understatement.

HTH
Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com
Nebula R&D sells mv.NET and other Pick/MultiValue products
worldwide, and provides related development and training services


> From: Ken Hall
> Check out Print Wizard from Rasmussen Software 
> http://www.anzio.com/ It is a great way to add 
> graphics to your printed output and to print to file 
> as either text or pdf.

Adam wrote:
> Does anyone have a good method of printing graphics...
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Universe triggers (still more)

2008-12-01 Thread Boydell, Stuart
Setdiagnostics is a function which works by adding an error condition
message into the SQL error stack. A trigger program comes from the SQL
side of UV and runs within a transaction boundary, when the
setdiagnostics() function is used it will cause the trigger to go into
rollback mode on return from the trigger program.

See the UniVerse BCI Guide Chap 7 for syntax...

subroutine TRG.CUST.DELETE(...)
open "AR.TRANS" to fvar then
readu rec from fvar,oldnum then
junk = setdiagnostics("Open receivables exist for
customer ":oldnum:". Clear transactions before deleting this customer.")
end else
  gosub DeleteCustomer:
end
end
return

>-Original Message-
>The manual seems to suggest
>that I could use SetDiagnostic to fail this . but I'm not even getting
my
>program to compile and can't find further information on the syntax of
that
>command.  Anyone know how to tell the trigger to refuse the write?


 
**
This email message and any files transmitted with it are confidential and 
intended solely for the use of addressed recipient(s). If you have received 
this communication in error, please reply to this e-mail to notify the sender 
of its incorrect delivery and then delete it and your reply.  It is your 
responsibility to check this email and any attachments for viruses and defects 
before opening or sending them on. Spotless collects information about you to 
provide and market our services. For information about use, disclosure and 
access, see our privacy policy at http://www.spotless.com.au 
Please consider our environment before printing this email. 
** 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Printing Graphics from UniVerse

2008-12-01 Thread Brian Leach
Hi Adam

Take a look at mvpdf - it offers a range of ways to create documents, has a 
drawing API and despite the name also supports drect printing.

Eval available on www.brianleach.co.uk

Regards

Brian

-Original Message-
From: Adam Taylor <[EMAIL PROTECTED]>
Sent: 01 December 2008 21:50
To: u2-users@listserver.u2ug.org
Subject: [U2] Printing Graphics from UniVerse

Hey folks,



I've got a multi-part question.  Does anyone have a good method of
printing graphics from UV programs other than the 2-bit black and white?
We'd like to expand into color logos on some of our document and wanted
to know if anyone had come up with a method of including those on
reports/invoices/etc.  As well, does anyone have a good method of
"printing" graphics and reports to file instead of to hardcopy?
Obviously we can print straight text to the &HOLD& file, but we'd also
like to include graphics in some documents we print to file.



Thanks.



Adam Taylor

Sr. Programmer Analyst

INX Inc.

6401 Southwest Freeway


[The entire original message is not included]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Printing Graphics from UniVerse

2008-12-01 Thread Ken Hall

Adam -
Check out Print Wizard from Rasmussen Software http://www.anzio.com/
It is a great way to add graphics to your printed output and to print 
to file as either text or pdf.


Ken

 At 01:50 PM 12/1/2008, you wrote:

Hey folks,



I've got a multi-part question.  Does anyone have a good method of
printing graphics from UV programs other than the 2-bit black and white?
We'd like to expand into color logos on some of our document and wanted
to know if anyone had come up with a method of including those on
reports/invoices/etc.  As well, does anyone have a good method of
"printing" graphics and reports to file instead of to hardcopy?
Obviously we can print straight text to the &HOLD& file, but we'd also
like to include graphics in some documents we print to file.



Thanks.



Adam Taylor

Sr. Programmer Analyst

INX Inc.

6401 Southwest Freeway

Houston,  Texas  77074

Phone: 713/795-2352

[EMAIL PROTECTED]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] biztalk adapter

2008-12-01 Thread Adam Taylor
Bob,

We use BizTalk with our UniVerse system, and have found some issues with
using webservices such that certain random connections seemed to get
dropped depending on how many messages you were trying to process at
once.  We have a vendor we work with who will sometimes send us hundreds
of messages in the span of a few minutes, and we'd see a consistent
ratio of dropped connections between the BT server and the webservice.

For us, the answer to that problem was writing a small custom .dll in
.NET that made use of UniObjects.NET to call a UV subroutine to pass the
data.  We then call this .dll from an expressions shape in our
orchestration.  This has seen increased performance and has completely
cleared the connection issues we had with webservices.

Hope this helps.

Adam Taylor
Sr. Programmer Analyst
INX Inc.
[EMAIL PROTECTED]

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney
Sent: Tuesday, November 25, 2008 6:27 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] biztalk adapter [ad]

Tony

Many thanks

The reason I asked is because I didn't want to write it myself

I have a webservice fronting the U2 already so I'll go thru that

It just that an adapter would have been nice

Not to worry

Bob

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tony G
Sent: 25 November 2008 10:15
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] biztalk adapter [ad]

Since there's only been one response so far and it doesn't look
like there are any alternatives, I can ask one of our guys to
write a BizTalk/U2 interface on a T&M basis.  The solution might
be an adapter, web service, or functoids, depending on how it
will be used.  Just email if interested.

HTH

Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com
Nebula R&D sells mv.NET and other Pick/MultiValue products
worldwide, and provides related development and training services
 

> From:Hona, David
> Bob
> You're probably going to have to use the BizTalk to MQSeries
adaptor.
> However, you'd need MQSeries installed on your server...not
really a
> cheap option to do. MQ may not give you want you need, 
> depending on your business/technical requirements.

> From: Bob Witney
> I am happily going from aix5.3 running universe 10.2 to ms sql
via MS
> BizTalk, works fine
> 
> Does anyone have knowledge of a BizTalk adapter (ms don't 
> have one) that will le me go the other way?
> i.e. BizTalk to Universe
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
__

Confidentiality Notice:  This e-mail and any attachments are intended
solely for the addressee and may contain confidential or privileged
information.   If you are not the named addressee, or the person
responsible for delivering the message to the named addressee, please
notify the sender as soon as possible and delete the material from your
computer.  This message will be protected by copyright.  If it has come
to you in error, you must not take any action based on its contents nor
must you copy or show the message to any person other than the intended
recipient. 
_
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
__
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Printing Graphics from UniVerse

2008-12-01 Thread Adam Taylor
Hey folks,



I've got a multi-part question.  Does anyone have a good method of
printing graphics from UV programs other than the 2-bit black and white?
We'd like to expand into color logos on some of our document and wanted
to know if anyone had come up with a method of including those on
reports/invoices/etc.  As well, does anyone have a good method of
"printing" graphics and reports to file instead of to hardcopy?
Obviously we can print straight text to the &HOLD& file, but we'd also
like to include graphics in some documents we print to file.



Thanks.



Adam Taylor

Sr. Programmer Analyst

INX Inc.

6401 Southwest Freeway

Houston,  Texas  77074

Phone: 713/795-2352

[EMAIL PROTECTED]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[Fwd: Re: [U2] Universe triggers (still more)]

2008-12-01 Thread Bill Haskett

Susan:

To expand further on Jeff's comment, the EXECSTAT variable is part of 
the CALL arguements

list. For instance, in UniData an update trigger might look like:

001 SUBROUTINE U2.MASTER.TRIGGER.U ( ExecStat, DictFlag, atFILENAME, atID, 
atRECORD )
  
The following table describes each parameter of the syntax.


  ** Parameter   Description
  ** --  
  ** trignameThe name of the globally cataloged subroutine.
  ** execstatThe execution status returned by the trigger subroutine:
  ** 0 - No updates are allowed.
  ** 1 - Updates are allowed.
  ** 2 - Updates are allowed, using the return recordval.
  ** dictflag"DICT" - Indicates that the trigger is operating on the
  **  dictionary file.
  ** "" - Indicates that the trigger is operating on the
  **  data file.
  ** Note: the quotation marks are required.
  ** filenameThe name of the file on which the trigger is operating.
  ** item ID The item ID of the record to be updated.
  ** recordval   The input record value submitted to the UPDATE trigger.
  ** "recordval" is both an input and output parameter. The
  ** trigger can change this value (for example, by performing
  ** a conversion). Then, if the trigger sets execstat to 2,
  ** this value is passed back in recordval and updates the
  ** data record. Only strings and numbers are valid.
  **
  ** If the value returned in recordval is invalid, the record
  ** is not updated, even if the trigger subroutine sets execstat
  ** to 2. In this case, the UniBasic STATUS function returns 3
  ** when executed immediately after the command that calls the
  ** trigger. Only strings and numbers are valid.

Therefore, you pass EXESTAT in and out of the CALLed program, set its value,
and UniData knows it and responds to the setting accordingly.
  
HTH,


Bill
  
__


  Jeff Butera wrote on 12/1/2008 8:46 AM:



Hi everyone,

I have the triggers working - yay! Thanks Manu! - but now I'm to the next
step, and of course stumbling again!  My program sets a flag when it wants
to disallow the write that called the trigger.  The manual seems to suggest
that I could use SetDiagnostic to fail this . but I'm not even getting my
program to compile and can't find further information on the syntax of that
command.  Anyone know how to tell the trigger to refuse the write?

I can't comment for Universe, but in Unidata you set EXECSTAT to one of three
values

0 = don't write the record
1 = write record, but don't allow trigger to have altered the contents
2 = write record and allow trigger to possibly have altered contents
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Universe triggers (still more)

2008-12-01 Thread Bill Haskett
   Susan:
   To expand further on Jeff's comment, the EXECSTAT variable is part of the
   CALL arguements list.  For instance, in UniData an update trigger might look
   like:
   001 SUBROUTINE U2.MASTER.TRIGGER.U ( ExecStat, DictFlag, atFILENAME, atID,
   atRECORD )
   The following table describes each parameter of the syntax.
   ** Parameter   Description
   ** --  
   ** trignameThe name of the globally cataloged subroutine.
   ** execstatThe execution status returned by the trigger subroutine:
   ** 0 - No updates are allowed.
   ** 1 - Updates are allowed.
   ** 2 - Updates are allowed, using the return recordval.
   ** dictflag"DICT" - Indicates that the trigger is operating on the
   **  dictionary file.
   ** "" - Indicates that the trigger is operating on the
   **  data file.
   ** Note: the quotation marks are required.
   ** filenameThe name of the file on which the trigger is operating.
   ** item ID The item ID of the record to be updated.
   ** recordval   The input record value submitted to the UPDATE trigger.
   ** "recordval" is both an input and output parameter. The
   ** trigger can change this value (for example, by performing
   ** a conversion). Then, if the trigger sets execstat to 2,
   ** this value is passed back in recordval and updates the
   ** data record. Only strings and numbers are valid.
   **
   ** If the value returned in recordval is invalid, the record
   ** is not updated, even if the trigger subroutine sets execstat
   ** to 2. In this case, the UniBasic STATUS function returns 3
   ** when executed immediately after the command that calls the
   ** trigger. Only strings and numbers are valid.
   Therefore, you pass EXESTAT in and out of the CALLed program, set its value,
   and UniData knows it and responds to the setting accordingly.
   HTH,
   Bill
   __

   Jeff Butera wrote on 12/1/2008 8:46 AM:



Hi everyone,

I have the triggers working - yay! Thanks Manu! - but now I'm to the next
step, and of course stumbling again!  My program sets a flag when it wants
to disallow the write that called the trigger.  The manual seems to suggest
that I could use SetDiagnostic to fail this . but I'm not even getting my
program to compile and can't find further information on the syntax of that
command.  Anyone know how to tell the trigger to refuse the write?

I can't comment for Universe, but in Unidata you set EXECSTAT to one of three
values

0 = don't write the record
1 = write record, but don't allow trigger to have altered the contents
2 = write record and allow trigger to possibly have altered contents
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Universe triggers (still more)

2008-12-01 Thread Jeff Butera

> Hi everyone,
>
>
>
> I have the triggers working - yay! Thanks Manu! - but now I'm to the next
> step, and of course stumbling again!  My program sets a flag when it wants
> to disallow the write that called the trigger.  The manual seems to suggest
> that I could use SetDiagnostic to fail this . but I'm not even getting my
> program to compile and can't find further information on the syntax of that
> command.  Anyone know how to tell the trigger to refuse the write?

I can't comment for Universe, but in Unidata you set EXECSTAT to one of three 
values

0 = don't write the record
1 = write record, but don't allow trigger to have altered the contents
2 = write record and allow trigger to possibly have altered contents

-- 
Jeff Butera, Ph.D.
Administrative Systems
Hampshire College
[EMAIL PROTECTED]
413-559-5556

"Where I'm from, we believe all sorts of
things that aren't true. We call it 'history'."
   The Wizard, Wicked
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Universe triggers (still more)

2008-12-01 Thread Susan Joslyn
Hi everyone,

 

I have the triggers working - yay! Thanks Manu! - but now I'm to the next
step, and of course stumbling again!  My program sets a flag when it wants
to disallow the write that called the trigger.  The manual seems to suggest
that I could use SetDiagnostic to fail this . but I'm not even getting my
program to compile and can't find further information on the syntax of that
command.  Anyone know how to tell the trigger to refuse the write?

 

Susan
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/