[waltsyd]

I have a master tablet. I synchronize other tablets to this server tablet. Every time I sync, I get many songs that indicate "merging....". How do I fix this so that the songs don't have to be "merged" every time? I'm not sure I understand the concepts.

[Zubersoft]

Change the merge behavior to "Prompt user for decision", and you'll see the differences MobileSheets is detecting that is causing the merging to occur.

Mike

[waltsyd]

Change the merge behavior to "Prompt user for decision", and you'll see the differences MobileSheets is detecting that is causing the merging to occur.

Mike

When I do that, I get the same files showing up to be merged every time. The name, size, and date modified are identical. I select "Use mine" and apply to all subsequent merges. I run sync again and get the same behavior.

For a test, I deleted the first offending file off of the client and ran the sync again. Strangely, I still got the same decision prompt for the just-deleted file. My side showed the file name, size, and date. The client just showed the words "Do nothing". I don't understand how there could be a merge issue when the client file had been deleted. Anyway, I selected "Use mine" and the next time I ran the sync, that file no longer caused a merge issue.

I think I will have to delete the offending files off of the client manually and do the sync again. That could take a while. The other option would be to nuke all the 5000+ files on the client and sync from the server. What would you recommend?

[Zubersoft]

It's possible there is an issue with the file hashes not matching and the hash not being updated on the second device for some reason. In order to investigate that, I would need a library backup file from each of your devices so I can try to reproduce the issue during the sync. That would be the easiest option. Otherwise I'll have to try to artifically set up a scenario to match what I think might be happening, but that may not be enough if any of my assumptions are wrong. Would you be willing to create and share the backups with mike@zubersoft.com?

Thanks,
Mike

[Tharlin]

It's possible there is an issue with the file hashes not matching and the hash not being updated on the second device for some reason. In order to investigate that, I would need a library backup file from each of your devices so I can try to reproduce the issue during the sync. That would be the easiest option. Otherwise I'll have to try to artifically set up a scenario to match what I think might be happening, but that may not be enough if any of my assumptions are wrong. Would you be willing to create and share the backups with mike@zubersoft.com?

Thanks,
Mike

I have the same problem, that a couple of songs is showing the merging dialogue on every synchronization. I even deleted one of the songs and deleted the whole online sync database, then uploaded the database again. Then I created that song again and on the next sync it shows that song again in the merging dialogues.

It's a bit annoying, to click all those dialogues on every sync. What can I do?

[Zubersoft]

There is a difference being detected between what is on the tablet versus what is in the cloud folder. Without a copy of a library backup from your device and a copy of the files in the sync folder, I can't investigate why that difference is being detected. If you have it set to "Prompt user for decision", it should be showing what the detected difference is. If nothing is shown, that means the file hash is different between what is stored in the tablet and what is listed in mobilesheets_hashcodes.txt in the sync folder. 

Mike

[Tharlin]

There is a difference being detected between what is on the tablet versus what is in the cloud folder. Without a copy of a library backup from your device and a copy of the files in the sync folder, I can't investigate why that difference is being detected. If you have it set to "Prompt user for decision", it should be showing what the detected difference is. If nothing is shown, that means the file hash is different between what is stored in the tablet and what is listed in mobilesheets_hashcodes.txt in the sync folder. 

Mike

Additional info: It happens when I sync my tablet with the cloud and it happens with the same songs when I sync my PC with the cloud. Deleted the cloud files several times and re-uploaded a version from my pc again. But the problem still exists.

~Edit: Sent you a link to my cloud storage and PC backup file via e-mail here in the forum.

[Tharlin]

Could you find out something from the data?

[Tharlin]

It's possible there is an issue with the file hashes not matching and the hash not being updated on the second device for some reason. In order to investigate that, I would need a library backup file from each of your devices so I can try to reproduce the issue during the sync. That would be the easiest option. Otherwise I'll have to try to artifically set up a scenario to match what I think might be happening, but that may not be enough if any of my assumptions are wrong. Would you be willing to create and share the backups with mike@zubersoft.com?
Thanks,
Mike

Could you please tell me, if you got the links I send via forum-mail and if you could download the data?

If you had no time to check for the problem yet, it's no problem. Just want to make sure, you got the data to check it.

[Zubersoft]

Thanks for checking in with me. There was an issue with the email getting archived accidentally, but I have your backup file and made a copy of the sync folder, so I should be able to look into this. 

Mike

[Zubersoft]

So I'm already seeing multiple issues:

1) You have multiple duplicate songs with the same title and files
2) You are using the song ID field which can cause unrelated songs to be matched up incorrectly. For example, I very quickly encountered a situation where you have 6 songs all using the same song ID which is going to cause MobileSheets to have conflicts when trying to match songs between the cloud folder and device. The song ID field is not just a simple piece of metadata - it overrides the normal title and filename matching logic and forces songs to be matched by that ID. If you were using it as a simple piece of information, that is going to cause chaos with features such as the library sync feature, the sharing and importing of .msf files, and potentially with the connect tablets feature (depending on the settings).

For reference, these are just one example of the entries using the same song ID:
Mein Regiment" Marsch
Mein Regiment" Marsch
Guten Abend, gute Nacht
Guten Abend, gute Nacht
Guten Abend, gute Nacht
Guten Abend, gute Nacht

Each one of those has a different database ID for the song, meaning they are all different entries on the songs tab. 

3) You are using a two-way sync which can lead to unpredictable results if you are not very careful. It's much better to use a one-way sync (either push changes up, or pull changes down, and only push changes on one device at a time between pulls).

So there are many, many potential issues here with the way you have things set up that will need to be resolved if you want to use the library sync feature without problems.

Mike