Title: Serialized data not importing correctly?
Last modified: August 24, 2016

---

# Serialized data not importing correctly?

 *  [resslx](https://wordpress.org/support/users/resslx/)
 * (@resslx)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/serialized-data-not-importing-correctly/)
 * 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.

## Tags

 * [ACF](https://wordpress.org/support/topic-tag/acf/)
 * [Import](https://wordpress.org/support/topic-tag/import/)
 * [serialized](https://wordpress.org/support/topic-tag/serialized/)

 * 0 replies
 * 1 participant
 * Last reply from: [resslx](https://wordpress.org/support/users/resslx/)
 * Last activity: [11 years, 1 month ago](https://wordpress.org/support/topic/serialized-data-not-importing-correctly/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics