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!

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,781
    Likes Received:
    123
    Trophy Points:
    343
    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 II
    Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    3,552
    Likes Received:
    253
    Trophy Points:
    193
    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,
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  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 II
    Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    3,552
    Likes Received:
    253
    Trophy Points:
    193
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice