Login or create new account.

By registering on joomprod.com, you will have immediate access to all our free products and to the public side of our support forum.

Enjoy our subscriptions.

Each of our subscriptions allow you to enjoy the private side of the support forum and all the update of our products for a period ranging from 3 months to 1 year.

Payment And immediate download.

After subscribing to one of our subscription, the products are immediately downloadable.

Login

Or Register
Accueil / forum / Support / AdsManager Support / ReOrdering Categories

Support Availability Because we must sleep sometimes

Working days: Monday to Friday.
Reply time: Depending on the complexity of your support issue it's usually between a few hours to 48 hours.

Support is only guaranteed to paid subscribers

AdsManager - End of life

It is with great regrets that we have chosen to end the developpement of Adsmanager and its other associated components.

AdsManager is born 10 years ago and, as of today, the number of new subscriptions and downloads have fallen and we cannot maintain the component anymore.

All active subscribers will be able to continue enjoying support until the end of their subscription.

The components will be free and no support will be provided anymore for the other users.

×

Notice

The forum is in read only mode.

ReOrdering Categories

More
11 years 4 months ago #11993 by dougwoody
ReOrdering Categories was created by dougwoody
Hey AdsManager Support,

I'm using AdsManager to keep track of interactions that my clients have with their clients, in many different regions across the globe. Because of the different regions, I have to break up the categories into many different levels (cities, states, countries, continents, etc), and this means I have a whole lot of categories. Up to a thousand, right now.

I'm trying to alphabetize categories within categories, but every time I move them:
1) The categories "freeze" for a few seconds upon moving them and then upon placing them, and
2) The categories sometimes don't save in the order I put them in.

I understand why 1) happens: I have a LOT of categories. And that's only going to get worse as we add more and more to this system.
My issue is more with 2) than it is with 1). I can handle long wait times while my browser figures itself out.

Here's an example:

North America --> USA --> Colorado --> Cities:
Colorado currently has these cities, in this order:
Laporte, Springfield, Wiley, Loveland, Littleton, Elizabeth, Denver.

And no matter how many times I drag Denver to the top of "cities" in the Colorado category, it always returns back to the bottom of the state's city list. I've even tried to move around other cities in the hopes that it'd move Denver up the list, but either none of those saved in the right place, or me moving these categories did not have any effect. I've used different browsers, cleaned my caches, restarting my computer, making sure it was plugged in, etc.
Most of the time, AdsManager DOES save right the ordering. Texas, which as more categories than Colorado, only has one city that won't go where I want it to.

Is there any easier way to organize/sort categories? Because the current way takes far too long to reorder one category of thousands.
Any tricks would be incredibly helpful.

Thanks for your time,
--Jake
The following user(s) said Thank You: adarr
More
11 years 4 months ago #11995 by loic
Replied by loic on topic ReOrdering Categories
Hello,

There is a trick for that, however, the ordering feature will not work after the modification and any reinstallation or update will erase this modification, so keep it safe somewhere :).

Open the file 'administrator/components/com_adsmanager/models/category.php' and find the line 327 in the function getCatTree():
. " ORDER BY c.parent,c.ordering,c.id";

Replace it with that:
. " ORDER BY c.parent,c.name,c.id";

If it is not working, the same line can be found in other functions at the line 105 and 26. You need to update the ORDER BY params and only this.

Best regards.
The following user(s) said Thank You: adarr, dougwoody
More
11 years 4 months ago #11999 by dougwoody
Replied by dougwoody on topic ReOrdering Categories
Wow, that little line of code fixed everything.

Thank you so much!
--Jake
The following user(s) said Thank You: adarr
More
11 years 4 months ago #12009 by tompap
Replied by tompap on topic ReOrdering Categories
Good news :)
The following user(s) said Thank You: adarr
Time to create page: 0.084 seconds
Powered by Kunena Forum