VE4PER / Andy
ve4per at aim.com
Wed Jun 29 21:47:06 EDT 2011
Further to below, you might want to check and see if the same data is also
in the CUT table as well as the CART table, I believe they are joined.
In this case it would be something along the lines of SELECT all from
WHERE name pattern is like "###-.*.mp3" JOIN to CUT table then update
all with a cascade
update so that both tables get updated to drop both the track number and
the .mp3 extension.
I might be wrong and you may have to select from the cut table and join
to the cart table; depends which one has the
master primary key.
VE4PER / Andy wrote:
> OK Nathan, I understand now. I ran into the same problem with using
> rdimport of my library as well a few OS versions and Rd versions back as
> I wound up copying all the selections in a common folder, then RDimport
> from there. It worked fine for me, since I had chose to drop the track
> number on import; but like you it was in the artist --> album -->
> selection folder tree ... I had many suggestions from another forum
> I use to write a script to copy and rename all the selections based on
> the folder names etc etc.
> One suggestion you might look at for what you already have in your USB
> drive so far is put them all into a single folder, then run a script
> to drop all the ascii characters up to and including the first hyphen in
> the name copying it to a new folder with the new truncated filename.
> It is easy enough to do using a database like MS access, but I would
> suggest maybe one of the script gurus we have in the forum here might be
> able to come up with what you need to do that. Unfortunately, that same
> script would likely have to be incorporated into some sort of macro to
> rename the files in the dropbox before importing them; then again if
> something was left in the dropbox without a track number preceeding the
> filename it might create a problem, unless the script tested for it
> first I suppose.
> The other option might be to import it as is, and then run a query in
> the database, after the import to strip the leading track number from
> the the filename so it only shows what you want..... this option might
> be hard to automate on import, but would allow the automatic import
> as it is now, and then manually run the update query for all imported
> files when you go to adjust the other parameters for putting them into a
> log. If you add WHERE conditions in the original selection of the update
> query so that it looks for something like '###-*.mp3' which would mean
> select only those items from the table where the filename has that
> number sequence in the filename, then update it by adjusting the update
> statement to drop the three or four leading characters including the
> first hyphen. I am sorry I can't give you the exact SQL statement,
> because ACCESS SQL code and other flavors of SQL aren't always the same
> when it comes to doing these extras, but this should give you an idea of
> how you could proceed.
> In the database is fast, once you get the correct sql code; just save it
> and re-run it whenever you need to.
> Sorry I can't be of more help.
> Hope this is a help
> nathan.steele at thecrossfm.com wrote:
>> I believe they are all downloads from amazon, i-tunes, etc...., I'm
>> not downloading them, but that's the way they come in. I got a flash
>> drive full of files in folder by artist (also a pain). this is
>> somewhat quicker than importing one by one in rdlibrary because at
>> least some folders have more than one song in them, and I can just
>> have someone drop the files into the dropbox folder, let them ingest,
>> and then go set markers later.
>> On June 29, 2011 at 4:51 PM VE4PER / Andy<ve4per at aim.com> wrote:
>>> Hi Nathan,
>>> what did you use as a source to generate the file in the dropbox? did
>>> you just put an existing file into the dropbox manually? or did you use
>>> an app or a process to generate the dropbox contents and does it have an
>>> option to kill the track number when naming the original contents?
>>> many player-rippers autogenerate the track number for CD's but also many
>>> have the option to exclude the track number from the ripped filename.
>>> Unfortunately, I am not in an on air environment with sat feeds etc so
>>> not exactly sure what kind of a source you would be using.
>>> nathan.steele at thecrossfm.com wrote:
>>>> I setup and got working a dropbox, hooray for me. now when pulling
>>>> data from the file name, how do i ignore parts of it. say the file nam
>>>> is 01-title.mp3? Iwas able to do this %u-%t.%u, but this puts
>>>> things in the user defined field, yes I realize I told it to with %u,
>>>> but what I really want is to ignore the track number and .mp3
>>>> extension, the first time I tried, i had only the first %u and got
>>>> titles title.mp3 in my title field. I read the info in the user guide
>>>> and wiki but nothing about how to ignore a portion of the filenam (or
>>>> I am too dense to decipher it).
>>>> Also, any way to add a scheduler code while importing from the
>>>> dropbox? I tag the compressed files as LOSSY, and would like to also
>>>> add a tag to id the files as freshly imported, so they can be ID'ed
>>>> for setting markers, maybe with a code like NOMRK.
>>>> Rivendell-dev mailing list
>>>> Rivendell-dev at lists.rivendellaudio.org
>>> Rivendell-dev mailing list
>>> Rivendell-dev at lists.rivendellaudio.org
>> Rivendell-dev mailing list
>> Rivendell-dev at lists.rivendellaudio.org
> Rivendell-dev mailing list
> Rivendell-dev at lists.rivendellaudio.org
More information about the Rivendell-dev