Pligg2Hotaru 0.2

[Nick]

Pligg2Hotaru
Version: 0.2
Author: Nick Ramsay
Created: 2010/08/16
Last Updated: 2010/08/19
Tested on: Hotaru 1.4.1
Plugins Required: None
Plug & Play: Yes, but needs some preparation (see instructions)
Supported: Yes

Description
Import a Pligg or SWCMS database into Hotaru CMS. Version 0.1 imports the following tables: Links, Comments, Users, Categories, Tags and Votes. It doesn't import favorites, messages, friend data or anything else. Please hire me if you have special requirements.

Difference to Pligg Importer
The Pligg Importer plugin used XML exports and tons of memory. It's also incompatible with the latest versions of phpMyAdmin and I've ended my support for it. Pligg2Hotaru uses SQL exports and works with batches of data to keep memory usage down. It is compatible with the most versions of phpMyAdmin.

Note
Depending on the size of your Pligg database, importing each file can take a long time. This isn't a straight import. Almost every aspect of your Pligg database is changed. For example, all users will get a new id number, so every table with a user_id field needs updating with this new id. The same goes for link ids, category ids etc.

Instructions
1. Make sure your Hotaru username and password match your old 'god' account from Pligg.

* If your Pligg username was 3 characters (e.g. "god" or "tom"), go to your Hotaru Account page and add "1" to your username (e.g. "god1" or "tom1").
* If your Pligg password is not at least 8 characters and only contains letters, numbers and these symbols: ! @ * # - _ then you will need to change your password in Pligg before using this plugin.
* After changing your Hotaru username or password, log out and then log back in again.

2. From phpMyAdmin (or similar) export your whole Pligg database as SQL, then import it into your Hotaru database (this will only work if your Pligg tables have a different prefix to Hotaru tables, e.g. "pligg_")
3. Upload the "pligg2hotaru" folder to your plugins folder.
4. Install it from Plugin Management in Admin.
5. Click Pligg2Hotaru in the Admin sidebar and follow the steps.

After importing...
When you've successfully imported your Pligg data into Hotaru and are satisfied it worked, you can delete all the old Pligg tables from the front page of the Pligg2Hotaru plugin. Some users won't be able to log in, so use the Admin Email plugin to inform them of these two points:

* If their username was 3 characters, they should add "1" to the end of it when they log in. After they have logged in, they can change their username again from their profile.
* Passwords in Hotaru must be at least 8 characters and can only contain letters, numbers and these symbols: ! @ * # - _ Any user with a password that fails will need to use the "Forgotten Password" form on the login page to get a new password.

Troubleshooting
Big databases usually require some workarounds to prevent timeouts, etc. Here are some tips:
* If you are coming from SWCMS, consider using the SWCMS DB Cleanup module before importing your site (not sure if it works for Pligg. It probably does.)
* Export the links, comments, users, categories, tags and votes tables individually from your Pligg database and import them into the Hotaru database one-by-one.
* Export your tables with compression, e.g. "zipped" or "gzipped".
* If you have access to php.ini, change "max_execution_time" to 3600 seconds (1 hour)
* If using phpMyAdmin, open config.inc.php and add or set $cfg['ExecTimeLimit'] = 3600;
* If you don't have access to php.ini, try adding the set_time_limit function to the foreach loops in the each file. Alternatively, try .htaccess.

Revision History
v.0.2 2010/08/18 - Nick - Fix for missing email values in Pligg
v.0.1 2010/08/16 - Nick - Released first version

Please click "Rate Thread" and give this plugin a rating. Thank you.

[carlo75]

A new challenge for trying to port my pligg in hotaru...
is it very exciting, and I'll try asap... stay tuned for the result

[carlo75]

Got an error. After 2 hrs of importing, at step 4 of 7, on Users, I receive this error:

Notice: Undefined property: stdClass::$valid_email in
C:\wamp\www\hotaru\content\plugins\pligg2hotaru\li bs\users.php on line 87

and

Notice: Undefined property: stdClass::$email_conf in
C:\wamp\www\hotaru\content\plugins\pligg2hotaru\li bs\users.php on line 88

...

[Nick]

Okay, Carlo. I see, those were added to SWCMS and aren't in Pligg.

Try this. Open, /pligg2hotaru/libs/users.php and change this:

                    //if not using SWCMS' email registration module, set to zero:
                    if (!$child->valid_email) { $child->valid_email = 0;}
                    if (!$child->email_conf) { $child->email_conf = 0; } 

to this:

                    //if not using SWCMS' email registration module, set to zero:
                    if (!isset($child->valid_email)) { $child->valid_email = 0;}
                    if (!isset($child->email_conf)) { $child->email_conf = 0; } 

Sorry it has taken so much of your time. If this change works for you, I will update the plugin with it.

[carlo75]

Perfect Nick, I restart the importing process, with your modification; and no problem for my time it can't be compared with the amount of days that you spend in this project!

[Nick]

Updated to version 0.2, fixing the issue reporter by Carlo.

[carlo75]

Little update:
Users step successfully passed
elaboration time until now: 4 hrs

[carlo75]

Finish, conversion complete.



Elaboration time: ~6Hrs
Pligg Links: ~ 80.000
Pligg Users: ~ 8.900
Pligg Comments: ~ 2.500
Pligg Vote: ~ 153.000
Pligg Tags: ~ 250.000

I've always some problem with character set, but this was only a test. From now I'll try to export pligg SQL in a charset that best fit my needs. Hower pligg2hotaru now works fine also for me.

[narc]

pligg2hotaru is the best thing that can happen to Pligg users. my local installation works wonderfully. now missing is a new template. adaptation of plugins. then you also have a lucky fan from Germany.

EDIT
but one is still missing. import the pictures from left Pligg to hotaru. image when I use the plugin by hotaru. that would be cream first.

many thanks nick.

[narc]

how can I remove the posts in <br/>. if more than three in succession are?

example:
pligg

lorem impsum lorem impsum lorem impsum<br>
<br>
lorem impsum lorem impsum lorem impsum<br>

import hotaru
hotaru

lorem impsum lorem impsum lorem impsum<br>
<br><br>
lorem impsum lorem impsum lorem impsum<br>