1

Topic: Converting from a flatfile forum

anyone did something similar? 'cause I'm on it, I managed to convert my user list in a very lame way (printing out stuff, then importing it via phpmyadmin) but It works like a charm (even passwords are ok)

In the topic table I see that poster id (topic starter) isn't stored, or is it somewhere else?

Re: Converting from a flatfile forum

http://punbb.org/docs/dev.html#dbtables - that might help.

3 (edited by mat 2005-12-19 12:44)

Re: Converting from a flatfile forum

thanx... it looks ok so far, I imported all the topics too, and now for the posts... I don't know if it will work the same way (print, csv_import, pray)... any ideeas would be apreciated

looks like this so far: http://raziel.rdsor.ro/techno/punBB/

Re: Converting from a flatfile forum

http://punbb.org/forums/viewtopic.php?id=8545 might be useful as it will sort out the post counts for users, forums and topics once you've imported all the data.

5

Re: Converting from a flatfile forum

Yes I downloaded that too, I will run it after all the import is done (pruning worked with users)

bad thing is Replies, Views, and Last post won't appear while viewing topics, although I checked the topics table and it's there... is it 'cause posts aren't imported yett?

6 (edited by mat 2005-12-20 11:47)

Re: Converting from a flatfile forum

mat wrote:

bad thing is Replies, Views, and Last post won't appear while viewing topics, although I checked the topics table and it's there... is it 'cause posts aren't imported yett?

mat, u are mistakin', the tables weren't ok, u forgot to change moved_to from 0 to NULL... u dumb a$$

please ignore this rant, I just write it here for future reference...

80% done I guess... if I finish it, I'll release it here, althogugh the coding really really sux. but it worx wink

7

Re: Converting from a flatfile forum

looks like I done it... for those who are interested, the original is navboard, and I converted all to punBB... the script is a mess, but it works ok...

got one last questin...

my board uses romanian and I changed all the fields in topics posts and users to collation utf8_general_ci. weird thing is in the database I have all the weird chars, but punbb won't display them... anyone managed to solve this?

8

Re: Converting from a flatfile forum

done. welcome a new punbb instalement... i'll post the convertor script... next year... see ya... have a nice evening, and a default new year. smile