Technology selection - filter and view

[Peter Hewett]

Hi

Can anyone suggest a simple solution to this task?

We have a flat table of data (6 columns, 700,000 rows) of text, about 100MB of data in a csv file (or dbf file). I'm after a user friendly interface that enables a non-technical person to filter on 1 or more columns and then view or print the result. The data should be read only to the user.

This is to run on a standalone PC running Windows 10. It doesn't have MS Office installed. I was thinking about a big html table filtered with jquery or similar, but it looks like there is just too much data for this to work well.

It would be good to have a simple solution, and avoid having to develop any bespoke software.

Any suggestions?

TIA

Peter

[Vince Martin-Smith]

Could load up Libre Office or Open Office and use the database tools in there.
Easy to load the data.

--
You received this message because you are subscribed to the Google Groups "Taranaki Linux Users Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to taranaki-linux-user...@googlegroups.com.
To post to this group, send email to taranaki-linu...@googlegroups.com.
Visit this group at https://groups.google.com/group/taranaki-linux-users-group.
For more options, visit https://groups.google.com/d/optout.

[grant.notley]

Peter

Try Libre Office or Open Office.

Both have spreadsheets and databases, similar in many respect to MS Office,
although I suspect at 700,000 rows you will need to use a database!.

One caveat, MS Excel (2010) can only differentiate up tp 30,000 items in one column
 This is simply a limitation, as given in the programme specs.

Grant Notley

[Peter Hewett]

Thanks Vince, Grant

I had tried the data in OpenOffice. Calc can handle the data, but is very slow. It takes almost a minute to open the data as an ods file, and several minutes to save a copy.  Maybe I should explore the OpenOffice database options.