2011-05-09, 01:56 AM
Hi guys,
First up, a few weeks ago I posted a similar thread in 1.6 support (http://community.mybb.com/thread-93209.html) but had no replies; through searching I have found a lot more info and also seen that this may be a better spot to ask, I have no one else ;-) Appologies if I can't do this, and please remove the thread.
OK. I have a spreadsheet with a couple of thousand rows, each that I am wanting to make into a new thread. I can easily format the spreadsheet to match that of the "_posts" SQL table (Pid, tid, replyto, fid, subject, icon, uid, username, dateline, message, ipaddress, longipaddress, includesig, smileieoff, edituid, edittime, visible, posthash).
I am wondering that if I do format my spreadsheet this way, would I be able to import it into _posts using phpMyAdmin? If this might work, would auto generated fields populate themselves? Would I need to add a value into 'posthash'? And also, would I need to add references to other tables aswell?
ANY assistance would be very much appreciated, even if there is an alternative BB that may offer this function (and then import back).
Much thanks
Rich
First up, a few weeks ago I posted a similar thread in 1.6 support (http://community.mybb.com/thread-93209.html) but had no replies; through searching I have found a lot more info and also seen that this may be a better spot to ask, I have no one else ;-) Appologies if I can't do this, and please remove the thread.
OK. I have a spreadsheet with a couple of thousand rows, each that I am wanting to make into a new thread. I can easily format the spreadsheet to match that of the "_posts" SQL table (Pid, tid, replyto, fid, subject, icon, uid, username, dateline, message, ipaddress, longipaddress, includesig, smileieoff, edituid, edittime, visible, posthash).
I am wondering that if I do format my spreadsheet this way, would I be able to import it into _posts using phpMyAdmin? If this might work, would auto generated fields populate themselves? Would I need to add a value into 'posthash'? And also, would I need to add references to other tables aswell?
ANY assistance would be very much appreciated, even if there is an alternative BB that may offer this function (and then import back).
Much thanks
Rich