SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Thread: CSV Excel file

  1. #1
    SitePoint Guru
    Join Date
    Aug 2004
    Location
    Earth
    Posts
    739
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    CSV Excel file

    Hi,

    I want to use a csv file of products for a shopping cart.. the csv file will be updated daily via ftp.. Am I best to read from the csv file to populate the cart or have the file dumped into the database and populate the cart that way?

    Thanks

  2. #2
    SitePoint Wizard silver trophybronze trophy Cups's Avatar
    Join Date
    Oct 2006
    Location
    France, deep rural.
    Posts
    6,869
    Mentioned
    17 Post(s)
    Tagged
    1 Thread(s)
    Depends ...

    how many items in the csv file?
    will the columns in the csv file be subject to change?
    will you need to sort, say to display together, any of the products?
    will you need to join any of the csv records to other records in your database - apart from users purchase record?

  3. #3
    SitePoint Enthusiast Adam Chrapkowski's Avatar
    Join Date
    Sep 2011
    Location
    Poland
    Posts
    42
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I suggest to use XML instead is is much convenient and you can easily read data from them. Of course importing CSV into a database is also possible.

  4. #4
    SitePoint Enthusiast
    Join Date
    Jul 2006
    Posts
    36
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I would recommend importing the CSV into MySQL. I just dealt with a similar situation for a client of mine who has 3,500+ products which are exported to CSV from their internal system. Using MySQL makes it a lot easier to work with in terms of searching and manipulating the data.


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
  •