Import export


It is inconvenient to manually add a large number of business listings at once to a fresh installation of GoClixy. Inserting categories, locations, and listings one by one will take a long time especially when you have hundreds or thousands of such information. In such situations, you need a solution to automatically add all those listings to your Online Business Directory.

To view all the existing imports and their status, go to Settings->Import/Export->Importer

Click the file name under the File Name column to download.

To delete the existing imported file, select the file by marking the checkbox to the left of the Data Imported column and click the Delete button.

Note: For security reasons, it is the best practice to delete all existing imported files.

Importer Import

How to import bulk data?

To import bulk listings, login to the admin panel and go to Settings->Import/Export->Importer, fill the information as described below and click the Save button.

Import: Select import type

Categories: To import bulk categories
States: To import bulk states
Cities: To import bulk cities
File Type: Select file format

CSV: Tested with 2,00,000 rows, you can have more than that.
Excel 97-2003: Support up to 10,000 rows
Excel 2007: Support up to 10,000 rows
Transaction Type:

Insert Only: Insert new rows only
Insert and update: Insert new rows and update existing
Import File: Click the Browse button to upload the file.

Recommended: If you have a slow Internet connection and the size of your file is larger than 5MB, then upload the file on your Hosting Server and type its name in the Specify File Name textbox.
## NOTE: After purchase, download your license copy and you will find the sample import files and other useful instructions in the Documentation folder ##

Importer Import Process

The export option allows you to download the information from your existing website for backup and other purposes.

To download an existing exported file, click the file name under the File Name column.

To deleted exported data information, select the file by marking the checkbox to the left of the Data Exported column and click the Delete button.

Exporter Export All

How to export existing data?

To export bulk listings, login to the admin panel and go to Settings->Import/Export->Exporter, fill the information as described below and click the Save button.

Export: Select the export type

Listings: To export listings
Categories: To export categories
States: To export states
Cities: To export cities
File Type: Select file format

CSV: No limit but special permissions are required on your Hosting server.
Excel 97-2003: Support up to 10,000 rows
Excel 2007: Support up to 10,000 rows
Start ID: ID of the start row
End ID: ID of the end row
Compress File: Save and download file in ZIP format.
Exporter Export Data
How to Migrate Data from phpMyDirectory to GoClixy?
Install GoClixy on your Server by following our installation manual.
Go to Developer->Database->Maintenance and click the Remove Sample Data button.
Use FTP and open the application/config/database.php file in your text/code editor.
Copy the $db['default'] array and paste it to the end of the file.
Migrate DB
Note: The username and password must be same for both databases.
- Get your phpMyDirectory DB information from the defaults.php file on your server and make the changes as per the screenshot.
- Save and close the file.
- Use cPanel/FTP and copy the files folder from your existing PMD directory to public_html/assets/pmd/ folder.
- Login to the Admin Panel and visit the URL https://YOUR DOMAIN NAME/admin/settings/migrate/migrate.
- Fill the details:
- Country - Name of the country
- Website - Enter your existing website URL
- ID Limit - Number of records to be processed at a time
- ID From - ID of the starting row, leave 0 for default
- ID To - ID of the ending row, leave 20000 for default
- Click the Submit button.

Migrate Form

This will take time depending on the size of your database.
If you see a Timeout error, again fill the form and click the Submit button, it will start from the last saved configuration.
Do this until you see a success message.
After completion, edit the application/config/database.php file and remove the copied lines.
Also delete the pmd folder from the public_html/assets/ folder.
Go to Financial->Packages, edit all packages and set the Limit as per your requirements.
Go to Settings->Locations and activate your default country.
Go to Settings->Settings->Advanced tab and set the default city.
Login to the Admin Panel, go to Content->Listings->Tweak Fields and click the Submit button to tweak search fields.
Do this for all listings. Change the IDs and repeat the step.
Go to Content->Categories and click the Update Listings Count tab in the upper right corner.
Storing PMD Routes and Links (Developer Edition Customers only)
Replace the public function location method inside the application/modules/listings/controllers/Listings.php file with the code below:

public function location($slug, $city = null) {
$id = (int)substr( $slug, strrpos( $slug, '-' ) + 1);
$module = 'listings';
if(empty($id)) {
if(!empty($city)) {
$city = escape($city);
$location = $this->db->where('slug', $city)->get('cities')->row();
if($location) {
$slug = $location->slug . '-' . $location->id;
$this->listings_model->category_location_tag_search(false, 'listings', 'cities', $this->session->userdata('search_country'), $slug, $this->limit);
} else {
$_GET['l'] = escape($city);
$_GET['tl'] = 1;
$this->listings_model->category_location_tag_search(false, $module, 'search', NULL, NULL, $this->limit);
} else {
$_GET['l'] = escape($slug);
$_GET['tl'] = 2;
$this->listings_model->category_location_tag_search(false, $module, 'search', NULL, NULL, $this->limit);
} else {
$this->listings_model->category_location_tag_search(false, 'listings', 'cities', $this->session->userdata('search_country'), $slug, $this->limit);
Add a new method to the end of the same file as follows:

* Browse By Category and Location
public function browse($category, $state, $city = null) {
$category = $this->db->get_where('categories', array('slug' => escape($category)))->row();
if($category) {
$_GET['cg'] = $category->id;
if(!empty($state)) {
$_GET['l'] = escape($state);
$_GET['tl'] = 2;
if(!empty($city)) {
$_GET['l'] = escape($city);
$_GET['tl'] = 1;
$module = 'listings';
$this->listings_model->category_location_tag_search(false, $module, 'search', NULL, NULL, $this->limit);
Add the below lines to the application/config/routes.php file after line number 269.

$route['category/(:any)/location/(:any)/(:any)'] = 'listings/browse/$1/$2/$3';
$route['category/(:any)/location/(:any)'] = 'listings/browse/$1/$2';
Add the below lines to the public_html/.htaccess file after line number 192:

RewriteCond %{THE_REQUEST} ^[A-Z]{3,}\s/+([^&\s]+)\.html [NC]
RewriteCond %{REQUEST_URI} !^/[0-9]+\..+\.cpaneldcv$
RewriteCond %{REQUEST_URI} !^/[A-F0-9]{32}\.txt(?:\ Comodo\ DCV)?$
RewriteRule ^ [L,R=301,NE]