Discussion:
Automatic downloading the EXCELL data from AS/400
(too old to reply)
dan
2003-09-12 06:14:17 UTC
Permalink
Our shop need to automate the download the data in PF to PC in excell
format very friday .

Does any body done so in there AS/400 setup.

Thanks in advance

DAN
USS Inc.
Dr. Ugo Gagliardelli
2003-09-12 11:03:09 UTC
Permalink
Post by dan
Our shop need to automate the download the data in PF to PC in excell
format very friday .
Does any body done so in there AS/400 setup.
If you don't need a "real" excell file and a csv excell compatible file would do the same, then you can use cpytoimpf command.
If you need a real excel file and in your shop there's a good Java programmer there's an open source Java project (called POI) that can run on as/400, that need a db interface to achieve your goal. (Actually I don't remember the link, if you're intrested in I can find out)
Basing on POI documentation (Microsoft didn't release any BIFF structure documentation) I did myself a DB/BIFF4 (excell V4) converter program that:
-put a first spreadsheet row with db column heading values
-format columns width accordingly to DB fields length
-format numeric columns accordingly to DB fields decimal percision
-format date columns accordingly to date/time DB fields date/time formats (timestamp as well)
-is limited to a 16MB output excell file
At the time I did that there was no 3rd party program that matched my requirement, even if you can find some spread sheet generator on the internet, try searching http://www.google.com/search?q=%2Bexcell+%2BiSeries and possibly you'll find some result pages.
Transfer the generated excell file to PC is matter of a good PC and NetServer configuration then you'll be able to copy the file with COPY as/400 command.
--
Dr.Ugo Gagliardelli,Modena,ItalyCertifiedUindoscrasherAñejoAlcoolInside
Spaccamaroni andate a cagare/Spammers not welcome/Spammers vão à merda
Spamers iros a la mierda/Spamers allez vous faire foutre
Spammers loop schijten/Spammers macht Euch vom Acker
QMAGIC
2003-09-12 15:31:46 UTC
Permalink
I and others have asked this question before, if you really need an
Excel file then your looking at a commerical solution. If a CSV file
will work for you check out CPYTOIMPF (Copy To Import File). If you
can schedule a job on the PC that wants the file look at using Client
Access file transfer and set the output pc file type to BIFF 8 (MS
Excel8). Biff is the format that Excel stores the information in.

Of course if you like you could write the information directly out
into the Biff format. In my searching I found a Java option also the
books that define the specifications for the Biff format. If you write
an RPG version to create the BIFF I would be very interested in seeing
it.

Hope this helps.
Dan
Post by dan
Our shop need to automate the download the data in PF to PC in excell
format very friday .
Does any body done so in there AS/400 setup.
Thanks in advance
DAN
USS Inc.
Dr. Ugo Gagliardelli
2003-09-12 17:49:40 UTC
Permalink
Post by QMAGIC
I and others have asked this question before, if you really need an
Of course if you like you could write the information directly out
into the Biff format. In my searching I found a Java option also the
books that define the specifications for the Biff format.
MS didn't release any, OpenOffice.org did. You can get the BIFF reference at http://sc.openoffice.org/excelfileformat.pdf
There's an open project called POI written in java on http://jakarta.apache.org/poi/index.html where you can download application jar and sources as well.
Post by QMAGIC
If you write an RPG version to create the BIFF I would be very interested in seeing
it.
I didn't, I wrote a C one.
--
Dr.Ugo Gagliardelli,Modena,ItalyCertifiedUindoscrasherAñejoAlcoolInside
Spaccamaroni andate a cagare/Spammers not welcome/Spammers vão à merda
Spamers iros a la mierda/Spamers allez vous faire foutre
Spammers loop schijten/Spammers macht Euch vom Acker
Thad Rizzi
2003-09-12 15:56:31 UTC
Permalink
Post by dan
Our shop need to automate the download the data in PF to PC in excell
format very friday .
Does any body done so in there AS/400 setup.
Thanks in advance
DAN
USS Inc.
Maybe try it on the PC side. If you are using Windows and Client
Access you may be able to use Scheduled Tasks to run the Client Acess
Data Transfer From AS/400 program. "C:\Program Files\IBM\Client
Access\cwbtf.exe" is the path on my PC. I didn't try it but it seems
feasible. Hope this helps.

Thad Rizzi
Andi Goering
2003-09-13 12:56:06 UTC
Permalink
Dan,

we offer a solution for Excel generation on the AS400.
So you can automize the things very easy with it.

The tool's name is **iExcelGen** and you find more facts and downloads at our
website http://www.goering.de

Best regards

Andreas Goering
GOERING iSeries Solutions
-Offices in Germany and USA-
Post by dan
Our shop need to automate the download the data in PF to PC in excell
format very friday .
Does any body done so in there AS/400 setup.
Thanks in advance
DAN
USS Inc.
barry NimesOk
2003-09-25 09:09:26 UTC
Permalink
Post by dan
Our shop need to automate the download the data in PF to PC in excell
format very friday .
Does any body done so in there AS/400 setup.
Thanks in advance
DAN
USS Inc.
Symtrax sell a lot of AS/400 nice tools that you can try for free :

http://www.symtrax.com
Stephen Chu
2003-09-25 16:16:45 UTC
Permalink
Why don't you schedule a job in NT via the File Explorer to run the CA File
Transfer? It's no cost at all.

Cheers/Stephen
Post by barry NimesOk
Post by dan
Our shop need to automate the download the data in PF to PC in excell
format very friday .
Does any body done so in there AS/400 setup.
Thanks in advance
DAN
USS Inc.
http://www.symtrax.com
Loading...