Discussion in 'Site Discussion' started by Fantasma, Nov 8, 2015.
What is this syncing thing for? What spreadsheet is this?
This is for the online spreadsheet that will eventually replace !view. It will show the owner,map name, url notes, and other important data. It clogs chat less, has more data, and is just all around better.
However I have shut it off for now as OAuth (required to access and modify data in a spreadsheet) isn't properly working, and I don't have the time to fix it.
Could we get the URL PM back while you fix the spreadsheet thing?
You know it would clog chat less if you had the bot PM the results of !view to the user rather than displayed it in chat. You'd be free to put each list item on a new line, then. You could have another command for displaying the list in public in the existing inline construction.
I'd much rather see
id suggest making the public one default and the private one seperate, since people will want it to be public more often than not (since it answers anyone else wondering what the maps are)
I didn't think it would really matter which command was used for which function, since I credit the average chat room user with intelligence enough to learn the difference, but I shall amend my suggestion:
Please provide us with a !pview command that privately sends us the list of maps, and their URLs, with each list item on a new line. For the removal of doubt for anyone else reading this, this command would be in addition to the existing !view command, which publicly lists the maps in one line, separated by commas.
If the amount of work required to implement this new function isn't worth it, then by all means forgo it in favour of the swift restoration of the URL PM and the subsequent introduction of the fabulous spreadsheet with its bells and whistles. Thank you kindly.
Ok, so I got OAUTH working, I shall spare the fantastic story.
So, the google spreadsheet will now update in unison, however for some reason when I use !add it wont' add the latest map entry to the spreadsheet, and !remove just plain crashes it. Will fix in future, but just wanted to let everyone know that there is some moving forward with the online spreadsheet.
The command to update the sheet manually is !Sync and !sheet will give a url, both can only be done in group chat. I think !sync is admin only too.
Please refrain from using the !view command. Please use the !sheet command.
On a related note, online spreadsheet functionality is at 100% which is pretty damn good
Please move this chat anywhere but here.
Anyways, any hiccups today with the !sheet command?
No, not that i saw. I think it is all working A-OK.
Ok, so bot update!
The bot will now removes maps from it's map list once they are ran both on and offline
It will also msg the user who put the map in the list that their map has been run, but I need confirmation from @Seba that this is working.
wording on the message is misleading as it implies the map has finished being played, rather than having just started
How were you able to read the message? Just curious?
I recieved a PM from the bot as soon as the server switched to my map, stating that it had been imped.
Oh neato, I thought I only imp'd Seba's.
That bot feature is now confirmed, will change the message soon.
I'm not following the thread, someone in chat just said you're depcreciating !view
Why? It's a useful feature and the google spreadsheet is a far less optimal way of quickly showing the whole chat which maps are in.
Please don't remove it!
If anything, View should also link the spreadsheet. Use !sheet for just the sheet and !view for the full list in chat + sheet link
Also please add a !help command that links to this thread's first post, finding the thread took me a good few minutes (server events... wtf??)
I had the google doc open and was happily uploading maps in the meantime. When I returned back to the sheet, random maps were removed for some reason.
Can you get me as much information of this happening as possible please.
Also i'm still making considerations about the !view command, i'm leaning towards making it msg only or admin only but I'm worried about how much it can break up chat when 2 users do it at once.
I did some investigation, there was no bug.
Using this: https://docs.google.com/spreadsheet...TSteMTGb5v4isVjK6o/edit#gid=185531839&vpid=A1
and the demo server: http://demos.geit.co.uk/
I've come to the conclusion that the maps were removed because the server ran them. This is 100% intended, except for pl_gladdison_a6 despite it running a5, which is odd. I'm going to assume this was a manual removal.
The bug moreso is the server not updating the sheet instantly.
!view is more convenient than the spreadsheet. If you are concerned about spam, then just limit the command so it can only be used once every minute or so. Then give us the ability to send !view to the bot via PM, and make that list have each map on a separate line so it's easier to read.
Separate names with a comma.