Importers (requests & poll)

[Jerry]

With the upcoming release of the importer system I'm sorting out the order for which importers to do and what order.

Currently there is: ubb.eve 4.02, ubb.classic 6.7, IPB 1.3 and phpBB2.

Next I'm going to be working on OpenTopic and wBB.

After that there is a list but no definite order so here a poll bit like the one (http://www.vbulletin.com/forum/showthread.php?t=13880) John did a while ago.

Suggestions ?

[Bill Thebert]

One vote for WebBBS.

[Floris]

I voted for: vB3

[mOdEtWo]

You've already made the phpBB2 scripts Jerry, as you said - so I'm happy. :)

[conqsoft]

Would be nice to have one for FuseTalk one day. (www.fusetalk.com) I have several clients currently using it, that I would like to convert over. (One is making the conversion anyway, and losing all his posts. I did a quick and dirty process to at least import his users.)

[msimonds]

are there any updates on when the import script system is going to be ready for ubb

[Semperfidelis]

A vb3 importer all the way
That is one thing that would have come in handy some many times whilst on the 2x series

[tgmorris]

Other - WebBBS

[Jerry]

are there any updates on when the import script system is going to be ready for ubb

Which one ? I've done classic and eve, threads I suppose ?

[Jerry]

A vb3 importer all the way
That is one thing that would have come in handy some many times whilst on the 2x series

Yup been asked for that a few times to be able to merge vB3 boards.

[juanchi]

I know this has been ask several times, but I will like to know when will I get my hands on the importer for phpBB2, I'm desperate to get my forum running on vb 3.0.0, thanks.;)

[Xube]

:rolleyes: What about ezboard (ezboard.com) and Yahoo! groups (groups.yahoo.com/group). The Yahoo one would be HUGE if it were possible...

[Zachery]

ezboard is already avalible, at least that im aware of.

[Brad.loo]

Are ubb.x boards still around? I thought they all went over to eve. What about IPB 2.0? it should be coming along to RC/gold stages soon.

[huuquynh]

I love vBulletin, so that why I want to change my forums from IPB to vBulletin. But there is not any importer scripts convert from IPB 1.3 to vBulletin 3.0 Final. When?

[Jerry]

:rolleyes: What about ezboard (ezboard.com) and Yahoo! groups (groups.yahoo.com/group). The Yahoo one would be HUGE if it were possible...

ezboard board has been done and why would Yahoo be impossiable, why can't it be done ?

[floleb7]

it's amazing mesdiscussions.net is on your list :D

[Jerry]

it's amazing mesdiscussions.net is on your list :D

I put all the ones I've been asked for in the past to try and gauge public demand. Luckily my French isn't that bad so I might be ok with it ;)

[floleb7]

I put all the ones I've been asked for in the past to try and gauge public demand. Luckily my French isn't that bad so I might be ok with it ;)
i don't know if you tested mesdiscussions.net but there are lots of feature vB needs
but it's not the subject here maybe i'll open a thread for that ;)

[Jerry]

i don't know if you tested mesdiscussions.net but there are lots of feature vB needs
but it's not the subject here maybe i'll open a thread for that ;)

Not yet no to be honest, though when writing the importers I'm after as much data as I can get, importing features is a bit harder to do though I'll look into it ;)

Though a "new features I R want" thread might be the way to go.

[TheSonic]

I need a vb3-Conv to merge two vb3s...
Not just me, i have a look at the votes - so i hope chances are not too bad :D

[Jerry]

I need a vb3-Conv to merge two vb3s...
Not just me, i have a look at the votes - so i hope chances are not too bad :D

Yup would seem to be winning at the moment.

[WildEye]

I need a vb3-Conv to merge two vb3s...
Not just me, i have a look at the votes - so i hope chances are not too bad :D
I would like this aswell...

[cirisme]

What about just plain YaBB? You have the Splinter Editition(PHP) on the list, but good old' YaBB(Perl) would be nice, too. :)

[stoopid]

vbulletin to vbulletin would be nice, telnet and ssh are not standard on all hosts and I recently had to cancel a move because my new host didn't allow this access. Why offer a sql dump if you can't ever import it?

I'm slowly working my way over to vb3, and I think some of this is solved (vbulletin team will assist in restores). But for someone like me on 2.3.0 it's VERY frustrating!

[lilsalmon]

Am I reading this thread correctly...I am in desperate need of the PHPBB to vB3 importer...I have had lengthy conversations with Steve Machol already about this and expressed my grave concern over the lack of its release. I am really behind the proverbial '8 ball' because the importers have not been released yet. I have a site ready to be deployed, but can't because a major part of the release includes the new vB3 forum system. A little help on where and/or when I can get this would make my situation a little easier to deal with. Thanks.

-Lil'

[shallowbay]

If this is the appropriate place, I'd like to request the phpBB importer so I can get my new board up and running.

Thanks for your hard work.

[Jerry]

phpBB2.

Yes this is the correct place.

Yes is done.

It's being release with the main system.

[lilsalmon]

So what you are telling me is...even though this is completed we must now wait till importers are built for ALL BB systems available???

-Lil'

[Jerry]

So what you are telling me is...even though this is completed we must now wait till importers are built for ALL BB systems available???

-Lil'


Nope, not at all.

Thoses 4 are done, at the moment we are getting the main system ready to be released (with the 4 that are done) once that is done, then I'll get on with writting the others and maintaining and updating the released ones etc.

[lilsalmon]

Excellent!... Thanks for the hard work on these...the sooner the release the better with the projects I need to complete!

-Lil'

[nepolia]

Just because I couldn't find anything about this anywhere else; Where will the converters be placed when they are ready for download? In the members area?

And what main system? the board itself? I thought you had just released a new update :)

[Jerry]

And what main system? the board itself? I thought you had just released a new update :)

The importer system I'll explain in an announcement when its released.

[nepolia]

Aha. Okey, sorry ;)

I can be patient.. ;)

[ITDev]

phpBB2.

Yes this is the correct place.

Yes is done.

It's being release with the main system.When?

[Jerry]

When?

Once again, this week.

As per the announcement and quite a few posts, though plus the time its taken to write this.

[ITDev]

I dont think you get to be sarcastic..

[Jerry]

I dont think you get to be sarcastic..

Nope not at all, it is the truth.

[CrazyFool]

I'm glad the phpbb2 one is done... I just wish I could get it. :( I am ready to convert over ASAP. ;)

