How to Import and Export Promotion Codes
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
This example code shows how to import and export promotion codes (coupons).
To import and export promotion codes
In Visual Studio, create a new Commerce Server Web application.
Add the Microsoft.CommerceServer.CrossTierTypes and Microsoft.CommerceServer.Marketing.CrossTierTypes references to the application.
Add a using directive for the Microsoft.CommerceServer and Microsoft.CommerceServer.Marketing namespaces.
Define the Marketing Web Service URL.
Create the MarketingContext object.
For more information, see How to Connect to the Marketing System. In the following example, the MarketingContext object is named marketingSystem.
Look up the ID of the "BatchPromoCodes" definition.
Export the promotion codes to a file named c:\ExportCodes.txt.
Create a new and empty PromoCodeDefinition object.
Import a group of promotion codes from a file into the PromoCodeDefinition.
For more information about how to create a promotion code file, see How to Create a Coupon File to Import Coupon Data.
Example
The following code example illustrates how to import and export promotion codes. This example builds on the promotion code definition named "BatchPromoCodes" created in How to Generate Coupons and Promotion Codes.
To review the results in the Marketing Manager
Look at the Coupons tab in the properties of a discount item.
Select the "Imported Codes" coupon definition from the drop-down box.
View the import record within the "Batches" grid, including the number of coupons imported.
using Microsoft.CommerceServer;
using Microsoft.CommerceServer.Marketing;
namespace CommerceServerMarketingExamples
{
public class CSMarketingExamples
{
public void ImportExportPromoCodes()
{
try
{
// Set the URL to the Web service.
string marketingWebServiceUrl = @"https://localhost/MarketingWebService/MarketingWebService.asmx";
// Create an instance of the Marketing System agent.
MarketingServiceAgent ma = new MarketingServiceAgent(marketingWebServiceUrl);
MarketingContext marketingSystem = MarketingContext.Create(ma);
// Look up the ID of an existing promotion code definition.
SearchClauseFactory searchClauseFactory = marketingSystem.PromoCodeDefinitions.GetSearchClauseFactory();
SearchClause sc = searchClauseFactory.CreateClause(ExplicitComparisonOperator.Equal, "Name", "BatchPromoCodes");
DataSet dataSet = marketingSystem.PromoCodeDefinitions.Search(sc);
int promoId = (int)dataSet.Tables["SearchResults"].Rows[0][0];
// Export the codes.
PromoCodeDefinitionManager.ProgressEventHandler promoEvents = null;
marketingSystem.PromoCodeDefinitions.ExportPromoCodesForDefinition("c:\\ExportCodes.txt", promoId, promoEvents);
// Create a new promotion code definition for import.
PromoCodeDefinition ipromo = marketingSystem.PromoCodeDefinitions.NewPromoCodeDefinition(PromoCodeUsageOption.Private, 1);
ipromo.Name = "ImportPromoCodes";
ipromo.UsageLimit = 5;
ipromo.Save(true);
// Import promotion codes into the promotion code definition.
marketingSystem.PromoCodeDefinitions.ImportCodes(ipromo.Id, "Imported Codes03", "c:\\ImportCodes03.CSV");
}
catch (Exception ex)
{
Console.WriteLine("Exception: {0}\r\nMessage: {1}", ex.GetType(), ex.Message);
if (ex.InnerException != null)
{
Console.WriteLine("\r\nInner Exception: {0}\r\nMessage: {1}", ex.InnerException.GetType(), ex.InnerException.Message);
}
Console.ReadLine();
}
}
}
}