The DIR-created text file would also be useful in creating playlists
for a shoutcast server if you want to host the music at home and
stream it to your phone.
On Nov 26, 2007 8:08 PM, Craig Froehle <[EMAIL PROTECTED]> wrote:
> No worries, Jeffrey...and I'm sure folks would be interested in your
> solution if you come up with one.
>
> OK, since I'm no programmer, but do like to tinker, here's a very
> crude, but possibly effective way to do what you want:
>
> 1) Generate a text file of your music directory's contents using DOS'
> DIR command with switches such that you
> a) get full paths to each file
> b) get the filesize of each file
> c) get nothing else
>
> 2) Import the resulting text file into Excel as a tab-delimited file
> -- you should now have two columns: filenames (with path) and file
> sizes
>
> 3) reformat the filesizes so they are just numbers (expressed in KB or
> MB...doesn't matter as long as they're all the same units)
>
> 4) add a column to the left of the file names and put "=RND()" in each
> cell before a music file -- this is how we'll randomize
>
> 5) In the column to the right of the filesizes (column D for those of
> you playing at home), add this formula: =SUM($C$1:C1) and copy
> it down to the bottom of the list
>
> 6) In column E, put this formula: =CONCATENATE("copy ",B1,"
> F:\music\") and copy it down to the bottom of the list (modify
> "F:\music" to match the drive letter and directory on your SD card
> where you want the MP3 files to go)
>
> 7) Hit F9 a few times to gen new random numbers and then sort the
> whole worksheet by Column A
>
> 8) If you know how much space you can fill on your card (holding out a
> bunch of space for Palm use), select all the cells in column E, from
> the top, to the row where column D matches the space you can fill
>
> 9) open a text file named "runme.bat" and paste your clipboard into
> it. Save the text file, close the editor, and double-click it. If
> your SD card is in the reader, it should copy those files in your list
> over to \music\ on your card.
>
> I may have forgotten a step, but if you're handy with VBA (I'm not),
> you could easily modify this and have yourself a relatively simple
> solution. A better approach even would be to retain the original
> files' directory structure, but that would require some additional
> trickery (or extra concatenate statements).
>
> If anyone tries this, let me know how it goes. ;-D
--
==============================
War Eagle
