[thomasp]

Hi everyone,
is it possible to create a separeted HTML-document which contains hyperlinks pointing to a certain page in a multi page score sheet and open this page with MobileSheets?
Thanks in advance!

[itsme]

what do you want to achieve?

[itsme]

btw. it's probably not a good idea to use your e-mail address as your username

[thomasp]

what do you want to achieve?

I have a lot of songbooks plus a lot of content tables in excel or csv Format, or in a database. The table shows the title of a song and the page where you can find it.
My idea is to create a html page wit a lot of "<a href="..."> tags where the hrev value ist something like "mobilesheets://[name of pdf-file] [no of page in that pdf]".
The user could open this html content page, click/touch on the row with the deep link and navigate quick to the desired music sheet.
The advantage is that my html-content table would be independent from MobileSheets leading to the ability of changing the pdf without the need of entering links to page again.

[thomasp]

btw. it's probably not a good idea to use your e-mail address as your username

Good idea! I did not expect that this forum shows my email adress. And now I can't find a place where to change this or to set a separate nickname. How to do that?

[Zubersoft]

At the top right, click your name with the little dropdown arrow next to it, then "Edit profile", and then you'll see an option on the side to change your username.

Mike

[thomasp]

At the top right, click your name with the little dropdown arrow next to it, then "Edit profile", and then you'll see an option on the side to change your username.

Mike

Exactly this was my idea. But I can't find it there. I can find a way to change my email adress, but I do NOT want to do that because I would need to create a new email adress is this case. Instead of, I just want to change the user name only. Or some kind of nickname. Thank you anyway.

[Zubersoft]

I have changed your username to thomasp for now. Let me know what you would like it to be.

Mike

[itsme]

Why do you want to reinvent the wheel? The database of MobileSheets can search, find and open your sheets way better than every HTML page you create yourself. CSV import is the way to go. Take a look at the manual or search the forum for details.
https://www.zubersoft.com/mobilesheets/f...11013.html
To avoid the default behaviour that MobileSheets copies your files to its internal storage you may want to manage your files yourself. On Android switch off "Storage - Let MobileSheets Manage My Files" (Speicher - MobileSheets soll meine Daten verwalten). Then set the MobileSheets storage location to a local directory of your choice and organise your files in a folder structure inside the MobileSheets storage location. If you then import your files into MobileSheets only the database entries are created, the files stay where you saved them and the MobileSheets database links to your original files. Every change shows up immediately in MobileSheets. That's how I organise my sheet music since I started using MobileSheets
https://www.zubersoft.com/mobilesheets/f...10834.html
https://www.zubersoft.com/mobilesheets/f...11628.html
I recommend to start with a small subset of your files and play around with MobileSheets until your happy with the result before you invest a lot of effort. Thus you can start from scratch in case it's required without lossing too many hours of work.

[thomasp]

At the top right, click your name with the little dropdown arrow next to it, then "Edit profile", and then you'll see an option on the side to change your username.

Mike

[thomasp]

I have changed your username to thomasp for now. Let me know what you would like it to be.

Mike

thomasp is fine - thank you!

[thomasp]

Why do you want to reinvent the wheel? The database of MobileSheets can search, find and open your sheets way better than every HTML page you create yourself. CSV import is the way to go. Take a look at the manual or search the forum for details.
https://www.zubersoft.com/mobilesheets/f...11013.html
To avoid the default behaviour that MobileSheets copies your files to its internal storage you may want to manage your files yourself. On Android switch off "Storage - Let MobileSheets Manage My Files" (Speicher - MobileSheets soll meine Daten verwalten). Then set the MobileSheets storage location to a local directory of your choice and organise your files in a folder structure inside the MobileSheets storage location. If you then import your files into MobileSheets only the database entries are created, the files stay where you saved them and the MobileSheets database links to your original files. Every change shows up immediately in MobileSheets. That's how I organise my sheet music since I started using MobileSheets
https://www.zubersoft.com/mobilesheets/f...10834.html
https://www.zubersoft.com/mobilesheets/f...11628.html
I recommend to start with a small subset of your files and play around with MobileSheets until your happy with the result before you invest a lot of effort. Thus you can start from scratch in case it's required without lossing too many hours of work.

