Thanks for the questions, you make me think further.
CONTEXT:
The mp3 files are not music file to be loaded permanently in a music library. Those are to be used within a sport event like a dancing competition. Each participants are to send their music file to the event organiser. Once they are ready to compete their music is being played. Those music files are only to exist for the duration of the event competition.
The need is to change what is displayed when looking at More Info under Get Info.
Title, Authors and Album are the metadata information to be modified by this AppleScript application.
Answering your questions:
-
The mp3 files are not to be loaded into the Music library, not at the moment. The Music application is only to be used to play them. If, at one point, being loaded in the Music Library it would only be for the time of the event competition. They are to be destroyed after completion of the event competition.
-
Music might not be the right application to be used for what I am trying to do.
-
These files are Music media type.
I do not know which application I should be using to modify the metadata of each music file. All music filenames are loaded in Numbers. Manupilation of the spreadsheet and once completed the metadata is to be modified. To do so, in Numbers I am going one row at a time to apply modification of the metadata.
I’ve changed my code to the following. However, I am getting an " Error: File not found -".
The file is there. Does someone have an idea why am I getting this error?
set folderpath to choose folder with prompt "Choose the folder containing the files to rename"
set myFolder to POSIX path of folderpath
--display dialog "myFolder: " & myFolder
tell application "Numbers"
-- In Numbers the first table is Table 1. It is hard to know this because the table most likely does not have its name appear, but the active sheet in a new Number file is Table 1. There can be multiple tables on a sheet. Therefore you need to designate the document (file) sheet, and table before you can access attributes
tell table 1 of active sheet of front document
-- For each row for the count of cells in the first column
repeat with i from 2 to count of cells of column 1
set NomFichierMusique to value of cell i of column "B" -- NomFichierMusiue
set newTitle to value of cell i of column "D" -- Titre
set newArtist to value of cell i of column "C" -- Catégorie
set newAlbum to value of cell i of column "E" -- Album
set MusicFilename to quoted form of (myFolder & (NomFichierMusique))
display dialog MusicFilename
do shell script "/usr/local/bin/exiftool -title='" & newTitle & "' -album='" & newAlbum & "' -artist='" & newArtist & "' " & quoted form of MusicFilename
end repeat
end tell
end tell