aboutsummaryrefslogtreecommitdiffstats
path: root/bin/oxfordshire
Commit message (Collapse)AuthorAgeLines
* Update code.fixmystreet.com references to fixmystreet.org.Matthew Somerville2014-03-19-3/+3
|
* force upper case on certain PEM fieldsDave Whiteland2013-07-25-4/+4
|
* change field length for ce_description to 1970Dave Whiteland2013-04-11-1/+1
| | | | | OCC report that the Action/Remarks field has max size of 1970, which matches our experience of 2000 (from the PEM docs) choking.
* fix truncation in Oxfordshire Open311 script (debug/test left in? gah)Dave Whiteland2013-03-14-1/+1
|
* suppress debug output from Oxfordshire script for deploymentDave Whiteland2013-01-28-6/+7
|
* rationalised old oxfordshire/open311_service_request.cgi to require shared ↵Dave Whiteland2013-01-24-116/+5
| | | | open311_services.pm
* add status criteria to effectively ignore error records in Oxfordshire's ↵Dave Whiteland2013-01-21-2/+5
| | | | update table
* fix HH24 date format, and use Oracle ROWNUM not LIMIT in SQLDave Whiteland2013-01-21-9/+12
|
* Oxfordshire scripts for connecting with Bentley/PEM (council back-end) table ↵Dave Whiteland2013-01-21-0/+272
| | | | of 'service request updates'
* Oxfordshire: whoops, from_to is in-place; fixed it but didn't commit promptlyDave Whiteland2012-12-21-3/+4
| | | | Also make it clear that encoding can be disabled from config file.
* added better test switch for commmand line test of OCC scriptDave Whiteland2012-12-20-6/+15
|
* add win encoding to Oxfordshire Oracle data before insertingDave Whiteland2012-12-20-3/+8
|
* some tidying, simply closest_address string according to Oxfordshire's requestDave Whiteland2012-12-19-42/+45
|
* tidy up char stripping, at point of binding, so it doesn't affect earlier ↵Dave Whiteland2012-12-19-21/+36
| | | | processing
* strip .full from incoming media URLs for OxfordshireDave Whiteland2012-12-19-0/+2
|
* pass closest_address string straight into OCC's ce_location field, which was ↵Dave Whiteland2012-12-19-35/+3
| | | | the Right Thing to do at the very start, gah
* pass nearest address over to Oxfordshire in its entirety, parse at point of ↵Dave Whiteland2012-12-19-9/+37
| | | | insertion
* fix postcode field name errorDave Whiteland2012-12-19-1/+1
|
* tiny changes to testing dataDave Whiteland2012-12-19-3/+5
|
* tidy up field Oxfordshire PEM field typesDave Whiteland2012-12-19-113/+41
|
* added postcode and nearest address to Oxfordshire Open311 callDave Whiteland2012-12-18-0/+12
|
* don't add newlines when adding media_url after stripper control charsDave Whiteland2012-12-17-3/+3
|
* add configurable setting for stripping control chars for Oxfordhsire EXOR entryDave Whiteland2012-12-17-2/+20
|
* tidied some debugging, moved config file to top of file now we're using it ↵Dave Whiteland2012-12-14-37/+37
| | | | for all instal-specific settings
* remove fake insert for command-line testsDave Whiteland2012-12-14-3/+3
|
* add media_url to description bodyDave Whiteland2012-12-14-5/+8
|
* print out fake (test) return value for now, and remove inout ORA_typesDave Whiteland2012-12-14-4/+5
|
* add ORA types for return values, add mandatory incident_datetimeDave Whiteland2012-12-14-3/+8
|
* just make the stored procedure call -- simpler SQL -- don't declare it hereDave Whiteland2012-12-14-98/+38
|
* only bind the params that we need, now defaults are in thereDave Whiteland2012-12-14-3/+2
|
* explicit SQL declaration of the procedureDave Whiteland2012-12-14-4/+90
|
* add CGI script for Oxfordshire to absorb incoming Open311 service request POSTsDave Whiteland2012-12-13-0/+510
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-06 17:46:52 +0000