[rt-users] Ideas on best way to do this?

[Leonid Mamchenkov]

Greg,

On Wed, Feb 20, 2008 at 8:34 PM, Greg Evans <gevans at hcc.net> wrote:
>  All of my users are in our radius file, which is great and I am pretty sure
>  that I can figure out how to import them from that using standard mySQL
>  syntax and a exported .csv or similar file.
>
>  The problem that was brought to my attention is that I would need to do this
>  daily. Is there a way that you or someone would know of that would allow me
>  to import only the new data each day?
>
>  Please remember, I am not much of a programmer, but I would like to see if
>  this is possible and maybe an example if someone knows how to do it :)

If you will find a way to import your data into RT once, there is, of
course, a way to do this daily.  Assuming that your data is in some
text format (like .csv file), you could use GNU diff to find out the
differences between two text files (one for yesterday and one for
today).  The output of GNU diff is very easy to parse and act upon.
(hint: when using this tool, go for unified diff output - it's even
easier to parse).

-- 
Leonid Mamchenkov
http://mamchenkov.net