Export Google Forms as PDF with GAMADV-XTD3

[Patrick Rhodes]

We are in the midst of a partial migration and need to export all Google Forms as PDFs to ensure the data is captured prior to migration. Is this possible with GAMADV-XTD3? I tried 'get drivefile' but I am getting a "Format not downloadable" error. 

Please advise ASAP. 

[Ross Scroggs]

Patrick,

Show me the command you executed.

Ross

On Tue, Oct 1, 2019 at 9:05 AM Patrick Rhodes <patrick...@enproindustries.com> wrote:

We are in the midst of a partial migration and need to export all Google Forms as PDFs to ensure the data is captured prior to migration. Is this possible with GAMADV-XTD3? I tried 'get drivefile' but I am getting a "Format not downloadable" error. 

Please advise ASAP. 

----------Legal Disclaimer----------

The information contained in this message may be privileged and confidential, and is intended solely for the use of the named addressee. No other person is authorized to access, copy or re-use this message (or any information contained herein). If you are not the intended recipient, please notify us immediately by replying to this message and delete it from your computer.

--
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/05ba50cd-47c0-4a01-8fe4-b81589b834a0%40googlegroups.com.

--

Ross Scroggs

ross.s...@gmail.com

[Patrick Rhodes]

Ross,

gam user email.address get drivefile formID format pdf

gam user email.address get drivefile formID

Both returned "User: patrick...@enproindustries.com, Drive File: Power Users Authorization Form, Not Downloaded: Format not downloadable"

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAJkvRS-7gioOSBVKL80ghArO-fvgaeJ%2BcDsvneAmrxayfVZ6WA%40mail.gmail.com.

[Ross Scroggs]

Patrick,

As far as I can tell, Google Forms are not exportable through the API.

Ross

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAHa9RzYaVgO5uhDM5FCxQ7DLDDHSG%2BzyzBv3sbXoTOzCLw54Lg%40mail.gmail.com.

--

Ross Scroggs

ross.s...@gmail.com

[Patrick Rhodes]

Ross,

That was my worry. So I guess I am SOL at this point then?

Thank you,

Patrick Rhodes
Solutions Engineer – Productivity Applications
 
315-597-3931 (W)
585-204-7616 (GVoice)

Patrick...@EnProIndustries.com

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAJkvRS-DwfT8o1i7Of2n10L-TagmXsHAfBQG%3DPoDZVBmRoJibQ%40mail.gmail.com.

[Ross Scroggs]

Patrick,

If you search for "export Google forms pdf" you get various hits; it appears to me that they are exporting submissions but what I know about forms is minimal.

Ross

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/CAHa9RzYkN4jSeNHaY6C-Qw9YCByHzRhw2kHk0Jr2zrP6c7k_7w%40mail.gmail.com.

--

Ross Scroggs

ross.s...@gmail.com

[+KimNilsson]

Patrick, use Google Takeout.

When you let it stay on XLSX it'll export the answers to a Excel, and your Form to an HTML file, and your answers once more as a CSV.

https://takeout.google.com

[Simon Laycock]

Just resurrecting this thread in the hope that things may have changed... We are being moved to Office 365 in a couple of weeks and there is no way to migrate all the Forms people have created. I had hoped to be able to iterate over their drives and at least convert the forms to PDF, which would preserve the questions and possible responses, but this doesn't seem possible. 

When I do gam user <username> get drivefile <fileid> format pdf I just get "Not Downloaded: Format not downloadable"

There must be a better way than telling people to open each individual form and print as pdf, mustn't there? (I'm using GAMADV-XTD3).

[Kim Nilsson]

No, you can't even download a Form in the Drive interface.

That usually means it's not going to be possible via API either.

Manually open each individual Form, and print - that's the only way.

/Kim

[Kim Nilsson]

Or, do as I said last time.

Export them with Takeout.

/Kim

[Ian Crew]

The Forms API also allows you to “GET” both the form and its responses, so maybe that’d be even more useful, as it’d give you the forms in JSON format, which might be more useful than a PDF to recreate things on the other side (via Power Automate or something, perhaps? I’m far less familiar on the MS365 side,)

Cheers,

Ian

