Importing Data

This topic deals with importing your old forum into Vanilla 2 using the Vanilla 2 export tool. The process is basically three steps:

  1. Export your old forum data with the Vanilla 2 export tool.
  2. Create a new Vanilla 2 installation.
  3. Import the file from step 1 to Vanilla 2

Export Your Old Forum Data

We’ve made a tool that you can use to put your old forum into a format that Vanilla 2 can import. We currently support exports from:

  • Vanilla 1
  • phpBB
  • vBulletin
  • bbPress
  • SimplePress

Here is how you use it:

  1. Grab the Vanilla 2 exporter here. The download is one file that you will copy to your server and run.
  2. Unzip the file to a directory in your old forum. For example, if your forum is located in /www/mysite/myforum then you would unzip the file to /www/mysite/myforum/vanilla2export.php.By default, the exporter will prompt you to save your export file. If your forum has a lot of data, it might make more sense to have the exporter save your data to a file on your server. If this is the case, you will need to place the vanilla2export.php file in a directory that is writable. Most forums have a /filesor /uploads directory for this.
  3. Browse to vanilla2export.php in your web browser. You should see a page like this:Vanilla Exporter UI
  4. You will need to know some information about your database in order to do the export. If you can’t remember, try looking at your forum’s configuration file. Once you’ve entered the information click Begin Export.
  5. A single file should be generated. This is the file that will be imported into Vanilla 2.

Create a New Vanilla 2 Installation

In order to import your data, you will need a fresh installation of Vanilla 2. When you do the import, all data in your fresh installation will be overwritten, so make sure you don’t have any discussions you want to keep there.

Import Your Forum

Vanilla 2 has an import utility in its dashboard. This is what you’ll use to import your forum.

  1. Go to the import tool located in your dashboard under Site Settings > Import.
  2. There are only a few inputs required. You need to upload the file and supply the username and password of the old forum’s administrative user. If your file is large (say over 5MB), you might want to upload the file manually to your /uploads directory using ftp.
  3. When you are ready to go click Upload File to get started.
  4. Once the file has been uploaded you’ll see a short summary. Click Start Import to start the import.
  5. The import should run on its own now. The length of time it takes depends on how much data you have to import. However, you will see a status update as the import progresses.
  6. Once the import is complete your data is now ready to go, however you might want to go through your site’s settings to update some of the stuff that wasn’t imported. One of the places you’ll definitely want to check is Roles & Permissions or else no one will have permission to view the discussions you just imported.
  7. At this point you’re done. Congratulations! Your Vanilla 2 installation is ready to go with your old forum’s data.

