Knowledge-Ideas-Solutions-Fixes

How to run queries in Oracle Using SQL*Plus

2011-12-09T07:22:00.000-08:00

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

2011-12-09T04:28:00.001-08:00

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

2011-12-02T05:30:00.000-08:00

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

2011-11-16T08:08:00.000-08:00

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

2011-10-11T11:45:00.001-07:00

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

SharePoint Newbies - List GUID, View GUID

2011-10-04T11:38:00.000-07:00

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

2011-09-20T11:18:00.001-07:00

SLAM @ Codeplex.

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

Technical diagrams (SharePoint Server 2010)

2011-09-16T05:52:00.001-07:00

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

Connect Oracle Web Services from SharePoint

2011-09-12T10:59:00.001-07:00

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

PDF Printer

2011-09-02T09:51:00.001-07:00

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

List of SP webservices

2011-09-02T06:20:00.001-07:00

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

SharePoint Excel Web Service

2011-08-23T16:45:00.000-07:00

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

2011-08-11T13:59:00.000-07:00

Experience The Creativity

Java/PHP - Integration With SharePoint

2011-08-11T10:30:00.000-07:00

David's IT Blog

JQuery : Hide SharePoint Field with Specific Comments -

2011-08-04T08:46:00.000-07:00

SharePoint LogViewer - View ULS logs the easy and efficient way

2011-07-18T13:13:00.000-07:00

SharePoint LogViewer - View ULS logs the easy and efficient way

Code to Create SharePoint views Programatically using SP WebService

2011-07-08T07:53:00.000-07:00

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

2011-07-06T13:17:00.000-07:00

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

2011-07-05T20:39:00.000-07:00

Round pic

Test WebService

2011-06-20T12:45:00.001-07:00

http://webservicestudio.codeplex.com/

Adjust column size

2011-06-08T09:13:00.000-07:00

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

HTML TABLE SORT

2011-06-07T06:03:00.001-07:00

http://tablesorter.com/docs/

SharePoint - Hide User field in Edit form using JQuery

2011-06-06T11:16:00.001-07:00

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

Nintex Workflow - Installtion issue

2011-05-27T08:05:00.000-07:00

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

2011-05-25T13:36:00.000-07:00

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