Rails - Mar 2007 - How to Create Records in Rails App Database using Inbound Email including Image File Attachments

I am trying to create a feature within my application to receive
product data including an image attachment via inbound email.

Can someone point me to a tutorial or other document online that will
help out with this.  I have started hammering at Google, but was
hoping someone could provide a link.

Thanks,
Nathan


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Nathan wrote:
> I am trying to create a feature within my application to receive
> product data including an image attachment via inbound email.
>
> Can someone point me to a tutorial or other document online that will
> help out with this.  I have started hammering at Google, but was
> hoping someone could provide a link.
>   
Here''s some code I use in one of my apps.  Stole most of it from some 
examples I found somewhere, don''t remember where:


class IncomingCSVFileHandler < ActionMailer::Base
  def receive(email)
    return unless email.has_attachments?

    email.attachments.each do |attachment|
      next unless attachment.original_filename[-4..-1] ==
''.csv''

      CSV::Reader.parse(attachment.read) do |rec|
        next if rec.last.blank?
        server = Server.find_by_name(rec.last.split(''-'', 
2).first.strip.upcase)
        next if server.blank?

        a = Answer.new
        a.server = server
        a.ticket_no = rec.first
        a.question = rec[2]
        a.answer = rec.last.split('' - '', 2).last
        first_name, last_name = rec[3].split
        a.created_by = User.find_by_name("#{last_name}, 
#{first_name}.titleize")
        a.last_updated = Time.now
        a.updated_by = a.created_by
        a.save!
        RAILS_DEFAULT_LOGGER.info("Added answer record for
#{server.name}")
      end
    end
  end

  def self.check_mail
    begin
      imap = Net::IMAP.new(''130.102.202.121'')
      imap.login(''userid'', ''password'')
      imap.select(''remedycsvfiles'')
      imap.search(["SINCE", Date.today.strftime("%d-%b-%Y")]
       ).each do |message_id|
        msg =
imap.fetch(message_id,''RFC822'')[0].attr[''RFC822'']

        IncomingCSVFileHandler.receive(msg)

        #Mark message as deleted and it will be removed from storage 
when user
        #session closed
#        imap.store(message_id, "+FLAGS", [:Deleted])
      end
#      imap.expunge
      imap.logout
    rescue
      RAILS_DEFAULT_LOGGER.error("Remedy CSV File Import Error: " +
$!)
    end
  end
end


Not pretty, but it works!

HTH,

Jamey Cribbs






--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

On 3/30/07, Nathan <nathanoleach-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
>
> I am trying to create a feature within my application to receive
> product data including an image attachment via inbound email.
>
> Can someone point me to a tutorial or other document online that will
> help out with this.  I have started hammering at Google, but was
> hoping someone could provide a link.
Nathan,
I dug this out of a feed recently:
http://wiki.rubyonrails.com/rails/pages/HowToReceiveEmailsWithActionMailer

Is this what you want?

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Richard,

I think this is really close to what I need.  I am not sure which method of
integrating with the mail server will be best for me, since I am working from a
Dreamhost server.  I am thinking I just want to periodically check a specific
mail account via POP.  If anyone has done this and can give specific help I
would appreciate it.

I will be working on this over the weekend and will post back to the group with
some findings.

Thanks everyone for the helpful posts!

Nathan

-----Original Message-----

From:  "Richard Conroy"
<richard.conroy-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
Subj:  [Rails] Re: How to Create Records in Rails App Database using Inbound
Email including Image File Attachments
Date:  Fri Mar 30, 2007 11:12 am
Size:  976 bytes
To:  rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org


On 3/30/07, Nathan <nathanoleach-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
>
> I am trying to create a feature within my application to receive
> product data including an image attachment via inbound email.
>
> Can someone point me to a tutorial or other document online that will
> help out with this.  I have started hammering at Google, but was
> hoping someone could provide a link.
Nathan,
I dug this out of a feed recently:
http://wiki.rubyonrails.com/rails/pages/HowToReceiveEmailsWithActionMailer

Is this what you want?





--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---