How to run queries in Oracle Using SQL*Plus

How to run queries in Oracle Using SQL*Plus

1. Install oracle client latest version from http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_client.zip

2. Please try to install maximum components you can while installation

3. Open SQL*Plus from Programs OR run SQLPLUS command from command prompt. See image below. Image given below is self describing further steps.

SP2010 + VS2010

http://blog.raminassar.com/2011/10/14/working-with-sharepoint-2010-projects-on-visual-studio-without-installing-the-server/

http://blog.raminassar.com/2011/11/23/remotly-working-and-debugging-sharepoint-2010-solutions/

Connect Oracle with SharePoint/SQL using SSIS

Using the Microsoft Connector for Oracle by Attunity with SQL Server 2008 Integration Services

http://msdn.microsoft.com/en-us/library/ee470675(v=sql.100).aspx

Microsoft Connectors for Oracle and Teradata by Attunity

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=11180

Get Free Remote Server

http://www.cloudshare.com/

The trial period is of 15 days. However this is really good service.

Change Data Capture (CDC) in SQL Server 2008

http://www.mssqltips.com/sqlservertip/1474/using-change-data-capture-cdc-in-sql-server-2008/

SharePoint Newbies - List GUID, View GUID

To find list GUID -

- Go to “all sites content” - http://sitename/sites/webname/_layouts/viewlsts.aspx

- Click on any list (For ex. ListName) - http://sitename/sites/webname/Lists/ListName/AllItems.aspx

- Click on List Setting – As shown in Figure 1

- Page will be redirect to List Settings. Please see the URL there. You will find List GUID there – See Figure 2 and URL http://sitename/sites/webname/_layouts/listedit.aspx?List={2E9DD63B-0D31-4059-B5FE-AAA299E709F1}

To find View GUID –

- After getting List GUID in the url of setting page, just scroll down a bit on the same page. You should be able to find views section. (See Figure 3)

- Click on any of the view name you want to find GUID for. (See Figure 3)

- You will be redirect to “Edit View” page. Please check the URL on that page. It will look similar like as given below-

http://sitename/sites/webname/_layouts/ViewEdit.aspx?List=%7B2E9DD63B%2D0D31%2D4059%2DB5FE%2DAAA299E709F1%7D&View=%7B49311C81%2D0868%2D4638%2D892D%2DDE2AA53A7411%7D

- In above url, the string after text “View=” is view GUID. - %7B49311C81%2D0868%2D4638%2D892D%2DDE2AA53A7411%7D

- Here view GUID is encoded url. To decode, just replace “%7B” with “{“ ,“%7D” with “}” and replace all “%2D” with “–“).

- You will get GUID looks like- {49311C81-0868-4638-892D-DE2AA53A7411}. This is View GUID

Tool to copy SharePoint List Data to SQL table - SLAM

SLAM @ Codeplex.

http://slam.codeplex.com/wikipage?title=Getting%20Started&referringTitle=Home

Technical diagrams (SharePoint Server 2010)

http://technet.microsoft.com/en-us/library/cc263199.aspx

Connect Oracle Web Services from SharePoint

http://underthehood.ironworks.com/2010/01/why-doesnt-my-generated-proxy-class-build-wsse-elements-into-the-soap-request-header.html

PDF Printer

http://www.bullzip.com/products/pdf/info.php#download

List of SP webservices

http://www.infoq.com/articles/swanson-moss-web-services

SharePoint Excel Web Service

Excel Web Service

Get Workbook using excel web service –

http://msdn.microsoft.com/en-us/library/ms519570(v=office.12).aspx

Save Workbook –

http://msdn.microsoft.com/en-us/library/ms575918(v=office.12).aspx

Use it as required in SSRS/SSIS

SharePoint Excel web Service URL - http://SiteURL/sites/WEBName/_vti_bin/excelservice.asmx

SharePoint + Android

Experience The Creativity

Java/PHP - Integration With SharePoint

David's IT Blog

JQuery : Hide SharePoint Field with Specific Comments -

<script type="text/javascript" src="_layouts/Server/jQuery/jquery-1.4.2.js"></script>

<script type="text/javascript" src="_layouts/Server/jQuery/jquery-1.3.2.min.js"></script>
<script type="text/javascript" src="_layouts/Server/jQuery/jquery.SPServices-0.5.8.min.js"></script>

<script type="text/javascript" language="javascript" >


$(document).ready(function(){

$("td.ms-formbody").each(function () {
if (this.innerText.indexOf("For Admins Only") > 0) {

$(this).parent().hide();
}
else
{

}
});

});

</script>

SharePoint LogViewer - View ULS logs the easy and efficient way

SharePoint LogViewer - View ULS logs the easy and efficient way

Code to Create SharePoint views Programatically using SP WebService

public void CreateView(string strCategory)
{
WRCreateView.Views objCreateViews = new CreateViews.WRCreateView.Views();
objCreateViews.Url = "http://Sitename.net/sites/SiteCol/_vti_bin/views.asmx";

NetworkCredential netcred = new NetworkCredential("MyUserName", "MyPassword", "MyDomain");

objCreateViews.Credentials = netcred;

string strQuery = " " + strCategory + "";

string strRowLimit = "100";

string strViewFields = "";



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

System.Xml.XmlNode ndQuery = xmlDoc.CreateNode(XmlNodeType.Element, "Query", "");
System.Xml.XmlNode ndRowLimit = xmlDoc.CreateNode(XmlNodeType.Element, "RowLimit", "");
System.Xml.XmlNode ndViewFields = xmlDoc.CreateNode(XmlNodeType.Element, "ViewFields", "");

ndQuery.InnerXml = strQuery;
ndRowLimit.InnerXml = strRowLimit;
ndViewFields.InnerXml = strViewFields;

XmlNode retNode = objCreateViews.AddView("{794D4A54-960D-2322-1234-B6A672927FB7}", strCategory, ndViewFields, ndQuery, ndRowLimit, "HTML", false);

//XmlNode xmln = objCreateViews.GetView("{794D4A54-960D-47FA-1234-B6A672927FB7}", "{44F80DED-1235-485B-9B47-3EB2FDD797B1}");
}

Programmatically start workflow

Steven Van de Craen's Blog - Programmatically start workflow: "Guid wfBaseId = new Guid('{6BE0ED92-BB12-4F8F-9687-E12DC927E4AD}');
SPSite site = ...;
SPWeb web = site.OpenWeb();
SPList list = web.Lists['listname'];
SPListItem item = list.Items[0];
SPWorkflowAssociation associationTemplate= list.WorkflowAssociations.GetAssociationByBaseID(wfBaseId);
site.WorkflowManager.StartWorkflow(item, associationTemplate, '');"

Round Pic

Round pic

Test WebService

http://webservicestudio.codeplex.com/

Adjust column size

.ms-vh2 div table tr td
{
white-space: normal
}

HTML TABLE SORT

http://tablesorter.com/docs/

SharePoint - Hide User field in Edit form using JQuery

$("nobr:contains('User')").parent().parent().parent().hide();

Nintex Workflow - Installtion issue

Not able to find Nintex Workflow Management section in Central admin.

After successful installation some SP versions dont enable features automatically. It should be done manually by using following command

1. "stsadm.exe -o installfeature -name nintexworkflowadmin -force"

Operation completed successfully.


2. stsadm.exe -o activatefeature -name nintexworkflowadmin -url http://CentralAdminWebsite:29638 -force

Operation completed successfully.

Thumbnails in SharePoint

http://www.codeproject.com/KB/sharepoint/linkimagewp.aspx