On 23 November 2013 11:22, Stephen Lane
<stephenlane92-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:> I am currently doing a project in Ruby on Rails and I have been presented
> with a dilemma.
>
> The dilemma is that the users of my system will be uploading an excel
> spreadsheet. The issue is should I just read straight from this excel
> spreadsheet into my front-end or should I load this spreadsheet into my
> MySQL database and then to my front-end.
Do you need to modify any of the data (or is it just to be displayed)?
Do you need to keep the data available in the long term?
Do you have to show multiple views of the data (so the spreadsheet
would have to be interrogated multiple times)?
Is this a system that will be modified and extended over time?
If the answer to any of those is yes then extract the data from the
spreadsheet into the database. If you are just providing a simple web
based view on data from the spreadsheet then you could just extract it
on the fly. I would advise using the database however. I think in
the long run it would be simpler and easier to maintain.
Colin
>
> I have asked numerous people about this issue and have researched on-line
to
> no avail.
>
> Any help would be much appreciated.
>
> Thanks
>
> Stephen
>
> --
> You received this message because you are subscribed to the Google Groups
> "Ruby on Rails: Talk" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
> To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
> To view this discussion on the web visit
>
https://groups.google.com/d/msgid/rubyonrails-talk/f350ec22-70e8-4e57-8adc-83b070291f94%40googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
--
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To view this discussion on the web visit
https://groups.google.com/d/msgid/rubyonrails-talk/CAL%3D0gLv%3DjUPSa2rnAsqqBjyGRrO5w3-fimp_%3DqS%2Bxmw6LNj07Q%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.