A selection of templates and other useful documents for OPCs and transcribers. These have been updated in 2007 to be compatible with the database design which now lies behind the OPC web site. Please use these templates wherever possible as it seriously reduces the work involved in uploading to the web site. However, if you have a lot of transcriptions in a different format, we can write bespoke scripts to read them into the database - please don't do a lot of conversion work before speaking to us first - and most important don't be deterred from contributing them!
VOLUNTEER FORM - Microsoft Word
CHURCH REGISTERS
TEMPLATE FOR BAPTISM TRANSCRIPTIONS - CSV
TEMPLATE FOR BAPTISM TRANSCRIPTIONS - Microsoft Excel
TEMPLATE FOR MARRIAGE TRANSCRIPTIONS - CSV
TEMPLATE FOR MARRIAGE TRANSCRIPTIONS - Microsoft Excel
TEMPLATE FOR BURIALS TRANSCRIPTIONS - CSV
TEMPLATE FOR BURIALS TRANSCRIPTIONS - Microsoft Excel
CENSUS RETURNS
NOTES ABOUT CENSUS TRANSCRIBING
TEMPLATE FOR 1841 CENSUS TRANSCRIPTIONS - Microsoft Excel
TEMPLATE FOR 1841 CENSUS TRANSCRIPTIONS - CSV
TEMPLATE FOR 1851 CENSUS TRANSCRIPTIONS - Microsoft Excel
TEMPLATE FOR 1851 CENSUS TRANSCRIPTIONS - CSV
TEMPLATE FOR 1861 CENSUS TRANSCRIPTIONS - Microsoft Excel
TEMPLATE FOR 1861 CENSUS TRANSCRIPTIONS - CSV
TEMPLATE FOR 1871 CENSUS TRANSCRIPTIONS - Microsoft Excel
TEMPLATE FOR 1871 CENSUS TRANSCRIPTIONS - CSV
TEMPLATE FOR 1881 CENSUS TRANSCRIPTIONS - Microsoft Excel
TEMPLATE FOR 1881 CENSUS TRANSCRIPTIONS - CSV
TEMPLATE FOR 1891 CENSUS TRANSCRIPTIONS - Microsoft Excel
TEMPLATE FOR 1891 CENSUS TRANSCRIPTIONS - CSV
TEMPLATE FOR 1901 CENSUS TRANSCRIPTIONS - Microsoft Excel
TEMPLATE FOR 1901 CENSUS TRANSCRIPTIONS - CSV
STANDARD ABBREVIATIONS - Microsoft Excel
STANDARD ABBREVIATIONS FOR RELATIONSHIP TO HEAD - CSV
STANDARD ABBREVIATIONS FOR MARITAL STATUS - CSV
STANDARD ABBREVIATIONS FOR GENDER - CSV
Please remember that the transcriptions are converted to CSV format, which removes all formatting, for uploading to the web site. For this reason, please do not use commas inside the spreadsheet fields, as this makes the conversions manually intensive. Also please do not leave blank lines in the spreadsheets - this again slows the upload process as each one has to be manually removed.
Please also remember to use numbers for the day, month & year fields, which standardises the data - however our scripts do recognise standard month abbreviations (Jan, Feb, Mar etc) if that is what you prefer to use. Whatever you do don't use the Microsoft Excel Date formatting as it doesn't work for 19th century and earlier dates, nor does it convert to CSV format properly.
If you have any questions about the templates, or the database upload procedure, please don't hesitate to contact the OPC coordinator for alternative template formats.
We welcome comments for improvements to the transcription templates as they are unlikely to be perfect....
| 30/10/2004 |
| |