If you don't mind being notified of other data changes in addition to
record additions, my preference would be to simply check the last
modified time of the UV file at the OS level. I think this shell script
would work:
#!/bin/bash
if [ ! -f /var/tmp/uv_timestamp ]; then
touch /var/tmp/uv_timestamp
elif [ -n "`find /path/to/UV/file -newer /var/tmp/uv_timestamp`" ]; then
{
echo "Content of email"
echo "notification"
} | mail -s "UV file change" [email protected]
touch /var/tmp/uv_timestamp
fi
The script compares the last modified time of an empty file you create
to the last modified time of the UV file. If the UV file is newer, you
send an email and reset the modified time of your comparison file. You
could have cron run it every 5 minutes. If you only care about record
additions, though, you'll have to test from within the UV environment
using one of the other suggestions.
-John
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of David
Campbell
Sent: Tuesday, December 10, 2013 9:39 PM
To: [email protected]
Subject: [U2] Exporting to File regularly
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-regul
arly-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
