Liz Conlan

Timing out, I'm currently getting a 504 for this

oh, ouch! useful to know, thanks @kingqueen3065!

This may not be the best place to add this but as it seems like the main "fix CSV import" ticket... > when you do an all authority export the...

The `InfoRequest.title`s are identical, and the `OutgoingMessage.body` appear identical. However, the SQL query is not matching the body text so `InfoRequest.find_existing` is returning `nil` (and allowing the duplicate) Postgres is...

Possible (horrible) solution: ```rb def self.find_existing(title, public_body_id, body) conditions = { :title => title, :public_body_id => public_body_id } matching = InfoRequest. where(conditions). first if matching ogm_ids = matching.outgoing_messages.pluck(:id) matching_ids =...

no, wait - it's treating e.g. "\r" as the literal value `\r` (a backslash followed by an r)

> Might be to do with differing newlines which get stripped They only get stripped if they're leading or trailing space

> So AIUI, the text submitted through params contains windows newlines, but we then save as unix newlines so the two don't match? We're saving it as submitted - the...

This might be specific to how the WDTK database is configured as this is the behaviour we're seeing: ``` message = OutgoingMessage.find(676453) OutgoingMessage.where(body: message.body) => # ``` Testing the returned...

We're still looking into this but currently believe our usage is at least broadly in line with the spirit of the RFC but that we have confused the issue by...