Notes

  • As of version 1.3.0 the porter will export the file attachments database data so you can port your attachments over to Vanilla 2. To do this you must enable the File Upload Vanilla 2 plugin before importing your data. You them must copy the contents of Vanilla 1′s /uploads folder to Vanilla 2′s /uploads folder.

  • bob

    phpbb please

  • Koffa

    A class for the wbb3 would be great!! I would even pay for that :)

  • fmimoso

    Please add bbpress to that list of supported export software – it’s in its way to become a WordPress plugin and, as a standalone forum it ceases to make sense, therefore, lots of people that need a standalone forum might be searching for alternatives (as myself).
    I think it’s a good opportunity to gain some more users. ;)

  • http://soccercentral.ph Chux18

    Hi There, I’m looking to import my data from Vanilla 1 to Vanilla 2 but when I was running the export tool that you gave and then hit on “Begin Export”, the apache server crashes. Any ideas? :)

  • Todd

    @bob, phpbb3 is in testing now.

    @Koffa, I have to admin that I haven’t heard of wbb3. Do you know any php? The exports are not difficult.

    @fmimoso, Those are good points. BBPress probably will be coming soon.

    @Chux18, if you want to make an issue on our issue tracker I can work through the problem with you. http://github.com/vanillaforums/Garden/issues#list

  • http://buzzdev.net buzz_lightyear

    Hi Todd,
    is the phpbb3 exporter test version available somewhere? github perhaps?

    thanx
    buzz

  • http://buzzdev.net buzz_lightyear

    Hi again,
    I’ve already found it on github…

    thanx
    buzz

  • Koffa

    @Todd Never heard of wbb3? It started as a vB clone, but right now it’s just a very mighty (german)bulletin board software.
    Yes, I am a long time php developer, but switched to ruby about a year ago. However I could try to make my own export file. I already started reading your files but I do not have much time. Are there any documents I can read or anything else that could help?

  • Gaetan

    Hey guys, I keep getting this error on import
    “Sorry, no account could be found related to the email and password you entered.”
    I keep entering the admin email and password but to no avail. ?
    Anyone else having this problem ?

    Thanks

  • WEST

    hi

    I am very tired from this script

    look this problem :

    The Discussion table is missing the following column(s): DateCreated, AuthUserID, DateLastActive, Sticky, LastUserID
    The Comment table is missing the following column(s): AuthUserID, DateCreated, EditUserID, DateEdited

  • Todd

    @Koffa. I don’t have any howto’s on writing an export yet, sorry. What I would do is grab one of the export classes, say phpbb2.php and copy it and follow its code. It is actually very straightforward.

    @Gaetan. You have to log in with the email/password of the user in the export file, not the admin user you created for the empty Vanilla 2 installation.

    @WEST. Are you sure you selected the right forum type in the drop down? What forum are you exporting from?

  • http://camstudio.org Nick The Geek

    Hi Guys

    Looking forward to updating to Vanilla 2.

    I tried to export my forum data using the porter but got the following error:

    Fatal error: Call to undefined function mb_detect_encoding() in /home/path/to/vanilla2export.php on line 362

    Any ideas?

    Cheers

    Nick :)

  • http://camstudio.org Nick The Geek

    I forgot to mention …

    I’m trying to update from Vanilla 1.1.10 > Vanilla 2

    Webhost is LiquidWeb.com

    Apache version: 1.3.42
    PHP version: 5.2.13
    MySQL version: 5.0.91-community
    OS: Linux
    Kernel version: 2.4.20-021stab028.18.77

    Cheers

    Nick :)

  • Todd

    @Nick, your server doesn’t have unicode support which we should handle. I’ll have to do an update to the exporter. I’ll let you know when it’s out.

  • Alex

    Hello.

    I seem to just get a single, vaguely formatted file output[0] (direct to the browser) when I attempt to export. Is this expected behaviour? It does seem to fail to import after

    Cheers

    A
    [0] Vaguely formatted, asin there are hyperlinks in the output.

  • Alex

    Blah. Disregard that. View Source. D’uh.

  • phil

    Wbb3 support would be great :(

  • Jason

    I’m trying to export a large (200 MB+) forum using your export tool, but the tool crashes when I try exporting to a new page, or when I try exporting to the server. When exporting to the server it creates a too small .gz zip file which is marked as corrupted when I try to uncompress. When I export to a new page the page itself crashes.

    Is there a way to run a non-compressed export to see which comments/discussions are causing the crash? Any suggestions on what else to try?

    Thanks in advance for your help…

  • Ron

    I am getting a parse error on line 51: Parse error: syntax error, unexpected T_CONST, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or ‘}’ in /homepages/4/d98586969/htdocs/XXXXX/Vanilla/vanilla2export.php on line 51

    Any ideas?

  • Me

    I always get

    * The import file is not in the correct format.

    *
    Select the file to import.

    when i try to import. help?

  • Chris

    @Ron, I’m having the same problem with the exporter. Have you had any success with a fix?

  • Chris

    @Ron, OK the issue seems to be server dependent, not with the exporter. I’m migrating servers so I exported my database from phpMyAdmin on the old server to a .sql file, imported it into a fresh database on the new server then ran vanilla2export.php on the new server. Job done!

  • http://www.flatpress.org NoWhereMan

    I’m getting a HY093 error while importing the discussions; also the email authentication doesn’t seem to work in chrome (it does work in firefox, though).

  • http://www.evaneckard.com evan

    same error as above…

    Parse error: syntax error, unexpected T_CONST, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or ‘}’

    any ideas?

  • Daniel Valenzuela

    @Ron,

    I’m getting the same problem… I’m hosted on 1and1.com

    Is there any solution to this problem?

  • Vaughn D. Taylor

    I’m getting the same error as listed above:

    Parse error: syntax error, unexpected T_CONST, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or ‘}’ in /nfs/c02/h06/mnt/XXXXXX/domains/myurl.com/html/vanilla2export.php on line 51

    I’m hosting on MediaTemple. Any solution to this would be great!

  • http://pmono.no Asle

    I followed yor steps converting from phpbb3, but no actual content came with the threads. I have 80 000 posts in my forum, none of them managed to find their way over to Vanilla.

  • Raize

    I just used your importer to go from a vBulletin 3.8.4 forum with 3200 members and 63,000 posts and it worked without any problem. I’m pleasantly surprised at how good of a tool this is. Great work!!

  • admin

    @Raize, Thanks!

  • justin

    what’s the best way to import images from the old forum?

    i’m updating from vanilla 1 to vanilla 2

  • http://raize.ca Raize

    @Todd

    I just wanted to point out that avatars are broken when doing an import from a forum such as vbulletin. The url that points to the avatar stays the same, but if the domain is changed or if the new forum is on a new server, then they will show up as broken images. There is a gravatar plugin which replaces everyones avatars with a generic image of a head, which looks a lot better than a bunch of broken images for avatars. So I was thinking, maybe it’s better not to import that previous avatars and to leave them blank so that the gravatar plugin can takeover and put placeholders there. Just a detail that isn’t too important

  • NoWhereMan

    any way of importing the dump back to an old vanilla 1 ?

  • http://pyxlmedia.com Brandon Tom

    What’s the best way to migrate from Vanilla 2.0 to Vanilla 2.0.11?

  • http://www.spirton.com/vanillaporter-1-2-1/ VanillaPorter 1.2.1 « Spirton

    [...] here and, as with before, follow the instructions here. Filed under: Uncategorized Leave a comment Comments (0) Trackbacks (0) ( subscribe to [...]

  • http://p8c.at igot2b

    worked like a charm from vanilla 1 to 2. also, after importing from phpbb to vanilla1.
    awesome work!

  • http://rodolfoberrios.com Rodolfo

    What about punbb? :(

  • Dan

    Hi, Thanks for this – very handy.
    Any idea when and if this will be able to export from Vanilla 2? We upgraded our forum, but screwed a whole bunch of things up and I’m trying to do a clean install.

    Cheers
    Dan

  • http://010fuss.com Arend

    is there a fix for this yet? This is a really crappy problem

  • Riko

    @bob,

    & Please ;-) Fluxbb version 1.2 vs 1.4 ??

    Many thaaanks

  • CiF

    Hi,

    I’m trying to convert with Exporter1.3.1 from Vanilla 1.10 to 2 and the process works somehow. But the export is missing any comment content.

    In fact there are some tables that do not get exported correctly: Comment (0 rows, 00:00.00), Conversation (0 rows, 00:00.00), ConversationMessage (0 rows, 00:00.00), UserConversation (0 rows, 00:00.00)

    What could be wrong?

  • http://Website GeciK

    Yes ;-) ) Please, don’t forget Fluxbb ! thank you

  • http://Website Mike

    I’m trying to export from wordpress to Vanilla. Can I get this ported?

  • http://soar.name soar

    What about import from IPB ?

  • http://lopar.org.ua Lopar

    smf 2.* please.

  • http://Website Kim

    Hi.
    Does this support the MyBB -> Vanilla 2 port?

  • Todd

    @Mike, you can export from SimplePress to Vanilla, but WordPress is more of a blog. Can you be more specific with what you want?

    @soar, IPB is on the list, but I haven’t started this one yet.

    @Lopar, I’m currently testing the SMF export now

    @Kim, I’ll add MyBB to the todo list.

  • http://foro.fuentedepermacultura.org Raul

    Hi,

    my current forum is an SMF 1.1.5. I wouldn’t like to upgrade to SMF 2.

    Are there possibility (or prevision) to export/import from SMF 1.1.5 to Vanilla??

    Best Regards,

  • http://Website jrapage

    As per other users comments, phpbb2 export zero’s the discussion ID meaning all the body content is ‘missing’ when imported in to Vanilla V2.

  • http://testing David

    I have a successful export from SimplePress 4.3.x although the exporter says only 1.x is supported. Should this work? When I try to import I’ve receiving the error “ImportFile is required. The import file is not in the correct format.” How do I convert my SPF 4.3.x data to 1.x?

  • http://www.axisandallies.org David Jensen

    @Todd, I realize it’s only been 12 days but any progress on that SMF export tool? I want to get away from that steaming pile of forum.

  • Todd

    @David, The issue with the SMF porter is that their BBCode doesn’t render well with either of the methods we use. SMF is not open source and they will not give me permission to use their bbcode parser right now so the job is quite significant.

  • http://Website Martin

    Hi,

    Vanilla seems to be a very cool Software and I’d like to change my forums software to vanilla. But my old Software is UNB (20100516-dev) [1] and I don’t want to lose all data. Is there any possibility that there will coma an export tool for UNB-Forums?

    [1] http://newsboard.unclassified.de/devel/docs

  • http://Website apaunganhote

    Hi Todd,

    Currently I am using phpbb 3.0.4 and after i export with ur exporter, all the data i get is user data, not forums and topics. Is it normal or can i know why?

  • http://www.linuxmintusers.de neo67

    From SMF 2.x to phpbb and than export does not went. :(
    The script create a file, but the importer is not able to import this.
    Error near line 1.

    And it makes sence, if you would add UFT-8 Code support.
    Thanks for the work until now.

    Greetz
    n.

  • http://dave.com Dave

    Surely this wont work for large databases as the PHP script will time out.

  • http://chawg.org/vanilla Sia

    It work fine, but masking all the html character inside the BBCODE
    [code]<h>
    <a href="{link=home/post}">{title}</a>
    [if-logged]<small style="font-size: 8pt color=#990000;"> (<a href="{cutepath}/index.
    <div align="justify"><p>{short-story}</p>
    </div>[/code]

  • http://chawg.org/vanilla Sia

    Sorry, should all [CODE] converting to PRE tag.

  • http://Website Rigo

    It seems my forum is too big or something, I get an “Allowed memory size of 134217728 bytes exhausted” error when I try to export.

  • http://www.mkronline.com/digitalconquest/ MKR

    Needs some way to export from Vanilla 2.

  • http://Website v2k

    Anyone fix this?

    @Asle
    > I followed yor steps converting from phpbb3, but no actual content came with the threads. I have 80 000 posts in my forum, none of them managed to find their way over to Vanilla.

  • http://Website Andy Hobday

    Has anyone done this for a WP install of Simple:Press Forums to a paid version of Vanilla Forums?

    I’n using a version 4.2.3 of SP which I would like to import over to vanilla and I’m looking for pointers please.

    Thanks in advance.

  • http://Website Bob

    Hello, The exporter seems to work well from the old site (a Vanilla 1 site) to create the file but when I go into the dashboard on the new Vanilla 2 site I can’t find any link titled “import”. The major categories I have down the left are: Dashboard, Appearance, Users, Forum, Addons, Settings. Settings only contains: Outgoing Email, Routes. The dashboard itself doesn’t have any import button either. I’m signed in as an administrator. Anyone know what is wrong? Version 2.0.17.8 installed today. Thanks!! -Bob

  • http://pfsmedia.net David Heriot

    Hi

    I’m migrating a Drupal site to a MODX site. The Drupal site has a forum and I’m trying to figure out how to export the Drupal forum data to a format where I can import it to Vanilla2.

    I have Vanilla2 installed on localhost and I have a bunch of Drupal tables which I can access and export on phpAdmin. Could anyone help with a few pointers on how I could get these Drupal tables into a state where I could import them into Vanilla2?

    thanks

    David Heriot

  • http://Website gene

    When importing from phpbb is not created field InsertUserID.
    There is only the field UpdateUserID.
    Therefore, the user name is not displayed for comments.

    We need the query after import:
    update `GDN_Comment` SET InsertUserID = UpdateUserID WHERE 1

  • http://Website JK

    It doesn’t look as though there is a “Import” option in settings. Any clue as to why this may not be appearing?

  • http://Website JK

    We’re unable to locate the “Import” link under settings in the dashboard—it does not exist. Any clues as to why this may be happening?

  • http://www.danbirlew.com Dan Birlew

    At my site I shut down my old phpBB3 board a few years ago, but left it online for viewing of old posts. Then I installed Simple:Press and my forum members migrated over to it. Because there is no import of phpBB3 for SPF. SPF has done well but leaves some things to be desired. Would it be possible with this importer to import BOTH the phpbb3 AND the SPF posts into one Vanilla forum? If so, totally worth the migration.

    Also, I see your free plan doesn’t allow for file storage, does that include no avatars? Is there a way to store avatars on my server instead, so that Vanilla would still use them? Or is that more of a sales question….?

  • http://Website Matthewc

    I would very much like to be able to export from Phorum 5.2.16 into Vanilla. It appears I will use Vanilla for new installs but I really need a migration path out of Phorum but not ready to throw it out just yet because of all the messages from the past 3 years.

  • http://Website MaERcS

    Hello. I´m trying to export a Bbpress forum, but:

    Parse error: syntax error, unexpected ‘<' in www/what/ever/vanilla2export.php on line 2957

    My server is PHP 5.2.16

  • http://mexdroid.com Jose Herrera

    I want to use this for importing BBpress 1.0.3 to Vanilla, Someone has tested it? does it works?

  • http://www.medellinstyle.com/foro jose

    INTERNAL SERVER ERROR WHEN I RUN THE IMPORT DAMN!!!!

  • http://Website Saif

    When IPB would be supported?

  • http://NoImportButton!! Dan

    Can anyone explain why the import button doesn’t appear to exist in the current download of the platform? Is something disabled somewhere? I’d love to use this package but I can’t get it imported. Please help!

  • http://4d-creations.com farhaddad

    @jose

    find line 2957

    change: }
    <?php

  • http://Website Rob

    Is it possible to use this to export the attachments from PHPBB and have them inport into Vanilla 2?

    I tried (enabling the File Upload Plugin as mentioned), but the attachments were not added.

    Thanks.

  • http://it4ug.net/ Sovichet Tep

    How about Kunena in Joomla? I want import Kunena forum’s data from Joomla! into Vanilla.

  • http://www.story-games.com Andy K

    What happens when you import from Vanilla 1.x with lots of Whispers? Since Vanilla 2.x doesn’t support Whispers anymore, what happens to them? Are the deleted, do they become Viewable By Anyone, etc?

    Thanks!
    -Andy

  • Todd

    Sorry about the parse error guys. The latest version of the porter doesn’t have that anymore. Thanks @farhaddad

    @Saif, IPB should be next in line. We are always looking for volunteers to give us a sample data dump to code exports. (I’m at todd@vanillaforums.com)

    @Dan, The import should be there at the bottom of the dashboard.

    @Matthewc, @Sovichet Tep, No plans currently for joomla and phorum, but again we are always looking for volunteers with sample data.

    @Rob, phpBB attachments are currently not supported.

    @Andy K, Whispers are imported as Conversations in Vanilla 2.

  • http://Website Stephan

    I get this message:

    usage: php parm1=value … type: The type of forum being exported (vanilla1, vanilla2, vbulletin, phpbb2, phpbb3, bbPress, SimplePress, SMF). prefix: The database table prefix. dbhost: The database host. dbname: The database name. dbuser: The database user. dbpass: The database password. savefile: Whether or not to save the file.

    What am I doing wrong? I’m using the latest Vanilla version. Thanks!

  • http://Website Saif

    @Stephan Same here, I’m trying to port SMF. I Hope Todd will fix that soon.

  • http://Whytemptfate.com Aaron

    I would love a export for ForumPress!

    http://forumpress.org/

  • http://www.spark-me.co.in/ rameez

    give import support to mybb please

  • JustinHewess

    I have the same issue as Saif and Stephan. Any assistance would be much appreciated!

  • lsandrsn

    Support for BuddyPress would really be great!

  • thanyawzinmin

    ANy for the SMFRC5 ???

  • jelo

    What exactly happens when I import? The exporter grabs user data from the relevant user tables, but are any notifications send to all users during the import? I plan to do test migration and just want to make sure that none of my users will in any way be directed to the new vanilla installation or similar….

  • olivierlacan

    The export fails with:- Premature end of script headers: vanilla2export.php, referer: http://***/export/vanilla2export.php

    - File does not exist: /home/***/internal_error.html, referer: http://***/export/vanilla2export.phpThe export folder is writeable (777) and all database connection settings are correct.Host is Dreamhost.

  • Thomas

    PunBB please !

  • eLcHiNoTe

    please check you’re not using php 4. migrate to php5, this solve your problem. regards

  • eLcHiNoTe

    please check you’re not using php 4. migrate to php5, this solve your problem. regards

  • http://www.chowchowbath.com geeksrik

    What about from myBB ?

  • http://www.chowchowbath.com geeksrik

    What about from myBB ?

  • Jon Kroeger

    When attempting to export my vBulletin 3.5.3 forum with Porter, I get the following error:

    The phrase table is missing the following column(s): fieldname

    I have no table prefix, but it puts “LUM_” into the table prefix field after the error happens, but I have no idea if that’s related or not.  My database server as uses a port, but adding that or leaving it off seems to have no affect.

  • Jon Kroeger

    When attempting to export my vBulletin 3.5.3 forum with Porter, I get the following error:

    The phrase table is missing the following column(s): fieldname

    I have no table prefix, but it puts “LUM_” into the table prefix field after the error happens, but I have no idea if that’s related or not.  My database server as uses a port, but adding that or leaving it off seems to have no affect.

  • Daniel Hunt

    It looks like the importer isn’t working right now.
    I’ve exported and gzipped an old database, and after uploading the file to the importer, I get 3 form errors (despite all fields being set as expected) :
    You must select a file to import.Email is required.Password is required.

  • Daniel Hunt

    It looks like the importer isn’t working right now.
    I’ve exported and gzipped an old database, and after uploading the file to the importer, I get 3 form errors (despite all fields being set as expected) :
    You must select a file to import.Email is required.Password is required.

  • Dvmorris

    Did you ever find a resolution to this? I’m having the same issue.

    Thanks,
    Dave

  • Bob

    In case anyone in the future has the same problem I had, it appears that the “import” button reference in the 3rd step of this process may not actually display if Vanilla is hosted on a Windows server.  It took me a lot of playing around before I realized this might be due to some Linux dependency but when I finally moved my install from a Windows server to a Linux server the button was there and the process worked fine.  I saw now other problems while hosting on Windows, just the missing import button, so it was unclear that there was an OS problem.  Just wanted to help out the next guy who has a Windows server and tries Vanilla.  

  • Bob

    In case anyone in the future has the same problem I had, it appears that the “import” button reference in the 3rd step of this process may not actually display if Vanilla is hosted on a Windows server.  It took me a lot of playing around before I realized this might be due to some Linux dependency but when I finally moved my install from a Windows server to a Linux server the button was there and the process worked fine.  I saw now other problems while hosting on Windows, just the missing import button, so it was unclear that there was an OS problem.  Just wanted to help out the next guy who has a Windows server and tries Vanilla.  

Partner/Referral Program Terms of Service Privacy Policy Refund Policy We're Hiring! About Us Contact Us