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: EVAL and LIKE
Title: Message Kevin: A problem is the use of the double-quote more than once - this will fail. Also, in your original below you have the following clause using LIKE: LIKE "'...*' which will not work in the way you want. Because the ...* is within the single quotes, the LIKE statement will try to match on exactly that - it will seek fields that are exactlythree periods and an asterisk!Actually, if you just want to count records, try this COUNTFILE.NAMEWITH FIELD.NAMELIKE "...'*'..." OR WITHFIELD.NAME LIKE "...'Incomplete'..." Note that the specific strings you want to seek are inside the single quotes, but the triple-dots are outside those but contained inside the double quotes. (In pi/openyou don't need the double quotes at all). Harold Oaks Sr. Analyst/Programmer Clark County, WA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin MichaelsenSent: Thursday, February 05, 2004 9:16 AMTo: U2 Users Discussion ListSubject: RE: EVAL and LIKEI tried it. It didn't seem to work but maybe I didn't do it right. I did include the [1] in there. I'm a newbie, was I not suppose to. I'm also running this in a UNIQUERY statement at the colon prompt. Would that have anything to do with it not running properly. Thanks for whatever light you can shed on my case.kevinAt 11:24 AM 2/5/2004 -0500, you wrote: Perhaps this will help:EVAL "IF (FIELD.NAME[1] = "*" OR INDEX(FIELD.NAME,'Incomplete',1)) THEN 1 ELSE 0" -Original Message- From: Kevin Michaelsen [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 05, 2004 11:14 AM To: [EMAIL PROTECTED] Subject: EVAL and LIKE I'm trying to get this statement to work: Basically I'm trying to count the number of records that have a FIELD.NAME that has an "*" or an "Incomplete". TOTAL EVAL "IF(WITH FIELD.NAME LIKE "'...*','Incomplete'") THEN COUNTER ELSE 0" Thanks for any assistance. Kevin-- 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