Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 23 Jan 2015, 00:57
final kaoss final kaoss is offline
 
Join Date: Apr 2006
Impex is Open Source now

I just now saw that, I don't remember getting a email or anything about it, so it's news to me. So I figured it's probably news to many people here too.

Source: http://www.vbulletin.com/forum/forum...ual-file-fixes

Impex has been released as an open source project. The official open source release is here: https://github.com/internetbrands/vbimpex

However a more updated version (with updates by VB Support member Zachery) is available here: https://github.com/vBZachery/vbimpex

Impex is no longer available in the Members Area.

The Impex Manual is here: http://www.vbulletin.com/docs/html/i...rsion=40202603

Please be aware this version of Impex does not work natively with VB5. In order to import into VB5 you must first import into VB4 and then upgrade to VB5.


The existing Impex software is old, there are some file edits you should do before you begin your import to reduce the chance of errors.

Note- If you use the Impex maintained by Zachery above these fixes have already been made.


Caution: Windows users should not use notepad to edit these files. Instead download a true code editor like Notepad2 or Notepad++. (Both are free and easily found with Google.)
The first edit is simple- open the index.php file in the /impex/ directory.

On or about line 271 fine the code: Code:

) TYPE=MyISAM";
Change the word TYPE to ENGINE, so... Code:

) ENGINE=MyISAM";
And save changes. This is required because the word TYPE is depreciated in newer versions of MySQL and will produce a database error if used.
Edit #2 is in the file ImpExDatabaseCore.php also in the /impex/ directory.

On or about line 1857 fine the code: Code:

'" . $caption . "',
and change it to: Code:

'" . addslashes($caption) . "',
And save changes. This is required to fix a bug in the code- if any attachment contains a single-quote ' character you would get a database error without this fix.
Edit #3 is only necessary if you are importing CMS data. In the ImpExDatabase_cms_001.php file in the /impex/ folder.

On or about line 848 fine the code: Code:

'" . addslashes($this->get_value('nonmandatory', 'workflowstatus')) . "',
and change it to: Code:

'$vbenumval',
Then several lines up (around line 832) you will fine the code: Code:

// MySQL database case 'mysql': { $Db_object->query("
Now, directly above the $Db_object->query... line add some blank lines and paste in the code: Code:

$vbenumval = addslashes($this->get_value('nonmandatory', 'workflowstatus')); if (empty($vbenumval)) { $vbenumval = "NULL"; }
So your final code will look like: Code:

// MySQL database case 'mysql': { $vbenumval = addslashes($this->get_value('nonmandatory', 'workflowstatus')); if (empty($vbenumval)) { $vbenumval = "NULL"; } $Db_object->query("
And save changes. This is because the word NULL must be explicitly stated if the value in question is blank, empty or zero.
Last Update: January 1, 2015
Reply With Quote
  #2  
Old 23 Jan 2015, 00:59
HM666's Avatar
HM666 HM666 is offline
 
Join Date: Jan 2014
Real name: Len Kaiser
Well that is interesting. I guess they wanted to keep that under their hat a little bit instead of telling paying customers about this new development.
Reply With Quote
  #3  
Old 23 Jan 2015, 01:41
Mark.B Mark.B is offline
 
Join Date: Feb 2004
Nobody wanted to keep anything "under their hat".

There wouldn't be much point emailing existing customers about ImpEx. ImpEx is designed for new customers.
__________________
MARK.B (Member of the vB Support Team)
Reply With Quote
  #4  
Old 23 Jan 2015, 01:48
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
All of the community sourced fixes are in the impex from ib, i'm going to continue working on fixing stuff, or at least making it work well enough for the time being.

I'm going to do my best to maintain it long term. There is already a beta build which is disabling strict notices.
__________________
Looking for ImpEx?
Reply With Quote
  #5  
Old 23 Jan 2015, 14:03
HM666's Avatar
HM666 HM666 is offline
 
Join Date: Jan 2014
Real name: Len Kaiser
Originally Posted by Mark.B View Post
Nobody wanted to keep anything "under their hat".

There wouldn't be much point emailing existing customers about ImpEx. ImpEx is designed for new customers.
Actually its not only new customers that use ImPex. Old customers use it as well if they have more than one license or move/change sites, downgrade their copy of vBulletin, or they have another site that is on another platform and want to migrate it into vBulletin after they purchase a second license, so yeah older customers use it too.
Reply With Quote
  #6  
