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

[Xavier Badosa]

It's probably true that we haven't focused enough on the production side of JSON-stat. I'm working in two different projects related to this topic.

One is JSON-stat Builder, a web app that allows you to produce JSON-stat files from data introduced by the user (manually or pasted from spreadsheets, CSVs, etc.(.

The second one does not have a name yet (JSON-stat Importer?) has a similar goal but basically it will produce JSON-stat from a variety of input formats.

Xavier

[Theodoros Ploumis]

We are also creating such tools. The options nowadays are too many. 

At the moment we are creating a builder based on https://github.com/Comcast/react-data-grid but it would be great if we could try the mentioned "JSON-stat Builder" since our tool will not be published soon. 

[Xavier Badosa]

https://jsonstat.com/builder/

(Presentation of this project in a separate post.)

Xavier

[Theodoros Ploumis]

Looks nice! Will be out as an open source project I suppose, right?

[Xavier Badosa]

> Will be out as an open source project I suppose, right?

I haven't thought about it. I planned to offer the service for free on jsonstat.com. I didn't think there was a real interest in having the actual code and I wanted to save myself the hassle of documenting it... But if there's a real interest I can open it (it's built with vanilla JS, no framework whatsoever).

Will you be interested?

Xavier

--
You received this message because you are subscribed to the Google Groups "json-stat" group.
To unsubscribe from this group and stop receiving emails from it, send an email to json-stat+...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/json-stat/78d693ca-ce18-4055-b3b4-69685d5e0a39n%40googlegroups.com.

[Theodoros Ploumis]

Yes! I am very interested.

[Xavier Badosa]

Ok, I've uploaded the code to Github:

https://github.com/jsonstat/builder