Bienvenido, Invitado
Recordarme

TEMA:

Google Drive connection does not authorize anymore 1 año 3 meses antes #262869

  • Autor del tema
  • hoekbrwr
  • Fuera de línea
  • Senior Breezer
  • Senior Breezer
  • Mensajes: 104
  • Gracias recibidas: 5
Just a thought!

After the changes Google made to their systems a few weeks ago I had a problem with reading data from a Google spreadsheet and solved that by using Papa Parse 5 ( www.papaparse.com/docs#json-to-csv ).

Maybe that's the way to solve this problem. I only did a read, but it seems it can also write to Sheets.
El siguiente usuario dijo gracias: tihana.krivic, Mirec

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

Google Drive connection does not authorize anymore 1 año 3 meses antes #262870

  • Avatar de Mirec
  • Mirec
  • Fuera de línea
  • Ultimate Breezer
  • Ultimate Breezer
  • Mensajes: 3265
  • Karma: 2
  • Gracias recibidas: 160
Hi,

I'm glad you solve it! :)

can you please share your solution with the community on how you did it (step by step), it will be great as a temporary solution, while we fix problems with google drive

Thank you!
regards,
Mirko

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

Última Edición: Post by Mirec.

Google Drive connection does not authorize anymore 1 año 3 meses antes #262883

  • Autor del tema
  • hoekbrwr
  • Fuera de línea
  • Senior Breezer
  • Senior Breezer
  • Mensajes: 104
  • Gracias recibidas: 5

Mirec escribió: Hi,

I'm glad you solve it! :)

can you please share your solution with the community on how you did it (step by step), it will be great as a temporary solution, while we fix problems with google drive

Thank you!
regards,
Mirko


I don't have an automated solution to the GD write problem.

As an emergency method I manually select records from the form, export them to a csv file and import them in Excel with the commands Data/From Text/CSV. The same can be done in Google Sheets File/Import/Upload and drag/drop the CSV file in the file area.

Voor reading select lists from Google Sheets I have published the sheet as on the Web, File/Publish to the web. Formerly I used Tabletop and you can find the change procedure with examples on github.com/jsoma/tabletop .

I have a little piece of the init sheet from my form
function ff_inschrijven_ndo_init() {
	//Vul alle leden  in de lijst met trainers/dansscholen in het veld met de naam trainer_org
	 Papa.parse('copy link from the publishing procedure', 
	 {
		download: true,
		complete: cb_ledenlijst,
		header: true,
	})

	function cb_ledenlijst(results) {
		var data = results.data		
		console.log(data);
		for (l = 0; l < data.length; l++) {
			var opt = document.createElement("option");
			opt.text = data[l]["Dansleraar/trainer"] + ", " + data[l]["Plaatsnaam"];
			opt.setAttribute("value", data[l]["Dansleraar/trainer"] + ", " + data[l]["Plaatsnaam"]);
			ff_getElementByName('trainer_org').options.add(opt);
		}
	}
} // ff_inschrijven_ndo_init

Sorry for the dutch comments.

I have written this, as is, and please don't ask me questions. It is just to point in the right direction if it applies to you!

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

Google Drive connection does not authorize anymore 1 año 3 meses antes #262887

  • Avatar de Mirec
  • Mirec
  • Fuera de línea
  • Ultimate Breezer
  • Ultimate Breezer
  • Mensajes: 3265
  • Karma: 2
  • Gracias recibidas: 160
Hi,

okay, thank you for sharing this with the community! :)

Reagrds,
Mirko

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

Google Drive connection does not authorize anymore 1 año 2 meses antes #263081

Hi,
fisrt steps of the tuto is ok but when I arrive to :

3)after that Google Drive in located in form->Advanced->More options->Google Drive->click on Sign up with google and you will get "key" -> copy it and save

>>> Nothing happens after filling the "key"

Regards
Pierre

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

Última Edición: Post by kino.

Google Drive connection does not authorize anymore 1 año 2 meses antes #263082

  • Avatar de Mirec
  • Mirec
  • Fuera de línea
  • Ultimate Breezer
  • Ultimate Breezer
  • Mensajes: 3265
  • Karma: 2
  • Gracias recibidas: 160
Hi,

we have a problem with communication with google drive and we working hard to solve it. We will inform you here when we will be done!

Thank you for understanding!
If you have more questions, feel free to ask!
Regards,
Mirko

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

  • Página:
  • 1
  • 2
Tiempo de carga de la página: 0.047 segundos