TOPIC:

Google Drive connection does not authorize anymore 3 weeks 6 days ago #262869

  • Topic Author
  • hoekbrwr
  • Offline
  • Senior Breezer
  • Senior Breezer
  • Posts: 91
  • Thanks: 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.
The following user(s) said Thank You: tihana.krivic, Mirec

Please Log in or Create an account to join the conversation.

Google Drive connection does not authorize anymore 3 weeks 6 days ago #262870

  • Mirec's Avatar
  • Mirec
  • Offline
  • Ultimate Breezer
  • Ultimate Breezer
  • Posts: 957
  • Karma: 2
  • Thanks: 50
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

Please Log in or Create an account to join the conversation.

Last edit: Post by Mirec.

Google Drive connection does not authorize anymore 3 weeks 6 days ago #262883

  • Topic Author
  • hoekbrwr
  • Offline
  • Senior Breezer
  • Senior Breezer
  • Posts: 91
  • Thanks: 5

Mirec wrote: 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!

Please Log in or Create an account to join the conversation.

Google Drive connection does not authorize anymore 3 weeks 6 days ago #262887

  • Mirec's Avatar
  • Mirec
  • Offline
  • Ultimate Breezer
  • Ultimate Breezer
  • Posts: 957
  • Karma: 2
  • Thanks: 50
Hi,

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

Reagrds,
Mirko

Please Log in or Create an account to join the conversation.

Google Drive connection does not authorize anymore 3 weeks 10 hours ago #263081

  • kino
  • Offline
  • Junior Breezer
  • Junior Breezer
  • Posts: 23
  • Thanks: 0
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

Please Log in or Create an account to join the conversation.

Last edit: Post by kino.

Google Drive connection does not authorize anymore 3 weeks 10 hours ago #263082

  • Mirec's Avatar
  • Mirec
  • Offline
  • Ultimate Breezer
  • Ultimate Breezer
  • Posts: 957
  • Karma: 2
  • Thanks: 50
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

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
  • 2
Time to create page: 0.048 seconds

BreezingForms Pro 1.4.7 for WordPress Released!

Available in the membership section.

September Discount!

Massive discounts on all subscriptions!

Get Your Subscription Here

Quick Links

Downloads

BreezingForms

ContentBuilder

BreezingCommerce

Templates

Documentation

BreezingForms

ContentBuilder

BreezingCommerce

Apprendre BreezingForms (French Community)

Apprendre et maîtriser BreezingForms par des tutoriels et exemples, le tout en français

breezingforms.eddy-vh.com

Questions et réponses sur les forums de l'AFUJ

AFUJ

Special Offer

Summer Sale! All subscriptions at a special price!

Includes prio support, all of our current and future Joomla!® extensions and Joomla!® templates for the duration of your membership.

Get it from here

3rd Party Discount - 25% Off

We help you to keep your costs under control. If you are a new member and purchased a form building tool from a different form vendor, then you'll get a 25% discount on our subscription plans.

How to receive the discount:

Send us a quick email to sales@crosstec.org with a proof of purchase (for example a paypal receipt), await payment instructions and enjoy your membership!