Data entry and Dataset builder forms

[Theodoros Ploumis]

Hi,

We have decided to use jsonstat on a statistical data entry portal built on PHP and JS.

During the evaluation phase we found many open source tools that can create Table forms from json-schema. But we need also to create a UI for the Admins to generate the Datasets (a builder tool). So, my questions are:

1) Which UI library/tool do you propose to build the Datasets (dimentions, keywirds, rules etc)

2) Which UI library/tool do you propose to allow the end Users submit table data to the Datasets (similar to a Spreadsheet data entry)?

Thanks.

[Xavier Badosa]

I'm not sure about 1).

On 2), while there are many libraries available for JSON-stat, almost all of them focus on processing or consuming the data, rather than producing it. On the technical side, generating the JSON-stat output is relatively straightforward since it relies on a flat array structure. Because the generation itself isn't the bottleneck, the primary focus should be on the user experience during data entry. As you say, most users are already highly comfortable with tools like Excel. By integrating a UI library like Handsontable, Tabulator, or Jspreadsheet CE, you can offer a familiar spreadsheet environment. 

Xavier