Exporting submissions and importing into another site.
-
Hi
I am redoing a non profit Norwegian ecosociety/sustainable village web site.
In the process I am transfering old material from one site to another.How would I go about exporting contact form entries/submissions from one web site to another?
Thanks!
-
There is not a submissions import option at this time in Ninja Forms. The best way to move your submissions will be to migrate the info in the database from one server to the other. Here is information on the tables that Ninja Forms uses:
Forms
nf3_forms?(Table of individual Forms)
? id (The unique ID of the Form)
? int(11)
? NOT NULL
? AUTO_INCREMENT
? Primary Key
? title (The displayable title of the Form)
? longtext
? COLLATE DATABASE_DEFAULT
? key (The administrative key of the Form)
? longtext
? COLLATE DATABASE_DEFAULT
? created_at (The date/time the Form was created)
? timestamp
? NOT NULL
? DEFAULT CURRENT_TIMESTAMP
? ON UPDATE CURRENT_TIMESTAMP
? updated_at (The date/time the Form was last updated)
? datetime
? views (The number of times the Form has been viewed)
? int(11)
? subs (The Form’s number of lifetime Submissions)
? int(11)
? form_title (The displayable title of the Form)
? longtext
? COLLATE utf8mb4_general_ci (fallback to utf8_general_ci)
? default_label_pos (The default label position of fields on the Form)
? varchar(15)
? show_title (Whether or not to show the Form title)
? bit(1)
? clear_complete (Whether or not to clear the Form after submission)
? bit(1)
? hide_complete (Whether or not to hide the Form after submission)
? bit(1)
? logged_in (Whether or not the user must be logged in to view the Form)
? bit(1)
? seq_num (The number of the next submission to the Form)
? int(11)
nf3_form_meta?(Table of Settings assoicated with each Form)
? id (The unique ID of the Setting)
? int(11)
? NOT NULL
? AUTO_INCREMENT
? Primary Key
? parent_id (The Form ID this Setting is associated with)
? int(11)
? NOT NULL
? Foreign Key ON?nf3_forms?id
? key (The administrative key of the Setting)
? longtext
? COLLATE DATABASE_DEFAULT
? NOT NULL
? value (The value of the Setting)
? longtext
? COLLATE DATABASE_DEFAULT
? meta_key (The administrative key of the Setting)
? longtext
? COLLATE utf8mb4_general_ci (fallback to utf8_general_ci)
? meta_value (The value of the Setting)
? longtext
? COLLATE utf8mb4_general_ci (fallback to utf8_general_ci)Fields
nf3_fields?(Table of individual Fields)
? id (The unique ID of the Field)
? int(11)
? NOT NULL
? AUTO_INCREMENT
? Primary Key
? label (The displayable label of the Field)
? longtext
? COLLATE DATABASE_DEFAULT
? key (The administrative key of the Field)
? longtext
? COLLATE DATABASE_DEFAULT
? type (The type of Field this record represents)
? longtext
? COLLATE DATABASE_DEFAULT
? parent_id (The Form ID this Field is associated with)
? int(11)
? NOT NULL
? Foreign Key ON?nf3_forms?id
? created_at (The date/time the Field was created)
? timestamp
? NOT NULL
? DEFAULT CURRENT_TIMESTAMP
? ON UPDATE CURRENT_TIMESTAMP
? updated_at (The date/time the Field was last updated)
? datetime
? field_label (The displayable label of the Field)
? longtext
? COLLATE utf8mb4_general_ci (fallback to utf8_general_ci)
? field_key (The adminstrative key of the Field)
? longtext
? COLLATE utf8mb4_general_ci (fallback to utf8_general_ci)
? order (The display order of the Field on the Form)
? int(11)
? required (Whether or not this is a required Field)
? bit(1)
? default_value (The default value assigned to the Field)
? longtext
? COLLATE utf8mb4_general_ci (fallback to utf8_general_ci)
? label_pos (The label position of the Field)
? varchar(15)
? COLLATE utf8mb4_general_ci (fallback to utf8_general_ci)
? personally_identifiable (Whether or not the Field contains personally identifiable data)
? bit(1)
nf3_field_meta?(Table of Settings associated with each Field)
? id (The unique ID of the Setting)
? int(11)
? NOT NULL
? AUTO_INCREMENT
? Primary Key
? parent_id (The Field ID this Setting is associated with)
? int(11)
? NOT NULL
? Foreign Key ON?nf3_fields?id
? key (The administrative key of the Setting)
? longtext
? COLLATE DATABASE_DEFAULT
? NOT NULL
? value (The value of the Setting)
? longtext
? COLLATE DATABASE_DEFAULT
? meta_key (The administrative key of the Setting)
? longtext
? COLLATE utf8mb4_general_ci (fallback to utf8_general_ci)
? meta_value (The value of the Setting)
? longtext
? COLLATE utf8mb4_general_ci (fallback to utf8_general_ci)Actions
nf3_actions?(Table of individual Actions)
? id (The unique ID of the Action)
? int(11)
? NOT NULL
? AUTO_INCREMENT
? Primrary Key
? title (The displayable title of the Action)
? longtext
? COLLATE DATABASE_DEFAULT
? key (The administrative key of the Action)
? longtext
? COLLATE DATABASE_DEFAULT
? type (The type of Action this record represents)
? longtext
? COLLATE DATABASE_DEFAULT
? active (Whether or not the Action is active)
? tinyint(1)
? DEFAULT 1
? parent_id (The Form ID this Action is associated with)
? int(11)
? NOT NULL
? Foreign Key ON?nf3_forms?id
? created_at (The date/time the Action was created)
? timestamp
? NOT NULL
? DEFAULT CURRENT_TIMESTAMP
? ON UPDATE CURRENT_TIMESTAMP
? updated_at (The date/time the Action was last updated)
? datetime
? label (The label of the action)
? longtext
? COLLATE DATABASE_DEFAULT
nf3_action_meta?(Table of Settings associated with each Action)
? id (The unique ID of the Setting)
? int(11)
? NOT NULL
? AUTO_INCREMENT
? Primary KEY
? parent_id (The Action ID this Setting is associated with)
? int(11)
? NOT_NULL
? Foreign Key ON?nf3_actions?id
? key (The administrative key of the Setting)
? longtext
? COLLATE DATABASE_DEFAULT
? NOT NULL
? value (The value of the Setting)
? longtext
? COLLATE DATABASE_DEFAULT
? meta_key (The administrative key of the Setting)
? longtext
? COLLATE utf8mb4_general_ci (fallback to utf8_general_ci)
? meta_value (The value of the Setting)
? longtext
? COLLATE utf8mb4_general_ci (fallback to utf8_general_ci)Objects
nf3_objects?(Table of non-structured Objects)
? id (The unique ID of the Object)
? int(11)
? NOT NULL
? AUTO_INCREMENT
? Primrary Key
? type (The type of Object this record represents)
? longtext
? COLLATE DATABASE_DEFAULT
? title (The displayable title of the Object)
? longtext
? COLLATE DATABASE_DEFAULT
? created_at (The date/time the Object was created)
? timestamp
? NOT NULL
? DEFAULT CURRENT_TIMESTAMP
? ON UPDATE CURRENT_TIMESTAMP
? updated_at (The date/time the Object was last updated)
? datetime
nf3_object_meta?(Table of Settings associated with each Object)
? id (The unique ID of the Setting)
? int(11)
? NOT NULL
? AUTO_INCREMENT
? Primary KEY
? parent_id (The Object ID this Setting is associated with)
? int(11)
? NOT_NULL
? Foreign Key ON?nf3_objects?id
? key (The administrative key of the Setting)
? longtext
? COLLATE DATABASE_DEFAULT
? NOT NULL
? value (The value of the Setting)
? longtext
? COLLATE DATABASE_DEFAULT
nf3_relationships?(Table of Relationships between Objects)
? id (The unique ID of the Relationship)
? int(11)
? NOT NULL
? AUTO_INCREMENT
? Primary KEY
? child_id (The child Object ID this record is associated with)
? int(11)
? NOT_NULL
? Foreign Key ON?nf3_objects?id
? child_type (The type of Object represented by child_id)
? longtext
? COLLATE DATABASE_DEFAULT
? NOT NULL
? parent_id (The parent Object ID this record is associated with)
? int(11)
? NOT_NULL
? Foreign Key ON?nf3_objects?id
? parent_type (The type of Object represented by parent_id)
? longtext
? COLLATE DATABASE_DEFAULT
? NOT NULL
? created_at (The date/time the Relationship was created)
? timestamp
? NOT NULL
? DEFAULT CURRENT_TIMESTAMP
? ON UPDATE CURRENT_TIMESTAMP
? updated_at (The date/time the Relationship was last updated)
? datetime
options?(The default WordPress options table)
? option_name = ‘nf_form_%’ WHERE % =?nf3_forms?id
? option_value = Serialized JSON Object (The Ninja Forms Cache)Submissions
posts?(The default WordPress posts table)
? id (The unique ID of the Post)
? bigint(20)
? NOT NULL
? AUTO_INCREMENT
? Primary Key
? post_type = ‘nf_sub’
postmeta?(The default WordPress postmeta table)
? meta_id (The unique ID of the Metadata)
? bigint(20)
? NOT NULL
? AUTO_INCREMENT
? Primary Key
? post_id (The Post ID this Metadata is associated with)
? bigint(20)
? NOT NULL
? DEFAULT 0
? Foreign Key ON?posts?id
? meta_key (The identifiable key by which this record is referenced)
? varchar(255)
? COLLATE DATABASE_DEFAULT
? meta_value (The value of this record)
? longtext
? COLLATE DATABASE_DEFAULTUpgrades
nf3_upgrades?(Table of Forms as they exist in the current structure and the stage of upgrade currently applied to each Form)
? id (The unique ID of the Form)
? int(11)
? NOT NULL
? Primary Key
? cache (The Ninja Forms cache as it was retrieved from the?options?table)
? longtext
? COLLATE utf8mb4_general_ci (fallback to utf8_general_ci)
? stage (The current upgrade stage of the Form)
? int(11)
? NOT NULL
? DEFAULT 0Chunks
nf3_chunks?(Table of Chunks created on publish to be reconstructed into a Ninja Forms cache)
? id (The unique ID of the Chunk)
? int(11)
? NOT NULL
? AUTO_INCREMENT
? Primary Key
? name (The name of the Chunk)
? varchar(200)
? COLLATE utf8mb4_general_ci (fallback to utf8_general_ci)
? value (The value of the Chunk)
? longtext
? COLLATE utf8mb4_general_ci (fallback to utf8_general_ci)Hey Justin
Thank you for the feedback!
What I have done earlier is create a form on the new dev site using the same types of fields as in the original form. I only need to export the submissions for the form. From what is mentioned above:
Submissions
posts (The default WordPress posts table)Will this export/import all WordPress posts along with the Ninja Forms submissions? I would rather not have the various WP posts included.
But it looks like I do not have a choice if I want to import the Ninja Forms submissions.What I am hoping for is an easy method to just export the database submissions for Ninja Forms from one database to another. That only includes the submissions entries. Into a new form created on the new site. Thanks.
- The topic ‘Exporting submissions and importing into another site.’ is closed to new replies.