INTERACT FORUM

Please login or register.

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

Author Topic: Is it possible to combine two database fields in one?  (Read 1870 times)

Mastiff

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1977
  • The Multi-Zone Tzar
Is it possible to combine two database fields in one?
« on: August 29, 2004, 07:38:03 am »

I have a slight problem - I want a field with Artist - Album. The problem is that I can't use a calculated field since this slows down the use. This is for NetRemote's album cover browsing, and if I use a calculated field as a browsing item it takes a lot longer (4-5 times) to show the covers. When there can be up to 70 covers on one page it will take far to long to show them. So can I in some way copy the Artist (or even better Album artist (Auto) field and the Album field into this one field I have created called "Artist - Album"?

I created a user field called "Artist - Album" and used "Fill properties from filename", with the directory name as the criteria, since I have all my music in directories named Artist - Album. Then I choose not to store it in ID3 tags (since updating and then doing a full new synchronization of more than 50 000 tracks will take a couples of days...). This works. But it's weird that I had to go through such lengths to do this. Also the directory names aren't totally accurate (for instance it's impossible to call a directory "AC/DC - Back in Black", it will be "AC_DC"). So can anybody give me a better solution here? I'd really appreciate any pointers!
Logged
Tor with the Cinema Inferno & Multi-Zone Audio system

Dragyn

  • Citizen of the Universe
  • *****
  • Posts: 3269
Re:Is it possible to combine two database fields in one?
« Reply #1 on: August 29, 2004, 08:56:24 am »

Have you tried "Move / Copy Fields"?
Logged

Mastiff

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1977
  • The Multi-Zone Tzar
Re:Is it possible to combine two database fields in one?
« Reply #2 on: August 29, 2004, 09:00:44 am »

Yes, I sure have. But it doesn't have an additive option, so it removes what's in the field already. Which means that if I first copy [Artist] to [Artist - Album] and then the [Album] field all I will be stuck with is another field where only the Album info is.
Logged
Tor with the Cinema Inferno & Multi-Zone Audio system

Dragyn

  • Citizen of the Universe
  • *****
  • Posts: 3269
Re:Is it possible to combine two database fields in one?
« Reply #3 on: August 29, 2004, 09:08:02 am »

I just tried it.

Made a calculated temp field: [Album Artist (auto)] - [Album]

Then I made the "Artist - Album" field. Then I did a copy field between the two and it filled up just fine.

Maybe I'm not understanding what you want.
Logged

Mastiff

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1977
  • The Multi-Zone Tzar
Re:Is it possible to combine two database fields in one?
« Reply #4 on: August 29, 2004, 09:25:24 am »

Man, you're a genius! Of course! I never thought about that second step - calculated to static field! But what version are you using? I can't see any calculated fields when I try to copy fields. I see Album artist (auto) but not for instance Album artist - Album (year). Do you use 11? Then this may be something that is added there.
Logged
Tor with the Cinema Inferno & Multi-Zone Audio system

Jaguu

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1336
Re:Is it possible to combine two database fields in one?
« Reply #5 on: August 29, 2004, 09:54:56 am »

I did the same thing as Dragyn suggested 2 days ago and it really worked fine. I did it with MC11, it might not work with earlier versions.

Some time ago I had split the fields NAME and MOVEMENT for classical music, but now I found that it was not worth to have an extra field MOVEMENT for that and decided to join the 2 fields again. Worked as mentioned above. Afterwards you can delete the extra fields.

It might be nice to have functions such as join fields and split fields and also regular expression support for search+replace.
Logged

Dragyn

  • Citizen of the Universe
  • *****
  • Posts: 3269
Re:Is it possible to combine two database fields in one?
« Reply #6 on: August 29, 2004, 10:01:45 am »

I think the caculated copying was added in 11.

Edit:

11.0.5 (6/9/04)

12. Changed: Non-editable fields (i.e. calculated fields, etc.) can be used as the source in the "Move / Copy Library Fields" tool.
Logged

Mastiff

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1977
  • The Multi-Zone Tzar
Re:Is it possible to combine two database fields in one?
« Reply #7 on: August 29, 2004, 10:06:04 am »

I was afraid of that. In my house WAF is king...er...queen, so I can't take the chance on using anything that's not 100 % stable (have I mentioned this before, perhaps?), so 11 is probably months away from my system, I'm afraid. Of course I could do a really big one: Install 11, create and copy the fields, store them in the tag, go back to 10 and finally do an update. But of course I won't. Overkill is my word for something like that...again there's the 50+ K tracks that has to be backed up again...
Logged
Tor with the Cinema Inferno & Multi-Zone Audio system

Alex B

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 10121
  • The Cosmic Bird
Re:Is it possible to combine two database fields in one?
« Reply #8 on: August 29, 2004, 10:33:46 am »

So now you have at least one good reason to upgrade when MC 11 is ready.  ;)
Logged
The Cosmic Bird - a triple merger of galaxies: http://eso.org/public/news/eso0755

Mastiff

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1977
  • The Multi-Zone Tzar
Re:Is it possible to combine two database fields in one?
« Reply #9 on: August 29, 2004, 10:35:54 am »

Actually I have many, it's just that it will take tiiiiiime. I hope it will happen in 2004, but I'm not holding my breath... The main reasons to upgrade are enhancements to the NetRemote part.
Logged
Tor with the Cinema Inferno & Multi-Zone Audio system

Dragyn

  • Citizen of the Universe
  • *****
  • Posts: 3269
Re:Is it possible to combine two database fields in one?
« Reply #10 on: August 29, 2004, 10:36:12 am »

Is it just because of the plugins and stuff?

I find v11 very stable and I don't think it should be labeled as alpha.
Logged

Mastiff

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1977
  • The Multi-Zone Tzar
Re:Is it possible to combine two database fields in one?
« Reply #11 on: August 29, 2004, 10:38:14 am »

I tried it on my work computer a month or so ago, and it had two crashes during the 12-14 hours I played music on it. Which makes it totally useless for me. But then again maybe big things has happened in that time?
Logged
Tor with the Cinema Inferno & Multi-Zone Audio system
Pages: [1]   Go Up