Impossible data entry control

9 Dec 2009 - 1:36pm
4 years ago
4 replies
912 reads
Rob Hatch
2007

In early interaction design sessions, my business partners are asking
for the following: I don't believe it exists.

1. Web Page with simple template allowing data entry.
2. Data must be able to be "pasted" in from other sources (most
likely from a spreadsheet)
3. Data will be variable (1 - N rows)
4. Data format will need to be validated on submission. (Two columns
of data will be allowed, one an identifier and the second a currency
amount)

I'm thinking of GDocs spreadsheet type functionality - but am not
aware of that type of control being commonly available. Any thoughts?

I'm proposing an alternate interaction - which is simply to upload
the file and validate there, but they are stuck on this template
model...

Comments

9 Dec 2009 - 3:56pm
.pauric
2006

Are you proposing something along the lines of the many-eyes data
entry form?
http://manyeyes.alphaworks.ibm.com/manyeyes/datasets/new

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Posted from the new ixda.org
http://www.ixda.org/discuss?post=47894

9 Dec 2009 - 4:05pm
David Lambert
2009

I've done a little work with this .Net control - pretty slick stuff:

http://www.spreadsheetgear.com/

You might be able to get close to what they're envisioning with
this.

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Posted from the new ixda.org
http://www.ixda.org/discuss?post=47894

10 Dec 2009 - 12:23pm
Krang
2009

We're wrestling with a similar issue on a current project. The
closest thing we've found to a Web-based Excel data entry grid is
Telerik's RadGrid for ASP.NET Ajax:

http://www.telerik.com/products/aspnet-ajax/grid.aspx

You can tab through the grid and manually type in data, but I'm not
aware of any way to cut and paste multiple rows from Excel,
unfortunately.

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Posted from the new ixda.org
http://www.ixda.org/discuss?post=47894

11 Dec 2009 - 2:30am
James Page
2008

All you need is a text area that is big enough to take the data.

I would use Ajax to upload the data to the server, or use Javascript on the
client to validate the data which should be faster.

Your business partners pattern is nice if you have the excel sheet open, as
the user only has to copy and paste between the two. On the other pattern if
you have to do a file upload the user has to :-

1. Save the excel file
2. Go to the browser.
3. Click upload.
4. Remember where they have saved the file
5. Browse to where the file is
6. Click upload.
7. Server validates.

User could easily make mistakes with the above in forgetting to save the
excel file. Forgetting where it is.
On the other hand your business partners pattern is :-

1. Go to the browser.
2. user copies data
3. pastes it
4. Server validates.

Nice and simple. This could be enhanced by the browser parcing the data
using javascript on the client. And placing the data into a columns of a
table on the page. So to give the user instant feedback. All is the quite
easy in Javascript now.

All the best

James
http://blog.feralabs.com <http://blog.feralabs.com>

2009/12/10 Krang <jorsi at industrialwisdom.com>

> We're wrestling with a similar issue on a current project. The
> closest thing we've found to a Web-based Excel data entry grid is
> Telerik's RadGrid for ASP.NET Ajax:
>
> http://www.telerik.com/products/aspnet-ajax/grid.aspx
>
> You can tab through the grid and manually type in data, but I'm not
> aware of any way to cut and paste multiple rows from Excel,
> unfortunately.
>
>
> . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
> Posted from the new ixda.org
> http://www.ixda.org/discuss?post=47894
>
>
> ________________________________________________________________
> Welcome to the Interaction Design Association (IxDA)!
> To post to this list ....... discuss at ixda.org
> Unsubscribe ................ http://www.ixda.org/unsubscribe
> List Guidelines ............ http://www.ixda.org/guidelines
> List Help .................. http://www.ixda.org/help
>

Syndicate content Get the feed