[gentoo-user] CSV or mysql table as spreadsheet-like web page

[gentoo-user] CSV or mysql table as spreadsheet-like web page

[hw]

Hi,

how would you go about creating a web page from either a CSV file or a 
table in a mysql database which presents the data to a user and lets 
them edit some of the data, preferably with the ability to use formulas 
like you can in a spreadsheet to do some calculations on the fly?

Once editing the data is finished, it should all be saved to a table in 
a database or as a CSV file.

Is there some php script or the like which can do this or get me started?

Re: [gentoo-user] CSV or mysql table as spreadsheet-like web page

[Matti Nykyri]

> On Mar 24, 2015, at 17:21, hw <hw@gartencenter-vaehning.de> wrote:
> 
> Hi,
> 
> how would you go about creating a web page from either a CSV file or a table in a mysql database which presents the data to a user and lets them edit some of the data, preferably with the ability to use formulas like you can in a spreadsheet to do some calculations on the fly?

A php script that does that kind of table drawing is really easy :) Editing the content is harder... You have to think how you wan't to do it. Htlm has its limitations :/

> Once editing the data is finished, it should all be saved to a table in a database or as a CSV file.

Design it so that you know for certain which cells the user has edited so you don't need to overwrite the entire table even if the table has changed in between.

Many things depend on the size of your table. Raw non-relational database is really easy to interface even with html. Excel can do a table with 2^16 rows and few hundred columns. With mysql you can easily do like a million rows :) design the database so that it has a separate value for the user typed cell content and another for the displayable result of the content.

> Is there some php script or the like which can do this or get me started?

Well i would never use HTML for real work, it is for free-time (facebook etc). Qt has has a really good frontend for working with mysql table. It is fast and supports getting rows asynchronously in the background and in the specified range. With a qt frontend the gui looks much better and unified than with a web-browser.

-- 
-Matti

Re: [gentoo-user] CSV or mysql table as spreadsheet-like web page

[Mickaël Bucas]

Hi

There seems to be open source solutions already available :
http://en.wikipedia.org/wiki/Online_spreadsheet

I don't like to reinvent the wheel, but they may be too complex for your need.

Tell us what you choose or build yourself

Mickaël

2015-03-24 16:21 GMT+01:00 hw <hw@gartencenter-vaehning.de>:
> Hi,
>
> how would you go about creating a web page from either a CSV file or a table
> in a mysql database which presents the data to a user and lets them edit
> some of the data, preferably with the ability to use formulas like you can
> in a spreadsheet to do some calculations on the fly?
>
> Once editing the data is finished, it should all be saved to a table in a
> database or as a CSV file.
>
> Is there some php script or the like which can do this or get me started?
>

Re: [gentoo-user] CSV or mysql table as spreadsheet-like web page

[Michael Orlitzky]

On 03/24/2015 11:21 AM, hw wrote:
> Hi,
> 
> how would you go about creating a web page from either a CSV file or a 
> table in a mysql database which presents the data to a user and lets 
> them edit some of the data, preferably with the ability to use formulas 
> like you can in a spreadsheet to do some calculations on the fly?
> 
> Once editing the data is finished, it should all be saved to a table in 
> a database or as a CSV file.
> 
> Is there some php script or the like which can do this or get me started?
> 

The lazy solution: phpMyAdmin.

Re: [gentoo-user] CSV or mysql table as spreadsheet-like web page

[Neil Bothwick]

[-- Attachment #1: Type: text/plain, Size: 847 bytes --]

On Tue, 24 Mar 2015 12:44:02 -0400, Michael Orlitzky wrote:

> > how would you go about creating a web page from either a CSV file or
> > a table in a mysql database which presents the data to a user and
> > lets them edit some of the data, preferably with the ability to use
> > formulas like you can in a spreadsheet to do some calculations on the
> > fly?
> > 
> > Once editing the data is finished, it should all be saved to a table
> > in a database or as a CSV file.
> > 
> > Is there some php script or the like which can do this or get me
> > started? 
> 
> The lazy solution: phpMyAdmin.

The *really* lazy solution, Google Docs. you can create a spreadsheet and
that export the HTML needed to allow input from a web page.


-- 
Neil Bothwick

WinErr 01E: Timing error - Please wait. And wait. And wait. And wait.

[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 181 bytes --]