ExpeditionRPG / expedition

Expedition: The Cards & App RPG
https://ExpeditionGame.com
Other
78 stars 26 forks source link

Card creator: re-support Translations by enabling inputting multiple CSVs #902

Open toddmedema opened 1 year ago

toddmedema commented 1 year ago

With the change to the Google API and only being able to import one CSV at a time, you can no longer input the Translations tab along with other cards. See here, where the system-level text like STARTING ABILITIES doesn't get translated

http://cards.expeditiongame.com/?theme=Color&source=https%3A%2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2Fe%2F2PACX-1vRFEgdeXT-YgfyuYJMGKgOTi--8rxaT3mcc7maXSspWbejTKkvOAeQQwZZIAsO1A-jRbcjvda_sPWyp%2Fpub%3Fgid%3D558719643%26single%3Dtrue%26output%3Dcsv

Proposed solution: Allow the custom input dialog + URL to support multiple CSVs. Perhaps the user pre-processes everything they want into a single string and input it, e.g. 2PACX-1vRFEgdeXT-YgfyuYJMGKgOTi--8rxaT3mcc7maXSspWbejTKkvOAeQQwZZIAsO1A-jRbcjvda_sPWyp,Translations,245544,Ability,4234234

(Maybe Translations will always need to be first so that it's applied when the other card data is loaded?)

Breaking down two Google URLS of tabs from the same sheet, we can see that the sheet ID is the same and it's just the GID that changes, so users could start with the sheet ID, then do a comma-separated list of sheetname,sheetgid?