# How to import only last two years of topics and posts (phpbb3)
**URL:** https://meta.discourse.org/t/how-to-import-only-last-two-years-of-topics-and-posts-phpbb3/53962
**Category:** Self-hosting
**Created:** [8 Dezembro , 2016 14:22 UTC](https://meta.discourse.org/t/how-to-import-only-last-two-years-of-topics-and-posts-phpbb3/53962 "2016-12-08T14:22:51Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Janno\_Liivak](https://meta.discourse.org/u/Janno_Liivak)
#### Post date: [8 Dezembro , 2016 14:22 UTC](https://meta.discourse.org/t/how-to-import-only-last-two-years-of-topics-and-posts-phpbb3/53962/1 "2016-12-08T14:22:52Z")
Hi! We’re in a process to make a move from phpbb3 to Discourse. We would like to not import older data and go for example with posts starting from year 2014 or 2015. How can this be done? Has anyone experience with such thing?
---
### Author:  [@zogstrip](https://meta.discourse.org/u/zogstrip)
#### Post date: [8 Dezembro , 2016 14:26 UTC](https://meta.discourse.org/t/how-to-import-only-last-two-years-of-topics-and-posts-phpbb3/53962/2 "2016-12-08T14:26:57Z")
Either use a dump of your phpBB3 database where you removed all the old content or modify the import script to add a condition in the SQL queries to only retrieve new content.
---
### Author:  [@Janno\_Liivak](https://meta.discourse.org/u/Janno_Liivak)
#### Post date: [8 Dezembro , 2016 14:30 UTC](https://meta.discourse.org/t/how-to-import-only-last-two-years-of-topics-and-posts-phpbb3/53962/3 "2016-12-08T14:30:31Z")
I was hoping for more specific hint… preferably something simple and elegant and what works (something from personal experience maybe) 🙂
---
### Author:  [@zogstrip](https://meta.discourse.org/u/zogstrip)
#### Post date: [8 Dezembro , 2016 14:31 UTC](https://meta.discourse.org/t/how-to-import-only-last-two-years-of-topics-and-posts-phpbb3/53962/4 "2016-12-08T14:31:11Z")
Both these solutions work and are from my personal experience 😉
---
### Author:  [@Janno\_Liivak](https://meta.discourse.org/u/Janno_Liivak)
#### Post date: [8 Dezembro , 2016 14:31 UTC](https://meta.discourse.org/t/how-to-import-only-last-two-years-of-topics-and-posts-phpbb3/53962/5 "2016-12-08T14:31:56Z")
but unfortunately too darn unspecific 😛
---
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [8 Dezembro , 2016 14:46 UTC](https://meta.discourse.org/t/how-to-import-only-last-two-years-of-topics-and-posts-phpbb3/53962/6 "2016-12-08T14:46:53Z")
I have added code to several importers that does just that. Search the import scripts for IMPORT\_AFTER for several examples.
---
### Author:  [@Janno\_Liivak](https://meta.discourse.org/u/Janno_Liivak)
#### Post date: [8 Dezembro , 2016 19:31 UTC](https://meta.discourse.org/t/how-to-import-only-last-two-years-of-topics-and-posts-phpbb3/53962/7 "2016-12-08T19:31:50Z")
What if we use “last\_post\_id” and set it to something from which we know is the last post we don’t want to import? Could it work?
Here:
>