Skip to main content

Posts

SharePoint PowerShell Console

For the code/script lovers, i know that SharePoint was beginning to take away that sweet thing from you, well now at least you get to run your scripts in powershell. Check out this one on codeplex (I think am in love with codeplex!!!) http://sppowershellconsole.codeplex.com/

Zambia's first Helpdesk System on SharePoint

For my 25th birthday today 3rd March, 2009, allow me to present to you another first of its kind in Zambia. Yes we have done it again, having been Project manager, I present to you Zambia's first Helpdesk System which Masialeti and I have developed on Microsoft Office SharePoint Server 2007. The system also implements SharePoint designer workflows, Infopath forms, SharePoint document library and sends email notifications to the relevant personnel. When a user logs in a call, the user automatically receives a mail from the system, telling them that their call has been received and is being attended to, IT section will also receive a notification and the helpdesk manager will assign the call to the right IT guy who will also automatically receive a mail notification from the system. When the call is resolved, the user again automatically gets notified by the system with a mail giving them description of the problem they logged and also how it has been resolved. The user also has an ...

Error "403 Forbidden" on Sharepoint Search Settings Page

Ok so I had to struggle with this error for like 48 hours, busy googling for a solution. This error came up at the same time on both our live and test environment after we were hit by the worm Microsoft reported a few days ago. So here is how I went about sorting it out: Using STSADMIN commands 1. I first ran stsadm -o osearch -action stop –f 2. Then stsadm -o osearch -action start -role indexquery 3. And stsadm -o execadmsvcjobs So now I tried to access the search site and it told me that I had to assign an index server, of which I did, then I again from the index server had to run stsadm -o execadmsvcjobs. At this point, I had to provide access to c:\windows\tasks, from the command line, on our index server for the local group WSS_WPG as follows 1. By running attrib -s c:\windows\tasks on the index server so as to be able to change the tasks system folder attributes. 2. Then I added the local group WSS_WPG with read and write access 3. And now take back the attributes of the tasks sy...

Report Server in SharePoint Integrated Mode Error: Cannot create a connection to data source 'DatasSource1'

So having made my report using Business Intelligence Development studio, i successfully deployed it to my Sharepoint Reports Library. When i tried to access the report from SharePoint, BOMB!!! An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'DatasSource1'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors So after 24 hours of hitting my head against the wall, i got it right. Try this: 1. open your http://sharepointserver/reports/data connections/ 2. click to open the data connection 3. On the credentials section, click the "stored credentials" radio button, type in a domain account in the format 'MYDOMAIN\Accountname' and it password. Note that this account can be the service account of your farm, assuming that its also the account that the report server is using when connecting to the report server d...

Zambia's first Copper Concentrate Logistics System on SharePoint 2007

Ok so my workmate Charles and I just finished developing a Copper Concentrate Logistics System on SharePoint 2007. Again we do something that has never been done before in Zambia, on SharePoint!!! So here is how it works: First of all, it’s mainly using SharePoint Lists, Views dependent on your log in credentials, InfoPath Forms that pull their data from the SharePoint list based on specific selection criteria. The marketing dept captures the details of the trucks expected to arrive, only after which, the Security personnel will be able to see the details of the expected trucks and authorize entry. This then allows the truck details on empty weight and on loaded weight to be captured to the same system from the Weighbridge and sealing details confirmed. Only when the weighbridge process has been confirmed, the Security to authorize exit would be able to view the truck details, which they will use for their exit authorization. This piece of a SharePoint system generates various reports...