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


  • Subject: Re: spool file to spreadsheet conversion program
  • From: MacWheel99@xxxxxxx
  • Date: Sat, 6 Jan 2001 14:11:03 EST

There are a ton of companies that provide lowcostware to get 400 reports to 
PC in popular formats such as e-mail attachments, word processing documents, 
spread sheet. etc.  There was a recent thread in Midrange_L that you could 
check in the archives < http://archive.midrange.com > called "400 report to 
PC file" and there was also a discussion I was involved in with my local 400 
user group, which does not yet have list_archives called "Re: AS400 going 
from spool file to html  or pdf"

I cut & pasted some those in their entirety to send you outside the list as 
they are a bit long for this place's guidelines & basically consist of a web 
site that you can cut & paste, then a short paragraph that tries to define 
what it is that this place offers of relevance.  I have recently been 
visiting some of those sites & 95% of them are good but a few I may have made 
a typo or something ... I cannot get to them.

Here is an example of the format of what I am cut pasting from months ago 
investigation.

http://www.centerfieldtechnology.com - with their stuff a PC CD_RW drive can 
create AS/400 readable CD_Roms ... they also have an SQL tool that puts 
DB/400 data into graphical form.

http://www.datawatch.com ... they make Monarch which usually has PC seat 
license fee around $600.00 but be patient, they often have a promotion & we 
got 
ours during a $300.00 PC seat deal ... how it works ... you click on AS/400 
spool entry you want Monarch to convert to PC reality & now you can slice & 
dice the data in the report, selecting columns & lines to include & you tell 
it what PC format you want the data to end up in ... Lotus, Symphony, Word 
... graphics package, spread sheet, PDF file, e-mail whatever.   It is just 
point & click.  If you are not doing any slice & dicing yout can get from 400 
spool to PC file in a matter of seconds.

I had also made an effort to correlate in chart form which of these 
lowcostware packages include which capabilities ... it is NOT uptodate NOR 
complete, but a starting point at seeing what is out there.

>  From:    wrooks@net400.com (Wilton Rooks)
>  
>  Does anyone know a company in NJ that has a program to convert spool files
>  to spreadsheet format. I spoke to them several months ago before it was
>  announced but have lost track of them and have not seen any announcements.
>  
>  Wilton Rooks
>  Net400, Inc.
>  


MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)
AS/400 Data Manager & Programmer for BPCS 405 CD Rel-02 mixed mode (twinax 
interactive & batch) @ http://www.cen-elec.com Central Industries of 
Indiana--->Quality manufacturer of wire harnesses and electrical 
sub-assemblies - fax # 812-424-6838

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---

As an Amazon Associate we earn from qualifying purchases.

This thread ...


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.