Skip to content

Instantly share code, notes, and snippets.

@lukecav
Last active August 26, 2020 18:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save lukecav/edba6c4c483f569559b3319307c4126a to your computer and use it in GitHub Desktop.
Save lukecav/edba6c4c483f569559b3319307c4126a to your computer and use it in GitHub Desktop.
Ninja Forms plugin submissions post type and WP All Import Pro submissions import template
[{"id":"1","options":"a:211:{s:4:\"type\";s:4:\"post\";s:21:\"is_override_post_type\";i:0;s:15:\"post_type_xpath\";s:0:\"\";s:8:\"deligate\";s:0:\"\";s:11:\"wizard_type\";s:3:\"new\";s:11:\"custom_type\";s:6:\"nf_sub\";s:14:\"featured_delim\";s:1:\",\";s:10:\"atch_delim\";s:1:\",\";s:25:\"is_search_existing_attach\";s:1:\"0\";s:15:\"post_taxonomies\";a:0:{}s:6:\"parent\";i:0;s:23:\"is_multiple_page_parent\";s:3:\"yes\";s:18:\"single_page_parent\";s:0:\"\";s:5:\"order\";s:1:\"0\";s:6:\"status\";s:7:\"publish\";s:13:\"page_template\";s:7:\"default\";s:25:\"is_multiple_page_template\";s:3:\"yes\";s:20:\"single_page_template\";s:0:\"\";s:15:\"page_taxonomies\";a:0:{}s:9:\"date_type\";s:8:\"specific\";s:4:\"date\";s:18:\"{datesubmitted[1]}\";s:10:\"date_start\";s:3:\"now\";s:8:\"date_end\";s:3:\"now\";s:11:\"custom_name\";a:4:{i:0;s:8:\"_field_1\";i:1;s:8:\"_field_2\";i:2;s:8:\"_field_3\";i:3;s:8:\"_form_id\";}s:12:\"custom_value\";a:4:{i:0;s:9:\"{name[1]}\";i:1;s:10:\"{email[1]}\";i:2;s:12:\"{message[1]}\";i:3;s:1:\"1\";}s:13:\"custom_format\";a:5:{i:0;s:1:\"0\";i:1;s:1:\"0\";i:2;s:1:\"0\";i:3;s:1:\"0\";i:4;s:1:\"0\";}s:14:\"custom_mapping\";a:0:{}s:17:\"serialized_values\";a:5:{i:0;s:7:\"[\"\",\"\"]\";i:1;s:7:\"[\"\",\"\"]\";i:2;s:7:\"[\"\",\"\"]\";i:3;s:7:\"[\"\",\"\"]\";i:4;s:7:\"[\"\",\"\"]\";}s:20:\"custom_mapping_rules\";a:5:{i:0;s:2:\"[]\";i:1;s:2:\"[]\";i:2;s:2:\"[]\";i:3;s:2:\"[]\";i:4;s:2:\"[]\";}s:14:\"comment_status\";s:6:\"closed\";s:20:\"comment_status_xpath\";s:0:\"\";s:11:\"ping_status\";s:6:\"closed\";s:17:\"ping_status_xpath\";s:0:\"\";s:12:\"create_draft\";s:2:\"no\";s:6:\"author\";s:0:\"\";s:12:\"post_excerpt\";s:0:\"\";s:9:\"post_slug\";s:0:\"\";s:11:\"attachments\";s:0:\"\";s:19:\"is_import_specified\";s:1:\"0\";s:16:\"import_specified\";s:0:\"\";s:16:\"is_delete_source\";i:0;s:8:\"is_cloak\";i:0;s:10:\"unique_key\";s:9:\"{name[1]}\";s:14:\"tmp_unique_key\";s:9:\"{name[1]}\";s:9:\"feed_type\";s:4:\"auto\";s:22:\"search_existing_images\";s:1:\"1\";s:18:\"create_new_records\";s:1:\"1\";s:20:\"is_selective_hashing\";s:1:\"1\";s:17:\"is_delete_missing\";s:1:\"0\";s:20:\"set_missing_to_draft\";s:1:\"0\";s:20:\"is_update_missing_cf\";s:1:\"0\";s:22:\"update_missing_cf_name\";s:0:\"\";s:23:\"update_missing_cf_value\";s:0:\"\";s:20:\"is_keep_former_posts\";s:3:\"yes\";s:16:\"is_update_status\";s:1:\"1\";s:17:\"is_update_content\";s:1:\"1\";s:15:\"is_update_title\";s:1:\"1\";s:14:\"is_update_slug\";s:1:\"1\";s:17:\"is_update_excerpt\";s:1:\"1\";s:20:\"is_update_categories\";s:1:\"1\";s:16:\"is_update_author\";s:1:\"1\";s:24:\"is_update_comment_status\";s:1:\"1\";s:21:\"is_update_ping_status\";s:1:\"1\";s:19:\"is_update_post_type\";s:1:\"1\";s:23:\"update_categories_logic\";s:11:\"full_update\";s:15:\"taxonomies_list\";s:1:\"0\";s:20:\"taxonomies_only_list\";s:0:\"\";s:22:\"taxonomies_except_list\";s:0:\"\";s:21:\"is_update_attachments\";s:1:\"1\";s:16:\"is_update_images\";s:1:\"1\";s:19:\"update_images_logic\";s:11:\"full_update\";s:15:\"is_update_dates\";s:1:\"1\";s:20:\"is_update_menu_order\";s:1:\"1\";s:16:\"is_update_parent\";s:1:\"1\";s:19:\"is_keep_attachments\";s:1:\"0\";s:12:\"is_keep_imgs\";s:1:\"0\";s:20:\"do_not_remove_images\";s:1:\"1\";s:23:\"is_update_custom_fields\";s:1:\"1\";s:26:\"update_custom_fields_logic\";s:11:\"full_update\";s:18:\"custom_fields_list\";s:1:\"0\";s:23:\"custom_fields_only_list\";s:0:\"\";s:25:\"custom_fields_except_list\";s:0:\"\";s:18:\"duplicate_matching\";s:4:\"auto\";s:19:\"duplicate_indicator\";s:5:\"title\";s:21:\"custom_duplicate_name\";s:0:\"\";s:22:\"custom_duplicate_value\";s:0:\"\";s:18:\"is_update_previous\";i:0;s:12:\"is_scheduled\";s:0:\"\";s:16:\"scheduled_period\";s:0:\"\";s:13:\"friendly_name\";s:0:\"\";s:19:\"records_per_request\";s:2:\"20\";s:18:\"auto_rename_images\";s:1:\"0\";s:25:\"auto_rename_images_suffix\";s:0:\"\";s:11:\"images_name\";s:8:\"filename\";s:11:\"post_format\";s:8:\"standard\";s:17:\"post_format_xpath\";s:0:\"\";s:8:\"encoding\";s:5:\"UTF-8\";s:9:\"delimiter\";s:1:\",\";s:16:\"image_meta_title\";s:0:\"\";s:22:\"image_meta_title_delim\";s:1:\",\";s:18:\"image_meta_caption\";s:0:\"\";s:24:\"image_meta_caption_delim\";s:1:\",\";s:14:\"image_meta_alt\";s:0:\"\";s:20:\"image_meta_alt_delim\";s:1:\",\";s:22:\"image_meta_description\";s:0:\"\";s:28:\"image_meta_description_delim\";s:1:\",\";s:34:\"image_meta_description_delim_logic\";s:8:\"separate\";s:12:\"status_xpath\";s:0:\"\";s:15:\"download_images\";s:3:\"yes\";s:17:\"converted_options\";s:1:\"1\";s:15:\"update_all_data\";s:3:\"yes\";s:12:\"is_fast_mode\";s:1:\"0\";s:9:\"chuncking\";s:1:\"1\";s:17:\"import_processing\";s:4:\"ajax\";s:26:\"processing_iteration_logic\";s:4:\"auto\";s:16:\"save_template_as\";s:1:\"1\";s:5:\"title\";s:17:\"[ninja_form id=1]\";s:7:\"content\";s:24:\"Ninja Forms Contact Test\";s:4:\"name\";s:30:\"Ninja Forms Submissions Import\";s:18:\"is_keep_linebreaks\";s:1:\"1\";s:13:\"is_leave_html\";s:1:\"0\";s:14:\"fix_characters\";i:0;s:9:\"pid_xpath\";s:0:\"\";s:10:\"slug_xpath\";s:0:\"\";s:11:\"title_xpath\";s:0:\"\";s:14:\"featured_image\";s:0:\"\";s:23:\"download_featured_image\";s:0:\"\";s:23:\"download_featured_delim\";s:1:\",\";s:22:\"gallery_featured_image\";s:0:\"\";s:22:\"gallery_featured_delim\";s:1:\",\";s:11:\"is_featured\";s:1:\"1\";s:17:\"is_featured_xpath\";s:0:\"\";s:20:\"set_image_meta_title\";s:1:\"0\";s:22:\"set_image_meta_caption\";s:1:\"0\";s:18:\"set_image_meta_alt\";s:1:\"0\";s:26:\"set_image_meta_description\";s:1:\"0\";s:18:\"auto_set_extension\";s:1:\"0\";s:13:\"new_extension\";s:0:\"\";s:9:\"tax_logic\";a:0:{}s:10:\"tax_assing\";a:0:{}s:11:\"term_assing\";a:0:{}s:20:\"multiple_term_assing\";a:0:{}s:23:\"tax_hierarchical_assing\";a:0:{}s:34:\"tax_hierarchical_last_level_assign\";a:0:{}s:16:\"tax_single_xpath\";a:0:{}s:18:\"tax_multiple_xpath\";a:0:{}s:22:\"tax_hierarchical_xpath\";a:0:{}s:18:\"tax_multiple_delim\";a:0:{}s:22:\"tax_hierarchical_delim\";a:0:{}s:25:\"tax_manualhierarchy_delim\";a:0:{}s:29:\"tax_hierarchical_logic_entire\";a:0:{}s:29:\"tax_hierarchical_logic_manual\";a:0:{}s:18:\"tax_enable_mapping\";a:0:{}s:25:\"tax_is_full_search_single\";a:0:{}s:27:\"tax_is_full_search_multiple\";a:0:{}s:29:\"tax_assign_to_one_term_single\";a:0:{}s:31:\"tax_assign_to_one_term_multiple\";a:0:{}s:11:\"tax_mapping\";a:0:{}s:17:\"tax_logic_mapping\";a:0:{}s:31:\"is_tax_hierarchical_group_delim\";a:0:{}s:28:\"tax_hierarchical_group_delim\";a:0:{}s:12:\"nested_files\";a:0:{}s:17:\"xml_reader_engine\";s:1:\"0\";s:13:\"taxonomy_type\";s:0:\"\";s:15:\"taxonomy_parent\";s:0:\"\";s:13:\"taxonomy_slug\";s:4:\"auto\";s:19:\"taxonomy_slug_xpath\";s:0:\"\";s:15:\"import_img_tags\";s:1:\"0\";s:28:\"search_existing_images_logic\";s:6:\"by_url\";s:24:\"enable_import_scheduling\";s:5:\"false\";s:17:\"scheduling_enable\";s:1:\"0\";s:22:\"scheduling_weekly_days\";s:0:\"\";s:17:\"scheduling_run_on\";s:6:\"weekly\";s:22:\"scheduling_monthly_day\";s:0:\"\";s:16:\"scheduling_times\";a:1:{i:0;s:0:\"\";}s:19:\"scheduling_timezone\";s:14:\"America\/Denver\";s:25:\"is_update_comment_post_id\";i:1;s:24:\"is_update_comment_author\";i:1;s:30:\"is_update_comment_author_email\";i:1;s:28:\"is_update_comment_author_url\";i:1;s:27:\"is_update_comment_author_IP\";i:1;s:23:\"is_update_comment_karma\";i:1;s:26:\"is_update_comment_approved\";i:1;s:26:\"is_update_comment_verified\";i:1;s:24:\"is_update_comment_rating\";i:1;s:23:\"is_update_comment_agent\";i:1;s:25:\"is_update_comment_user_id\";i:1;s:22:\"is_update_comment_type\";i:1;s:18:\"is_update_comments\";i:1;s:21:\"update_comments_logic\";s:11:\"full_update\";s:14:\"comment_author\";s:0:\"\";s:20:\"comment_author_email\";s:0:\"\";s:18:\"comment_author_url\";s:0:\"\";s:17:\"comment_author_IP\";s:0:\"\";s:13:\"comment_karma\";s:0:\"\";s:14:\"comment_parent\";s:0:\"\";s:16:\"comment_approved\";s:1:\"1\";s:22:\"comment_approved_xpath\";s:0:\"\";s:16:\"comment_verified\";s:1:\"1\";s:22:\"comment_verified_xpath\";s:0:\"\";s:13:\"comment_agent\";s:0:\"\";s:12:\"comment_type\";s:0:\"\";s:18:\"comment_type_xpath\";s:0:\"\";s:15:\"comment_user_id\";s:5:\"email\";s:21:\"comment_user_id_xpath\";s:0:\"\";s:12:\"comment_post\";s:0:\"\";s:14:\"comment_rating\";s:0:\"\";s:22:\"comments_repeater_mode\";s:3:\"csv\";s:32:\"comments_repeater_mode_separator\";s:1:\"|\";s:30:\"comments_repeater_mode_foreach\";s:0:\"\";s:8:\"comments\";a:9:{s:7:\"content\";s:0:\"\";s:6:\"author\";s:0:\"\";s:12:\"author_email\";s:0:\"\";s:10:\"author_url\";s:0:\"\";s:9:\"author_ip\";s:0:\"\";s:5:\"karma\";s:0:\"\";s:8:\"approved\";s:0:\"\";s:4:\"type\";s:0:\"\";s:4:\"date\";s:3:\"now\";}}","scheduled":"","name":"Ninja Forms Submissions Import","title":"N;","content":"N;","is_keep_linebreaks":"1","is_leave_html":"0","fix_characters":"0","meta":"N;"}]
@lukecav
Copy link
Author

lukecav commented Aug 26, 2020

Export out form submissions to CSV file in Ninja Forms for a specific form;

Ninja Forms > Submissions > Download All Submissions

Download the WPAI template as a text file and then use that to import the template into WP ALL Import Pro plugin.

All Import > Settings > Import Templates

Import in the template to WPAI

Now use the submissions CSV file to import in as a new import.

All Import > New Import

WP All Import step 1

In step three of the import select the new template to map all of the fields.

You will need to update the post_content and post_title values to match the forms name and form ID. The post object name for Ninja Forms submissions is nf_sub.

Example
post_content
Ninja Forms Contact Test

post_title
[ninja_form id=1]

Then map all of the fields in the form and {name[1]} as the unique key to import in new form submissions.

Top of the import
Custom fields for submissions
Final step before import is run

Go back to confirm that the submissions have been imported in on the specific form.

Ninja Forms > Submissions

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment