you're also quite welcome to post it to http://www.pickwiki.com along with any docs you might have. the more, the merrier!
>-----Original Message----- >From: Tony Gravagno [mailto:[EMAIL PROTECTED] >Sent: Friday, February 27, 2004 8:41 PM >To: 'U2 Users Discussion List' >Subject: RE: UniVerse to excel feeds > > >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 > -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
