Support » Plugin: WP CSV » Re-serializing on import

  • Wonderful plugin first of all. Thank you for it!

    I saw a post about importing serialized data, and it seemed to indicate imports that come directly from the Export feature of WP-CSV wouldn’t be re-serialized. However, when I import, the data is being serialized again.

    Am I missing something?

    I did disable CPT UI (as I believe was suggested in that previous post).

    Thanks,
    Craig

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

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

    (@cpkwebsolutions)

    Hi Craig

    I haven’t had time to check the plugin on WP 4.5 yet. There’s a chance it isn’t compatible. I’ll try to review the plugin in the near future.

    Best wishes

    Paul

    Thanks for your response, Paul. I didn’t get a email about it for some reason, but I did a search and this came up as the second result in google. 🙂

    Just so you’re aware, I’m still on 4.4.2 right now. If you know of any other plugins I should disable besides CPT-UI, let me know.

    Thanks again…
    Craig

    Plugin Author CPK Web Solutions

    (@cpkwebsolutions)

    Hi Craig

    All I can say is that they shouldn’t! When you export arrays/objects, they should appear in JSON format. If they remain in JSON format, then the intention is that they’d be re-serialized on import. There’s a check to see if the data is still valid JSON. Is it possible that the format is invalid by the time of re-import?

    Best wishes

    Paul

    Hi Paul,

    Here is the exact value I have in the cell after creating the field in the UI and exporting it (to use as an example for what I’ll upload later):

    a:1:{i:0;a:5:{s:4:”type”;s:4:”text”;s:8:”required”;s:2:”on”;s:5:”label”;s:44:”Please tell us what sewing machine you have.”;s:4:”slug”;s:43:”please-tell-us-what-sewing-machine-you-have”;s:5:”extra”;a:0:{}}}

    After importing it and then exporting it again, I get this:

    s:343:”a:2:{i:0;a:5:{s:4:”type”;s:4:”text”;s:8:”required”;s:2:”on”;s:5:”label”;s:44:”Please tell us what sewing machine you have.”;s:4:”slug”;s:43:”please-tell-us-what-sewing-machine-you-have”;s:5:”extra”;a:0:{}}i:1;a:5:{s:4:”type”;s:4:”text”;s:8:”required”;s:2:”on”;s:5:”label”;s:12:”Phone Number”;s:4:”slug”;s:12:”phone-number”;s:5:”extra”;a:0:{}}}”;

    If this is beyond the scope of support you can provide, just let me know…

    Thanks,
    Craig

    Plugin Author CPK Web Solutions

    (@cpkwebsolutions)

    Ok, thanks for clarifying. It shouldn’t be exporting like that. It should export custom fields like that as JSON. Either the plugin has failed to identify serialised data and convert to JSON, or the data isn’t stored as expected.

    I’ll take a look as soon as I can.

    Best wishes

    Paul

    Thank you, Paul. Sorry I didn’t post it this way the first time.

    Best,
    Craig

    If someone runs in to this it is possible to clean the serialized data. Basically on import (I think on import) it turns this…

    a:0:{}

    in to this.

    s:13:”s:6:”a:0:{}”;”;

    So just find the row of data in the raw database and remove the extra. Back up your database first. Its tedious but at least your data gets fixed.

    Plugin Author CPK Web Solutions

    (@cpkwebsolutions)

    Thanks graftedin.

    I’ll be addressing this soon along with a long list of other issues I haven’t had time to get to.

    Best wishes

    Paul

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Re-serializing on import’ is closed to new replies.