MAME/FBA Compatibility lists need small updates

[dankcushions]

https://docs.google.com/spreadsheets/d/1GaqIIoiWbzKHwZ52S2xCSDQXILo81Ls1mHK6czKGAtM
done! phew, that took ages!

for anyone curious, there's a few games added to the latest version of FBA-next that caught my eye:
open ice (on mame2003 i think, but was slow performance on a pi2)
killer instinct 1 /2 (on mame2003 but can't get it to work - if it works in FBA that's huge!)
mortal kombat 3 & ultimate mk3 (on mame2003 i think, but still - first mk game i've seen in FBA)

@herb_fargus i couldn't delete the final sheet due to permissions for some reason, even though I could delete all data! it's blank now, but could you do it, for tidyness? thanks :)

[herb_fargus]

@dankcushions hmm that's weird. But yeah it's deleted. Thanks for keeping it all up to date :)

[dankcushions]

@herb_fargus seems like someone has deleted the rpi1 and 2 columns in the lr-mame2003 sheet:
https://docs.google.com/spreadsheets/d/1LP1MELCvcxu7TfiowF_0ZuvRVEMqlfQyTVetnOJvuJc

according to the revision history, it was an anonymous user on the 26th of june. i suggest reverting to the last good one: 26 June, 17:44?

is there a way of protecting columns, but still allowing the contents to be edited? hmm..

[BuZz]

:/ Idiot.

Is it possible to disallow anonymous editing - might put off people from breaking it if they have to use a real google account ?

[BuZz]

It's possible to protect parts from editing, I don't know about if it's possible to protect from deleting but still allow editing.

[caver01]

@BuZz you can protect the columns you want to prevent from being removed, but use an exception to all data rows. In this way, the header (or other rows above the data) are protected. This allows editing the data rows, but the column can't be deleted because the user is stopped by the protected cells above.

[dankcushions]

paging @herb_fargus :) it looks like i have access to revert some of the spreadseets, but not the mame2003 one, for example - https://docs.google.com/spreadsheets/d/1LP1MELCvcxu7TfiowF_0ZuvRVEMqlfQyTVetnOJvuJc/edit#gid=1744967714

after that i think we should follow @caver01's suggestion, and also disabling anonymous editing, as @BuZz says. i think some of the other sheets are in a bit of a mess also, at quick glance.

[herb_fargus]

@dankcushions said in MAME/FBA Compatibility lists need small updates:

vert some of the spreadseets, but not the mame2003 o

You are set as an editor and I changed the protected columns to be editable by you as well, so you should be able to change everything I can

[herb_fargus]

@dankcushions do you want me to change the ownership to you? I have lots of life decisions right now and I don't know how much longer I'll be able to maintain these things, (and you probably have a much better understanding of mame than I do)

[dankcushions]

@herb_fargus sure! actually i seem to be able to do reversions from the history now? so it doesn't make much difference for me :) i'm not really sure how editing on these sheets works...

[dankcushions]

ok i've reverted to early june.. last time the notes column was around :/

i think the permissions are good now. i've set both readme and main sheet to be protected, and the 3 columns + the notes column to be editable by all. @caver01 is this what you mean?

[caver01]

@dankcushions Yes. That should keep rows 1 and 2 protected on C,D,E,H so that nobody can delete the columns.

[dankcushions]

cool thanks :) ok, i'll try and go through the other sheets and repeat the process.

[herb_fargus]

@dankcushions I've just given you ownership to the whole folder of all the compatibility lists. Thanks for your work on this. (not sure if it will break the links on the wiki, might be worth checking out just to make sure.)

[caver01]

@herb_fargus The links didn't break. They shouldn't, as each Google Sheet has a unique KEY that identifies the document and is part of the URL.

[dankcushions]

@herb_fargus said in MAME/FBA Compatibility lists need small updates:

@dankcushions I've just given you ownership to the whole folder of all the compatibility lists. Thanks for your work on this. (not sure if it will break the links on the wiki, might be worth checking out just to make sure.)

thanks! but thanks so much to you for doing them in the first place - that's the bulk of the work! if Life ever settles down you can take them back :)

does anyone know how to turn off anonymous editing? google isn't being helpful... i think maybe you can't unless you set specific google accounts to have access?

[dankcushions]

ok, one sheet which I can't revert for whatever reason - the general arcade spreadsheet:
https://docs.google.com/spreadsheets/d/1antILt7D12EWOFzyJwTfB86NceghMJKXG7CdYumuHec/edit#gid=0
last known good version:
8th april 04:37
(after which some user deleted the 3 testing columns...)

[dankcushions]

sorry @herb_fargus , i'm at a bit of a loss here. i've got ownership of the drive, but i can't seem to change ownership of the files within. i don't understand how the two things are separate! if anyone as any experience with google drive, let me know :)

[Floob]

@dankcushions Maybe this will help - it mentions how to transfer ownership of all documents
https://support.google.com/a/answer/1247799?hl=en

Or maybe just save the docs locally, then upload in your own drive area. Unless there is a Google account associated with the RetroPie project.

[dankcushions]

@Floob unfortunately that involves the "google admin console" which needs a paid "google for work" account, which i didn't even know existed before today! :(