Re: iTunes Library

Thanks Rene, that looks like it covers all the strange characters I'm seeing. Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin On Wed, Apr 9, 2014 at 12:09 AM, René Micout wrote:

Re: iTunes Library

If it’s just for Apple, use Applescript to get the data out. Bob On Apr 7, 2014, at 18:41 , Peter Haworth wrote: > I'm looking to get information out of iTunes and store it into an SQL > database. There's an export function in iTunes that creates XML but it > create one XML block for each tr

Re: iTunes Library

Hello Peter, I have do that (I think it is not complete) : replace "√®" with "è" in vlListeAlbums replace "√º" with "ü" in vlListeAlbums replace "√©" with "é" in vlListeAlbums replace "√≥" with "ó" in vlListeAlbums replace "≈ì" with "œ" in vlListeAlbums replace "√â" with "É" in vl

Re: iTunes Library

Thanks for that Kay, I went with that approach and it took perhaps an hour to write the import script. I am however, whether I like it or not, having to get into the weird world of Unicode (I think). Some of the artist names and CD names in my iTunes library have accented characters which end up

Re: iTunes Library

Thanks, I'll see if I can find it. Pete lcSQL Software On Apr 7, 2014 7:06 PM, "PystCat" wrote: > Hey Pete, > > Check out Thomas McGrath's excellent work with iTunes in the user area... > Sorry... Not near a computer where I can look up the URL. I'm not sure if > you can access it through Live

Re: iTunes Library

Thanks, I'll check that out. Pete lcSQL Software On Apr 7, 2014 7:25 PM, "Kay C Lan" wrote: > On Tue, Apr 8, 2014 at 9:41 AM, Peter Haworth wrote: > > > There's an export function in iTunes that creates XML but it > > create one XML block for each track (the tracks have a unique ID), but no > >

Re: iTunes Library

I've heard that but haven't been able to locate the file. Judging by what's in the xml file, I have a feeling it won't be very normalized. Pete lcSQL Software On Apr 7, 2014 7:30 PM, "Richard Gaskin" wrote: > Isn't iTunes in SQLite format? > > -- > Richard Gaskin > Fourth World Systems > Sof

Re: iTunes Library

Isn't iTunes in SQLite format? -- Richard Gaskin Fourth World Systems Software Design and Development for Desktop, Mobile, and Web ambassa...@fourthworld.comhttp://www.FourthWorld.com _

Re: iTunes Library

On Tue, Apr 8, 2014 at 9:41 AM, Peter Haworth wrote: > There's an export function in iTunes that creates XML but it > create one XML block for each track (the tracks have a unique ID), but no > separate XML blocks for the Artists and CDs > > That would be the Export Library option. Have you had a

Re: iTunes Library

Hey Pete, Check out Thomas McGrath's excellent work with iTunes in the user area... Sorry... Not near a computer where I can look up the URL. I'm not sure if you can access it through LiveCode's user area anymore... I think that quietly died. Send a note if you can't find it... When I get back

iTunes Library

I'm looking to get information out of iTunes and store it into an SQL database. There's an export function in iTunes that creates XML but it create one XML block for each track (the tracks have a unique ID), but no separate XML blocks for the Artists and CDs I guess I could write some sort of scr