Advise needed for user-input copy/paste from a spreadsheet into a form

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Advise needed for user-input copy/paste from a spreadsheet into a form

cjhorton
Hi Everyone,

I am using ofbiz to replace our current customer order submission website.  Our current system was written about 5 years ago and is rapidly becoming antiquated.  My lab performs analysis on customer samples that they submit online and then send the physical samples in to us.  Normally they submit only a few at a time, but often they have many(~100).  Our current system allows them to upload a tab-delimited file which the sample names get parsed from, but I would rather not go that route.

Instead, I would like to have a form widget that allows customers to copy a column of cells containing sample names from a spreadsheet and paste them into the form.  Any guidance on how to do this is greatly appreciated!

Thanks in advance!

CJ
Reply | Threaded
Open this post in threaded view
|

Re: Advise needed for user-input copy/paste from a spreadsheet into a form

BJ Freeman
you can create a textarea but the cells would be tab delimited strings.
or you can create a java applet that uses the PIO, but that has to be
imported, parse.
the upload is the best way.
look at the
https://demo.hotwaxmedia.com/partymgr/control/addressMatchMap
code and enities

cjhorton sent the following on 11/18/2008 1:02 PM:

> Hi Everyone,
>
> I am using ofbiz to replace our current customer order submission website.
> Our current system was written about 5 years ago and is rapidly becoming
> antiquated.  My lab performs analysis on customer samples that they submit
> online and then send the physical samples in to us.  Normally they submit
> only a few at a time, but often they have many(~100).  Our current system
> allows them to upload a tab-delimited file which the sample names get parsed
> from, but I would rather not go that route.
>
> Instead, I would like to have a form widget that allows customers to copy a
> column of cells containing sample names from a spreadsheet and paste them
> into the form.  Any guidance on how to do this is greatly appreciated!
>
> Thanks in advance!
>
> CJ
Reply | Threaded
Open this post in threaded view
|

Re: Advise needed for user-input copy/paste from a spreadsheet into a form

cjhorton
Awesome. Thanks BJ!