Register Members List Search Today's Posts Mark Forums Read

Thread Tools
Old 28 Jul 2010, 21:53
neatchee neatchee is offline
Join Date: Jul 2010
Viable import format for unsupported forum via API export [UserVoice]

The company I work for has been using UserVoice as their feedback system of choice (against my urgings). They've finally been convinced that moving to vBulletin is a wise decision. UserVoice has no export options for its database, however it does have a half-way decent API which you can use to pull threads, comments, userinfo etc. My question is: If I write my own export program using their API, is there a simple (or relatively simple) format I can dump all the data into (since the forum is still relatively small) that I could then import into vBulletin 4.x? I know I can do a text userlist, but I'd like to get post data as well.

Alternatively, does anyone have a good method for using vBulletin API to do this? Take output from the UserVoice API as input to the vBulletin API? I don't really need to maintain user info on the posts, I just need the post content. So, if needbe, I'd be okay setting up a user account named "Migrated Content" and using that account as the "poster" for all the post data migrated from UserVoice. I took a look at the vBulletin API documentation but I'm honestly no programmer, so it was pretty overwhelming.
Reply With Quote
Old 29 Jul 2010, 12:14
Retal Retal is offline
Join Date: Nov 2006
I would probably go for the quick and dirty method - export Uservoice posts into a TXT file and than make INSERT statements for the vB out of the rows (any text editor with regular expressions) and paste/import them to the DB via command line / phpMyAdmin.

On another note: Why are you switching from Uservoice to vB? Is Uservoice not good?
We were thinking of implementing Uservoice for user feedback on our vB forum, because Uservoice allows the users to vote on ideas.
Be considerate to your users. Open links in the same window.
Reply With Quote
Old 29 Jul 2010, 22:39
neatchee neatchee is offline
Join Date: Jul 2010
UserVoice is great if you're looking for a mono-directional user->company feedback system. The problem is that it has no way to post announcements/stickies, poor options for forum structure, and is generally just not great for ongoing/developing conversation. If you're looking for a way for users to recommend features/ideas and then let other users vote on them, UserVoice is great. Just doesn't cut it as the main forum for a beta program (which is what we need).

Is there documentation or a how-to somewhere for making the SQL statements I'll need? I'm a little concerned about formatting and making sure that all the necessary data to have everything inserted properly is present when I do this export.
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

New To Site? Need Help?

All times are GMT. The time now is 20:47.

Layout Options | Width: Wide Color: