[ronnie]

Hi all,

first of all, I hope that this question isn't a double, if so please excuse me and just send a link to the correct thread, I couldn't find any fitting ones!


I started cleaning up my library (which is managed by MobileSheets) by renaming files within the app (edit -> Files -> rename files). Most of the time, it works like a charm, but I encountered some issues:

1. I have two songs with file names "Example" and "Example2". I deleted the song "Example" from my library and wanted to rename the second one to "Example" instead. The library always tells me that the file already exists. I double-checked both my library and the synchronisation to Google Drive, the original file "Example" does not exist anymore. Also, I used a program to read the .db file but couldn't find an entry there either. So there seems to be a "dead entry" still remembering the old, deleted file name. Any ideas where I could find and delete that?

2. I have two song files that I renamed to "Song v1.pdf" (original: Song.pdf) and "Song v2.pdf" (original: Song xy.pdf), both of which have the in-app song name "Song". On my android tablet, this is no problem. When I use cloud folder synchronisation (with "only update folder" option) to Google Drive, it asked me which file belongs to which song, which I selected correctly, and both files appeared correctly in the Google Drive folder. Now I wanted to synchronise my Android phone (using "only update device" option), it created three songs: Song v1 was correcty created, Song v2 was created two times, one time with wiped-out meta data, one time with correct metadata but an old file name of Song v2, which was "Song xy.pdf". I have no idea where the information comes from, since this file does not exist in the MobileSheets database on my tablet or Google Drive. A complete reset of the app and new synchronisation did not fix the issue, also a complete wipe and resynch of the Google Drive folder did not help. So again, some dead metadata lying around which I can't find.

I'm super glad for any help I can get! I'm also open to kind of wiping my whole library and re-importing all files with their metadata, so if this sounds like a valid solution, I'm happy for some instructions on how to do that best.

Cheers!

[Chris Bakker]

Hi,
I ran into some problems with files, so perhaps my approach will help you.
(i have a dutch version running, so if the names are not exactly correct, im sorry).
In settings choose extra settings.
There should be a Find missing file and Fix broken filepaths.
Just run them to see if this fixes the issue.

Be sure that deleting it from mobilesheets also have the option to delete the file, it wont be deleted if its still in use.

for the moderator the  "Fix broken filepaths" (Herstel bestandspaden) is stil in english in my dutch version.

[ronnie]

Hi,
I ran into some problems with files, so perhaps my approach will help you.
(i have a dutch version running, so if the names are not exactly correct, im sorry).
In settings choose extra settings.
There should be a Find missing file and Fix broken filepaths.
Just run them to see if this fixes the issue.

Be sure that deleting it from mobilesheets also have the option to delete the file, it wont be deleted if its still in use.

for the moderator the  "Fix broken filepaths" (Herstel bestandspaden) is stil in english in my dutch version.

Hi Chris,
thanks for your reply. I already ran the "Find missing file" option. On my tablet, nothing shows up (which is expected because everything works properly except for not being able to rename files to a specific name). On my android phone, the non-existing file "Song xy.pdf" shows up which is also expected, but just confirms my problem  when I delete the Song linking to the missing file, but synchronise with the cloud again, it is created again.

[Zubersoft]

Uniquely naming songs really helps prevent conflicts with the synchronization feature, so if you can make sure each song has a unique title, that may prevent some issues. How did you go about deleting "Example"? If you just removed it from the song editor, that won't actually delete the file. It just leaves it in an orphaned state (this is done so MobileSheets does not delete a file a user may want to use a later point in time). This is something I need to address in the near future (both by adding an option when removing files to delete them and provide a utility to clean up orphaned files). You can delete an orphaned file in several ways:

1) Tap Import->Local File, tap the SD card icon, then tap "App data directory", find the PDF and swipe it horizontally in the list to delete the file
2) If the MobileSheets storage location is set to something that other apps can get to, use an external file editor to delete the file
3) Connect your tablet to your PC with a USB cable and delete the file using Windows Explorer

If you delete a song in MobileSheets, it will delete the file used by that song if you enable that option. This prevents orphaned files - you only run into this issue if you just remove the file in the song editor.

Mike