[vissa]

I hope UBB classic 6.2x is able to be imported... Will the 6.7 importer be backwards compatible with that?

[Hoobastank68]

Definitely XMB :)

[Downlo]

Hope you do ubb threads also version 6.4

[Ryan Ashbrook]

With the upcoming release of the importer system I'm sorting out the order for which importers to do and what order.

Currently there is: ubb.eve 4.02, ubb.classic 6.7, IPB 1.3 and phpBB2.

Next I'm going to be working on OpenTopic and wBB.

Suggestions ?
When you say wBB you do mean Woltlab's Burning Board, right?

I'd love to see one for Burning Board 1.2 and 2.x. :)

Although I'd love to see one for vB3, and XMB.

Think you can do a My Bulletin Board one as well?

[mOdEtWo]

Jerry,

I want to ask you something. Will the phpBB2 importer support PM's and date-of-birth type of info? The old vB2 importers didn't support this, so I really hope the vB3 ones will. :)

[TheMusicMan]

I have asked for an Import Specification document in another thread of mine somewhere - I'm sure we will get something in a few days that will explain exactly what data-items and tables will be imported etc...

[Jerry]

I have asked for an Import Specification document in another thread of mine somewhere - I'm sure we will get something in a few days that will explain exactly what data-items and tables will be imported etc...

Writing it atm.

[Jerry]

When you say wBB you do mean Woltlab's Burning Board, right?

Yes.

Think you can do a My Bulletin Board one as well?

My cat could write that one the database schemas are so close .... so yea not a problem.

[TheMusicMan]

Writing it atm.
Excellent Jerry - didn't mean that to be a prod though...;)

Still... very much lookikng forward to reading through it.

[Jerry]

:rolleyes: What about ezboard (ezboard.com) and Yahoo! groups (groups.yahoo.com/group). The Yahoo one would be HUGE if it were possible...

So why wouldn't this be possible ?

[Ryan Ashbrook]

Yes.



My cat could write that one the database schemas are so close .... so yea not a problem.
Alright, that's all good then. :)

[mfowler70]

What about PNphpbb2, and specifically, version 1.2a.

Or would the regular phpbb2 importer work for that one?

[pipedreams]

Snitz would be great, at the moment I have to do this:-

snitz -> phpbb -> vb2 -> vb3!

[Jerry]

Snitz would be great, at the moment I have to do this:-

snitz -> phpbb -> vb2 -> vb3!

Its on the list, vote away :)

[pipedreams]

I just did!, when do you think it would come out?

Even the php2 -> vb3 would save me time - when is that out?

[msimonds]

Jerry

Is this going to work on all versions leading up to UBB 6.7, like in my case it is UBB 6.3.1


Thanks
Mike

[Jerry]

Jerry

Is this going to work on all versions leading up to UBB 6.7, like in my case it is UBB 6.3.1


Thanks
Mike

I think the lowest version I've tested it on was 6.2.something.

In the early versions it was PM's that were the trickiest.

Answer :

Probably and if it doesn't I'll fix it.

[Jerry]

I just did!, when do you think it would come out?

Even the php2 -> vb3 would save me time - when is that out?

Of the current list, vB3 will be next. After I've done wBB and OT.

After that it will be done to the votes I'd guess.

[mfowler70]

What about PNphpbb2, and specifically, version 1.2a.

Or would the regular phpbb2 importer work for that one?
What am I, invisible? :eek: or did I just answer my own question?

[Jerry]

What am I, invisible? :eek: or did I just answer my own question?

I take it you mean Post Nuke ?

If so the only commonality at the moment are the users as long as they are sync'ed up. I will have to write another import for that one as the schema is so diffrent from phpBB2.

I've added post nuke to the poll.

[Jerry]

I have asked for an Import Specification document in another thread of mine somewhere - I'm sure we will get something in a few days that will explain exactly what data-items and tables will be imported etc...

At the moment, I've not documented each importer as to the exact elements that get imported per module just the API, but by nature of the importers you can see on the main menu what is done generally (i.e. post, threads, moderators, etc).

[mfowler70]

I take it you mean Post Nuke ?

If so the only commonality at the moment are the users as long as they are sync'ed up. I will have to write another import for that one as the schema is so diffrent from phpBB2.

I've added post nuke to the poll.
I'm referring to PNphpbb2, which is a modified version of phpBB specifically modified to work with postnuke. The dev site is http://www.pnphpbb.com/. Not sure if it's the same that you're thinking of, and I do recall there being other phpbb ports for postnuke.

The version I'm running is 1.2a, which was the latest last time I checked.

Seems I remember seeing a post somewhere on this site where someone removed the nuke_ prefix from his db tables (which left the original phpbb table names), and then ran the phpbb importer and it worked. My question is more to the point of would it be easy for you to modify the script to recognize the nuke_ prefix and then call it a pnphpbb2 importer....and also I was wondering if the VB3 version of the phpbb script would have changed to the extent that it would no longer work with PNphpbb2 (minus the nuke_ prefixes)?

[Jerry]

I'm referring to PNphpbb2, which is a modified version of phpBB specifically modified to work with postnuke. The dev site is http://www.pnphpbb.com/. Not sure if it's the same that you're thinking of, and I do recall there being other phpbb ports for postnuke.

The version I'm running is 1.2a, which was the latest last time I checked.

Seems I remember seeing a post somewhere on this site where someone removed the nuke_ prefix from his db tables (which left the original phpbb table names), and then ran the phpbb importer and it worked. My question is more to the point of would it be easy for you to modify the script to recognize the nuke_ prefix and then call it a pnphpbb2 importer....and also I was wondering if the VB3 version of the phpbb script would have changed to the extent that it would no longer work with PNphpbb2 (minus the nuke_ prefixes)?

To be honest with out having a PNphpBB database to test againsn't I could say either way, though table prefixes are taken care of in the new importers.

I'll download it and have a go.

[bL@De]

I notice IPB 1.3 has been completed, will this also include 1.2? or am I better off upgrading to 1.3 and then doing it from there?

Thanks

[Jerry]

I notice IPB 1.3 has been completed, will this also include 1.2? or am I better off upgrading to 1.3 and then doing it from there?

Thanks

I belive there arn't any major diffrences to the database between 1.2 and 1.3, so it should be fine.

Personally I would try it straight off, if it dosn't work submitt a bug. Then upgrade to 1.3 and go from there.

[bL@De]

No worries at all.

Thanks Jerry.

[Jerry]

http://www.vbulletin.com/forum/showthread.php?p=653266

[TheSonic]

Great, but i hope we get a vb3-importer for vb3 - this one also had the most votes :D

[Jerry]

Great, but i hope we get a vb3-importer for vb3 - this one also had the most votes :D

After wBB and OT are finished yes.

[VodkaFish]

I've offered my help to the team if they wish to build a Snitz importer. I ran it for years and imported a rather large forum into vb.

[Jerry]

I've offered my help to the team if they wish to build a Snitz importer. I ran it for years and imported a rather large forum into vb.

I'll PM you when it comes up then :)

[ImportPassion.com]

Fusetalk
http://www.fusetalk.com

[Jimmy Kane]

After wBB and OT are finished yes.
Wicked, i cant wait for the vb3-vb3,
I have two 200 meg dbs you could use for testing if you want?

[cobraclub]

I am really interested in the DCF+ importer, have voted for it and am eagerly awaiting a date for the release.

I am able to test the DCF+ importer as I have a DCF+ and VB test forum set-up already on my server for testing and playing with. :D :)

Robert

[Jerry]

Fusetalk
http://www.fusetalk.com

On the poll now.

[Mike Sullivan]

Wicked, i cant wait for the vb3-vb3,
I have two 200 meg dbs you could use for testing if you want?
I'm pretty sure we have whatever source vB3 data necessary. :)

[Jerry]

1.01 done

IPB groups and phpBB user select fixed.

[mfowler70]

Jerry, can you give me an ETA on impex for pnphpbb 1.2a?

[Jerry]

No, I can't give any dates at the moment due to not being able to predict the order that the poll will dictate which importers to do in which order.

The only times I can give are on the importers I'm working on at that time, i.e. right now is wBB.

Also MiniBB is the only system with less votes.

[infobeto]

1.01 done

IPB groups and phpBB user select fixed.Jerry does this mean that the problem with missing users for the transfer from phpbb to VB3 has been fixed? :confused:

Sorry If I'm totally talking about something different.

The importer for phpbb2 does not work properly and I doubt someone has done a full transfer. Do you have any news Jerry? I bought VB3 just for this reason.

Thank you for your time.

Nektarios

[mOdEtWo]

1.01 done

IPB groups and phpBB user select fixed.
Is the package in the members area updated?

[Jerry]

Is the package in the members area updated?

Yup, did it this morning. Still working on 1 phpBB and 1 IPB issue atm as well as doing the wBB importer.

[TalkMilitary]

Another vote for WebBBS. I have several years of posts that would rather be in vB3 :)
Glenn

[Jerry]

Is the package in the members area updated?

It is updated every time a bug is fixed as well.

[MrNase]

Other => ThWboard @ http://www.thwboard.de (mostly german)

Don't ask me why i propose a converter for that software. Iam one of the main developers :rolleyes:
It is just there are some projects that need a fast and simple solution. Nothing against vB but a ThWboard is a lot easier to understand for newbies :)
Don't let us argue about it, ok? ;)

[Dream On]

What About phpNuke ;)

[Jerry]

Other => ThWboard @ http://www.thwboard.de (mostly german)

Don't ask me why i propose a converter for that software. Iam one of the main developers :rolleyes:
It is just there are some projects that need a fast and simple solution. Nothing against vB but a ThWboard is a lot easier to understand for newbies :)
Don't let us argue about it, ok? ;)

I included the core API doc for people that want to do their own importers.

[Corbu]

Suggestions ?

Many people need UBB Thread Importers ! I have a UBB Threads 6.4 and there were no importers...

[Jerry]

Many people need UBB Thread Importers ! I have a UBB Threads 6.4 and there were no importers...

Yup thats on the poll now :)

[mfowler70]

No, I can't give any dates at the moment due to not being able to predict the order that the poll will dictate which importers to do in which order.

The only times I can give are on the importers I'm working on at that time, i.e. right now is wBB.

Also MiniBB is the only system with less votes.
OpenTopic only has 2 votes, and WBB 5.....and they are both being worked on.

[Jerry]

OpenTopic only has 2 votes, and WBB 5.....and they are both being worked on.

With the upcoming release of the importer system I'm sorting out the order for which importers to do and what order.

Currently there is: ubb.eve 4.02, ubb.classic 6.7, IPB 1.3 and phpBB2.

Next I'm going to be working on OpenTopic and wBB.

I always said I was going to do those two next, read the first post in this thread.

[cobraclub]

Jerry

Any update on a release for DCForum?

Best Regards

Robert

[Jerry]

Jerry

Any update on a release for DCForum?

Best Regards

Robert

I update the text on the poll as the importers are done and as I find and fix the bugs, i.e. 4 are done and on OT now, then going to be on vB3 by the looks of it, then YaBB SE and so on.

[mOdEtWo]

I hope you update the Bug Count on the phpBB2 importer, cause it's more than 1 bug remaining. ;)

Keep up the good work, Jerry!

[Jerry]

I hope you update the Bug Count on the phpBB2 importer, cause it's more than 1 bug remaining. ;)

Keep up the good work, Jerry!

Yea, taken that off now, every time I fix one I rebuild the impex download so first port of call to anyone having troubles is to download it to make sure they have the latest then do an import etc.

[mOdEtWo]

Yea, taken that off now, every time I fix one I rebuild the impex download so first port of call to anyone having troubles is to download it to make sure they have the latest then do an import etc.
I see.

I've got a suggestion tho. Maybe you should create a closed thread and stick in somewhere - and post a new message whenever you update the package. And then, of course, tell short about what in the package that have been updated (like a spesific phpBB2 bug).

Whenever I see you say that you have updated the package, I test it out to see if the phpBB2 bugs are fixed, and then I give you feedback. It would be easier for me to do that if you told us when you've fixed a bug and updated the package.

Just a thought. :)

[Jerry]

Yea, I'll do something like that I think, I'll have a chat with Kier when he gets back to see how he wants it done.

[mOdEtWo]

Great! http://images.vbulletin.com/images_vb3/icons/icon14.gif

[Jerry]

wBB done and in testing with a user. Working on OpenTopic now.

[Jerry]

Request for IPB 1.3 subscriptions to be added to the importer :

http://www.vbulletin.com/forum/showthread.php?t=101482

[Jerry]

