Sort Movies With No Country Tag

General Discussions
1

Is there a way to sort movies that don’t have a Country tag? I’ve tried looking at Advanced filters and leaving the Country option blank, but it just shows all my movies. There’s no option for None.

Thanks

2

If you want to identify movies without a country, you can use the Export Tools section of WebTools-NG to export a list of all movies in a library, including the country, to a CSV file. You could then import the list into a spreadsheet and sort as desired.

WebTools-NG runs on Windows, Mac, & Linux. It does not have to run on the same system as Plex Media Server.

You can choose to export All info, but that is probably more than you need.

You can create a custom export level with only the desired information.

Example:

Custom Level with Title, Country, and File Path

custom country
custom country1525×955 70.5 KB


Export the data

export tools
export tools1520×986 71.8 KB


Output 
"Title","Country","Part File Combined"
"Abbott and Costello Go to Mars","United States of America","/media/movies/Abbott and Costello Go to Mars (1953)/Abbott and Costello Go to Mars (1953).mkv"
"Abbott and Costello in the Foreign Legion","United States of America","/media/movies/Abbott and Costello in the Foreign Legion (1950)/Abbott and Costello in the Foreign Legion (1950).mkv"
"Abbott and Costello Meet Dr. Jekyll and Mr. Hyde","United States of America","/media/movies/Abbott and Costello Meet Dr. Jekyll and Mr. Hyde (1953)/Abbott and Costello Meet Dr. Jekyll and Mr. Hyde (1953).mkv"

GitHub: GitHub - WebTools-NG/WebTools-NG: WebTools Next Generation for Plex
Download: Release 1.2.1 · WebTools-NG/WebTools-NG · GitHub
Wiki: Home · WebTools-NG/WebTools-NG Wiki · GitHub
Export Tools: ExportTools · WebTools-NG/WebTools-NG Wiki · GitHub

1 Like
3

Thanks so much.

Do you know if there’s an option to export a .csv with columns instead of all info on one line? This version of WebTools-NG says “for this version xlsx is currently disabled”

4

When you import the csv file into a spreadsheet application it should separate the info into columns.

You might have to manually fix a few entries, but most should be correctly aligned.

5

You should define the column separator character as tabulator. Not as comma or semicolon, because these can occur in text metadata.

7

What would I put in the “Delimiter between columns in CSV file” option to achieve that? I tried “|” and everything was still on one line, no columns.

Thank you

8

grafik
grafik1262×948 91.7 KB

You might wanna use LibreOffice instead of Microsoft Office. For some reason, MS made it difficult to define how to interpret CSV files. It used to work just fine in older versions of MS Office.

9

Using Google Sheets.

If I import the CSV file and tell Sheets to use a comma as the delineator (instead of auto), then the information is imported correctly.

Using the data from my earlier post, I have movie title in column A, Countries in column B, and path to the file in Column C.

It works even if the movie has commas, colons, etc. in the name.

Steps:

File → Import → Upload
Drag CSV file into upload window

  • Import Location = Replace Spreadsheet
  • Separator type = Comma
  • Convert text to numbers, dates & formulas = unchecked
    Then re-size columns as needed.
Google Sheets Screenshot

import
import2319×827 189 KB

10

I’m doing something wrong, because I’m still not getting columns, just all the info on one line. This is what Sheets gave me:

Webtools-NG Output
Webtools-NG Output1057×211 21.6 KB

11

My settings:

Qualifier to use with a text based field for CSV = " = quotation mark
Delimiter between columns in CSV = , = comma


wtng settings
wtng settings1117×729 41.1 KB

1 Like
12

Awesome! That worked.

Thank you