Drive download error: UnboundLocalError: local variable 'download_url' referenced before assignment

[Rick Burgess]

Hello. I'm attempting to download the contents of each user's Drive/Docs through gam with the following command: 

gam user "user...@mydomain.com" get drivefile query "'me' in owners" format microsoft targetfolder "C:\test"

It produces this output:

Searching for files with query: "'me' in owners"...

 got 139 files...

Downloading Google Doc: C:\test/SLC - from User 2014

Traceback (most recent call last):

  File "gam.py", line 7353, in <module>

  File "gam.py", line 2339, in downloadDriveFile

UnboundLocalError: local variable 'download_url' referenced before assignment

Any ideas what's going on and how I can proceed?

[Matt S]

There appear to be a few bugs in this function.  There is a similar error with the 'export_formats' variable.  Both need to be assigned at the beginning of the function.  I was trying to fix it myself but was having trouble compiling/running the code.  Was trying to get help here: https://groups.google.com/forum/#!topic/google-apps-manager/xpPu7kSoFqM

Hopefully one of the devs will see this.  I tried emailing one of them too (jay0lee) but didn't get a response.  Couldn't find the other's email address.

-Matt

[Jay Lee]

This is fixed in GAM 3.3:

https://github.com/jay0lee/GAM/releases

@Matt S: as far as compiling GAM, you need to install the pyOpenSSL library. There may be other dependencies. I use the build.bat script to put all the bits together. It's been awhile but if I ever rebuild my Windows machine I'll try to document the process.

Jay

[Ed Hillis]

I'm seeing this error in GAM 3.3 64-bit windows version

Downloading Google Doc: folder/xyz

Traceback (most recent call last):

  File "gam.py", line 7177, in <module>

  File "gam.py", line 2275, in downloadDriveFile

UnboundLocalError: local variable 'download_url' referenced before assignment

Ed

[Jay Lee]

What type of document is folder/xyz? Can someone share a problematic file with me as I'm unable to reproduce the issue otherwise. Share it with ad...@jay.powerposters.org

Jay Lee

--
You received this message because you are subscribed to the Google Groups "Google Apps Manager" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To post to this group, send email to google-ap...@googlegroups.com.
Visit this group at http://groups.google.com/group/google-apps-manager.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/35defef8-bf5d-4609-b2be-d790bf802b7c%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[Rick Burgess]

Interestingly, I tried the same command running the x86 version and it works.

--

[Ed Hillis]

It turns out it's a folder. The user owns the folder, but she only owns a few of the files in the folder. The rest are owned by others in the organization. I'm working on backing up some users' files, and this is one of the users. I can't share it without her permission, but may be able to arrange that. 

Thanks,

Ed

Jay Lee

To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.

To post to this group, send email to google-ap...@googlegroups.com.
Visit this group at http://groups.google.com/group/google-apps-manager.

[Jay Lee]

Don't try to download folders, they don't actually contain any content. I'll add code to skip over them in the next GAM release but for now you should be skipping over them with your query. The OP query should be:

gam user "user...@mydomain.com" get drivefile query "'me' in owners and mimeType != 'application/vnd.google-apps.folder'" format microsoft targetfolder "C:\test"

Jay Lee

To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.

To post to this group, send email to google-ap...@googlegroups.com.
Visit this group at http://groups.google.com/group/google-apps-manager.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/a03da931-1bdf-4fe1-89a4-4c2d0f20e0f3%40googlegroups.com.

[Ed Hillis]

That worked. Thanks!

Ed

Jay Lee

Thanks,

Ed

Jay Lee

To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsubscribe...@googlegroups.com.

To post to this group, send email to google-ap...@googlegroups.com.

Visit this group at http://groups.google.com/group/google-apps-manager.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/35defef8-bf5d-4609-b2be-d790bf802b7c%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Google Apps Manager" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.
To post to this group, send email to google-ap...@googlegroups.com.
Visit this group at http://groups.google.com/group/google-apps-manager.

[Matt S]

Thanks for the update!  Much appreciated.  Unfortunately I came across another issue:

Running the query with the folder exclusion you mentioned above I got this:

Searching for files with query: "'me' in owners and mimeType != 'application/vnd.google-apps.folder'"...

