How do I get the photos to appear in alphabetical order?
They are out of the original order of upload.
Note: When I upload in the correct order ... but appear out of order in view of the gallery.
Offline
1) install/activate [extension by Piwigo Team] LocalFiles Editor from screen [Administration > Plugins > Manage]
2) open [Administration > Plugins > LocalFiles Editor > Local config] and paste the following code:
<?php
$conf['order_by'] = " order by file asc";
?>
Offline
I tried this but am still missing some files alphabetically; for instance, I have a file named armenonville green.jpg - thumbnail should appear on this page
http://hermesscarf.com/piwigo/index.php … hotos_Here
It is definitely in the album, here is the individual page
http://hermesscarf.com/piwigo/picture.p … category/4
Thumbnails are in alphabetical order, they just seem to skip over some...but no thumbnails are missing.
Offline
I figured out my main problem, I have files names in lower case, upper case and mixed - how can I have file order be case insensitive? I will need this also for search parameters... Thank you.
Offline
Looking again, it does not appear that upper/lower case is determining order of file names, so I am not at all sure why they are not appearing in order.
Offline
I'm interested in how this gets fixed. Sort hasn't worked right for me since the upgrade. The only thing I've found that works for me (and it wasn't like this before the upgrade) is using pLoader and uploading them in the order I want them to appear (which is creation_date desc, file asc).
Someone told me here on the forums that the creation_date is Piwigo generated during upload which makes me wonder what the difference between the creation_date and the post_date is.
In Piwigo v 2.1, creation_date seemed to follow the metadata creation date.
Last edited by lisaviolet (2011-04-18 00:40:19)
Offline
We investigate .... [Bugtracker] ticket 2270
Last edited by flop25 (2011-04-19 15:00:30)
Offline
flop25 wrote:
We investigate .... [Bugtracker] ticket 2270
there is in fact no problem. this is how works the alphabetical order :
Aurora_screenshot.jpg
BSD_013_TechnoDream.jpg
BUD_metal_work_03.jpg
BeHappyDamnit.jpg
Beyond_Knowledge_V1.jpg
BlueOrb.jpg Blue_Christmas.jpg
BoXXiCelli1024x768.jpg
Celestial_Dragons.jpg
Christmas_Balls.jpg
it's case sensitive
Offline
flop25 wrote:
it's case sensitive
You can sort by filename with insensitive case:
$conf['order_by'] = " order by UPPER(file) ASC";
Offline
Or better (at performance level):
$conf['order_by'] = ' ORDER BY file COLLATE \'utf8_general_ci\' ASC';
Offline
If anyone is curious to take a look...there are five images beginning with Africa - but only one shows alphabetically by file name
http://hermesscarf.com/piwigo/index.php?/category/home
You can see them in the Geography subfolder.
I guess there's not an option to sort by title as set within Piwigo?
Offline
yplady wrote:
If anyone is curious to take a look...there are five images beginning with Africa - but only one shows alphabetically by file name
http://hermesscarf.com/piwigo/index.php?/category/home
You can see them in the Geography subfolder.
I guess there's not an option to sort by title as set within Piwigo?
the category is private
btw you seems to have trouble with hr_os_xl
ps : your link is wrong but the album Geography is ok ^^
ps² : if you're french you can go to the french forum
Last edited by flop25 (2011-06-16 11:40:59)
Offline
It's normal : first the numbers, then you have the capital letters ordered correctly and then the others.
So use this thread to order as you wish :
$conf['order_by'] = " order by UPPER(file) COLLATE \'utf8_general_ci\' ASC"; may be the better solution
ps : don't forget $conf['order_by_inside_category']=$conf['order_by']
Last edited by flop25 (2011-06-16 11:47:49)
Offline
Thanks - it's now working!
Offline
Would it not be better, safer and easier to have an extra configuration option in the configuration --> options section?
I would then have the following possible options and a few columns, the first one.
The first column will show the option, the second will show the level in a dropdown menu (level 1 will be ordered first etc), and the third column will show ASC or DESC (dropdown menu):
This ti will look like
Order based on:
Date | ASC or DESC | level
Filename | ASC or DESC | level
File added | ASC or DESC | level
etc
Offline