Basically receive incoming daily emails, with CSV attachment, then importing the CSV rows to your desired model/database.
Anyone done this before?
Thanks for any input.
Daniel I'm with Jack and recommend you use Griddler for inbound email. I currently use it to capture attachments on inbound emails and store them to S3.
Process the email, check for a filetype of CSV (or against name etc.) then process as a normal CSV import. Ruby supports this natively or you can use the smarter-csv gem.
Join 24,647+ developers who get early access to new screencasts, articles, guides, updates, and more.