Title: [csv-importer] export phpbb to csv
Last modified: August 19, 2016

---

# [csv-importer] export phpbb to csv

 *  Resolved [Landgraaf](https://wordpress.org/support/users/landgraaf/)
 * (@landgraaf)
 * [15 years, 4 months ago](https://wordpress.org/support/topic/csv-importer-export-phpbb-to-csv/)
 * hi i code a phpbb2 to csv to use the csc-inporter
 * [code]`
    <? /* svc export 1.00 phpbb2 to svc port a forum post ( without the 
   comments ) to svc made bij p.Landgraaf of spep.nl [http://wordpress.org/extend/plugins/csv-importer/](http://wordpress.org/extend/plugins/csv-importer/)
   thx to : d.v.kobozev
 * short info and how to use :
 * place this file where the phpbb2 index.php file is , run it and .
 * copy and past the output in a new file and save it and import it again
 * I know its a paece dirty of coding BUT its works 🙂
    */ $forumnr = '1' //= nieuws
 * include "config.php";
 * mysql_connect("$dbhost", "$dbuser", "$dbpasswd");
    mysql_select_db("$dbname");
 * $eerste ='"csv_post_title","csv_post_post","csv_post_type","csv_post_excerpt","
   csv_post_categories","csv_post_tags","csv_post_date","csv_post_author","csv_post_slug","
   custom_field_1","custom_field_2"';
 * echo $eerste;
 * $qry = "SELECT topic_id,topic_title,forum_id FROM spep_phpbb_topics WHERE forum_id
   = $forumnr ORDER BY topic_id ASC LIMIT 5000";
    $result = mysql_query($qry); while(
   $row = mysql_fetch_array($result)) { $topic_id = $row['topic_id']; $forum_titel
   = $row['topic_title']; $topic_time =$row['topic_time'];
 * //echo "$topic_id - $forum_titel - $topic_time <br>"; // test
 * $ss = "SELECT post_id ,topic_id ,post_time FROM spep_phpbb_posts WHERE topic_id
   = $topic_id LIMIT 1";
    $resultz = mysql_query($ss); while ($row = mysql_fetch_array(
   $resultz)) { $post_id = $row['post_id']; $tijd = $row['post_time']; }
 * $sql = "SELECT post_id,bbcode_uid,post_subject,post_text FROM spep_phpbb_posts_text
   WHERE post_id = $post_id LIMIT 1";
    $results = mysql_query($sql); while ($row
   = mysql_fetch_array($results)) { $id = $row['post_id']; $bb = $row['bbcode_uid'];
   $tit = $row['post_subject']; $txt = $row['post_text'];
 * $dat = date("Y-m-d H:i:s", $tijd);
    $tit = str_replace(":$bb]", "]", $tit); //
   $tit = str_replace("·", "", $tit); // was in my old postings the start //addslashes(
   htmlspecialchars($tit,ENT_QUOTES)); $txt = str_replace(":$bb]", "]", $txt); //
   addslashes(htmlspecialchars($txt,ENT_QUOTES)); }
 * echo "\"$tit\",\"$txt\",,,\"old\",\"old\",\"$dat\",,,,\n<br>";
 * }
 * echo '"A future post","This is a post ",,"An excerpt of a future post.","Testing
   CSV Importer","spep.nl","2010-01-01 14:00:00",,,42,43';
    ?>
 * `[/code]

The topic ‘[csv-importer] export phpbb to csv’ is closed to new replies.

## Tags

 * [phpBB](https://wordpress.org/support/topic-tag/phpbb/)

 * 0 replies
 * 1 participant
 * Last reply from: [Landgraaf](https://wordpress.org/support/users/landgraaf/)
 * Last activity: [15 years, 4 months ago](https://wordpress.org/support/topic/csv-importer-export-phpbb-to-csv/)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics