We're updating the issue view to help you get more done. 

Language list not properly alphabetical

Description

http://test.ao3.org/admin_posts
http://test.ao3.org/admin_posts/###

1. About > News
2. Open the select menu for Languages
3. Examine the list of languages in the menu
4. Look at a post with languages listed as Translations

Languages in the menu and on translated posts are currently sorted alphabetically by their short name, which means the list contains such seemingly inexplicable alphabetization as "Suomi" (fi) coming between "español" (es) and "Français" (fr).

Much like we did with fandom tags, we want to add a sortable_name column to the languages table so admins can set an optional name to use for alphabetization. If no name is set, it should continue to fall back to the abbreviation (short_name).

That process should go like:

http://test.ao3.org/languages/ABBREVIATION/edit

1. Log in as admin
2. Go to languages page at http://test.ao3.org/languages
3. Choose "Edit" for a language, e.g. Suomi
4. Enter an optional name to sort on (e.g. Suomi) in a text field labeled "Name for alphabetical sorting"
5. Update Language
6. Voila ! Suomi is now with the other S-languages on the Language menu and in the list of translations on any news post that uses it

We want to do this via a new sortable_name column rather than using the languages' actual names to avoid having all the languages that begin with non-Latin characters ending up in a jumble at the end.

Please note that languages from http://test.ao3.org/languages are used in many places throughout the site. In addition to the admin post pages referred to above, here is a list of places that should be updated to use the sortable_name:

Note: the following 2 locations are currently sorting by language name right now. This means that this fix will appear to "break" the alphabetical sorting on these pages until an admin adds sortable_names to the relevant languages.

Environment

None

Status

Assignee

Christina Cortland

Reporter

Sarken

Roadmap

Internationalization

Priority

Medium

Affects versions

0.9.131

Fix versions

Components

BackEnd
FrontEnd

Difficulty

Medium

Required Access Level

Admin

Milestone

Internal 0.9