Emails arrive and are parsed into a table, part of that is the notice url which is then parsed to get the details from it. If the email is a completion email then the stoppage record in canalplan is marked as complete, if its a url it's already seen (and its not a completion) then it updates the stoppage record with the new details. Otherwise it inserts it
I then go in and manually approve or close off the stoppage - so we get a lot about downed trees which we don't actually want to make live.