How do I format raw data that will eventually be part of a database?
December 10, 2006 2:16 PM Subscribe
Complete database newbie. I have raw information in the form of text, numbers and photos. This stuff will eventually be fed to users on a web site. I am in the information-collection phase now. What's the best way to collect and format the data so it has the easiest possible path into a database that will serve the web site?
posted by crosten to computers & internet (9 answers total) 1 user marked this as a favorite
Just so you know, I'm using a Mac to collect and store the data. I have text in the form of single words and/or numbers and text in sentence and paragraph form. I also have photos. Should I just be using something dumb like Word to store the text? Or maybe something more database-y like FileMaker Pro? Do I need to tag it or name variables associated with the text? How do I format it? I want to avoid, if at all possible entering this data once when I collect it and then again when it has to go into a web-serving database.