Visitor counter + Google spreadsheet, update for 2013

Update: At Oct. 8, 2014 Maria Korolov published new and easier way how to log visitors to Google spreadsheet. Please try her version first.

If you want to log visitors of your region or parcel to spreadsheet, it is possible even in new Google Drive. This howto is made for spreadsheets in August 2013 and it works properly.
You do not need any special skills like programming or inworld scripting.

1. step

Thanks to Maria Korolov, for the idea and very nice and descriptive article. Her instructions are part one. My howto explaining how to change the Google URL and inworld script to work with current Google forms.
Make your new Google form as described in article, get the form URL.
Read more info about script there, if you want. Download Maria’s script, if you would like to study the changes.

2. step

Bellow is my complete script for your inworld counter. Before you use it, you have to change some parts of script. It is not working as is!

Your current URL for view the form looks like this one:

https://docs.google.com/forms/d/XXXXXXXXXXXXXXXX/viewform

where XXXX… is your unique ID for this form.

You have to change several parts of script:

First line of script – insert your Google form ID above
string google_formkey = "XXXX...."; //MUST REPLACE with your own Google form key

Next part for change is explained by Maria – if you want log in your avatar.
If the owner of inworld object with script has to be logged, comment this line:
//if( llDetectedKey( i ) != llGetOwner() )

If you do not want to log in your avatar, let it uncommented:
if( llDetectedKey( i ) != llGetOwner() )

Tha last part is most tricky.
In my script you can find this line:
string URL = "https://docs.google.com/forms/d/" + google_formkey + "/formResponse" + "?entry.YYY=" + detected_name + "&entry.ZZZ=" + region_name + "&submit=Submit";

All blue parts has to be replaced by your values.
My values above representing this URL:
https://docs.google.com/forms/d/XXXX…/formResponse?entry.724632390=AVATARNAME&entry.57313582=REGIONNAME&submit=Submit

Devide your URL to following parts:
First part is before XXXX… (your unique ID), in my case "https://docs.google.com/forms/d/"
Next is your Google form ID, it is loaded at first line of script in string google_formkey
Add the rest of URL between Form ID and question mark, in my case "/formResponse"
Add ID of your entries. First one starting with question mark (?), other ones starting with ampersand (&)

How to find your entries IDs?
For some reason Google do not use neat entry IDs like “entry.1″ and “entry.2″ anymore, but some random numbers.
You can find it in HTML code of your form. On the form page rightclick on the word “Avatar” and find “Inspect element,” “Show source code” or similar option, depending on your browser. It shows the code and probably highlight the element of “Avatar.” See the picture bellow.
Find the IDs of your elements and replace them in your script – "entry.YYY" by Avatar value and "entry.ZZZ" by Region value.

You can check the correct values even without scripting and logging inworld. Put together your URL with your values:
https://docs.google.com/forms/d/XXXX…/formResponse?entry.724632390=AVATARNAME&entry.57313582=REGIONNAME&submit=Submit

Replace AVATARNAME and REGIONNAME by any values you choose.
Insert URL into your browser and press Enter. If you get error message, you made a mistake. If your URL is right, Google thanks you for submiting your answer and you just manually insert first visitor to your spreadsheet!

Download sample script. Works in OpenSim.
Download Second Life version of script. (Escaped avatar name)

Insert script with proper values to your object inworld. It is done.

I hope this howto will be helpful. If you find very different Google form URL or if it does not work for you (and you are absolutely sure it is not your typo), let me know in discussion.

14 Responses to "Visitor counter + Google spreadsheet, update for 2013"

Rycon says:

15.9.2013 at 15.05

Seem to having an issue and this is an issue I had even with Maria’s first script. I’d get everything all set up and it’ll work manualy entering but it won’t actually log automatically from Second Life. Any help on the matter would be apreciated.

Reply
1. Zuza Ritt says:
  
  15.9.2013 at 23.33
  
  Hello Rycon. There is a different version of script for SL. Did you use this version? Your description fits to the problem with OpenSim version of script in SL.
  
  Reply
  1. Rycon says:
    
    2.10.2013 at 22.18
    
    I attempted to use both versions and neither one worked. Is there a specific version I should be using for Second Life?
    
    Reply
    1. Zuza Ritt says:
      
      10.10.2013 at 12.29
      
      The “SL version” as above is the one for SL.
      I guess you double checked your numbers in code and it is still not working? Is the structure of your form numbers significantly different from my one or it is the same?
      Are you the one who contacted me in SL? I sent you my email…
      
      Reply
      1. Rycon says:
        
        13.10.2013 at 22.42
        
        i dont think so, but let me give it another go and if it doesnt work i’ll send you my code in world so we can see whats going on.
harmar says:

8.12.2013 at 4.16

