|
----- Original Message ----- From: "PaulMmn" <PaulMmn@ix.netcom.com> To: <midrange-l@midrange.com> Sent: Thursday, January 10, 2002 8:26 PM Subject: Re: AW: Pulling spool files off AS/400 - VB? > Adam, > > Oliver's reply made me realize that 'all' you want is a spool queue downloader. That's pretty easy to do - you just set the writer on the outq to lpr to a pc, run lpd on the pc. I can think offhand if it will use something in particular for the filename. We wrote out own lpd where you can pass the file name (and select the subdirectory to write to) with various methods. there are extra parameter fields, or you can use the printq name and parse it on the lpd side. > One product that includes this function is MetaFile. Part of the > package is a downloader that downloads an output queue to a directory > on a PC. The download can be set to run automatically every xx > seconds. The downloaded spool file can be deleted or moved to > another output queue. Our LaserVault system does something similar, but we give the user explicit selection capabilities thru command line or cl on the host, it seems silly to download something and erase it. > We have the program running on an NT server. The only drawback with > the version we have (2-3 years old) is that it does not run as a > service; you need to keep a session signed on and the program running. They might have a newer version that does run as a service, most of us COLD vendors did that a couple of years ago. If not, tell me so I can use it against them in competitive situations. That will ge them to upgrade the product with the feature you want. > MetaFile is a program which archives spool files, indexes the > contents, and allows users to find documents based on that index. > The archive is created and stored on a PC. Because the retrieval is > an index lookup, not a search, it is quick. New documents are added > to the index after they are downloaded. Time to add a document to > the index depends on the size of the document, number of words to > index, and the existing size of the index. > > Every word, character sequence, and number are indexed. You can > search for a dollar amount listed at the bottom of an invoice, a > customer number, a city name, a customer name. Anything. You can > also omit 'junk' words (like a, an, the, of, from, etc., etc.) And there is an example. We have always done our indexing on selected columns (including keys that are made up of several different fields). Our indexing is faster than anyones (in generation, they are all about the same in retrieval speed), but Metafile honks on the fact we don't do full text indexing (many of our customers use very large spool files, and full text indexing isn't that important when you are looking up invoice numbers, customer names, etc.) So now we are adding full text indexing. > You can add an overlay and view the archived spool files as if they > were printed on your custom forms. > > I don't know if they offer the download portion separately. They probably don't. We don't, but if there is a market for this let me know, it would be easy to abstract it out. We have another feature that no other COLD vendor has, to my knowledge - SCSI download. We can imitate a tape drive and get stuff off the AS/400 faster than any LAN - and without loading up the LAN. I've often thought it would be great for large data replication work. > One thing that impressed us when we invited the MetaFile folks to > give us a demonstration: IT WORKED! We provided a PC with Client > Access installed (I don't recall if it was an NT machine or not; the > production version is running on NT). The rep installed the software > on the PC (no software required on the AS/400). After tweaking the > settings for the output queue to monitor (and, IIRC, tweaking some > authority), IT WORKED! Took less than 30 minutes from a standing > start. IT WORKED! As advertised. No messing with fancy settings. > No "Oh, you need to do such and such." IT WORKED!! That sold us, > even though there were other products we had yet to evaluate. > > --Paul E Musselman > PaulMmn@ix.netcom.nospam.com Metafile is a good product, one of the best on the AS/400. I didn't realize they weren't putting software on the AS/400. The advanatage of having software on the AS/400 is the ability to control the reports you download, the ability to append and name them, the ability to control the PC side from the AS/400 side and report back errors to the operator, and the ability to print back to the AS/400. We've got a programmable LPD (Line Printer Daemon) which we do not yet sell as a product. But for example, we are working on a combination of our LPD and our Nextract data extract (if you have used Monarch to convert reports to spreadsheets or databases, it's similar to that but lots better). The idea is you take a report and download it, convert it to a spreadsheet or database, and email it, all in one function from the AS/400 side. I've also thought of print to LPD, and include instructions to run x program on the file, or just email it. Brad Jensen www.elstore.com LaserVault - you might like it even better than Metafile, or maybe not
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.