02-27-2020, 05:26 AM
Hey everyone,
firstly a big thanks to the developer, you really did amazing work with this application! I've been happily using it for about 2 years now, let me describe my existing infrastructure (of which there is no open-source code yet but might be in the future):
It started with a songbook I had created before getting a tablet. This songbook used LaTeX and a pretty horrible syntax in order to create rather beautiful lyrics with the chords above them.
When I bought a tablet and this app, I just wrote a script where instead of creating a big pdf of a few hundred songs it would export each song individually into a folder named after the artist for easy import into MobileSheetsPro. It would also leave out the huge margins needed for a printed book, scale the pages for tablet etc.
Then, on a long weekend, I found out about the chordpro format and MSPs ability to directly import and view these files, so I downloaded a huge collection of chopro files and added them to my library.
I did, however, still like the more polished look of my LaTeX PDF files.
Naturally, I coded a Python script that would read in a chopro file and use some regex magic to convert it into a latex source file compatible with my build pipeline described earlier.
After that, I even went so far as to create a browser plugin that would allow me to directly download a chopro file from ultimate-guitar.com. (with partial support for ascii tablature!)
So that was my pipeline.
I want a new song?
1. Visit ultimate-guitar.com, find chords that seem to fit
2. Download a chopro file using my browser extension
3. Do some manual adjustments of where the chords actually belong (I want my sheets to be more exact than those on UG)
4. Run the Python script to convert this into a .tex file that's compatible with my songbook
5. Run a Python script that generates PDFs from all the changed, individual .tex files
Unfortunately, something broke when I moved to a new PC and I haven't found the time to dig through the (extremely messy) code yet, so at the moment it does not work and I'm not 100% sure I still have the browser extension code.
Now, instead of just fixing the code, documenting it for other people to use (which would be possible pretty much only for programmers, so not very user friendly) I am currently thinking about creating a (node.js based) application that has a web frontend and unites all those features by running the scripts in the correct order etc.
For this I would use my personal cloud server (although when I open-source this, it can also be run on a PC), but there is one very important thing missing in the pipeline: Getting those files into MobileSheetsPro.
So this is where my question comes in: Is it possible to edit the names of songs, artists and other metadata (crop? attached mp3 files? most important: collections?) manually in Google Drive, maybe add a few files and then sync all those changes back to MSP? I started uploading my library to Google Drive from my tablet about an hour ago and it has only reached 1%, so I can not yet see how the metadata are being stored.
If that is possible (and if not, please please please give me the option to do this), I would start by writing a webapp that connects to Google Drive with their API and allows to edit the library there. This would not only allow someone to edit their library without directly connecting a tablet and using the Windows tool but would then allow me to add the features described above back in, have this run on a server, and be able to add an ultimate-guitar link from everywhere (mobile browser?), which is then downloaded as chopro, compiled to PDF, added to Google Drive automatically and will then be downloaded the next time I sync my table to the cloud folder, but would also allow other people to have multiple tablets connected to one Google Drive folder, which can then be edited with this tool.
Please tell me there is nothing stopping me from realizing this except my own programming skills
firstly a big thanks to the developer, you really did amazing work with this application! I've been happily using it for about 2 years now, let me describe my existing infrastructure (of which there is no open-source code yet but might be in the future):
It started with a songbook I had created before getting a tablet. This songbook used LaTeX and a pretty horrible syntax in order to create rather beautiful lyrics with the chords above them.
When I bought a tablet and this app, I just wrote a script where instead of creating a big pdf of a few hundred songs it would export each song individually into a folder named after the artist for easy import into MobileSheetsPro. It would also leave out the huge margins needed for a printed book, scale the pages for tablet etc.
Then, on a long weekend, I found out about the chordpro format and MSPs ability to directly import and view these files, so I downloaded a huge collection of chopro files and added them to my library.
I did, however, still like the more polished look of my LaTeX PDF files.
Naturally, I coded a Python script that would read in a chopro file and use some regex magic to convert it into a latex source file compatible with my build pipeline described earlier.
After that, I even went so far as to create a browser plugin that would allow me to directly download a chopro file from ultimate-guitar.com. (with partial support for ascii tablature!)
So that was my pipeline.
I want a new song?
1. Visit ultimate-guitar.com, find chords that seem to fit
2. Download a chopro file using my browser extension
3. Do some manual adjustments of where the chords actually belong (I want my sheets to be more exact than those on UG)
4. Run the Python script to convert this into a .tex file that's compatible with my songbook
5. Run a Python script that generates PDFs from all the changed, individual .tex files
Unfortunately, something broke when I moved to a new PC and I haven't found the time to dig through the (extremely messy) code yet, so at the moment it does not work and I'm not 100% sure I still have the browser extension code.
Now, instead of just fixing the code, documenting it for other people to use (which would be possible pretty much only for programmers, so not very user friendly) I am currently thinking about creating a (node.js based) application that has a web frontend and unites all those features by running the scripts in the correct order etc.
For this I would use my personal cloud server (although when I open-source this, it can also be run on a PC), but there is one very important thing missing in the pipeline: Getting those files into MobileSheetsPro.
So this is where my question comes in: Is it possible to edit the names of songs, artists and other metadata (crop? attached mp3 files? most important: collections?) manually in Google Drive, maybe add a few files and then sync all those changes back to MSP? I started uploading my library to Google Drive from my tablet about an hour ago and it has only reached 1%, so I can not yet see how the metadata are being stored.
If that is possible (and if not, please please please give me the option to do this), I would start by writing a webapp that connects to Google Drive with their API and allows to edit the library there. This would not only allow someone to edit their library without directly connecting a tablet and using the Windows tool but would then allow me to add the features described above back in, have this run on a server, and be able to add an ultimate-guitar link from everywhere (mobile browser?), which is then downloaded as chopro, compiled to PDF, added to Google Drive automatically and will then be downloaded the next time I sync my table to the cloud folder, but would also allow other people to have multiple tablets connected to one Google Drive folder, which can then be edited with this tool.
Please tell me there is nothing stopping me from realizing this except my own programming skills