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.macm...@gmail.com> wrote: > On Tue, Apr 8, 2014 at 9:41 AM, Peter Haworth <p...@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@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
