Hello translators,
I've been practising some excel wizardry in order to provide a
reasonable amount of automation to collection of the status of
translated documentation.
Before I roll out the status across all the specific language status
sheets, I'd like to get feedback to make sure I'm on track. The
spreadsheet I'm working on is in google docs here:
https://spreadsheets.google.com/ccc?key=0AlRFyY1XenjJdFRDbjFyWHg1MlNTRm10QXk0UWEzWlE&authkey=CPTB6uIE&hl=en_GB#gid=5
I've written a script extracts version numbers of all documents in svn,
which is manually copied to the sheet svnlist.
I'm also extracting the status of English docs from our package status
page here:
https://spreadsheets.google.com/ccc?key=0Al9zh8DjmU_RdGIzd0VLLTBpQVJuNVlHMlBWSDhKLXc&hl=en_GB#gid=8
(Status of English docs are: 4.0final, 4.5devel, 4.5draft, 4.5complete)
I'm now expecting that we will keep a translation status for each
document as: (--, draft, complete, reviewed)
Based on all these inputs, I've created a "Summary" sheet, which allows
us to see:
* whether a doc is ready for translation
* whether the English doc is newer than the translated doc (with status
of "...dated")
* whether a doc has completed translation
* who was the last person to commit a file to subversion
* priority for translating
You can see what this should look like for each language in the sheet
"ExampleLang".
Could translators please look at "ExampleLang" and confirm that you are
ok with the way the information is presented. If so, I will replace the
spreadsheets es,de, ja,it,el,ro,pl with these sheets.
Doc to review is here:
https://spreadsheets.google.com/ccc?key=0AlRFyY1XenjJdFRDbjFyWHg1MlNTRm10QXk0UWEzWlE&authkey=CPTB6uIE&hl=en_GB#gid=11
--
Cameron Shorter
Geospatial Solutions Manager
Tel: +61 (0)2 8570 5050
Mob: +61 (0)419 142 254
Think Globally, Fix Locally
Geospatial Solutions enhanced with Open Standards and Open Source
http://www.lisasoft.com
_______________________________________________
Live-demo mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/live-demo
http://wiki.osgeo.org/wiki/Live_GIS_Disc
