RegionCodes table of the transactionconfig database
Hi All,
I am a beginner in CS and am configuring Starter Site according to the needs of the project. I am after a more definite answer on this below mentioned question.
How would one go about configuring or adding countries in Starter Site for delivery addresses etc.?
I have got an answer in one of my previous posts from Joe Wasson - MSFT, which is mentioned below:
This is exposed through the RegionCodeDataSet of Commerce Server. The data is contained in the RegionCodes table of the transactionconfig database. (I'm not sure if it is exposed through the Customer and Orders Manager UI, I don't have a box installed I can look at and no one is around
I could not find UI in Business User Application Managers to add a country, hence I did try to change the tables but it consists of the following fields:
Type, Code, Group, Name, Description, LastModified and Created.
Out of which few fields I can understand and know what data to put into but I cannot exactly make out what would go in type, code, group and name.
The trouble I fall across in the CS 2007 Starter Site is this. I add products to my shopping cart. Click on checkout and it would ask for my account log in (if I am not logged in). Once logged in it asks me toEnter or update shipping address information, which is fair enough. But in the Country dropdown box/Combo box there are no options at all. I want to populate these options by various countries.
Hope the above mentioned makes sense.
Many thanks.
Shriroop.
Shriroop,
The RegionCodes table should've been populated correctly when you unPUPed the starter site or CSharpSite, as they are packaged in both of those files.
Based on looking at what I have on my image, I will attempt to explain what's in this database.
Type : 1 (Country) or 2 (State/Province).
Code: 2 or 3 letter code corresponding to country/state/province (such as "US" for United States, or "SK" for Saskatchewan).
Group: If type is 2, this needs to correspond to a country (Saskatchewan would need to map to "CA").
Name: Full name of country/state/province.
Description & Modified By: Not sure if this is needed
And then there are some timestamps, but I don't think you need to worry about this.
Hi Joe,
I have followed your instructions and now I can view the country in the drop down box.
Perfect.
But again as you have mentioned - "The RegionCodes table should've been populated correctly when you unPUPed the starter site or CSharpSite, as they are packaged in both of those files." This has not happened at all. I did import the sample data and also the package unpacking did not have any errors that I can remember.
Would you be able to tell me if there is a way of populating the database again with these codes and having a list of those areas and the countries?
Many thanks
Shriroop.
Shriroop,
I do not believe region codes are part of the Sample Data Import wizard, I think they're just part of the packaged database.
If you want to unpackage just one part of a PUP, go through the Site Packager and select Unpack, then Custom. You should see eventually see a radio button that allows you to unpack specific resources to an existing site. I suppose you could just try unpacking the transactions config database. Not sure if this will work any better than the first time you unpacked this, though.
