Import User-Data

Openfire Openfire Support
21

Finally I have successfully imported and exported using the plugin

I created a Perl-script for exporting into the JM-169 XML and if anyone would want to reuse you can find it here:

http://john.nu/files/jive-import_from_j2-mysql.pl

Feel free to use or change it!

I also made some changes to the plugin itself and these can be found here:

http://john.nu/files/userImportExportPlugin_mod.zip

I included diff to the version in Jive Software CVS and source. I also have some feedback for the (non-modded) plugin:

  1. JID in the plugin is imported without server-name, maybe it should? I cannot se the reason not to do it…

  2. If a users is imported but is already in the database, the users rooster is not imported, maybe it should be imported but omitting roster-items already in the database?

Thanks alot for all the help,

/John

22

Hi John,

Glad to hear you got everything to work.

  1. JID in the plugin is imported without server-name,

maybe it should? I cannot se the reason not to do

it…

The Jive roster table only stores the username, not the entire JID, that’'s why it was done that way.

  1. If a users is imported but is already in the

database, the users rooster is not imported, maybe it

should be imported but omitting roster-items

already in the database?

Yeah, I had wondered about that. A possible problem with that is there is no real way to be sure that the user in the new system is the same as the one that is being imported from the old system. I decided to play it safe and just not do the import, maybe that could be an option for a future version.

Thanks for the feedback, I really appreciate it.

Thanks again,

Ryan

23

I’'d like to have this Perl script if it exports from Jabber2 MySql to a file that will import into Jive Messenger 2.1.5. I clicked the link but got a password prompt. Is it possible to still get this script?

Thanks,

Russell