osCmax v2.5 User Manual
Results 1 to 2 of 2

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 ...

      
  1. #1
    New Member
    Join Date
    Sep 2008
    Posts
    17
    Rep Power
    0


    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?

  2. #2
    jpf
    jpf is offline
    osCMax Testing Team
    jpf's Avatar
    Join Date
    Sep 2003
    Location
    Manitoba, Canada
    Posts
    2,699
    Rep Power
    22


    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!

Similar Threads

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

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •