Project Tools Importer for forum threads
 

Beta warning

This is currently in beta stadium. I used it successfully on my forum, but there might be problems with other configurations. See below for current limitations and features not yet implemented.

Note for german speaking users: There will be a german version released and supported on vB GO once this mod reaches Release Candidate stage.


What's this mod for?

I needed a simple to use function to move my forum threads into the vBulletin Project Tools. This Add-on adds a new moderation link to the showthread page that allows you to import the thread into any project and issue type you are allowed to post in.

The source thread can either be left untouched or automatically be converted into a redirector that leads to the created issue. No data in the original thread will be lost, an easy restore function will be implemented in the future. Redirectors can show a prefix (like "Moved:" for thread redirectors) that can display the project title and the issue type.


What's new in Beta 3?

Code rewrite

This is a major rewrite of the whole codebase. The code has been optimized and redundant code has been moved to functions and classes. Please note that this means almost everything is new and this likely means there are new bugs in places that worked before. Use at your own risk!

Attachment import

The most requested functions has been added: You can now import attachments if vBulletin or Project Tools (or both, of course) store attachments in the file system. There's a new setting in the AdminCP where you can specify if attachments that do not meet the current limitations should be imported.

I was only able to test this on Windows based systems, but it should work on *NIX as well.

Other changes

A function has been implemented to allow the creation of a notice stating the issue has been imported (by which user at which date). It's enabled by default, but you can disable it in the AdminCP. See also the new screenshot attached.

There have been other minor changes, see the changelog below.


Functions implemented

• Import of threads (Issue)
• Import of posts (Notices)
• Import of attachments (Filesystem is now supported, too!)
• Import of subscriptions
• Create redirector (optional)
• Create a notice stating this note was imported (optional)

Current limitations

These limitations result on the fact that I created this Add-on mainly for myself and so I left out some features not important to me. They are planned to be fixed in Version 1.0.0.

• Currently you need the moderator permissions canmanagethreads and canremoveposts to import threads. Should be replaced by a new moderator permission (can convert all threads in a forum) and a new usergroup permission (can convert own threads).
• [s]Attachments will only be imported if both vBulletin and Project Tools are configured to save attachments in the database. Attachment limits will be ignored.[/s]

Functions planned

This functions will probably be added to a version after 1.0.0. Please post suggestions and comments so I can see where to go :)

• Allow to hide redirectors based on a global setting or on usergroup permissions
• Allow to completely delete the source during thread after import
• Allow to manually delete redirecting threads (imported x days before) using the AdminCP / ModCP
• Allow to automatically delete redirecting threads using vBCron
• Allow to associate status changes with posts during import (ex: change status to "Solved" at the same time a it has been posted)
• Mass import of multiple threads
• Export issues (back) into threads

Requirements

• vBulletin 3.6.7
• vBulletin Project Tools 1.0.0

Installation

These are some fast installation steps. There is a file ptimporter_install.txt in the zip file with more detailed instructions.

• Upload everything in the "upload" directory into your vbulletin home directory
• import the product file ./includes/xml/product-db_ptimporter.xml
  Note: select "Allow Overwrite" if upgrading
• Apply the two small template changes in ptimporter_templates.txt
  Note: Not needed if upgrading from Beta 2

Done. :)

Changelog

Version 1.0.0 Beta 3

New:

• Rewritten attachment import to allow import of attachments in the filesystem
• Added option to create a notice stating this note was imported

Improved:

• Rewritten almost everything to move redundant code to functions and classes
• Added template group (Thanks Yves)
• Some changes in the background to allow new functions in the future

Fixed:

• Fixed bug not allowing to choose issue type
• Reduced the amount of queries executed using caching

Version 1.0.0 Beta 2

• First public release

shucks missed it :(

I'll check this later today but I think you saved my life with this ;)

This can help a lot of customers who want to convert some threads into issues for Project Tools ;)

Thanks for this ;)

Looks fantastic - will be a wonderful way to integrate vB and PT.
tks a lot
Beduino

What is 'project tools'?

http://www.vbulletin.com/features_project.php

For the beta test, I'm surprised this mod works very well ;)

Just missing to add templates into cache ($globaltemplates) and add 14 queries for that :/

Feature Request: By moving thread possibility to choose to create new issue (currently) or to create new task, or new feature.

Well, you should rename this to Bug Report... this would be possible if I hadn't forgotten a silly break; in the script I used for testing.

Just open ptimporter.php and remove the break; from Line 208.

Now you should be able to select the issue type if you have permission to create an issue in more than one...

Will also be fixed in the next beta, of course.

This will be very popular, something which vb should have made default. nice work.

I'm sorry, I missed this edit before...

As far as I see there is only one templates missing (optgroup) which adds one query for the add issue page. The others are in $globaltemplates and $actiontemplates. Am I missing something here?

I know there is potential for optimizations for using the datastore / $specialtemplates. But that part will be somewhat rewritten anyway.

The only thing I can suggest is to make a group for templates in hook template_groups ;)

Thanks for making this. It has come in quite handy for moving all the support threads.

Never mind. I missed something somehow.

Hy,

any news on this?

Hi Dominic,

I'm somewhat occupied with my job at the moment so I don't have too much time for this ;)

I rewrote most of the script (move redundant code to functions, optimize the usage of database queries and so on) but that's not yet completely finished. I also want to rewrite the attachment import so filesystem attachments will be imported correctly before publishing the next beta version.

Shouldn't take too long, but I don't want to give a concrete date for this - Jelsoft know why they don't :cool:.

Ok, thanks for your reply.

If you need someone for testing you know where to find me :)

Just want to bump this a little bit ;)

I didn't forget about it ;)

Here you are...

What a nice addon. Thanks for this.

I've found an issue but I'm not sure if it is a bug or working as designed. ;)
If I move a thread to a project, I can select self assign. Does this mean I, as the administrator but not thread startet, are going to be assigned to this issue or does this mean the thread starter is going to be assigned although he is not a staff member?

Hi,

it means you (the one importing the thread) are assigned. Usually "assigned" means you are the one handling the issue, and I assume often it's the person importing it so that's what the shortcut is for.

So, this is then a bug because I didn't get assigned to the issue. I've had to assign me in the issue details by hand.

I've found 2 other issues:

1. If you have a thread with replies by yourself and are subscribed to this thread, the subscription will stay if you move the thread to the project tools.
   Viewing all your subscriptions show a locked icon for the thread.
2. Similar situation as above: You've subscribed to a thread and there are new messages you didn't yet read. The thread got moved to the project tools.
   Now everytime you go to you UserCP, there is the notification about unread threads. Same goes for New Posts.

I think the subscription should be removed while moving the thread to the tools, because it is no longer a thread but a issue.

Hello? Is anyone alive?

Hi, for some reason I didn't get an email notification for your other posts so I missed them. Sorry about that.

Assigning

I'll look into this

Thread subscription

The threads are not actually deleted but just closed. That way a "undo" would be easy to implement. I'm not sure how to resolve that issue the best way, but let me think about it.

Thanks for the info. :)
Maybe it would solve the problem, if every subscription a user has with this thread would be deleted.
So the thread can be imported into a project and is closed to leave the ability of undoing the import is still usable.

hello gamecrash!

you already test this with vb 370rc3?
tks for all
beduino

Hi,

I didn't test it with vB 3.7 yet, but I don't think there will be a problem. If there is a problem let me know.

The next version released will officially support vB 3.7.

And why don't I get the "Instant email notification" I have enabled for this thread :confused:

thank you, works fine on 3.7.0 gold 8)

Anyone use this with vB 3.7 and Project Tools 2?

Seems to be working fine for vB 3.7.2 and PT 2.0 BETA

works fine with vb 3.7.3 and pt 2.0.0 :up:

works in 3.7.4pl1 with Tools 2.0.

It would be nice to have the ability to mass move into projects added.

Sadly can't install it.
This product is not compatible with version 2.0.0 of the product vbprojecttools. (Compatible starting with 1.0.0 / Incompatible with 1.1.0 and greater)

Think you can edit the xml and change something like "maxversion".
I only took a short look and will try it some other lonely night ... ;)

Willing to help pay for someone to upgrade this module and make some of the planned improvements. PM me with a quote and details about what the bid would include if you're interested.

Is an Update avaiable?

Is an Update avaiable for VB4 ?

Ditto