--- trunk/ChangeLog 2007/10/07 13:09:56 206 +++ trunk/ChangeLog 2009/03/31 10:08:00 321 @@ -1,3 +1,710 @@ +2009-03-31 Sascha L. Teichmann + + * formed/formed/model/exprtree.py: Fixes from server. Raise + exceptions if there is less or more than one element on stack + after compilation of expression. + +2009-03-20 Sascha L. Teichmann + + * formed/formed/model/data.py: Removed debug output + + * formed/formed/plugins/modify/rules.py: Fixed error message. + Generate past and future rules. + +2009-03-16 Sascha L. Teichmann + + * formed/formed/model/exprtree.py: Forget to call today with context. + +2009-03-16 Sascha L. Teichmann + + * formed/formed/io/document.py: Fixed syntax typo. + +2009-03-16 Sascha L. Teichmann + + * formed/formed/model/data.py: ConditionalNode inherits from Node directly. + +2009-03-16 Sascha L. Teichmann + + * formed/formed/model/data.py: Added ConditionalNode + + * formed/formed/io/document.py: Make ConditionalNode loadable. + +2009-03-13 Sascha L. Teichmann + + * formed/formed/plugins/modify/rules.py: Make the error descriptions + in date sequence rules more precise. + +2009-03-13 Sascha L. Teichmann + + * formed/formed/plugins/modify/rules.py: generate date sequence rules. + +2009-03-13 Sascha L. Teichmann + + * formed/formed/model/exprtree.py: New tree based expression engine. + + * formed/formed/model/__init__.py, formed/formed/model/data.py: + Adjusted imports. + +2009-03-12 Torsten Irländer + + Introduced new order attribute for date fields + + * formed/formed/model/data.py: Order fields can be used to define to + ordering of datefields withing the document. Needed for automatic + generation of consistency rules. + +2009-02-09 Sascha L. Teichmann + + * formed/formed/model/data.py: Allow pages to be 'invisible'. + +2009-02-09 Sascha L. Teichmann + + * formed/formed/plugins/export/sql.py: Fixed problem with + description reference tables of radio groups. + +2009-02-09 Sascha L. Teichmann + + * formed/formed/plugins/export/sql.py: replace '-' in names + by '_'. + +2009-02-09 Sascha L. Teichmann + + * formed/formed/plugins/export/sql.py: to figure ou which + tables are equal the insert statememnts are lower cased + and sorted before they are compared. This reduces the number + of generated referfence tables. + +2009-02-09 Sascha L. Teichmann + + Repair SQL schema creation for radio groups. + + * formed/formed/plugins/export/sql.py: radio groups are handled + like choices now. + +2009-02-09 Sascha L. Teichmann + + Make it startable again. + + * formed/formed/plugins/export/xls.py: Import pyExcelerator only + when plug-in is called. + + * formed/formed/model/nodecomponents.py: Event routing was messed up. + Rewired root node with document. + + * formed/formed/plugins/web/help.py: Removed old xml.ext import. + XXX: This breaks creating help by now! + + * formed/formed/io/parser.py: Replace old deprecated base class + by new one. + + * formed/formed/main.py: Do not crash if locale cannot be set. + + * formed/formed/ui/controls.py: Use document.getCase() instead + of document.case to prevent uninitialized dereferences. + +2009-01-22 Torsten Irländer + + Implemented new XML-Format for formed xml files. + + * formed/formed/model/nodecomponents.py, + formed/formed/io/document.py, + formed/formed/main.py, + formed/formed/ui/controls.py: Introduced new "case" and "logbook" + node. Under case is the definition of the formular. logbook will + hold the defintion of logboog entrys. For now only the part under + "case" can be modified. + +2009-01-21 Torsten Irländer + + Changed way how XSD-Scheme is generated + + * formed/formed/plugins/export/xsd.py: Enhanced xsd schema to support + logbookentrys. The scheme definiton is now hardcoded in the + exporter as it will rarely change. It logbookpart will not be + generated from the formedtree anymore. + +2009-01-20 Torsten Irländer + + Support Logbook entrys in xsd schema export + + * formed/formed/model/data.py: Repeatnode are now handeld as + repeatgroups in xsd-export + * formed/formed/plugins/export/xsd.py: Enhanced xsd schema to support + logbookentrys. The scheme will now validate against an xmlfile from + the offlineclient. + +2009-01-09 Torsten Irländer + + Added new repeat node + + * formed/formed/model/data.py, + formed/formed/io/document.py: Added repeatnode to the formedtree. + TODO: Remove repeatgroup handling from the groupnode. + +2009-01-08 Torsten Irländer + + Add isset operator to autogenerated rules. + + * formed/formed/plugins/modify/rules.py: Add issed operator to standard + autogenerated rules. + +2008-12-17 Frank Koormann + + * formed/formed/plugins/export/latex.py: Export form as set of + latex tables to be included into a master document. The export + generates section marks to structure the form and placeholders for + help texts to be merged in by a post processing step. + +2008-12-04 Sascha L. Teichmann + + * formed/formed/model/expr.py: Added 'today' which pushes the current date + on the stack. + +2008-12-03 Sascha L. Teichmann + + * formed/formed/plugins/web/controllers.py: compute changeset more correctly in + storage of fields. + + * formed/formed/plugins/export/xsd.py: Added unknown int -999999 to integer + fields as an accepted value. Generate schema for radio groups too. + +2008-12-01 Torsten Irländer + + Added autmatic generation of required rules + + * formed/formed/model/data.py, + formed/formed/model/expr.py, + formed/formed/plugins/modify/rules.py: Default rules for required + fields can now be generated. + +2008-11-28 Sascha L. Teichmann + + * formed/formed/model/data.py, formed/formed/model/nodecomponents.py: + Ported WidgetCollector from Offline client. + + * formed/formed/plugins/modify/__init__.py, formed/formed/plugins/modify, + formed/formed/plugins/modify/rules.py: Stub for required rules generator. + + * formed/formed/config.py: Bind new filter to FormEd + +2008-11-27 Torsten Irländer + + * formed/formed/model/data.py: Added new attribute mark for rules + +2008-11-10 Torsten Irländer + + Implemented radio-matrix elements. radio elelement having the same + options can now be rendered in table form. + + * formed/formed/model/data.py, + formed/formed/io/document.py: Added new radio-matrix element to the + model and gui + * formed/formed/plugins/web/view_renderer.py: Write html-renderer for + the radio-matrix element. + +2008-11.03 Torsten Irländer + + * formed/formed/model/data.py: Fixed import error + +2008-10-29 Sascha L. Teichmann + + Relative paths in external choices are now possible. Relative paths are + relative to path of the master document. + + * formed/model/data.py: external choice are now storing the path to the + master document. + + * formed/formed/io/document.py: Pass context to SAX builder. + + * formed/formed/io/factories.py: For new created nodes look if there + is a method 'setLoadContext' and call it. + +2008-09-04 Sascha L. Teichmann + + * doc/beschreibung.txt: New. Initial description of FormEd (german). + +2008-08-22 Sascha L. Teichmann + + * formed/formed/model/nodecomponents.py: Added attribute 'flags'. + +2008-08-21 Sascha L. Teichmann + + * formed/formed/io/document.py: Indent tree while saving + * formed/formed/main.py: removed needless print + +2008-08-15 Sascha L. Teichmann + + * LICENSE: New GPLv3 + * */*.py, *.sh: Added reference to LICENSE + +2008-08-15 Sascha L. Teichmann + + * tools: removed because there a no tools any more. + +2008-08-15 Sascha L. Teichmann + + * tools/formed: moved one level up because its the only + part of this project now. + +2008-08-15 Sascha L. Teichmann + + * tools/anonym/*: Removed as it belongs to mpuls WASKA + +2008-08-15 Sascha L. Teichmann + + * pdf2xfa/*: removed. It belongs to mpuls + +2008-08-13 L. Teichmann + + i18n of the plug-ins: + * tools/formed/formed/plugins/export/diff.py, + tools/formed/formed/plugins/export/data.py, + tools/formed/formed/plugins/export/old_sql.py, + tools/formed/formed/plugins/export/latex.py, + tools/formed/formed/plugins/export/xsd.py, + tools/formed/formed/plugins/export/sql.py, + tools/formed/formed/plugins/export/typemap.py, + tools/formed/formed/plugins/export/html.py, + tools/formed/formed/plugins/export/mode.py, + tools/formed/formed/plugins/export/html2.py, + tools/formed/formed/plugins/export/xls.py, + tools/formed/formed/plugins/names/filter.py, + tools/formed/formed/plugins/plugin.py, + tools/formed/formed/plugins/web/help.py, + tools/formed/formed/plugins/web/form_renderer.py, + tools/formed/formed/plugins/web/plugin.py, + tools/formed/formed/plugins/web/error_renderer.py, + tools/formed/formed/plugins/web/view_renderer.py, + tools/formed/formed/plugins/web/semantic.py, + tools/formed/formed/plugins/web/cache.py, + tools/formed/formed/plugins/web/server.py, + tools/formed/formed/plugins/web/controllers.py, + tools/formed/formed/plugins/web/renderer.py, + tools/formed/formed/plugins/ui/controls.py, + tools/formed/formed/config.py: _("")s the stuff + tools/formed/po/formed.pot, tools/formed/po/de_DE.po: + extracted and translated. + +2008-08-08 Sascha L. Teichmann + + First version of FormEd i18n. After checkout go to tools/formed/po/ and + say 'make mo'. Afterwards you can start FormEd as usual. + + * tools/formed/resources: New. Place to places ressources like *.mo files + * tools/formed/formed/main.py, tools/formed/formed/ui/controls.py: Add _("")s + + * tools/formed/po, + tools/formed/po/Makefile, + tools/formed/po/formed.pot, + tools/formed/po/de_DE.po: i18n stuff. + +2008-08-08 Sascha L. Teichmann + + * tools/anonym/xmlexport.py: Only export cases which are not + 'schwebend geloescht'. + +2008-07-23 Sascha L. Teichmann + + Fixed issue472 + + * tools/anonym/xmlimport.py: Regenerate dicts from current form ed tree. + +2008-07-17 Sascha L. Teichmann + + * tools/anonym/xmlimport.py: removed marking of invalid cases + * tools/anonym/cron.importAnonXml.sh: re-inserted here. + +2008-07.07 Torsten Irländer + + * tools/formed/formed/plugins/export/latex.py + tools/formed/formed/config.py: Added new LaTex Export. Beware this + is even more ugly the HTML Export. + * tools/formed/formed/plugins/export/html.py: Added information on + anonymisation to the html export. + +2008-07-07 Sascha L. Teichmann + + * tools/anonym/xmlimport.py: Mark cases if they are inconsistent. + +2008-07-07 Sascha L. Teichmann + + * tools/anonym/xmlimport.py: Updated to schema 1.5. (Which is incompatible to 1.4) + +2008-07-07 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/html.py: Added additional column + to the html export with information how each field will get + anonymized. + +2008-07-07 Sascha L. Teichmann + + * tools/anonym/xmlimport.py: sync with productive version. + +2008-06-10 Torsten Irländer + + * tools/formed/formed/plugins/export/sql.py: grant admin permission to + call anonymize function + +2008-05-21 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/xsd.py: Brought encoding + back to UTF-8. + +2008-05-21 Frank Koormann + + * tools/formed/formed/plugins/export/xls.py: New, export key value + tables as excel workbook with one sheet per table. + + * tools/formed/formed/config.py: ExportKeyValueTableAsXLS added. + +2008-05-21 Frank Koormann + + * tools/formed/formed/plugins/export/xsd.py + (SchemaCreator._createChoice): Fix use of choices name. + +2008-04-29 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/xsd.py: Use substitution group + to allow arbitrary order of repeat groups. + +2008-04-29 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/xsd.py: Removed a needless + character. + +2008-04-29 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/xsd.py: Added annotations + to fields. + +2008-04-29 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/xsd.py: Added for + choice fields. + +2008-04-29 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/xsd.py: Added support for + boolean fields based on enumerations. + +2008-04-28 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/xsd.py: Added support for + date, text and textarea fields. + +2008-04-28 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/xsd.py: Added support for + repeat groups and integer fields. + +2008-04-28 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/xsd.py: New. plug-in for + exporting as XML schema. not ready, yet. + + * tools/formed/formed/config.py: Use new plug-in. + + * tools/formed/formed/plugins/export/sql.py: Fixed wrong GUI text. + +2008-04-17 Torsten Irländer + + * tools/formed/formed/plugins/export/sql.py: Changed WHERE clause in + for the views because of the new group permissions. + +2008-04-09 Sascha L. Teichmann + + * tools/anonym/cron.deleteOldAnonymized.sh: New. cron job to delete + old anonymized cases. + +2008-04-01 Sascha L. Teichmann + + * tools/anonym/xmlexport.py: Removed "WHERE einverstaendniserklaerung = 1" + from clause to select datasets. + Replace ']]>' in CDATA sections with correct splitted replacement. + +2008-03-12 Sascha L. Teichmann + + * tools/anonym/cron.importAnonXml.sh: Added absolut path to xmlimport + script. + + * tools/anonym/xmlimport.py: commented out database port from + connectionstring. + +2008-03-12 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: Fixed bug in generation + of anonymization of repeat groups (wrong id was given). + +2008-03-11 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: Generate no update + statements for relations which have no anonym functions applied. + +2008-03-11 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: Added a newline after + 'COMMIT;' in the last line. + +2008-03-11 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: Fixed syntax of + generated anonymize_case() function. + +2008-03-11 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: Added code to + generate a plpgsql function anonymize_case() that anonymized + a given case and all of its depending repeat groups. + +2008-03-06 Sascha L. Teichmann + + * tools/anonym/xmlimport.py: remove print of insert statement. + + * tools/formed/formed/plugins/export/sql.py: Print generation date in ISO. + +2008-03-03 Torsten Irländer + + * anonym/cron.sendAnonXml.sh, + anonym/getDbList.sh: Modified script to be used directly in the + production environment (Copied running scripts from production + server) + + * cron.importAnonXml.sh: Added deleting of ols cases. Modified script + to be used in a production environment (Cpoied running script from + production server) + + * tools/anonym/xmlexport.py: Added "WHERE" clause to SQL-Statement to + ensure that only valid cases get exported + +2008-02-27 Sascha L. Teichmann + + * tools/anonym/xmlimport.py: Fixed bug in date converter. + +2008-02-27 Sascha L. Teichmann + + * tools/anonym/xmlimport.py: Simpilied version + +2008-02-27 Sascha L. Teichmann + + * tools/anonym/cron.importAnonXml.sh: Add sudo call for + xmlimport.py and parameters. + + * tools/anonym/xmlimport.py: Various bug fixes. Not working yet. :-/ + + * tools/anonym/xmlexport.py: Use python interpreter without env + because of sudo context. + +2008-02-26 Sascha L. Teichmann + + * tools/anonym/xmlimport.py: added support for getopt. add + support to force in fkz in import of case. + +2008-02-26 Sascha L. Teichmann + + * tools/anonym/xmlimport.py: Implemented logic to create/update cases. + + * tools/anonym/html.awk: produces valid HTML. + +2008-02-25 Sascha L. Teichmann + + * tools/anonym/joincsv.py: Fix a logic bug. + +2008-02-25 Torsten Irlaender + + * tools/anonym/cron.importAnonXml.sh: Added shellscript for importing + exportted cases. It will read all files from a directory and import + the files into the DB. After that the script will cleanup the + directory. + +2008-02-25 Torsten Irländer + + * tools/anonym/cron.sendAnonXml.sh, + tools/anonym/xmlexport.py, + tools/anonym/getDbList.sh: Added shell-scripts for exporting cases + +2008-02-25 Sascha L. Teichmann + + * tools/anonym/joincsv.py: Fixed typo which generated wrong number of cols. + +2008-02-25 Sascha L. Teichmann + + * tools/anonym/joincsv.py: New. Joins CSV files. + + * tools/anonym/html.awk: New. Converts CSV to HTML + +2008-02-25 Sascha L. Teichmann + + * tools/anonym/xmlimport.py: New. Added generation of + update statements. + +2008-02-25 Sascha L. Teichmann + + * tools/anonym/xmlimport.py: New. Base for importing + XML from cron. + +2008-02-24 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/html2.py: New. plug-in + for a simplified HTML output + + * tools/formed/formed/plugins/export/typemap.py: New. plug-in + for dump schema as python dictionary. + + * tools/formed/formed/config.py: Enable new plug-ins. Out comment + old stored procedure and view generators. + +2008-02-19 Sascha L. Teichmann + + * tools/anonym/xmlexport.py: New. Export all cases in database + as XML. + +2008-02-18 Sascha L. Teichmann + + * tools/anonym/anoymncsv.py: separate field with '\t' now. + all '\t's are replaced by ' ' before. '\r\n' are removed too. + +2008-02-15 Sascha L. Teichmann + + * tools/anonym/anoymncsv.py: simple script to fetch anonymous + data from database. + +2008-02-14 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: Exchanged name + erase_value with suppress_value/suppress_value2. + +2008-02-13 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: output id, master_id + substitute 'erase_value' with NULL value. + +2008-02-13 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: output id, master_id + and uuid_id in anonymiziation views too. + +2008-02-13 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: Added generation + of anonymiziation views for master table views and repeat group + views. + +2008-02-13 Sascha L. Teichmann + + * tools/formed/formed/model/nodecomponents.py: Added attribute + "function" + + * tools/formed/formed/io/document.py: Save attributes in + alphabetical order. + +2008-02-02 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: Added update rule + for master table and repeat groups views. Granted update right + to :cm_ka_group. + +2008-02-01 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: Added a column 'uuid_id' + for master table and repeat groups. Also added unique constraints + to these columns. + +2007-12-10 Sascha L. Teichmann + + * pdf2xfa/src/de/intevation/pdfimport/ClientHandler.java: Added a system + property 'root.element' to specify the name of the XML root. + + * pdf2xfa/startup/pdf2xfa.sh, pdf2xfa/README.TXT: Adjusted. + +2007-11-22 Sascha L. Teichmann + + * pdf2xfa/startup, */pdf2xfa.sh, */pdf2xfa.init: boot scripts + for GNU/Linux (tested Debian 'Etch' 4.0) by Sascha Wilde. + + * pdf2xfa/README.TXT: Add a remark to new boot scripts. + +2007-11-21 Sascha L. Teichmann + + * pdf2xfa/src/de/intevation/pdfimport/Log.java: New. + Sends logging to file. + + * pdf2xfa/src/de/intevation/pdfimport/Server.java, + pdf2xfa/src/de/intevation/pdfimport/ClientHandler.java: Adjusted + to use new logging. + + * pdf2xfa/README.TXT: Added remark how to use logging. + +2007-11-16 Frank Koormann + + * tools/formed/formed/plugins/export/sql.py (createSchema): + Append only column "bearbeiter_id", standins are modelled by a + separate table. + +2007-11-16 Sascha L. Teichmann + + * tools/formed/formed/model/data.py, + tools/formed/formed/plugins/web/view_renderer.py: + Added an invisible flag for info fields. + +2007-11-07 Sascha L. Teichmann + + * tools/formed/formed/model/nodecomponents.py: Fixed a few small bugs + (calling a wrong method). + +2007-11-07 Sascha L. Teichmann + + * tools/formed/formed/model/nodecomponents.py: Added a field + 'alternative' to all node components. This might be of help to + match PDF imports where the descriptions do not match. + +2007-10-23 Frank Koormann + + * tools/formed/formed/plugins/export/sql.py: New WHERE-Clause for views + +2007-10-23 Frank Koormann + + * tools/formed/formed/plugins/export/sql.py: Set default + value (-1) for choices and bools. + +2007-10-21 Frank Koormann + + * tools/formed/formed/plugins/export/sql.py: Grant statements for + descriptive tables added. + (Table.getName): new + +2007-10-21 Frank Koormann + + * tools/formed/formed/plugins/export/sql.py: "CREATE OR REPLACE" + statements for views and roles to make updates easier. + Add "admin_ka" membership as third option to VIEW_WHERE_CLAUSE. + +2007-10-19 Frank Koormann + + * tools/formed/formed/plugins/export/sql.py: Added GRANT statements + for views. The statements are prepared for variable substitution + when executing the SQL-scripts by psql. + +2007-10-18 Sascha L. Teichmann + + * pdf2xfa/src/de/intevation/pdfimport/ClientHandler.java: Fixed: + End of result XML was truncated because of an unflushed buffer. + +2007-10-17 Sascha L. Teichmann + + * pdf2xfa/bin/build-jar.sh: New. Build production jar file. + + * pdf2xfa/README.TXT: Adjusted how to build production jar file + and how to use it. + + * pdf2xfa/etc, pdf2xfa/etc/manifest.txt: New. Defines main class + and iText dependency. + +2007-10-16 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: Model 'Ja, Nein, Keine Angabe' + are not modeled as BOOLEANs any more. That simpifies the conversion + process web vs. db. + 2007-10-07 Sascha L. Teichmann * tools/formed/formed/plugins/export/sql.py: Added the remaining