Hi David, Depending on your file type and underlying OS you could 1) If the file type is not a type 1 or type 19 then write a uniVerse subroutine as a SQL trigger. See chapter 5 of the SQL reference guide, on how to do this.
2) If the file type is a type 1 or a type 19 then if your underlying OS is Unix try "find <File> -mtime -1" to get only those records (files) that have been modified today. >From the tone of your posting it sounds as if you are comfortable with scripts >anyway. Creating and using uniVerse triggers can be pretty daunting, even for experienced uniVerse users. I would try to see if you could get some support from your uniVerse VAR on this. It will probably cost - but rest assured it is do-able. HTH Adrian Sent from my iPad On 11 Dec 2013, at 4:38 pm, David Campbell <[email protected]> wrote: Hi Everyone, I'm new to universe (a complete noob) and I couldn't quite find what I was looking for on google and I've been smashing my face against this for a while until I stumbled upon this mailing list so I was wondering if anyone could help me out here. I'm writing a script that will hopefully alert me via email whenever a new record is added to a particular universe file, if there is a better way to do this I would be all ears. I'm working around another proprietary system which operates on universe and I dont know enough about universe to really say for sure what is proprietary and what is universe standard code and the proprietary stuff is covered in NDA's and no touchy hand slappy orders so I cannot really modify the way it works, I just need to know when a new entry appears, preferably via an smtp email. My Current plan works like this I'm looking to regularly (every 5 minutes) output data into a text or csv file, doesn't matter really, so long as it is not full of characters that batch scripts hate and it can happen in an automated fashion. The closest thing I can get to what I want right now is SP.ASSIGN HS LIST FILE.NAME LPTR this lists all the records and dumps them in a spool file under /var/spool/uv/ and then a script I have written in the past retrieves that spool file for me, I have trained that spool file to look for specific markers in the first line of the file and apply a particular script to it This spooled print job gives me a list of the records that I can then sort numerically, pick the highest number, check that number against what the number was last time and alert me via email if its different. Ultimately I would love for a regularly running script to just output the highest record (maybe sort numerically and give me the highest number and dump just that number into a file on the unix box for me to retrieve and the work with. Any help would be greatly appreciated! -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Exporting-to-File-regularly-tp42264.html Sent from the U2 - Users mailing list archive at Nabble.com. _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
