Sounds like a great tool Ronnie. http://www.PickSource.com is a great place for stuff like this. I'll be happy to host it at http://Nebula-RnD.com/freeware, just e-mail me a zip, and please include a ReadMe.
Good luck in any case. Tony Nebula R&D >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Ronnie Adams >Sent: Friday, February 27, 2004 8:28 PM >To: 'U2 Users Discussion List' >Subject: RE: UniVerse to excel feeds > > >I have a subroutine that works with both Accuterm and >Wintegrate. It's fairly easy to integrate into an existing >report. You can put column headings, set column widths, add >formulas, multiple sheets, multiple books. It does quite a >bit. I'd be glad to share it with the group if somebody would >tell me where to put it. I should also put an example of a >program that calls it. Let me know. > >Ronnie > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Bruce McAdoo >Sent: Friday, February 27, 2004 3:26 PM >To: 'U2 Users Discussion List' >Subject: RE: UniVerse to excel feeds > > >Don: > >If you have wIntegrate, terminal emulation and host-based >application, you can accomplish your task. I did, but it was >about five years ago. >Maybe a current wIntegrate user could chime in. > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >On Behalf Of [EMAIL PROTECTED] >Sent: Friday, February 27, 2004 11:47 AM >To: [EMAIL PROTECTED] >Subject: RE: UniVerse to excel feeds > >Don: > >I have written a program called BEXCEL which takes in a >command, formats a csv file, and then uses an ftp process (we >have pi/open on hpux) to send this file to a place where the >users can open it. For example, the command > >BEXCEL INMATE | LNAME FNAME MNAME DOB AKA.LN AKA.FN | IRPT1 | ALL | Y > >reads the INMATE file then outputs a file named >"myloginIRPT1.csv" with columns LNAME, FNAME, MNAME, DOB, >AKA.LN, and AKA.FN to the designated network site via an ftp >transfer. The AKA fields are multivalued and are handled. >All records were selected, but in the place of 'ALL' one could >have put the name of a select list. The final parameter Y >means to put a space between records in the csv file. > >I have the companion programs HEXCEL, which outputs a .htm >file for your browser and has additional parameters to specify >headlines, and TEXCEL which is the interactive version where >users enter file name, fields desired, etc for Ad Hoc reporting. > >I have embedded calls to BEXCEL in a few programs ("send report to >Excel") >and it works fine. > >There is a little 'local' coding in each of these, but I will >be happy to take that code out. > >You do need to set up a couple of VOC entries (easy) and also >set up the ftp process to get the file automatically sent to >the desired network directory (I needed my network guys to do >this for me). > >Free if you would like to take a look. > >Harold Oaks > > >Don Cutting wrote: > >Hi All, > We are looking for a process, where a report run in >UniVerse can feed direct into excel, with no human action >being taken - or as little as possible. If you have a process >or tool where you can do this, and are willing to share this >information, please e-mail. We are on UniVerse 10.0.19 and AIX 5.2 > > Thank you in advance for your suggestions. > >-- >u2-users mailing list >[EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users > >-- >u2-users mailing list >[EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users > > >-- >u2-users mailing list >[EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users > -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