wBB released, finishing OT now, looks like vB3 beginning of next week then its a close 2nd but YaBB SE seems to have it at the moment.

[Shadow Duelist]

I voted for: vB3
How can you import from vB3 to vB3? LoL that make no sense..

Unless your upgarding..

[conqsoft]

How can you import from vB3 to vB3? LoL that make no sense..

Unless your upgarding..

Combining two vB3 sites.

[Shadow Duelist]

Combining two vB3 sites.
Huh?

[Zachery]

You combine Site A into Site B

:)

[Shadow Duelist]

Ohhhh.

[Jerry]

wBB importer updated, user options and permissions.

Sorting phpBB now.

[Jerry]

Lists of bug fixes per version can be found in "impex.readme.txt" in the download at the bottom of the file.

As this file will have to be updated when anything is fixed any where in impex, the @version will denote the impex version that you have downloaded.

[Jerry]

Version 1.3 done now.

Mainly phpBB & wBB fixeds and two core things.

IPB bugs & changes tomorrow.

[cobraclub]

Jerry

Hows the DCF+ looking, any nearer to starting it?

Thanks

Rob

[Jerry]

http://www.vbulletin.com/forum/poll.php?do=showresults&pollid=805

[cobraclub]

I am aware of the poll, however how does that map to timescales?

I need to let my forum members know and look at testing and downtime.

[Jerry]

Well it looks like it is currently in 10th place. I could tell you a projected date based on how the poll is now, but if it all changed in the next week my estimate would be wrong, I will only be able to give an estimate when it is in the top 5 or so to do.

[cobraclub]

Go on, finger in the air, ballpark timescale, you could always caveat it.

I can neither confirm nor deny the above statement and had no prior knowledge of the fact, or something like that. :D :p :p

Rob

[Joshua Clinard]

I'd really like to see a vB2 importer so really large boards could migrate without having too much downtime.

[FindSP.com]

I voted for vb2

[jacobi]

Just letting people know that Discus/Discus Pro is officially listed on the poll above as "DC + - Discuss & MySQL."

[cobraclub]

http://www.vbulletin.com/forum/poll.php?do=showresults&pollid=805
Now I am really confused, following jacobis post, is DCForum not even listed up there??????? :confused: :confused: :confused: :mad: :mad: :mad: :mad: :mad: :mad: :mad:

[Jerry]

Now I am really confused, following jacobis post, is DCForum not even listed up there??????? :confused: :confused: :confused: :mad: :mad: :mad: :mad: :mad: :mad: :mad:

The one you are after is the top one in the poll.

[cobraclub]

The one you are after is the top one in the poll.
Can you change it to DCForum so it doesn't get confused Discus/Discus Pro as it really threw me when I read the other post.

[chrisvonc]

Hmm, is it possible for me to change my vote to that then? Been hoping for a Discus import of my messages ever since I switched to VB.
:)
Just letting people know that Discus/Discus Pro is officially listed on the poll above as "DC + - Discuss & MySQL."

[Jerry]

1.7 done.

IPB threads parent id's changed. ubb posts parsning, corse functions for vB3 importer.

OT in testing ,vB3 importer about 50% done.

[mfowler70]

I was able to successfully import my PNphpbb2 database tables into vbulletin. Any of you guys in need, just send me a PM.

Mike

[vb-hispano]

vb3 is first you'd must do, because is a help to vbulletin comunity

[poolking]

vb3 is first you'd must do, because is a help to vbulletin comunity


Have you read Jerry's latest post?

[Razgo]

go yabbse!! can't wait. it's so close i think i can taste it :)

[vb-hispano]

Have you read Jerry's latest post?
nop, sorry jerry
:D

[Jerry]

nop, sorry jerry
:D

No problemo :) I'm working on it at the moment.

[Jerry]

go yabbse!! can't wait. it's so close i think i can taste it :)

Just started it :D

[Razgo]

ok i just put my bib on to catch the drool in anticipation :)

[Steward]

Define a text layout which can survive over time and versions. A windows INI file is an example. Something with NAME=VALUE pairs, organized into sections and/or categories etc.

Always import into vb from this. The importer takes care of missing values. You cannot know what the other fellow is supplying. Stop trying.

Now all other importers are a matter of dumping into that format.

You could even document it, and let other people convert their own data into that format, then use your script to suck it into vb.

It appears to me you have done something sexy with the importers. Objects and classes and not a helluva lot of documentation. You are dealing with people who are new to the software, and are looking to get this one step over with so they can get their hands dirty. I speak for myself of course.

Keep it simple.

Good luck.

[Jerry]

Well I looked at lots of different ways of doing it and the system that I came up with in the end does 3 things, firstly keeps the data model of vB intact by only allowing valid data to be imported, the vB2 importers would often break the database and loose dependencies.

Secondly it hides a lot of the workings in the core system to abstract the separate importers away from it, so there is no dependency on the source.

Thirdly is makes writing the imports easy (ok, I'm bias as I wrote it, but its true) because mostly all you have to worry about is the middle part of any module where you add the mandatory and non mandatory data.

I did think of value paired system where you would define matches in something like an INI file, but there is too many holes in the design and it doesn't cater to lots of different data sources. You'd have to get the source data some how as well.

As it is the vast majority of the time you do know what the other person is supplying, but more importantly you know what you can accept, ImpExData takes care of all that with is_valid() so you don't have to worry about it.

I did do (and released) a OO-API doc with ImpEx, there are more tools that go with it, most of the code for the system is automatically generated as it is.

Compared to vB3 its fairly simple, its just the design lent itself to OO better than structured.

As for other people developing with it I am working on some docs and other resources to make this easier.

Cheers for the feedback :)

[Steward]

I understood the beauty of your model immediately.

It does not make writing imports easy for a stranger. I do not want to know the details of vb, and I appreciate your hiding them.

But you hid the baby with the bath water, so to speak.

Although you have hidden the ugly details of vb from me, you have also hidden the stunningly seek and perfect details of your importer module. I am lost in pages and pages of techincal documentation and scripts.



I did think of value paired system where you would define matches in something like an INI file, but there is too many holes in the design and it doesn't cater to lots of different data sources. You'd have to get the source data some how as well.

