Announcement

#1 2011-04-01 18:17:47

prof.claudia
Member
2011-04-01
1

How do I get the photos to appear in alphabetical order?

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

 

#2 2011-04-01 19:58:38

ddtddt
Piwigo Team
Quetigny - France
2007-07-27
7201

Re: How do I get the photos to appear in alphabetical order?

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";
?>


You love Piwigo so don't hesitate to participate, learn more on the "Contribute to Piwigo" page. If you don't have much time for contribution, you can also help the project with a donation.

Offline

 

#3 2011-04-17 20:06:13

yplady
Member
2011-04-10
18

Re: How do I get the photos to appear in alphabetical order?

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

 

#4 2011-04-17 20:23:55

yplady
Member
2011-04-10
18

Re: How do I get the photos to appear in alphabetical order?

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

 

#5 2011-04-17 20:39:20

yplady
Member
2011-04-10
18

Re: How do I get the photos to appear in alphabetical order?

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

 

#6 2011-04-18 00:39:38

lisaviolet
Member
san diego, california
2011-01-03
334

Re: How do I get the photos to appear in alphabetical order?

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

 

#7 2011-04-19 14:58:34

flop25
Piwigo Team
2006-07-06
7037

Re: How do I get the photos to appear in alphabetical order?

We investigate .... [Bugtracker] ticket 2270

Last edited by flop25 (2011-04-19 15:00:30)


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#8 2011-04-20 18:08:48

flop25
Piwigo Team
2006-07-06
7037

Re: How do I get the photos to appear in alphabetical order?

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


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#9 2011-04-20 18:46:27

P@t
Piwigo Team
Nice
2007-06-13
4098

Re: How do I get the photos to appear in alphabetical order?

flop25 wrote:

it's case sensitive

You can sort by filename with insensitive case:

Code:

$conf['order_by'] = " order by UPPER(file) ASC";

P@t

Offline

 

#10 2011-06-01 15:22:13

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13786

Re: How do I get the photos to appear in alphabetical order?

Or better (at performance level):

Code:

$conf['order_by'] = ' ORDER BY file COLLATE \'utf8_general_ci\' ASC';

Offline

 

#11 2011-06-16 04:15:43

yplady
Member
2011-04-10
18

Re: How do I get the photos to appear in alphabetical order?

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

 

#12 2011-06-16 11:04:35

flop25
Piwigo Team
2006-07-06
7037

Re: How do I get the photos to appear in alphabetical order?

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)


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#13 2011-06-16 11:44:18

flop25
Piwigo Team
2006-07-06
7037

Re: How do I get the photos to appear in alphabetical order?

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)


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#14 2011-06-17 02:39:31

yplady
Member
2011-04-10
18

Re: How do I get the photos to appear in alphabetical order?

Thanks - it's now working!

Offline

 

#15 2011-08-25 14:44:25

lehrer
Member
2010-08-30
24

Re: How do I get the photos to appear in alphabetical order?

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

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact