I have read the admin guide and I cant find anything that says about sorting albums.For example I have an album named 2003 and in that album there are albums using names or numbers.How would you sort them so that they were in alphabetical order or number order.

Thanks and I really think this is a stupid question however I cant seem to find the answer anywhere.

That is what I was looking for we will give it a go in sql

Thanks :)

Gallery Server stores albums and media objects in it's cache, so that's probably why you restarted IIS. You can also clear the cache by restarting the application pool or "touching" the web.config file. That is, opening it and resaving it.

As you know, an album can contain many child albums and/or media objects. When GSP displays them, it sorts them in order of the Seq field that exists in both gs_Album and gs_MediaObject.

Each time you rearrange the items, GSP automatically assigns each object a Seq number starting with 1.

Therefore, each level of albums has Seq numbers starting with 1.

Hope this gives you enough info to be able to put together a SQL statement.

And fyi, earlier in this thread I said additional sorting options were scheduled for 2.3. Unfortunately, those have been pushed back to 2.4.

Glad you got it.

You can programmatically start a synch from your utility without too much trouble, but it may be difficult for a self-proclaimed non-programmer. Essentially, you would add references to the dll's used by GSP, create an app.config that contains the config settings in galleryserverpro.config, and then invoke the Synchronize function just like it is done in the real app (gs\pages\task\synchronize.ascx.cs).