INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: fill tags from an xls (or csv) file  (Read 1107 times)

kdwykleingeld

  • World Citizen
  • ***
  • Posts: 118
fill tags from an xls (or csv) file
« on: July 11, 2014, 08:19:16 am »

Hi, what would be the most easy way to do the following :

1) i have a lot of jpg images that i import into jriver  .. those jpg images represent mechanical parts..

2) the file name for each image contains the   partnumber   (e.g. 123456.jpg    or 4585995.jpg)

3) i have an xls spreadsheet which contains more details for each part such as color, category, price etc

My question : how can i fill the tags in jriver for each image/part based on the content of my xls   (if required i can create a csv etc)

the lookup key would be the unique partnumber that is part of the image file (filename) and present as a column in the xls file 

thx koen

Logged

kdwykleingeld

  • World Citizen
  • ***
  • Posts: 118
Re: fill tags from an xls (or csv) file
« Reply #1 on: July 11, 2014, 08:24:07 am »

the other way around would be to generate an MPL file from the content of the xls database .. import that as a playlist .. and somehow relate the correct image to each entry ...?? i have no idea if that would be possible and how to link them ..

thx koen
Logged

glynor

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 19608
Re: fill tags from an xls (or csv) file
« Reply #2 on: July 11, 2014, 09:06:37 am »

MrC's pscriptor can probably do this, or help.
Logged
"Some cultures are defined by their relationship to cheese."

Visit me on the Interweb Thingie: http://glynor.com/

kdwykleingeld

  • World Citizen
  • ***
  • Posts: 118
Re: fill tags from an xls (or csv) file
« Reply #3 on: July 12, 2014, 02:33:16 am »

i found a way ...

1) rename all image files to <Album Artist> - <Album>.jpg
2) place all these files in the Albums coverart directory
3) create a MPL with all tags that you want to add  and set the Media Type to "Audio"  and ensure that "Album Artist" and "Album" are in line with the one specified in the image file name 
4) import the playlist and the image file is added automatically..

not very neat imho .. but it works

it seems not possible to do this when the Media Type = Data ... ??

are there any other more clean ways to do this ??

i.e.. lookup tag values in an external file based on the image file name

thx koen
Logged
Pages: [1]   Go Up