AbleCommerce Shopping Cart Software

Hello,

I am trying to import users from a previous store (not able commerce) to able commerce using data port 7.4.

First of all when I open data port I get a waring that: 'Your store configurations are not saved.' I cannot figure out what store configurations are not saved or what this is referencing.

Second of all I have exported the users from the previous store into a CSV file using the following fields:

StoreID
UserName,
FirstName,
LastName,
Email,
IsApproved,
IsLockedOut,
PasswordPlainText,
Address1,
Address2,
City,
PostalCode,
Province,
CountryCode,
Phone

I am able to point DataPort at the CSV and it maps the fields accordingly. However when I do to import/upload the data I get a error stating that: 'No User available for Import(Upload).'. It is not clear if this error message refers to the fact that the tool thinks I am missing fields to import or there is something wrong with the user I am trying to use to import the data with, or if this has something to do with the warning about store configurations when I open the tool.

I have tried turning on the debugging feature in DataPort but I do not seem to get a log file or anything to use to debug.

Also I have attempted to set the UserId to 0 for new users to no avail.

What am I doing wrong here?

Also this is from the able commerce store:

AbleCommerce for ASP.NET
VERSION: 7.0.4.13424
MSSQL v2005
AC SCHEMA v2005
ASP.NET TRUST: Unrestricted

AjaxControlToolkit: 3.0.20229.20843
CommerceBuilder: 7.4.13416.0
CommerceBuilder.AbleCommerceTax: 7.4.13043.0
CommerceBuilder.AcTestProvider: 1.0.0.0
CommerceBuilder.AustraliaPost: 7.1.0.0
CommerceBuilder.AuthorizeNet: 7.3.12625.0
CommerceBuilder.BankOfCanada: 7.3.0.0
CommerceBuilder.CanadaPost: 7.0.0.0
CommerceBuilder.Configuration: 7.4.13416.0
CommerceBuilder.CyberSource: 7.0.9310.0
CommerceBuilder.Data: 7.4.13416.0
CommerceBuilder.DataClient.Api: 7.4.13416.0
CommerceBuilder.DataClient.Csv: 7.0.34.0
CommerceBuilder.DHLInternational: 7.2.11307.0
CommerceBuilder.ECB: 7.0.0.0
CommerceBuilder.FedEx: 7.0.9725.0
CommerceBuilder.GoogleCheckout: 7.3.12468.0
CommerceBuilder.InternetSecure: 7.0.9764.0
CommerceBuilder.LinkPoint: 7.0.9764.0
CommerceBuilder.Paradata: 7.0.9764.0
CommerceBuilder.PayFlowPro: 7.0.10061.0
CommerceBuilder.PayJunction: 7.3.12625.0
CommerceBuilder.PaymentechOrbital: 7.3.12625.0
CommerceBuilder.PayPal: 7.3.13228.0
CommerceBuilder.Protx: 7.3.12327.0
CommerceBuilder.Services: 7.4.13416.0
CommerceBuilder.SkipJack: 7.0.9764.0
CommerceBuilder.UPS: 7.4.13022.0
CommerceBuilder.USPS: 7.0.9728.0
CommerceBuilder.Web: 7.4.13416.0
ComponentArt.Web.UI: 2008.2.1267.3
CyberSource.Base: 2.0.0.0
CyberSource.Clients: 5.0.2.0
CyberSource.Clients.XmlSerializers: 5.0.2.0
CyberSource.WSSecurity: 2.0.0.0
CybsWSSecurityIOP: 1.0.0.0
FredCK.FCKeditorV2: 2.5.2912.21007
ICSharpCode.SharpZipLib: 0.85.5.452
LinkPointTransaction: 1.0.1797.29766
log4net: 1.2.10.0
Microsoft.Web.Preview: 1.2.61025.0
NVelocity: 7.2.0.0
PaygatewayNET: 3.0.0.0
paypal_base: 4.2.1.0
PFProCOMLib: 1.0.0.0
PFProdotNET: 0.0.0.0
RadAjax.Net2: 1.8.3.0
RadCalendar.Net2: 2.2.3.0
RadChart.Net2: 4.1.1.0
RadComboBox.Net2: 2.8.3.0
RadDock.Net2: 1.8.6.0
RadEditor.Net2: 7.3.1.0
RadGrid.Net2: 5.1.1.0
RadInput.Net2: 2.1.3.0
RadMenu.Net2: 4.4.6.0
RadPanelbar.Net2: 4.3.6.0
RadRotator.Net2: 2.7.3.0
RadSpell.Net2: 3.2.3.0
RadSplitter.Net2: 1.3.3.0
RadTabStrip.Net2: 3.6.3.0
RadToolbar.Net2: 1.6.3.0
RadTreeView.Net2: 6.3.3.0
RadUpload.Net2: 2.4.3.0
RadWindow.Net2: 1.9.3.0
Recaptcha: 1.0.0.0
Telerik.Charting: 2.0.2.0
Telerik.QuickStart: 1.0.2827.28014
Telerik.Web.UI: 2008.1.619.20
Validators: 1.0.0.0
WebChart: 1.1.1.6
wiDLL: 1.0.0.0
wwHoverPanel: 1.85.0.0

