Impex is Open Source now

[final kaoss]

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