# phpBB 3 Importer (old)

**URL:** <https://meta.discourse.org/t/phpbb-3-importer-old/17397>\
**Category:** Feature\
**Created:** [09.Июль.2014 18:57:02 UTC](https://meta.discourse.org/t/phpbb-3-importer-old/17397 "2014-07-09T18:57:02Z")\
**Posts on this page:** 1\
**Showing post:** 73

<div class="post-metadata">

**Author:** ![michaeld](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/michaeld/32/1594_2.png) [@michaeld](https://meta.discourse.org/u/michaeld)\
**Post date:** [24.Сентябрь.2014 20:31:46 UTC](https://meta.discourse.org/t/phpbb-3-importer-old/17397/73 "2014-09-24T20:31:46Z")

</div>

> [@JSey](#):
>
> and modify the query which pulls the original contents to start at a given id. Do you have any ideas more sophisticated than this?

What we do is that we store a `discourse_id` in the original database for every post, topic and user. We create a new column in all those tables (in the old forum database) and set it to zero. If importing a certain post, topic or user succeeds we store the Discourse id (this is also handy for feeding into a SEO redirection script which we put in place instead of the old forum). If it fails we store -1. All our queries have a filter `WHERE discourse_id = 0`

This makes the script continue where it left off.

---

_[View the full topic](https://meta.discourse.org/t/phpbb-3-importer-old/17397)._