X-Cart forums - Import / Export

X-Cart forums (https://forum.x-cart.com/index.php)

- Changing design (https://forum.x-cart.com/forumdisplay.php?f=51)

- - Import / Export (https://forum.x-cart.com/showthread.php?t=61259)

Fersick

10-17-2011 08:30 PM

Import / Export

Hi,
I'm trying to import a CSV file that i have exported from an 4.3.2.

But keep getting an error when i it tries to import the USER section.

Code:

Error on line 2: Column 'B_TITLE' is not supposed to be in the section 'USERS' (USERS):

!LOGIN;!USERTYPE;!PASSWORD;!B_TITLE;!B_FIRSTNAME;!B_LASTNAME;!B_ADDRESS;!B_ADDRESS_2;!B_CITY;!B_COUNTY;!B_STATE;!B_COUNTRY;!B

Any Help?

cflsystems

10-18-2011 11:04 AM

Re: Import / Export

Where are you trying to import it? 4.4.x version? There is no "b_" in any of the field titles.

Fersick

10-18-2011 03:33 PM

Re: Import / Export

I'm using the import/export function from both versions of X-cart. I can manually transfer the products over which isn't a problem as all the images are getting updated anyway. But i would love to keep the existing customer list.

Basically what i am doing at the moment is in 4.3.2 going to import/export -> export - leaving everything as default, ticking the users box, then clicking export.

Then in 4.4.4 Im going tools -> import/export -> import - leaving everything as default, selecting load CSV from home computer. If i tick the "user" box in the import options or not i still get the same error.

cflsystems

10-18-2011 06:00 PM

Re: Import / Export

You can't do that. These versions have very different database structure so you can't just "copy/paste". Use the upgrade packs 4.3.2-4.4.0-4.4.4 to properly transfer database over.

All times are GMT -8. The time now is 06:40 PM.