Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Need help with CSV/file manager.

Discussion in 'General Discussion' started by xyourxhighnessx, Apr 20, 2018.

  1. xyourxhighnessx

    xyourxhighnessx Registered

    Joined:
    Apr 20, 2018
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    USA
    cPanel Access Level:
    Website Owner
    I have a rather large can file (several GB in size) uploaded and I can acesac it in the file manager.

    I would like some information or to be pointed towards a helpful resource that explain how I can go about converting that csv into posts without using a wp plugin (my site is on the WordPress platform).

    I found "tools" that allow that but most don't accept it in zip format and none seem to allow you to import it from your file manager.



    I would just upload the csv unzipped but it's much too large. After 12 hours of waiting yesterday the upload failed at 50% (wifi dropped off momentarily) I don't want to try that again.
     
  2. sparek-3

    sparek-3 Well-Known Member

    Joined:
    Aug 10, 2002
    Messages:
    1,628
    Likes Received:
    72
    Trophy Points:
    328
    cPanel Access Level:
    Root Administrator
    What kind of CSV file is it?

    CSV is an agnostic type of dump file. It therefore can't be imported unless the entity you are importing it into is matched up the same way as the source of the dump.

    Without knowing exactly what you are doing, we really can't offer any advice (and it's doubtful we'll be able to offer much either way).

    You probably want to look into importing the CSV file into whatever application you are needing to import it into. I suspect a MySQL or MariaDB database table. But again, that table will have to be constructed in the same way that the source table was constructed.

    Some information may be found at:

    How to import CSV file to MySQL table

    Or you may want to just search for more generic forms of how to import data into a MySQL table.
     
    cPanelLauren likes this.
  3. cPanelLauren

    cPanelLauren Forums Analyst
    Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    906
    Likes Received:
    65
    Trophy Points:
    103
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Great advice @sparek-3 thank you for your response! @xyourxhighnessx more information on the CSV file might be helpful for the community to provide you better advice as well!

    Thank you,
     
  4. xyourxhighnessx

    xyourxhighnessx Registered

    Joined:
    Apr 20, 2018
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    USA
    cPanel Access Level:
    Website Owner
    The csv file is supposed to be a large number of posts for a video tube type of website. The csv is 7.1GB.

    I'd like to import the content and upload each in an individual post.
     
  5. cPanelLauren

    cPanelLauren Forums Analyst
    Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    906
    Likes Received:
    65
    Trophy Points:
    103
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
Loading...

Share This Page