Traceback (most recent call last):

  File "gam.py", line 7177, in <module>
  File "gam.py", line 2225, in downloadDriveFile
  File "gam.py", line 1844, in doDriveSearch
  File "gam.py", line 434, in callGAPIpages
  File "gam.py", line 374, in callGAPI
  File "oauth2client\util.pyo", line 132, in positional_wrapper
  File "apiclient\http.pyo", line 716, in execute
  File "oauth2client\util.pyo", line 132, in positional_wrapper
  File "oauth2client\client.pyo", line 490, in new_request
  File "httplib2\__init__.pyo", line 1593, in request
  File "httplib2\__init__.pyo", line 1396, in _request
  File "httplib2\__init__.pyo", line 448, in _updateCache
  File "httplib2\__init__.pyo", line 715, in set
IOError: [Errno 2] No such file or directory: 'C:\\Users\\userprofile\\Desktop\\gam\\gamcache\\www.googleapis.com,drive,v2,files,q=%27me%27+in+owners+and+m
imeType+%21%3D+%27application%2Fvnd.google-apps.folder%27&fields=nextPageToken%2Citems%28id%29&alt=json&prettyPrint=false&maxResults=1000,hashremovedforsecurity'

Then without the folder exclusion I got this:

Searching for files with query: "'me' in owners"...

 got 589 files...
Downloading Google Doc: C:\Users\userprofile\Desktop\gam\_GoogleDrive-userfolder/Senior Seminar.odt
Downloading: C:\Users\userprofile\Desktop\gam\_GoogleDrive-userfolder/WhatisGovernment.pdf of 8mb bytes

Traceback (most recent call last):

  File "gam.py", line 7177, in <module>
  File "gam.py", line 2275, in downloadDriveFile
  File "oauth2client\util.pyo", line 132, in positional_wrapper
  File "oauth2client\client.pyo", line 490, in new_request
  File "httplib2\__init__.pyo", line 1593, in request
  File "httplib2\__init__.pyo", line 1396, in _request
  File "httplib2\__init__.pyo", line 448, in _updateCache
  File "httplib2\__init__.pyo", line 715, in set
IOError: [Errno 2] No such file or directory: 'C:\\Users\\userprofile\\Desktop\\gam\\gamcache\\doc-14-3c-docs.googleusercontent.com,docs,securesc,hashesremovedforsecurity'

It did download the first file, "Senior Seminar.odt".

Same results both with "format Microsoft" and without.


[Matt S]

Upon searching the error I found this thread: https://code.google.com/p/google-apps-manager/issues/detail?id=170 which talks about the nocache.exe file.  That did fix the above issue.

[Gustavo Aristi]

I am trying to do something similar in bulk. 

However with this method all files from multiple users end up all mixed up in the target folder. Is there an argument I can use to have GAM create independent folders for each user's Drive files?

gam csv userList.csv gam user ~email get drivefile query "'me' in owners" format microsoft targetfolder "C:\TEST"

Thanks for the help!

[+KimNilsson]

Most likely!

Put unique folders in your CSV and set the final option targetfolder as a variable, like the other CSV variables.

Something like this.

gam csv userList.csv gam user ~email get drivefile query "'me' in owners" format microsoft targetfolder ~folder

[Rajesh Sadasivan]

Python has lexical scoping by default, which means that although an enclosed scope can access values in its enclosing scope, it cannot modify them (unless they're declared global with the global keyword). A closure binds values in the enclosing environment to names in the local environment. The local environment can then use the bound value, and even reassign that name to something else, but it can't modify the binding in the enclosing environment. UnboundLocalError happend because when python sees an assignment inside a function then it considers that variable as local variable and will not fetch its value from enclosing or global scope when we execute the function. To modify a global variable inside a function, you must use the global keyword.

[Ross Scroggs]

Rajesh,

It would be helpful to see the command you entered and the error message.

Ross

--

ross.s...@gmail.com

On May 7, 2020, at 11:11 PM, Rajesh Sadasivan <rajesh...@gmail.com> wrote:

Python has lexical scoping by default, which means that although an enclosed scope can access values in its enclosing scope, it cannot modify them (unless they're declared global with the global keyword). A closure binds values in the enclosing environment to names in the local environment. The local environment can then use the bound value, and even reassign that name to something else, but it can't modify the binding in the enclosing environment. UnboundLocalError happend because when python sees an assignment inside a function then it considers that variable as local variable and will not fetch its value from enclosing or global scope when we execute the function. To modify a global variable inside a function, you must use the global keyword.

--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/e256664c-561d-4c87-960c-92c978283bde%40googlegroups.com.