Yet, in another thread somewhere (http://www.vbulletin.com/forum/showthread.php?p=671122#post671122), you have asked me for a sample user file.


A simple example would help me wonders...

1. Make sure your script is in this place and has these headers.
2. Create this object or that object.
3. Feed this object your database details.
4. Modify this function to handle field conversions.
5. Run your script and poof, your member file is converted.

So I guess my suggestion is: documentation for idiots with a simple task at hand.

Lord knows I can be an idiot.

Cheers

[jacobi]

Hi Jerry -- Now I'm really confused. :confused: Judging by this post (http://www.vbulletin.com/forum/showpost.php?p=670229&postcount=9), the converter that's listed as "done," i.e., "DC Forum+ / Discus Pro" is actually only DC Forum (http://dcscripts.com/) and not Discus (http://www.discusware.com/). You apparently misinterpreted my request of several weeks ago to add Discus to the poll (though you referred to flat file or MySQL backend -- both of which could mean Discus), and now I erroneously rallied, and misdirected other Discus users to vote for DC Forum, pushing it up to "finished" status very quickly. As I alluded to in this thread (http://www.vbulletin.com/forum/showthread.php?t=100105), I have been going back and forth with vBulletin staff for quite some time now. Now, I fear that even if you do add Discus to the poll, it will be a start from ground-zero, and all of us who voted for DC Forum or "other" will have no recourse.

Please help. Please.

[ducasi]

I hope vB2 gets done soon - it's not at the top of the vote list, but it surely must be easier than, say, Yahoo groups?

I've got a fairly large forum that I want to move over to vB3, but it has been tweaked quite a bit and I need to figure out how to tweak vB3 in the same way.

I don't want to have to do all my modifications twice and I have to keep downtime to the absolute minimum, so being able to perfect my vB3 install while the vB2 one continues and then once I'm ready doing an import, would be fantastic.

Cheers!

[Jerry]

Yup anything with a database back end will be easier, and faster to develop.

The poll is just one factor that effects the order they are done in, probably the strongest deciding factor though

[Razgo]

yabbse done? its not in the importer i just downloaded?

[Zachery]

Did you go to the Impex settings and see if it was in the drop down?

[Razgo]

yes. it is not there.

thanks.

[Wayne Luke]

yes. it is not there.

thanks.
There was a problem with the CVS tree and the download hadn't been updated yet as far as I am aware. Should be available tomorrow, sorry for the false start.

[Razgo]

no worries, will wait for tomorrow.

thanks.

[Jerry]

YaBB SE is in the download now.

Vr 1.10.

[chrisvonc]

Hi Jerry -- Now I'm really confused. :confused: Judging by this post (http://www.vbulletin.com/forum/showpost.php?p=670229&postcount=9), the converter that's listed as "done," i.e., "DC Forum+ / Discus Pro" is actually only DC Forum (http://dcscripts.com/) and not Discus (http://www.discusware.com/). You apparently misinterpreted my request of several weeks ago to add Discus to the poll (though you referred to flat file or MySQL backend -- both of which could mean Discus), and now I erroneously rallied, and misdirected other Discus users to vote for DC Forum, pushing it up to "finished" status very quickly. As I alluded to in this thread (http://www.vbulletin.com/forum/showthread.php?t=100105), I have been going back and forth with vBulletin staff for quite some time now. Now, I fear that even if you do add Discus to the poll, it will be a start from ground-zero, and all of us who voted for DC Forum or "other" will have no recourse.Well said Jacob!

I have been getting by with a link back to my old Discus forum for the old messages, but I agree with Jacobs comments and feelings. Discus was not even on the list if I recall when this first started. How many of the 16 votes for DC were actually for Discus and how many votes were cast for something else before Discus made it on the list that cant be changed to the correct selection now that its available? I see now there is a seperate Discus listing now but with 0 votes, we all know that does not truely reflect the interest in an importer for Discus.

I also see that its listing the intent to test on user accounts and I assume that plans to test importing the messages from a Discus forum, would be following closely after? All my users have long already migrated themselves over to the vB forum and anyone who has not, can easily create their new account so, my situation for example, the message importer portion would be much more pratical.

Like I said, I personally am working around it fine and its not something I "have to have this second" so please dont take my comments that way. But, I can see how there can be a level of fustration that we cant even properly reflect our need for something that should have been on the listing from the get go.

[Jerry]

The poll is just one influence in the decision making for the order they are done in.

DC had hardly any votes and was done for other reasons.

The belief that the Discus votes effected the DC+ importer is completely wrong.

[Jerry]

ubb.classic polls module added.

[Bailx]

vb3 to vb3 all the way :cool: (psst... it has the most votes) ;)

[Jerry]

vB3 is done now, its in the download.

[FindSP.com]

Man too bad you didn't say that 2 weeks ago - I decided to open a new forum instead of just uploading the old db :)

[dndog]

What is your estimate for the time the PNphpBB2 importer will be released?

[Jerry]

Snitz done.

[dndog]

I have test data for PNphpBB2. How can I send it over to the vB team?

[Jerry]

I have test data for PNphpBB2. How can I send it over to the vB team?

For things like this PM me and we'll sort it out.

[Duke of Lions]

Would love to see a feature where vb can import Alxnet Guestbooks like these:
http://pub.alxnet.com/guestbook?id=1232871
'Cause they were widely used, and it would be nice to preserve the data in it.....

[MrNase]

ThWboard @ http://www.thwboard.de


Jerry, contact me if you need some sample data and/or files.

[Jerry]

ThWboard @ http://www.thwboard.de


Jerry, contact me if you need some sample data and/or files.

Okies will do when the time comes !

[Hellraider]

I need an importer for wBB 1.2

Sample DB is available if someone needs it.

[makaiguy]

How far back down the UBB classic chain does the ubb.classic 6.7 converter cover? I'm working on a system to replace an old UBB classic 5.47. Plans were to convert into vB 2.3.5 then upgrade to 3.0.1, but if I can import directly into 3.0.1 that would obviously be preferable.

[Jerry]

How far back down the UBB classic chain does the ubb.classic 6.7 converter cover? I'm working on a system to replace an old UBB classic 5.47. Plans were to convert into vB 2.3.5 then upgrade to 3.0.1, but if I can import directly into 3.0.1 that would obviously be preferable.

I've only ever had enough test data to get it working with 6.3 , I've never had the chance to test it with that version so I couldn't say what would happen.

[dndog]

Under PNphpBB2, it says that it needs test data. I thought I already sent the data, or did something go wrong in the process?

[Jerry]

Under PNphpBB2, it says that it needs test data. I thought I already sent the data, or did something go wrong in the process?

Nope its all good, but you can never have enough test data, one board might show up something on an import that something else might not.

[dndog]

Jerry, can you give me an ETA on when the PNphpBB importer will be finished? I need it soon...

[Shadow Duelist]

Hey Jerry,

Are you making a IPB 2.0.0 converter?

Not that I'm using IPB.. just saying because there's gon' be alot of poeple using the 2.0.

[Jerry]

Jerry, can you give me an ETA on when the PNphpBB importer will be finished? I need it soon...

Nope I can't the work load at the moment is too dynamic and there are some higher priority importers that are going to take a while due to being file based.

[Jerry]

Hey Jerry,

Are you making a IPB 2.0.0 converter?

Not that I'm using IPB.. just saying because there's gon' be alot of poeple using the 2.0.

Defiantly, though there are too many bugs with the current importers that I/we need to get sorted along with some functionality that didn't make it into the core with the release, like attachments and internal link parsing.

I'd like to get what we have running as smooth as possible before putting time into more importers. There are 13 out now and 3 more in dev with 4 more waiting that I have data for now.

Also by the time that’s all sorted there should be some nice IPB 2 boards available as test data for me to use.

I've put it on the poll.

[Joshua Clinard]

Can you reset the poll, or maybe start a new one? It seems wrong to have so many options that are already done. And did you think that some people may have more than one type of forum they wish to convert? And since they can only vote once, you won't really know what their needs are.

Also, is vb2 one of the ones in dev?

[Jerry]

Can you reset the poll, or maybe start a new one? It seems wrong to have so many options that are already done. And did you think that some people may have more than one type of forum they wish to convert? And since they can only vote once, you won't really know what their needs are.

Also, is vb2 one of the ones in dev?

I'm leaving the ones that are done in there for completeness so I don't get asked for them when they are already done.

The poll is multi vote so people can vote for as many as they like, I made it like that from day one.

vB2 is not in dev at the moment, the ones that are or are waiting have notes next to the forum type name.

[dndog]

The poll is multi vote so people can vote for as many as they like, I made it like that from day one.

Are you sure its multivote? It says that I've already voted and will not allow me to vote again...

[Jerry]

Are you sure its multivote? It says that I've already voted and will not allow me to vote again...

Meaning that when you do vote you can vote for as many as you like, if I let the voting be totally open I would expect some people who were very eager would vote several hundred times for one importer.

[Jerry]

XMB 1.9 Done.

[Jerry]

Version 1.17 released.

Auto email associate add to core system and vB3->vB3 importer.

[Joshua Clinard]

Since I can only vote once, and I didn't know you could vote for more than one option in the initial vote, I will register my additional votes here:

vB 2
YaBB
MiniBB
Yahoo Groups

[Jerry]

1.18 released.

Core = import_attachments.

IPB = import_attachments added. & auto email user associate.

Released, though as a beta though still testing so be aware :

Discuss (file system)
SMF
ThWBoard.

[Jerry]

1.19 released.

vB3 = import_attachments added.

+ Bug fixes.

[Jerry]

1.20.

Ikonboard (MySQL) attachments added.
vBB released.

[PitchouneN64ngc]

Jerry, will you develop import of smilies for YaBBSE? It's not in your development part of your thread about this importer :)

[Jerry]

Jerry, will you develop import of smilies for YaBBSE? It's not in your development part of your thread about this importer :)

Do you mean import custom smilies ? As the ones in the post text should be parsed on import.

[PitchouneN64ngc]

I mean smilies with categories (the 'smilies' table of YaBB SE) :)

[Jerry]

I mean smilies with categories (the 'smilies' table of YaBB SE) :)

