I thought I would just update you on where I am at.
It's great news! I now have a client that works (most kinks/bugs out).
Folders that are synced are "Contacts, Magic Briefcase, Mobile Photos, Web Archive (soon to be removed from sync), Deleted Files (soon to be removed from sync too)"
Also and "Shared folders" on the account are also downloaded with the option to upload if you have privileges to do so ( it's the feature requested here: Re: Limitations of "Shared Folder" function - http://support.sugarsync.com/ics/forum/Client/Common/ContentView.aspx?contentID=90386&PageNo=2)
I have a few small things to do still:
-- Improve the upload check: currently it's a bit lazy (finds newly downloaded files as modified and then uploads them)
-- Build a facility to delete files on the server!!!
-- Migrate the MySQL database to sqlite for portability
-- Change the setup file to be config based rather then code
-- Build a better logging facility to help diagnose problems
-- Build a script to remove all data & empty data for testing purposes
SugarSync have been great the past few weeks helping me with the hiccups I have been having but i'm hoping to have a release by the weekend (or midweek next week)
This release is ALPHA and shouldn't be used in production, There is no delete feature yet - So your online data should be safe still
Through the api I can only do (for the moment) whole file download/upload so if you have large files it may take some time to update them.