MyNextHome
2008-09-17T16:20:00Z
Hello,

we are using Outlook 2007. We have Contacts in our CRM (SQL Server) and pictures are stored in a directory on a network drive.

When importing these pictures into Outlook (using a View), it displays the picture as normal attachment?

Thanks
Administrator
2008-09-17T16:34:00Z
Outlook is using special values to recognize Contact Picture between other “normal” attachments.
Attachment number: MUST BE LINKED TO A TABLE COLUMN! Contains a number that uniquely identifies the attachment within its parent message.
(When importing only Contact pictures (no other attachments )Attachment number can be 0)


When importing from a file, you must provide Outlook with these values:

Attachment filename: must be empty
Attachment full path and filename: <file> Example: d:\foto\mypicture.jpg
Attachment long filename: ContactPicture.jpg (this is mandatory, Outlook always uses this fixed name in attachment table)
Attachment method:1
Attachment rendering position:-1

when importing directly from DB (blob column):
Attachment binary: the picture
Attachment filename: must be empty
Attachment long filename: ContactPicture.jpg
Attachment method:1
Attachment rendering position:-1


Belcl, Paul
2008-12-28T06:04:00Z
hello,
i found this thread and have a "beginners" question.

i have all my contact pictures stored in P:\fotos.
the name of the picture files is "firstname lastname.jpg"

how exactly has my importfile to look like?
specially how do i use the variables for the name?
Administrator
2008-12-29T11:22:00Z
Attachment filename: must be empty
Attachment full path and filename: P:\fotos\your picture file name.jpg
Attachment long filename: ContactPicture.jpg
Attachment method:1
Attachment rendering position:-1



Belcl, Paul
2008-12-29T12:23:00Z
Hi admin,

thanks for this answer, but i ment which format this import file should have?
is it CSV format ?
which field seperator is needed ?
maybe there is a small demo file with 2 or 3 records to have a look to?
Administrator
2008-12-29T12:36:00Z
You must link an attachment table (Assign Table->Item Attachments). it can be also a View (query in MS Access).

The Table/Query must return the values above (don't map the attachment binary column since you want to use files on harddisk). Set also the extaction path (Extract attachments to a folder..->Set button)
Belcl, Paul
2008-12-30T07:26:00Z
sorry but i are not used to this function. therefore my questions are sometimes "rookie" ;-)

How do i get the pictures linked to the right person record in outlook?
i did not find a "name" field in your settings?

is there maybe a small demo table aviable, to have a look in ?
Administrator
2008-12-30T15:45:00Z
how the attachment record links to a parent record (Contact) or picture file depends on your data model.

If you have only a file in "firstname lastname"."jpg" format, you will have to create a View based on your main table, example (Pseudocode):

Create View ContactPictureView as
select myPrimaryKey,
'' as FileName, 
'd:\foto\' + FirstName + LastName + '.jpg' as Attachmentfullpathandfilename,
'ContactPicture.jpg' as Attachmentlongfilename,
1 as Attachmentmethod,
-1 as AttachmentrenderingPosition,
1 as AttachmentNumber
from myContacts