|
Group: Forum Members
Last Active: Tue 31 Mar 2015
Posts: 68,
Visits: 185
|
I am looking at importing customer details from an old Cactushop database. Although the database has been deleted, the customer data has been saved into an excel spreadsheet.
The data has been converted to an older Excel 93-97 format and using Datatools I have tried to import.
However, a message appears;
[Data Sheet] 13333 records/lines detected.
Unexpected number of columns: 14. Please select another file/sheet (should be 2 columns or 29+ coulmns).
Please can you provide guidance on importing customer details.
|
|
Group: Administrators
Last Active: Fri 15 Sep 2023
Posts: 806,
Visits: 2,737
|
Actually, a better option might be to import into a CactuShop db and then use the Data Tool on that - still need a .vbs to do the data into CactuShop, but this way you can let the Data Tool handle the hard work of the password hashing, by importing customers from CactuShop to Kartris with the Data Tool.
--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.
If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
|