Ceon URI Mapping v4.x

[DivaVocals]

Awesome!!!

Fyi, step one: complete. Option is available to update/create product URIs using the settings of this module (ie, capitalize the first word, or use a hyphen, etc.) while exporting the products of the database with options such as, export to file only (or update the database/store) using the following options: create URIs only for products that don't have one currently (new store, new user of this module, or after upload of new products until the reverse process is created), update only products that have existing URIs (good for when a site changes directories or just want to reset the clock), and update all URIs (store directory change, start over, populate blanks and previously written), and all of this in whatever language(s) are present. Tested on ZC 1.5.1 and 1.5.3. This works as if editing each product individually and selecting the autogenerate URI option in the process of saving the product except in bulk.

Next is categories, EZ-pages then importing.

[solo_400]

I have seen that 4.4.2 version came out. I have 4.4.1, can someone give me some hints about upgrade steps ?

Thanks in advance

[mc12345678]

I have seen that 4.4.2 version came out. I have 4.4.1, can someone give me some hints about upgrade steps ?

Thanks in advance

One way, and if not mistaken for this latest update, is to download the new package, compare it to the old, and then make the changes that were identified.

Another is to perform the same comparison, then compare the new file(s) with the existing site's files and merge those two. This later method is to identify what other changes are in the affected file(s) and evaluate the impact of them to the plugin being installed.

There's a number of ways to go about it. As always though, it is suggested that the upgrade be performed on a development site first so that the live site continues to operate and to also make a local backup before making changes.

[DivaVocals]

One way, and if not mistaken for this latest update, is to download the new package, compare it to the old, and then make the changes that were identified.

Another is to perform the same comparison, then compare the new file(s) with the existing site's files and merge those two. This later method is to identify what other changes are in the affected file(s) and evaluate the impact of them to the plugin being installed.

There's a number of ways to go about it. As always though, it is suggested that the upgrade be performed on a development site first so that the live site continues to operate and to also make a local backup before making changes.

OR..

one could download the new package and see if the upgrade hints/steps are covered in the readme.. (IJS)

[mc12345678]

OR..

one could download the new package and see if the upgrade hints/steps are covered in the readme.. (IJS)

Hmm, guess I jumped the gun, thinking that may had already been done...

[solo_400]

OR..

one could download the new package and see if the upgrade hints/steps are covered in the readme.. (IJS)

In doc files is specified how to upgrade from older versions to 4.4.1

[DivaVocals]

One way, and if not mistaken for this latest update, is to download the new package, compare it to the old, and then make the changes that were identified.

........................

[mc12345678]

Hadn't seen this included either in the forum (searched for 1.5.3, 153, zip upgrade, etc...; however, nothing seemed to result in a post or near a post where such an addition was included) or in the newest available download (4.4.2) which included a code change to prevent an issue associated with the constant SID, but thought others trying to install this plugin on ZC 1.5.3 would want to easily keep the changes that have been made to support ZC 1.5.3 in place.

Attached is a zip file that contains the modified_core_files directory for 1.5.3 as made from comparing the files in the 1.5.1 version of this module to a vanilla install of ZC 1.5.3. This zip file would be unzipped to the same location as the 4.4.2 version of the module to add the one directory and support installation using the "normal" method. Sorry, I have only gone half way with this "upgrade" to the module in that the instructions have not been rewritten to support a full 1.5.3 install/upgrade. I have used this on a ZC 1.5.3 site; however, the site is not yet using PHP 5.4, so I do not know if there are other changes that may be necessary to support continued use under that version of PHP or higher.

[mc12345678]

Fyi, step one: complete. Option is available to update/create product URIs using the settings of this module (ie, capitalize the first word, or use a hyphen, etc.) while exporting the products of the database with options such as, export to file only (or update the database/store) using the following options: create URIs only for products that don't have one currently (new store, new user of this module, or after upload of new products until the reverse process is created), update only products that have existing URIs (good for when a site changes directories or just want to reset the clock), and update all URIs (store directory change, start over, populate blanks and previously written), and all of this in whatever language(s) are present. Tested on ZC 1.5.1 and 1.5.3. This works as if editing each product individually and selecting the autogenerate URI option in the process of saving the product except in bulk.

Next is categories, EZ-pages then importing.

Categories done. Essentially has the same functionality as with products. Create/recreate URIs for all categories on export (Categories Only with metatags) or all categories that currently have a product associated (Model/Category). Adding EZ-Page capability that wasn't previously included...

[franekz]

Hi guys,

Many of you want to convert all of products/categories to be used by this module.
This is a very simle code (my site is only english, only GBP etc etc). I did not have enough time to write it properly so you should actually change it if you use more than one language in your shop. But I had only 15 min so the code is as it is.

<?php
    global $db;
/* CATEGORIES */

      require_once(DIR_WS_CLASSES . 'class.CeonURIMappingAdminCategoryPages.php');
      
     

/* CATEGORIES */
      

/* PRODUCTS */
    require_once(DIR_WS_CLASSES . 'class.CeonURIMappingAdminProductPages.php');
    
set_time_limit(600);    
        
/* PRODUCTS */
$__i = 0;
if(false) $_cat = $db->Execute("TRUNCATE ceon_uri_mappings");


$ceon_uri_mapping_admin = new CeonURIMappingAdminCategoryPages();
$__products = $db->Execute("SELECT categories_id,parent_id FROM " . TABLE_CATEGORIES);
while (!$__products->EOF) {
    $__cat = $__products -> fields;
    $__cat_id = $__cat['categories_id'];
    $new_uri = $ceon_uri_mapping_admin->autogenCategoryOrProductURIMapping($__cat_id, 'category',NULL,NULL,"en",1);
    //echo($new_uri . "</br>");
    $_cat = $db->Execute("SELECT * FROM ceon_uri_mappings WHERE associated_db_id = '$__cat_id' AND main_page = 'index'");
    if($_cat -> RecordCount() == 0)     
        $cat = $db -> Execute("INSERT INTO ceon_uri_mappings (uri,language_id,current_uri,main_page,associated_db_id,redirection_type_code) VALUES ('$new_uri','1','1','index','$__cat_id',NULL)"); 
    $__products->MoveNext();       
}    

$ceon_uri_mapping_admin = new CeonURIMappingAdminProductPages();
$__products = $db->Execute("SELECT products_id, products_type FROM " . TABLE_PRODUCTS);
while (!$__products->EOF) {
    set_time_limit(600);  
    $__prod = $__products -> fields;
    $__prod_id = $__prod['products_id'];
    
    
    $_cat = $db->Execute("SELECT categories_id FROM products_to_categories WHERE products_id = '$__prod_id'");
    $cat = $_cat -> fields;
    
    
    $new_uri = $ceon_uri_mapping_admin->autogenCategoryOrProductURIMapping($cat['categories_id'], 'category',NULL,NULL,"en",1);
    $new_uri .= $ceon_uri_mapping_admin->autogenCategoryOrProductURIMapping($__prod_id, 'product',NULL,NULL,"en",1);

    $_cat = $db->Execute("SELECT * FROM ceon_uri_mappings WHERE associated_db_id = '$__prod_id' AND main_page = 'product_info'");
    //if($__i++ == 10) die();
    if($_cat -> RecordCount() == 0) 
        $cat = $db -> Execute("INSERT INTO ceon_uri_mappings (uri,language_id,current_uri,main_page,associated_db_id,redirection_type_code) VALUES ('$new_uri','1','1','product_info','$__prod_id',NULL)"); 
    //echo($new_uri . "</br>");
    $__products->MoveNext();
            
}




    
?>