Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine

Re^2: XML and Databases and Excel, Oh My!

by jedikaiti (Hermit)
on May 13, 2010 at 16:12 UTC ( #839855=note: print w/replies, xml ) Need Help??

in reply to Re: XML and Databases and Excel, Oh My!
in thread XML and Databases and Excel, Oh My!

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.


Swiss Army Nerd
  • Comment on Re^2: XML and Databases and Excel, Oh My!

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://839855]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (10)
As of 2018-05-22 14:07 GMT
Find Nodes?
    Voting Booth?