Forums

Hello,

since days I try to upload data to GoogleDrive in an spreadsheet.
See as attachment the configuration and format of spreadsheet.

I add my email address and password to the form, but I got this
error:

[9] => Array
(
[Google Spreadsheet Save] => Array
(
[Authentication] => Failed
)

)

What´s going wrong?

Best regards
Michael

Sorry, here is the picture

Hi Michael,

The Data Path entry should just be GSheet. Please try that.

Bob

Hi Bob,

now I add only "GSheet" in Data Path.

But again: [Authentication] => Failed

email-address is correct
password is correct
name of spreadsheet is correct

Hi michaelnrw,

That's a second problem I fear - Google changed the Authentication earlier this year to make it more secure and Max hasn't yet updated the standard action. I have sent you a PM with a link to download my GSheet Save [GH] action plus the Google API library.

Bob

Hi Bob,

thanks for your massage. It looks like I have access now.
But there is an other error:

 [GSheet Save [GH]] => Array
        (
            [0] => No data found to save
        )

I am not a PHP expert, but I think this could happen because the Array is empty.

To add wished parameters to Spreadsheet, what I have to do?

My Data:

Array
(
    [option] => com_chronoforms5
    [chronoform] => Hochlade_inkl_Kontaktdaten
    [event] => submit
    [first_name] => Michael // save this
    [last_name] => abc // save this
    [email] => michael.abc@de.de // save this
    [phone] => 2222222 // save this
    [address] => strasse // save this
    [city] =>stadt // save this
    [state] => 
    [zip] => 
    [message] => dsgdsgdsgdsgdsgdsgsd // save this
    [checkbox13] => ja // save this
    [captcha] => 
    [submit6] => Absenden
    [file12] => 20161119_Michael_abc_upload.JPG // save this
    [ip_address] => 93.192.yyy.yyy
    [id] => 9
)

The marked ones I want to add.

Best regards
Michael

Hi Michael,

You are correct - the data array is empty, That's probably because you haven't added any data to it.

The data path setting in the action looks for a sub-array of the form data. You can either use the data path in the element names, or use a Custom code action to copy it over in the On Submit event. With the Data path 'Gsheet' that would be like this

<?php
$form->data['GSheet']['first_name'] = $form->data['first_name'];
$form->data['GSheet']['last_name'] = $form->data['last_name'];
. . .
?>

Bob

Hi,

I'm going crazy with the GSheet Save [GH] action. I have been using them for months. My website migrated to a new server last week (the address-domain is still the same -fepemur.org-). I updated joomla version... But no matter how hard I try and how many different ways I test, I can make it work. This is what I get every time:


Please, help me!

Thanks in advance for your support!

Hi antoniorh9,

I can only suggest that you check with your web-host - it looks as though the Connection to Google is being blocked. You might get more clues by turning Site Debug on temporarily but I don't think that the action is the immediate problem here. If you see the line in the code where the error is being triggered that might help a bit.

Bob

Hi Bob,

I'm having the same issue with failed authentication.

Would it be possible to try your action that you described earlier?

Thanks

Mark

Hi Mark,

I have PMd you a link.

Bob

I had the same issue, worked on it a bit more, added the custom code to create my data array, and now when I submit my test form I get an unable to parse the p12 file error.

For other readers:

Mark got this to work using these notes I sent him:

It looks as though Google have changed the API set up a bit. When it says what kind of credentials do you want there is an option to ask a few questions.

+ Which API are you using: Google Drive API

+ Where will you be calling the API from: Web server

+ What data will you be accessing: Application data

+ Are you using . . . : No I'm not using them.

The next screen will let you create an email, etc.

Bob