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?
Correct, see screenshot attached.
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?
I don't know about the 'mask' field (and I don't use it).
-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?
Yes, if comment was made by some guest...
-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?
I don't use this field (yet...). It is set by Joomla! core...
-metadata field has created_by_link= and this is where I put a weblink if the user has included one in his -What happens to an unregistered commentor's email address when he enters it? (I don't need to have email as a field anywhere?)
email is stored in 'metadata' field as:
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?
Yes, you are right.
Good luck, and please give us feedback, when you'll do this