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
On Nov 25, 2007 11:04 PM, Jeffrey Kaplan <[EMAIL PROTECTED]> wrote:
> On Wed, 21 Nov 2007 17:05:27 -0500 I said:
>
> > Well, this just isn't going to work. And it seems that the larger the
> > card I try, the worse it gets. The problem isn't the playing of the
> > music, the problem is getting the files onto the card.
>
> I want to apologize to anyone who took offence at my recent postings in
> this thread. No offence was meant, I in no way intended to be
> condescending to anyone. Looking back on the exchanges, I see that I
> did give that impression.
>
> I know this is no excuse, merely an explanation: I was getting
> frustrated with trying to get the Treo to behave in a way it clearly
> cannot, with respects to transferring hundreds of multimegabyte files
> via USB or MTP data transfer and desktop side software that will not
> overfill the available space.
>
> Now that I've had time to relax and review, I've taken another look at
> the suggestions that were made in good faith, and I'm going to go with
> using an external card reader for the transfer of music files, until
> such time as an eventual replacement for the Treo comes out where this
> can be done internally.
>
> To that end, I've ordered the Patriot 16G SDHC card from newegg.com, a
> stereo plug adapter from treocentral.com, and I'm trialling the latest
> version of PTunes Deluxe.
>
> If anyone wants, I can relate how it all comes together when I get the
> stuff. If no one wants, I'll understand and keep quiet about it.
>
> --
> Jeffrey Kaplan www.gordol.org
> The from userid is killfiled Send personal mail to gordol
>
> Peter's Top 100 Things I'd Do If I Ever Became An Evil Overlord, #88.
> If a group of henchmen fail miserably at a task, I will not berate them
> for incompetence then send the same group out to try the task again.
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
--
http://www.GearBits.com -- Tech. Culture. Ideas. Opinions.
