Unanswered Question During CS2007 Developer Boot Camp

Here are the answers to the question I couldn't answer during the boot camp as well as some links I promised.

Questions:

1. Cab File location can be found at Installation and Configuration Guide for Microsoft Commerce Server 2007 section 11. To save you a few steps see below.
   • The locations for the CAB files are as follows:
     • Windows Server 2003 32 bit DE: https://go.microsoft.com/fwlink/?LinkID=63719
     • Windows Server 2003 32 bit EN: https://go.microsoft.com/fwlink/?LinkID=63706
     • Windows Server 2003 32 bit FR: https://go.microsoft.com/fwlink/?LinkID=63721
     • Windows Server 2003 32 bit JA: https://go.microsoft.com/fwlink/?LinkID=63727
     • Windows Server 2003 x64 DE: https://go.microsoft.com/fwlink/?LinkID=63729
     • Windows Server 2003 x64 EN: https://go.microsoft.com/fwlink/?LinkID=63730
     • Windows Server 2003 x64 FR: https://go.microsoft.com/fwlink/?LinkID=63731
     • Windows Server 2003 x64 JA: https://go.microsoft.com/fwlink/?LinkID=63732
     • Windows XP 32 bit DE: https://go.microsoft.com/fwlink/?LinkID=63733
     • Windows XP 32 bit EN: https://go.microsoft.com/fwlink/?LinkID=63734
     • Windows XP 32 bit FR: https://go.microsoft.com/fwlink/?LinkID=63735
     • Windows XP 32 bit JA: https://go.microsoft.com/fwlink/?LinkID=63736
     • Windows XP x64 DE: https://go.microsoft.com/fwlink/?LinkID=63737
     • Windows XP x64 EN: https://go.microsoft.com/fwlink/?LinkID=63739
     • Windows XP x64 FR: https://go.microsoft.com/fwlink/?LinkID=63742
     • Windows XP x64 JA: https://go.microsoft.com/fwlink/?LinkID=63745
2. Importing Partial File for Catalog Import? The answer is no you can't import partial files but you can use a query to export which could resolve some scenarios. If you must then I would recommend reading the XML file and creating a new XML file based on your business rules.
3. Marketing Tools:
   • dmlrun.exe
   • PurgeCommerceData.exe This tool has other options but the question was more specific about Marketing.
     • Remove deleted data: customers, campaigns, global expressions, campaign items, ads, discounts, Direct Mail templates, and coupon codes that are older than the "deleted number of days" specified.

Links:

1. Design Patterns Link
2. Microsoft's Patterns and Practices home page
3. Commerce Server Virtual Labs
   • Lab 15 which I found out has a few minor errors should be substituted for Microsoft Commerce Server 2007 - Customization and Extensibility.