Forum module: Discussion thread for converting PHPBB data
Development and Programming
Sue, thank you for your contribution and it will be very helpful for our efforts.
Phil, she is talking PHP voodoo which is why you are lost. In a nutshell fgetcsv and fputcsv are PHP functions that allows a PHP script to both read and write a CSV format.
http://us2.php.net/manual/en/function.fgetcsv.php http://us2.php.net/manual/en/function.fputcsv.php
The EE PHP routines she is talking about is PHP code written by the EE developers that serve as tools to be able to do things such as what we are attempting to accomplish here (among others.)
In short, if you do not understand what she just said… that message is not necessarily for you 😊
My own direction in this thread is to privide a manual method of converting PHPBB data to be used in the EE system that does not require knowledge of programming. This is what I am still in the process of writing. I have actually started a Wiki entry for the documentation and I will give you the address when I have something substantial there. By the way, what version of Excel are you using?
I am still in the process of writing documentation on how to use Excel… hang tight!
I have the lasted on my mac, and on my PC…I’m not sure what the version numbers are. I use my Mac more though. and i will hang in there! haha
any progress? I am not trying to come across being mean, I was just wondering.
I’m also interested in this. However, I’m not interested in importing the users, but the posts.
Has anyone tried converting their phpBB forum, and run into any problems with unusually long (over 10,000 character) posts?
Sorry guys I have been MIA because I have been busy at work. I wrote up a pretty long forum post to give some tips on some things to try and I ended up going over the 6000 character post limit. I am really really tired so I did not feel like breaking it up into smaller posts. Instead I dropped my post into a PDF and uploaded it to a Geocities address.
TLM Leslie… what you want to do should be no problem.
Phil K… go to the following site to grab the PDF.
Edit: This is not the documentation I was promising… rather it is just a simple example of how to export a SQL table in the CSV format, make some changes to that data, and then upload it into another database.
Edit Edit: I removed the above link because I have since posted this information in the EE wiki.
You know, you could just upload it to the wiki….. that’s part of what the thing is there for. =)
Yes I could, and I will, but through the haze of my tired brain I remember reading you are taking it down for support this weekend during which time Phil K and whoever else is interested may not be able to read it. I will post it to the Wiki after you do this.
Theoretically it should be down for about 5-10 minutes between midnight and 3am. I just made it sound scary in case I screw something up. winks
Lisa… go to bed! :D
I will post the info to the wiki tomorrow when I get off work… unless you want to do it for me winks
manofsteel, thanks for the assist! (That max character limit is supposed to be fixed in the latest version of the forum; but I am unable to get it to work. H’m…)
I’ll give this a shot and report back on how it goes.
Thanks again!
I haven’t had time to give this a try yet - RL threw some minor curveballs at me, and this weekend is booked. I’ll first need to set up my mapping, though. I have the userbase already in the EE installation - I just have to match up the EE user numbers with the identifiers used on the posts in phpBB, suck the post and thread data into the appropriate databases, et voila.
Just checking back in on the status of an automated script to handle this converstion. Any forecast?
The automated script is being created by the Pmachine developers. This thread does not discuss an automated script. Instead we are working on a manual process for non-coders of using spreadsheets to convert the data. There are several of us who are working on this as time allows and sharing info as we go. At this time we are working on PHPBB because we feel that is the most used open-source forum system and will probably be a ways back in in the line of forum systems to receive a conversion script.
Since I am on the subject sorry for not getting this out on the time line that I originally laid out. Unforseen business changes at my place of employment has been gobbling up more of my time and of course making the bread takes precedence over side projects.
monofsteel, i know your thread revolves around a manual process. You are doing some cool stuff. Given the time I’d try it.
If PHPBB is the “most used open-source forum,” why would you say it would be last in line to receive a conversion? Doesn’t this make it a prime candidate to be first in line?
Like many, I’m waiting for the automated script. Sorry for posting in your thread but this seems to be the only place with an active discussion of this topic. Also it seems to be the only place on pMachine’s site that indicates a conversion script is in the works.
<
blockquote>If PHPBB is the