INTERACT FORUM

Please login or register.

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

Author Topic: Moving data fields  (Read 2129 times)

Cmagic

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 1196
  • Enjoying life with a little music....
Moving data fields
« on: February 11, 2003, 04:03:10 am »

Dear Folks,

Starting with MJ version 7 or so I used the Custom field #1 to store the composer(s) of each song in my library. Since MC9 introduced a dedicated Composer field that can be saved in id3v2 or ape tags I thought It might be a good idea to move my current Custom#1 data column to the Composer column.

I imagined several solution to do that :
- Manual copy and paste in properties. Might be tedious for my +7000 tracks !
- Export my library to .xml and write a small program to move custom1 item data to composer item. But then how do I import my .xml library back ?

Any other ideas on how I could migrate my data from one field to another ??

Thanks for any help.

Christian
Logged
Until the color of a man's skin is of no more significance
than the color of his eyes.
Bob Marley (War)

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42053
  • Shoes gone again!
Re: Moving data fields
« Reply #1 on: February 11, 2003, 04:13:27 am »

I think we just need to make a tool to copy from one field to another.  It's been a common need.

We may be able to slip it into one of the coming builds.  If not, remind us.

Thanks Christian.
Logged
Matt Ashland, JRiver Media Center

michel

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 619
Re: Moving data fields
« Reply #2 on: February 11, 2003, 04:19:54 am »

I need that also.

A few days ago, I tried 'to export library to xml', to replace all 'custom 2' strings by 'keywords' string and then to reimport the xml file. I have been successful once - I am sure of that - but I cannot reproduce it anymore (my first try was with a little database, now I am trying with a big database, may be it is the explanation).

Anyway, a tool to do that will be a nice feature. Thanks.

Logged

Cmagic

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 1196
  • Enjoying life with a little music....
Re: Moving data fields
« Reply #3 on: February 11, 2003, 04:22:21 am »

Thanks Matt,

That would be great to have such a data migration
tool.
Let me think. Could we imagine a scheme in which we move data by simply renaming fields ?

forex: I first delete the default 'Composer' field then I simply rename the 'Custom1' field to 'Composer'. I know this is not possible right now but would that make sense ?

Anyway thanks again for the great work on MC9,

Christian
Logged
Until the color of a man's skin is of no more significance
than the color of his eyes.
Bob Marley (War)

Cmagic

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 1196
  • Enjoying life with a little music....
Re: Moving data fields
« Reply #4 on: February 11, 2003, 04:25:35 am »

salut michel,

How do you re-import the xml database ?
maybe a new feature of 0109 (I'm still on 0107)

C.
Logged
Until the color of a man's skin is of no more significance
than the color of his eyes.
Bob Marley (War)

michel

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 619
Re: Moving data fields
« Reply #5 on: February 11, 2003, 04:48:49 am »

Quote
salut michel,

How do you re-import the xml database ?
maybe a new feature of 0109 (I'm still on 0107)

C.


I never tried it before 109. I am not aboslutely sure (since I cannot reproduce it !) but it seems to me that I just 'import media' (with all types selected), ... or may be I renamed .xml to .mpl ?

Je deviens vieux et j'ai la mémoire qui flanche, mais ça avait marché, j'en suis sûr !
Logged

Cmagic

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 1196
  • Enjoying life with a little music....
Re: Moving data fields
« Reply #6 on: February 11, 2003, 04:54:12 am »

Thanks michel I'll check 'import media',

T'as la mémoire qui flanche,
Tu n'te souviens plus très bien.....
(an old song by Jeanne Moreau, n'est ce pas ? ;)
Logged
Until the color of a man's skin is of no more significance
than the color of his eyes.
Bob Marley (War)

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42053
  • Shoes gone again!
Re: Moving data fields
« Reply #7 on: February 11, 2003, 05:17:45 am »

The tool "Move / Copy Fields..." will be in the next build.
Logged
Matt Ashland, JRiver Media Center

michel

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 619
Re: Moving data fields
« Reply #8 on: February 11, 2003, 05:20:08 am »

I have to admit that I am impressed by such a reactivity...

What ? Next build is only in two weeks ?!!!

;D
Logged

Cmagic

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 1196
  • Enjoying life with a little music....
Re: Moving data fields
« Reply #9 on: February 11, 2003, 05:36:51 am »

Merci beaucoup Matt,

you're great !

C.

Logged
Until the color of a man's skin is of no more significance
than the color of his eyes.
Bob Marley (War)

aussie1

  • World Citizen
  • ***
  • Posts: 249
  • nothing more to say...
Re: Moving data fields
« Reply #10 on: February 11, 2003, 09:41:55 am »

I also applaud the addition of the Move/copy fields tool. Thanks!
Logged

nila

  • Guest
Re: Moving data fields
« Reply #11 on: February 11, 2003, 11:38:02 pm »

Wahoo - Been wanting this tool for a LONG time.

Any chance of adding the options:

Copy IF EMPTY
Move IF EMPTY

So that it copies to the field only if the field is empty.

I have a field called: Album Rating so I can rate all the songs in an album with a rating for the whole album rather than for each individual song. I'd like to copy the 'rating' to the 'album rating' for all songs that dont have one.

These simply additional tools would be great :)
Logged

Marty3d

  • Citizen of the Universe
  • *****
  • Posts: 1363
Re: Moving data fields
« Reply #12 on: February 12, 2003, 12:43:22 am »

GUI suggestion for Nilas idea:
Instead of IF EMPTY (sounds so programatically), put a checkbox with the text "Overwrite existing values" or something...:) Then you all of a sudden have some sort of default that people DON'T overwrite the values if they're not empty :)
Logged


Pages: [1]   Go Up