Is that a standard ? What version are you using ?

If you mean SMF, its done for that importer.

[Shadow Duelist]

Anyways, How about the IPB converter? It's at it's RC stage.. :/

[Jerry]

Anyways, How about the IPB converter? It's at it's RC stage.. :/

Not too sure what you mean, the IPB 1.3 importer has been out for a while.

[Shadow Duelist]

IPB 2.0.0, Jerry. (Jerry! Jerry!) LOL I just had to :P

[Jerry]

Off on holiday for a few weeks, will have a go at it when I get back.

[PitchouneN64ngc]

Is that a standard ? What version are you using ?

If you mean SMF, its done for that importer.
In a test of importation from YaBB SE 1.5.5 into vB3, i had a table named 'smilies' and didn't know it was not created by default with the YaBBSE installer :p

Sorry for my bad request...:o

[ServerSide]

Come on guys, i need the YaBB perl converter :(

[may]

vb3 => vb3:

Could someone say me if I need only the database for importing or also all the other files?

Thanks & regards,
may

[Floris]

Just the database.

[may]

Many thanks Floris :)

may

[krohnathlonman]

I have IPB2 data if you're interested in some testing, I really want to dump that POS system ASAP.

it's ckyforums.com

[ServerSide]

I'm getting quite desperate for this converter, if you need test data, thats not a problem.

I bought VB so I could get rid of Yabb please help :)

[Jerry]

I'm getting quite desperate for this converter, if you need test data, thats not a problem.

I bought VB so I could get rid of Yabb please help :)

Just finishing it off at the moment.

The focus of the importer dev is on bug fixing the current importers and ImpEx (missing functionality) before releasing anymore.

There are 23 in total now with the ones still in dev, and 2 unofficial ones I know about.

[Joshua Clinard]

Glad to see you back, Jerry. You were gone for about 5 weeks, so I was begenning to wonder if you were ever coming back. I am anxios for the vB 2 importer to be officially released, as I understand there are some bugs, and my client is not interested in upgrading until it's final.

[Jerry]

Glad to see you back, Jerry. You were gone for about 5 weeks, so I was begenning to wonder if you were ever coming back. I am anxios for the vB 2 importer to be officially released, as I understand there are some bugs, and my client is not interested in upgrading until it's final.

The upgrade scripts are released and separate from the importer.

The vB2->vB3 importer is for special cases.

[Joshua Clinard]

I am well aware of the differences between a import and an upgrade. But I think you need to give the customer what they want. Let them decide which route they want to take to use new software. There are some circumstances where an upgrade is just not possible. Such is the case with very large forums, with databases in the 50 gigabyte range.

[Jerry]

I am well aware of the differences between a import and an upgrade. But I think you need to give the customer what they want. Let them decide which route they want to take to use new software. There are some circumstances where an upgrade is just not possible. Such is the case with very large forums, with databases in the 50 gigabyte range.

