Hi David If you upgrade to the latest UV version you have access to the built-in UV DB audit logging facility. Then you can setup a logging event to log changes to the file(s) in question. Hence, not violating the NDAs nor application flow (which you would have too if modifying the file with adding indices / triggers or the like).
A simple file-based trigger (not the UV/SQL triggers - which a different more powerful beasts) that copies could make a copy to your own file or invokes a BASIC program/script to send notifications should do the trick too. A working example someone has posted on U2-Users List: http://u2-universe-unidata.1073795.n5.nabble.com/universe-11-1-triggers-via-indexing-and-IDX-IOTYPE-sample-tc41706.html#a41718 Audit logging is not for you unless you upgrade UV....but perhaps in the future...I guess you need a job to check the audit log for these events...too https://docs.rocketsoftware.com/nxt/gateway.dll/RKB14/universe/11.2/security1.pdf See page 372 Section 7 for Audit logging BTW: Look at from the vendors' perspective they have a lot of intellectual property tied up in their product. They sell it with consultancy, etc. It's how they make their living - pay their bills and eat... ;) Plus a lot of clients go out of their way not to pay for anything... it's a two-way rocky road sometimes! Regards, David -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Campbell Sent: Thursday, 12 December 2013 9:05 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Exporting to File regularly Wow, overwhelming response to this question, thank you VERY MUCH for all of your idea's, I have a lot to process and decide what I can achieve... as a bit of background that I probably should have included, I am running UniVerse 11.1.9 on an IBM AIX 7.1.1.15 box. So far Bruce Decker seems to have the most appealing option if I can get it going, I'm sure I be full of more questions than answers in a few days, I just hope making this script doesn't make me the go to guy at work when someone needs weird universe stuff done... *gulp* Oh and its a database that is populated by a contact form from a secure website which then alerts the old terminal sessions that this business used in the past, but since they switched to a web interface for the software and hardly anyone uses the terminal full time any more the items sit there sometimes for hours before a response, so yes I want to be spammed by this all day long, and once it works I can point that spam at a receptionist or two :) The problem with notifying just on changes, is the file changes every time an individual reads a record and marks a particular record as "READ" for that user by removing their name from the "users who have not read this yet" column, the file size never changes unless it needs to grow and when records are deleted it simply fills with junk, which I take it is a standard universe thing it does, at this point the numbers appear sequential but that is best guess sigh. The vendor is incredibly secretive, they wont tell me how it works and their NDA says I am not allowed to memorize how their interface works... WTF so YAY obscure software that we cant leave because we are backed into a corner! /end rant Anyway thanks for all the help guys, so glad I found this place! -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Exporting-to-File-regularly-tp42264p42277.html Sent from the U2 - Users mailing list archive at Nabble.com. _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ************** IMPORTANT MESSAGE ***************************** This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ************************************************************** _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
