[fnogb]

Hi

Not sure, if this is the correct forum. Anyway:

I'm working on a script to automate importing sheets into MobileSheets, and I think the easist way is by using the builtin sync-function - I think the companion app is too slow (and slightly unstable as well) .
(Also: The script could be made to monitor the folder where I keep all my sheets and then automatically import them whenever I create a new sheet! )
The workflow would be like this:

First: Manually sync the library to a cloud folder

Then the script takes over like this:
1. Collect information about the file - Title, composer, genre, and so on
2. Copy the file to the cloud folder in its own subdirectory
3. Add rows as necessary to the relevant tables in the SQLite database
4. Add to mobilesheets_hashcodes.txt
5. Repeat
6. Sync the library again - thereby importing all the new sheets

First of all: Is this even possible?

If it is:

I have trouble understanding the mobilesheets_hashcodes.txt file.

It contains 4 lines per file:
1. A hash or unique id of some sort followed by a / and then filename
2. A hashcode
3.Timestamp
4. Filesize

The mystery is the two hashvalues. How are they calculated? And of what?
I have no idea about the first hash - or if it even is a hash. Maybe it's some sort of unique id?
I'm pretty sure, the hashcode is calculated using java's hashcode() function. But when I input the filename, filename w/o extension, directory+filename (both forward a backslash) or some combination, I don't get the correct value.

I would greatly appreciate any help!

Best regards
Anders Olesen