Insert forums through phpMyAdmin - How?

[TWood]

I need to create a lot of forums automagically by adding them to the database in bulk. I tested a small list and got it added to the 'forum' table, but they won't show in the list of forums on the board itself. Is there more I need to do in the database to get them to become active?

Attached is a partial shot of the table, the top two forums I added manually to see what values were needed in the table fields, then I copied those into the spreadsheet that I used to create a CSV file.

Thanks,

TW

EDIT: Got it to work by going to the ACP>Maintenance>Update Counters>Rebuild Forum Information

I just need to learn a little more about how to create valid CSV files.