Ceon URI Mapping v4.x

[picandnix]

This would be miles easier than having to manually update every product/category/EZ Page on the site..

And circumnavigate a rather (now, yet not previously) expensive commercial add-on that currently does it.

[mc12345678]

And circumnavigate a rather (now, yet not previously) expensive commercial add-on that currently does it.

Which, in part is why I hadn't put something like it out there yet. I don't know if it is something like a programmer's respect or if it is that I don't want to be responsible for the loss of another's income (although I might be talked into it. ), but I was considering providing the ability to interface with the applicable table(s), leaving any automation or other mixing and matching to the user. This is much like how the version of EP that I have come to like is setup. It seems to have all that is needed in it, but is not necessariily sequenced/documented for all things.

To incorporate in another version, I'd have to learn and tinker a bit.

[DivaVocals]

Which, in part is why I hadn't put something like it out there yet. I don't know if it is something like a programmer's respect or if it is that I don't want to be responsible for the loss of another's income (although I might be talked into it. ), but I was considering providing the ability to interface with the applicable table(s), leaving any automation or other mixing and matching to the user. This is much like how the version of EP that I have come to like is setup. It seems to have all that is needed in it, but is not necessariily sequenced/documented for all things.

To incorporate in another version, I'd have to learn and tinker a bit.

Honestly that's very nice that you feel this way, but not necessary since this add-on is a FREE module.. And since the original developer is no longer with us, and the free module is now largely supported by the community, I say it's more than okay to submit any helper add-ons we (as the community who are continuing to support this add-on) see fit to submit.. What you proposed could certainly end up being a lot more robust than my simple SQL script which only closes ONE gap. What you propose with EP could close ALL the gaps.. But let me make sure that I understand if this is what you are proposing:

Using either EP or a variant of EP

• Initial population of category/product/EZ Pages URI Mappings
• Initial population of default/other pages URI Mappings
• Updates to URI Mappings when changes to category/product/EZ Pages are needed
• Updates/Additions to URI Mappings when changes/additions to default/other pages are needed

Because if this is what you are suggesting, this would be FANTASTIC and a much WELCOME add-on to the Zen Cart community!!

[mc12345678]

Honestly that's very nice that you feel this way, but not necessary since this add-on is a FREE module.. And since the original developer is no longer with us, and the free module is now largely supported by the community, I say it's more than okay to submit any helper add-ons we (as the community who are continuing to support this add-on) see fit to submit.. What you proposed could certainly end up being a lot more robust than my simple SQL script which only closes ONE gap. What you propose with EP could close ALL the gaps.. But let me make sure that I understand if this is what you are proposing:

Using either EP or a variant of EP

• Initial population of category/product/EZ Pages URI Mappings
• Initial population of default/other pages URI Mappings
• Updates to URI Mappings when changes to category/product/EZ Pages are needed
• Updates/Additions to URI Mappings when changes/additions to default/other pages are needed

Because if this is what you are suggesting, this would be FANTASTIC and a much WELCOME add-on to the Zen Cart community!!

So, perhaps that would be the end user(s) thought on how it would work, but here is my possible duplication of that statement in a somewhat sequence of development/design.

1) First export of the existing CEON URI table/tables.
2) identify relationships of that data with other tables in the database/EP program so that can export applicable CEON data with the applicable file export file.
3) Incorporate import capability to each of the file types.
4) Provide detection for existence of CEON URI being installed.
5) Create default file(s) based off of export of such to then be import by "new" users.
6) Incorporate export of new path based on admin chosen sequence for items exported that do not have a path assigned yet.
7) Detect path to be formatted as originally described (/ first followed by whatever "sub-directory" is part of ZC install with possibility of an admin override for those hey need it, want it this way kind of instances.
8) Incorporate a switch that controls the "calculation" of the path so that on import a check is made and based on difference(s) recreates the new path withthe expectation of the new one becoming the only "new" one for that identifier.
9) Generation of the new path/verification would need to include/incorporate existing switches and settings of this plugin (ie -, _, lower case, upper case and other separators)


I'm not sure what is implied/expected about "Updates/Additions to URI Mappings when changes/additions to default/other pages are needed" I mean I think that this is covered by what I describe above, but not sure.

The thought is that the file(s) would be of a CSV type and more than likely need to be manipulated by a spreadsheet program (or similar text editor) that would maintain quotes around all data, with quoted text split by commas, all data in a UTF-8 format, umm kinda can't think of anything else related, but think that we are on the same page? Not to say that your SQL code wouldn't still be good. At least would be good to have a starting point of the desired URI remappings/pages to remap, etc...