Nothing gets imported

  • Resolved grantg182

    (@grantg182)


    10 years, 5 months ago

    Hi

    Using WP 4.3.1 Multi site.

    I exported Site 1 posts and excluded attachments. Because my site was primarily imported via phpMyAdmin after coming across to WP from another platform, I needed to export the post data to insert the post categories, which I have now done.

    I have then saved my file – which contains Korean characters, therefore saved the CSV as UTF8 and quote text cells options in OpenOffice. Selected my new CSV, clicked Upload – and nothing happened. The page loaded for a minute or so, then nothing.

    PHP error log has no errors reported. I see no errors or messages in WP, so I am at a complete loss. I also tried saving as the original export file was, to no avail.

    Am I doing something wrong here?

    https://wordpress.org/plugins/wp-csv/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author CPK Web Solutions

    (@cpkwebsolutions)

    10 years, 5 months ago

    Hi Grant

    The plugin hasn’t been tested with Multi Site at all. If the destination site is Multi Site, then it’s possible that the posts were imported without setting the blog id.

    If the destination is a standard WP site, then I’d expect it to work in most cases. You’re welcome to contact me via my site so that I can give you my email address and then you can send the import file.

    Best wishes

    Paul

    Thread Starter grantg182

    (@grantg182)

    10 years, 5 months ago

    Hi Paul

    Thanks for your quick reply.

    I guess I am lucky in the sense that I only need to import the ‘Site 1’ data – thankfully Multi Site uses the default database structure in this instance (and appends duplicated tables with ‘2’ for second networked site, ‘3’ for 3rd, etc). So there are no problems there. Importing into the first site of Multi Site is identical to importing into a single WP installation.

    Now, on to the problem – it seems my ‘max_upload_size’ was very low, 8MB. I have now increased this to 60M – my CSV was 54mb with 12,000 rows. I decided to err on the side of caution and split the file into 6 files, 2000 rows each, around 8-10mb each and now there are no issues!

    Importing all just fine – the first and only plugin I have tried (believe me, that’s a long list!) – including Korean characters. I have since discovered that MS Excel is NOT a job for CSV work. OpenOffice Calc is the way forward, and when dealing with characters such as Korean, Chinese, etc, save the CSV as UTF8 format and voila – a CSV is produced with the correct characters and imports into WP perfectly!

    Although I do not know why I got the initial loading page after uploading the (large) CSV (I never got to the second ‘Import’ page – the only change I made was increasing the max_upload_size value in PHP, therefore suspect that was the problem. It may be advantageous if you could report this on the initial upload page.

    Thanks again!

    Thread Starter grantg182

    (@grantg182)

    10 years, 5 months ago

    Also, another note – on the Import Results page, it would also be very helpful to return the original files name as, after having split into several files, it can be confusing to remember which file you just imported!

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Nothing gets imported’ is closed to new replies.