[Logo] Jaikoz and SongKong Forums
  [Search] Search   [Recent Topics] Recent Topics   [Members]  Member Listing   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
Mapping Catalogue Number to the Comment field?  XML
Forum Index -> Jaikoz Questions
Author Message
Psygnosis



Joined: 13/09/2011 12:35:57
Messages: 2
Offline

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 <label>" / "<catnr>" - "<format>] to <comment> field that could be added to the end of the auto correct procedure would be fantastic. Is this possible somehow?
paultaylor

Pro
[Avatar]

Joined: 21/08/2006 09:21:27
Messages: 7298
Offline

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.

thanks Paul (Administrator)
pschonmann

Pro
[Avatar]
Joined: 30/11/2008 14:02:22
Messages: 239
Offline

Or just use workaround spreadsheet editor and concatenate function

Support Jaikoz! I did it!
[Email] [WWW]
Psygnosis



Joined: 13/09/2011 12:35:57
Messages: 2
Offline

paultaylor wrote:
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. 


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.

pschonmann wrote:
Or just use workaround spreadsheet editor and concatenate function 


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!
dkoh

Pro
[Avatar]

Joined: 05/06/2010 15:02:29
Messages: 246
Location: NorCal, US
Offline

Psygnosis wrote:

pschonmann wrote:
Or just use workaround spreadsheet editor and concatenate function 

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.
 


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.

Code:
Function csvRange(myRange As Range)
     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.

-----------------------------------
Windows 7 64-bit
Asus M4A88TD-V EVO/USB3
AMD AthlonII X3 3.20 GHz
8.0GB RAM
Nvidia 8800 GTX
Back to 5.1.1 NGS (320 & FLAC)
 
Forum Index -> Jaikoz Questions
Go to:   
Powered by JForum 2.1.6 © JForum Team