• Resolved Anthony

    (@hcmobilemedia)


    I have a Custom Post Type that I can’t get to import properly via .csv file. I know this is the “Export CSV” forum, but I believe my issue may lie in how the data is exported, rather than the import phase. One of the fields that I need gets exported as serialized data. When I go to import this field back into another site, the post is broken. I went into the database to see what was actually getting stored in the meta_value field. Here is what I found:

    The original exported meta_value:

    a:1:{i:0;a:2:{s:4:"name";s:21:"Link title here";s:3:"url";s:31:"/url-goes-here/";}}

    The meta_value after importing:

    s:103:"a:1:{i:0;a:2:{s:4:"name";s:21:"Link title here";s:3:"url";s:31:"/url-goes-here/";}}"

    The added s:103 and double quotes breaks the posts with these values. When I go into the database and remove those added characters, they work again. My current guess is that the data is getting serialized again upon importing. So is there a way to tell WP All Export to unserialize the data somehow when exporting? Or is there perhaps another way to handle this serialized data or stop WordPress from adding those characters?

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.