I have a csv (68mb gzip=4mb) approx 45k rows
It has post_title post_content and 4 custom fields
I can import it to wordpress using csv-importer(a wordpress free plugin).
But my problem is , while i import it ,Wordpress stops on Half.
I even modified the plugin to take file directly from server , but no help.
I am willing to buy any mod to above plugin or any help which can save my day and let me import csv flawlessly.
Thank you guys!!
Ok here i did to solve my problem
I download wordpress on wamp(my pc)
Increased the max execution time and upload limit using php.ini
and started uploading files onto it.
1st 1000 files took 39 secs 2nd 1000 files took 50+ 3rd 1000 files took 60+
and so on , it even went above 360 secs.
This was very irritating , So i installed another wp on localhost and uploaded renaming sets of csv.
Same way it took increasing time .
Later did some query on wp2 and imported it to wp1 .
The final sql export was added to my site.
I think there is some bug with csv importer. but has nice utility indeed.
I would wish to see here some good database handling plugins for wordpress .