Syncdocs Google Drive Forum

Help on Google Drive sync

1. 

   crazedny
   Member

   Hey Guys,

   I just bought syncdocs yesterday after testing it and thinking I worked out all the kinks. I'm having a strange issue and was hoping there was a fix. So I created a symbolic link to a folder with Excel documents named Planning using the Right click>Upload to Google Drive function.

   It then uploaded all my files to a Planning folder on Google Drive. Great!

   I wanted to be able to edit those files on Google Drive directly without downloading them and opening them in Microsoft Office. So I removed the symbolic link and made sure that the documents also got deleted from Google drive. Then, I went into the settings and checked the box to Convert files to Google Docs on upload, if possible.

   I then right clicked the same planning folder and uploaded it again. This time the files on my symbolic link remained .xlsx but on the Google drive they were converted into the Google Sheets format. Which is exactly what I wanted.

   I made a change the the file locally on my machine and the change then got uploaded to my Google Sheet document on GDrive. Where I ran into an issue was when I modified the document on the Google Drive side. When I added text to a cell Syncdocs recognized that the file changed. However, even though it said it downloaded the file my local file did not reflect these changes. Also, every time I initiated a sync it would always "download" that file since it saw it as a change but the local file never got updated.

   So I then created a new Google Sheet Document on the Planning Drive on GDrive. Again, Syncdocs recognized a new file and "downloaded" it. However, the new Google Sheet file I created never got synced locally. Now both the updated spreadsheet and the new GSheet I created always "download" every time a sync is initiated.

   So basically my issue is Syncdocs is not downloading Google Sheet documents to my local drive.

   I'm not sure what's going on. I do not have this issue when using the default Google Drive client nor the Insync (3rd Party) client.

   Lastly, assuming there is a fix to this is there a way to turn off document conversion when Google Documents get downloaded from Google Drive. In other words, can I download the gdsheets format and store that instead of it converting it to xlsx.

   Posted 6 years ago #
   Magical rainbow ponies
2. 

   Phil
   Syncdocs

   Thank you for the detailed description.

   Are you using the new format Google sheets? Google does not yet support exporting these (although we are busy working on a work-around). See this thread.

   If you haven't enabled the new format sheets, please email us your log at contact-syncdocs@syncdocs.com and we'll see what's wrong.

   Posted 6 years ago #
   Edit page
3. 

   crazedny
   Member

   I think it's the old version. I used your software to convert the original XLS files to Google Spreadsheets. When you convert the documents by selecting "Convert files to Google Docs on upload, if possible" is it converting them to the old or new version? If not is there a way to upload and convert my original xlsx excel documents while ensuring that it uses the old version of google sheets?

   Is there any way to tell if they're the old format vs the new? The file extension says .gsheet. I also tried to create an old spreadsheet using the g.co/oldsheets trick that's detailed here:

   https://support.google.com/docs/answer/3541068?rd=1

   Both files say .gsheet at the end of it.

   However, the one that I created using the g.co/oldsheets appears to be syncing providing it isn't in the same directory as the other offending documents.

   Another question I have is with regards if I have to do a new installation. Do I need to download the contents of a folder on GDrive before I can sync to it? For example. Let's say I have files in a folder on GDrive that I manually uploaded via the web GUI. However, the files actually exist on my local computer under the same folder name.

   Can I create a symbolic link in the Syncdocs Google Drive directory and will it compare what's already up in google drive or will it think that the files are new and upload another Directory with the same name and download the folder and contents from Google drive as a (2). Basically I'm trying to avoid having to download all of my data should I need to uninstall and re-install in the future on a new machine.

   Posted 6 years ago #
4. 

   Phil
   Syncdocs

   My guess is that it is the new sheets format as your g.co/oldsheets sheet synced.

   According to Google, new sheets are being rolled out now, so new sheets you create will be in the new Google sheets format, while the ones before April will definitely be in the older format. Sheets created during the Google switch from old to new format (April and early May) depend on the Google server you connected to, so could be in either.

   We are busy working on a way of exporting the new sheets format, and hope to have it in our beta release next week.

   Regarding the new installation question. Yes, you can just create a symbolic link. If the files are the same and at the same level in the directory hierarchy, Syncdocs will not re-upload or re-download them.

   Posted 6 years ago #
   Contact us
5. 

   crazedny
   Member

   After doing further tests it looks like the new documents that get created are in fact the new format. How can I get notified when the beta gets released? Thanks for your help!

   Posted 6 years ago #
6. 

   Phil
   Syncdocs

   We are working on it now. I'll announce it in this forum, so you can subscribe to this thread to get a notification of the new sheets release.

   Posted 6 years ago #
   Secret
7. 

   Andrew
   Syncdocs

   Google has now enabled the API for the new sheets on their server, so both old and new format sheets will be exported.

   This means that the existing Syncdocs now supports both old and new sheets sync, there is no need to run the beta.

   We're not sure if this change has been rolled out to all Google servers worldwide, so we would be interested to hear from anyone still having this problem.

   Posted 6 years ago #
8. 

   crazedny
   Member

   Hey,

   I can verify that it is in fact working now. Thanks for providing insight into this issue.

   Posted 6 years ago #
9. 

   Andrew
   Syncdocs

   Good to hear. Thanks for the confirmation.

   Posted 6 years ago #

RSS feed for this topic

Reply

You must log in to post.