[culytera]

Originally Posted by mmmmmmmm

hi again! im sorry, i just cant seem to figure this out.

i raelly want to be able to filter by M/M or F/F or F/M etc.
i have a column for that, and i know you said FFF stores that in genre (for ao3).

i have no idea what i'm missing, but nothing shows up in my column.

in 'custom columns' i have it set to 'genre'

ive tried to play around with the personal.ini

[defaults]
include_in_genre:genre,forumtags,freeformtags, ao3categories

Including all those metadata entries in genre means you're not only adding ao3categories (F/F, etc.) in your ao3categories column, you're also adding the entries under genre, forumtags (not sure if Ao3 uses that) AND freeformtags. If you only want the F/F entries in that column you just need ao3categories=>#ao3categories under your custom_columns_settings instead of genre =>#ao3categories.

 category=> (- All Media Types|- Fandom|\(Movies\)|\(Movie [0-9]+\)|\(Comics\)|\(TV\))$=>
 characters=>\(mentions of\) =>
 characters=> \([Ch]haracter\)=>
 characters=> ?\((cameo|briefly|if you squint|sort of)\)=>
 characters=> - Character=>
 characters=>^Other mentions$=>

 ships=>(.*)[/&](.*) \(?[Ff]riendship(?: only)\)?=>\1 & \2
 ships=> - Relationship=>

These lines need to be below add_to_replace_metadata.

[defaults]
## Some sites also require the user to confirm they are adult for
## adult content.  Uncomment by removing '#' in front of is_adult.
is_adult:true

[archiveofourown.org]
username:XXXXXXXX
password:XXXXXXXX
is_adult:true

You have redundant is_adult entries.

## Question: what does the (,a) after '#fandom' do?

You can check the default personal.ini to learn what some settings do.

There are three parts, the entry name,
## then the label of the calibre custom column, then (optionally) a
## 'mode'. 'r' to Replace any existing values, 'a' to Add to existing
## value (use with tag-like columns), and 'n' for setting on New books
## only. (Default is 'r'.)

I did a test with the ini below and attached screenshot is the result.

Spoiler:

[defaults]
#include_in_genre:genre,forumtags,freeformtags, ao3categories
include_in_genre:

#extra_valid_entries:fandoms

add_to_replace_metadata:
 category=> (- All Media Types|- Fandom|\(Movies\)|\(Movie [0-9]+\)|\(Comics\)|\(TV\))$=>
 characters=>\(mentions of\) =>
 characters=> \([Ch]haracter\)=>
 characters=> ?\((cameo|briefly|if you squint|sort of)\)=>
 characters=> - Character=>
 characters=>^Other mentions$=>
 ships=>(.*)[/&](.*) \(?[Ff]riendship(?: only)\)?=>\1 & \2
 ships=> - Relationship=>
## Changes line breaks to paragraphs
 description=><br/>=></p><p>
## Applies justified alignment to paragraphs
 description=><p>=><p align="justify">

include_subject_tags:ships,category
is_adult:true


[epub]
include_images:true
make_firstimage_cover:false 

[archiveofourown.org]
extra_subject_tags:ao3categories
chapterslashtotal_label: Chapters
titlepage_entries: seriesHTML,category,ao3categories,characters,ships,status,datePublished,dateUpdated,dateCreated,rating,warnings,freeformtags,chapterslashtotal,numWords,description

add_to_replace_metadata:
 chapterslashtotal=>^(\d+)/\1$=>\1
 chapterslashtotal=>/\?$=>

custom_columns_settings:
 ao3categories =>#ao3categories
 rating =>#audience