Manual Insert Posts - Schema

[Rizwan Kassim]

I'd like to import some posts from my listserv/mailman archive.

Is there a simple API call I could make, or a list of INSERTS required so that we can parse our logs and insert our old data?

Thanks,

 

[Jake Bunce]

You need to insert into the xf_thread and xf_post tables.

If you can get the source data into separate tables in your XF database then you can do cross table inserts, like this:

INSERT INTO xf_thread (thread_id, node_id, title, user_id, username, post_date, first_post_id, last_post_date, last_post_id, last_post_user_id, last_post_username)
	SELECT values, for, each, column
	FROM yourtable;

INSERT INTO xf_post (thread_id, user_id, username, post_date, message, position, like_users)
	SELECT values, for, each, column
	FROM yourtable;

Then rebuild your thread information afterwards:

Admin CP -> Tools -> Rebuild Caches

 

[Rizwan Kassim]

Thanks!
What about attachments?

 

[Jake Bunce]

Thanks!
What about attachments?

Attachment data is more complex. You can no longer use simple queries. I suggest creating a new importer so you can use the import model. You can refer to the built-in importers for reference:

library/XenForo/Importer