EGReports-DeliciousData.ppt-Evergreen.ppt

The post-import Send the report output somewhere E-mail notify that “report’s ready at someurl” Trigger something like a bib export of the records that were output One more thing... Don’t forget to delete your scheduled report output Custom reporting views exposed in the IDL SQL views in the IDL Exposed via reporting interface Good for on-demand reporting Don’t break the IDL xmllint is your friend pick a class id unlikely to collide class id=rlcd controller=open-ils.cstore open-ils.pcrud open-ils.reporter-store oils_obj:fieldmapper=reporter::last_copy_deleted oils_persist:readonly=true reporter:core=true reporter:label=Last Copy Delete Time oils_persist:source_definition SELECT b.id, MAX(dcp.edit_date) AS last_delete_date FROM biblio.record_entry b JOIN asset.call_number cn ON (cn.record = b.id) JOIN asset.copy dcp ON (cn.id = dcp.call_number) WHERE NOT b.deleted GROUP BY b.id HAVING SUM( CASE WHEN NOT dcp.deleted THEN 1 ELSE 0 END) = 0 /oils_persist:source_definition !-- continued -- fields oils_persist:primary=id oils_persist:sequence=biblio.record_entry field reporter:label=Record ID name=id reporter:datatype=id/ field reporter:label=Delete Date/Time name=last_delete_date reporter:datatype=timestamp/ /fields links link field=id reltype=has_a key=id map= class=bre/ /links !-- continued -- permacrud xmlns=/spec/opensrf/IDL/permacrud/v1 actions retrieve/ /actions /permacrud /class The Future General third party reporting frameworks? Library Dashboards? Your Ideas? Photo Credits Surrounded by papers by Flickr user suratlozowick /photos/suratlozowick/4522926028/ Thanks! Delicious Data:Automated Techniques for Complex Reports Presented by Jeff Godin and Benjamin Shum How NOT to run reports... Planning the framework SQL Query Report Export Results to CSV Convert CSV to XLS Email XLS to Library Schedule as Cron Job Some Strategies Schedule as Cron Job Use our experience setting up crontab