Format (xxxx) not available when downloading gdrive docs

85 views
Skip to first unread message

K.Z.

unread,
Mar 6, 2019, 7:50:09 AM3/6/19
to GAM for G Suite
Hi, the app is great, but I'm constantly getting this error for specific files:

Downloading Google Doc: <filename> to /Volumes/.../<filename>.xlsx
Format (xlsx) not available
ERROR: Format (microsoft) not available

This happens for different file types (not only excel), but always the same, is persistent and affects 5-10% of files.
Commands I used (no mather which I use, effect is the same):
gam user <username> get drivefile query "'me' in owners" targetfolder <path> format microsoft
gam user <username> get drivefile query "'me' in owners" targetfolder <path> format openoffice
gam user <username> get drivefile query "'me' in owners" targetfolder <path>

Any ideas what can be the problem?


Jay Lee

unread,
Mar 6, 2019, 7:59:21 AM3/6/19
to google-ap...@googlegroups.com
Using drive.google.com are you able to export the file to those formats?

--
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 post to this group, send email to google-ap...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/7fd83624-3011-473a-967f-cc13730c2a82%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Ross Scroggs

unread,
Mar 6, 2019, 9:04:40 AM3/6/19
to google-ap...@googlegroups.com
K.Z.,

What is the mimeType of the documents that aren't downloaded?
gam user <username> print filelist query "title='<filename>'" id title mimetype

Ross

K.Z.

unread,
Mar 6, 2019, 10:48:43 AM3/6/19
to GAM for G Suite
Hi Jay,

Yes I can export it to pptx without a problem.

On Wednesday, 6 March 2019 13:59:21 UTC+1, Jay Lee wrote:
Using drive.google.com are you able to export the file to those formats?

On Wed, Mar 6, 2019, 7:50 AM K.Z. <konrad.z...@s-f.com> wrote:
Hi, the app is great, but I'm constantly getting this error for specific files:

Downloading Google Doc: <filename> to /Volumes/.../<filename>.xlsx
Format (xlsx) not available
ERROR: Format (microsoft) not available

This happens for different file types (not only excel), but always the same, is persistent and affects 5-10% of files.
Commands I used (no mather which I use, effect is the same):
gam user <username> get drivefile query "'me' in owners" targetfolder <path> format microsoft
gam user <username> get drivefile query "'me' in owners" targetfolder <path> format openoffice
gam user <username> get drivefile query "'me' in owners" targetfolder <path>

Any ideas what can be the problem?


--
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-manager+unsub...@googlegroups.com.

K.Z.

unread,
Mar 6, 2019, 10:52:42 AM3/6/19
to GAM for G Suite
Hi Ross,

among those 'errored' are:
  • application/vnd.google-apps.presentation
  • application/vnd.openxmlformats-officedocument.wordprocessingml.document
  • application/vnd.ms-excel

On Wednesday, 6 March 2019 15:04:40 UTC+1, Ross Scroggs wrote:
K.Z.,

What is the mimeType of the documents that aren't downloaded?
gam user <username> print filelist query "title='<filename>'" id title mimetype

Ross

On Mar 6, 2019, at 4:50 AM, K.Z. <konrad.z...@s-f.com> wrote:

Hi, the app is great, but I'm constantly getting this error for specific files:

Downloading Google Doc: <filename> to /Volumes/.../<filename>.xlsx
Format (xlsx) not available
ERROR: Format (microsoft) not available

This happens for different file types (not only excel), but always the same, is persistent and affects 5-10% of files.
Commands I used (no mather which I use, effect is the same):
gam user <username> get drivefile query "'me' in owners" targetfolder <path> format microsoft
gam user <username> get drivefile query "'me' in owners" targetfolder <path> format openoffice
gam user <username> get drivefile query "'me' in owners" targetfolder <path>

Any ideas what can be the problem?



--
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-manager+unsub...@googlegroups.com.

Jay Lee

unread,
Mar 6, 2019, 10:55:04 AM3/6/19
to google-ap...@googlegroups.com
Do you have a sample doc you can make public or share with Ross and I that exhibit this behavior?

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

--
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 post to this group, send email to google-ap...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/dca9f978-7c52-4893-a0be-db3cd9b98bc2%40googlegroups.com.

K.Z.

unread,
Mar 6, 2019, 12:29:40 PM3/6/19
to GAM for G Suite
Hey,

Unfortunatelly all those documents I've checked is corporate data, so I can not.
I'll try to crawl through those I did not check yet and upload something.

Your tesis for now is that something is specific about the docs, right?
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.

--
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-manager+unsub...@googlegroups.com.

Ross Scroggs

unread,
Mar 6, 2019, 12:52:44 PM3/6/19
to google-ap...@googlegroups.com
K.Z,

Do you have a particular file that always fails?

Ross

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

--
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.

--
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 post to this group, send email to google-ap...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/d71297cb-9911-4dc0-b7b9-c77fba415e04%40googlegroups.com.

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


--

K.Z.

unread,
Mar 6, 2019, 5:14:37 PM3/6/19
to GAM for G Suite
Hi Ross,

I do have at least 150 of them.

To build up the background a bit:
We are making migration from G-Suite to O365 for the whole company (1700 users+)
Since we have almost 300 suspended (de-provisioned) users, which we do not want to migrate (due to license cost...), but have to store their data for a year, GAM was a natural choice.
After archiving 2014 files from 48 users, I got 150+ errors. First idea was that maybe those were shared and in use, when GAM-based script worked. Second time I got errors on the same files.

like I've said I'll find some 'neutral ones' I'm allowed to publish.

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

