This page is a quick description of how to use data from a Jomres SA installation and import it into a Joomla installation. It's important to be aware that the following steps haven't been tested, instead they are how I would go about doing the export.

 

If in doubt, it's better that you don't attempt to export from one system to another and instead you recreate the data anew. That said, if I were to try to copy the data from SA to Joomla, the following steps would be what I'd perform. They may or may not work for you.

 

In your old standalone database there are a number of tables. Some of these tables are for Standalone and cannot be used in Joomla. Some of the tables are for Jomres and can be used in both Joomla and Standalone. You want to extract _only_ the tables that are used by Jomres. These are typically xxx_jomres_yyy, xxx_jrportal_yyy and xxx_jomcomp_yyy. (xxx can be jos, jomres or some other prefix, so for example one table will be named "jomres_jomres_custom_text" when coming from standalone).

 

If your Joomla prefix is "jos", then you'll need to rename your standalone tables from, for example, jomres_jomres_managers to jos_jomres_managers. This is easiest to do by exporting the standalone data via phpmyadmin as a .sql file then editing that file via notepad or some other text editor.

 

At the same time, from that file remove any references to jomres_users, jomres_sessions and jomres_users_profiles tables, you don't want to import them. Those tables are for Jomres SA only.

 

Next, you'll need to remove any inserts that import data to the jos_jomres_managers and jos_jomres_managers_propertys_xref as Jomres will not be able to use this. Instead, you'll need to recreate those users in Joomla and use the Jomres Show Profiles feature to re-associate the new Joomla users with the properties.

 

At this point, you should be ready to import the edited .sql file into your Joomla database via phpmyadmin.

 

Good luck and have fun.