Getting a downloadable list of "My Songs"
I asked this before, a long time ago, and got an answer, but I could not find it. I entered a topic in General Discussion to ask if there is a way to search "Topics". But I will ask it again in case the answer may have changed.
Is there a way to get a downloadable list of "My Songs". I would like to enter it in Excel and compare it to a list I keep when I create a .mscz file. I want to make sure I did not forget to upload a song, but since I have over 600 songs, it has become unmanageable.
Comments
See https://musescore.org/en/node/323495
Just click you name to fine our topics, https://musescore.org/en/user/1888830
In reply to Just click you name to fine… by Jojo-Schmitz
Thanks for all your replies.
I have developed a way to get a "downloadable" listing of all "My Scores". I go to My Scores. I set the number of scores per page to the maximum of 50. I then right click on each page (in my case I had 14 pages to list all 600+ songs I have uploaded) and select print. I print as a PDF file (I have free software called PDFLite that installs a virtual printer called PDFLite). I then enter all the 14 PDF files into a program called ReadIRIS Pro, which I received as free software with the purchase of a computer I bought a long time ago. I then convert all the pages of the 14 PDFs to a Rich Text File (.rtf file) by using the Optical Character Recognition (OCR) option in ReadIRIS Pro. I then open the .rtf file in Microsoft WORD and save it as a plain .txt file. I then wrote a FORTRAN program to read the .txt file and extract and list the Song titles. I then copy the list of song titles from the .txt file and paste them into Excel. I then, in Excel, sort them alphabetically.
The compiled FORTRAN executable works on a PC but not on a Mac. So, if you have a PC and download PDFLite (or have something else that prints to a PDF file) and have access to OCR software and want the executable, let me know.
In reply to Thanks for all your replies… by nlsavin
Windows has had its own PDF printer built in for years.
OCR is not necessary: Since the score listing is not an image you could either open the PDF in a viewer and copy paste all the text from it, or open the PDF directly in Word which will do the conversion for you.
You could also take photos of your screen and let Google/Samsung/Microsoft OCR the text - Microsoft has a free app called Office Lens which I use to capture text from presentations: https://support.microsoft.com/en-us/office/office-lens-for-windows-577e…
Microsoft Excel phone app allows you to turn images to tables: https://support.microsoft.com/en-us/office/insert-data-from-picture-3c1…
You can also drop screen-shots into OneNote and it will instantly allow you to copy the text from it.
In reply to Windows has had its own PDF… by memeweaver
Thanks for your reply.
I actually have 4 different virtual printers which print to a PDF file including Microsoft Print to PDF. I have always use PDFLite since it has other features I uses.
I opened the PDF in Acrobat Reader DC and PDFLite but could not find a way to copy the contents as text in either. I bought Microsoft Office in 1997. I cannot open a PDF in WORD (1997 version). I opened the PDF in LibraOffice, but still could not copy it as text or save it as a text file or Export it as a text file. I received a reply which said I could set scores per page to 1000 scores per page. That shortened the process from 14 page saves and 14 PDF loadings into ReadIRIS Pro to just 1. I still need to run the 1 PDF through ReadIRIS Pro and use the OCR option, but this is now a much shorter process. I do not see doing this frequently (and maybe never again). I have completed my list of songs I wanted to convert to multipart scores for our 5 piece all accordion band. So, I may do a new song, once in a while, if asked by our band leader or member, but it will be easier for me to keep track of whether I have uploaded the latest songs to Musescore. But trying to see if I uploaded 600+ songs was just unmanageable. I just wanted to see if I forgot to upload any songs. So, with this Excel list I can easily compare it to my Excel list I keep of all the Musescore songs I have on my computer. I worked with what I had. Thanks!
Thanks for all your replies.
I have developed a way to get a "downloadable" listing of all "My Scores". I go to My Scores. I set the number of scores per page to the maximum of 50. I then right click on each page (in my case I had 14 pages to list all 600+ songs I have uploaded) and select print. I print as a PDF file (I have free software called PDFLite that installs a virtual printer called PDFLite). I then enter all the 14 PDF files into a program called ReadIRIS Pro, which I received as free software with the purchase of a computer I bought a long time ago. I then convert all the pages of the 14 PDFs to a Rich Text File (.rtf file) by using the Optical Character Recognition (OCR) option in ReadIRIS Pro. I then open the .rtf file in Microsoft WORD and save it as a plain .txt file. I then wrote a FORTRAN program to read the .txt file and extract and list the Song titles. I then copy the list of song titles from the .txt file and paste them into Excel. I then, in Excel, sort them alphabetically.
The compiled FORTRAN executable works on a PC but not on a Mac. So, if you have a PC and download PDFLite (or have something else that prints to a PDF file) and have access to OCR software and want the executable, let me know.
In reply to Thanks for all your replies… by nlsavin
Since you are using Excel you may be able to process the pages more efficiently by using Power Query, either with the PDF pages or a web page format. Power Query is part of Microsoft's Power Platform, (used with Power BI), and is available in Excel. Once you have set up the query, you simply save your page updates to the same location and press refresh in Excel. No, OCR, no RTF, no TXT but a fully automated conversion.
You may even be able to change the number of scores listed per page on the website by changing the parameter in the URL. This would give you fewer pages to save.
[Edit] I have just tried setting the number of scores per page to 1000 and it seems to work. I cannot verify this since I do not have 1000 scores uploaded buy you could give it a try using:
https://musescore.com/my-scores?items_per_page=1000&private=All&sort_by…
[Note] Power Query can grab webpage data directly if you can find a way to pass your Musescore login credentials to the site.
In reply to Since you are using Excel… by yonah_ag
Thank you for your reply. I bought Microsoft Office in 1997. I looked but could not find Power Query. I have downloaded Open Office and Libra Office a few years ago and will check if they have something similar to Power Query. But since your suggestion to set 1000 scores per page does work, you have shortened the process from 14 page saves and 14 PDF loadings into ReadIRIS Pro to just 1. Thanks
In reply to Thank you for your reply. I… by nlsavin
Power Query was introduced in Excel 2010. I am afraid you're about behind 8 or 9 major releases of Office.
In reply to Thank you for your reply. I… by nlsavin
Seriously still using a 25 years old version?
In reply to Seriously still using a 25… by Jojo-Schmitz
At work I always had the latest version of Microsoft Office. At home, I just could not justify the purchase of a new version, especially since Microsoft Office 97, LibreOffice, OpenOffice and Acrobat Reader DC) satisfies almost all of my administrative needs. I have programed computers since 1968, and actually enjoy developing my own solution to a missing feature. I wanted a downloadable list of the titles of "My Scores". I first wanted to make sure it was not an option built into Musescore.com. Since it was not, it took me about an hour to develop a way and get the list in a workaround. I have written hundreds of programs for the IBM1130, IBM360, CDC6600, CDC7600, Cray Supercomputer and finally PCs. It took me about 15 minutes to write the less than 20 lines of executable code I needed to read the text file, select the title and make a list.
I have attached the list. With this list I can compare (write a COMPARE program) it to my list on my computer. I will be able to see if I missed uploading any and I can also see why I may have more than one score version uploaded (either by mistake or for a reason).
I wanted to thank you and explain this to you since you have provided me a lot of support over the years.
In reply to Thank you for your reply. I… by nlsavin
I think that Microsoft Power BI Desktop is still free and this includes Power Query. You only need to move to a paid version if you want to publish your reports on Microsoft's cloud, (typically a business requirement), which gives you report sharing options and scheduled data refresh - plus a lot more processing power. However, until your report reaches 100,000 to 1,000,000 records any decent PC will manage so your set of < 1000 records should be no problem.
This page gives you an idea of the vast array of data sources that Power BI can get data from. Any report can link data from many sources.
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-data-so…
If this route interests you then here's a good place to get started:
https://learn.microsoft.com/en-us/power-bi/fundamentals/desktop-get-the…
In reply to Thank you for your reply. I… by nlsavin
It feels rather Rube Goldberg-ish to take structured text, convert it into a series of images and then try to recover the text content and structure separately! It's almost like trying to recreate human vision.
In reply to It feels rather Rube… by memeweaver
I wanted a downloadable list of the titles of "My Scores". It took me about an hour to develop a way and get the list. It may have been Rube Goldberg-ish, but it got the job done in under an hour. I worked with what I had readily available and would accomplish the job.
In my 40 years as an engineer, I have seen my young coworkers take days to get an answer for our customer using a state-of-the-art Monte Carlo code (MCNP) when I could have provided the answer, they "needed", in an hour using a hand calculation. The choice of methodology used should not only depend on the tools available, but on the customer "needs" and when they need it. The customer wants the correct answer at the lowest cost. The methodology used to get the correct answer is not their concern, even if it is Rube Goldberg-ish.
I considered looking at the source code for the webpage and stripping out only the coding that accesses the database and pulls the score titles from it. I do not know that programing language, but I can look at what someone else has done and figure out what I want to do. I decided that that would take longer than the way I chose. To me, directly accessing the database and pulling the score titles from it would be the ultimate in not "recreating human vision".
Having said that, I do appreciate you taking the time to reply to my comment.