dbTalk Databases Forums  

mvBase & Viaduct Hold File to Windows.WRI file

comp.databases.pick comp.databases.pick


Discuss mvBase & Viaduct Hold File to Windows.WRI file in the comp.databases.pick forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Curt
 
Posts: n/a

Default mvBase & Viaduct Hold File to Windows.WRI file - 11-23-2006 , 10:42 AM






I normally work in a Universe/AccuTerm environment. I have a new
customer who runs mvBase & ViaDuct. I am attempting to get reports that
were ran to a hold file, out to a windows .WRI file. My thought was to
set the TERM to 200,9999,0,0,0 then create a program that had ViaDuct go
into 'capture' mode and provide a path and filename to it, then execute
a sp-edit and stack a TN so the print job would spool out to the
terminal and be saved in the capture file. Then, I would turn off
capture mode and the file would be in a windows file. I am not real
savvy with ViaDuct so it might be a simple thing. Any help or even
better suggestions would be appreciated.

Thanks

Reply With Quote
  #2  
Old   
Craig
 
Posts: n/a

Default Re: mvBase & Viaduct Hold File to Windows.WRI file - 11-23-2006 , 03:15 PM






Is there any chance you could change the report output direct to a DOS level
file? Then you could actually write out a document in HTML with a .doc
extention and then just launch word with the path to the document!!

It looks naff until you view it in print preview or print it!!

I do this with some Works Order documentation. Works very well!

I do this straight from mvTERM don't need to use any other emulator though

You would be able to do this quite easily from Viaduct I am sure

Craig

"Curt" <junkmail (AT) junkmail (DOT) com> wrote

Quote:
I normally work in a Universe/AccuTerm environment. I have a new
customer who runs mvBase & ViaDuct. I am attempting to get reports that
were ran to a hold file, out to a windows .WRI file. My thought was to
set the TERM to 200,9999,0,0,0 then create a program that had ViaDuct go
into 'capture' mode and provide a path and filename to it, then execute
a sp-edit and stack a TN so the print job would spool out to the
terminal and be saved in the capture file. Then, I would turn off
capture mode and the file would be in a windows file. I am not real
savvy with ViaDuct so it might be a simple thing. Any help or even
better suggestions would be appreciated.

Thanks



Reply With Quote
  #3  
Old   
Ross Ferris
 
Posts: n/a

Default Re: mvBase & Viaduct Hold File to Windows.WRI file - 11-23-2006 , 04:03 PM



I haven't used ViaDuct in over a decade, and have never used mvBase,
BUT ...

if mvBase supports printing to auxillary ports ("sp-assign as" on d3
systems), then why not just setup a FILE: printer under windows, set
that as the default printer that ViaDuct uses and then just run your
report ... user then is simply prompted for file name to use (by
Windows) --> easy.

We have used this to ship out standard reports, and multi-megabyte
"specially formatted" files to windows using AccuTerm for years, but
the principal should be unchanged


Curt wrote:
Quote:
I normally work in a Universe/AccuTerm environment. I have a new
customer who runs mvBase & ViaDuct. I am attempting to get reports that
were ran to a hold file, out to a windows .WRI file. My thought was to
set the TERM to 200,9999,0,0,0 then create a program that had ViaDuct go
into 'capture' mode and provide a path and filename to it, then execute
a sp-edit and stack a TN so the print job would spool out to the
terminal and be saved in the capture file. Then, I would turn off
capture mode and the file would be in a windows file. I am not real
savvy with ViaDuct so it might be a simple thing. Any help or even
better suggestions would be appreciated.

Thanks


Reply With Quote
  #4  
Old   
Curt
 
Posts: n/a

Default Re: mvBase & Viaduct Hold File to Windows.WRI file - 11-24-2006 , 03:20 PM



Thank you, this is the kind of ideas I was looking for. I am not
attempting to do this for a single report, or I would just do a UOPEN
and write it directly into a report.wri file. I am looking for a generic
way to do bunches of existing report.

Again, Thanks for the new idea to try.

Reply With Quote
  #5  
Old   
spayne@jitservices.com
 
Posts: n/a

Default Re: mvBase & Viaduct Hold File to Windows.WRI file - 11-27-2006 , 09:47 AM




Curt wrote:
Quote:
Thank you, this is the kind of ideas I was looking for. I am not
attempting to do this for a single report, or I would just do a UOPEN
and write it directly into a report.wri file. I am looking for a generic
way to do bunches of existing report.

Again, Thanks for the new idea to try.
With via you can just do a file transfer, very easy and puts it to a
file on your hard drive.

Just tell it what file you are pulling info from
how you want it (Select stmt)
fields
file sending to



Reply With Quote
  #6  
Old   
David Ousele
 
Posts: n/a

Default Re: mvBase & Viaduct Hold File to Windows.WRI file - 11-27-2006 , 03:55 PM



Curt,

I'm a little late to this discussion, but we also use mvBASE/ViaDuct
and we have a little utility program called "copy-from-spooler" that
sends a spooler hold file to the printer configured in your ViaDuct
session. It just copies the character stream from a hold file to the
ViaDuct printer -- very handy if that's what you want to do.

It's a bit long to post, but if you email me, I'll send you a listing.


Reply With Quote
  #7  
Old   
Brian Speirs
 
Posts: n/a

Default Re: mvBase & Viaduct Hold File to Windows.WRI file - 11-27-2006 , 10:54 PM



But this misses the point doesn't it. The OP wanted to get data out of
a hold file - ie spooler file - and as far as I am aware, you can't
select on a spooler file in mvBASE.

Cheers,

Brian

spayne (AT) jitservices (DOT) com wrote:
Quote:
Curt wrote:
With via you can just do a file transfer, very easy and puts it to a
file on your hard drive.

Just tell it what file you are pulling info from
how you want it (Select stmt)
fields
file sending to


Reply With Quote
  #8  
Old   
Curt
 
Posts: n/a

Default Re: mvBase & Viaduct Hold File to Windows.WRI file Thanks - 11-29-2006 , 12:21 PM



I will load this on my customer's computer and give it a shot. Thanks a
bunch for your assistance.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.