{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":102,"n_cols":20,"rows_kept":102,"cut":false,"hidden":false,"merged":[[64,11,64,18],[33,11,33,18],[27,2,27,14],[1,2,1,14],[3,2,3,14],[5,2,5,14],[7,2,7,14],[26,2,26,9]]}
[]
[null,null,"This spreadsheet contains a macro to convert your music collection's ID3 tags\n into the database (db) used by the MITPlayer"]
[]
[null,null,"You can use it to (a) create a new db, or you can use it to (b) add new entries \nto an existing db, if you've received additional music files"]
[]
[null,null,"The steps are using a program to list your tags, \nthen running this spreadsheet's macro"]
[]
[null,null,"We urge you to read the documentation for a full explanation.  info.convert.id3.tags.to.mit.db is located on the MITPlayer site"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"A) Use mp3tag:"]
[null,null,"Download the free program from mp3tag.de/en/download.html"]
[null,null,"1) In the File Explorer, go to   %AppData%\\Mp3tag\\export   or   %USERPROFILE%\\Mp3tag\\export [type that in address bar] \n    (or C:\\Users\\[USER]\\AppData\\Roaming\\Mp3tag\\export or C:\\Users\\[USER]\\Mp3tag\\export)"]
[null,null,"2) Rename the file csv.mte as csv-orig.mte, and copy the csv-MIT.mte file that's available here on the MITPlayer site"]
[null,null,"3) Start mp3tag.  Navigate to open the topmost folder where all your dances are located"]
[null,null,"4) Click to include subdirectories"]
[null,null,"5) Click File/Export [or Cntl-E].  May need Select All [Cntl-A] to highlight all your files"]
[null,null,"6) Select csv and the location and name of the export file, then click OK"]
[null,null,null,"Again, we urge you to read the documentation for a full explanation:",null,null,null,null,null,null,null,"How to convert ID3 tags to a MIT database on the MITPlayer site"]
[]
[null,"B) Run the macro associated with this spreadsheet:"]
[null,null,"1) If received this file by download or email, you may get a one-time security warning"]
[null,null,"Click: Enable Editing"]
[]
[]
[]
[null,null,"And/or click: Enable Content "]
[]
[]
[null,null,"2) Click View, click Macros, then View Macros"]
[]
[]
[]
[]
[]
[null,null,"3) Click Run after selecting CopyToMIT"]
[]
[]
[]
[null,null,"4) First, open your existing MIT db if you have one"]
[null,null,"If you are starting fresh, without an existing db,"]
[null,null,"select the MITPlayer program executable instead"]
[]
[null,null,"5) Next, choose the .csv or .xlsx file containing your tag data"]
[]
[]
[]
[null,null,"6) Choose the file generation and"]
[null,null,"     reporting options you want",null,null,null,null,null,null,null,null,"Again, we urge you to read the documentation to understand options:"]
[null,null,null,null,null,null,null,null,null,null,null,"How to convert ID3 tags to a MIT database on the MITPlayer site",null,null,null,null,null,null,null,"[For Murray: edit/format text in formula bar]"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"7) The macro will run and create your new dance database. "]
[null,null,"    Pay attention to any error messages (such as needing to respell any dance names)."]
[null,null,"    The macro ends with a summary pop-up message that also identifies the location of a detailed report of actions taken and errors found."]
[]
[null,null,"8) Save your prior dance database, and store the new one (labeled *_new.txt) as your current one"]
[null,null,"    – either dance_data_int.txt or dance_data_isr.txt – in your main directory for the MITPlayer."]
[]
[null,null,"9) You can redo steps (A)+(B) any time you get more music files with ID3 tags.  "]
[null,null,"    Info for your existing dances will not be disrupted. "]
[]
[null,"C) If using this program to create a new MIT db"]
[null,null,"There are steps to set up the MITPlayer program to use a new database:"]
[null,null,"1) Do all the initial setup steps described in the New Users documentation to set up the Player from the MITPlayer site"]
[null,null,"2) If your group has a majority dance type (eg, Line, Couple, Strathspey), "]
[null,null,"    list that as the first Type Caption on your Options/Setup Screen [Cntl-I]. "]
[]
[]
[]
[]
[]
[null,null,"   The database created from your ID3 tags will all show that first type category."]
[null,null,"   Over time, you can recategorize the smaller minority of your dance repertoire."]