Forms | ETL Interface

by
Odoo

$ 308.62

v 13.0 Third Party 17
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Community Apps Dependencies
Lines of code 7441
Technical Name formio_etl
LicenseOPL-1
Websitehttps://www.novacode.nl
Versions 14.0 13.0 12.0 15.0 16.0 17.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Community Apps Dependencies
Lines of code 7441
Technical Name formio_etl
LicenseOPL-1
Websitehttps://www.novacode.nl
Versions 14.0 13.0 12.0 15.0 16.0 17.0

Forms | ETL Interface

Explore Forms loaded (ETL) into generated models, views, database tables and records

Search and view structured Forms data in database records.
Use your Business Intelligence and Reporting tools of choice to analyse Forms data.
Export the Forms records to CSV and Excel.

Features for every Form (Builder version):
  • Automatically generated: Models, Views, Window action.
  • Configurable Views: List, Form, Graph, Search (e.g. show/hide fields).
  • Access management: Group(s) assignment.
  • Menu(s) creation: Create and assign under every menu.
  • Load/import Forms records: Manually by button and/or Scheduled action (cron).
  • Sync changes in Form Builder to Models and Views (fields). Just click the button "ETL Builder" to run the action.

Preview of the ETL power

Example shows a filled in Form - ETL to list and form views.

Form

ETL'ed List View

ETL'ed Form View

ETL Interface

Create ETL Interface - from Form Builder

Configure ETL Interface

Model and Fields

List View

Form View

Graph View

Search View

Create Menu item(s)

Access Rights

Update ETL Interface - after configuration changes

ETL Forms to Database records

Run manually

Scheduled action (default enabled per 10 minutes)

Supported field(component) types

Currently supported: textfield, textarea, number, email, checkbox, select, radio, phoneNumber, date, datetime.

Upcoming versions of this module shall support additional ones (or upon request).

Currently supported field/component types are also shown in the info-box.

License

One License is permitted per customer project.

Visit the online Demo

Click the Live Preview button in the top.

Users (email / password)

  • demo / demo
  • portal / portal

Releases

1.5

  • Improvement: Handle and display error (exception) when creating the ETL Interface.

1.4

  • Improvement in Form Builder: don't show the ETL Interface button, if empty Builder schema.

1.3

  • Fields readonly: builder_etl_date, forms_etl_date.

1.2

  • New feature: User (admin) can add ETL fields which receive value by Python Code.

1.1

  • Implement address input component (provider: Google Maps).
    The component ETLs to mutliple fields, currently: street_name, street_number, postal_code, city, country (more to come eg: lat, lon).

1.0

  • Error handling and reporting in case the Forms ETL fails.
  • Implement radio input component, ETLs to a selection field.

0.4

  • Fix datetime component: Convert (datetime) value from timezone of the submission user, to UTC (storage).

0.3

  • Fix/change due to recent change in the Python formiodata library (version: 0.3.0)
    Change (formiodata) Builder object attr: form_components became input_components

0.2

  • Fix uninstall of module.
    Prevent ORM to trigger redundant delete of ir.model.fields record. Error shown to user: Record does not exist or has been deleted.

0.1

  • Initial version
Odoo Proprietary License v1.0

This software and associated files (the "Software") may only be used (executed,
modified, executed after modifications) if you have purchased a valid license
from the authors, typically via Odoo Apps, or if you have received a written
agreement from the authors of the Software (see the COPYRIGHT file).

You may develop Odoo modules that use the Software as a library (typically
by depending on it, importing it and using its resources), but without copying
any source code or material from the Software. You may distribute those
modules under the license of your choice, provided that this license is
compatible with the terms of the Odoo Proprietary License (For example:
LGPL, MIT, or proprietary licenses similar to this one).

It is forbidden to publish, distribute, sublicense, or sell copies of the Software
or modified copies of the Software.

The above copyright notice and this permission notice must be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM,
DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
DEALINGS IN THE SOFTWARE.

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.
There are no ratings yet!
demo link
by
rommel@waters.com.ph
on 4/13/22, 11:37 PM

where is the demo link?

Re: demo link
by
Bob Leers
on 4/14/22, 1:32 AM Author

I sent you a mail with the details.