Ryangel's vB3 Journal -> vBJournal 1.0.0 Importer

Introducing.. Jim Port!


[high]Who is Jim Port?[/high]
Jim Port is the name that I gave to the import script..
Journal Import -> admincp/jimport.php -> Jim Port


[high]What can Jim Port do for me?[/high]
He will automatically do the following:

• Backup Ryangel's Journal database tables
• Revert database changes made by Ryangel's Journal
• Remove Ryangel's Journal templates
• Remove Ryangel's Journal phrases
• Install vBJournal database tables
• Alter database tables for vBJournal compatability
• Transfer data from Ryangel's Journal to vBJournal
• Install vBJournal phrases
• Install vBJournal templates

[high]Are there any known issues to using Jim Port?[/high]
Obviously, the database tables aren't 100% compatible with each other.. Jim Port cannot identify which of the journal entries is the journal's latest, and therefore no data is inserted in to the latest entry title or date fields. This was a worthy sacrifice as the majority of users will update their journals on a common basis anyway, and once a new entry is posted the latest entries will continue to function as intended.

Jim Port currently cannot strip the slashes from entry or comment titles and text. As such, journal.php must be modified slightly in order to display these correctly and the edits have been documented in the readme. These edits will not have any side-effects on any new comments or entries made beyond this point.

Also, during the beta testing phase it was reported that any deleted journals (ie. if a user had deleted all of their entries) would still show up as empty, but the comments from these deleted entries would continue to be displayed in the Recent Comments section of the journal. There is no easy fix for this other than manual deletion..


[high]What versions of Ryangel's Journal is Jim Port compatible with?[/high]
To cut a long story short, I don't know 100%. However, as long as you are running a ported vB3 version of Ryangel's Journal and not the original vB2 version, then this should work as it was intended.. I tested it on version 1.1d and at least one of the beta testers tried it on version 1.2 and both appeared to import flawlessly.


[high]What versions of vBulletin is Jim Port compatible with?[/high]
It should work on ANY version of 3.0.0..


[high]Jim Port looks similar to the v3arcade Installer, are they twins?[/high]
Yup, the journal import script is heavily based on the v3arcade Installer by John. I've tried to get in touch with him on numerous occasions about making sure it was ok with him, but currently remain unsuccessful. Should he wish me to cease using it, the zip will be removed and I will attempt to try and write this in some other way.

I feel that I have learnt a lot from his work, and would like to thank him for this.


[high]Miscellaneous notes about Jim Port[/high]
Lines of code in admincp/jimport.php: 1816
Days to write: 4
Private beta testers: tmhall, DanielP (vb.nl)

The backed up Ryangel's Journal database tables *ARE NOT* removed automatically. This was intentional in case admins wanted something to fall back on should anything go wrong, and can be deleted manually if you are satisfied with the import process.


[high]I'd like to buy Jim Port a beer![/high]
Well, you can't buy him one as he's nothing but code, however, if you'd like to buy me a beer my Paypal address is [high]obk395@yahoo.co.uk[/high]. All donations will be drunk with thanks!

[Polo]

Thanks Oblivion Knight, I have seen alot of members ask for this.. Pretty sure they will be happy with this importer

[sabret00the]

Congratulations on the release, nice work

[Cloud-Warrior]

Great job OBK, just editing files now... Spotted this in the readme.txt:

$text= unhtmlspecialchars(stripslashes($text));
$entry['date']= vbdate($vboptions['dateformat'], $entry['entrydate'], 1);
$entry['time']= vbdate($vboptions['timeformat'], $entry['entrydate']);

It doesn't exist, so i guess it should be:

$text= parse_bbcode2($entry['entrytext'], 0, $setting['allow_imgcode'], $setting['allow_smilies'], $setting['allow_bbcode']);
$entry['date']= vbdate($vboptions['dateformat'], $entry['entrydate'], 1);
$entry['time']= vbdate($vboptions['timeformat'], $entry['entrydate']);

And:

Files to edit: (3) - profile.php, includes/functions.php,
includes/adminfunctions_template.php, journal.php (vBJ)

Remove the admin... one.

[Oblivion Knight]

Originally Posted by Cloud-Warrior

Great job OBK, just editing files now... Spotted this in the readme.txt:

$text= unhtmlspecialchars(stripslashes($text));
$entry['date']= vbdate($vboptions['dateformat'], $entry['entrydate'], 1);
$entry['time']= vbdate($vboptions['timeformat'], $entry['entrydate']);

It doesn't exist, so i guess it should be:

$text= parse_bbcode2($entry['entrytext'], 0, $setting['allow_imgcode'], $setting['allow_smilies'], $setting['allow_bbcode']);
$entry['date']= vbdate($vboptions['dateformat'], $entry['entrydate'], 1);
$entry['time']= vbdate($vboptions['timeformat'], $entry['entrydate']);

It should exist, as you're adding the top line of that code as an earlier edit..

I realise that these edits aren't in the correct order, but I was documenting them as I edited the necessary code.

Originally Posted by Cloud-Warrior

Files to edit: (3) - profile.php, includes/functions.php,
includes/adminfunctions_template.php, journal.php (vBJ)

Remove the admin... one.

Thanks, that edit was removed from the RC2 private beta for this release as it wasn't necessary.

[FleaBag]

Hell yeah, you know I've been waiting for this one. My site's members are gonna be wetting themselves now I can install your script! Thanks a lot, I really mean that!

[FleaBag]

OK here we go, heh. Any idea what this means mate? As I certainly don't...

Database error in vBulletin 3.0.5:

Invalid SQL:
UPDATE journals, bjournal_commentcount
SET journals.commentcount = bjournal_commentcount.count
WHERE journals.journal_id = bjournal_commentcount.journal_id

mysql error: You have an error in your SQL syntax near ' bjournal_commentcount
SET journals.commentcount = bjournal_commentcount.coun' at line 2

mysql error number: 1064

Date: Tuesday 29th of March 2005 04:01:03 PM
Script: http://dragonninja.co.uk/admin/jimport.php
Referer: http://dragonninja.co.uk/admin/jimport.php

[Oblivion Knight]

Are you using a table prefix? What is your MySQL version?

[Cloud-Warrior]

Originally Posted by Oblivion Knight

It should exist, as you're adding the top line of that code as an earlier edit..

I realise that these edits aren't in the correct order, but I was documenting them as I edited the necessary code.


Thanks, that edit was removed from the RC2 private beta for this release as it wasn't necessary.

Nice one - my mistake - I was looking for order

I'm having problems with step seven of the script, due to the huge tables I have... I've had to change the first two SELECT queries to:

SELECT u.username, u.ipaddress, j.journal_id FROM user as u left join journals as j on u.userid=j.journalist_id WHERE j.journal_id<>"";

SELECT u.username, u.ipaddress, c.comment_id FROM user as u left join journal_comments AS c ON u.userid = c.commenter_id WHERE c.comment_id <> "";

Otherwise they run for way too long and the script times out.

[Oblivion Knight]

Originally Posted by Cloud-Warrior

I'm having problems with step seven of the script, due to the huge tables I have... I've had to change the first two SELECT queries to:

SELECT u.username, u.ipaddress, j.journal_id FROM user as u left join journals as j on u.userid=j.journalist_id WHERE j.journal_id<>"";

SELECT u.username, u.ipaddress, c.comment_id FROM user as u left join journal_comments AS c ON u.userid = c.commenter_id WHERE c.comment_id <> "";

Otherwise they run for way too long and the script times out.

Aha, the script hasn't been tested on a huge forum before, so thanks for the feedback. I'll update them shortly..

Other than that, did everything work ok for you?