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!

[Oblivion Knight]

Originally Posted by FleaBag

Yep on a live board, I've always had the luck of the Irish before lol. So am I screwed?

Never, ever use a beta hack on your live board without testing it first..
It's very likely that any hack released in a beta state will be changed at least once before released as "final".


You're not completely screwed, but you're making life difficult for yourself.. Remove the database tables journal_comments, journal_entries, journal_moods, journal_settings and journals. Once you've done that, remove the "b" from the database tables bjournal, bjournal_comments and bjournal_entry. If bjournal_commentcount exists, remove it.


You may need to run these queries too..
[sql]ALTER TABLE user DROP canhavejournal[/sql][sql]ALTER TABLE usergroup DROP journalpermissions[/sql][sql]ALTER TABLE session DROP injournal[/sql]After that, you should be able to run the import script once again. You may want to wait for the next version though.. I'll have it done within the next hour or so.

[FleaBag]

Thanks a lot for your support, especially considering I went ahead and did something blatantly dumb that I know I shouldn't have. The problem I have is that my vB database is 400 meg, it's a bit of a bugger to back up as regularly as I'd like to - my host keeps backups on my behalf but his response time is 1-3 weeks. But I will learn from my mistakes! I'll get onto undoing my actions as per your advice and will wait for the new release.

Looking forward to getting your journal running!

[Oblivion Knight]

Originally Posted by tmhall

Under Control Panel Stop Messages:

journal_mood_deleted_successfully --> Mood deleted successfully.
journal_mood_updated_successfully --> Mood updated successfully.
journal_inserted_mood_successfully --> Inserted {1} successfully.

journal_inserted_mood_successfully already exists, but the others have been added in v0.31 of the importer..

Originally Posted by FleaBag

Thanks a lot for your support, especially considering I went ahead and did something blatantly dumb that I know I shouldn't have. The problem I have is that my vB database is 400 meg, it's a bit of a bugger to back up as regularly as I'd like to - my host keeps backups on my behalf but his response time is 1-3 weeks. But I will learn from my mistakes! I'll get onto undoing my actions as per your adive and will wait for the new release.

Looking forward to getting your journal running!

Don't worry about it, everyone has different circumstances..
However, before using any script that automatically runs queries on your live database I would recommend backing up beforehand and/or testing it on a seperate test board.

vBJournal isn't my Journal script, but hopefully I will be working with AN-net at some point on the project.

v0.31 of Jim Port is now released..

[FleaBag]

Aha sorry a little confusion on my part there. That's all those brain cells dying from substance abuse lol. It actually just occured to me that I can just make a dump of those tables as a backup... Silly me. Will fire it up in a moment!

[FleaBag]

Success! I had to edit the jimport a little to remove certain steps but it all worked like a dream from thereon in! I've now got the journal script up and running 100% with all of my existing entries. Thanks a whole lot Oblivion_Knight.

[Oblivion Knight]

No problem, and for future reference there's no "_" in my name..

[FleaBag]

Oops... What am I like lol.

[zetetic]

I can't remember if I created this myself or if it was part of RyAngel's hack, but I had a phrase called viewing_journals --> Viewing Journals and matching entries in functions_online so Who's Online would be accurate when people were in journals. That phrase seems to have been removed by the importer.

[Oblivion Knight]

Originally Posted by tmhall

I can't remember if I created this myself or if it was part of RyAngel's hack, but I had a phrase called viewing_journals --> Viewing Journals and matching entries in functions_online so Who's Online would be accurate when people were in journals. That phrase seems to have been removed by the importer.

Yup, the importer removes any phrases that contain the words "journal" or "jbuddy".

I'm afraid you'll have to re-add these (they sound like custom ones to me).

[zetetic]

No worries, already taken care of. Thanks.