 WebProWorld
IT Forum |
The best router is......?
I'm considering buying a dsl router, as I'm getting fed-up of the standard ICS networking (i.e. ports get block on my lan even if I use port-forwarding on my firewall)...
Deleted Files Hanging
Ok, ever since I upgraded my computer a bit, I've been having problems with OE where it gets errors that have nothing to do with my server or ISP. It seems when there are too many e-mail windows open, it crashes & I have to shut everything down...
dns transfer question
I have my main domain used as nameservers on a shared hosting server. Now, I decided to get it its own server (dedicated) but obviously I will not move the ns1/ns2 to the new server and cause downtime for everyone else.
|
|
|
01.05.05
Siebel Email Attachments Import - C# And MS Transact SQL Example
 By Boris Makushkin
Microsoft CRM - CRM's answer from Microsoft Business Solutions has an aggressive pricing, going down and making it affordable for small companies.
We see cases when Microsoft CRM replaces such traditional CRM systems as Siebel. It is not necessary, that clients decided to replace it themselves - they may be victims of their systems - the example: Great Plains had alliance with Siebel several years ago and we saw multiple clients with Great Plains - Siebel tandem. Now Great Plains integrates with MS CRM.
This article is for programmer, who needs data to be migrated from Siebel or other CRM to MS CRM.
Today's topic is Siebel emails, stored in the files, import into MS CRM database. Each message exists in the form of separate file in the import directory. We will use custom SQL table, created in MS SQL Server 2000:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CrmAttachImporter]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CrmAttachImporter]
GO
CREATE TABLE [dbo].[CrmAttachImporter] (
[Id] uniqueidentifier ROWGUIDCOL NOT NULL ,
[CrmActivityGuid] [varchar] (50) NOT NULL ,
[MsgFileName] [varchar] (2000) NOT NULL
) ON [PRIMARY]
GO
Comments to this table - its goal is storing MS CRM activity GUID relationship to file name with email attachment (email message), which needs to be attached to the activity. We will store activity GUID in the field CrmActivityGuid and file name in the import directory of the attachment in the MsgFileName field.
Configuration file for our utility will be the following:
<config>
<connectionString>provider=SQLOLEDB;Initial Catalog=Albaspectrum;Data Source=MSSQL1;User Id=sa;Password=sa;</connectionString>
<msgFolder>data</msgFolder>
<tableName>CrmAttachImporter</tableName>
<activityGuidColumn>CrmActivityGuid</activityGuidColumn>
<msgFileNameColumn>MsgFileName</msgFileNameColumn>
</config>
Here we described MS SQL Server connection string, the path to messages-files in the file system, table name, which stores the relations Activity GUID and file names, table column names, required for import procedure.
To control the import process we will use free logging library for .NET: log4net. You can get it here: http://logging.apache.org/log4net/
Let's look at the method of potential attachments catalog scanning:
public void scanFolder() {
log = LogManager.GetLogger(typeof(AttachImporter));
DOMConfigurator.Configure(new FileInfo("log.config"));
try {
DirectoryInfo dirInfo = new DirectoryInfo(msgFolder);
FileInfo[] files = dirInfo.GetFiles();
Hashtable emails = new Hashtable();
foreach (FileInfo fileInfo in files) {
log.Debug("Analizing file: " + fileInfo.Name);
Guid activityId = GetActivityIdByFileName(fileInfo.Name);
if (! activityId.ToString().Equals(new Guid().ToString())) {
emails.Add(activityId, fileInfo.DirectoryName + @"\" + fileInfo.Name);
Console.WriteLine("Marked for import: " + fileInfo.Name);
log.Debug("Marked for import: " + fileInfo.Name);
}
else {
Console.WriteLine("Not found in activity import list: " + fileInfo.Name);
log.Debug("Not found in activity import list: " + fileInfo.Name);
}
}
ProcessMessages(emails);
}
catch (Exception e) {
Console.WriteLine(e.Message + "\r\n" + e.StackTrace);
}
}
Read the Rest of the Article.
About the Author:
Boris Makushkin is senior software developer in Alba Spectrum Technologies – US nation-wide Great Plains, Microsoft CRM customization company, based in Chicago and having locations in multiple states and internationally (www.albaspectrum.com ), he is Unix, SQL, C#.Net, Crystal Reports, Microsoft CRM SDK and Exchange Server SDK developer. You can reach Boris: borism@albaspectrum.com |
