Re-serializing on import

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

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

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.

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