Old 23 Jan 2015, 15:00
Digital Jedi's Avatar
Digital Jedi Digital Jedi is offline
 
Join Date: Oct 2006
Real name: Mark Daniel Martinez
Does that mean we'll be getting an Impex forum in the Open Source section?
__________________
Reply With Quote
  #7  
Old 23 Jan 2015, 17:30
Brandon Sheley's Avatar
Brandon Sheley Brandon Sheley is offline
 
Join Date: Mar 2005
Real name: Brandon
lol.. only for new customers

nice
__________________

Email me for website help: brandon[at]sheley[dot]org
Reply With Quote
  #8  
Old 23 Jan 2015, 17:47
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
Originally Posted by Digital Jedi View Post
Does that mean we'll be getting an Impex forum in the Open Source section?
I don't really see the need for it, myself.
__________________
Looking for ImpEx?
Reply With Quote
  #9  
Old 23 Jan 2015, 17:52
Mark.B Mark.B is offline
 
Join Date: Feb 2004
Originally Posted by HM666 View Post
Actually its not only new customers that use ImPex. Old customers use it as well if they have more than one license or move/change sites, downgrade their copy of vBulletin, or they have another site that is on another platform and want to migrate it into vBulletin after they purchase a second license, so yeah older customers use it too.
It's primary purpose has always been to allow customers on other software to migrate to vBulletin. It allowed us to facilitate sales of the software to people who already had established forums but wanted to migrate them without starting from scratch.

The number of existing customers who would make use of it is absolutely tiny. The vast majority of customers would not have a clue what it was. Accordingly, we would not waste time sending out an email announcing the open sourcing of something few recipients will have heard of. All that does is annoy customers who would consider it some form of marketing spam.

Of course, I would expect the usual suspects to try and pull negatives out of this move. Perhaps it would have been better to simply remove it from the site and throw it in the bin.
__________________
MARK.B (Member of the vB Support Team)
Reply With Quote
  #10  
Old 23 Jan 2015, 18:42
Brandon Sheley's Avatar
Brandon Sheley Brandon Sheley is offline
 
Join Date: Mar 2005
Real name: Brandon
Why would vbulletin email users to let them know about this, there is no way for vbulletin to make money off it.

End of the story.
__________________

Email me for website help: brandon[at]sheley[dot]org
Reply With Quote
  #11  
Old 23 Jan 2015, 19:05
final kaoss final kaoss is offline
 
Join Date: Apr 2006
Originally Posted by Brandon Sheley View Post
Why would vbulletin email users to let them know about this, there is no way for vbulletin to make money off it.

End of the story.
Yep doesn't matter if current customers care about it or not, if they can't make money from it, then to hell with telling people about it apparently.
Reply With Quote
  #12  
Old 23 Jan 2015, 19:16
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
To be fair, we didn't have to open source the software.
__________________
Looking for ImpEx?
Reply With Quote
  #13  
Old 23 Jan 2015, 19:19
final kaoss final kaoss is offline
 
Join Date: Apr 2006
That's true but it's also not the main point of the discussion so far either. I probably would've been interested in it had I been emailed about it or notified about it via announcement on .com or .org.
Reply With Quote
  #14  
Old 23 Jan 2015, 19:22
Brandon Sheley's Avatar
Brandon Sheley Brandon Sheley is offline
 
Join Date: Mar 2005
Real name: Brandon
Originally Posted by Zachery View Post
To be fair, we didn't have to open source the software.
We appreciate that the bugs have been fixed. To me it didn't matter if it was open source or at the vb.com.

In my opinion it's been the best thing about vbulletin for years.
__________________

Email me for website help: brandon[at]sheley[dot]org
Reply With Quote
  #15  
Old 23 Jan 2015, 20:15
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
I'm not really a developer, so anything going forward will probably be slow on my end.

I intend to merge/test any pull requests and get them applied.
If people log issues in my repo, I'll do my best to help work though them, or hopefully get community help.

I'm going to do my best to maintain the project on myend anyway. I've reached out to Andreas to see if he is okay with me including his xenForo importer in the package. I believe I've also applied a workaround to fixing an issue with his code. I just can't publish it yet without permission from him. Since its not marked as re-useable code, and there is no included license otherwise.
__________________
Looking for ImpEx?
Reply With Quote
Reply



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


New To Site? Need Help?

All times are GMT. The time now is 16:26.

Layout Options | Width: Wide Color: