iTunes Library

[Peter Haworth]

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 in the tab delimited file as
<not what the original character was>. The corrupted characters then end up
in my database.

I don't have any control over how iTunes exports the data so is it possible
for me to ensure that what ends up in my sqlite database is correct?  The
default text encoding for sqlite db's is UTF-8 but it can be changed to
UTF-16, UTF-16le, or UTF-16be.

Assuming that can be done, how do I make sure the artists names and album
names are correctly displayed in my fields/option menus/datagrids?  Let's
assume for now that I will not be using LC7 for this.

And finally, whatever happened to Esperanto?

Pete
lcSQL Software <http://www.lcsql.com>
Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>


On Mon, Apr 7, 2014 at 7:25 PM, Kay C Lan <lan.kc.macmail at gmail.com> wrote:

> On Tue, Apr 8, 2014 at 9:41 AM, Peter Haworth <pete at lcsql.com> 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 look at Export
> Playlist option, this creates a tab separated flat file. By setting up your
> playlist to include everything, and every column selected to view, you can
> export the entire library, but if you just want specific information, i.e.
> just music without movies or podcasts, and you don't care how many times
> the track has been played or what the Beats Per Minute are, then deselect
> these from the View Options, then sort by whatever column is appropriate.
> You can have as much or as little info as you need.
>
> Using LC to parse through the flat file is lightning fast.
>
> HTH
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>