![]()
However, if I find there's enough interest from readers of this article in the entire database conversion process, I'll consider adding a future article to my website and explain this process more fully. The detail for that is **really** getting into the weeds of technical detail, so I won't bore you with that. Prior to importing the data into mySQL, I had to open each csv file in Excel and format certain columns of data in a specific way so that all the data could be added to mySQL in the proper format. Then for each of these csv files, I imported them into mySQL using phpMyAdmin. I needed to export both the albums table and tracks Name is confusing though, as what it's really doing is exporting to a comma separated value (csv), or Excel, file. The only one that made any sense for my purposes was exporting to text. If that sort of thing makes your eyes glaze over, feel free to skip it.Īs you know, Music Collector has several formats to which you can export your database. ![]() The next paragraph goes into a bit more technical detail about the conversion process. Suffice it to say though that it took a while to figure it all out. I won't bore you with all the technical details of that (well okay, some of them). (Excel), then converted the Excel to mySQL, which is similar to the conversion process I used with CD Trustee. At a high level, here's how I did it: I converted my Music Collector database to an intermediate format When it came to figuring out the logistics of converting my Music Collector database, loading it onto my website and then making coding changes based on the newĭatabase, that presented some challenges of its own. I needed to find a way to convert Music Collector's database in a similar way so that it would be transparent to any visitors to my site. It to a mySQL database, then use that database for displaying my collection in various ways on my website. One of the things I had done with it was to convert As you may or may not know, CD Trustee's back end database was done in Microsoft Access. #MUSIC COLLECTOR FOR WINDOWS SOFTWARE#That was a time consuming chore to be sure, but also a one time only change to each album.īesides having desktop software to keep track of my music collection, I also needed a database that I could load onto my website and use it the same way I had If I didn't do that, anyone who linked to collection items of mine from another website would find the links were either broken or pointed to the wrong item, and I certainly didn't want that. Since the database conversion process from CD Trustee to Music Collector reassigned all the album indexes and I have my database on my website, I also needed to edit each album and reassign its index back to what it was originally in CD Trustee. The two user defined fields in CD Trustee are also missing here so again, you'll have to create and populate user defined fields for each album that uses them. #MUSIC COLLECTOR FOR WINDOWS UPDATE#For example, if you want to keep track of items in your collection that you're willing to trade, you'll have to create a user defined field for that, then go into each album in Music Collector and individually update each trade item. Not a lot), depending on how you use Music Collector. In fact, they state on their website, "We don’t want you to lose all your hard work on your CD database." In truth though, you do lose some of your work (although That's obviously important to the Music Collector folks. To start with, the conversion of my CD Trustee database to Music Collector was very straightforward and easy. I decided to once again give Music Collector a try and bought the latest version of it. #MUSIC COLLECTOR FOR WINDOWS INSTALL#Trustee wouldn't install on it, so I was forced to change. #MUSIC COLLECTOR FOR WINDOWS WINDOWS 10#However, when I got my new Windows 10 PC shortly before Christmas of 2017, CD #MUSIC COLLECTOR FOR WINDOWS WINDOWS 7#When I upgraded to Windows 7 from Windows XP, CD Trustee lost some of its functionality (for example, searches would sometimes error out)īut for the most part, I could still use it so I continued to hobble along with it. I really had no desire to change.įlash forward a few years. After all, CD Trustee still worked just fine it was just no longer going I bought it, then decided I really didn't want to switch software. , in turn, offered their product at a discount to existingĬD Trustee customers. His company, product and customer base toĬ. I was a very happy customer of CD Trustee, so I was dismayed to learn a few years ago that Mike Paulick, CD Trustee's developer, was retiring. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |