Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Import Users Problem Rate Topic   - - - - -

 
  • dioskouros
  • Member
  • Members
  • Join Date: 21-Jul 10
  • 68 posts

Posted 29 May 2018 - 05:56 PM #1

Hello,

 

I have installed 4.7.4 version recently as I was asked to "modernise" an old eshop.

 

I have created a csv file accordind to structure of an exported csv from cs-cart (as I couldn't find an sample anywhere !)

 

I have tried all the combinations of comma seperated or delimeter, of text distinction by single or double quotes but all I get is "Error : The impoted file must contain these fields: E-mail"

 

Please help ,I don't have a clue what causes this problem

 

thank you 



 
  • oleg.gorshkov
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 06-Dec 13
  • 2896 posts

Posted 30 May 2018 - 05:38 AM #2

Hello,

 

I have installed 4.7.4 version recently as I was asked to "modernise" an old eshop.

 

I have created a csv file accordind to structure of an exported csv from cs-cart (as I couldn't find an sample anywhere !)

 

I have tried all the combinations of comma seperated or delimeter, of text distinction by single or double quotes but all I get is "Error : The impoted file must contain these fields: E-mail"

 

Please help ,I don't have a clue what causes this problem

 

thank you 

 

Hello!

 

What columns do you have in your file?

 

Also try to export file and import it without any changes to define if the issue is in your file.


Simtech Development | sales@simtechdev.com | www.simtechdev.com
CERTIFIED CS-CART PARTNER | LICENSES | DEVELOPMENT | ADD-ONS | DESIGN | UPGRADE

Mega SEO Package - All you need for your SEO


 
  • dioskouros
  • Member
  • Members
  • Join Date: 21-Jul 10
  • 68 posts

Posted 30 May 2018 - 08:01 AM #3

I use the exported file from cs-cart with these columns:

E-mail

User type

Status

Password

First name

Phone

Web site

Language

Billing: first name

Billing: address

Billing: address (line 2)

Billing: country

Billing: zipcode

Shipping: first name

Shipping: address

Shipping: address (line 2)

Shipping: country

Shipping: zipcode

Reward points user

(reward points  from a third party addon which exported the points per user, fine)

 

I saved the file with utf-8 encoding , comma seperated and double quotes for text.

some rows include NULL word in some fields or empty fields, but not empty email.



 
  • dioskouros
  • Member
  • Members
  • Join Date: 21-Jul 10
  • 68 posts

Posted 30 May 2018 - 10:10 AM #4

Finally found the problem 

The soft maker office software was damaging my csv !

Edit it with libre office and the import was successfull

 



 
  • oleg.gorshkov
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 06-Dec 13
  • 2896 posts

Posted 30 May 2018 - 12:29 PM #5

Finally found the problem 

The soft maker office software was damaging my csv !

Edit it with libre office and the import was successfull

 

Thank you for the update. Glad to know that the issue is resolved.


Simtech Development | sales@simtechdev.com | www.simtechdev.com
CERTIFIED CS-CART PARTNER | LICENSES | DEVELOPMENT | ADD-ONS | DESIGN | UPGRADE

Mega SEO Package - All you need for your SEO