Every Comment is linked to the Article using 'parentid' field.
So, for your example, all comments of "Sample Article" will have parentid=4.
Ok, so if i understand correctly, then in the content table you attached to your post, that would mean that the comment titled "Testing comments" is attached to the "We Are Volunteers" article, correct?
Please correct and/or clarify my understanding of the following fields if you would be so kind. Perhaps this info will help anyone else that is looking to import comments:
-No Introtext, the text of the comment goes in the fulltext field.
-Not sure what the mask field is?
-sectionid and catid are always the same for comments.
-created is the date the comment was placed
-created_by - not sure what this is? Perhaps the guest user's id you speak of in your instructions?
-created_by_alias is the field where I insert the person's name
-ordering is set to 1, what is this? It's not the order of the comments apparently?
-metadata field has created_by_link= and this is where I put a weblink if the user has included one in his comment
-What happens to an unregistered commentor's email address when he enters it? (I don't need to have email as a field anywhere?)
I think I have a pretty good handle on most of it. The only thing that has me concerned is the id field. As far as I understand, everything in Joomla must have a unique id. The question is, when I go to import many comments at once into the content table, how will I know what id to start at? Do I just take the next highest number after the last in the table? Does the subject of the comment become the title field?
Thanks again for helping me with this...
- Official website of Ron Paul's Campaign For Liberty