I access a legacy table that contains a number of fields:
db.define_table(source
,Field('sourceID', 'id')
,Field('name', 'string')
,Field('refNumber', 'string')
,Field('actualText', 'text')
,Field('remarks', 'text')
,Field('fields', 'blob'))
The "fields" field contains an XML description of fields, containing stuff
like this:
<?xml version="1.0" encoding="UTF-8"?>
<Root><Fields><Field><Name>Owner</Name><Value>Santa Cruz
Main</Value></Field><Field><Name>Location</Name><Value>Santa Cruz
District</Value></Field><Field><Name>RegisterName</Name><Value>Register</Value></Field><Field><Name>Volume</Name><Value>XXIV</Value></Field><Field><Name>ArchRegNo</Name><Value>CR</Value></Field><Field><Name>Repository</Name><Value>Archives</Value></Field><Field><Name>RepositoryLoc</Name><Value/></Field></Fields></Root>
How I can process the contents of the blob field using the advantages of
web2py forms and validators?
