Recording visitors to a Google spreadsheet

Creating scripts
Post Reply
User avatar
Serene Jewell
Posts: 336
Joined: Thu Dec 27, 2012 6:12 am
Has thanked: 636 times
Been thanked: 397 times

Recording visitors to a Google spreadsheet

Post by Serene Jewell » Thu Aug 11, 2016 10:34 pm

Aaron Griffiths has been posting some informative articles about how he creates worlds in Opensim. In a recent post, he outlines a method for recording visitors to a Google spreadsheet and gives the script and instructions.

https://fxualeducation.wordpress.com/20 ... readsheet/
These users thanked the author Serene Jewell for the post (total 3):
Ilan TochnerConstance PeregrineSelby Evans
User avatar
Ilan Tochner
Posts: 5026
Joined: Sun Dec 23, 2012 8:44 am
Has thanked: 2786 times
Been thanked: 2815 times
Contact:

Re: Recording visitors to a Google spreadsheet

Post by Ilan Tochner » Fri Aug 12, 2016 1:40 am

Thank you Serene,

I think it is worth mentioning that Kitely already tracks world visits and logs them in people's Account History pages: https://www.kitely.com/history

Each Kitely account's History page also includes a link to download the history report.
These users thanked the author Ilan Tochner for the post (total 5):
Genavieve PageSelby EvansFreda FrostbiteConstance PeregrineLorelei Seetan
User avatar
Genavieve Page
Posts: 48
Joined: Thu Jun 02, 2016 2:54 pm
Has thanked: 87 times
Been thanked: 33 times

Re: Recording visitors to a Google spreadsheet

Post by Genavieve Page » Fri Aug 12, 2016 2:12 am

Ilan Tochner wrote:Thank you Serene,

I think it is worth mentioning that Kitely already tracks world visits and logs them in people's Account History pages: https://www.kitely.com/history

Each Kitely account's History page also includes a link to download the history report.


I found this out myself awhile ago and think its a great feature that Kitely has.. really like this inclusion, makes it easy to track and keep a log
These users thanked the author Genavieve Page for the post (total 3):
Ilan TochnerSelby EvansFreda Frostbite
User avatar
Aaron Griffiths
Posts: 25
Joined: Thu Aug 01, 2013 7:21 am
Location: New Zealand
Has thanked: 0
Been thanked: 8 times
Contact:

Re: Recording visitors to a Google spreadsheet

Post by Aaron Griffiths » Sat Sep 17, 2016 5:33 am

Thanks for mentioning this here Serene and thanks also Ilan for bringing up the History capability. In this particular case the data research is being carried out by someone who isn't the sim owner so creating an option that didn't require my input required consideration. I think also, as the research progresses, they will find it useful to know specifically which parcels (different areas of the ancient reconstruction) people focus on rather just knowing they have visited the sim.

The script, in particular the function that captures data and sends it to a Google spreadsheet, may also be usefully adapted for capturing how learners interact with exhibits, learning activities etc.
These users thanked the author Aaron Griffiths for the post:
Selby Evans
Aaron Griffiths in RL and Kitely
Isa Goodman in Second Life
Current Kitely Development: Occupational Medicine Simulation
F/Xual Education Services
User avatar
Kurtis Anatine
Posts: 23
Joined: Thu Jun 30, 2016 10:33 pm
Has thanked: 3 times
Been thanked: 32 times

Re: Recording visitors to a Google spreadsheet

Post by Kurtis Anatine » Tue Oct 11, 2016 6:45 am

I was looking into this a while back for someone and there is a way to do it! It would involve a prim in world and a webserver of sorts to handle the data.

I could make a little example for it for you if you like :)

EDIT: Totally had a look into this, Google API's are super stupid to look at late at night when you are tired.
User avatar
Arton Tripsa
Posts: 62
Joined: Tue Oct 01, 2013 12:28 am
Has thanked: 57 times
Been thanked: 31 times

Re: Recording visitors to a Google spreadsheet

Post by Arton Tripsa » Wed Oct 12, 2016 2:40 am

What would also be very good Kurtis would be if someone could make a prim inworld that read the data off Google calendar. The final product would be an event board that could be updated outworld on Google calendar. Ruud Lathrop used to sell one in SL. I am sure lots of folks would love this :-) Well I would lol :-)
These users thanked the author Arton Tripsa for the post:
Serene Jewell
User avatar
Serene Jewell
Posts: 336
Joined: Thu Dec 27, 2012 6:12 am
Has thanked: 636 times
Been thanked: 397 times

Re: Recording visitors to a Google spreadsheet

Post by Serene Jewell » Fri Oct 14, 2016 4:58 am

Hey, Kurtis has made exactly that kind of calendar that pulls from a Google calendar and displays inworld. I believe Ilan is looking at putting it in the KWC so new arrivals can find current events. I have it running at the History Hub and at Clutterfly Redux. It's pretty cool.

Put that thing on the market, Kurtis Anatine! :D
Last edited by Serene Jewell on Fri Oct 14, 2016 5:07 am, edited 1 time in total.
These users thanked the author Serene Jewell for the post (total 2):
Selby EvansArton Tripsa
User avatar
Kurtis Anatine
Posts: 23
Joined: Thu Jun 30, 2016 10:33 pm
Has thanked: 3 times
Been thanked: 32 times

Re: Recording visitors to a Google spreadsheet

Post by Kurtis Anatine » Fri Oct 14, 2016 5:01 am

Haha! Or I could just send you one!
These users thanked the author Kurtis Anatine for the post (total 2):
Selby EvansArton Tripsa
Post Reply