Knowledge Base - How to Import GF3 Maps to GF5

Import Tool - GF3 to GF5

What is it

Geocode Factory 5 comes with an import tool that is designed to import old maps and markersets from Geocode Factory 3.x. It does this by accessing your old Geocode Factory 3 database tables.

Introduction - Preparation

The old tables (from Geocode Factory 3) can be in the current database used for your current Joomla 3 installation or in another database. If they are in another database however, this database MUST be located on the same server as your current Joomla 3 installation. In other words, GF5 cannot access a remote server to import your tables.
An example of the remote server is when your GF3 and GF5 websites are hosted at different web hosting companies. Another example is when one of the two sites is on your personal computer's web server while the other is hosted elsewhere (ex: a hosting company).
If this is your case, you must export your tables from the remote server and import them somewhere inside the local server yourself before proceeding. 'Local' here simply means wherever your GF5 website is.

If this is NOT your case, please SKIP the next section 'Remote Server Manual Preparation' and go directly to "Ready to Import".

Remote Server Table Retrieval

The database tables you will need to manually import to your local server are the following:

xxx_geocode_factory_contents
xxx_geocode_factory_maps
xxx_geocode_factory_markersets
xxx_geocode_factory_parametres

Note: 'xxx' represents your table prefix and it will be different in your case, ex: 'jos'

a-) Exporting the tables from the 'remote server'
    1. Log into your database management tool. We will be using phpMyAdmin here.
    2. Select the database where the GF3 tables are located.
    3. Browse the list of database tables and select the above mentioned tables by checking each of their boxes like in the following image.

      export tables phpMyAdmin

    4. Once these are checked, scroll to the bottom of the page and select the "Export" option from the "With Selected" dropdown menu as seen in the following image.

      export selected phpMyAdmin

    5. Doing this will then lead you to the export page. Once there, simply click on the 'Go' button found at the bottom of this page. You will then have successfully exported the needed tables.
b-) Importing the tables to the local server
  1. Log into your database management tool of choice. We will be using phpMyAdmin here.
  2. Select the database that you want to import your old tables in. You may select the database where the GF5 tables are located (same database of your current Joomla 3 installation) if you choose, but this is optional*.
  3. Click on the import menu link at the top. On the export page, select the file you just exported before by browsing to your computer's location. Then simply click on Go on the bottom of that page.

    import page phpMyAdmin

  4. phpMyAdmin should show you a message "Import has been successfully finished, xx queries executed". You will then have successfully imported the needed tables.

Ready  to Import

When the old database tables are located in a database on the same server as your Geocode Factory 5 installation you are ready to go! You simply need to enter the correct database credentials in the Geocode Factory settings (Main Configuration - Import tab) before proceeding with the import.

Main Configuration - Import tab

You can access these settings by clicking on the "Component configuration" link from your GF5 Welcome Panel (the component's main page in your Joomla backend).

The “Import” tab in the main configuration looks like this:

Import Settings

The first option “Imported map/markerset prefix” is the extra prefix that will be applied to the old tables once they are imported into your current website’s database.This is just to be able to identify them properly when you're browsing your tables later on and you are wondering what ths table is.. :)

The rest of the options are pretty straightforward. They refer to the database where the old tables are to be found.

Creating a temporary readonly database user, and removing these credentials from the settings after importing is a good idea (optional).

Another good practice is to do a backup before import. We highly recommend this.

*Special note: For Advanced Users

If your GF3 database tables have the same table prefix as your current-target Joomla 3 installation tables do.

AND

If your GF3 database tables are located in the same database as your current-target Joomla 3 installation.

Then, and only in this case, you do not need to fill out the Main Configuration - Import tab credentials. Instead you can simply click on the “Import old” link (as seen in the next paragraph)

For Advanced Users

Time to Import!

When the correct database credentials are in place, go back to your Geocode Factory control panel (Welcome Panel) and click on the “Import old” link. 

Geocode Factory will then give you the list of maps and related marker sets available for import. You may select the ones you wish to import and then click on “Import the old maps, with the attached markersets” on the top left corner of your screen to proceed (see image below).

Import Tables

After Importing

Keep in mind that there is a significant difference between Geocode Factory 3 and Geocode Factory 5. The new version does not work in the same way as the old version. For example, the pattern concept  is a new development in the Geocode Factory 5 version only. . The database structure is very different as well, so some settings cannot be restored from the old tables.

Overall, the import tool will help you restore the same maps and markersets as the ones in your old configuration or installation, and it will save you a lot of time. But you need to check the integrity of each imported item.

The most basic thing to do after importing is to assign a pattern to your new markersets. You can access your imported markersets form your "Markerset Manager". Keep in mind you the type of pattern has to be compatible with the markerset data. For example, if the markerset refers to SobiPro data you will have to use a SobiPro pattern type. See the Main Documentation for more details.

 

Applies To

Geocode Factory 3, Geocode Factory 5