input String Error During Shipping Calculation

Item		Qty	Total
	{{cartItem.ProductName}} SKU: {{cartItem.ProductSku}}	{{cartItem.Quantity \| number : 2}} x {{cartItem.UnitCost \| currency : '$' : 2}}	{{cartItem.UnitCost * cartItem.Quantity \| currency : '$' : 2}}
{{itemVariant.VariantHasText ? (itemVariant.VariantName + ': ' + itemVariant.VariantText) : (itemVariant.VariantGroup + ': ' + itemVariant.VariantName)}}
You have no items in your shopping cart.
Subtotal	{{minicart.cartTotals.SubTotal \| currency : '$' : 2}}

Image	Item	Qty	Total
	{{cartItem.ProductName}} SKU: {{cartItem.ProductSku}}	{{cartItem.Quantity \| number : 2}} x {{cartItem.UnitCost \| currency : '$' : 2}}	{{cartItem.UnitCost * cartItem.Quantity \| currency : '$' : 2}}
{{itemVariant.VariantHasText ? (itemVariant.VariantName + ': ' + itemVariant.VariantText) : (itemVariant.VariantGroup + ': ' + itemVariant.VariantName)}}
You have no items in your shopping cart.

Status	Order No.	Order Date	Ship To	Order Total	Pay Total	Balance
Bill Me Later Open Ready To Ship Shipped Picked Up Cancelled Incomplete On Hold Back Ordered Returned {{order.Status}}	{{order.OrderID}}	{{order.OrderDate \| date : 'M/d/yyyy'}}	{{order.ShipFirstName}} {{order.ShipLastName}}, {{order.ShipAddress1}} {{order.ShipAddress2}}, {{order.ShipCity}}, {{order.ShipState}} {{order.ShipZipcode}}	{{order.GrandTotal \| currency : '$' : 2}}	{{order.PayTotal \| currency : '$' : 2}}	{{order.GrandTotal - order.PayTotal \| currency : '$' : 2}}

Home

Product Discus...

SmithCart

input String Error During Shipping Calculation

8/11/2011 12:08 AM

Ismet Dumlupinar

Joined: 7/10/2011

Posts: 38

input String Error During Shipping Calculation

DNN: 5.6.3

Portal has localization for both en-US and fr-CA.

SC: 4.50 Trial

Working Scenario: Buyer has IE9 set to English (United States) from Internet Options > Languages. He logins to portal and goes to SC page, adds an item to cart and goes to view cart. Then he inputs his address data and zipCode with one of the available shipping options. And then he clicks on Calculate shipping. Shipping Calculator works. (zipCodes are in this format: *** *** [e.g. H4N 1F6]

Scenario Throwing an input String Error: Buyer has IE9 set to French (Canada) (fr-CA) from Internet Options > Languages. He logins to portal and goes to SC page, adds an item to cart and goes to view cart. Then he inputs his address data and zipCode with one of the available shipping options. And then he clicks on Calculate shipping. Shipping Calculator throws following error:

AssemblyVersion: 5.6.3

PortalID: 0

PortalName: SomeShop

UserID: 5

UserName: HelloWorld

ActiveTabID: 76

ActiveTabName: Store

RawURL: /Store/tabid/76/ctl/Cart/mid/439/Default.aspx

AbsoluteURL: /Default.aspx

AbsoluteURLReferrer: http://www.Store.com/Store/tabid/76/ctl/Cart/mid/439/Default.aspx

UserAgent: Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)

DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider

ExceptionGUID: dd5b5dfa-3dd2-42f4-b274-fa192d2841a3

InnerException: Input string was not in a correct format.

FileName:

FileLineNumber: 0

FileColumnNumber: 0

Method: System.Number.StringToNumber

StackTrace:

Message: DotNetNuke.Services.Exceptions.PageLoadException: Input string was not in a correct format. ---> System.FormatException: Input string was not in a correct format. at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseDecimal(String value, NumberStyles options, NumberFormatInfo numfmt) at System.Convert.ToDecimal(String value) at Smith.DNN.Modules.BuyNow.Cart.GetTotalAfterTax() at Smith.DNN.Modules.BuyNow.Cart.UpdateTotalLabel() at Smith.DNN.Modules.BuyNow.Cart.btnApply_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e) at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---

Source:

Server Name: WIN-Store

My notes: My friend told me about using commas or dots in Shipping Rates, he say that they are using commas, while module accepts dots for decimals. Maybe this is the reason why shipping calculation fails to complete and throw an exception.

Can you reproduce and provide a fix?

We are very close to complete our tests and we will buy licenses for multiple concepts. I'm attaching a fr-CA localization pack in case you need it for testing.

8/11/2011 6:52 PM

Joined: 1/1/0001

Posts: 0

Re: input String Error During Shipping Calculation Modified By on 8/11/2011 6:53:00 PM

Hi Ismet,

By default Smith Cart displays all content in English. For a full description of how to enable different languages or install language packs in your DNN portal please refer to the DotNetNuke® User Guide. There are a few different ways your site can be localized for a different language, through the browser, by installing a Language Pack in DNN, and also installing a Language Pack provided for the Cart available on the SmithCart Language Packs page available above in the drop-down of the Forums menu option above. for more information and instructions you can also refer to our manual starting at the bottom of pg.270 here: http://www.smith-consulting.com/Porta...

