Serialized data not importing correctly?

  • resslx

    (@resslx)


    9 years ago

    I’m attempting to import a series of ACF (serialized) checkbox fields into my database. I’ve exported a large CSV using WP CSV, and have been attempting to import it using WP CSV as well as WP All Import. Both are giving similar results and I’m not sure why. Currently, if I go to edit my post data all these fields are blank (no boxes are checked).

    As an example, If I export the data for a particular field, I get this:

    a:1:{i:0;s:39:"a:1:{i:0;s:21:"Automotive Franchises";}";}

    Although, I’ve been importing this:

    a:1:{i:0;s:21:"Automotive Franchises";}

    Both plugins appear to be taking this last string and ‘converting’ it into a serialized value. I’m willing to convert these by hand, but some of the values are quite long. For example, this checkbox field holds state data:

    a:1:{i:0;s:1029:"a:1:{i:0;s:1009:"a:48:{i:0;s:7:"Alabama";i:1;s:6:"Alaska";i:2;s:7:"Arizona";i:3;s:8:"Arkansas";i:4;s:10:"California";i:5;s:8:"Colorado";i:6;s:11:"Connecticut";i:7;s:8:"Delaware";i:8;s:20:"District of Columbia";i:9;s:7:"Florida";i:10;s:7:"Georgia";i:11;s:5:"Idaho";i:12;s:8:"Illinois";i:13;s:7:"Indiana";i:14;s:4:"Iowa";i:15;s:6:"Kansas";i:16;s:8:"Kentucky";i:17;s:9:"Louisiana";i:18;s:5:"Maine";i:19;s:13:"Massachusetts";i:20;s:8:"Michigan";i:21;s:9:"Minnesota";i:22;s:11:"Mississippi";i:23;s:8:"Missouri";i:24;s:7:"Montana";i:25;s:8:"Nebraska";i:26;s:6:"Nevada";i:27;s:13:"New Hampshire";i:28;s:10:"New Jersey";i:29;s:10:"New Mexico";i:30;s:14:"North Carolina";i:31;s:12:"North Dakota";i:32;s:4:"Ohio";i:33;s:8:"Oklahoma";i:34;s:6:"Oregon";i:35;s:12:"Pennsylvania";i:36;s:12:"Rhode Island";i:37;s:14:"South Carolina";i:38;s:12:"South Dakota";i:39;s:9:"Tennessee";i:40;s:5:"Texas";i:41;s:4:"Utah";i:42;s:7:"Vermont";i:43;s:8:"Virginia";i:44;s:10:"Washington";i:45;s:13:"West Virginia";i:46;s:9:"Wisconsin";i:47;s:7:"Wyoming";}";}";}

    I’ve contacted ACF and they simply referred me to the WP All Import documentation. I contacted WP All Import supprot, but they haven’t responded.

    Is there someething else I might be doing wrong?

  • The topic ‘Serialized data not importing correctly?’ is closed to new replies.