| ||||||||||
Shopping cart software Solutions for online shops and malls | ||||||||||
|
X-Cart Home | FAQ | Forum rules | Calendar | Mark Forums Read | User manuals | Login |
Importing existing Users List | |||
|
|
Thread Tools | Search this Thread |
#1
|
|||||||
|
|||||||
Importing existing Users List
Hi guys,
I have a user list of about 400 dealers and would like to import them into the databse... any ideas how i can do this? if anyone can help will be great, i'm using phpMyadmin to manage the db. thanks! |
|||||||
#2
|
|||||||
|
|||||||
Re: Importing existing Users List
Quote:
The table in x-cart is xcart_customers. The hard part will be putting the password into the table so that it will work - is it an existing x-cart dealer list? If so, if you export the data from the existing table using phpmyadmin and then simply import the sql into the new table. If it isn't.... a lot of work is needed to encrypt the password that you have in a flat file to get them into the database. The function in xcarts func.php script is: Code:
Now in theory it should be possible to run each name in your list through this function and then add it to the table. Enjoy !! Funkydunk
__________________
ex x-cart guru |
|||||||
#3
|
|||||||
|
|||||||
thanks
Hi there,
thanks for the quick reply, unfortunately the list of users is from another cart. i have been exporting the users list from xcel to txt then importing to the previous cart... i figured the encryption will be a prob, but i'll give it a try. Was hoping that someone had this experience before... thanks again, GC |
|||||||
#4
|
|||||||
|
|||||||
Afraid I haven't got the experience of doing this with x-cart but if you can code a bit in php, you will be able to get it to open your file of the dealer list and loop through each item, encrypting the password, then adding it to the table in x-cart.
If you want help with the code let me know. Funkydunk
__________________
ex x-cart guru |
|||||||
#5
|
|||||||
|
|||||||
I had them customize this for me. In the SQL string the password part just has:
Code:
If you want I can send you the whole file. What I need to do is have the password exported with the order our of xcart so I can import it into my accounting system. |
|||||||
#6
|
|||||||
|
|||||||
a possible solutuion
Some had this posted a while back - SOMEHOW this import post was deleted - Humm??
anyway heres the code: Code:
Now - I have added several EXTRA FIELDS which is a different mod altogether. But this is the concept.... The fields added are for ship to additional info - like phone, fax, email - so I changed the code to add the second email to the email list table. IT WORKS - BUT - the delimiter for the input file is a problem for me. several fields will be entered into 1 MySQL table field. Im no coder but i know enough to be a pain in the A$$. I cant remember what file type to use for import... any help here?
__________________
X-Cart V3.3.6 - w/ Product Import Mod Unix --------------------------------------------- Currently migrating to V4.0.11 |
|||||||
#7
|
|||||||
|
|||||||
my bad
that original thread was here http://forum.x-cart.com/viewtopic.php?t=2972 - but no explaination of input file format. any one?
__________________
X-Cart V3.3.6 - w/ Product Import Mod Unix --------------------------------------------- Currently migrating to V4.0.11 |
|||||||
#8
|
|||||||
|
|||||||
Has anyone done this in the 4.x area? I'm importing several hundred customers from a custom-written ASP cart, and the passwords and credit card numbers are in clear text. I need to encrypt them, but don't have the level of PHP skills to write the code to do so.
I have used PHPMyAdmin to retrieve the datafile into a delimited text file, and can re-insert the data into x-cart, but I need to process it first. Has anyone out there done this and are you willing to share your code? I'm tapped out of cash for paying X-cart, the mods I had to get done for adding mixed discounts and shipping markups based on quantity and restricted shipping to only listed states ate what little budget I had...and we're *so* close to launch.... Thanks for any input. Honestly, I've learned *so* much just reading what y'all have posted, I don't think I would have gotten my cart working so well if it weren't for these forums! Hmm, found this: http://forum.x-cart.com/viewtopic.php?t=2972&highlight=encryption. The code here looks pretty straightforward. Is it ok for 4.013? Thanks!
__________________
Vicky Rowe Satori Digital Marketing http://www.satoridigitalmarketing.com X-Cart Pro Version 4.0.13, running on a Unix server |
|||||||
|
Thread Tools | Search this Thread |
|
|
|
|||
X-Cart forums © 2001-2020
|