This is the list of fields, originally there are over 80 fields, but I cut it down. Go to our website to see what I am doing right now, making them .htm pages so EXCITE can search on them. I put all 800 entries into ASK SAM and tried to export as a csv file, but won't do over one line per field.
Thanks Norm Field name ......................................:no Field name ......................................:comments Field name ......................................:ORG_LEVEL_1 Field name ......................................:STREET_BUILDING Field name ......................................:STREET_ADDRESS Field name ......................................:STREET_CITY Field name ......................................:MAIL_CARE_OF Field name ......................................:BUILDING Field name ......................................:ADDRESS Field name ......................................:CITY Field name ......................................:PROVINCE Field name ......................................:POSTAL_CODE Field name ......................................:OFFICE_PHONE Field name ......................................:TDD_PHONE Field name ......................................:TOLL_FREE_PHONE Field name ......................................:FAX Field name ......................................:CRISIS_PHONE Field name ......................................:AFTER_HRS_PHONE Field name ......................................:e_mail Field name ......................................:www_address Field name ......................................:CONTACT_NAME_1 Field name ......................................:CONTACT_TITLE_1 Field name ......................................:CONTACT_ORG_1 Field name ......................................:CONTACT_PHONE_1 Field name ......................................:CONTACT_NAME_2 Field name ......................................:CONTACT_TITLE_2 Field name ......................................:CONTACT_ORG_2 Field name ......................................:CONTACT_PHONE_2 Field name ......................................:DESCRIPTION Field name ......................................:subjects Field name ......................................:UPDATE_DATE > > Whew, if that's one record, then you are going to need some changes. It > looks as though all the information about this entity is in this one > record, is that right? What you are running into is trying to convert an > old flat file database (say from FoxPro) into a relational one. We've > all ran into this at one time or another and it can be a real bear, but > not impossible. It will require some programming to extract the > individual pieces of data from the entries like the one above, and enter > them into the correct tables once you have that part figured out. > > Using the above 'record', here's what I'm guessing the fields are: > ID: SAR0260 > SubID: 999 feb try13 ( ? ) > OrgName: INFORMATION SARNIA LAMBTON > Blank1: > Blank2: > Blank3: > StreetAddress1: 180 North College Avenue (* you might wish to add a > second street address) > StreetAddress2: 2nd Floor, Selby Building > City: Sarnia > Province: ON > PCode: N7T 7X2 > VoiceAreaCode: 519 (* note that I break out the area code into a > separate field) > VoicePhone: 332-2814 > Blank4: > Blank5: > FaxAreaCode: 519 > FaxPhone: 542-4566 > Blank6: > Blank7: > ContactEmail: [EMAIL PROTECTED] > OrgURL: http://www.informsarnialambton.org > OrgName1: Ray Beggs > OrgName1Position: Chairman > Blank8: > Blank9: > OrgName2: Norm Lamoureux > OrgName2Position: Database Manager > OrgName3: Sue Wright > OrgName3Position: Secretary (* note that I broke this into 2 fields) > Blank10: > OrgDescription: Assists the public in ... > OrgCategory: INFORMATION AND REFERRAL > OrgEntryDate: 2002-01-15 > > Relational database design takes information about something and breaks > it up into separate chunks, each chunk handling only one aspect of the > whole ball of wax. The chunks are called tables, and in your case I can > immediately see 3 or 4 tables that this data could be broken into. > > I'm assuming 'SAR0260' is a unique identifier for this entity, and that > every entity also has a unique identifier? If so, that is an excellent > start, as that will be used to tie the different records together. > > There seems to be several fields of contact information (names, > addresses, emails, URLs, phones etc.) Look at every individual piece of > information and decide exactly what it is 'about'. When you have a few > collections of these, they will make up your tables. > > For example, I might break up the information into these tables and > fields: > > Organizations (these fields describe only the organization) > ID: SAR0260 > SubID: 999 feb try13 ( ? ) > OrgName: INFORMATION SARNIA LAMBTON > Blank1: > Blank2: > Blank3: > OrgEntryDate: 2002-01-15 > StreetAddress1: 180 North College Avenue (* you might wish to add a > second street address) > StreetAddress2: 2nd Floor, Selby Building > City: Sarnia > Province: ON > PCode: N7T 7X2 > VoiceAreaCode: 519 (* note that I break out the area code into a > separate field) > VoicePhone: 332-2814 ( some would even break out the exchange, depending > on their needs) > Blank4: ( voice extension ?) > Blank5: > FaxAreaCode: 519 > FaxPhone: 542-4566 > OrgURL: http://www.informsarnialambton.org > > Contacts (these only describe contacts) > ID: SAR0260 > ContactEmail: [EMAIL PROTECTED] > OrgName1: Ray Beggs > OrgName1Position: Chairman > Blank8: > Blank9: > OrgName2: Norm Lamoureux > OrgName2Position: Database Manager > OrgName3: Sue Wright > OrgName3Position: Secretary (* note that I broke this into 2 fields) > > Categories > ID: SAR0260 > OrgCategory: INFORMATION AND REFERRAL > > Descriptions ( some would leave this in the Organizations table ) > ID: SAR0260 > OrgDescription: Assists the public in ... > > As you read and begin to understand relational database concepts, this > will make more sense to you. You are in for a very interesting and > challenging task but it's also lots of fun. Good luck. > -- > /* All outgoing email scanned by Norton Antivirus 2002 */ > Amer Neely, Softouch Information Services > W: www.softouch.on.ca > E: [EMAIL PROTECTED] > V: 519.438.5887 > Perl | PHP | MySQL | CGI programming for all data entry forms. > "We make web sites work!" -- - Visit me - http://www2.ebtech.net/~nlamoure/index.htm - Information Sarnia Lambton - http://www.informsarnialambton.org - Sarnia Computer Users' Group - http://www.sarnia.com/scug - Lawrence House Centre for the Arts - http://www.lawrencehouse.ca - Good computer website - http://www.techtv.com "Looking for Star Wars and View Masters ! " Also any U.S. state quarters. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
