Title: Custom fields import
Last modified: August 31, 2016

---

# Custom fields import

 *  Resolved [wordpressplugins1](https://wordpress.org/support/users/wordpressplugins1/)
 * (@wordpressplugins1)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/custom-fields-import-1/)
 * Hi
 * I am using these post fields type:
 * Date
 * Select
 * Checkboxes
 * I am trying to import post using CSV Importer but I can get any of imported
 * This is what I have
 * wpcf-date- : May 17,1993
    wpcf_country : India wpcf_services : travel, flights
 * Can you please tell me the format for these
 * [https://wordpress.org/plugins/types/](https://wordpress.org/plugins/types/)

Viewing 8 replies - 1 through 8 (of 8 total)

 *  Anonymous User 14808221
 * (@anonymized-14808221)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/custom-fields-import-1/#post-7136251)
 * Date is a timestamp (seconds from timestamp start date), Select a single value(
   you define it in Types) and Checkboxes a array (storing the option and value)
 * Do you need more infos?
 *  Thread Starter [wordpressplugins1](https://wordpress.org/support/users/wordpressplugins1/)
 * (@wordpressplugins1)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/custom-fields-import-1/#post-7136252)
 * Thanks for your reply. Can you please give me example for date and checkboxes.
   Basically what to write in CSV file.
 * Thanks
 *  Thread Starter [wordpressplugins1](https://wordpress.org/support/users/wordpressplugins1/)
 * (@wordpressplugins1)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/custom-fields-import-1/#post-7136271)
 * Hi Beda
 * Please help me with this. Please give me sample data.
 * Thanks
 *  Anonymous User 14808221
 * (@anonymized-14808221)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/custom-fields-import-1/#post-7136276)
 * Sample data for date 01/01/2010, 00.00 hrs:
    `1262304000`
 * Checkboxes require high elaborated Custom Code to import because those are serialized
   arrays.
    Every Serialized array is differently stored in the Database and it 
   is not possible to import with the CSV importer only.
 * I apologize not having stated this initially.
 * thank you
 *  Thread Starter [wordpressplugins1](https://wordpress.org/support/users/wordpressplugins1/)
 * (@wordpressplugins1)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/custom-fields-import-1/#post-7136290)
 * Hi Beda
 * Thanks for your reply.
 * I have solved the date issue. This may not be the best way but I found a excel
   formula to convert date to linux date
 * **=(A1-DATE(1970,1,1))\*86400**
 * I use the result of this formaula to import the date which works great. So one
   down one to go.
 * I tried couple of things with checkboxes and I managed to find there reference
   in wp_option table in DB and I tried to use those but didn’t work.
 * I have 3 checkboxes named : **Travel, Food & Lifestyle** and this is how they
   are saved in DB when checked / selected.
 * a:3:{s:64:”wpcf-fields-checkboxes-option-8c118d34a1f3ecf4323f7c164ebc7f60-1″;
   a:1:{i:0;s:4:”Travel”;}s:64:”wpcf-fields-checkboxes-option-649a1973132a37753189ba22fd2af5f9-
   1″;a:1:{i:0;s:6:”Food”;}s:64:”wpcf-fields-checkboxes-option-7f10c97b284b890a3dadce48307cc9d5-
   1″;a:1:{i:0;s:10:”Lifestyle”;}}
 * Can you help with this?
 *  Anonymous User 14808221
 * (@anonymized-14808221)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/custom-fields-import-1/#post-7136297)
 * Checkboxes require high elaborated Custom Code to import because those are serialized
   arrays.
 * Every Serialized array is differently stored in the Database and it is not possible
   to import with the CSV importer only.
 * I can not help with this.
    It will be a tough one anyway, as any Plugin you use,
   will re-serialize on import.
 * Every array has a different amount of characters and this is faster to “import”
   if you just create the Checkboxes and populate them in the Backend, instead of
   coding each one manually to import via CSV, which will present the issue of re-
   serialization.
 *  Thread Starter [wordpressplugins1](https://wordpress.org/support/users/wordpressplugins1/)
 * (@wordpressplugins1)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/custom-fields-import-1/#post-7136300)
 * ok thanks
 *  Anonymous User 14808221
 * (@anonymized-14808221)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/custom-fields-import-1/#post-7136304)
 * marked as resolved

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘Custom fields import’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/types_ced1d3.svg)
 * [Toolset Types - Custom Post Types, Custom Fields and Taxonomies](https://wordpress.org/plugins/types/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/types/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/types/)
 * [Active Topics](https://wordpress.org/support/plugin/types/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/types/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/types/reviews/)

## Tags

 * [custom](https://wordpress.org/support/topic-tag/custom/)
 * [date](https://wordpress.org/support/topic-tag/date/)
 * [select](https://wordpress.org/support/topic-tag/select/)

 * 8 replies
 * 2 participants
 * Last reply from: Anonymous User 14808221
 * Last activity: [10 years, 2 months ago](https://wordpress.org/support/topic/custom-fields-import-1/#post-7136304)
 * Status: resolved