
Video and Audio], Broadcasting and podcasting Broadcast On the Net

[description], Story, any other text you want to use.

Microsoft CRM Customization – programming email activity attachment

by: Boris Makushkin

Microsoft CRM is now on the scene and it is increasing its market share, due to Microsoft Business Solutions muscles and marketing strategy. It is tightly integrated with other Microsoft Business Solutions products such as Microsoft Great Plains, Solomon, Navision. Being relatively inexpensive in comparison to competitors, like Siebel, Oracle - Microsoft CRM opens you the door for worldwide operations automation. In this small article we would like to give you, software developer, some hints on Microsoft CRM customization.

Today's topic is Activity of email type programming - you usually deal with these customizations when you improve Microsoft Exchange CRM connector. How do you create email attachment - this is the main discussion topic. We'll use C#.Net.

In Exchange handler/event sink you create Activity of email type in MS CRM and one of the tasks is transfer the attachment(s) from the body of the incoming email to the attachment(s) in the Activity. You can realize it through direct access to Microsoft CRM DB. Let's see C# code:

1. First we are getting access to the letter via ExOLEDB:

CDO.Message	iMessage = new CDO.MessageClass();
CDO.IBodyPart iPrt;

iMessage.DataSource.Open(bstrURLItem, null, ADODB.ConnectModeEnum.adModeRead,

ADODB.RecordCreateOptionsEnum.adFailIfNotExists, ADODB.RecordOpenOptionsEnum.adOpenSource, "", "");

2. Next – we come through the attachment list, get their names and save their bodies into temporary catalogue:

	for(int i = 1; i ";
			strXml += "Activity 1";
			strXml += "" + attachmentNumber + "";
			strXml += "" + emailId.ToString("B") + "";
			strXml += "";

			// Create the activity attachment
			Guid attachmentId = new Guid(activityAttachment.Create(userAuth, strXml));
			log.Debug("Create Attachemnt ID: " + attachmentId.ToString("B"));

			UploadFileToDB(attachmentId, filename, filesize);

			return attachmentId;
		}
		catch (System.Web.Services.Protocols.SoapException e)	{
			log.Debug("ErrorMessage: " + e.Message + " " + e.Detail.OuterXml + " Source: " + e.Source);
		}
		catch (Exception e) {
			log.Debug(e.Message + "
\n" + e.StackTrace);
		}

		return new Guid();
	}

5. Main problem, however is attachment body adding to MS CRM database. Main requirement is – attachment must be encoded as BASE64 stream and its length must be specified correctly together with Nine Type and file name of the file it will be knows as an attachment in activity. Let's look at the C# code:

	public void UploadFileToDB(Guid attachmentId, string filename, long filesize) {
		string contentType = "application/octet-stream";

		try {
			Hashtable mimes = LoadMimeDB(Environment.SystemDirectory + "/Albaspectrum/ContentType.txt");

			if (mimes != null) {
				string tmpContentType = GetMimeType(mimes, filename);

				if (tmpContentType != null && !tmpContentType.Equals(""))
					contentType = tmpContentType;
			}

			byte[] memoryData = new byte[filesize];

			FileStream fs = new FileStream(filename, FileMode.Open, FileAccess.Read);
			BinaryReader reader = new BinaryReader(fs);

			reader.Read(memoryData, 0, (int)filesize);

			reader.Close();
			fs.Close();

			OleDbCommand command = conn.CreateCommand();

			command.CommandText = "UPDATE ActivityMimeAttachment SET FileSize = (?), MimeType = (?), FileName = (?), Body = (?) WHERE ActivityMimeAttachmentId = (?)";
			command.Prepare();
			command.Parameters.Add(new OleDbParameter("FileSize", filesize));
			command.Parameters.Add(new OleDbParameter("MimeType", contentType));
			command.Parameters.Add(new OleDbParameter("FileName", new FileInfo(filename).Name));
			command.Parameters.Add(new OleDbParameter("Body", Convert.ToBase64String(memoryData, 0, (int)filesize)));
			command.Parameters.Add(new OleDbParameter("ActivityMimeAttachmentId", attachmentId));

			log.Debug("Prepare to upload attachemnt " + attachmentId.ToString("B") + " in ActivityMimeAttachment");

			command.ExecuteNonQuery();

			memoryData = null;
		}
		catch (Exception e) {
			log.Debug(e.Message + "
\n" + e.StackTrace);
		}
	}

6. File ContectType.txt is matching list of the files extensions and their mime-type in the following format:

asc application/pgp-encrypted Armored Encrypted file (PGP)

asd application/astound Autosave file (Word for Windows)

asm PC ASM File

asn application/astound

etc.

Happy customizing, implementing and modifying! If you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

About The Author

Boris Makushkin is Lead Software Developer in Alba Spectrum Technologies – USA nationwide Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, Boston, San Francisco, San Diego, Los Angeles, Houston, Dallas, Atlanta, Miami, Montreal, Toronto, Vancouver, Moscow and Europe and internationally (www.albaspectrum.com), he is Microsoft CRM SDK, C#, VB.Net, SQL, Oracle, Unix developer.

borism@albaspectrum.com

broadband satellite internet

Brodcast On the Net - streaming video, streaming audio, video conferencing, audio
Broadcast On the Net. If you are running a search for video conferencing and are looking for audio streaming or video streaminng and web conferenceing then you have come to the proper place. You can find many of the finest sites with the best conferencing services. Even find video studios or maybe the video talent to produce your program, no matter what you are looking for you can see the best streaming media here.
Brodcast On the Net - streaming video, streaming audio, video conferencing, audio

Until recently, people used a technique called symmetric key cryptography to secure information being transmitted across public networks in order to make broadband satellite internet shopping more secure. This method involves encrypting and decrypting a broadband satellite internet message using the same key, which must be known to both parties in order to keep it private. The key is passed from one party to the other in a separate transmission, making it vulnerable to being stolen as it is passed along.

With public-key cryptography, separate keys are used to encrypt and decrypt a message, so that nothing but the encrypted message needs to be passed along. Each party in a broadband satellite internet transaction has a *key pair* which consists of two keys with a particular relationship that allows one to encrypt a message that the other can decrypt. One of these keys is made publicly available and the other is a private key. A broadband satellite internet order encrypted with a person's public key can't be decrypted with that same key, but can be decrypted with the private key that corresponds to it. If you sign a transaction with your bank using your private key, the bank can read it with your corresponding public key and know that only you could have sent it. This is the equivalent of a digital signature. While this takes the risk out of broadband satellite internet transactions if can be quite fiddly. Our recommended provider listed below makes it all much simpler.

Broadcast On the Net Index

Main Menu
Broadcast On the Net
Site Map

Affiliate Ads, Links, news, etc.

News for 21-Jul-24

Source: BBC News - Home
Kabul nights

Source: BBC News - Home
Adrenaline and exhaustion

Source: BBC News - Home
Sri Lankan court acquits five men in Tamil MP murder trial

Source: BBC News - Home
David Moyes: Manchester United's great traditions have gone says Sunderland boss

Source: BBC News - Home
All heart

Source: BBC News - Home
Berlin truck attacker Anis Amri killed in Milan

Source: BBC News - Home
How phones changed the imagery of the American campaign

Source: BBC News - Home
British astronaut Piers Sellers dies

Source: BBC News - Home
British passenger missing from Queen Mary 2 liner

Source: BBC News - Home
The longest kiss

Links
Links
Links

Fantasy Football Strategies Take It Correctly Internet Meetings