--
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-manager+unsub...@googlegroups.com.

--
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-manager+unsub...@googlegroups.com.


--

Ross Scroggs

unread,
Mar 6, 2019, 5:35:21 PM3/6/19
to google-ap...@googlegroups.com
K.Z.,

What is your Gam version and what command are you using?

Ross

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

--
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.

--
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.


--

--
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 post to this group, send email to google-ap...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/2f2e721f-6abf-47a2-8197-9306894efe8f%40googlegroups.com.

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


--
Message has been deleted

Robert Smith

unread,
Apr 4, 2019, 8:23:03 AM4/4/19
to GAM for G Suite
I have the same problem. One thing I have noticed is that I get the error "Format (xlsx) not available" for files own by suspended users. Is it possible to add an argument to include suspended users or do I have to update suspended user (=off) before I run this command ?

Ross Scroggs

unread,
Apr 4, 2019, 12:04:14 PM4/4/19
to google-ap...@googlegroups.com
Robert,

You can not download files for suspended users, so yes, you'll have to unsuspend the user, download the file and then suspend the user.

Ross

--
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 post to this group, send email to google-ap...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/aaf3a390-d978-4055-94c0-8a2ceb61c3c6%40googlegroups.com.

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


--

Robert Smith

unread,
Apr 4, 2019, 12:43:13 PM4/4/19
to GAM for G Suite
Thy !!

My workaround is:
  1. gam print users suspended query "orgUnitPath=/xxx" todrive
  2. Make a bash script to temporally change all suspended users to active users
  3. gam update user x...@domain.xx suspended off
  4. Download files
  5. Run the bash script again to suspend users who previous was suspended (change off to on)
So if it's not possible to DL files from suspended users, maybe it's a good idea to change the error msg?


On Thursday, 4 April 2019 18:04:14 UTC+2, Ross Scroggs wrote:
Robert,

You can not download files for suspended users, so yes, you'll have to unsuspend the user, download the file and then suspend the user.

Ross

On Thu, Apr 4, 2019 at 5:23 AM Robert Smith <per-ake....@vasterholm.se> wrote:
I have the same problem. One thing I have noticed is that I get the error "Format (xlsx) not available" for files own by suspended users. Is it possible to add an argument to include suspended users or do I have to update suspended user (=off) before I run this command ?

On Wednesday, 6 March 2019 13:50:09 UTC+1, K.Z. wrote:
Hi, the app is great, but I'm constantly getting this error for specific files:

Downloading Google Doc: <filename> to /Volumes/.../<filename>.xlsx
Format (xlsx) not available
ERROR: Format (microsoft) not available

This happens for different file types (not only excel), but always the same, is persistent and affects 5-10% of files.
Commands I used (no mather which I use, effect is the same):
gam user <username> get drivefile query "'me' in owners" targetfolder <path> format microsoft
gam user <username> get drivefile query "'me' in owners" targetfolder <path> format openoffice
gam user <username> get drivefile query "'me' in owners" targetfolder <path>

Any ideas what can be the problem?


--
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-manager+unsub...@googlegroups.com.


--
Ross Scroggs

Ross Scroggs

unread,
Apr 4, 2019, 1:14:04 PM4/4/19
to google-ap...@googlegroups.com
Robert,

Here is what Google returns:

$ gam user testuser8 get drivefile id abc123xyz

Downloading Google Doc: Sheet to /Users/admin/Documents/GoogleApps/GAM/Sheet.ods


ERROR: Insufficient permissions for this file


Ross

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


--
Ross Scroggs

--
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 post to this group, send email to google-ap...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/dec28cc0-f374-43f6-8041-fa2bb02e305f%40googlegroups.com.

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


--

Robert Smith

unread,
Apr 4, 2019, 1:22:53 PM4/4/19
to GAM for G Suite
That is nice error, but when I run

gam ou_and_children xxx get drivefile query "title contains 'xxx' and 'me' in owners" targetfolder /Volumes/Apricorn/xxx

I get the "Format (xxx) not available" Error
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.


--
Ross Scroggs

--
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-manager+unsub...@googlegroups.com.


--
Ross Scroggs

Ross Scroggs

unread,
Apr 4, 2019, 1:28:32 PM4/4/19
to google-ap...@googlegroups.com
Robert,

What I showed you is based on making a change to Gam; it was to illustrate that Google doesn't say anything about the user being suspended.

Ross

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


--
Ross Scroggs

--
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.


--
Ross Scroggs

--
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 post to this group, send email to google-ap...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/80334625-f7c8-442b-aadc-62263a01db87%40googlegroups.com.

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


--

Robert Smith

unread,
Apr 4, 2019, 1:39:05 PM4/4/19
to GAM for G Suite
True :)

But "Insufficient permissions for this file" is better when "Format (xxx) not available"
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.


--
Ross Scroggs

--
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-manager+unsub...@googlegroups.com.


--
Ross Scroggs

--
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-manager+unsub...@googlegroups.com.


--
Ross Scroggs

Steve - DynTech

unread,
Apr 4, 2019, 11:52:51 PM4/4/19
to GAM for G Suite
K.Z - Save yourself the trouble and just downgrade the user to Cloud Identity Free licenses. This way the data on the user account remains as it is. You just can't login as that user and access Gmail/Drive/etc.

The data stays in the account and you can add a license back to the user if you need to. All documents that the user owns, that you don't transfer to a new owner for example, remain accessible by any other users that are shared on them.

I talk about this in a bit more detail in my doc.
Reply all
Reply to author
Forward
0 new messages