if you are getting the following error while deleting solution: The solution cannot be removed when a job is scheduled or running, that means your solution got corrupted while deployment and it is not retractable.
Even if you will see under operation in Central Administration( under "Solution Management"), it will not give you option to retract and it will show error without detail.
Here is the solution to remove corrupted soltuion from sharepoint 2007:
step-1:
get the job id using enumdeployments
stsadm -o enumdeployments
i.e. job id(2529c788-971c-46a3-b69f-a2a0a1fcc851)
step-2:
cancel deployment using job id
stsadm -o canceldeployment -id 2529c788-971c-46a3-b69f-a2a0a1fcc851
step-3:
once job id in step 2 is canceled than retract solution
stsadm -o retractsolution "Yoursolution.wsp" -immediate
step-4:
once retract is completed than delete solution
stsadm -o deletesolution "Yoursolution.wsp" -override
enjoy green coding using free www.code4green.com site
Wednesday, December 29, 2010
Tuesday, October 26, 2010
SQL Query To Find out which site template had been used to create a site
Another SQL Query for WSS_Content / sharepoint / Moss database
Find out which site template had been used to create a site entitled
SELECT Title, WebTemplate, ProvisionConfig
FROM dbo.Webs
WHERE Title='Give your siteName'
Enjoy Green coding....
Keep looking for the Free Sharepoint SQL eBook on code4green.com
Find out which site template had been used to create a site entitled
SELECT Title, WebTemplate, ProvisionConfig
FROM dbo.Webs
WHERE Title='Give your siteName
Enjoy Green coding....
Keep looking for the Free Sharepoint SQL eBook on code4green.com
Basic SharePoint's tables in Content Database
Here is the list of the basic SharePoint's tables in Content Database
Features: information about all the activated features for each site collection or site.
Sites : information about all the site collections for this content database.
Webs : information about all the specific sites (webs) in each site collection.
UserInfo : information about all the users for each site collection.
Groups : information about all the SharePoint groups in each site collection.
Roles : information about all the SharePoint roles (permission levels) for each site.
AllLists : information about lists for each site.
GroupMembership : information about all the SharePoint group members.
AllUserData : information about all the list items for each list.
AllDocs : information about all the documents (and all list items) for each document library and list.
RoleAssignment : information about all the users or SharePoint groups that are assigned to roles.
SchedSubscriptions : information about all the scheduled subscriptions (alerts) for each user. ImmedSubscriptions : information about all the immediate subscriptions (alerts) for each user.
Enjoy Green coding using code4green.com
Features: information about all the activated features for each site collection or site.
Sites : information about all the site collections for this content database.
Webs : information about all the specific sites (webs) in each site collection.
UserInfo : information about all the users for each site collection.
Groups : information about all the SharePoint groups in each site collection.
Roles : information about all the SharePoint roles (permission levels) for each site.
AllLists : information about lists for each site.
GroupMembership : information about all the SharePoint group members.
AllUserData : information about all the list items for each list.
AllDocs : information about all the documents (and all list items) for each document library and list.
RoleAssignment : information about all the users or SharePoint groups that are assigned to roles.
SchedSubscriptions : information about all the scheduled subscriptions (alerts) for each user. ImmedSubscriptions : information about all the immediate subscriptions (alerts) for each user.
Enjoy Green coding using code4green.com
SQL Queries For Sharepoint's Content Database
Here is the List of some most important SQL Queries for sharepoint/moss's content database:
1. Query to get all the top level site collections
SELECT SiteId AS SiteGuid, Id AS WebGuid, FullUrl AS Url, Title, Author, TimeCreated
FROM dbo.Webs
WHERE (ParentWebId IS NULL)
2. Query to get all the child sites in a site collection
SELECT SiteId AS SiteGuid, Id AS WebGuid, FullUrl AS Url, Title, Author, TimeCreated
FROM dbo.Webs
WHERE (NOT (ParentWebId IS NULL))
3. Query to get all the SharePoint groups in a site collection
SELECT dbo.Webs.SiteId, dbo.Webs.Id, dbo.Webs.FullUrl, dbo.Webs.Title, dbo.Groups.ID AS Expr1,
dbo.Groups.Title AS Expr2, dbo.Groups.Description
FROM dbo.Groups INNER JOIN
dbo.Webs ON dbo.Groups.SiteId = dbo.Webs.SiteId
4. Query to get all the users in a site collection
SELECT dbo.Webs.SiteId, dbo.Webs.Id, dbo.Webs.FullUrl, dbo.Webs.Title, dbo.UserInfo.tp_ID,
dbo.UserInfo.tp_DomainGroup, dbo.UserInfo.tp_SiteAdmin, dbo.UserInfo.tp_Title, dbo.UserInfo.tp_Email
FROM dbo.UserInfo INNER JOIN
dbo.Webs ON dbo.UserInfo.tp_SiteID = dbo.Webs.SiteId
5. Query to get all the members of the SharePoint Groups
SELECT dbo.Groups.ID, dbo.Groups.Title, dbo.UserInfo.tp_Title, dbo.UserInfo.tp_Login
FROM dbo.GroupMembership INNER JOIN
dbo.Groups ON dbo.GroupMembership.SiteId = dbo.Groups.SiteId INNER JOIN
dbo.UserInfo ON dbo.GroupMembership.MemberId = dbo.UserInfo.tp_ID
6. Query to get all the sites where a specific feature is activated
SELECT dbo.Webs.Id AS WebGuid, dbo.Webs.Title AS WebTitle, dbo.Webs.FullUrl AS WebUrl, dbo.Features.FeatureId,
dbo.Features.TimeActivated
FROM dbo.Features INNER JOIN
dbo.Webs ON dbo.Features.SiteId = dbo.Webs.SiteId AND dbo.Features.WebId = dbo.Webs.Id
WHERE (dbo.Features.FeatureId = '00BFEA71-D1CE-42de-9C63-A44004CE0104')
7. Query to get all the users assigned to roles
SELECT dbo.Webs.Id, dbo.Webs.Title, dbo.Webs.FullUrl, dbo.Roles.RoleId, dbo.Roles.Title AS RoleTitle,
dbo.UserInfo.tp_Title, dbo.UserInfo.tp_Login
FROM dbo.RoleAssignment INNER JOIN
dbo.Roles ON dbo.RoleAssignment.SiteId = dbo.Roles.SiteId AND
dbo.RoleAssignment.RoleId = dbo.Roles.RoleId INNER JOIN
dbo.Webs ON dbo.Roles.SiteId = dbo.Webs.SiteId AND dbo.Roles.WebId = dbo.Webs.Id INNER JOIN
dbo.UserInfo ON dbo.RoleAssignment.PrincipalId = dbo.UserInfo.tp_ID
8. Query to get all the SharePoint groups assigned to roles
SELECT dbo.Webs.Id, dbo.Webs.Title, dbo.Webs.FullUrl, dbo.Roles.RoleId, dbo.Roles.Title AS RoleTitle,
dbo.Groups.Title AS GroupName
FROM dbo.RoleAssignment INNER JOIN
dbo.Roles ON dbo.RoleAssignment.SiteId = dbo.Roles.SiteId AND
dbo.RoleAssignment.RoleId = dbo.Roles.RoleId INNER JOIN
dbo.Webs ON dbo.Roles.SiteId = dbo.Webs.SiteId AND dbo.Roles.WebId = dbo.Webs.Id INNER JOIN
dbo.Groups ON dbo.RoleAssignment.SiteId = dbo.Groups.SiteId AND
dbo.RoleAssignment.PrincipalId = dbo.Groups.ID
Thank you Ethan. For more Sharepoint's content database related topics please visit Ethan's blog: http://vspug.com/ethan/
Enjoy Green coding
1. Query to get all the top level site collections
SELECT SiteId AS SiteGuid, Id AS WebGuid, FullUrl AS Url, Title, Author, TimeCreated
FROM dbo.Webs
WHERE (ParentWebId IS NULL)
2. Query to get all the child sites in a site collection
SELECT SiteId AS SiteGuid, Id AS WebGuid, FullUrl AS Url, Title, Author, TimeCreated
FROM dbo.Webs
WHERE (NOT (ParentWebId IS NULL))
3. Query to get all the SharePoint groups in a site collection
SELECT dbo.Webs.SiteId, dbo.Webs.Id, dbo.Webs.FullUrl, dbo.Webs.Title, dbo.Groups.ID AS Expr1,
dbo.Groups.Title AS Expr2, dbo.Groups.Description
FROM dbo.Groups INNER JOIN
dbo.Webs ON dbo.Groups.SiteId = dbo.Webs.SiteId
4. Query to get all the users in a site collection
SELECT dbo.Webs.SiteId, dbo.Webs.Id, dbo.Webs.FullUrl, dbo.Webs.Title, dbo.UserInfo.tp_ID,
dbo.UserInfo.tp_DomainGroup, dbo.UserInfo.tp_SiteAdmin, dbo.UserInfo.tp_Title, dbo.UserInfo.tp_Email
FROM dbo.UserInfo INNER JOIN
dbo.Webs ON dbo.UserInfo.tp_SiteID = dbo.Webs.SiteId
5. Query to get all the members of the SharePoint Groups
SELECT dbo.Groups.ID, dbo.Groups.Title, dbo.UserInfo.tp_Title, dbo.UserInfo.tp_Login
FROM dbo.GroupMembership INNER JOIN
dbo.Groups ON dbo.GroupMembership.SiteId = dbo.Groups.SiteId INNER JOIN
dbo.UserInfo ON dbo.GroupMembership.MemberId = dbo.UserInfo.tp_ID
6. Query to get all the sites where a specific feature is activated
SELECT dbo.Webs.Id AS WebGuid, dbo.Webs.Title AS WebTitle, dbo.Webs.FullUrl AS WebUrl, dbo.Features.FeatureId,
dbo.Features.TimeActivated
FROM dbo.Features INNER JOIN
dbo.Webs ON dbo.Features.SiteId = dbo.Webs.SiteId AND dbo.Features.WebId = dbo.Webs.Id
WHERE (dbo.Features.FeatureId = '00BFEA71-D1CE-42de-9C63-A44004CE0104')
7. Query to get all the users assigned to roles
SELECT dbo.Webs.Id, dbo.Webs.Title, dbo.Webs.FullUrl, dbo.Roles.RoleId, dbo.Roles.Title AS RoleTitle,
dbo.UserInfo.tp_Title, dbo.UserInfo.tp_Login
FROM dbo.RoleAssignment INNER JOIN
dbo.Roles ON dbo.RoleAssignment.SiteId = dbo.Roles.SiteId AND
dbo.RoleAssignment.RoleId = dbo.Roles.RoleId INNER JOIN
dbo.Webs ON dbo.Roles.SiteId = dbo.Webs.SiteId AND dbo.Roles.WebId = dbo.Webs.Id INNER JOIN
dbo.UserInfo ON dbo.RoleAssignment.PrincipalId = dbo.UserInfo.tp_ID
8. Query to get all the SharePoint groups assigned to roles
SELECT dbo.Webs.Id, dbo.Webs.Title, dbo.Webs.FullUrl, dbo.Roles.RoleId, dbo.Roles.Title AS RoleTitle,
dbo.Groups.Title AS GroupName
FROM dbo.RoleAssignment INNER JOIN
dbo.Roles ON dbo.RoleAssignment.SiteId = dbo.Roles.SiteId AND
dbo.RoleAssignment.RoleId = dbo.Roles.RoleId INNER JOIN
dbo.Webs ON dbo.Roles.SiteId = dbo.Webs.SiteId AND dbo.Roles.WebId = dbo.Webs.Id INNER JOIN
dbo.Groups ON dbo.RoleAssignment.SiteId = dbo.Groups.SiteId AND
dbo.RoleAssignment.PrincipalId = dbo.Groups.ID
Thank you Ethan. For more Sharepoint's content database related topics please visit Ethan's blog: http://vspug.com/ethan/
Enjoy Green coding
Tuesday, August 10, 2010
MOSS 2007 : Complete reference Guide for STSADM
Thank you Jose Barreto, you did once again a nice job.- stsadm -o activatefeature {-filename <relative path to Feature.xml>
-name <feature folder> -id <feature Id>} [-url <url>] [-force] - stsadm -o activateformtemplate -url <URL to the site collection>
[-formid <form template ID>] [-filename <path to form template file>] - stsadm -o addalternatedomain -url <protocol://existing.WebApplication.URLdomain>
-incomingurl <protocol://incoming.url.domain> -urlzone <default, extranet,
internet, intranet, custom> -resourcename <non-web application resource name> - stsadm -o addcontentdb -url <url> -databasename <database
name> [-databaseserver <database server name>] [-databaseuser <database
username>] [-databasepassword <database password>] [-sitewarning <site
warning count>] [-sitemax <site max count>] - stsadm -o adddataconnectionfile -filename <path to file to add>
[-webaccessible <bool>] [-overwrite <bool>] [-category <bool>] - stsadm -o add-ecsfiletrustedlocation -Ssp <SSP name> -Location
<URLUNC> -LocationType SharePointUncHttp -IncludeChildren TrueFalse [-SessionTimeout
<time in seconds>] [-ShortSessionTimeout <time in seconds>] [-MaxRequestDuration
<time in seconds>] [-MaxWorkbookSize <file size in Mbytes>] [-MaxChartSize
<size in Mbytes>] [-VolatileFunctionCacheLifetime <time in seconds>]
[-DefaultWorkbookCalcMode FileManualAutoAutoDataTables] [-AllowExternalData NoneDclDclAndEmbedded]
[-WarnOnDataRefresh TrueFalse] [-StopOpenOnRefreshFailure TrueFalse] [-PeriodicCacheLifetime
<time in seconds>] [-ManualCacheLifetime <time in seconds>] [-MaxConcurrentRequestsPerSession
<number of requests>] [-AllowUdfs TrueFalse] [-Description <descriptive
text>] - stsadm -o add-ecssafedataprovider -Ssp <SSP name> -ID <data
provider id> -Type OledbOdbcOdbcDsn [-Description <descriptive text>] - stsadm -o add-ecstrusteddataconnectionlibrary -Ssp <SSP name>
-Location <URL> [-Description <descriptive text>] - stsadm -o add-ecsuserdefinedfunction -Ssp <SSP name> -Assembly
<strong namefile path> -AssemblyLocation GACFile [-Enable TrueFalse] [-Description
<descriptive text>] - stsadm -o addexemptuseragent -name <user-agent to receive InfoPath
files instead of a Web page> - stsadm -o addpath -url <url> -type <explicitinclusion/wildcardinclusion>
- stsadm -o addpermissionpolicy -url <url> -userlogin <login
name> -permissionlevel <permission policy level> [-zone <URL zone>]
[-username <display name>] - stsadm -o addsolution -filename <Solution filename> [-lcid
<language>] - stsadm -o addtemplate -filename <template filename> -title
<template title> [-description <template description>] - stsadm -o adduser -url <url> -userlogin <DOMAIN\user>
-useremail <UserName@mail.com>
-role <role name> / -group <group name> -username <display name>
[-siteadmin] - stsadm -o addwppack -filename <Web Part Package filename>
[-lcid <language>] [-url <url>] [-globalinstall] [-force] [-nodeploy] - stsadm -o addwppack -name <name of Web Part Package>
[-lcid <language>] [-url <url>] [-globalinstall] [-force] - stsadm -o addzoneurl -url <protocol://existing.WebApplication.URLdomain>
-urlzone <default, extranet, internet, intranet, custom> -zonemappedurl <protocol://outgoing.url.domain>
-resourcename <non-web application resource name> - stsadm -o allowuserformwebserviceproxy -url <Url of the web
application> -enable <true to enable, false to disable> - stsadm -o allowwebserviceproxy -url <Url of the web application>
-enable <true to enable, false to disable> - stsadm -o associatewebapp -title <SSP name> [-default -parent]
-url <Web application 1 url,Web application 2 url> [-all] - stsadm -o authentication -url <url> -type <windows/forms/websso>
[-usebasic (valid only in windows authentication mode)] [-usewindowsintegrated (valid
only in windows authentication mode)] [-exclusivelyusentlm (valid only in windows
authentication mode)] [-membershipprovider <membership provider name>] [-rolemanager
<role manager name>] [-enableclientintegration] [-allowanonymous] - stsadm -o backup -url <url> -filename <filename> [-overwrite]
- stsadm -o backup -directory <UNC path> -backupmethod <full
differential> [-item <created path from tree>] [-percentage <integer
between 1 and 100>] [-backupthreads <integer between 1 and 10>] [-showtree]
[-quiet] - stsadm -o backuphistory -directory <UNC path> [-backup] [-restore]
- stsadm -o binddrservice -servicename <data retrieval service
name> -setting <data retrieval services setting> - stsadm -o blockedfilelist -extension <extension> -add [-url
<url>] - stsadm -o blockedfilelist -extension <extension> -delete
[-url <url>] - stsadm -o canceldeployment -id <id>
- stsadm -o changepermissionpolicy -url <url> -userlogin <DOMAIN\name>
[-zone <URL zone>] [-username <display name>] [{ -add -delete } -permissionlevel
<permission policy level>] - stsadm -o copyappbincontent
- stsadm -o createadminvs [-admapidname <app pool name>] [-admapidtype
<configurableid/NetworkService>] [-admapidlogin <DOMAIN\name>] [-admapidpwd
<app pool password>] - stsadm -o createcmsmigrationprofile -profilename <profile name>
[-description <description>] [-connectionstring <connection string>]
-databaseserver <server> -databasename <name> -databaseuser
<username> [-databasepassword <password>] [-auth windowsauthsqlauth]
-destination <url> [-rootchannel <channelname>] [-destinationlocale
<LCID>] [-migrateresources onlyusedall] [-migrateacls yesno] [-emailto <address1;address2>]
[-emailon successfailurenoneboth] [-keeptemporaryfiles NeverAlwaysFailure]
[-enableeventreceivers yesno] - stsadm -o creategroup -url <url> -name <group name>
-description <description> -ownerlogin <DOMAIN\name or group name> [-type
membervisitorowner] - stsadm -o createsite -url <url> -owneremail <UserName@mail.com> [-ownerlogin <DOMAIN\name>]
[-ownername <display name>] [-secondaryemail <UserName@mail.com>] [-secondarylogin
<DOMAIN\name>] [-secondaryname <display name>] [-lcid <language>]
[-sitetemplate <site template>] [-title <site title>] [-description
<site description>] [-hostheaderwebapplicationurl <web application url>]
[-quota <quota template>] - stsadm -o createsiteinnewdb -url <url> -owneremail <UserName@mail.com>
[-ownerlogin <DOMAIN\name>] [-ownername <display name>] [-secondaryemail
<UserName@mail.com>]
[-secondarylogin <DOMAIN\name>] [-secondaryname <display name>] [-lcid
<language>] [-sitetemplate <site template>] [-title <site title>]
[-description <site description>] [-hostheaderwebapplicationurl <web application
url>] [-quota <quota template>] [-databaseuser <database username>]
[-databasepassword <database password>] [-databaseserver <database server
name>] [-databasename <database name>] - stsadm -o createssp -title <SSP name> -url <Web application
url> -mysiteurl <MySite Web application url> -ssplogin <username>
-indexserver <index server> -indexlocation <index file path> [-ssppassword
<password>] [-sspdatabaseserver <SSP database server>] [-sspdatabasename
<SSP database name>] [-sspsqlauthlogin <SQL username>] [-sspsqlauthpassword
<SQL password>] [-searchdatabaseserver <search database server>] [-searchdatabasename
<search database name>] [-searchsqlauthlogin <SQL username>] [-searchsqlauthpassword
<SQL password>] [-ssl <yesno>] - stsadm -o createweb -url <url> [-lcid <language>] [-sitetemplate
<site template>] [-title <site title>] [-description <site description>]
[-convert] [-unique] - stsadm -o databaserepair -url <url> -databasename <database
name> [-deletecorruption] - stsadm -o deactivatefeature {-filename <relative path to Feature.xml>
-name <feature folder> -id <feature Id>} [-url <url>] [-force] - stsadm -o deactivateformtemplate -url <URL to the site collection>
[-formid <form template ID>] [-filename <path to form template file>] - stsadm -o deleteadminvs
- stsadm -o deletealternatedomain -url <ignored> -incomingurl
<protocol://incoming.url.domain> - stsadm -o deletecmsmigrationprofile -profilename <profile name>
- stsadm -o deleteconfigdb
- stsadm -o deletecontentdb -url <url> -databasename <database
name> [-databaseserver <database server name>] - stsadm -o deletegroup -url <url> -name <group name>
- stsadm -o deletepath -url <url>
- stsadm -o deletepermissionpolicy -url <url> -userlogin <login
name> [-zone <URL zone>] - stsadm -o deletesite -url <url> -deleteadaccounts <true/false>
- stsadm -o deletesolution -name <Solution name> [-override]
[-lcid <language>] - stsadm -o deletessp -title <SSP name> [-deletedatabases]
- stsadm -o deletessptimerjob -title <SSP Name> -jobid <SSP
Timer Job Id> - stsadm -o deletetemplate -title <template title> [-lcid <language>]
- stsadm -o deleteuser -url <url> -userlogin <DOMAIN\name>
[-group <group>] - stsadm -o deleteweb -url <url>
- stsadm -o deletewppack -name <name of Web Part Package> [-lcid
<language>] [-url <url>] - stsadm -o deletezoneurl -url <protocol://existing.WebApplication.URLdomain>
-urlzone <default, extranet, internet, intranet, custom> -resourcename <non-web
application resource name> - stsadm -o deploysolution -name <Solution name> [-url <virtual
server url>] [-allcontenturls] [-time <time to deploy at>] [-immediate]
[-local] [-allowgacdeployment] [-allowcaspolicies] [-lcid <language>] [-force] - stsadm -o deploywppack -name <Web Part Package name> [-url
<virtual server url>] [-time <time to deploy at>] [-immediate] [-local]
[-lcid <language>] [-globalinstall] [-force] - stsadm -o disablessc -url <url>
- stsadm -o displaysolution -name <Solution name>
- stsadm -o editcmsmigrationprofile -profilename <profile name>
[-description <description>] [-connectionstring <connection string>]
[-databaseserver <server>] [-databasename <name>] [-databaseuser <username>]
[-databasepassword <password>] [-auth sqlauthwindowsauth] [-emailto <address1;address2>]
[-emailon successfailurenoneboth] [-excludeschema ] [-keeptemporaryfiles NeverAlwaysFailure]
[-enableeventreceivers yesno] - stsadm -o editcontentdeploymentpath -pathname <path name>
[-keeptemporaryfiles NeverAlwaysFailure] [-enableeventreceivers yesno] [-enablecompression
yesno] - stsadm -o editssp -title <SSP name> [-newtitle <new SSP
name>] [-sspadminsite <administration site url>] [-ssplogin <username>]
[-ssppassword <password>] [-indexserver <index server>] [-indexlocation
<index file path>] [-setaccounts <process accounts (domain\username)>]
[-ssl <yesno>] - stsadm -o email -outsmtpserver <SMTP server> -fromaddress
<UserName@mail.com>
-replytoaddress <UserName@mail.com>
-codepage <codepage> [-url <url>] - stsadm -o enablecmsurlredirect -profilename <profile name>
-off - stsadm -o enablessc -url <url> [-requiresecondarycontact]
- stsadm -o enumalternatedomains -url <protocol://existing.WebApplication.URLdomain>
-resourcename <non-web application resource name> - stsadm -o enumcontentdbs -url <url>
- stsadm -o enumdataconnectionfiledependants -filename <filename
for which to enumerate dependants> - stsadm -o enumdataconnectionfiles [-mode <a u all unreferenced>]
- stsadm -o enumdeployments
- stsadm -o enumexemptuseragents
- stsadm -o enumformtemplates
- stsadm -o enumgroups -url <url>
- stsadm -o enumroles -url <url>
- stsadm -o enumservices
- stsadm -o enumsites -url <virtual server url> -showlocks
-redirectedsites - stsadm -o enumsolutions
- stsadm -o enumssp -title <SSP name> [-default -parent
-all] - stsadm -o enumssptimerjobs -title <SSP Name>
- stsadm -o enumsubwebs -url <url>
- stsadm -o enumtemplates [-lcid <language>]
- stsadm -o enumusers -url <url>
- stsadm -o enumwppacks [-name <name of Web Part Package>]
[-url <virtual server url>] [-farm] - stsadm -o enumzoneurls -url <protocol://existing.WebApplication.URLdomain>
-resourcename <non-web application resource name> - stsadm -o execadmsvcjobs
- stsadm -o export -url <URL to be exported> -filename <export
file name> [-overwrite] [-includeusersecurity] [-haltonwarning] [-haltonfatalerror]
[-nologfile] [-versions <1-4> 1= Last major version for files and list items
(default), 2= The current version, either the last major or the last minor, 3= Last
major and last minor version for files and list items, 4= All versions for files
and list items] [-cabsize <integer from 1-1024 megabytes> (default: 25)] [-nofilecompression]
[-quiet] - stsadm -o extendvs -url <url> -ownerlogin <domain\name>
-owneremail <UserName@mail.com>
[-exclusivelyusentlm] [-ownername <display name>] [-databaseuser <database
user>] [-databaseserver <database server>] [-databasename <database
name>] [-databasepassword <database user password>] [-lcid <language>]
[-sitetemplate <site template>] [-donotcreatesite] [-description <iis web
site name>] [-sethostheader] [-apidname <app pool name>] [-apidtype <configurableid/NetworkService>]
[-apidlogin <DOMAIN\name>] [-apidpwd <app pool password>] [-allowanonymous] - stsadm -o extendvsinwebfarm -url <url> -vsname <web application
name> [-exclusivelyusentlm] [-apidname <app pool name>] [-apidtype <configurableid/NetworkService>]
[-apidlogin <DOMAIN\name>] [-apidpwd <app pool password>] [-allowanonymous] - stsadm -o forcedeleteweb -url <url>
- stsadm -o formtemplatequiescestatus [-formid <form template
ID>] [-filename <path to form template file>] - stsadm -o getadminport
- stsadm -o getdataconnectionfileproperty -filename <filename
of the data connection file> -pn <property name> - stsadm -o getformsserviceproperty -pn <option name>
- stsadm -o getformtemplateproperty [-formid <form template ID>]
[-filename <path to form template file>] -pn <property name> - stsadm -o getproperty -propertyname <property name> [-url
<url>] (SharePoint cluster properties: avallowdownload, avcleaningenabled,
avdownloadscanenabled, avnumberofthreads, avtimeout, avuploadscanenabled, command-line-upgrade-running,
database-command-timeout, database-connection-timeout, data-retrieval-services-enabled,
data-retrieval-services-oledb-providers, data-retrieval-services-response-size,
data-retrieval-services-timeout, data-retrieval-services-update, data-source-controls-enabled,
dead-site-auto-delete, dead-site-notify-after, dead-site-num-notifications, defaultcontentdb-password,
defaultcontentdb-server, defaultcontentdb-user, delete-web-send-email, irmaddinsenabled,
irmrmscertserver, irmrmsenabled, irmrmsusead, job-ceip-datacollection, job-config-refresh,
job-database-statistics, job-dead-site-delete, job-usage-analysis, job-watson-trigger,
large-file-chunk-size, token-timeout, workflow-cpu-throttle, workflow-eventdelivery-batchsize,
workflow-eventdelivery-throttle, workflow-eventdelivery-timeout, workflow-timerjob-cpu-throttle,
workitem-eventdelivery-batchsize, workitem-eventdelivery-throttle; SharePoint virtual
server properties: alerts-enabled, alerts-limited, alerts-maximum, change-log-expiration-enabled,
change-log-retention-period, data-retrieval-services-enabled, data-retrieval-services-inherit,
data-retrieval-services-oledb-providers, data-retrieval-services-response-size,
data-retrieval-services-timeout, data-retrieval-services-update, data-source-controls-enabled,
days-to-show-new-icon, dead-site-auto-delete, dead-site-notify-after, dead-site-num-notifications,
defaultquotatemplate, defaulttimezone, delete-web-send-email, job-change-log-expiration,
job-dead-site-delete, job-diskquota-warning, job-immediate-alerts, job-recycle-bin-cleanup,
job-usage-analysis, job-workflow, job-workflow-autoclean, job-workflow-failover,
max-file-post-size, peoplepicker-activedirectorysearchtimeout, peoplepicker-distributionlistsearchdomains,
peoplepicker-nowindowsaccountsfornonwindowsauthenticationmode, peoplepicker-onlysearchwithinsitecollection,
peoplepicker-searchadcustomquery, peoplepicker-searchadforests, presenceenabled,
recycle-bin-cleanup-enabled, recycle-bin-enabled, recycle-bin-retention-period,
second-stage-recycle-bin-quota, send-ad-email) - stsadm -o getsitedirectoryscanschedule
- stsadm -o getsitelock -url <url>
- stsadm -o geturlzone -url <protocol://incoming.url.domain>
- stsadm -o import -url <URL to import to> -filename <import
file name> [-includeusersecurity] [-haltonwarning] [-haltonfatalerror] [-nologfile]
[-updateversions <1-3> 1= Add new versions to the current file (default),
2= Overwrite the file and all its versions (delete then insert),3= Ignore the file
if it exists on the destination] [-nofilecompression] [-quiet] - stsadm -o installfeature {-filename <relative path to Feature.xml
from system feature directory> -name <feature folder>} [-force] - stsadm -o listlogginglevels [-showhidden]
- stsadm -o listregisteredsecuritytrimmers -ssp <ssp name>
- stsadm -o localupgradestatus
- stsadm -o managepermissionpolicylevel -url <url> -name <permission
policy level name> [{ -add -delete }] [-description <description>] [-siteadmin
<true false>] [-siteauditor <true false>] [-grantpermissions <comma-separated
list of permissions>] [-denypermissions <comma-separated list of permissions>] - stsadm -o migrateuser -oldlogin <DOMAIN\name> -newlogin <DOMAIN\name>
[-ignoresidhistory] - stsadm -o osearch [-action <liststartstop>] required parameters
for 'start' (if not already set): role, farmcontactemail, service credentials
[-f (suppress prompts)] [-role <IndexQueryIndexQuery>] [-farmcontactemail
<email>] [-farmperformancelevel <ReducedPartlyReducedMaximum>] [-farmserviceaccount
<DOMAIN\name> (service credentials)] [-farmservicepassword <password>]
[-defaultindexlocation <directory>] [-propagationlocation <directory>] - stsadm -o osearchdiacriticsensitive -ssp <ssp name> [-setstatus
<TrueFalse>] [-noreset] [-force] - stsadm -o preparetomove {-ContentDB <DatabaseServer:DatabaseName>
-Site <URL>} [-OldContentDB <uniqueidentifier>] [-undo] - stsadm -o profilechangelog -title <SSP Name> -daysofhistory
<number of days> -generateanniversaries - stsadm -o profiledeletehandler -type <Full Assembly Path>
- stsadm -o provisionservice -action <start/stop> -servicetype
<servicetype (namespace or assembly qualified name if not SharePoint service)>
[-servicename <servicename>] - stsadm -o quiescefarm -maxduration <duration in minutes>
- stsadm -o quiescefarmstatus
- stsadm -o quiesceformtemplate [-formid <form template ID>]
[-filename <path to form template file>] -maxduration <time in minutes> - stsadm -o reconvertallformtemplates
- stsadm -o refreshdms -url <url>
- stsadm -o refreshsitedms -url <url>
- stsadm -o registersecuritytrimmer -ssp <ssp name> -id <0
- 2147483647> -typename <assembly qualified TypeName of ISecurityTrimmer implementation>
-rulepath <crawl rule URL> [-configprops <name value pairs delimited by
'~'>] - stsadm -o registerwsswriter
- stsadm -o removedataconnectionfile -filename <filename to remove>
- stsadm -o removedrservice -servicename <data retrieval service
name> -setting <data retrieval services setting> - stsadm -o remove-ecsfiletrustedlocation -Ssp <SSP name> -Location
<URLUNC> -LocationType SharePointUncHttp - stsadm -o remove-ecssafedataprovider -Ssp <SSP name> -ID
<data provider id> -Type OledbOdbcOdbcDsn - stsadm -o remove-ecstrusteddataconnectionlibrary -Ssp <SSP name>
-Location <URL> - stsadm -o remove-ecsuserdefinedfunction -Ssp <SSP name> -Assembly
<strong namefile path> -AssemblyLocation GACFile - stsadm -o removeexemptuseragent -name <user-agent to receive
InfoPath files instead of a Web page> - stsadm -o removeformtemplate [-formid <form template ID>]
[-filename <path to form template file>] - stsadm -o removesolutiondeploymentlock [-server <server>
[-allservers] - stsadm -o renameserver -oldservername <oldServerName> -newservername
<newServerName> - stsadm -o renameweb -url <url> -newname <new subsite name>
- stsadm -o restore -url <url> -filename <filename> [-hostheaderwebapplicationurl
<web application url>] [-overwrite] - stsadm -o restore -directory <UNC path> -restoremethod <overwrite
new> [-backupid <Id from backuphistory, see stsadm -help backuphistory>]
[-item <created path from tree>] [-percentage <integer between 1 and 100>]
[-showtree] [-suppressprompt] [-username <username>] [-password <password>]
[-newdatabaseserver <new database server name>] [-quiet] - stsadm -o restoressp -title <SSP name> -url <Web application
url> -ssplogin <username> -mysiteurl <MySite Web application url>
-indexserver <index server> -indexlocation <index file path> [-keepindex]
-sspdatabaseserver <SSP database server> -sspdatabasename <SSP database
name> [-ssppassword <password>] [-sspsqlauthlogin <SQL username>]
[-sspsqlauthpassword <SQL password>] [-searchdatabaseserver <search database
server>] [-searchdatabasename <search database name>] [-searchsqlauthlogin
<SQL username>] [-searchsqlauthpassword <SQL password>] [-ssl <yesno>] - stsadm -o retractsolution -name <Solution name> [-url <virtual
server url>] [-allcontenturls] [-time <time to remove at>] [-immediate]
[-local] [-lcid <language>] - stsadm -o retractwppack -name <Web Part Package name> [-url
<virtual server url>] [-time <time to retract at>] [-immediate] [-local]
[-lcid <language>] - stsadm -o runcmsmigrationprofile -profilename <profile name>
[-skipanalyzer ] [-onlyanalyzer ] [-startover ] [-migratesincetime <DateTime
string>] [-migrationfolder <path>] [-exportonly ] [-importonly ] [-htmldiff
<path>] - stsadm -o runcontentdeploymentjob -jobname <name> [-wait
yesno] [-deploysincetime <datetime>] (<datetime> as "MM/DD/YY HH:MM:SS") - stsadm -o scanforfeatures [-solutionid <Id of Solution>]
[-displayonly] - stsadm -o setadminport -port <port> [-ssl] [-admapcreatenew]
[-admapidname <app pool name>] - stsadm -o setapppassword -password <password>
- stsadm -o setbulkworkflowtaskprocessingschedule -schedule <recurrence
string> - stsadm -o setconfigdb [-connect] -databaseserver <database server>
[-databaseuser <database user>] [-databasepassword <database user password>]
[-databasename <database name>] [-exclusivelyusentlm] [-farmuser] [-farmpassword]
[-adcreation] [-addomain <Active Directory domain>] [-adou <Active Directory
OU>] - stsadm -o setcontentdeploymentjobschedule -jobname <name>
-schedule <schedule> (Schedule Parameter Examples: "every 5 minutes between
0 and 59", "hourly between 0 and 59", "daily at 15:00:00", "weekly between Fri 22:00:00
and Sun 06:00:00", "monthly at 15 15:00:00", "yearly at Jan 1 15:00:00") - stsadm -o setdataconnectionfileproperty -filename <filename
of the data connection file> -pn <property name> -pv <property value> - stsadm -o setdefaultssp -title <SSP name>
- stsadm -o set-ecsexternaldata -Ssp <SSP name> [-ConnectionLifetime
<time in seconds>] [-UnattendedServiceAccountName <account name>] [-UnattendedServiceAccountPassword
<account password>] - stsadm -o set-ecsloadbalancing -Ssp <SSP name> [-Scheme WorkbookUrlRoundRobinLocal]
[-RetryInterval <time in seconds>] - stsadm -o set-ecsmemoryutilization -Ssp <SSP name> [-MaxPrivateBytes
<memory in MBytes>] [-MemoryCacheThreshold <percentage>] [-MaxUnusedObjectAge
<time in minutes>] - stsadm -o set-ecssecurity -Ssp <SSP name> [-FileAccessMethod
UseImpersonationUseFileAccessAccount] [-AccessModel DelegationTrustedSubsystem]
[-RequireEncryptedUserConnection FalseTrue] [-AllowCrossDomainAccess TrueFalse] - stsadm -o set-ecssessionmanagement -Ssp <SSP name> [-MaxSessionsPerUser
<number of sessions>] - stsadm -o set-ecsworkbookcache -Ssp <SSP name> [-Location
<local or UNC path>] [-MaxCacheSize <storage in Mbytes>] [-EnableCachingOfUnusedFiles
TrueFalse] - stsadm -o setformsserviceproperty -pn <option name> -pv <option
value> - stsadm -o setformtemplateproperty [-formid <form template ID>]
[-filename <path to form template file>] -pn <property name> -pv <property
value> - stsadm -o setholdschedule -schedule <recurrence string>
- stsadm -o setlogginglevel [-category < [CategoryName Manager:CategoryName
[;...]] >] {-default -tracelevel < None; Unexpected; Monitorable;
High; Medium; Verbose> [-windowslogginglevel < None; ErrorServiceUnavailable;
ErrorSecurityBreach; ErrorCritical; Error; Warning; FailureAudit;
SuccessAudit; Information; Success>] } - stsadm -o setpolicyschedule -schedule <recurrence string>
- stsadm -o setproperty -propertyname <property name> -propertyvalue
<property value> [-url <url>] (SharePoint cluster properties:, avallowdownload,
avcleaningenabled, avdownloadscanenabled, avnumberofthreads, avtimeout, avuploadscanenabled,
command-line-upgrade-running, database-command-timeout, database-connection-timeout,
data-retrieval-services-enabled, data-retrieval-services-oledb-providers, data-retrieval-services-response-size,
data-retrieval-services-timeout, data-retrieval-services-update, data-source-controls-enabled,
dead-site-auto-delete, dead-site-notify-after, dead-site-num-notifications, defaultcontentdb-password,
defaultcontentdb-server, defaultcontentdb-user, delete-web-send-email, irmaddinsenabled,
irmrmscertserver, irmrmsenabled, irmrmsusead, job-ceip-datacollection, job-config-refresh,
job-database-statistics, job-dead-site-delete, job-usage-analysis, job-watson-trigger,
large-file-chunk-size, token-timeout, workflow-cpu-throttle, workflow-eventdelivery-batchsize,
workflow-eventdelivery-throttle, workflow-eventdelivery-timeout, workflow-timerjob-cpu-throttle,
workitem-eventdelivery-batchsize, workitem-eventdelivery-throttle; SharePoint virtual
server properties:, alerts-enabled, alerts-limited, alerts-maximum, change-log-expiration-enabled,
change-log-retention-period, data-retrieval-services-enabled, data-retrieval-services-inherit,
data-retrieval-services-oledb-providers, data-retrieval-services-response-size,
data-retrieval-services-timeout, data-retrieval-services-update, data-source-controls-enabled,
days-to-show-new-icon, dead-site-auto-delete, dead-site-notify-after, dead-site-num-notifications,
defaultquotatemplate, defaulttimezone, delete-web-send-email, job-change-log-expiration,
job-dead-site-delete, job-diskquota-warning, job-immediate-alerts, job-recycle-bin-cleanup,
job-usage-analysis, job-workflow, job-workflow-autoclean, job-workflow-failover,
max-file-post-size, peoplepicker-activedirectorysearchtimeout, peoplepicker-distributionlistsearchdomains,
peoplepicker-nowindowsaccountsfornonwindowsauthenticationmode, peoplepicker-onlysearchwithinsitecollection,
peoplepicker-searchadcustomquery, peoplepicker-searchadforests, presenceenabled,
recycle-bin-cleanup-enabled, recycle-bin-enabled, recycle-bin-retention-period,
second-stage-recycle-bin-quota, send-ad-email) - stsadm -o setrecordsrepositoryschedule -schedule <recurrence
string> - stsadm -o setsearchandprocessschedule -schedule <recurrence
string> - stsadm -o setsharedwebserviceauthn -ntlm -negotiate
- stsadm -o setsitedirectoryscanschedule -schedule <recurrence
string> (Schedule parameter examples: "every 5 minutes between 0 and 59", "hourly
between 0 and 59", "daily at 15:00:00", "weekly between Fri 22:00:00 and Sun 06:00:00",
"monthly at 15 15:00:00", "yearly at Jan 1 15:00:00") - stsadm -o setsitelock -url <url> -lock <none noadditions
readonly noaccess> - stsadm -o setsspport -httpport <HTTP port number> -httpsport
<HTTPS port number> - stsadm -o setworkflowconfig -url <url> {-emailtonopermissionparticipants
<enabledisable> -externalparticipants <enabledisable> -userdefinedworkflows
<enabledisable>} - stsadm -o siteowner -url <url> [-ownerlogin <DOMAIN\name>]
[-secondarylogin <DOMAIN\name>] - stsadm -o spsearch [-action <list start stop attachcontentdatabase
detachcontentdatabase fullcrawlstart fullcrawlstop>] [-f (suppress prompts)]
[-farmperformancelevel <Reduced PartlyReduced Maximum>] [-farmserviceaccount
<DOMAIN\name> (service credentials)] [-farmservicepassword <password>]
[-farmcontentaccessaccount <DOMAIN\name>] [-farmcontentaccesspassword <password>]
[-indexlocation <new index location>] [-databaseserver <server\instance>
(default: josebda-moss)] [-databasename <database name> (default: SharePoint_WSS_Search)]
[-sqlauthlogin <SQL authenticated database user>] [-sqlauthpassword <password>]
-action list -action stop [-f (suppress prompts)] -action start -farmserviceaccount
<DOMAIN\name> (service credentials) [-farmservicepassword <password>]
-action attachcontentdatabase [-databaseserver <server\instance> (default:
josebda-moss)] -databasename <content database name> [-searchserver <search
server name> (default: josebda-moss)] -action detachcontentdatabase [-databaseserver
<server\instance> (default: josebda-moss)] -databasename <content database
name> [-f (suppress prompts)] -action fullcrawlstart -action fullcrawlstop - stsadm -o spsearchdiacriticsensitive [-setstatus <TrueFalse>]
[-noreset] [-force] - stsadm -o sync {-ExcludeWebApps <web applications> -SyncTiming
<schedule(M/H/D:value)> -SweepTiming <schedule(M/H/D:value)> -ListOldDatabases
<days> -DeleteOldDatabases <days>} - stsadm -o syncsolution -name <Solution name>] [-lcid <language>]
[-alllcids] - stsadm -o syncsolution -allsolutions
- stsadm -o unextendvs -url <url> [-deletecontent] [-deleteiissites]
- stsadm -o uninstallfeature {-filename <relative path to Feature.xml>
-name <feature folder> -id <feature Id>} [-force] - stsadm -o unquiescefarm
- stsadm -o unquiesceformtemplate [-formid <form template ID>]
[-filename <path to form template file>] - stsadm -o unregistersecuritytrimmer -ssp <ssp name> -id <0
- 2147483647> - stsadm -o unregisterwsswriter
- stsadm -o updateaccountpassword -userlogin <DOMAIN\name>
-password <password> [-noadmin] - stsadm -o updatealerttemplates -url <url> [-filename <filename>]
[-lcid <language> - stsadm -o updatefarmcredentials [-identitytype <configurableid/NetworkService>]
[-userlogin <DOMAIN\name>] [-password <password>] [-local [-keyonly]] - stsadm -o upgrade {-inplace -sidebyside} [-url <url>] [-forceupgrade]
[-quiet] [-farmuser <farm user>] [-farmpassword <farm user password>]
[-reghost] [-sitelistpath <sites xml file>] - stsadm -o upgradeformtemplate -filename <path to form template
file> [-upgradetype <upgrade type>] - stsadm -o upgradesolution -name <Solution name> -filename
<upgrade filename> [-time <time to upgrade at>] [-immediate] [-local]
[-allowgacdeployment] [-allowcaspolicies] [-lcid <language>] - stsadm -o upgradetargetwebapplication -url <URL to upgrade>
-relocationurl <new URL for non-upgraded content> -apidname <new app pool
name> [-apidtype <configurableid/NetworkService>] [-apidlogin <DOMAIN\name>]
[-apidpwd <app pool password>] [-exclusivelyusentlm] - stsadm -o uploadformtemplate -filename <path to form template
file> - stsadm -o userrole -url <url> -userlogin <DOMAIN\name>
-role <role name> [-add] [-delete] - stsadm -o verifyformtemplate -filename <path to form template
file>
Monday, August 9, 2010
Sample "web service" for file upload and update metadata using C#
Here is a sample "web service" for file upload and update metadata for uploaded file in Moss 2007 using C# language.
using Microsoft.VisualBasic;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Diagnostics;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Configuration;
using System.Xml;
using System.Net;
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[Microsoft.VisualBasic.CompilerServices.DesignerGenerated()]
public class Service : System.Web.Services.WebService
{
[WebMethod()]
public string HelloWorld()
{
return "Hello World";
}
[System.Web.Services.WebMethod(Description = "Upload files to Portal")]
public string sUploadandUpdateFiles(string sFolder)
{
string sSharedPath = ConfigurationManager.AppSettings("GlobalSharedPath");
sFolder = sSharedPath + sFolder;
int counter = 0;
Collection oCollFiles = null;
object vFromFile = null;
string sFromFile = null;
string UploadFileFlag = null;
string sToFile = null;
string UpdateListFlag = null;
string sSampleVal = "Test Value";
try {
oCollFiles = GetFileColl(ref sFolder);
if (oCollFiles.Count() > 0) {
foreach (object vFromFile_loopVariable in oCollFiles) {
vFromFile = vFromFile_loopVariable;
sFromFile = sFolder + "\\" + Convert.ToString(vFromFile);
sToFile = vFromFile;
bEnableVersion(true);
UploadFileFlag = UploadDocument(sFromFile, sToFile);
bEnableVersion(false);
UpdateListFlag = WSSUpdateFile(sToFile, sToFile, sSampleVal);
counter = counter + 1;
}
}
return counter + " Files moved";
} catch (Exception ex) {
return ex.Message;
}
}
private Collection GetFileColl(ref string sPath)
{
Collection functionReturnValue = null;
string sFile = null;
Collection oReturnColl = null;
oReturnColl = new Collection();
// ERROR: Not supported in C#: OnErrorStatement
sFile = FileSystem.Dir(sPath + "\\*.*");
do {
if (!string.IsNullOrEmpty(sFile)) {
oReturnColl.Add(sFile);
sFile = FileSystem.Dir();
}
} while (!(string.IsNullOrEmpty(sFile)));
errGetColl:
functionReturnValue = oReturnColl;
return;
return functionReturnValue;
}
[WebMethod()]
public string bEnableVersion(bool bEnable)
{
string sUser = ConfigurationManager.AppSettings("User");
string sPwd = ConfigurationManager.AppSettings("Pwd");
string sDomain = ConfigurationManager.AppSettings("Domain");
string sSPURL = ConfigurationManager.AppSettings("SharePointServer");
string sDocLib = ConfigurationManager.AppSettings("DocLibrary");
System.Net.NetworkCredential netAccess = new System.Net.NetworkCredential(sUser, sPwd, sDomain);
SPLists.Lists L = new SPLists.Lists();
L.Credentials = netAccess;
L.Url = sSPURL + "/_vti_bin/lists.asmx";
try {
XmlNode anode = L.GetList(sDocLib);
XmlDocument aXMLDoc = new XmlDocument();
XmlElement aXMLElement = aXMLDoc.CreateElement("List");
aXMLElement.SetAttribute("EnableVersioning", bEnable);
L.UpdateList(anode.Attributes("ID").Value, aXMLElement, null, null, null, anode.Attributes("Version").Value);
return "TRUE";
} catch (Exception ex) {
return Err.Description;
}
}
[WebMethod()]
public string CreateFolder(string sFolderName, bool sSAM)
{
string sSPURL = ConfigurationManager.AppSettings("SharePointServer");
string sDocLib = ConfigurationManager.AppSettings("DocLibrary");
string sUser = ConfigurationManager.AppSettings("User");
string sPwd = ConfigurationManager.AppSettings("Pwd");
string sDomain = ConfigurationManager.AppSettings("Domain");
System.Net.NetworkCredential netAccess = new System.Net.NetworkCredential(sUser, sPwd, sDomain);
DWS.Dws dwsService = new DWS.Dws();
dwsService.Url = sSPURL + "/_vti_bin/DWs.asmx";
dwsService.Credentials = netAccess;
try {
string strResult = null;
string strFolderComplete = sDocLib + sFolderName;
strFolderComplete = Strings.Replace(strFolderComplete, "\\", "/");
strResult = dwsService.CreateFolder(strFolderComplete);
if (IsDwsErrorResult(strResult)) {
int intErrorID = 0;
string strErrorMsg = null;
ParseDwsErrorResult(strResult, ref intErrorID, ref strErrorMsg);
if (intErrorID.ToString() == "13") {
return strFolderComplete;
return;
}
return ("A document workspace error occurred." + Constants.vbCrLf + "Error number: " + intErrorID.ToString() + Constants.vbCrLf + "Error description:" + strErrorMsg);
} else {
return strFolderComplete;
}
} catch (Exception exc) {
return ("An exception occurred." + Constants.vbCrLf + "Description: " + exc.Message);
}
}
private bool IsDwsErrorResult(string ResultFragment)
{
System.IO.StringReader srResult = new System.IO.StringReader(ResultFragment);
System.Xml.XmlTextReader xtr = new System.Xml.XmlTextReader(srResult);
xtr.Read();
if (xtr.Name == "Error") {
return true;
} else {
return false;
}
}
private void ParseDwsErrorResult(string ErrorFragment, ref int ErrorID, ref string ErrorMsg)
{
System.IO.StringReader srError = new System.IO.StringReader(ErrorFragment);
System.Xml.XmlTextReader xtr = new System.Xml.XmlTextReader(srError);
xtr.Read();
xtr.MoveToAttribute("ID");
xtr.ReadAttributeValue();
ErrorID = xtr.Value;
ErrorMsg = xtr.ReadString();
}
private string ParseDwsSingleResult(string ResultFragment)
{
System.IO.StringReader srResult = new System.IO.StringReader(ResultFragment);
System.Xml.XmlTextReader xtr = new System.Xml.XmlTextReader(srResult);
xtr.Read();
return xtr.ReadString();
}
[WebMethod()]
public string UploadDocument(string localFile, string remoteFile)
{
//// Read in the local file
// ERROR: Not supported in C#: OnErrorStatement
byte[] r = null;
System.IO.FileStream Strm = new System.IO.FileStream(localFile, System.IO.FileMode.Open, System.IO.FileAccess.Read);
System.IO.BinaryReader reader = new System.IO.BinaryReader(Strm);
byte[] filecontents = reader.ReadBytes(Convert.ToInt32(Strm.Length));
reader.Close();
Strm.Close();
string sSPURL = ConfigurationManager.AppSettings("SharePointServer");
string sDocLib = ConfigurationManager.AppSettings("DocLibrary");
string sUser = ConfigurationManager.AppSettings("User");
string sPwd = ConfigurationManager.AppSettings("Pwd");
string sDomain = ConfigurationManager.AppSettings("Domain");
string sRemoteFileURL = null;
System.Net.NetworkCredential NC = new System.Net.NetworkCredential(sUser, sPwd, sDomain);
sRemoteFileURL = sSPURL + "/" + sDocLib + "/" + Strings.Trim(Strings.LTrim(Strings.RTrim(remoteFile)));
sRemoteFileURL = Strings.Replace(sRemoteFileURL, " ", "%20");
sRemoteFileURL = Strings.Replace(sRemoteFileURL, "\\", "/");
WebClient m_WC = new WebClient();
m_WC.Credentials = NC;
r = m_WC.UploadData(sRemoteFileURL, "PUT", filecontents);
return "TRUE";
return;
handler:
return Err.Description;
}
public string WSSUpdateFile(string sFileName, string sSiteDoc, string sTestCol)
{
string sUser = ConfigurationManager.AppSettings("User");
string sPwd = ConfigurationManager.AppSettings("Pwd");
string sDomain = ConfigurationManager.AppSettings("Domain");
string sFileIDinList = null;
string strBatch = "";
sSiteDoc = Strings.Replace(sSiteDoc, "%20", " ");
sSiteDoc = Strings.Replace(sSiteDoc, "\\", "/");
string sFinalFilePath = null;
string sSPURL = ConfigurationManager.AppSettings("SharePointServer");
string sDocLib = ConfigurationManager.AppSettings("DocLibrary");
try {
System.Net.NetworkCredential netAccess = new System.Net.NetworkCredential(sUser, sPwd, sDomain);
SPLists.Lists listService = new SPLists.Lists();
listService.Url = sSPURL + "/_vti_bin/lists.asmx";
listService.Credentials = netAccess;
sFileIDinList = sGetID(listService.Url, sDocLib, sFileName);
if (!string.IsNullOrEmpty(sFileIDinList)) {
sFinalFilePath = sSPURL + "/" + sDocLib + "/" + sFileName;
//Now we have FileID so update the list
strBatch = "" + "" + sFileIDinList + " " + "" + sFinalFilePath + " " + "" + sTestCol + " " + " ";
object xmlDoc = new System.Xml.XmlDocument();
System.Xml.XmlElement elBatch = xmlDoc.CreateElement("Batch");
elBatch.InnerXml = strBatch;
System.Xml.XmlNode ndreturn = listService.UpdateListItems(sDocLib, elBatch);
}
return "TRUE";
} catch (Exception ex) {
return ex.Message;
}
}
private string sGetID(string sURL, string sListGUID, string sFileName)
{
string sUser = ConfigurationManager.AppSettings("User");
string sPwd = ConfigurationManager.AppSettings("Pwd");
string sDomain = ConfigurationManager.AppSettings("Domain");
System.Net.NetworkCredential netAccess = new System.Net.NetworkCredential(sUser, sPwd, sDomain);
SPLists.Lists L = new SPLists.Lists();
L.Credentials = netAccess;
L.Url = sURL;
XmlDocument xmldoc = new XmlDocument();
XmlNode query = xmldoc.CreateNode(XmlNodeType.Element, "Query", "");
query.InnerXml = "
try {
XmlNode caml = L.GetListItems(sListGUID, null, query, null, "1", null, null);
string id = caml.ChildNodes(1).ChildNodes(1).Attributes("ows_ID").Value;
return id;
} catch (Exception ex) {
return ex.Message;
}
}
}
using Microsoft.VisualBasic;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Diagnostics;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Configuration;
using System.Xml;
using System.Net;
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[Microsoft.VisualBasic.CompilerServices.DesignerGenerated()]
public class Service : System.Web.Services.WebService
{
[WebMethod()]
public string HelloWorld()
{
return "Hello World";
}
[System.Web.Services.WebMethod(Description = "Upload files to Portal")]
public string sUploadandUpdateFiles(string sFolder)
{
string sSharedPath = ConfigurationManager.AppSettings("GlobalSharedPath");
sFolder = sSharedPath + sFolder;
int counter = 0;
Collection oCollFiles = null;
object vFromFile = null;
string sFromFile = null;
string UploadFileFlag = null;
string sToFile = null;
string UpdateListFlag = null;
string sSampleVal = "Test Value";
try {
oCollFiles = GetFileColl(ref sFolder);
if (oCollFiles.Count() > 0) {
foreach (object vFromFile_loopVariable in oCollFiles) {
vFromFile = vFromFile_loopVariable;
sFromFile = sFolder + "\\" + Convert.ToString(vFromFile);
sToFile = vFromFile;
bEnableVersion(true);
UploadFileFlag = UploadDocument(sFromFile, sToFile);
bEnableVersion(false);
UpdateListFlag = WSSUpdateFile(sToFile, sToFile, sSampleVal);
counter = counter + 1;
}
}
return counter + " Files moved";
} catch (Exception ex) {
return ex.Message;
}
}
private Collection GetFileColl(ref string sPath)
{
Collection functionReturnValue = null;
string sFile = null;
Collection oReturnColl = null;
oReturnColl = new Collection();
// ERROR: Not supported in C#: OnErrorStatement
sFile = FileSystem.Dir(sPath + "\\*.*");
do {
if (!string.IsNullOrEmpty(sFile)) {
oReturnColl.Add(sFile);
sFile = FileSystem.Dir();
}
} while (!(string.IsNullOrEmpty(sFile)));
errGetColl:
functionReturnValue = oReturnColl;
return;
return functionReturnValue;
}
[WebMethod()]
public string bEnableVersion(bool bEnable)
{
string sUser = ConfigurationManager.AppSettings("User");
string sPwd = ConfigurationManager.AppSettings("Pwd");
string sDomain = ConfigurationManager.AppSettings("Domain");
string sSPURL = ConfigurationManager.AppSettings("SharePointServer");
string sDocLib = ConfigurationManager.AppSettings("DocLibrary");
System.Net.NetworkCredential netAccess = new System.Net.NetworkCredential(sUser, sPwd, sDomain);
SPLists.Lists L = new SPLists.Lists();
L.Credentials = netAccess;
L.Url = sSPURL + "/_vti_bin/lists.asmx";
try {
XmlNode anode = L.GetList(sDocLib);
XmlDocument aXMLDoc = new XmlDocument();
XmlElement aXMLElement = aXMLDoc.CreateElement("List");
aXMLElement.SetAttribute("EnableVersioning", bEnable);
L.UpdateList(anode.Attributes("ID").Value, aXMLElement, null, null, null, anode.Attributes("Version").Value);
return "TRUE";
} catch (Exception ex) {
return Err.Description;
}
}
[WebMethod()]
public string CreateFolder(string sFolderName, bool sSAM)
{
string sSPURL = ConfigurationManager.AppSettings("SharePointServer");
string sDocLib = ConfigurationManager.AppSettings("DocLibrary");
string sUser = ConfigurationManager.AppSettings("User");
string sPwd = ConfigurationManager.AppSettings("Pwd");
string sDomain = ConfigurationManager.AppSettings("Domain");
System.Net.NetworkCredential netAccess = new System.Net.NetworkCredential(sUser, sPwd, sDomain);
DWS.Dws dwsService = new DWS.Dws();
dwsService.Url = sSPURL + "/_vti_bin/DWs.asmx";
dwsService.Credentials = netAccess;
try {
string strResult = null;
string strFolderComplete = sDocLib + sFolderName;
strFolderComplete = Strings.Replace(strFolderComplete, "\\", "/");
strResult = dwsService.CreateFolder(strFolderComplete);
if (IsDwsErrorResult(strResult)) {
int intErrorID = 0;
string strErrorMsg = null;
ParseDwsErrorResult(strResult, ref intErrorID, ref strErrorMsg);
if (intErrorID.ToString() == "13") {
return strFolderComplete;
return;
}
return ("A document workspace error occurred." + Constants.vbCrLf + "Error number: " + intErrorID.ToString() + Constants.vbCrLf + "Error description:" + strErrorMsg);
} else {
return strFolderComplete;
}
} catch (Exception exc) {
return ("An exception occurred." + Constants.vbCrLf + "Description: " + exc.Message);
}
}
private bool IsDwsErrorResult(string ResultFragment)
{
System.IO.StringReader srResult = new System.IO.StringReader(ResultFragment);
System.Xml.XmlTextReader xtr = new System.Xml.XmlTextReader(srResult);
xtr.Read();
if (xtr.Name == "Error") {
return true;
} else {
return false;
}
}
private void ParseDwsErrorResult(string ErrorFragment, ref int ErrorID, ref string ErrorMsg)
{
System.IO.StringReader srError = new System.IO.StringReader(ErrorFragment);
System.Xml.XmlTextReader xtr = new System.Xml.XmlTextReader(srError);
xtr.Read();
xtr.MoveToAttribute("ID");
xtr.ReadAttributeValue();
ErrorID = xtr.Value;
ErrorMsg = xtr.ReadString();
}
private string ParseDwsSingleResult(string ResultFragment)
{
System.IO.StringReader srResult = new System.IO.StringReader(ResultFragment);
System.Xml.XmlTextReader xtr = new System.Xml.XmlTextReader(srResult);
xtr.Read();
return xtr.ReadString();
}
[WebMethod()]
public string UploadDocument(string localFile, string remoteFile)
{
//// Read in the local file
// ERROR: Not supported in C#: OnErrorStatement
byte[] r = null;
System.IO.FileStream Strm = new System.IO.FileStream(localFile, System.IO.FileMode.Open, System.IO.FileAccess.Read);
System.IO.BinaryReader reader = new System.IO.BinaryReader(Strm);
byte[] filecontents = reader.ReadBytes(Convert.ToInt32(Strm.Length));
reader.Close();
Strm.Close();
string sSPURL = ConfigurationManager.AppSettings("SharePointServer");
string sDocLib = ConfigurationManager.AppSettings("DocLibrary");
string sUser = ConfigurationManager.AppSettings("User");
string sPwd = ConfigurationManager.AppSettings("Pwd");
string sDomain = ConfigurationManager.AppSettings("Domain");
string sRemoteFileURL = null;
System.Net.NetworkCredential NC = new System.Net.NetworkCredential(sUser, sPwd, sDomain);
sRemoteFileURL = sSPURL + "/" + sDocLib + "/" + Strings.Trim(Strings.LTrim(Strings.RTrim(remoteFile)));
sRemoteFileURL = Strings.Replace(sRemoteFileURL, " ", "%20");
sRemoteFileURL = Strings.Replace(sRemoteFileURL, "\\", "/");
WebClient m_WC = new WebClient();
m_WC.Credentials = NC;
r = m_WC.UploadData(sRemoteFileURL, "PUT", filecontents);
return "TRUE";
return;
handler:
return Err.Description;
}
public string WSSUpdateFile(string sFileName, string sSiteDoc, string sTestCol)
{
string sUser = ConfigurationManager.AppSettings("User");
string sPwd = ConfigurationManager.AppSettings("Pwd");
string sDomain = ConfigurationManager.AppSettings("Domain");
string sFileIDinList = null;
string strBatch = "";
sSiteDoc = Strings.Replace(sSiteDoc, "%20", " ");
sSiteDoc = Strings.Replace(sSiteDoc, "\\", "/");
string sFinalFilePath = null;
string sSPURL = ConfigurationManager.AppSettings("SharePointServer");
string sDocLib = ConfigurationManager.AppSettings("DocLibrary");
try {
System.Net.NetworkCredential netAccess = new System.Net.NetworkCredential(sUser, sPwd, sDomain);
SPLists.Lists listService = new SPLists.Lists();
listService.Url = sSPURL + "/_vti_bin/lists.asmx";
listService.Credentials = netAccess;
sFileIDinList = sGetID(listService.Url, sDocLib, sFileName);
if (!string.IsNullOrEmpty(sFileIDinList)) {
sFinalFilePath = sSPURL + "/" + sDocLib + "/" + sFileName;
//Now we have FileID so update the list
strBatch = "
object xmlDoc = new System.Xml.XmlDocument();
System.Xml.XmlElement elBatch = xmlDoc.CreateElement("Batch");
elBatch.InnerXml = strBatch;
System.Xml.XmlNode ndreturn = listService.UpdateListItems(sDocLib, elBatch);
}
return "TRUE";
} catch (Exception ex) {
return ex.Message;
}
}
private string sGetID(string sURL, string sListGUID, string sFileName)
{
string sUser = ConfigurationManager.AppSettings("User");
string sPwd = ConfigurationManager.AppSettings("Pwd");
string sDomain = ConfigurationManager.AppSettings("Domain");
System.Net.NetworkCredential netAccess = new System.Net.NetworkCredential(sUser, sPwd, sDomain);
SPLists.Lists L = new SPLists.Lists();
L.Credentials = netAccess;
L.Url = sURL;
XmlDocument xmldoc = new XmlDocument();
XmlNode query = xmldoc.CreateNode(XmlNodeType.Element, "Query", "");
query.InnerXml = "
try {
XmlNode caml = L.GetListItems(sListGUID, null, query, null, "1", null, null);
string id = caml.ChildNodes(1).ChildNodes(1).Attributes("ows_ID").Value;
return id;
} catch (Exception ex) {
return ex.Message;
}
}
}
Monday, July 26, 2010
15th Shaban and Importance of Areeza
Q. What is Areeza?
Ans. "AREEZA" is a letter to the Imam Mehdi(a.s.). This letter is written with a lot of love and affection and is traditionally wrapped up in flour or pure soil and sprinkled with scents (Itar) and is thrown in a waterbody like river, ocean, canal with the intention that it reaches our beloved Imam-e-Zamana(a.s.).
------------------------------------------------------------------------------------------------
For the first time in history, an online portal Areeza.com is being launched that will take your Areezas in the service of the 12th Imam (A.S.). We know a lot of people want to send their Areezas, but are unable to do so due to a variety of reasons. We will undertake the humble responsibility of making your prayers reach their destination by being the messengers for you. Kindly support our noble cause and send your Areezas online in the service of God.
Our dedicated team will drop your Areezas in the ocean every Friday. We will keep your Areezas completely confidential, we will not be reading them. We will only be dropping your Areezas, never reading any contents so you can be sure your prayers only reach the 12th Imam (A.S.).
Please Join us with all your family member and friends so they can also take advantage of sending their Areezas online.
Kindly visit http://www.Areeza.com to send your Areezas! We have launched this site today on 14th of Shaban in the occasion of Shab-e-barat(15th Shaban).
Ans. "AREEZA" is a letter to the Imam Mehdi(a.s.). This letter is written with a lot of love and affection and is traditionally wrapped up in flour or pure soil and sprinkled with scents (Itar) and is thrown in a waterbody like river, ocean, canal with the intention that it reaches our beloved Imam-e-Zamana(a.s.).
------------------------------------------------------------------------------------------------
For the first time in history, an online portal Areeza.com is being launched that will take your Areezas in the service of the 12th Imam (A.S.). We know a lot of people want to send their Areezas, but are unable to do so due to a variety of reasons. We will undertake the humble responsibility of making your prayers reach their destination by being the messengers for you. Kindly support our noble cause and send your Areezas online in the service of God.
Our dedicated team will drop your Areezas in the ocean every Friday. We will keep your Areezas completely confidential, we will not be reading them. We will only be dropping your Areezas, never reading any contents so you can be sure your prayers only reach the 12th Imam (A.S.).
Please Join us with all your family member and friends so they can also take advantage of sending their Areezas online.
Kindly visit http://www.Areeza.com to send your Areezas! We have launched this site today on 14th of Shaban in the occasion of Shab-e-barat(15th Shaban).
Tuesday, July 6, 2010
Moss 2010 - Store sharepoint Logs in database
I was playing with the moss 2010 and have found "Database driven Log system" as new feature. Now all the logs can store into a database from all the servers within a farm.
The only thing you have to do is turn on this feature in Central Admin.
You can see the following logs: ULS, events, performance counter, memory info, disk info, etc.
For more detail please go to microsoft's sharepoint site
Nthing I am going to do is to design the SSRS report for different log info, once those will be ready, I will post those reports for you guys.
Enjoy green coding...
The only thing you have to do is turn on this feature in Central Admin.
You can see the following logs: ULS, events, performance counter, memory info, disk info, etc.
For more detail please go to microsoft's sharepoint site
Nthing I am going to do is to design the SSRS report for different log info, once those will be ready, I will post those reports for you guys.
Enjoy green coding...
Monday, June 21, 2010
Get the detailed error message from Microsoft.SharePoint.SoapServer.SoapServerException
Remove all try and catch statements and let the error come as "SoapException was unhandled by code" error. In this case debugging will throw a message. See this message and click on ViewDetail under Action.
Under the View Detai, expand exception. See InnerXML under Detail: you will get the exact error. For example, I am getting this error from Microsoft.SharePoint.SoapServer.SoapServerException: "
See the attached Image for more detail.
I hope this will help you to see detail error of Microsoft.SharePoint.SoapServer.SoapServerException
Enjoy green debugging: www.code4green.com
Sunday, June 13, 2010
MultiColumnLookupField control in sharepoint 2007
Depoyment of MultiColumnLookupField in sharepoint
I was looking for how to use this control into sharepoint, and after doing work around I have got this solution for others:
1. Build your assembly(project) and install it in the GAC on the server.
2. Copy the ascx control(MultiColumnLookupField.ascx) to C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\CONTROLTEMPLATES
3. Copy the fldtypesMultiColumnLookup.xml to C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\XML
4. Reset IIS
Enjoy green coding
Hussain Naqvi
use this online tool for free code generation www.Code4green.com
Thursday, May 13, 2010
Features of SharePoint2010
Hi, I have compiled my first eBook on "Features of Moss2010". Please download this free eBook from my code4gree site : http://www.code4green.com/Files/MOSS%202010%20Features.pdf Also, use new version of code4green to generate free code. Enjoy Green Coding....
Subscribe to:
Posts (Atom)