Google Sheets Connector Issue
Welcome to QSM Support Forum. › Forums › QSM Pro Support › Google Sheets Connector Issue
Tagged: Add-On, Google Sheets
- This topic has 13 replies, 5 voices, and was last updated 4 years, 8 months ago by Kriti Sharma.
-
AuthorPosts
-
March 3, 2020 at 12:58 pm #2558[email protected]Participant
Hi,
I purchased the Google Sheets Connector Addon and I haven’t been able to get it to work. Here’s what’s happening:
I configured my Google Access Code and that seems to be working.
I added a Google Sheet Name and Google Sheet Tab to an existing survey.
The survey has a pool of 40 questions, and I have it set so that each user gets a random set of 5 questions to answer.
While the Google Sheet is configured, when a user clicks submit at the end of the survey, the loading circle spins forever – I’ve let it go for 10 minutes and it’s still spinning.
When I check the Google Sheet, I see that a couple of answers have come through, but that’s it.Any help would be much appreciated.
Thanks,
Mike BakerMarch 4, 2020 at 6:35 am #2568Kriti SharmaKeymasterHi Mike,
Welcome to Qsm Pro Support Forum. Hope you are doing well.
I request you to please share the website’s admin credentials with me so that I can look into the issue. Make sure to set the message as private before sharing the credentials.
Kind regards,
KritiMarch 4, 2020 at 6:34 pm #2581[email protected]ParticipantHi Kriti,
I’m not really comfortable giving out the admin credentials to my website. Perhaps we could schedule a time for a screen sharing session?
Thanks,
Mike BakerMarch 4, 2020 at 7:00 pm #2582Kriti SharmaKeymasterHi Mike,
I need to talk to the development team regarding this.
Regards,
KritiMarch 5, 2020 at 2:46 pm #2604Kriti SharmaKeymasterHi,
Please put the following into the end of his .htaccess file and see if it helps.
php_value memory_limit 256M php_value max_input_vars 4000
These are values to tell the web server to increase memory and max_input_vars so that it can process larger amount of data.
Use the following plugin to check if the values have been increase, after adding the above mention in .htaccess file.
If not, you will have to ask web hosting company for help to increase those values.
Regards,
KritiMarch 19, 2020 at 11:14 pm #2751[email protected]ParticipantHi,
I just installed this Addon and I have the same problem, I have already put in htaccess what they have suggested, but it still doesn’t work. Please help.
March 23, 2020 at 9:37 am #2797Kriti SharmaKeymasterI have forwarded your issue to the development team.
Kriti
March 31, 2020 at 2:09 pm #2958Tim WParticipantHi, I am trying to get this plugin to work and having the same problem. Some issues below.
1. The integration is not google verified and there is a security warning. Whe will the app integration be verified. This is important if it is to be used with client data, we need to be sure that the solution is secure?
2. The plugin installs and the configuration appears to be successful when the license is installed
3. When completing a quiz, clicking submit results in the spinner continuously displaying and no confirmation that the dta is stored – as it noramlly did prior to enabling google sheets
4. When opening the google sheet, the questions appear but not the results
5. I can’t find detailed documentation to explain other configuration options in case I am doing something wrongThanks
TimMarch 31, 2020 at 5:00 pm #2961Kriti SharmaKeymasterHi Tim,
We just released the latest version of the plugin, please update it to the latest version and please let me know whether the issue persists or resolves.
Regards,
KritiMarch 31, 2020 at 5:17 pm #2962Tim WParticipantHi Kriti, yes I upgraded and this is the problem situation when using the lastest version.
Thanks
TimMarch 31, 2020 at 6:13 pm #2964[email protected]ParticipantI have the same problems.
April 1, 2020 at 7:41 am #2978Kriti SharmaKeymasterHi,
I have forwarded your issues to the development team.
Regards,
KritiApril 1, 2020 at 5:05 pm #2988[email protected]ParticipantI have updated to the latest version and it works correctly, I no longer have a problem at the end of the test, it shows the results page and exports the contact data to Google correctly.
Thanks to the support team for their timely support!April 2, 2020 at 7:38 am #3002Kriti SharmaKeymasterHi all,
There is no problem in the plugin now. I am able to use it properly. Please see my screen-cast.
https://drive.google.com/file/d/1MDeToKwJa6RRgHSSeql3Xb_6lwowHjuH/view
After updating all plugins, please clear any server cache or cache plugin’s cache content as well as browser history before using the plugin.
We request you to create a new googlesheet and try it out.
If you are still stuck at spinning icon, this could mean that is a javascript error on the website.
In this case, we request you to check for plugin conflict or theme conflict.
Regards,
Kriti -
AuthorPosts
- You must be logged in to reply to this topic.