Its a mute point seeing as both are avaiable anyway and have been for a while. As far as I'm aware there arn't any vB2 bugs, not that are reported in the bug tracker anyway.

And seeing as that is the case, I've added vB2 to the offical importers status thread.

[Jerry]

1.22 released.

YaBB - Gold. Released, though still being tested.

vB2. No reported bugs atm, released.

[Joshua Clinard]

There were a few people that had problems with the importer in the importer discussion forum. Did those get sorted?

[Lenni]

I have IPB2 data if you're interested in some testing, I really want to dump that POS system ASAP.

it's ckyforums.com
i can offer you my database too for testing. even if it still alpha. [i dont care if private messages or attachments wont work.]
database currently has : 28.800 posts and 3890 members @ ~18 MB

[ServerSide]

Just converted a backup of my YaBB Gold forum to vb using the importer, everything comes in fine. The only problem i have is the Members do not show on the members list, thay are in the find all users in admin, just not in the Members list on the forum pages.

Any ideas :confused:

[PitchouneN64ngc]

Have you verified usergroups after the importation and their permissions?

When I was tested an importation of YaBB SE, I has this thing too and it was because the members was imported into a new usergroup and they was not visible in the members list.

[Jerry]

i can offer you my database too for testing. even if it still alpha. [i dont care if private messages or attachments wont work.]
database currently has : 28.800 posts and 3890 members @ ~18 MB

Well I do, attachments and PM's must work.

If you have a dB and attachments, PM me.

[ServerSide]

Have you verified usergroups after the importation and their permissions?

When I was tested an importation of YaBB SE, I has this thing too and it was because the members was imported into a new usergroup and they was not visible in the members list.

Yeah, bit blonde of me really :(

Tis sorted now, thanks for your help

[Lenni]

jerry, i sent you a pm. :) hope you read it. :)

[Jerry]

jerry, i sent you a pm. :) hope you read it. :)

I get a fair few, I try to wade thought them !

[FindSP.com]

How about making 1 for blabla4u.com

?

[Jerry]

How about making 1 for blabla4u.com

?

Looks like it would have to be a spider unless there is a way of exporting the data of the forum.

[Jerry]

Inital openBB released.

Ikon_mysql attachement and poll bugs fixed.

SMF moved out of testing.

[Jerry]

Discuss, moved out of testing.

Though its very version specific due to the HTML comment parsing.

[jeto]

What's about the www.parsimony.net (http://www.parsimony.net/) - Forums?

I've 4 Forums to migrate...

[Jerry]

What's about the www.parsimony.net (http://www.parsimony.net/) - Forums?

I've 4 Forums to migrate...

Could you provide source data to develop and importer from ?

Is it a MySQL backend?

[Jerry]

IPB 2 importer released

[Lenni]

when do you expect to release an updated ipb2.0 importer? [imports avatars as well as subforums]

[Jerry]

when do you expect to release an updated ipb2.0 importer? [imports avatars as well as subforums]

I've done sub forums.

I would expect avatars either end of today or tomorrow.

[Lenni]

thank you for your efforts. :)

[Jerry]

1.28

Mainly bug fixing.

Phorum 3 released.

IPB2 sub-forums.


thank you for your efforts. :)

Your welcome, will try and get that done today.

[Jerry]

rin - IPB2 custom avatars are done now and in the download.

[Jerry]

There have been a few importers released since my last post here and quite a lot of bugs fixed.

I am currently working on the discus_mysql importer at the moment.

The main outstanding areas of work at the moment are phpBB attachments as I have no test data or sites for that and a PNphpBB importer, though I have yet to find a default Post Nuke install board that I can base an importer on.

Apart from that with (soon to be) 32 importers the poll will soon be closed and import requests taken on a per customer basis, i.e. if you want one post in the importer forum or PM me.

[James Kojiro]

Can we also do ImpEx scripts? I have a few ideas.

[Jerry]

You can write modules, like I have fof phpBB2 and IPB2 etc, though you can't release modifyied source, i.e. change the ImpEx core.

I belive vb.org is probally the best place for that discussion and releases etc.

[GetGamer.com]

