Email Inserts of Pictures
-
I am a network engineer for a medium based home health care company and had two of our programmers ask if I can find any documentation/scripts on importing pictures based on a subject string 0002245 or the picture name as an attachment 00032344.jpg and pump it into the database. Is this a fairly easy feat? Does anyone know of any documentation on this? Thanks in advance all!
-
This was removed by the editor as SPAM
-
If I understand you correctly, you're talking about eMails containing picture attachments which should be loaded into a db, right?
Now, if so, I would write a small VB app utilizing Outlook's object model library to save the pics on disk. For there you can import them into an IMAGE column in your table using the ADO.Stream object. Maybe this http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx will help you, too.
In case I misunderstood you, can you be more specific?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Your understanding was exactly correct.... off to do some reading
I will let you know how it turns out! Spencer -
Actually... do you know where I can find the save to disk portion on object model library? Also- would this be the thing to do? We have over 100 agencies of each will be submitting possibly 40+ pictures a day. Would writing to disk first and then running inserts on a prod database (although on a SAN with 32gb or ram) be a resource catastrophy?
-
Just finished configuring the vb as a macro in outlook to write files to disk. Was rather easy ... the only concern is we will have to be running outlook the whole time on a "batch server" so to speak... which we are trying to do away with on our previous platform of software we have. Is there any way to run this process Outlookless?
-
Well, I must confess I use this only for more or less private use. Some 4 or 5 other people in my company use it. I do receive some ~200 research mails a day and have a macro to save to disk and then to the db. I choose this approach, because I do only have to distribute a small app that let one choose which mail to read, then that mail gets saved to disk and is opened with Outlook.
I think you might also be able doing this utilizing the CDO object library, but I haven't done much with it, so I can help you with it. Probably you'll find some answers here: http://www.cdolive.com/
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply