Showing posts from 2010

Commerce Server Inventory System Part 1

Inventory management is a vital part of any retail business, whether it’s a traditional brick-and-mortar shop or an online Web site.Inventory management provides you with critical information about the condition of your products, such as whether you are low on stock and your inventory needs to be replenished.Inventory management also provides your customers with accurate information, letting them know when items are out-of-stock, back-ordered, or pre-orderable.Failure to provide your customers with this information puts you at risk of losing future business.Inventory management also gives you insight into which products are selling well and which products are not.This information allows you to make better business decisions on how to market your products, and whether or not to even carry them.Previous versions of Commerce Server to 2007 did not have an out-of-the-box inventory system.Instead, developers were either required to customize and extend the catalog schema, as well as write …

Commerce Server Template Pack for SharePoint 2010

At our User Group meeting last week, I installed the Template Pack live on a SharePoint 2010 installation. Several asked to have the procedure I used, so here goes.

The main point with the template pack is that it works with CS2009, you do not have to wait for R2.

1. First you will need a functioning SharePoint 2010 installation. This has quite a high Hardware Spec, with 64 bit and 8 GB. I did my Hyper V installation with 4 GB, but I am not recommending this. If you are using virtual images you will need a separate machine as a domain controller. Yes, I know you there are other options, hacking SharePoint (for local accounts) or hacking Commerce Server (so that you can install on a domain controller) but the whole point is to have a supported installation.

2. Second you will need to go through the usual fun process: Install Commerce Server 2007, Configure, Install Commerce Server 2009, Configure. Make sure you have everything you need (eg. Business Tools) otherwise you will have to unins…

The Microsoft Certified Master program

I just added the MCM logo to my blog. Why? Just another certification from Microsoft? Last time I looked on my transcript, I had the following, MCT, MCSD, MCDST, MCAD, MCDBA, MCSA, 2 MCITPs, 19 MCTSs, 5 MCPDs and 3 MCSEs. Each of those certifications took a lot of work and study and I consider each a good proof of competence in a technical area. Why am so excited about 3 more unpronounceable letters? ( so much so that when the email came late at night on Friday, our whole family was dancing around our home).

The key lies with the difficulty of the Master certification. The Master certification in effect certifies that one is an expert in a particular area, in my case SharePoint 2007. When I came to the three weeks of intensive course in Redmond in March 2009, I considered myself very competent in SharePoint, I had worked with SharePoint from the early beginnings of Digital Dashboard, all though the incarnations 2001, 2003 and 2007. I had gained a lot of experience, coaching a consul…

Creating a generic Data Form web part with SharePoint Designer 2010

If you create a List Form web part and save it to a file or gallery you get a prompt whether you want the web part saved with a relative path (list name is stored in the web part) or fixed to thesite (list id is saved in the web part)

If you create a Data Form web part and save it to a file or gallery you do not get this prompt. Insert > Data View > Empty Data View Select a Data Source, then insert fields as Single Item Form. Save Web Part to a gallery.
To make the web part generic and referencing a file name you need to do the following changes.
In the property ParameterBindings replace: ParameterBinding Name="ListID" Location="None" DefaultValue="{01CF5B35-CB1E-4A5A-82D1-144C6A0312E2}" with ParameterBinding Name="ListName" Location="None" DefaultValue="Shared Documents"
Also replace property name="ListName" type="string">{01CF5B35-CB1E-4A5A-82D1-144C6A0312E2} with property name="ListName" type=&quo…

Commerce Server Training in Canada

Just got back from Ottawa, after giving my Commerce Server Training there. Thanks to Itplanit, it was an excellent training center, everything worked well. Did not get a chance to get across and visit those I know at Cactus, will have to do that next time.

Using SSL in Windows 2008

Our old friend SelfSSl does not work in IIS 7.0. But it is easy enough to set up a certificate and use SSL. Here is the brief version:
Server Name > Server Certifications > Create Self-Signed Cert
Go to site > Right click > Edit Bindings > Add one for https with unused port
Select the cert you created.
Restart web site then click on the correct browser link for the port on the right
You will get a warning that the cert is unsafe, but you can continue to the site.

Here is a longer version if you get stuck:

Recycling Application Pools in Windows 2008

C:\Windows\System32\inetsrv>appcmd stop apppool sharepointapppool
C:\Windows\System32\inetsrv>appcmd start apppool sharepointapppool
Here is the a command file that does the above.

2nd Commerce Server User Group Meeting - Commerce Server Staging

Great user group meeting. Especially enjoyed the practical tone of the questions.
Here are the links I mentioned in my talk: Using SQL instead of Access command line Developing with the Staging API Creating log files
We will have the next meeting on November 5, subject will be CS and SharePoint 2010.

Sychronizing SharePoint Profiles with Active Directory

There are a lot of urban myths about importing profiles from AD, particularly on some blogs where it is claimed that deleted users are only erased from SharePoint on the third try.
Here are the steps when a user is deleted from Active Directory:
1. When the profiles are synchronized with Active Directory, the bDeleted flag is set to true in the SSP's UserProfile_Full table. Full description is here:
2. Every hour the MySiteCleanup job runs. If bDeleted is true the job deletes the profile from UserProfile_Full table and adds it to the deleted users. The manager gets a email and ownership of the MySite.
3. Every five minutes each Content DataBase sychronizes its UserInfo table with the SSP. This is the Quick Profile Synchronization (WSSSweepSynch).
4. Every hour there is a complete synchronization Profile Sychronization (WSSProfileSych). This is bidirectional, in the up direction the Profil…

