![]() Number (select 'Using locale' first and then select 'Number' and 'English (United States)' if your country does not use a. Now we need to change some data types but right clicking on the header of the column and choosing ‘Change Type’ and choosing the type you want to change to.Ĭhange these columns to the indicated types: To do this mouse over and click on the little cross icon in front ‘ChangedType’. We now need to delete the last step (we will redo it ourselves later on). Now select the ‘FirstRowAsHeader’ step and check the output. Make sure to select the correct delimiter (semicolon in my case) and make sure that ‘At each occurrence of the delimiter’ under ‘Split’ and click OK. Make sure the ‘Source’ step is still selected and then right click on the ‘Column1’ header and choose ‘Split Column’ à ‘By Delimiter…’ Now we need to split the column in by the semicolon delimiter. This already looks a lot better, doesn’t it? Then in the ‘Open file as’ drop down box select ‘Text File’ instead of ‘CSV Document’ and click OK. ![]() Click open the steps fly-out on the right and click the first step (Source) and click the icon right next to it. Now Power Query will do its best to give you what you want but as you can see it is not very successful (with the build available at the time of this writing).Īll is not lost however, because now we get to work with the magic of Power Query!įirst off, we need to get rid of all the errors we get in the data rows. Select the CSV file you just created and click OK. Open up Excel 2013, click on Power Query in the ribbon and select From File à From CSV. As a consequence the steps you need to take to get the data loaded may vary. If you followed along you will have a CSV file that contains the export of your music collection delimited by semicolons. Wait for a while and then click No to not display the export file. Then, return to Mp3tag, select your export configuration, set up the export file name and click OK. $loop(%_filename_ext%)%title% %artist% %album% %track% %year% %_length_seconds% %_file_size% %_file_mod_date% %_folderpath% %_filename_ext% %albumartist% %discnumber% %genre% %composer% %bpm% %_codec% %_bitrate% $filename(csv,utf-16)Title Artist Album Track Year Length Size Last Modified Path Filename AlbumArtist DiscNumber Genre Composer BPM Codec Bitrate Notepad will open and allow you to edit the export configuration.Īt this point you can copy and paste the code below into Notepad and hit save. Now, hit the first button on the right (the little page with a star to create a new export configuration and give it a name (I named mine “My CSV Export”) and click OK. Once Mp3tag has listed all your files (might take a while if you have a large collection), select all files (Edit àSelect all files or CTRL+A) and then choose File à Export (CTRL+E). To create the export with Mp3tag, open the program and navigate to where you music is stored (my collection sits on \192.168.1.9\Music, which is a folder on my server). If you use another tool (not Mp3tag) or already have an export file you would like to use skip to the next step. ![]() ![]() If you want to follow along in my step-by-step scenario I suggest installing Mp3tag.Īgain, please note that you do not have to follow these steps exactly. Of course you can use any other tool that has an export function, as long as you end up with something like a CSV. Keep reading if you want to know how and maybe rip mine. I created my own export file and I suggest you do too. It also comes with an export function to CSV, although it does not export enough to my taste. I particularly like Mp3tag ( ) which is free and is extensible. A lot of tools exist that enable you to work with these tags and fix them. If you are like me you have a digital music collection all nice and tidy complete with ID3 tags. Now, with Power BI being just around the corner I started thinking about taking on this old habit again. It all started back in the days of Pivot Viewer (At some point I was even part of a lustrous duo called ‘the Pivot Brothers’). ![]() Using Power BI to visualize your music collection ĭisclaimer: this post was written before I learned that pie charts are bad.Īs some of you might recall, I have been talking about visualizing digital music collections using Microsoft tools. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |