Skip to content

dalenewman/OrchardCore.Transformalize

Repository files navigation

Transformalize in Orchard Core

This is an Orchard Core module that uses Transformalize arrangements to create:

  • Reports: Browse and Search for data.
  • Tasks: Validate & transform parameters for use in data modification statements.
  • Forms: Validate & transform form data for data collection.
  • Bulk Actions: Tasks run on records selected from reports.

Reports

Reports read, filter, search, export, and page over data. You may transform records using Razor , Liquid, and built-in transforms. If the records have coordinates, you may display them on a map.

TODO: Explain example arrangement and show GIF.

Tasks

Tasks accept, transform, and validate parameters before running traditional transformalize or simple data modification processes.

TODO: Explain example arrangement and show GIF.

Forms

Building off the ability to validate parameters, forms collect valid user supplied input and store it in a relational provider (a specified table).

TODO: Explain example arrangement and show GIF.

Bulk Actions

Bulk Actions combine reports and tasks. You may select records on a report, and send them to a task for processing.

Configurable tasks must be defined to run bulk actions:

  1. batch-create: create and return a batch identifier
  2. batch-write: write batch values
  3. batch-summary: query batch summary
  4. batch-run: indicate the task is running (not yet implemented)
  5. batch-success: indicate the task succeeded
  6. batch-fail: indicate the task failed

There are recipes for MSSQL, PostgreSql, and SQLite for the above tasks. Initially, The "batch write" task must be run once in init mode to setup the necessary tables/views.


Putting it all together, here is a GIF showing a report (with map) that has a bulk action to change color associated with the record.

bogus report

TODO: Link to arrangement here.


Development