Recipe:RSS Viewer in MOSS 2007

1. To add a feed for a list or document library.Go to list, actions, rss feed. Save address. Go to page, add web part, copy address into url.
2. To set refresh for rss feed. Site collection rss settings. Settings for web part. But...refresh is hard coded at 60 minutes!
Kerberos Authentication, needed even if sql on same box.
Add the following registry value: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\Kerberos\Parameters
Registry Value: LogLevel Value Type: REG_DWORD Value Data: 0x1
But you will get some false errors.
Kerbtray gives the tickets for the current logged in user only. See great blog.
When cross forest trust, make sure that forest and domains are 2003 level, otherwise will only have external trusts which will not use kerberos. Make sure the web site is trusted site to see RSS feed.

Recipe: Using Kerberos with MOSS 2007 and Windows 2003

1. SPN for SQL Install ADSIEdit on DC from W2003 Support Tools. Change SPN of SQL Service Account to: MSSQLSvc/
MSDN also says add not just FQDN but NetBIOS name also: MSSQLSvc/sql1:1433 Don't understand why this is necessary. If the SQL is on the same machine as MOSS Kerberos will not be used. Ditto named pipes are used. See blog. You can also check your work by using the SetSPN -L SQLService From the the W2003 Resource kit you can use Klist and Kerbtray To list or purge the Tickets use Klist tickets or Klist purge.
2. SPN for Central Admin Add SPNs to Central Admin App Pool Identity. HTTP/moss01:12345 HTTP/moss01.litware:12345 Change Central Admin to negotiate Use this link to get to stsadm stsadm -o authentication -url http://moss01:12345 -type windows -usewindowsintegrated Browse to site.
If you get following error Logon Failure: Reason:Unknown user name or bad password User Name: Domain: Logon Type:3 Logon Process:Kerberos Authentication Package:Kerberos Workstation Name:- Caller U…

Recipe: IIS Compression with IIS 6.0

CSCRIPT.EXE ADSUTIL.VBS SET W3Svc/Filters/Compression/DEFLATE/HcFileExtensions "htm" "html" "txt" "css" "js" CSCRIPT.EXE ADSUTIL.VBS SET W3Svc/Filters/Compression/GZIP/HcFileExtensions "htm" "html" "txt" "css" "js" CSCRIPT.EXE ADSUTIL.VBS SET W3Svc/Filters/Compression/DEFLATE/HcScriptFileExtensions "asp" "exe" "axd" "aspx" CSCRIPT.EXE ADSUTIL.VBS SET W3Svc/Filters/Compression/GZIP/HcScriptFileExtensions "asp" "exe" "axd" "aspx" CSCRIPT.EXE ADSUTIL.VBS SET W3Svc/Filters/Compression/DEFLATE/HcDynamicCompressionLevel "9" CSCRIPT.EXE ADSUTIL.VBS SET W3Svc/Filters/Compression/GZIP/HcDynamicCompressionLevel "9"
blobcache location="C:\blobCache" path="\.(gif|jpg|png|css|js)$" maxsize="10" age="86400" enabled="false">

Commerce Server - Cannot connect to named instance

Have seen this several times during install or CSConfig, have found that the best solution is to give the exact port number of the SQL instance and to make sure that you are communicating over TCP.

Bug in Catalog System - Error Cannot delete default Language

Haven't seen this documented anywhere.If the default Catalog language is not en-US, it will not let you delete en-US, you get the error "cannot delete default language. Heard the solution from one of the delegates in my Commerce Server Experts Training, you need to change the language of the Catalog Manager temporarily away from en-US.
With thanks to Ralf Höppner.

Publicly accessible CS2009 site on SharePoint!

Just came across this site built on SharePoint and Commerce Server 2009. Would be interested to hear of any other public sites on the same architecture.

Virtualpc has no networks when booted in hyper-v

Seems to be a HAL problem. Use MSconfig.exe to change boot options, advanced to detect HAL.

CS: Direct Mailer

Reminder: Add the Marketing Web Service account(not just the DM Service Account) to the DML_SG Group Add CommerceDirectMailerAuthenticationModule to the HttpModule section of the web.config

Recipe: SharePoint Excel Services

From MSDN:
By default, cross-domain workbook and data connection access is not allowed. To allow workbooks in trusted file locations
stsadm.exe -o Set-EcsSecurity -Ssp -AllowCrossDomainAccess true|falseThe requesting Web pages and the workbooks or data connections must reside in the same farm.

Recipe: Setting up Interfarm SSP

1. Parent farmFind out Sql name and configdb name. Give read rights to config db to whom? msdn says child farm administrator account Provide ssp to child farms Give child farm user rights to parent ssp blog says child farm CA app pool
2. Child farm Set up to consume web services msdn says parent farm admin must be granted Full Read to each child Web application using Web App policy Assign WApps to parent ssp

Schema changes CS 2007 SP2 and CS2009

Have been upgrading some systems from CS2007 SP1 to SP2 and then on to CS2009. The question came up if there are any schema changes between these versions. I took a backup of the product catalog before and after these changes and used Red Gate SQL Toolbelt to compare the databases. There were changes to contraints and stored procedures but no schema changes.

I survived the First User Group Meeting

The technology worked well. We used Live Meeting. It was a new experience for me to talk to the webcam instead of a room full of people. The interchange was interesting, it was interesting to hear about the present projects and hear why some are waiting for R2. Hope to put on a second meeting soon.