My vote is for Snitz Forums (http://forum.snitz.com/).

[Jerry]

My vote is for Snitz Forums (http://forum.snitz.com/).

I've done the MySQL version :

http://www.vbulletin.com/forum/showthread.php?t=102412

Are you after an importer for a diffrent back end ?

[Spleasure]

I'm asked to convert a ASP/MS SQL site into PHP/MySQL, and so I have to convert their ASP Playground (http://www.aspplayground.net) forum as well. If it's possible to make an importer for MS SQL, then I would surely recommend vBulletin to the owners of that site.

[Jerry]

I'm asked to convert a ASP/MS SQL site into PHP/MySQL, and so I have to convert their ASP Playground (http://www.aspplayground.net) forum as well. If it's possible to make an importer for MS SQL, then I would surely recommend vBulletin to the owners of that site.

Its been done :

http://www.vbulletin.com/forum/showthread.php?p=657602

[Spleasure]

Its been done :

http://www.vbulletin.com/forum/showthread.php?p=657602

Sorry, forgot to search for ASPPlayground, searched for ASP Playground .... thanks anyway

[GetGamer.com]

I've done the MySQL version :

http://www.vbulletin.com/forum/showthread.php?t=102412

Are you after an importer for a diffrent back end ?
Yes, I'm converting from Snitz with a MS SQL database to vBulletin with MySQL.

[StuartW]

Please add WowBB to your poll. There are more of us out here than you think!

[Jerry]

Please add WowBB to your poll. There are more of us out here than you think!

If you have a source database please PM me about getting this done.

[dndog]

I don't use this bulletin board software, but you might as well add it to the list Jerry.

http://www.bbv2.com/

-dndog

[Bill Thebert]

What's the latest on WebBBS?

Nearly a year ago I sent in several thousand WebBBS messages as test data. Plus a functioning WebBBS-->VB3 script (limited, but basic functionality).

I'm surprised to now see a request for test data in the poll.

If I provide it again, will it help to bump WebBBS up the priority list?

[Jerry]

What's the latest on WebBBS?

Nearly a year ago I sent in several thousand WebBBS messages as test data. Plus a functioning WebBBS-->VB3 script (limited, but basic functionality).

I'm surprised to now see a request for test data in the poll.

If I provide it again, will it help to bump WebBBS up the priority list?

A year ago ? vB3 was only released in march.

Though if you PM me the details I can look at it.

[Bill Thebert]

A year ago ? vB3 was only released in march.

Though if you PM me the details I can look at it.

Yep. I rounded it off. 10-11 months = nearly a year.

I've long ago mislaid the support ticket number that started our correspondence, Jerry. But you & I exchanged numerous e-mails on this subject.

I forwarded a WebBBS->vB3 script . . . one that started out as webBBS->vB2.X, but which had been hacked by user "tmorris" to perform some basic vB3 functionality. For example, it included support for "threading" (maintaining the parent/child relationship between posts & replies), but it didn't import any USER data. All posts were imported as those of a "Guest User".

The results of a test run of this script can be seen here:

http://www.binderbulletin.org/forums/forumdisplay.php?f=58

I also forwarded some sample data. Most of which I still have -- still unimported.

One unresolved riddle, as I recall, concerned older versions of webBBS which stored dates in a text fashion; whereas newer versions stored UNIX-style dates. Others were relatively trivial -- like importing quotation marks (stored as " ) properly.

What other details would you like me to send? I'm willing to send/share anything that would help this along.

Best,

Bill

[Jerry]

I've long ago mislaid the support ticket number that started our correspondence, Jerry. But you & I exchanged numerous e-mails on this subject.

As have I, I had a quick look as the system name seemed familiar though my memory was found wanting.

I do apologize, I must of over looked this one.


I forwarded a WebBBS->vB3 script . . . one that started out as webBBS->vB2.X, but which had been hacked by user "tmorris" to perform some basic vB3 functionality. For example, it included support for "threading" (maintaining the parent/child relationship between posts & replies), but it didn't import any USER data. All posts were imported as those of a "Guest User".

The results of a test run of this script can be seen here:

http://www.binderbulletin.org/forums/forumdisplay.php?f=58

I also forwarded some sample data. Most of which I still have -- still unimported.

One unresolved riddle, as I recall, concerned older versions of webBBS which stored dates in a text fashion; whereas newer versions stored UNIX-style dates. Others were relatively trivial -- like importing quotation marks (stored as " ) properly.

What other details would you like me to send? I'm willing to send/share anything that would help this along.

Best,

Bill

I dare say with the time that has passed and my lack of recall on the matter it would be best to start a new ticket and re start the process, so that I can look at it a fresh.

The only thing I can think is other importers took priority on shear numbers of requests and that in the normal course of house keeping I deleted the data by mistake, as unless I have permission, I don't keep user data once an import has been written.

Also with the improvments in impex over the last year I would expect that the user Guest status can be soved also.

[Jerry]

I don't use this bulletin board software, but you might as well add it to the list Jerry.

http://www.bbv2.com/

-dndog

Yup, its already done, #34 in the import done list.

[x-man01]

ok i have a site running phpnuke7.5 and id like to import my users + posts into vbulletin 3.0.5 . this is an urgent request.

please if anyone knows anything about how to go about this please share your wisdom.

i have the latest impEx on this board.
thnx

[Jerry]

ok i have a site running phpnuke7.5 and id like to import my users + posts into vbulletin 3.0.5 . this is an urgent request.

please if anyone knows anything about how to go about this please share your wisdom.

i have the latest impEx on this board.
thnx

If its a default phpnuke install PM me and if you can give me a copy of the database I'll be able to do the importer, its just finding a default install that is the difficult bit for me.

[ManagerJosh]

Just a more strategic sales strategy...

Perhaps providing a bridge(importer) between the old vBLite/vB1.x users to vB3? :)

[PitchouneN64ngc]

Jerry, "Xoops - NewBB" importer is compatible with NewBB2 for importing?

[Jerry]

Just a more strategic sales strategy...

Perhaps providing a bridge(importer) between the old vBLite/vB1.x users to vB3? :)

Spooky got asked for that one at the end of last week, all done now.

[Jerry]

Jerry, "Xoops - NewBB" importer is compatible with NewBB2 for importing?

Yes.

[ManagerJosh]

LDUForum? (http://www.neocrome.net/list.php?c=file)

[Jerry]

LDUForum? (http://www.neocrome.net/list.php?c=file)

Looks good, would just need some source data.

[ManagerJosh]

Possible Importer Update?
Eve 4.0.3

http://community.infopop.net/eve/ubb.x/a/tpc/f/62810671463/m/2601005/r/2601005

[Jerry]

Possible Importer Update?
Eve 4.0.3

http://community.infopop.net/eve/ubb.x/a/tpc/f/62810671463/m/2601005/r/2601005

Yup, it's been fun keeping on top of it to date (schema changes etc), though this is a fairly major one I think.

As always if there is a system or a change to an existing one to be done to keep the importers up to date and to give people options, I'm sure it will happen ;)

[ManagerJosh]

You got a willing Guinea Pig over in this thread..
http://www.vbulletin.com/forum/showthread.php?p=822291#post822291

[dailydose]

How long will you need to add import for DCForum Version 6.12 (flatfile database). We can supply demo database.
All the best
Juergen / DAILYDOSE

[Jerry]

How long will you need to add import for DCForum Version 6.12 (flatfile database). We can supply demo database.
All the best
Juergen / DAILYDOSE

It will depend on how many votes it gets on the poll, i.e. once the demand is high enough.

Is there a conversion to the MySQL back end ?

[dailydose]

Is there a conversion to the MySQL back end ?
I'll ask the dc-forum support for a conversion (flatfile > mysql). if this exists, we could use the importer system i think...
all the best
juergen

[Jerry]

I'll ask the dc-forum support for a conversion (flatfile > mysql). if this exists, we could use the importer system i think...
all the best
juergen

That is going to be the fastest way I belive, I know that the tool exsists, then once that is done us the dB based importer.

[jugo]

I think that there is a tru need for a comprehensive PHP-Nuke Import script. And yes, I know there is a phpBB script but one for the complete conversion of the PHP Nuke implementation would be more useful as many MANY Nukers are coming to the realization that vB just Rocks alot more than PHP-Nuke.

:D

[Jerry]

There is a PNphpBB2 (Post nuke) importer, its basically the phpBB one with the slight changes.

[subnet_rx]

I'd like to add SMF to the list.

[Steve Machol]

I'd like to add SMF to the list.
There is already one for SMF:

http://www.vbulletin.com/forum/showpost.php?p=728082&postcount=21