INTERACT FORUM

Please login or register.

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

Author Topic: Importing Excel or CSV metadata to tag (multiple) albums  (Read 19698 times)

ted_b

  • World Citizen
  • ***
  • Posts: 117
Re: Importing Excel or CSV metadata to tag (multiple) albums
« Reply #50 on: August 16, 2013, 01:01:44 pm »

Success!  Thanks   ;D
Logged

ted_b

  • World Citizen
  • ***
  • Posts: 117
Re: Importing Excel or CSV metadata to tag (multiple) albums
« Reply #51 on: September 04, 2013, 01:49:33 pm »

One question has come up, and I've done a search and found a very similar thread, but the answer (log expression) doesn't seem to work. 
.....the expression was =listitem( [composer],listcount([composer],/ ),/ )

So here goes:

The label wants to name the files with the composer last name in the file name.  The composer tag has two to three names in it (meaning Amadeus Mozart or Ludwig Von Beethoven) but last name is always, er, last, and is preceded by a space.  Is there any expresssion I could use to strip off just the last name (for the file renaming) or should I simply do edits to the tags and make a new composer-last-name field (filled with copy and pasting from composer data)?  Thanks
Ted
Logged

MrC

  • Citizen of the Universe
  • *****
  • Posts: 10462
  • Your life is short. Give me your money.
Re: Importing Excel or CSV metadata to tag (multiple) albums
« Reply #52 on: September 04, 2013, 02:05:08 pm »

Sure, but also consider: What is the last name of these:

   - Cipriano de Rore
   - Michael Tilson Thomas
   - Lara St. John
   - Jaap van Zweden
   - Manuel de Falla

If you truly want just the last "word", then:

   regex([composer], /# ([^ ]+)$#/, 1)
Logged
The opinions I express represent my own folly.

ted_b

  • World Citizen
  • ***
  • Posts: 117
Re: Importing Excel or CSV metadata to tag (multiple) albums
« Reply #53 on: September 04, 2013, 03:05:08 pm »

Very good point.  I just got off a conference call, and we are fixing the data.  Thanks!
Logged

ted_b

  • World Citizen
  • ***
  • Posts: 117
Re: Importing Excel or CSV metadata to tag (multiple) albums
« Reply #54 on: December 30, 2013, 12:08:13 pm »

Mr C, need a hopefully simple issue addressed.  Some of the small labels are sending Jared (Channel Classics) some of their own spreadsheets (we've successfully done his, several hundred, thank you again...), which I've taught him to move into CSV's, etc.  I have his perl running fine, TEXT-CSV installed, etc.  Howver, we keep getting this error message (and the mpl is created with nothging in it)
"No such file or directory at csv2mpl.pl line 18"  .  ??  Line 18, if I am correct, is looking for the music files?
Logged

MrC

  • Citizen of the Universe
  • *****
  • Posts: 10462
  • Your life is short. Give me your money.
Re: Importing Excel or CSV metadata to tag (multiple) albums
« Reply #55 on: December 30, 2013, 05:30:41 pm »

The error is stating that the file being passed on the command line is not correct or does not exist.  It should be a relative or full path to a CSV file.
Logged
The opinions I express represent my own folly.

ted_b

  • World Citizen
  • ***
  • Posts: 117
Re: Importing Excel or CSV metadata to tag (multiple) albums
« Reply #56 on: December 30, 2013, 06:54:04 pm »

Thanks for the response.  So you are saying that the script can't find the csv?  And the basepath location?  That is where the yet-to-be-tagged music files should be located, right?
Logged

MrC

  • Citizen of the Universe
  • *****
  • Posts: 10462
  • Your life is short. Give me your money.
Re: Importing Excel or CSV metadata to tag (multiple) albums
« Reply #57 on: December 30, 2013, 07:43:40 pm »

Your summary seems correct.
Logged
The opinions I express represent my own folly.

ted_b

  • World Citizen
  • ***
  • Posts: 117
Re: Importing Excel or CSV metadata to tag (multiple) albums
« Reply #58 on: December 30, 2013, 07:51:12 pm »

Thanks.  I teamviewed in to Jared's pc and tried a few things but none seem to work.  On a side note, the csvs he produces (Danish version of Excel) are semi-colon delimited!  Argh.  I fixed them, so this is not the issue, but it's another hurdle regardless.
Logged

MrC

  • Citizen of the Universe
  • *****
  • Posts: 10462
  • Your life is short. Give me your money.
Re: Importing Excel or CSV metadata to tag (multiple) albums
« Reply #59 on: December 30, 2013, 07:59:20 pm »

See if the same path does not work with any other command, such as:

   more path-to-CSV

If not, what path are you specifying?
Logged
The opinions I express represent my own folly.

ted_b

  • World Citizen
  • ***
  • Posts: 117
Re: Importing Excel or CSV metadata to tag (multiple) albums
« Reply #60 on: December 30, 2013, 08:12:05 pm »

mid of the night in Europe now, so will get on his pc again in am.  The path is nothing weird; it's like
perl csv2mpl.pl X:\dsf_csv\COBRA0036.csv >COBRA0036.mpl
where COBRA0036 is the name of the csv (as well as the name of the catalog # tag), and the files (in the basepath) are named like 01-COBRA0036.dsf, etc.
Logged
Pages: 1 [2]   Go Up