As a side note running the data port utility as an administrator got rid of the configuration saving error (win7 x64).

As a side note running the data port utility as an administrator got rid of the configuration saving error (win7 x64)

Yes, the DataPort tries to save the settings in a config file but I think it fails because not having write access to local file system in C drive.

'No User available for Import(Upload).'.

This particular error indicates that there is something wrong with your Users CSV data. There might be some syntax error in CSV raising this issue. So, please manually review the CSV file or try to open it in MS Excel and fix any CSV syntax issues. I think the CSV data might be missing some delimiter or quote character etc.

It'd be nice if the tool would make trouble shooting a bit easier when I have thousands of lines of a CSV file to review. Such as saying it cannot parse line number x.

I actually broke my csv file into smaller and smaller chunks trying to find this bad data. It appears that it was quotation marks inside 1 field, it also appears that the tool is splitting the file on quotation marks are not commas. As I can get the offending line to upload when it is on a single line but it breaks things out into different fields.

I finally narrowed this down to 3 lines in a CSV file which will not upload. However when broken out into 3 separate files, it uploads fine. So really it would be nice to have more verbose error messages from the tool.

These lines will not upload when all together....password are removed...bolded line has extra quotes in the Address1 field
"StoreId","UserName","FirstName","LastName","Email","IsApproved","PasswordPlainText","Address1","Address2","City","Province","CountryCode","PostalCode","Phone","IsLockedOut"
"1","CORKIMMIL@aol.com","Kimberly","Miller","CORKIMMIL@aol.com","true","****","1403 Beanehaven Dr.","","Godfrey","IL","US","62035","618-467-6353","false"
"1","coronadovacation@hotmail.com","SUSAN","SMITH","coronadovacation@hotmail.com","true","****","501 "J"AVE.","","Coronado","CA","US","92118","619 435-2211","false"
"1","corrineslade@hotmail.com","corrine ","slade","corrineslade@hotmail.com","true","****","123 Georgia dr","","stephenville, nfld","AL","CA","a2n3l4","7096433201","false"

broken out files that work...
"StoreId","UserName","FirstName","LastName","Email","IsApproved","PasswordPlainText","Address1","Address2","City","Province","CountryCode","PostalCode","Phone","IsLockedOut"
"1","CORKIMMIL@aol.com","Kimberly","Miller","CORKIMMIL@aol.com","true","****","1403 Beanehaven Dr.","","Godfrey","IL","US","62035","618-467-6353","false"

Line that uploads when on a single line but not with others
"StoreId","UserName","FirstName","LastName","Email","IsApproved","PasswordPlainText","Address1","Address2","City","Province","CountryCode","PostalCode","Phone","IsLockedOut"
"1","coronadovacation@hotmail.com","SUSAN","SMITH","coronadovacation@hotmail.com","true","***","501 "J"AVE.","","Coronado","CA","US","92118","619 435-2211","false"

"StoreId","UserName","FirstName","LastName","Email","IsApproved","PasswordPlainText","Address1","Address2","City","Province","CountryCode","PostalCode","Phone","IsLockedOut"
"1","corrineslade@hotmail.com","corrine ","slade","corrineslade@hotmail.com","true","***","123 Georgia dr","","stephenville, nfld","AL","CA","a2n3l4","7096433201","false"

If you set the chunk size under Options--> Settings to 1, you can step thru the import one record at a time.