Skip to content

Instantly share code, notes, and snippets.

@ntwb

ntwb/forum.csv

Created September 12, 2013 02:05
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ntwb/6532360 to your computer and use it in GitHub Desktop.
Save ntwb/6532360 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
forum.csv
post_author post_date post_content post_title
1 2013-09-01 00:37:17 Main Category Description Main Category
1 2013-09-01 00:37:17 Main Forum Description Main Forum
Raw
reply.csv
post_author post_date post_content post_title post_parent
1 4/09/2013 0:31 1st reply to 1st topic content 1st Topic 348831
1 4/09/2013 0:31 2nd reply to 1st topic content 1st Topic 348831
Raw
topic.csv
post_author post_date post_content post_title post_parent
1 2010-09-01 00:37:17 1st topic content 1st Topic 348830
1 2011-09-01 00:37:17 2nd topic content 2nd Topic 348830
@sciman
Copy link

sciman commented Sep 12, 2013

Terrific. I'd like to clarify several issues though:

  • I notice that for "post_author" you have inserted "1" here, though on the sample topics and replies, the name comes through as "First Last". I presume that for the import I would have first and last names within the csv topics and replies, and perhaps my own name as the "post author" at the point of forum definitions. The upload file might contain a good number of posts by multiple authors. Do authors need to be uploaded with any meta information such as email addresses, etc. in a separate upload file?
  • The post_date format includes an indication of time of the post as well. In my case, I do not have that information, but have M/DD/YYYY formatted post dates. I presume that this is sufficient. I notice that you have two date formats in these files with both m/dd/yyyy and yyyy-mm-d included -- so I presume that bbPress can handle either of these.

This is all very helpful and much appreciated. Steve Iman sciman at csupomona dot edu

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