Thanks,

8/14/2011 1:19 AM

Ismet Dumlupinar

Joined: 7/10/2011

Posts: 38

Re: input String Error During Shipping Calculation

Kevin, no offense but i know how to work with localization. I'm not a newbie at DNN, using it for about 6 years and I'm a member of localization team.
I'm making a wild guess and telling you that i might have discovered a bug (maybe more) and trying to report it.
Allow me a few moments and I'll support my case with screenshots.
Then maybe you will accept my report and try to find a solution.

8/14/2011 7:54 AM

Ismet Dumlupinar

Joined: 7/10/2011

Posts: 38

Re: input String Error During Shipping Calculation

Guys, please take a look:
http://stackoverflow.com/questions/5757315/round-trip-problem-when-using-formview-with-localization-in-net-3-5-web-applicat
Our problem with input string is similar to this..
And i strongly believe this is a Smith Cart module bug. Looking at following:

Message: DotNetNuke.Services.Exceptions.PageLoadException: Input string was not in a correct format. ---> System.FormatException: Input string was not in a correct format. at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseDecimal(String value, NumberStyles options, NumberFormatInfo numfmt) at System.Convert.ToDecimal(String value) at Smith.DNN.Modules.BuyNow.Cart.GetTotalAfterTax() at Smith.DNN.Modules.BuyNow.Cart.UpdateTotalLabel() at Smith.DNN.Modules.BuyNow.Cart.btnApply_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e) at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---

Module is complaining about number format in database. Please help us to solve this problem.

Aren't you able to replicate this problem on your installation??

I already attached a language pack.

Until i hear from you saying "Hey, i tested this on our local installation and i am unable to reproduce" i'll continue believing it's a module bug.

8/14/2011 9:14 AM

Ismet Dumlupinar

Joined: 7/10/2011

Posts: 38

Re: input String Error During Shipping Calculation

Kevin another note: SQL Server Management Studio displays Price column of ShippingbyZipCode table as "Money". Do you think changing this value might help?

On your side for Price type is Money right?

8/15/2011 12:59 PM

Joined: 1/1/0001

Posts: 0

Re: input String Error During Shipping Calculation

Hi Ismet,

I just tried to re-produce this error on my test portal and was unable to recreate the error but I may not have the exact same configuration as you. Can you login to our test site http://www7.smith-consulting.com/ and try to replicate the error. This will determine if the issue is with the latest version of the cart or an issue with your specific dnn portal/cart install.

Please email me at kevin@smith-consulting.com if you need login credentials.

Thanks,

8/20/2011 6:19 AM

Ismet Dumlupinar

Joined: 7/10/2011

Posts: 38

Re: input String Error During Shipping Calculation

Kevin i sent you an email, i also attached a video inside it and waiting for the response.
Thank you.

8/22/2011 12:44 PM

Joined: 1/1/0001

Posts: 0

Re: input String Error During Shipping Calculation

Hi Ismet,

Thank you, I have sent you the credentials to our test portal.

8/23/2011 4:47 AM

Ismet Dumlupinar

Joined: 7/10/2011

Posts: 38

Re: input String Error During Shipping Calculation

Kevin, here is the first results of my test. Regardless of uploading language pack, I went ahead to Admin > Languages on your test portal and added French (Canada) from the list.

Then set up Store Settings to use Canadian Dollar. Added a shipping method called Rapide Delivery,
And added a postcode & rate at Shipping section.

Tried to have shipping & tax calculated correctly, but it is not. Same input string error is displayed. So, i don't think there is a problem with our localization. Your module simply refuses to make the calculation, instead displays Input String error when it is set to use fr-CA.

Try yourself, if you still don't understand it by watching the video i sent you earlier.
http://www19.smith-consulting.com
Login as host and the password you sent me.

Logged error is:
AssemblyVersion: 5.6.3
PortalID: 0
PortalName: My Website
UserID: 1
UserName: host
ActiveTabID: 41
ActiveTabName: Home
RawURL: /Home/tabid/41/ctl/Cart/mid/380/language/fr-CA/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www19.smith-consulting.com/Home/tabid/41/ctl/Cart/mid/380/language/fr-CA/Default.aspx
UserAgent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/13.0.782.112 Safari/535.1
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: cdb445f2-a6a7-4767-b4ec-754ab3b280fb
InnerException: Input string was not in a correct format.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Number.StringToNumber
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: Input string was not in a correct format. ---> System.FormatException: Input string was not in a correct format. at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseDecimal(String value, NumberStyles options, NumberFormatInfo numfmt) at System.Convert.ToDecimal(String value) at Smith.DNN.Modules.BuyNow.Cart.GetTotalAfterTax() at Smith.DNN.Modules.BuyNow.Cart.UpdateTotalLabel() at Smith.DNN.Modules.BuyNow.Cart.btnApply_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e) at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---
Source:
Server Name: NEPTUNE

8/23/2011 8:34 PM

Joined: 1/1/0001

Posts: 0

Re: input String Error During Shipping Calculation

Hi Ismet,

I have emailed you regarding this issue of using multiple languages and using Custom Shipping Method by Zipcode as well as forwarded all the information you have sent me into programming and we are looking into this. I will post back as soon as I have any further information.

Thanks,