bpm-diag / smartRPA

MIT License
17 stars 2 forks source link

Improve data storage in single source data store #24

Open thohenadl opened 9 months ago

thohenadl commented 9 months ago

The storage as csv limits the processing of the data as it needs refinement of the sperator, e.g. "," or ";". If the openining tool, e.g. Excel or Calc, are not properly set, they cannot present the data accuratly. If parameters/attributes contain the seperator, this leads to shifts in the data columns in the displaying tool.

Thus, i suggest choosing a different storage format to primarly store the data. E.g. XES as already available or storing it in database tables, NoSQL for XES/XML, would be possible. Setting up a database, however, might be difficult for distributed variants of smartRPA. Must be locally installed together with smartRPA.