I am new to Askbot. I have already has the data file for question. I want to import these things into my askbot forum. I import directly through mysql shell from the text file (.csv) to "question" table. In this table, I noticed that a field name "tagnames". Hence I don't know what is the meaning of field tagnames in question table. But this field is a "NOT NULL" field. Could you please explain why we should have "tagnames" field? I also have to import all the "tag" table and "question_tags" table to do a search using tag.
I have also done the following experiment.
I have 3 questions in my database.
Question 1. tagnames="physics", tag="test""image". //import from file -> directly go to database then use admin UI to add tag
Question 2. tagnames="physics", tag="test""image". //import from file
Question 3. tagnames="test" "image", tag="test""image". //submit through UI
As I expect, when I click on "test" tag (question 3), it show up all the 3 questions. However, when start over, click on the tag "physics" of either question 1 or 2, it show nothing (no matched tag). (I expected when click on physics, it show up question 1 and 2).
Then, what is happened behind the scene of clicking the tag?
Hello, if you are creating an importer script, it will be best if you use python calls like
user.post_question(), that way all that will be taken care of automatically.
tagnames field in the
question table is a so called denormalized data - simply a copy of tag names associated with the question tags - directly in the question table. That way data loads faster - bypassing the relations to the
question_tag table is a bridge table storing assignments of tags to questions and the
tag table stores information about tags themselves.
Create your Q&A site at askbot.com. Managed Askbot hosting at just $15/mo. Dedicated hosting, support contracts, consulting services.create your Q&A site
Asked: 2012-01-05 22:28:01 -0500
Seen: 56 times
Last updated: Jan 06 '12