osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 

Possible to Load Customer Database From Excel?

This is a discussion on Possible to Load Customer Database From Excel? within the osCMax v2 Customization/Mods forums, part of the osCMax v2.0 Forums category; I built a site for a customer of mine that has an extensive existing customer database in Excel format. I ...



Find us on Facebook
Go Back   osCommerce and osCMax shopping cart software forums > osCMax v2.0 Forums > osCMax v2 Customization/Mods

Connect with Facebook Register FAQDonate Members List Calendar Mark Forums Read


Closed Thread

 

LinkBack Thread Tools
  #1  
Old 10-20-2008, 12:00 PM
New Member
 
Join Date: Sep 2008
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
m82492 is on a distinguished road
Default Possible to Load Customer Database From Excel?

I built a site for a customer of mine that has an extensive existing customer database in Excel format. I would like to get her customers loaded into her new site. Is there a way to upload her customers into OSCMax similar to what Easy Polpulate will do for products?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #2  
Old 10-21-2008, 08:25 AM
jpf's Avatar
jpf jpf is offline
Moderator

 
Join Date: Sep 2003
Location: Manitoba, Canada
Posts: 2,681
Thanks: 12
Thanked 214 Times in 196 Posts
Rep Power: 20
jpf has much to be proud ofjpf has much to be proud ofjpf has much to be proud ofjpf has much to be proud ofjpf has much to be proud ofjpf has much to be proud ofjpf has much to be proud ofjpf has much to be proud ofjpf has much to be proud of
Default Re: Possible to Load Customer Database From Excel?

Yes you can - is it easy - no.

Options:
1. Massauge the data - then put in to a CVS file then massauge it again into a SQL statement.
2. Get ODBC drivers - let excel put it into mySQL.
3. Manually enter into osCMax

There is several steps in order to do the above. Depend HOW many enties you need to do and IF you have enough information to do it.
__________________
JPF - osCMax Fourm Moderator - To contact, post on the forum or click here
Try out our osCMax at: Live Catalog Demo
Limited access Admin: Live Admin Demo
Feel free to add products they way you want and then purchase them -=+=- Sorry nothing will be billed or shipped!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Closed Thread

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads

Thread Thread Starter Forum Replies Last Post
I can't get my ssl cerificates to load JKZ33@AOL.COM osCMax v2 Installation issues 9 01-30-2008 06:41 AM
Question about customer’s state information and database! webwolfe osCMax v1.7 General Mods Discussion 1 04-10-2006 06:37 PM
Which PayPal IPN to load? DerekJ osCMax v1.7 Discussion 5 04-04-2005 03:32 AM
Adding a field in customer database ksl8313 osCommerce 2.2 Modification Help 3 02-27-2005 12:21 AM
One Page Will Not Load annea03 osCMax v1.7 Discussion 4 09-23-2003 11:19 AM


All times are GMT -8. The time now is 09:58 PM.


Powered by vBulletin®
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO
Copyright 2009 osCMax
Inactive Reminders By Icora Web Design