I have a celebrity site that already has a photo gallery but I've considered using Photopost Pro instead so that I could make it more interactive. The photo gallery that I have now has one category per celebrity and through SQL query I could alphabetize the categories and even break down the pages by letter when it gets to the point that I have hundreds of categories.
What I'd like to know is if someone has already dealt with the issue of having hundreds of categories. If not, any ideas?
There are many of our sample sites which are larger sites that have hundreds of categories and you may view those sites to see how they handle things. You can assign categories to other categories order them how you wish etc.
After I run the query to add the subcategories, I then went to photopost admin and opened and saved the main category. This added the subcategory numbers to the children column of the main category. Now the subcategories show up.
You can not add categories though some bulk query. More than queries are done as in your categories need to be created under the data directory this is all done through the script when it does the processes in the script built in.
Ahhhhh...I see what you're saying. But what if I'm only wanting to use the categories that I'm adding through a sql query for the purpose of allowing users to assign their member albums to one of those categories? They won't be adding photos directly into those categories so the data directories won't really be necessary. Is there anything else that the script does that might cause a problem by not executing the script and using the sql query instead?
What I'm trying to do is this: I have a list of several hundred cities and I would like to make each of those cities a category. I would then like for users to be able to assign their albums to one of the categories.
I was able to add the categories with a sql query but it really slowed things down. Do you think this is just a result of the database limitations and/or my server speed? Or is it slowing down due to the limitations of photopost (not a complaint), or possibly from the way I added the categories through the sql query?
You should add a check in the photo processing on upload to see if the data structure exists and if it doesn't create it. Then we could do this. It took 30 minutes to create the sql and execute to add 2000 categories. You got any idea how long that would have taken one at a time... Forever. Now I gotta go back and write a script to create the folder structure... (UGH!)
There is already a script that creates folder structures its called add a category. You must create categories to upload to properly in our program through our program if you do not then oh well you do it manually if you wish.