I seam to be getting an error as well, I receive a 400 error “Your client has issued a malformed or illegal request.” but it only happens from within SL. doing the link on its own on a browser works

Reply
1. Zuza Ritt says:
  
  8.12.2013 at 12.56
  
  hi harmar, do you use the different version of script for SL?
  
  Reply
harmar says:

8.12.2013 at 21.17

yes, I use the SL version

Reply
Josh says:

23.1.2014 at 20.43

I’ve got an idea, but not sure how to implement it. we have a device that people have to click, either they say yes or they say no. we have no way of logging who did what with it. but I know it does say “Thanks for your answer. we would like to collect this information into a google doc and found this script and we see it logs to the doc it’s self with this script.

So as I am code dumb, how would one modify this to listen to specific words and log them to the doc?

Reply
Nick Chater says:

16.4.2014 at 16.42

Followed your instructions to the letter and I have tried out the script you said direct to the URL and it works but it does not work in OpenSim! Arghhh:

Is this bit wrong:

string URL = “https://docs.google.com/forms/d/myidcodeinhere/formResponse?entry.387801594=” + detected_name + “&entry.818337028=” + region_name + “&submit=Submit”;

Reply
1. Zuza Ritt says:
  
  17.4.2014 at 15.27
  
  Hi Nick,
  looks OK for me. Currently I am getting longer numbers as entry IDs, at least 10 digits, but it could be random. Hope you using OpenSim version in Opensim, not the SL one…
  Is your script in Opensim starting? There is “Visitor recording script started…” in local chat, if script is running. You can restart the script in object or simply take it and rez again for restart of script.
  
  Reply
Araminta Hexx says:

23.4.2015 at 5.10

I was on the right track with Maria’s script, and had found the entry.XXXXX keys in the form just as you described, but I wasn’t quite sure exactly where they needed to go until looking at your updated code. This post answered that question for me. Thank you!

I did modify a teensy bit so that the avatar and location form field variables are not hard-coded. This should make it easier for a novice to modify the script without accidentally futzing something up.

string google_formkey = "XXXXXXXXXXXXXXXXX"; //MUST REPLACE with your own Google form key string location_key = "entry.XXXXXXXXX"; // Replace with the location field key string avatar_key = "entry.XXXXXXXXX"; // Replace with the avatar field key
// Do not edit below this line unless you know what you're doing. integer list_size = 10; //how many avatar names to keep in memory float range = 96.0; // in meters float rate = 1.0; // in seconds // Script Name: Google Spreadsheet Visitor Recorder // By Maria Korolov of Hypergrid Business // Edited by Zuza Ritt in August 2013 // Adapted from Visitor_List_Maker.lsl // And from Hyperica Lookup HG Teleport Script (with code contributed by Paul Emery) // This program is free software; you can redistribute it and/or modify it. // Creative Commons licenses apply to all scripts from the Second Life // wiki and script library and are Copyrighted by Linden Lab. See // http://creativecommons.org/licenses/ // Please leave any author credits and headers intact in any script you use or publish. // If you don't like these restrictions, then don't use these scripts. // Global variables list visitor_list; string region_name; integer len; // Functions integer isNameOnList( string name ) { len = llGetListLength( visitor_list ); integer i; for( i = 0; i < len; i++ ) { if( llList2String(visitor_list, i) == name ) { return TRUE; } } return FALSE; } // States default { state_entry() { llSay(0, "Visitor recording script started..."); llSensorRepeat( "", "", AGENT, range, TWO_PI, rate ); llListen(0, "", llGetOwner(), ""); region_name= llGetRegionName(); } sensor( integer number_detected ) { integer i; for( i = 0; i list_size) { visitor_list = llDeleteSubList(visitor_list,0,0); } } } } }
// END //

Reply
1. Araminta Hexx says:
  
  23.4.2015 at 5.15
  
  Not quite sure what happened to my reply. I did use the code attribute. Hmm. So, in short….
  
  Input strings at the top of the script:
  
  string google_formkey = “XXXXXXXXXXXXXXXX”; //MUST REPLACE with your own Google form key
  string location_key = “entry.XXXX”; // Replace with the location field key
  string avatar_key = “entry.XXXX”; // Replace with the avatar field key
  
  Output string at the bottom of the script:
  
  string URL = “https://docs.google.com/forms/d/” + google_formkey + “/formResponse” + “?” + avatar_key + “=” + detected_name + “&” + location_key + “=” + region_name + “&submit=Submit”
  
  Reply
  1. Zuza Ritt says:
    
    23.4.2015 at 9.50
    
    Araminta, thanks for your modification.
    Replies are not automatically published because of big amount of spam. I let both your comments here, full script and changed lines only, hope it is OK for you:)
    
    Reply

1. step

2. step

Leave a Reply to Rycon Cancel reply