Re:: UniVerse to excel feeds
I found some out some more specifics... Universe spooler hook. The hook is a script that executes a C program that parses the report from standard input and determines the columns and headings. It then parses the output and generates a Perl script that creates an Excel spreadsheet, and executes the Perl script. It then FTP's the spreadsheet file to a Windows server and sends a message to the user that created the file where the file can be picked up. More info can be found by emailing [EMAIL PROTECTED] > I do know of such an animal. There is a guy that wrote a c program that is > linked into the spooler. Once the installation of the software has taken place, > all you have to do is assign the printer, print something, and you are off and > running with your brand new spreadsheet. It is really nifty. He can be reached > at [EMAIL PROTECTED] I am not sure if he just gives it away ot charges for it > but it is worth whatever you pay. > > 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. > > > > Thanks and have a great day! > > > > > > Donald H. Cutting > > A. N. Deringer, Inc. > > D. B. A. / Systems Analyst > > Tel. (802)524-8172 > > Fax. (802)524-8297 > > www.anderinger.com > > Our Service Recommends Us! > > > > -- > > 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
Re:: UniVerse to excel feeds
I do know of such an animal. There is a guy that wrote a c program that is linked into the spooler. Once the installation of the software has taken place, all you have to do is assign the printer, print something, and you are off and running with your brand new spreadsheet. It is really nifty. He can be reached at [EMAIL PROTECTED] I am not sure if he just gives it away ot charges for it but it is worth whatever you pay. > 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. > > Thanks and have a great day! > > > Donald H. Cutting > A. N. Deringer, Inc. > D. B. A. / Systems Analyst > Tel. (802)524-8172 > Fax. (802)524-8297 > www.anderinger.com > Our Service Recommends Us! > > -- > 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
RE: UniVerse to excel feeds
Bob Modrich wrote >This worked >well until I deployed vb.net program on the Unidata windows >server and ran across a number of issues with using excel this >way. Microsoft has documented some of the issues at >http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757 >They say "Microsoft does not currently recommend, and does not support, > Automation of Microsoft Office applications from any unattended, non- > interactive client application or component (including ASP, DCOM, and NT > Services), because Office may exhibit unstable behavior and/or deadlock when > run in this environment." Except for reentrancy and scalability, it's relatively easy to code around all of the issues they've presented. I think their statement is less technical and more intended to discourage multi-user access to Excel. It's designed and licensed as a single-user desktop app, and they don't get paid for multiple users in a networked environment. Tony Nebula R&D [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UniVerse to excel feeds
In a message dated 2/27/2004 8:30:51 PM Pacific Standard Time, [EMAIL PROTECTED] writes: > 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. > www.pickwiki.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniVerse to excel feeds
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
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
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
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
RE: UniVerse to excel feeds
For an example of what's possible, see these links: http://Nebula-RnD.com/products/analysis.htm http://Nebula-RnD.com/demos/nebulanalysis/ (audio/video presentation) Unattended, all Pick BASIC, no CSV files or XML or other file I/O or translations, full formatting with charts and all other features of Excel. Internally I've written a COM-AddIn for Excel that listens for socket calls and processes the requests - that's a fast and direct pipe, no intermediate formatting. Another benefit of this is that many users in an office can share a single copy of Excel on a given host, or the MV server can use the Excel that's on the MV client PC. NebulAnalysis is not being offered over U2 at this time as a product but I am willing to implement the features as a service. It's been a long time since I've done anything with this, honestly because most people are quite happy with the traditional mess of writing a CSV, doing some manual import, then manually reformatting after they've done the import. In a world where people want everything automated I really don't understand this intense desire to do everything manually with Excel. Inquiries welcome. Tony, Nebula R&D [EMAIL PROTECTED] (Moderator for Spectrum, Las Vegas) >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Don Cutting >Sent: Friday, February 27, 2004 8:22 AM >To: U2 Users Discussion List >Subject: UniVerse to excel feeds > > >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. > >Thanks and have a great day! > > >Donald H. Cutting >A. N. Deringer, Inc. >D. B. A. / Systems Analyst >Tel. (802)524-8172 >Fax. (802)524-8297 >www.anderinger.com >Our Service Recommends Us! > >-- >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
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
RE: UniVerse to excel feeds
Well, here is one way, given you are running Unix and want to use windows... If you just want to load data into Excel and you only want to do this on one windows machine. There is a lpd/lpr daemon program I use (www.brooksnet.com) called RPM which when setup on a windows machine, looks like a remote printer to unix. It has the ability to take a print job, and force-feed it into an application. You can set it up so it will stick put an .csv extension on the temp file (print job) it receives and will then launch Excel, which will in turn read the data and display it. On the unix side, you just create a ASCII csv file and print it to the remote printer. As discussed earlier, if you use XML, then you can get excel (newer versions) to do a bit of formatting as well, just change the lpd/lpr program to add an .xml extension. This is fairly low cost solution (I think a single license is about $100-150.00) If you want this on mulitple machines, a different method might be to write a small PERL program that runs as a service on windows, that when it receives a file via sockets, it then launches excel with that file. Have a Unix side first determine IP of requesting machine (another discussion :)) and open a socket to that IP and send the data to the PERL program. George >-Original Message- >From: Don Cutting [mailto:[EMAIL PROTECTED] >Sent: Friday, February 27, 2004 11:22 AM >To: U2 Users Discussion List >Subject: UniVerse to excel feeds > > >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. > >Thanks and have a great day! > > >Donald H. Cutting >A. N. Deringer, Inc. >D. B. A. / Systems Analyst >Tel. (802)524-8172 >Fax. (802)524-8297 >www.anderinger.com >Our Service Recommends Us! > >-- >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
Re: UniVerse to excel feeds [AD]-ish
Don, We have a tool which can be automated to pull data at a specified time (or multiple times) from UniVerse and push it out in CSV (which can be read directly by excel). If that's a close enough fit, let me know. The product is called Zeus Data Integration and it retails for less than $1K. - Charles Barouch [EMAIL PROTECTED] 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. Thanks and have a great day! Donald H. Cutting A. N. Deringer, Inc. D. B. A. / Systems Analyst Tel. (802)524-8172 Fax. (802)524-8297 www.anderinger.com Our Service Recommends Us! -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users