trying to import csv file into database, need path?

Discussion in 'Databases' started by Nitro-Dog, Dec 16, 2010.

0
  1. #1
    trying to import csv file into database, need path?
    my site asks for path.
    what do i put there?
    Products
    Save Cancel
    * File:
    * Path:
    * File type:
    * Weight:
    * Currency:
    * Last category as main category: e.g. in category path Pets/Dogs/Toy Bones, parser will get Toy Bones and add it as main category.
     
    Nitro-Dog, Dec 16, 2010 IP
  2. AcevedoAaron

    AcevedoAaron Peon

    Messages:
    49
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    i need this too i think we should search in net But i cant find any useful result so if anybody can help then thanks in advanced.i hope we will get some one as soon as possiable
     
    AcevedoAaron, Dec 17, 2010 IP
  3. Nitro-Dog

    Nitro-Dog Greenhorn

    Messages:
    47
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #3
    i have seached the web and the only thing i found is this and i have not tried it yet.
    Path is a relative to script's root path and is not required.
    In example if you've installed your open cart script into /home/site/public_html/ then if you upload data.csv file there via FTP or CPanel you can just write data.csv into this field.
    This is used in case you use large CSV files and server cannot handle large file uploads.
     
    Nitro-Dog, Dec 17, 2010 IP
  4. NuLLByTe

    NuLLByTe Active Member

    Messages:
    382
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    80
    #4
    Dude, a path is where the file can be found... You can upload csv files via phpMyAdmin if I remember well.
     
    NuLLByTe, Dec 18, 2010 IP
  5. getbestproduct

    getbestproduct Peon

    Messages:
    140
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    You can upload the file to your server/
     
    getbestproduct, Dec 23, 2010 IP
  6. aboxy

    aboxy Peon

    Messages:
    12
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    You can't beat the efficiency and speed of 'load data infile' .
    Just connect to database via mysql client and execute
    LOAD DATA INFILE '<YOUR-FILE>' INTO TABLE test
    FIELDS TERMINATED BY ',' ;


    <YOUR-FILE>=wherever you downloaded it locally, i.e. c:/mydata/mydatafile.csv
     
    aboxy, Jan 10, 2011 IP