Spreadsheet Workflow.

Have been working with the localization component for a bit now, and am finding the use of the import/export to google spreadsheets both wonderful but also limiting. Just having some clarity around the rules will help, and then i have some suggestions.

I'm never sure if import/export is destructive - i'm almost 100% sure that it is on export - anything you have in the spreadsheet gets over-written when exporting. I'd like to know if this includes items which are not part of the local DB. For example, in the spreadsheet i have a row which does not exist in the Unity project, when i export, does that row get removed?

Equally, when i do an import, does it replace all existing items? Replace new items?

I think what i would like is an Additive option when importing/exporting. This would allow for the addition of _new_ stuff to an existing set of stuff, rather then absolutely over-writing whatever is there. I think this would get me 80% of the way to a "perfect" solution (where everything is updated/synced perfectly all the time), which is beyond the scope of this tool, and mostly impossible anyway.

Thanks again,
Jos

That all sounds quite excellent. I hadn't thought about the "type" for the translation's, and having meta-data regarding that would be very helpful.

One other thing might be to have a view-changes - ie. a non-applying way to see the "diff" between the Spreadsheet and the local store. So you can be sure that you are going to apply what you want, with no surprises.

That is about the only thing i can think of (right now! ) which is missing, you seem to have covered most of the workflow stuff that was problematic. Nice job, and thanks!

Jos