The assumption is that you deployed your branding solution as .wsp file and you now wanted to make further changes such as the master page, page layout, CSS, images etc..
How do you go about the upgrade and deployment process:
- Open your existing branding solution using Visual Studio 2010 or latest version
- Make the appropriate code changes
- Save your project and later, right click your solution and “Rebuild”
- Right click your solution and click “Package”
- Right click your solution and click “Open Folder in Windows Explorer”
- Click the bin folder
- Click Debug folder
- Make sure your .dll, .pdb and .wsp files’ modified date is todays date to reflect that you indeed have rebuilt the project
- Make a copy of the wsp file, rename it such as by giving a version number
- Since this is a Sandboxed solution, to deploy click Site Actions -> Site Settings -> Solutions (i.e. under Galleries)
- From Solutions page, click the Solutioms ribon and later Upload Soltuion icon.
- Upload the renamed .wsp file and in the Solution Gallery – Upgrade Soltuion dial box click the Upgrade icon
- As you can see your new .wsp file is activated while the previous .wsp file is deactivated
That is it.
I am writing this tips as a note to myself.
As a SharePoint developer I run my SharePoint 2010 development inside a VM. As times goes by I found myself short of hard disk spaces. Following these steps helped to alleviate the problem:
- Open up your SQL database where SharePoint is installed
- Find the database where its log file is taking up lots of space, in most situations it would be Sharepoint_Config.
- Right click the database -> Properties -> options and now change recovery mode from full to simple
- Right click database again -> Tasks -> shrink -> database then click Ok. This will shrink the SharePoint_Config_log.ldf file
- Finally change the recovery mode to full by following a similar step as #3
Please do not use this technique in prod environment as you normally would require to have a normal database backup process.
This is a note for myself so that I can easily find it.
Today October 25, 2011 I took Umbraco Level 2 test and became Umbraco Certified Developer.
If you are using Windows 2003, then you should be running IIS 6.0. If you do not see Application Pools in the IIS MMC, it looks like you are running in IIS 5 isolation mode. You can verify this, by right clicking on “Web Sites” in the IIS MMC, choose Properties, click on the Service tab, if “Run WWW service in IIS 5.0 isolation mode” is checked, then that is why you do not see Application Pools. You will need to uncheck this setting and restart IIS.
Since in Microsoft Office Excel 2007, the ability to synchronize data between Excel table and a SharePoint list is deprecated we need to download and install an add-in. The add-in then will enable us to update the information in a SharePoint list from Excel 2007.
The first thing we need to do is download and install the Excel 2007 Add-in: Synchronizing Tables with SharePoint Lists into our Microsoft Office 2007 client application.
Please consult this MSDN paper as to how you can install the add-in into Office 2007 and publish the data to a SharePoint list.
Please note that you cannot save your Excel workbook in the new Office Open XML Formats (.docx). Instead, to retain the functionality, you need to save the workbook in the Excel 97-2003 file format (.doc).
If you follow these steps you have now an Excel workbook that has a data and synced to a SharePoint list.
In my next and final blog I will explain as to how we can create the Visifire chart, to display the synced SharePoint list data, using SharePoint designer 2007.
Recently I got a request from a client, which reads as “…currently, we track our budgets and spending for the work units using a series of linked Excel spreadsheets. Admin support enters invoice information into these spreadsheets and the information gets categorized according to pre-defined budget and program codes. We need a Dashboard for our SharePoint that would allow us to present summary information for our spending (budget against spending to date) by extracting information from the spreadsheets..”
A common business issue is the inability to display meaningful Business Intelligence (BI) information in a cost-effective, efficient manner. In Microsoft Office SharePoint Server 2007, we can generate powerful graphs through Performance Point, Excel Services, and SQL Server Reporting Services (SSRS) but these technologies can come at a high cost. The costs make sense for many large companies that are setting up their own SharePoint farm and running extensive analytics. However, this may be overkill for smaller businesses who only want to generate a few basic charts.
In the coming few days I will be blogging as to how I tackled this issue by using Excel 2007 as data source then sync the Excel data to a SharePoint list. Later create a visually appealing chart using SharePoint designer 2007 and Visifire charting control. For today I will show you the end result of my solution which potentially met this client’s requirement.