Turning Guitar Tabs into structured Data. Silicon crunching Metal.
I'm always looking for data from unlikely sources, especially sources that are close to my own bizarre (and predictable) interests. Anyone who grew up learning (or still plays) guitar at one point or another has probably used tablature at one time or another.
From the old Cherry Hill tab books of our favorite albums and artists, to the internet age where tens of thousands of plain-text format tabs because available all over the place (of varying levels of correctness at times).
I've been playing off and on for the past 21 years - more "on" lately than any time in recent memory.
So, I had an idea. What if I were to script out a way to crunch through an old school tab text file, split it up in a usable / logical way, and insert it all into a database so I can analyze and display it later via different methods. What would the data tell me?
- What if I could compile 100s of these files in this way?
- What could I do with the data once it was transformed?
- Would anyone even give a shit?
Well, I've taken the first step - both in the CRUNCHING side and on the VISUALIZING side.
First, the end product - we can save the technical shit for AFTER. As you can see from the shot above. I took a (mostly correct) guitar tab for Metallica's Enter Sandman from ultimate-guitar.com - crunched it, note-for-note, into a database table and built a "analytic report" (using the term very loosely) out of it using Tableau Public.
Link: Learning Enter Sandman with Visual Analytics
Now, on to the "how"...
If you look at my source tab, it's not that straightforward for computer reading with all the literal "3x", "12x" etc. I had to streamline it for line-by-line (and col-by-col) machine reading. You can see the original tab I started with here.
My "machine-friendly streamlined" version
?Metallica|Enter Sandman|The Black Album|http://tabs.ultimate-guitar.com/m/metallica/enter_sandman_tab.htm
+01 Intro:
#|
1|------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2|------------------------------------------------------------------------------------------------------------------------------------------------------------------------
3|------------------------------------------------------------------------------------------------------------------------------------------------------------------------
4|------------5---------------------------5---------------------------5---------------------------5---------------------------5---------------------------5---------------
5|--------7---------------7-----------7---------------7-----------7---------------7-----------7---------------7-----------7---------------7-----------7---------------7---
6|----0-----------6---5-----------0-----------6---5-----------0-----------6---5-----------0-----------6---5-----------0-----------6---5-----------0-----------6---5-------
#|
1|------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2|------------------------------------------------------------------------------------------------------------------------------------------------------------------------
3|------------------------------------------------------------------------------------------------------------------------------------------------------------------------
4|------------5---------------------------5---------------------------5---------------------------5---------------------------5---------------------------5---------------
5|--------7---------------7-----------7---------------7-----------7---------------7-----------7---------------7-----------7---------------7-----------7---------------7---
6|----0-----------6---5-----------0-----------6---5-----------0-----------6---5-----------0-----------6---5-----------0-----------6---5-----------0-----------6---5-------
+02 Rhythm Fill 1:
#| PM------------------- sl PM----------------------- sl PM----------------------- sl PM----------------------- sl PM--- PM------- P PM--- PM------- P PM--- PM------- P PM--- PM------- P
1|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
3|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
4|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
5|--2---------------------------/7------------------------------/7--------------------------------/7---------------------------------/7-----------7------------------3\2--------7------------------3\2--------7------------------3\2--------7------------------3\2
6|--0---0---0---0---0---0---0--------0---0---0---0---0---0---0---------0---0---0---0---0---0---0----------0---0---0---0---0---0---0-------0---0------6---0---0---0---1\00---0------6---0---0---0---1\00---0------6---0---0---0---1\00---0------6---0---0---0---1\0
#|PM--- PM--- P PM--- PM--- P PM--- PM--- P PM--- PM--- P PM--- PM--- P PM--- PM--- P PM--- PM--- P PM--- PM--- P
1|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
3|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
4|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
5|--------7-------------------3\2-----------7-------------------3\2-----------7-------------------3\2-----------7-------------------3\2-----------7-------------------3\2-----------7-------------------3\2-----------7-------------------3\2-----------7-------------------3\2---
6|0---0-------6---5---0---0---1\0---0---0-------6---5---0---0---1\0---0---0-------6---5---0---0---1\0---0---0-------6---5---0---0---1\0---0---0-------6---5---0---0---1\0---0---0-------6---5---0---0---1\0---0---0-------6---5---0---0---1\0---0---0-------6---5---0---0---1\0---
+03 Rhythm Fill 2:
#| sl V sl V sl V PM------------------- sl V sl V sl V PM-------------------
1|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
3|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
4|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
5|--2---2----/7-------------2---2----/7-------------2---2----/7--------------5-------5-------4---5---4--------2---2----/7-------------2---2----/7-------------2---2----/7--------------5-------5-------4---5---4------
6|--0---0---------6---5-----0---0---------6---5-----0---0---------6---5------3---0---3---0---2---3---2--------0---0---------6---5-----0---0---------6---5-----0---0---------6---5------3---0---3---0---2---3---2------
+04 Rhythm Fill 3:
#| PM------------------- P PM------------------------ P PM----------------------- PM------------
1|--------------------------------------------------------------------------------------------------------------------------------------------------------
2|--------------------------------------------------------------------------------------------------------------------------------------------------------
3|--------------------------------------------------------------------------------------------------------------------------------------------------------
4|--------------------------------------------------------------------------------------------------------------------------------------------------------
5|--2----------------------------3\2-------------------------------3\2-----------------------------------------5-------5-------4---5---4------------------
6|--0---0---0---0---0---0---0----1\0---0---0---0---0---0---0---0---1\0----------0---0---0---0---0---0---0------3---0---3---0---2---3---2------------------
#| PM------------------- P PM------------------------ P PM----------------------- PM------------
1|--------------------------------------------------------------------------------------------------------------------------------------------------------
2|--------------------------------------------------------------------------------------------------------------------------------------------------------
3|--------------------------------------------------------------------------------------------------------------------------------------------------------
4|--------------------------------------------------------------------------------------------------------------------------------------------------------
5|--2----------------------------3\2-------------------------------3\2-----------------------------------------5-------5-------4---5---4------------------
6|--0---0---0---0---0---0---0----1\0---0---0---0---0---0---0---0---1\0----------0---0---0---0---0---0---0------3---0---3---0---2---3---2------------------
+05 Bridge:
#| PM---------------------------
1|------------------------------------------------------------------------------------------------------------------------
2|------------------------------------------------------------------------------------------------------------------------
3|---------2---------------------2---------------------2------------------------------------------------------------------
4|-----4---------------------4---------------------4----------------------------------------------------------------------
5|-------------3---2-----------------3---2-----------------3---2-------4---4---4---4---4---2---3---4----------------------
6|--2---------------------2---------------------2----------------------2---2---2---2---2---0---1---2----------------------
+06 Chorus Fill:
#| PM------------
1|----------------------------------------------------------------------------
2|----------------------------------------------------------------------------
3|----------------------------------------------------------------2-----------
4|------5---4---------5---4---------5---4---------5---2---5---2-------2-------
5|--4---3---2-----4---3---2-----4---3---2----2--------------------------------
6|--2-------------2-------------2------------0--------------------------------
#| PM----------- PM-----------
1|----------------------------------------------------------------------------
2|----------------------------------------------------------------------------
3|------------------------------------2---------------------------------------
4|------5---4---------5---2---5---2-------2-----------------------------------
5|--4---3---2-----2----------------------------5-------5-------4---5---5------
6|--2-------------0----------------------------3---0---3---0---2---3---3------
+07 Rhythm Fill 2:
#| sl V sl V sl V PM------------------- sl V sl V sl V PM-------------------
1|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
3|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
4|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
5|--2---2----/7-------------2---2----/7-------------2---2----/7--------------5-------5-------4---5---4--------2---2----/7-------------2---2----/7-------------2---2----/7--------------5-------5-------4---5---4------
6|--0---0---------6---5-----0---0---------6---5-----0---0---------6---5------3---0---3---0---2---3---2--------0---0---------6---5-----0---0---------6---5-----0---0---------6---5------3---0---3---0---2---3---2------
+08 Rhythm Fill 3:
#| PM------------------- P PM------------------------ P PM----------------------- PM------------
1|--------------------------------------------------------------------------------------------------------------------------------------------------------
2|--------------------------------------------------------------------------------------------------------------------------------------------------------
3|--------------------------------------------------------------------------------------------------------------------------------------------------------
4|--------------------------------------------------------------------------------------------------------------------------------------------------------
5|--2----------------------------3\2-------------------------------3\2-----------------------------------------5-------5-------4---5---4------------------
6|--0---0---0---0---0---0---0----1\0---0---0---0---0---0---0---0---1\0----------0---0---0---0---0---0---0------3---0---3---0---2---3---2------------------
#| PM------------------- P PM------------------------ P PM----------------------- PM------------
1|--------------------------------------------------------------------------------------------------------------------------------------------------------
2|--------------------------------------------------------------------------------------------------------------------------------------------------------
3|--------------------------------------------------------------------------------------------------------------------------------------------------------
4|--------------------------------------------------------------------------------------------------------------------------------------------------------
5|--2----------------------------3\2-------------------------------3\2-----------------------------------------5-------5-------4---5---4------------------
6|--0---0---0---0---0---0---0----1\0---0---0---0---0---0---0---0---1\0----------0---0---0---0---0---0---0------3---0---3---0---2---3---2------------------
+09 Bridge:
#| PM---------------------------
1|------------------------------------------------------------------------------------------------------------------------
2|------------------------------------------------------------------------------------------------------------------------
3|---------2---------------------2---------------------2------------------------------------------------------------------
4|-----4---------------------4---------------------4----------------------------------------------------------------------
5|-------------3---2-----------------3---2-----------------3---2-------4---4---4---4---4---2---3---4----------------------
6|--2---------------------2---------------------2----------------------2---2---2---2---2---0---1---2----------------------
+10 Chorus Fill:
#| PM------------
1|----------------------------------------------------------------------------
2|----------------------------------------------------------------------------
3|----------------------------------------------------------------2-----------
4|------5---4---------5---4---------5---4---------5---2---5---2-------2-------
5|--4---3---2-----4---3---2-----4---3---2----2--------------------------------
6|--2-------------2-------------2------------0--------------------------------
#| PM----------- PM-----------
1|----------------------------------------------------------------------------
2|----------------------------------------------------------------------------
3|------------------------------------2---------------------------------------
4|------5---4---------5---2---5---2-------2-----------------------------------
5|--4---3---2-----2----------------------------5-------5-------4---5---5------
6|--2-------------0----------------------------3---0---3---0---2---3---3------
+11 Solo
#|
1|-------------------------------------------------------------
2|-15-15-15-12----12---------------12-12----15b17-15b17-(15)\--
3|-------------14-----14b16---(14)-------14--------------------
4|-------------------------------------------------------------
5|-------------------------------------------------------------
6|-------------------------------------------------------------
#|
1|--------------------------------------------------
2|--------------------------------------------------
3|-12/14-14-14-14\12-12-12-12/14-14-14-14\12-12-12--
4|--------------------------------------------------
5|--------------------------------------------------
6|--------------------------------------------------
#|
1|------------------------------------------
2|------------------------------------------
3|-14p12------------------------------------
4|-------14--14p12--------------------------
5|-----------------14--14p12\10-------------
6|------------------------------12-~-(12)\--
#|
1|-------12-12-12-------12-12-12-------12-12-12-------12-12-12--
2|-15b17----------15b17----------15b17----------15b17-----------
3|--------------------------------------------------------------
4|--------------------------------------------------------------
5|--------------------------------------------------------------
6|--------------------------------------------------------------
#|
1|-------12-12-12h15p12-12h15p12-12h15p12-12-15-12-12-14-14--
2|-15b17-----------------------------------------------------
3|-----------------------------------------------------------
4|-----------------------------------------------------------
5|-----------------------------------------------------------
6|-----------------------------------------------------------
#|
1|-17p14----17p14----17p14-19p15----19p15----19p15--
2|-------15-------15-------------17-------17--------
3|--------------------------------------------------
4|--------------------------------------------------
5|--------------------------------------------------
6|--------------------------------------------------
#|
1|-21p17----21p17----21p17----22b24-(22)\-------------------------
2|-------17-------17-------17-------------9b10---(9)---9b10---9---
3|----------------------------------------9b11---(9)---9b11---9---
4|----------------------------------------------------------------
5|----------------------------------------------------------------
6|----------------------------------------------------------------
#|
1|-------------------------------------------------------------------
2|-9b10--9b10-----------------10---(10)----10-8-7---8\7---7----------
3|-9b11--9b11--7--9--------7----------------------9-----9---9-7---7--
4|--------------------7h9---------------------------------------9----
5|-------------------------------------------------------------------
6|-------------------------------------------------------------------
#|
1|------------------------------------------------------------------
2|------------------------------------------------------------------
3|-9p7---------------------------16b18-14-----14-16b18--14------14--
4|-----9p7---7-9-7------------------------16----------------16------
5|---------9-------9-8-7--------------------------------------------
6|-----------------------10-7\--------------------------------------
#|
1|------------------------------------
2|------------------------------------
3|-16b18-14----14-16b18-14--------14--
4|----------16-------------16--16-----
5|------------------------------------
6|------------------------------------
#|
1|-----------------------------------------------------------------------
2|-------17-------17------------17---------------------------------------
3|-16b18----16b18----16b18---------16b18---(16)-\1/-\1/-\1/-\1/-\1/-\1/--
4|-----------------------------------------------------------------------
5|----------------------------------------------accentuate-w/bar---------
6|-----------------------------------------------------------------------
#|
1|-21p17----21p17----21p17----21p17----21p17----21p17-----
2|-------17-------17-------17-------17-------17-------17--
3|--------------------------------------------------------
4|--------------------------------------------------------
5|--------------------------------------------------------
6|--------------------------------------------------------
#|
1|-22b24--22-22-22b24--22-22-22b24-~-~-(22)\--
2|--------------------------------------------
3|--------------------------------------------
4|--------------------------------------------
5|--------------------------------------------
6|--------------------------------------------
#|
1|--------------------------------------------------------
2|-10p8p7-------------------------------------------------
3|--------9--9p7------------------------------------------
4|---------------9--9p7-5--7b9---5------------------------
5|----------------------------------7---(7)-~-~-~----5h7--
6|------------------------------------------w/bar---------
#|
1|------------------------------------------------------
2|------------------------------------------------------
3|------------------------------------------------------
4|------------------------------------------------------
5|-4---(4)-~-~-~-~-----0----2--\1/-\1/-\1/-\1/-\1/-\1/--
6|------------------------------------------------------
+12 Prayer Intro:
#|
1|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
3|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
4|------------5---------------------------5---------------------------5---------------------------5---------------------------5---------------------------5---------------------------5---------------------------5---------------
5|--------7---------------7-----------7---------------7-----------7---------------7-----------7---------------7-----------7---------------7-----------7---------------7-----------7---------------7-----------7---------------7---
6|----0-----------6---5-----------0-----------6---5-----------0-----------6---5-----------0-----------6---5-----------0-----------6---5-----------0-----------6---5-----------0-----------6---5-----------0-----------6---5-------
+13 Bridge:
#| PM--------------------------- PM---------------------------
1|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
3|---------2---------------------2---------------------2----------------------2----------------------2---------------------2----------------------------------------------------------------
4|-----4---------------------4---------------------4----------------------4----------------------4---------------------4--------------------------------------------------------------------
5|-------------3---2-----------------3---2-----------------3---2------------------3---2------------------3---2-----------------3---2-----4---4---4---4---4---2---3---4----------------------
6|--2---------------------2---------------------2----------------------2----------------------2---------------------2--------------------2---2---2---2---2---0---1---2----------------------
+14 Chorus Fill:
#| PM------------ PM------------
1|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
3|----------------------------------------------------------------2--------------------------------------------------------------------------------------------------------------2------
4|------5---4---------5---4---------5---4---------5---2---5---2-------2--------5---4-----------------------------------5---4---------5---4---------5---4---------5---2---5---2-------2--
5|--4---3---2-----4---3---2-----4---3---2----2-----------------------------4---3---2-----2-------------------------4---3---2-----4---3---2-----4---3---2----2---------------------------
6|--2-------------2-------------2------------0-----------------------------2-------------0-------------------------2-------------2-------------2------------0---------------------------
#| PM----------- PM-----------
1|----------------------------------------------------------------------------
2|----------------------------------------------------------------------------
3|------------------------------------2---------------------------------------
4|------5---4---------5---2---5---2-------2-----------------------------------
5|--4---3---2-----2----------------------------5-------5-------4---5---5--2---
6|--2-------------0----------------------------3---0---3---0---2---3---3--0---
+15 Rhythm Fill 2:
#| sl V sl V BOOOM! sl V sl V sl V sl V sl V PM-------------------
1|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
3|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
4|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
5|--2---2----/7-------------2---2----/7-------------2---2----/7-------------2---2----/7-------------2---2----/7-------------2---2----/7-------------2---2----/7--------------5-------5-------4---5---4------
6|--0---0---------6---5-----0---0---------6---5-----0---0---------6---5-----0---0---------6---5-----0---0---------6---5-----0---0---------6---5-----0---0---------6---5------3---0---3---0---2---3---2------
+16 Outro:
#| PM PM--- P PM---------------------- P PM---------------------- P PM---------------------- P
1|--------------------------------------------------------------------------------------------------------------------------------------------
2|--------------------------------------------------------------------------------------------------------------------------------------------
3|--------------------------------------------------------------------------------------------------------------------------------------------
4|--------------------------------------------------------------------------------------------------------------------------------------------
5|--2-------7-------------------3\2-----------7------------------3\2-----------7------------------3\2-----------7------------------3\2--------
6|--0---0-------6---5---0---0---1\0---0---0------6---5---0---0---1\0---0---0------6---5---0---0---1\0---0---0------6---5---0---0---1\0--------
#| PM--- PM------- P PM--- PM------- P PM--- PM------- P PM--- PM------- P PM--------------------------- PM--------------------------- PM--------------------------- PM---------------------------
1|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
3|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
4|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
5|----------7------------------3\2-------------7------------------3\2-------------7------------------3\2-------------7------------------3\2-------------7-------------------------------7-------------------------------7-------------------------------7---------------------------
6|--0---0------6---0---0---0---1\0-----0---0------6---0---0---0---1\0-----0---0------6---0---0---0---1\0-----0---0------6---0---0---0---1\0-----0---0-------0---0---0---0---0---0---0-------0---0---0---0---0---0---0-------0---0---0---0---0---0---0-------0---0---0---0---0-------
#| PM-------------------------------
1|----------------------------------------------------------------------------
2|----------------------------------------------------------------------------
3|----------------------------------------------------------------------------
4|----------------------------------------------------------------------------
5|----------------------------------------------------------------------------
6|--0---0---0---0---0---0---0---0---0-----------------------------------------
+01 Intro:
#|
1|------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2|------------------------------------------------------------------------------------------------------------------------------------------------------------------------
3|------------------------------------------------------------------------------------------------------------------------------------------------------------------------
4|------------5---------------------------5---------------------------5---------------------------5---------------------------5---------------------------5---------------
5|--------7---------------7-----------7---------------7-----------7---------------7-----------7---------------7-----------7---------------7-----------7---------------7---
6|----0-----------6---5-----------0-----------6---5-----------0-----------6---5-----------0-----------6---5-----------0-----------6---5-----------0-----------6---5-------
#|
1|------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2|------------------------------------------------------------------------------------------------------------------------------------------------------------------------
3|------------------------------------------------------------------------------------------------------------------------------------------------------------------------
4|------------5---------------------------5---------------------------5---------------------------5---------------------------5---------------------------5---------------
5|--------7---------------7-----------7---------------7-----------7---------------7-----------7---------------7-----------7---------------7-----------7---------------7---
6|----0-----------6---5-----------0-----------6---5-----------0-----------6---5-----------0-----------6---5-----------0-----------6---5-----------0-----------6---5-------
+02 Rhythm Fill 1:
#| PM------------------- sl PM----------------------- sl PM----------------------- sl PM----------------------- sl PM--- PM------- P PM--- PM------- P PM--- PM------- P PM--- PM------- P
1|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
3|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
4|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
5|--2---------------------------/7------------------------------/7--------------------------------/7---------------------------------/7-----------7------------------3\2--------7------------------3\2--------7------------------3\2--------7------------------3\2
6|--0---0---0---0---0---0---0--------0---0---0---0---0---0---0---------0---0---0---0---0---0---0----------0---0---0---0---0---0---0-------0---0------6---0---0---0---1\00---0------6---0---0---0---1\00---0------6---0---0---0---1\00---0------6---0---0---0---1\0
#|PM--- PM--- P PM--- PM--- P PM--- PM--- P PM--- PM--- P PM--- PM--- P PM--- PM--- P PM--- PM--- P PM--- PM--- P
1|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
3|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
4|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
5|--------7-------------------3\2-----------7-------------------3\2-----------7-------------------3\2-----------7-------------------3\2-----------7-------------------3\2-----------7-------------------3\2-----------7-------------------3\2-----------7-------------------3\2---
6|0---0-------6---5---0---0---1\0---0---0-------6---5---0---0---1\0---0---0-------6---5---0---0---1\0---0---0-------6---5---0---0---1\0---0---0-------6---5---0---0---1\0---0---0-------6---5---0---0---1\0---0---0-------6---5---0---0---1\0---0---0-------6---5---0---0---1\0---
+03 Rhythm Fill 2:
#| sl V sl V sl V PM------------------- sl V sl V sl V PM-------------------
1|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
3|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
4|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
5|--2---2----/7-------------2---2----/7-------------2---2----/7--------------5-------5-------4---5---4--------2---2----/7-------------2---2----/7-------------2---2----/7--------------5-------5-------4---5---4------
6|--0---0---------6---5-----0---0---------6---5-----0---0---------6---5------3---0---3---0---2---3---2--------0---0---------6---5-----0---0---------6---5-----0---0---------6---5------3---0---3---0---2---3---2------
+04 Rhythm Fill 3:
#| PM------------------- P PM------------------------ P PM----------------------- PM------------
1|--------------------------------------------------------------------------------------------------------------------------------------------------------
2|--------------------------------------------------------------------------------------------------------------------------------------------------------
3|--------------------------------------------------------------------------------------------------------------------------------------------------------
4|--------------------------------------------------------------------------------------------------------------------------------------------------------
5|--2----------------------------3\2-------------------------------3\2-----------------------------------------5-------5-------4---5---4------------------
6|--0---0---0---0---0---0---0----1\0---0---0---0---0---0---0---0---1\0----------0---0---0---0---0---0---0------3---0---3---0---2---3---2------------------
#| PM------------------- P PM------------------------ P PM----------------------- PM------------
1|--------------------------------------------------------------------------------------------------------------------------------------------------------
2|--------------------------------------------------------------------------------------------------------------------------------------------------------
3|--------------------------------------------------------------------------------------------------------------------------------------------------------
4|--------------------------------------------------------------------------------------------------------------------------------------------------------
5|--2----------------------------3\2-------------------------------3\2-----------------------------------------5-------5-------4---5---4------------------
6|--0---0---0---0---0---0---0----1\0---0---0---0---0---0---0---0---1\0----------0---0---0---0---0---0---0------3---0---3---0---2---3---2------------------
+05 Bridge:
#| PM---------------------------
1|------------------------------------------------------------------------------------------------------------------------
2|------------------------------------------------------------------------------------------------------------------------
3|---------2---------------------2---------------------2------------------------------------------------------------------
4|-----4---------------------4---------------------4----------------------------------------------------------------------
5|-------------3---2-----------------3---2-----------------3---2-------4---4---4---4---4---2---3---4----------------------
6|--2---------------------2---------------------2----------------------2---2---2---2---2---0---1---2----------------------
+06 Chorus Fill:
#| PM------------
1|----------------------------------------------------------------------------
2|----------------------------------------------------------------------------
3|----------------------------------------------------------------2-----------
4|------5---4---------5---4---------5---4---------5---2---5---2-------2-------
5|--4---3---2-----4---3---2-----4---3---2----2--------------------------------
6|--2-------------2-------------2------------0--------------------------------
#| PM----------- PM-----------
1|----------------------------------------------------------------------------
2|----------------------------------------------------------------------------
3|------------------------------------2---------------------------------------
4|------5---4---------5---2---5---2-------2-----------------------------------
5|--4---3---2-----2----------------------------5-------5-------4---5---5------
6|--2-------------0----------------------------3---0---3---0---2---3---3------
+07 Rhythm Fill 2:
#| sl V sl V sl V PM------------------- sl V sl V sl V PM-------------------
1|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
3|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
4|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
5|--2---2----/7-------------2---2----/7-------------2---2----/7--------------5-------5-------4---5---4--------2---2----/7-------------2---2----/7-------------2---2----/7--------------5-------5-------4---5---4------
6|--0---0---------6---5-----0---0---------6---5-----0---0---------6---5------3---0---3---0---2---3---2--------0---0---------6---5-----0---0---------6---5-----0---0---------6---5------3---0---3---0---2---3---2------
+08 Rhythm Fill 3:
#| PM------------------- P PM------------------------ P PM----------------------- PM------------
1|--------------------------------------------------------------------------------------------------------------------------------------------------------
2|--------------------------------------------------------------------------------------------------------------------------------------------------------
3|--------------------------------------------------------------------------------------------------------------------------------------------------------
4|--------------------------------------------------------------------------------------------------------------------------------------------------------
5|--2----------------------------3\2-------------------------------3\2-----------------------------------------5-------5-------4---5---4------------------
6|--0---0---0---0---0---0---0----1\0---0---0---0---0---0---0---0---1\0----------0---0---0---0---0---0---0------3---0---3---0---2---3---2------------------
#| PM------------------- P PM------------------------ P PM----------------------- PM------------
1|--------------------------------------------------------------------------------------------------------------------------------------------------------
2|--------------------------------------------------------------------------------------------------------------------------------------------------------
3|--------------------------------------------------------------------------------------------------------------------------------------------------------
4|--------------------------------------------------------------------------------------------------------------------------------------------------------
5|--2----------------------------3\2-------------------------------3\2-----------------------------------------5-------5-------4---5---4------------------
6|--0---0---0---0---0---0---0----1\0---0---0---0---0---0---0---0---1\0----------0---0---0---0---0---0---0------3---0---3---0---2---3---2------------------
+09 Bridge:
#| PM---------------------------
1|------------------------------------------------------------------------------------------------------------------------
2|------------------------------------------------------------------------------------------------------------------------
3|---------2---------------------2---------------------2------------------------------------------------------------------
4|-----4---------------------4---------------------4----------------------------------------------------------------------
5|-------------3---2-----------------3---2-----------------3---2-------4---4---4---4---4---2---3---4----------------------
6|--2---------------------2---------------------2----------------------2---2---2---2---2---0---1---2----------------------
+10 Chorus Fill:
#| PM------------
1|----------------------------------------------------------------------------
2|----------------------------------------------------------------------------
3|----------------------------------------------------------------2-----------
4|------5---4---------5---4---------5---4---------5---2---5---2-------2-------
5|--4---3---2-----4---3---2-----4---3---2----2--------------------------------
6|--2-------------2-------------2------------0--------------------------------
#| PM----------- PM-----------
1|----------------------------------------------------------------------------
2|----------------------------------------------------------------------------
3|------------------------------------2---------------------------------------
4|------5---4---------5---2---5---2-------2-----------------------------------
5|--4---3---2-----2----------------------------5-------5-------4---5---5------
6|--2-------------0----------------------------3---0---3---0---2---3---3------
+11 Solo
#|
1|-------------------------------------------------------------
2|-15-15-15-12----12---------------12-12----15b17-15b17-(15)\--
3|-------------14-----14b16---(14)-------14--------------------
4|-------------------------------------------------------------
5|-------------------------------------------------------------
6|-------------------------------------------------------------
#|
1|--------------------------------------------------
2|--------------------------------------------------
3|-12/14-14-14-14\12-12-12-12/14-14-14-14\12-12-12--
4|--------------------------------------------------
5|--------------------------------------------------
6|--------------------------------------------------
#|
1|------------------------------------------
2|------------------------------------------
3|-14p12------------------------------------
4|-------14--14p12--------------------------
5|-----------------14--14p12\10-------------
6|------------------------------12-~-(12)\--
#|
1|-------12-12-12-------12-12-12-------12-12-12-------12-12-12--
2|-15b17----------15b17----------15b17----------15b17-----------
3|--------------------------------------------------------------
4|--------------------------------------------------------------
5|--------------------------------------------------------------
6|--------------------------------------------------------------
#|
1|-------12-12-12h15p12-12h15p12-12h15p12-12-15-12-12-14-14--
2|-15b17-----------------------------------------------------
3|-----------------------------------------------------------
4|-----------------------------------------------------------
5|-----------------------------------------------------------
6|-----------------------------------------------------------
#|
1|-17p14----17p14----17p14-19p15----19p15----19p15--
2|-------15-------15-------------17-------17--------
3|--------------------------------------------------
4|--------------------------------------------------
5|--------------------------------------------------
6|--------------------------------------------------
#|
1|-21p17----21p17----21p17----22b24-(22)\-------------------------
2|-------17-------17-------17-------------9b10---(9)---9b10---9---
3|----------------------------------------9b11---(9)---9b11---9---
4|----------------------------------------------------------------
5|----------------------------------------------------------------
6|----------------------------------------------------------------
#|
1|-------------------------------------------------------------------
2|-9b10--9b10-----------------10---(10)----10-8-7---8\7---7----------
3|-9b11--9b11--7--9--------7----------------------9-----9---9-7---7--
4|--------------------7h9---------------------------------------9----
5|-------------------------------------------------------------------
6|-------------------------------------------------------------------
#|
1|------------------------------------------------------------------
2|------------------------------------------------------------------
3|-9p7---------------------------16b18-14-----14-16b18--14------14--
4|-----9p7---7-9-7------------------------16----------------16------
5|---------9-------9-8-7--------------------------------------------
6|-----------------------10-7\--------------------------------------
#|
1|------------------------------------
2|------------------------------------
3|-16b18-14----14-16b18-14--------14--
4|----------16-------------16--16-----
5|------------------------------------
6|------------------------------------
#|
1|-----------------------------------------------------------------------
2|-------17-------17------------17---------------------------------------
3|-16b18----16b18----16b18---------16b18---(16)-\1/-\1/-\1/-\1/-\1/-\1/--
4|-----------------------------------------------------------------------
5|----------------------------------------------accentuate-w/bar---------
6|-----------------------------------------------------------------------
#|
1|-21p17----21p17----21p17----21p17----21p17----21p17-----
2|-------17-------17-------17-------17-------17-------17--
3|--------------------------------------------------------
4|--------------------------------------------------------
5|--------------------------------------------------------
6|--------------------------------------------------------
#|
1|-22b24--22-22-22b24--22-22-22b24-~-~-(22)\--
2|--------------------------------------------
3|--------------------------------------------
4|--------------------------------------------
5|--------------------------------------------
6|--------------------------------------------
#|
1|--------------------------------------------------------
2|-10p8p7-------------------------------------------------
3|--------9--9p7------------------------------------------
4|---------------9--9p7-5--7b9---5------------------------
5|----------------------------------7---(7)-~-~-~----5h7--
6|------------------------------------------w/bar---------
#|
1|------------------------------------------------------
2|------------------------------------------------------
3|------------------------------------------------------
4|------------------------------------------------------
5|-4---(4)-~-~-~-~-----0----2--\1/-\1/-\1/-\1/-\1/-\1/--
6|------------------------------------------------------
+12 Prayer Intro:
#|
1|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
3|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
4|------------5---------------------------5---------------------------5---------------------------5---------------------------5---------------------------5---------------------------5---------------------------5---------------
5|--------7---------------7-----------7---------------7-----------7---------------7-----------7---------------7-----------7---------------7-----------7---------------7-----------7---------------7-----------7---------------7---
6|----0-----------6---5-----------0-----------6---5-----------0-----------6---5-----------0-----------6---5-----------0-----------6---5-----------0-----------6---5-----------0-----------6---5-----------0-----------6---5-------
+13 Bridge:
#| PM--------------------------- PM---------------------------
1|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
3|---------2---------------------2---------------------2----------------------2----------------------2---------------------2----------------------------------------------------------------
4|-----4---------------------4---------------------4----------------------4----------------------4---------------------4--------------------------------------------------------------------
5|-------------3---2-----------------3---2-----------------3---2------------------3---2------------------3---2-----------------3---2-----4---4---4---4---4---2---3---4----------------------
6|--2---------------------2---------------------2----------------------2----------------------2---------------------2--------------------2---2---2---2---2---0---1---2----------------------
+14 Chorus Fill:
#| PM------------ PM------------
1|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
3|----------------------------------------------------------------2--------------------------------------------------------------------------------------------------------------2------
4|------5---4---------5---4---------5---4---------5---2---5---2-------2--------5---4-----------------------------------5---4---------5---4---------5---4---------5---2---5---2-------2--
5|--4---3---2-----4---3---2-----4---3---2----2-----------------------------4---3---2-----2-------------------------4---3---2-----4---3---2-----4---3---2----2---------------------------
6|--2-------------2-------------2------------0-----------------------------2-------------0-------------------------2-------------2-------------2------------0---------------------------
#| PM----------- PM-----------
1|----------------------------------------------------------------------------
2|----------------------------------------------------------------------------
3|------------------------------------2---------------------------------------
4|------5---4---------5---2---5---2-------2-----------------------------------
5|--4---3---2-----2----------------------------5-------5-------4---5---5--2---
6|--2-------------0----------------------------3---0---3---0---2---3---3--0---
+15 Rhythm Fill 2:
#| sl V sl V BOOOM! sl V sl V sl V sl V sl V PM-------------------
1|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
3|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
4|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
5|--2---2----/7-------------2---2----/7-------------2---2----/7-------------2---2----/7-------------2---2----/7-------------2---2----/7-------------2---2----/7--------------5-------5-------4---5---4------
6|--0---0---------6---5-----0---0---------6---5-----0---0---------6---5-----0---0---------6---5-----0---0---------6---5-----0---0---------6---5-----0---0---------6---5------3---0---3---0---2---3---2------
+16 Outro:
#| PM PM--- P PM---------------------- P PM---------------------- P PM---------------------- P
1|--------------------------------------------------------------------------------------------------------------------------------------------
2|--------------------------------------------------------------------------------------------------------------------------------------------
3|--------------------------------------------------------------------------------------------------------------------------------------------
4|--------------------------------------------------------------------------------------------------------------------------------------------
5|--2-------7-------------------3\2-----------7------------------3\2-----------7------------------3\2-----------7------------------3\2--------
6|--0---0-------6---5---0---0---1\0---0---0------6---5---0---0---1\0---0---0------6---5---0---0---1\0---0---0------6---5---0---0---1\0--------
#| PM--- PM------- P PM--- PM------- P PM--- PM------- P PM--- PM------- P PM--------------------------- PM--------------------------- PM--------------------------- PM---------------------------
1|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
3|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
4|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
5|----------7------------------3\2-------------7------------------3\2-------------7------------------3\2-------------7------------------3\2-------------7-------------------------------7-------------------------------7-------------------------------7---------------------------
6|--0---0------6---0---0---0---1\0-----0---0------6---0---0---0---1\0-----0---0------6---0---0---0---1\0-----0---0------6---0---0---0---1\0-----0---0-------0---0---0---0---0---0---0-------0---0---0---0---0---0---0-------0---0---0---0---0---0---0-------0---0---0---0---0-------
#| PM-------------------------------
1|----------------------------------------------------------------------------
2|----------------------------------------------------------------------------
3|----------------------------------------------------------------------------
4|----------------------------------------------------------------------------
5|----------------------------------------------------------------------------
6|--0---0---0---0---0---0---0---0---0-----------------------------------------
Note that I repeated sections where it was needed and evened out all the whitespace in regards to PalmMuting, slide, etc notations.
I also created a tagging system for both what "part" we were on as well as the sequence of that part (really important for re-ordering data in a viz, especially when you have repeating "parts" that may or may not be EXACTLY the same). Which made things slightly more complicated than I anticipated, but not much.
The cool thing about sequencing LINEAR rhythm parts (no multi-part overlapping yet, including solos) is that you can build Gantt charts out of it - and they actually make sense from a arrangement perspective.
My Python way of converting this into a table was to use multiple dictionaries and be very conscience of column number and "line type" so they can iterated back through at the end and have the same orientation, string-wise. There are probably better ways to do this (ones that have more fault-tolerance as far as whitespace goes, etc), but this was the fastest way I could think of - and it only came out to around ~130 lines (and is already fast as hell).
import requests, pprint, json, pymssql, psutil, urllib
import time, os, string, sys, time
import pymssql
mssql_db = pymssql.connect(host='localhost:1450', user='sa', password='****', database='FretLogic')
mssql_cursor = mssql_db.cursor()
pp = pprint.PrettyPrinter(indent=3)
# For converting WELL FORMATTED (FULL) tablature to MSSQL Server Tables for later analysis...
f = open('sandmantab-modded.txt')
line = f.readline()
PMfretlogic = dict()
E1fretlogic = dict()
B2fretlogic = dict()
G3fretlogic = dict()
D4fretlogic = dict()
A5fretlogic = dict()
E6fretlogic = dict()
PRTfretlogic = dict()
POfretlogic = dict()
part_type = ' '
nummPM = 0
nummE1 = 0
nummB2 = 0
nummG3 = 0
nummD4 = 0
nummA5 = 0
nummE6 = 0
for lineno, linestr in enumerate(f):
print "line number: " + str(lineno) + ": " + linestr.rstrip()
rowtype = linestr[0] #what string, what type of data
print rowtype
if rowtype == '+':
part_type = str(linestr.rstrip()).replace('+','').replace(':','')
part_order = str(part_type[0])+str(part_type[1])
print part_order
part_type = part_type[2:]
print part_type
if rowtype == '?': #grab song data from ?string|shit
##Artist|Song|Album|link
artist_data = str(linestr.rstrip()).replace('?','')
artist = artist_data.split('|', 1)[0]
song = artist_data.split('|', 2)[1]
album = artist_data.split('|', 3)[2]
links = artist_data.split('|', 4)[3]
#print part_type
for colno, linecol in enumerate(linestr):
#print "line number: " + str(lineno) + " col number: " + str(colno) + ": " + linecol.rstrip()
if rowtype == '#': #'PALM MUTER line'
if linecol <> '|':
PMfretlogic[nummPM] = str(linecol).replace("\n",'')
PRTfretlogic[nummPM] = str(part_type)
POfretlogic[nummPM] = str(part_order)
nummPM = nummPM + 1
elif rowtype == '1': #'1E'
if linecol <> '|':
E1fretlogic[nummE1] = str(linecol).replace("\n",'')
PRTfretlogic[nummE1] = str(part_type)
POfretlogic[nummE1] = str(part_order)
nummE1 = nummE1 + 1
elif rowtype == '2': #'2B'
if linecol <> '|':
B2fretlogic[nummB2] = str(linecol).replace("\n",'')
PRTfretlogic[nummB2] = str(part_type)
POfretlogic[nummB2] = str(part_order)
nummB2 = nummB2 + 1
elif rowtype == '3': #'3G'
if linecol <> '|':
G3fretlogic[nummG3] = str(linecol).replace("\n",'')
PRTfretlogic[nummG3] = str(part_type)
POfretlogic[nummG3] = str(part_order)
nummG3 = nummG3 + 1
elif rowtype == '4': #'4D'
if linecol <> '|':
D4fretlogic[nummD4] = str(linecol).replace("\n",'')
PRTfretlogic[nummD4] = str(part_type)
POfretlogic[nummD4] = str(part_order)
nummD4 = nummD4 + 1
elif rowtype == '5': #'5A'
if linecol <> '|':
A5fretlogic[nummA5] = str(linecol).replace("\n",'')
PRTfretlogic[nummA5] = str(part_type)
POfretlogic[nummA5] = str(part_order)
nummA5 = nummA5 + 1
elif rowtype == '6': #'6E'
if linecol <> '|':
E6fretlogic[nummE6] = str(linecol).replace("\n",'')
PRTfretlogic[nummE6] = str(part_type)
POfretlogic[nummE6] = str(part_order)
nummE6 = nummE6 + 1
#pp.pprint(B2fretlogic)
print 'cols ' + str(nummPM) + ' ' + str(nummE1) + ' ' + str(nummB2) + ' ' + str(nummG3) + ' ' + str(nummD4) + ' ' + str(nummA5) + ' ' + str(nummE6)
print 'lines ' + str(lineno)
for i in range(nummE1):
try:
if str(E1fretlogic[i]) == '1' and str(B2fretlogic[i]) == '2' and str(G3fretlogic[i]) == '3' and str(D4fretlogic[i]) == '4' and str(A5fretlogic[i]) == '5' and str(E6fretlogic[i]) == '6':
pass
elif str(E1fretlogic[i]) == '':
pass
else:
print str(i) + '-' +str(artist) + ' ' + str(song) + ' ' + str(album) + ' ' + str(links) + ' ' +str(PRTfretlogic[i]) + ' ' + str(PMfretlogic[i]) + ' ' + str(E1fretlogic[i]) + ' ' + str(B2fretlogic[i]) + ' ' + str(G3fretlogic[i]) + ' ' + str(D4fretlogic[i]) + ' ' + str(A5fretlogic[i]) + ' ' + str(E6fretlogic[i])
mssql_cursor.execute("""insert into FretLogic.dbo.TabData (PickId, Test, Artist, Song, Album, TabLink, Part, PartOrder, PM, E1, B2, G3, D4, A5, E6) values ('""" + str(i) + """', GETDATE(), '""" + str(artist) + """', '""" + str(song) + """', '""" + str(album) + """', '""" + str(links) + """', '""" +str(PRTfretlogic[i]) + """', '""" +str(POfretlogic[i]) + """', '""" + str(PMfretlogic[i]) + """', '""" + str(E1fretlogic[i]) + """', '""" + str(B2fretlogic[i]) + """', '""" + str(G3fretlogic[i]) + """', '""" + str(D4fretlogic[i]) + """', '""" + str(A5fretlogic[i]) + """', '""" + str(E6fretlogic[i]) + """' )""")
except:
print 'cols ' + str(nummPM) + ' ' + str(nummE1) + ' ' + str(nummB2) + ' ' + str(nummG3) + ' ' + str(nummD4) + ' ' + str(nummA5) + ' ' + str(nummE6)
print 'lines ' + str(lineno)
print sys.exc_info()[0] #debug for fuckups
print sys.exc_info()[1] #debug for fuckups
print artist
print song
print album
mssql_cursor.execute("update TabData set Vert = (E1 + CHAR(13) + B2 + CHAR(13) + G3 + CHAR(13) + D4 + CHAR(13) + A5 + CHAR(13) + E6)")
mssql_db.commit()
f.close()
#Let's drink!
import time, os, string, sys, time
import pymssql
mssql_db = pymssql.connect(host='localhost:1450', user='sa', password='****', database='FretLogic')
mssql_cursor = mssql_db.cursor()
pp = pprint.PrettyPrinter(indent=3)
# For converting WELL FORMATTED (FULL) tablature to MSSQL Server Tables for later analysis...
f = open('sandmantab-modded.txt')
line = f.readline()
PMfretlogic = dict()
E1fretlogic = dict()
B2fretlogic = dict()
G3fretlogic = dict()
D4fretlogic = dict()
A5fretlogic = dict()
E6fretlogic = dict()
PRTfretlogic = dict()
POfretlogic = dict()
part_type = ' '
nummPM = 0
nummE1 = 0
nummB2 = 0
nummG3 = 0
nummD4 = 0
nummA5 = 0
nummE6 = 0
for lineno, linestr in enumerate(f):
print "line number: " + str(lineno) + ": " + linestr.rstrip()
rowtype = linestr[0] #what string, what type of data
print rowtype
if rowtype == '+':
part_type = str(linestr.rstrip()).replace('+','').replace(':','')
part_order = str(part_type[0])+str(part_type[1])
print part_order
part_type = part_type[2:]
print part_type
if rowtype == '?': #grab song data from ?string|shit
##Artist|Song|Album|link
artist_data = str(linestr.rstrip()).replace('?','')
artist = artist_data.split('|', 1)[0]
song = artist_data.split('|', 2)[1]
album = artist_data.split('|', 3)[2]
links = artist_data.split('|', 4)[3]
#print part_type
for colno, linecol in enumerate(linestr):
#print "line number: " + str(lineno) + " col number: " + str(colno) + ": " + linecol.rstrip()
if rowtype == '#': #'PALM MUTER line'
if linecol <> '|':
PMfretlogic[nummPM] = str(linecol).replace("\n",'')
PRTfretlogic[nummPM] = str(part_type)
POfretlogic[nummPM] = str(part_order)
nummPM = nummPM + 1
elif rowtype == '1': #'1E'
if linecol <> '|':
E1fretlogic[nummE1] = str(linecol).replace("\n",'')
PRTfretlogic[nummE1] = str(part_type)
POfretlogic[nummE1] = str(part_order)
nummE1 = nummE1 + 1
elif rowtype == '2': #'2B'
if linecol <> '|':
B2fretlogic[nummB2] = str(linecol).replace("\n",'')
PRTfretlogic[nummB2] = str(part_type)
POfretlogic[nummB2] = str(part_order)
nummB2 = nummB2 + 1
elif rowtype == '3': #'3G'
if linecol <> '|':
G3fretlogic[nummG3] = str(linecol).replace("\n",'')
PRTfretlogic[nummG3] = str(part_type)
POfretlogic[nummG3] = str(part_order)
nummG3 = nummG3 + 1
elif rowtype == '4': #'4D'
if linecol <> '|':
D4fretlogic[nummD4] = str(linecol).replace("\n",'')
PRTfretlogic[nummD4] = str(part_type)
POfretlogic[nummD4] = str(part_order)
nummD4 = nummD4 + 1
elif rowtype == '5': #'5A'
if linecol <> '|':
A5fretlogic[nummA5] = str(linecol).replace("\n",'')
PRTfretlogic[nummA5] = str(part_type)
POfretlogic[nummA5] = str(part_order)
nummA5 = nummA5 + 1
elif rowtype == '6': #'6E'
if linecol <> '|':
E6fretlogic[nummE6] = str(linecol).replace("\n",'')
PRTfretlogic[nummE6] = str(part_type)
POfretlogic[nummE6] = str(part_order)
nummE6 = nummE6 + 1
#pp.pprint(B2fretlogic)
print 'cols ' + str(nummPM) + ' ' + str(nummE1) + ' ' + str(nummB2) + ' ' + str(nummG3) + ' ' + str(nummD4) + ' ' + str(nummA5) + ' ' + str(nummE6)
print 'lines ' + str(lineno)
for i in range(nummE1):
try:
if str(E1fretlogic[i]) == '1' and str(B2fretlogic[i]) == '2' and str(G3fretlogic[i]) == '3' and str(D4fretlogic[i]) == '4' and str(A5fretlogic[i]) == '5' and str(E6fretlogic[i]) == '6':
pass
elif str(E1fretlogic[i]) == '':
pass
else:
print str(i) + '-' +str(artist) + ' ' + str(song) + ' ' + str(album) + ' ' + str(links) + ' ' +str(PRTfretlogic[i]) + ' ' + str(PMfretlogic[i]) + ' ' + str(E1fretlogic[i]) + ' ' + str(B2fretlogic[i]) + ' ' + str(G3fretlogic[i]) + ' ' + str(D4fretlogic[i]) + ' ' + str(A5fretlogic[i]) + ' ' + str(E6fretlogic[i])
mssql_cursor.execute("""insert into FretLogic.dbo.TabData (PickId, Test, Artist, Song, Album, TabLink, Part, PartOrder, PM, E1, B2, G3, D4, A5, E6) values ('""" + str(i) + """', GETDATE(), '""" + str(artist) + """', '""" + str(song) + """', '""" + str(album) + """', '""" + str(links) + """', '""" +str(PRTfretlogic[i]) + """', '""" +str(POfretlogic[i]) + """', '""" + str(PMfretlogic[i]) + """', '""" + str(E1fretlogic[i]) + """', '""" + str(B2fretlogic[i]) + """', '""" + str(G3fretlogic[i]) + """', '""" + str(D4fretlogic[i]) + """', '""" + str(A5fretlogic[i]) + """', '""" + str(E6fretlogic[i]) + """' )""")
except:
print 'cols ' + str(nummPM) + ' ' + str(nummE1) + ' ' + str(nummB2) + ' ' + str(nummG3) + ' ' + str(nummD4) + ' ' + str(nummA5) + ' ' + str(nummE6)
print 'lines ' + str(lineno)
print sys.exc_info()[0] #debug for fuckups
print sys.exc_info()[1] #debug for fuckups
print artist
print song
print album
mssql_cursor.execute("update TabData set Vert = (E1 + CHAR(13) + B2 + CHAR(13) + G3 + CHAR(13) + D4 + CHAR(13) + A5 + CHAR(13) + E6)")
mssql_db.commit()
f.close()
#Let's drink!
On my TO DO List:
- Actual note lookup (i.e. being able to name chords, E5, and single notes etc)
- much less human intervention required on the source files
- Lyrics as new line in tab reading?
- Some type of 1:1 time references, some permitting
Regardless, I'm def going to "viz out" a few more song's off 'The Black Album' just for the hell of it. I think I can make some usability improvements over this one.
