I don’t know if anybody else has ever tried anything even remotely
resembling this, but I am in the process of taking a bunch o’ data
currently maintained in an excel spreadsheet, and trying to write a
slick RoR database backed web application to manage that data.
Anticipating that this will take some time (I will probably spend
somewhere between 5 and 20 minutes per day working on this, so it is
likely that it will take quite a bit of time), I would like to start
by writing some code that will synchronize my database with the data
in the existing spreadsheet. In that manner, I can work with and test
my database application in isolation, with real data, with real use
cases, while the rest of my group uses the spreadsheet, until such
time as I can go public.
Enough boring background…Here’s my real question …
Where should I put my “sync to spreadsheet” code? Does it belong in a
model? In a helper? As a standalone Ruby app? Keeping in mind that
I’m the only person in the world who will ever use this, I recognize
that it can go anywhere. I’m just curious to learn where an expert
would put this type of code.