DocMaster - SharePoint Document Library Sync Tool

-
DocMaster is a handy tool to sync SharePoint Document Libraries Between Sites/Servers. I have used SharePoint Copy Web Service to perform this task. So, it will work on any PC with .NET Framework 2.0 installed. But, you may have to configure the config file according to your SharePoint resources.
 
Config File Settings:
 
<?xml version="1.0" encoding="utf-8" ?>

<configuration>

<configSections>

<sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" >

<section name="DocMaster.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />

</sectionGroup>

</configSections>

<appSettings>

<add key="SourceURL" value="http://dcftsd1" />

<add key="SourceLibrary" value="Shared Documents" />

<add key="DestinationURL" value="http://dcftsd1" />

<add key="DestinationLibrary" value="Policy" />

</appSettings>

<applicationSettings>

<DocMaster.Properties.Settings>

<setting name="DocMaster_SourceList_Lists" serializeAs="String">

<value>http://dcftsd1/_vti_bin/lists.asmx</value>

</setting>

<setting name="DocMaster_DestList_Lists" serializeAs="String">

<value>http://dcftsd1/_vti_bin/lists.asmx</value>

</setting>

<setting name="DocMaster_CopyService_Copy" serializeAs="String">

<value>http://dcftsd1/_vti_bin/copy.asmx</value>

</setting>

</DocMaster.Properties.Settings>

</applicationSettings>

</configuration>

There are basically 2 Main Functions:

private void uploadFiles()

{

try

{

this.listBox1.Items.Add("===============================================");

this.listBox1.Items.Add("Uploading Document Library: " + sourceList);

this.listBox1.Items.Add("===============================================");

this.listBox1.Refresh();

using (SourceList.Lists sourceListService = new SourceList.Lists())

{

using (DestList.Lists destListService = new DestList.Lists())

{

sourceListService.PreAuthenticate = false;

sourceListService.Credentials = System.Net.CredentialCache.DefaultCredentials;

destListService.PreAuthenticate = false;

destListService.Credentials = System.Net.CredentialCache.DefaultCredentials;

XmlDocument xmlDoc = new System.Xml.XmlDocument();

XmlNode ndQuery = xmlDoc.CreateNode(XmlNodeType.Element, "Query", "");

XmlNode ndViewFields = xmlDoc.CreateNode(XmlNodeType.Element, "ViewFields", "");

XmlNode ndQueryOptions = xmlDoc.CreateNode(XmlNodeType.Element, "QueryOptions", "");

try

{

ndQueryOptions.InnerXml = "<IncludeAttachmentUrls>TRUE</IncludeAttachmentUrls>";

ndViewFields.InnerXml = "";

ndQuery.InnerXml = "";

XmlNode sourceItemData = sourceListService.GetListItems(sourceList, null, ndQuery, ndViewFields, null, ndQueryOptions, null);

XmlNodeList oNodes = sourceItemData.ChildNodes;

foreach (XmlNode node in oNodes)

{

XmlNodeReader objReader = new XmlNodeReader(node);

while (objReader.Read())

{

if (objReader["ows_EncodedAbsUrl"] != null && objReader["ows_LinkFilename"] != null)

{

string strURL = objReader["ows_EncodedAbsUrl"].ToString();

string strFileName = objReader["ows_LinkFilename"].ToString();

this.listBox1.Items.Add("Uploading File: " + strFileName);

this.listBox1.Refresh();

string destFilePath = destURL + "/" + destList + "/" + strFileName;

UploadAttachment(strURL, destFilePath);

}

}

}

}

catch (SoapException ex)

{

this.listBox1.Items.Add("Message:\n" + ex.Message + "\nDetail:\n" + ex.Detail.InnerText + "\nStackTrace:\n" + ex.StackTrace);

this.listBox1.Refresh();

}

}

}

}

catch (Exception ex)

{

using (System.IO.StreamWriter str = new System.IO.StreamWriter("ErrorLog_" + System.DateTime.Now.ToString().Replace(":", "_").Replace(@"/", "_") + ".log"))

{

str.WriteLine("Message:->\n" + ex.Message + "\nStackTrace:->\n" + ex.StackTrace, "CruiseCradle");

}

this.listBox1.Items.Add("Message:->\n" + ex.Message + "\nStackTrace:->\n" + ex.StackTrace);

this.listBox1.Refresh();

}

}

private void UploadAttachment(string copySource, string destFilePath)

