MAME/FBA Compatibility lists need small updates

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?

undefined

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! :(

Floob

hmm, this one may be more appropriate:
https://support.google.com/drive/answer/2494893?co=GENIE.Platform%3DDesktop&hl=en

But I guess still easier to download, then upload to your own google docs. Or register an account with a retropie.org.uk email if Buzz or Herb set one up.

caver01

Seems like the Arcade romset is kinda bogus anyway, as the arcade aggregates multiple emus (each requiring their own compatibility lists). How is .171 the romset for a rom that I choose to launch with mame4all?