--
You received this message because you are subscribed to the Google Groups "GAM for Google Workspace" 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/CAGPzzFv%2BfQaGtFLePc7WXd%3DBKodq9g879yAeZYbOkmsjh%3D12%3DQ%40mail.gmail.com.

 

Ian Crew Solutions Architect Productivity & Collaboration Services Berkeley IT

[Simon Laycock]

Thanks for responding. I can't believe there's no sensible way of doing this in 2022!

Kim - I couldn't see a way to specify just forms in takeout, and I don't want them downloading all their drive data as it will then be duplicated. Am I missing something?

Ian - I did have a quick go at getting the JSON with get document, but I think I need to authorize another scope for GAM and I couldn't remember how to do that. I am led to believe that there are no import tools for Microsoft Forms though, so it probably wouldn't be worth persevering.

[Kim Nilsson]

No data will be duplicated unless you upload everything again. Point is to separate the form data once downloaded.

Then migrate everything else as planned. 

Afterwards, they will have the form data to look at when creating new MS Forms. 

From the start we know there is no proper migration possible, so it's just a question of how to make the downloaded content as easy to work with as possible. 

You will have to test the alternatives to really see which your users prefer. 

[James SEYMOUR]

Hi Simon,

Enabling the API should be easy. I was looking into the JSON option and came up against, this.

I was testing;-

gam user <User Email> print forms <Drive ID> todrive formatjson

The error message includes the URL you need to visit (by clicking on it) and then on the page, you just need to click on the 'accept' button.
ERROR: 403: permissionDenied - Google Forms API has not been used in project XXXXXXX before or it is disabled. Enable it by visiting https://console.developers.google.com/apis/api/forms.googleapis.com/overview?project=XXXXXXX then retry. If you enabled this API recently, wait a few minutes for the action to propagate to our systems and retry.

After that the command just worked.

From https://github.com/taers232c/GAMADV-XTD3/wiki/Users-Forms#display-forms this option may be useful if you go forward with JSON

The quotechar <Character> option allows you to choose an alternate quote character, single quote for instance, that makes for readable/processable output. quotechar defaults to gam.cfg/csv_output_quote_char.

Cheers

James

[Ross Scroggs]

Simion/James,

The correct response to any message about an API not enabled is:

gam update project

gam oauth create

gam user us...@domain.com check serviceaccount

Ross

--

ross.s...@gmail.com

Jerudong International School
https://www.jerudonginternationalschool.com

Follow us on:

    

--
You received this message because you are subscribed to the Google Groups "GAM for Google Workspace" 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/33ac83cc-f36a-4d8c-8bb6-60440022da0an%40googlegroups.com.

[Simon Laycock]

Hmm. I've tried both what James said (although I never got the error you mentioned, just the one I've copied below) and also what Ross said, but even after passing all the service account checks I still get:

ERROR: API access Denied
Please make sure the Service Account Client name: xxxxx is authorized for the appropriate API or scopes:
Forms API

Do I need to specify to GAM that I need the Forms API? It's enabled when I look online:

Thanks,

Simon

[Ross Scroggs]

Simon,

Try: gam user us...@domain.com update serviceaccount

Make sure that the Forms API is enabled.

Ross

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/de57c0c5-75ae-4691-8541-e1f7caa3243fn%40googlegroups.com.

--

Ross Scroggs

ross.s...@gmail.com

[Simon Laycock]

Thanks Ross. I'm home from work now but will try that in the morning. I can't access GAM from home.

You received this message because you are subscribed to a topic in the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-manager/L5JHUs50azE/unsubscribe.
To unsubscribe from this group and all its topics, 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/CAJkvRS8MbVyz5Wd2GJjSp0v6tXbK%2BvOY66EVDYmo82j_%2BdGrGA%40mail.gmail.com.

[Simon Laycock]

OK, thank you both. I remembered my laptop had GAM on it and once updated to the latest version, running the update and oauth steps sorted it out. (I see you have updated GAM today, Ross!).

The output is interesting - it would need quite a bit of work to get it back into a usable format I think! Is formatjson the only option or can I get it as anything else (Word/PDF for example?).

[Simon Laycock]

Just a small update, MS tweeted last night that Microsoft Forms would gain the ability to import paper forms. I asked if this included PDFs from Google forms and they said yes. If only I could bulk save to PDF!