Thank you of theese hints! I will check them out.

[thomasp]

Why do you want to reinvent the wheel? The database of MobileSheets can search, find and open your sheets way better than every HTML page you create yourself. CSV import is the way to go. Take a look at the manual or search the forum for details.
https://www.zubersoft.com/mobilesheets/f...11013.html
To avoid the default behaviour that MobileSheets copies your files to its internal storage you may want to manage your files yourself. On Android switch off "Storage - Let MobileSheets Manage My Files" (Speicher - MobileSheets soll meine Daten verwalten). Then set the MobileSheets storage location to a local directory of your choice and organise your files in a folder structure inside the MobileSheets storage location. If you then import your files into MobileSheets only the database entries are created, the files stay where you saved them and the MobileSheets database links to your original files. Every change shows up immediately in MobileSheets. That's how I organise my sheet music since I started using MobileSheets
https://www.zubersoft.com/mobilesheets/f...10834.html
https://www.zubersoft.com/mobilesheets/f...11628.html
I recommend to start with a small subset of your files and play around with MobileSheets until your happy with the result before you invest a lot of effort. Thus you can start from scratch in case it's required without lossing too many hours of work.

Now I have done some checks.
First, I cannot change the storage location, ("Storage - Let MobileSheets Manage My Files" (Speicher - MobileSheets soll meine Daten verwalten)) because I cannot find such a setting in MobileSheets for iPad.
Second, i have the suspiction that there is a limitation regarding the pdf. I created a csv and a pdf-File. When I try to import theese in Mobile Sheet, there should be a dialog showing me which songs I want to import, but the list from where I am supposed to choose from is empty. No error messages, just yn empty list. Therefor I tried to find out what the reason may be. Firt, I used the example in the manual:

Code:

title;pages;composers;difficulty
SongA;1-3;ComposerA|ComposerB;8
SongB;4-5;

along with a fitting simple pdf-document and this worked.
Then I created an own simple exampe which also worked.
Then I modified my own csv-file into a very simple one: only the columns with name of the songs plus the pages, referencing only two songs. No special characters (german umlauts) an nothing other complicated.
This did work.
I edited my original pdf-document (225 pages, size of approx. 210 MB) into a smaller one (15 pages, 13 MB) and shrinked also my csv file: not working.
--------------------------
Finally I found a reason which I coul consider to be a bug in mobile sheets: I do have some collections in my csv-file an I am usind german umlauts here, exactly "Übung001" (="exercise001" or "practise001"). When I replaced the "Ü" (uppercase U umlaut) with the letter "U"), it worked. The funny thin is that I alredy have a collection named "Übung001" on MobileSheet on my iPad and I just wanted to add some sheets
this way.
Perhaps there is a problem with imcompatible charcter sets and/or codepages (ISO, ANSII, UNICODE or whatever) whe I try to transfer theese from a PC to an iPad.
---------------------------
I will continue my research (or investigation together wir my buddy Mr. Watson) an report my results.

---

Edit: I solved it! I converted my *.csv-file into unicode UTF-8 format and it worked well.

[Zubersoft]

You cannot change the storage location on iOS because Apple's framework forces apps to store files in their own folder.

The CSV parsing should support multiple encodings, but it's best to use UTF-8 if possible.

Mike

[thomasp]

You cannot change the storage location on iOS because Apple's framework forces apps to store files in their own folder.

The CSV parsing should support multiple encodings, but it's best to use UTF-8 if possible.

Mike

Thanks for your answer!

Pity about the storage location on iOS, I can see the "MobileSheets" folder on my iPad and I can copy files into that folder, but it seems that MobileSheets doesn't recognize this copy action. Instead of, I have to import the modified sheet again, losing my handwritten notes that way. This will not hapen very often, therefore I can live with that.

And encoding in UTF-8 is what I will do in Future.