Thank you again for your software. I appreciate what has already been done and also the amount of work you are constantly putting in. Here are some notes and suggestions (in no particular order) that I have for the future development of mETL, after having realized one project with your software.
Implement a capitalize() helper for the Transform component. It is a minor addition, but unlike upper() and lower(), some RDBMS (i.E. mssql) do not have this function on-board.
Add a groovy script template that transforms an entity value of each row of a message. (I did not quite figure out how it is done, a template would greatly help).
Implement a "eMail send file" component. Extracting a weekly sales summary and sending it per mail is a very common task, which could be easily done in mETL. This component does of course not replace the current "eMail send message" component.
Add a sample flow "Get from RDBMS->Create, name and format Excel->eMail File->Delete File". Of course, this is when your Excel Export and eMail component is ready.
Add tutorial on how to use "Flow parameters". The concept is not easy to understand for me, although I think that parameters could be a powerful tool.
Small correction on help-file in Table 4.5.1: the last two rows are mashed-up
Add option to move (or copy) flows between projects. This would make the organization al little easier.
Add option to move agents between folders. Same reason. Also it is not intuitive, where the folders are created (below "design time")
Add help entry or sample for Assert component. Don't fully understand what it does, but sounds promising.
minor Bug in Notification for "Agents": I created a deployment folder, put an agent inside, but it does not show up in the "notification for agent..." section. If I create an agent directly below "design time" it works.
minor Bug in deployments: I have changed the log-level to "warn" for cron-deployments, but "info" messages are still logged. (did not restart server though)
Hope you appreciate the feedback,
best regards,
Alexander, Austria
Last edit: A Hromadka 2017-02-23
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thanks Alexander for your great suggestions and feedback. We are reviewing these and have opened git issues for a couple and are working on others. In the future feel free to open git enhancement requests for other ideas. (https://github.com/JumpMind/metl)
Dear mETL Team!
Thank you again for your software. I appreciate what has already been done and also the amount of work you are constantly putting in. Here are some notes and suggestions (in no particular order) that I have for the future development of mETL, after having realized one project with your software.
Hope you appreciate the feedback,
best regards,
Alexander, Austria
Last edit: A Hromadka 2017-02-23
Thanks Alexander for your great suggestions and feedback. We are reviewing these and have opened git issues for a couple and are working on others. In the future feel free to open git enhancement requests for other ideas. (https://github.com/JumpMind/metl)
Completed enhancements checked into git:
Capitalize to Transformer options.
See: https://github.com/JumpMind/metl/issues/673
Add option to move (or copy) flows.
See: https://github.com/JumpMind/metl/issues/506
Open enhancements:
Enhancement for email send file.
See: https://github.com/JumpMind/metl/issues/674
We will continue to go through these and update when able.
Thanks,
-Nathan