{

HttpWebRequest request;

HttpWebResponse response = null;

try

{

using (CopyService.Copy myCopyService = new CopyService.Copy())

{

string[] copyDest = { destFilePath };

myCopyService.Credentials = System.Net.CredentialCache.DefaultCredentials;

CopyService.FieldInformation myFieldInfo = new

CopyService.FieldInformation();

CopyService.FieldInformation[] myFieldInfoArray = { myFieldInfo };

byte[] myByteArray;

uint myGetUint = myCopyService.GetItem(copySource, out myFieldInfoArray, out myByteArray);

CopyService.CopyResult myCopyResult1 = new CopyService.CopyResult();

CopyService.CopyResult myCopyResult2 = new CopyService.CopyResult();

CopyService.CopyResult[] myCopyResultArray = { myCopyResult1, myCopyResult2 };

try

{

uint myCopyUint = myCopyService.CopyIntoItems(copySource, copyDest, myFieldInfoArray, myByteArray, out myCopyResultArray);

if (myCopyUint == 0)

{

int idx = 0;

foreach (CopyService.CopyResult myCopyResult in myCopyResultArray)

{

string opString = (idx + 1).ToString();

if (myCopyResultArray[idx].ErrorMessage == null)

{

this.listBox1.Items.Add("Copy operation completed.\r\n" + "Destination: " +

myCopyResultArray[idx].DestinationUrl);

this.listBox1.Refresh();

}

else

{

this.listBox1.Items.Add("Copy operation failed.\r\n" + "Error: " +

myCopyResultArray[idx].ErrorMessage + "\r\n" +

"Code: " + myCopyResultArray[idx].ErrorCode);

this.listBox1.Refresh();

}

idx++;

}

}

}

catch (Exception exc)

{

int idx = 0;

foreach (CopyService.CopyResult myCopyResult in myCopyResultArray)

{

idx++;

if (myCopyResult.DestinationUrl == null)

{

string idxString = idx.ToString();

this.listBox1.Items.Add("Copy operation failed.\r\n" + "Description: " + exc.Message);

this.listBox1.Refresh();

}

}

}

}

}

catch (Exception ex)

{

this.listBox1.Items.Add(ex.Message);

}

}

Download Link: http://docmaster.codeplex.com/

Comments

Post a Comment

Popular posts from this blog

How to Create SSRS Report on SharePoint List

-
Image
There is fairly an easy way to create a SSRS report on SharePoint List. By using an XML data source, we will get access to the SharePoint List. Then, create your own CAML query to manipulate SharePoint List Data. Here is the step by step example of creating SQL Reporting Services report on SharePoint List.   1. Create a Report Server Project in Visual Studio   2. Add a Data Source with following info types:   - Name : Should be the Data Source Name   - Type : XML   - Connection String : Should be the SharePoint Web Service for SharePoint List     [Example: http://myintranet/ts/FazlulsWorld/_vti_bin/lists.asmx ]   - Credentials: Windows Authentication or choose appropriate radio button   3. Add a New Report:   - Select Shared Data Source that you just created   - Paste the CAML Query into the Query String. You may have to find out the GUID for the SharePoint List and View on which you are re...
Read more

Database Testing With DBUnit

-
Image
DBUnit is an Open Source Database Testing Framework which was created by Manuel Laflamme. DBUnit is a Database Unit Testing Framework to Test Database Driven Classes, Procedures or Functions. NUnit, MVC .NET/Visual Studio testing platforms can be used to build a standard unit test suite. Developer should create a dataset, defined within an XML file, and then extends one of a number of parent classes to inherit pre-defined functionality in order to use the framework. An IDbConnection implementation to connect to the database, then DbUnit.NET can be used to test the data access code. Following Operations can be performed using DBUnit: UPDATE TRUNCATE INSERT REFRESH DELETE CLEAN_INSERT DELETE_ALL NONE Other Operations: Composite Operation Transaction Operation Identity Insert Operation DBUnit Support Databases: OracleDatabase MsSQL MySQL IbmDB2 IbmInformix H2 HypersonicSQL PostgreSQL SybaseSQL InterBase OpenBase8 SapDB/MaxDB Derby FrontBase HOW TO WRITE A DBUnit TEST CASE ? To create a ...
Read more

SAP RFC Integration through BizTalk

-
Image
It has been a long while since I published some technical write-ups into my blog. Today, I will try to elaborate on Integration mechanism with SAP though BizTalk middleware. As you are aware, SAP is a self-contained and modular system. So, communicating with SAP is a complex process. You have to have basic understanding of SAP Modules and Data Query/Retrieval process. But, communicating to SAP through RFC function calls has made it even easier. You can communicate with SAP RFCs in three different ways: 1.     Access SAP RFCs using WCF-SAP Adapter and SAP system credentials 2.     Access SAF RFCs through exposed RFCs as ABAP web services 3.     Access SAF RFCs through SAP Process Orchestrator, which is basically the SAP integration middleware Today, I will concentrate on No. 2, which is to communicate with SAP through RFC Web Services via ABAP web services. To do that, you need to expose SAP RFCs as consumable web services. Please follow THIS to expose RFCs as ...
Read more