SongKong Jaikoz

SongKong and Jaikoz Music Tagger Community Forum

Fetching Disc Number from Folder Name

#1

Hi All,

Apologies if this has been answered already, but I am trying to do a simple operation with the latest Jaikoz and am falling short. I want to populate the Disc No field automatically from the folder contaning my files. The folder name has some letters and the disc number. So an example folder would be
CD22/FLAC files in here.
I can get rid of the letters and non necessary characters later via Find and Replace, but I would need to effectively copy the folder name into the DiscNo field, via I assume “Correct Metadata from Filename”. Could anyone kindly point me out how to do this?

Many thanks!

#2

The Disc No field only allows numbers to be added not just general text so I think the best solution would be as follows, few steps to follow but can be done on all files in one go. We use Custom 1 as an interim stage assuming it not used for something else, if it is use a different column.

Position columns so they go Sub Folder/Custom 1/Disc No

image
image1288×449 45.6 KB

Select all fields in SubFolder and Custom 1 column

image
image1288×449 48.4 KB

Right Click and select Edit/Append to Right

image
image1288×449 58.1 KB

use Find and Replace to modify Custom 1 column to have the correct value, exactly how you do this depends on your data.

image

image

image
image1288×449 55.2 KB

Select all fields in Custom 1 and DiscNo column

image
image1288×449 55.2 KB

Right Click and select EditAppend to Right

image
image1288×449 55.8 KB

Right click on Custom 1 column and select Empty Column

image
image1288×449 57.4 KB

Contemplating re-tagging my music database (165k Files) with Songkong
#3

Many thanks, Paul. This is very useful. Can I ask what the best way of selecting all fields in a column is? I would need it for other tasks too, but I have not found a shortcut/menu item to do so. A manual selection can be imprecise and complicated, especially when dealing with hundreds of files at the same time.

#4

On Windows I would do as follows.

Select first item in column by left-clicking in field with mouse

image
image1034×493 24.2 KB

Then go to last item in list and hold SHIFT key down and left mouse click on item

image
image1034×493 27.7 KB

For two adjacent columns, first step is same, second step would be to SHIFT and click on last item in second column

image
image1034×493 27.8 KB

There is currently no shortcut or key to select all fields in a column, I can see that may be useful.

#5

Dear Paul,

What you kindly suggest works for a small amount of tracks, but at times I need to work with hundreds, and it becomes cumbersome, particularly due to the fact that I often work on a small laptop screen. It would be ideal if there was a command to select all fields in a column, as you suggest, say within the right click menu when clicking on the column name (Album Artist, Track No, etc). That would make things much easier.
It would be also good if there was a command in the Edit menu for the copying of all fields from one column to the other - say I want to copy everything in the Title column to Grouping. A window enabling me to select both as source and destination would also be very useful.

#6

Agreed, I will raise an issue for both of these requests.

#7

Okay, first one already exists https://jthink.atlassian.net/jira/software/c/projects/JAIKOZ/issues/JAIKOZ-71
Second one raised https://jthink.atlassian.net/browse/JAIKOZ-1469

#8

First issue fixed ready for next release.

Second issue, you can actually already do this, if you have two columns selected then you can use Edit:Swap to swap them round. Note Edit:Swap option only enabled if you have fields in two columns selected, it will not be enabled if only have one column selected or more than two columns selected, so will close JAIKOZ-1469 as duplicate.

#9

First issue now fixed in Jaikoz 11.9