Need help with CSV/file manager.

[xyourxhighnessx]

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.

 

[sparek-3]

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]

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,

 

[xyourxhighnessx]

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.

 

[cPanelLauren]

The following thread may also be useful:

Problem importing zipped CSV into a database