HomeHome Product Discus... Product Discus...SmithCartSmithCartImporting orders into Smith Cart Importing orders into Smith Cart
Previous
 
Next
New Post
12/23/2011 10:14 AM
 
ambrose alward
No Ranking


Joined: 6/3/2011
Posts: 15

I am getting ready to import our historical orders from virtuemart into smith cart.   My research leads me to belive that there is no direct migration path, So I am looking at mannually moving over the data. 

I am inserting the data into the following tables:

DNN_Smith_Customer

DNN_Smith_Invoicing

DNN_Smith_PayHist

DNN_Smith_StoreOrders

DNN_Smith_StoreOrderDetails

After the import  go into a users account and look at there orders and they are there but if I click on any of them I get the error: A critical error has occurred.An unexpected error has occurred.

the log file reports:

AssemblyVersion: 6.1.0

PortalID: 2

PortalName: MIG Inc.

UserID: 1978

UserName: Ambrose

ActiveTabID: 167

ActiveTabName: My Account

RawURL: /myaccount/tabid/167/userid/1978/default.aspx

AbsoluteURL: /Default.aspx

AbsoluteURLReferrer: http://mig-inc.com/myaccount/tabid/167/userid/1978/default.aspx

UserAgent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:8.0.1) Gecko/20100101 Firefox/8.0.1

DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider

ExceptionGUID: 9be18d8d-789c-47c6-8c92-5d74f0049e85

InnerException: Value was either too large or too small for a Decimal.

FileName:

FileLineNumber: 0

FileColumnNumber: 0

Method: System.Decimal.FCallSubtract

StackTrace:

Message: DotNetNuke.Services.Exceptions.PageLoadException: Value was either too large or too small for a Decimal. ---> System.OverflowException: Value was either too large or too small for a Decimal. at System.Decimal.FCallSubtract(Decimal& result, Decimal d1, Decimal d2) at System.Decimal.op_Subtraction(Decimal d1, Decimal d2) at Smith.DNN.Modules.MyAccount.MyAccountManageOrders.ShowOrderDetails(Object sender) at Smith.DNN.Modules.MyAccount.MyAccountManageOrders.lkSelect_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: Storm

Am I missing a table that needs data?  Or is it that a value is incorrect?
 
New Post
12/23/2011 4:15 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0
Hi Ambrose,

Which version of the Cart and DNN are you currently running?

Is the data you are importing from another SmithCart? If so which versions to and from?

If the data is coming from a database other than sql server like a uniz platform, mainframe or vsam/isam files the data is most likely stored in a different data format and when exported could include characters that may not be visible in ascii so make sure your data is clean of any special characters before importing.

Make sure that alphanumeric fields that have all numbers (i.e. sku) have a single quote in front of the them as excel converts these fields to numbers or scientific notation in some cases if the number is big enough.

To ensure the correct data format, I suggest first copying to notepad before pasting to the SmithCart spreadsheet to strip characters that may not be visible.

Thanks,
 
New Post
12/27/2011 8:51 AM
 
ambrose alward
No Ranking


Joined: 6/3/2011
Posts: 15
DNN is 6.01.00
Smith cart is 4.70.0
The data is comming from virtuemart (joomla's shopping cart) running on a windows 2008 with Mysql
I understand it might be a format issue, My main question is are there any other tables other then:
DNN_Smith_Customer

DNN_Smith_Invoicing

DNN_Smith_PayHist

DNN_Smith_StoreOrders

DNN_Smith_StoreOrderDetails


That need to be populated?
 
New Post
12/27/2011 12:52 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0
Hi Ambrose,

It's looks like you have all the correct tables associated with the order history of your store. You may want to also check the PortalID of those tables.

Thanks,
 
 Page 1 of 1
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartImporting orders into Smith Cart Importing orders into Smith Cart




Questions? Contact us for answers!

Contact Us!