Import in Guestbook
Posted: Wed Sep 26, 2007 9:00 am
I am converting a website to CMSMS and i would like to import my old guestbook in the new Guestbook module.
I made a export.php file that exports my old guestbook to a SQL query that I can paste in phpmyadmin to import all the posts, i use a counter to give each post an unique ID.
So I will import the posts in "cms_module_guestbook"
But there are some other tables from the guestbook module and I am not sure I need to change something in them too :s
# cms_module_guestbook_post -> this one holds 2 fields "id and idpost"
# cms_module_guestbook_post_seq -> this one holds 1 field "id", problably the sequence number of the previous table
# cms_module_guestbook_seq -> this one holds 1 field "id" probably the sequence number of my guestbook
so let's pretend that my counter stopped at 1000 posts, i think i need to change the "cms_module_guestbook_seq" id field to 1000.
But what to do with the first 2 tables? The post table seems to hild some kind of hash value??
I don't think i need to change something in:
# cms_module_guestbook_settings
I made a export.php file that exports my old guestbook to a SQL query that I can paste in phpmyadmin to import all the posts, i use a counter to give each post an unique ID.
So I will import the posts in "cms_module_guestbook"
But there are some other tables from the guestbook module and I am not sure I need to change something in them too :s
# cms_module_guestbook_post -> this one holds 2 fields "id and idpost"
# cms_module_guestbook_post_seq -> this one holds 1 field "id", problably the sequence number of the previous table
# cms_module_guestbook_seq -> this one holds 1 field "id" probably the sequence number of my guestbook
so let's pretend that my counter stopped at 1000 posts, i think i need to change the "cms_module_guestbook_seq" id field to 1000.
But what to do with the first 2 tables? The post table seems to hild some kind of hash value??
I don't think i need to change something in:
# cms_module_guestbook_settings