SongKong Jaikoz

SongKong and Jaikoz Music Tagger Community Forum

Mapping Catalogue Number to the Comment field?

Hi!

Is there a way to map the label and catalogue number from Musicbrainz and/or Discogs to the comment field? I use iTunes and it won’t show the actual label and catalogue number field so currently I’m moving this information to the comment field manually.

Having some sort of [copy " / “” - "] to field that could be added to the end of the auto correct procedure would be fantastic. Is this possible somehow?

There is no way to map them automatically, but you can do it easily manually as follows:
Drag comment column to the right of label column
Right click on comment header and select ‘Empty Column’
Selecting all fields in the Label and Comment column
Select Edit/Append to Right option

It wouldn’t be a particulary big job to add these as automated actions but isn’t currently available.

Or just use workaround spreadsheet editor and concatenate function

[quote=paultaylor]There is no way to map them automatically, but you can do it easily manually as follows:
Drag comment column to the right of label column
Right click on comment header and select ‘Empty Column’
Selecting all fields in the Label and Comment column
Select Edit/Append to Right option

It wouldn’t be a particulary big job to add these as automated actions but isn’t currently available.[/quote]

That works but I’d also like to put a divider (like " / " or " - ") in between the label, catalogue number and possibly release format in the single comment field.

Never even considered the export function but I imagine you can do this and a whole lot more in Excel. I’m going to try this out.

Thanks guys! :slight_smile:

Take note that Jaikoz and Excel use different sorting, like numbers and all-caps fields. Make sure you pick a common column that sorts the same, then you can copy/paste an entire column at once.

Not really your issue, but I thought I’d throw it out there. I found a bit of VB that turns a list into a comma-separated value. You can change the separation character easily. I’ve been using this to input all those allmusic moods/occasions.

    csvRange = myRange
    csvRange = Application.Transpose(csvRange)
    csvRange = Join(csvRange, ",")
     
End Function

Paste your list into Excel, pick a different cell and type =csvRange, and select your list.