Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: XML and Databases and Excel, Oh My!

by graff (Chancellor)
on May 12, 2010 at 21:46 UTC ( #839745=note: print w/ replies, xml ) Need Help??


in reply to XML and Databases and Excel, Oh My!

One other possibility to think about: What does Excel offer you that you wouldn't be able to get via a basic web form? Another way to state the question is: How might the use of a web form simplify and/or enhance the project?

(Or, depending on your particular situation, maybe a basic Perl/Tk, Perl/Gtk or similar GUI app would be preferable to a web app.)

The point would be to get the end users into direct contact with the database, rather than bothering with external intermediate files. You could even add a table to the database to log all updates, so that you keep a revision history and can roll back if you want.

Depending on lots of factors, there are good reasons for both approaches (spreadsheet files vs. direct DB access).


Comment on Re: XML and Databases and Excel, Oh My!
Re^2: XML and Databases and Excel, Oh My!
by jedikaiti (Friar) on May 13, 2010 at 16:12 UTC

    Actually, the main point of this project is to have the data in an easier-to-deal-with format for the end user. (A change to data in one place frequently requires changes to data in another table or two, etc, and having a process in place that will deal with the 6-digit ID number for you, rather than having to keep them all straight.) Another benefit is NOT changing the database directly, so that the likely changes can be compared to the current data before the changes are actually uploaded to the DB.

    A web form may still work, although one nice thing about Excel is that I do have a base worksheet already that I can build on.

    Thanks!

    Kaiti
    Swiss Army Nerd

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://839745]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (10)
As of 2014-12-22 16:03 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (121 votes), past polls