I have 200 customers. "Hopefully that will dramatically increase in a few years" My goal is to create a Wiki that will have a page (profile) for each customer. It will store basic info (address, phone, etc) and will also documents each visit along with a summary of each vist, eg. -
Sept 4, 2006 - Customer was mad
Sept 10, 2006 - Customer was happy
etc.
I have a PHP calendar that I would also like to have on each page of the wiki.
Here are my 2 questions -
1) What is the best Wiki to use for this type of project, where I will be able to intergrate PHP code and has a friendly interface?
2) I want to use MySQL, but until I figure out how I am going to set everything up, I am entering all the data in a Excel spreadsheet. What is the best way to set up the fields in Excel to later on be transferred to a MySQL database, and then be intergrated into the Wiki? For now I just have - "Visit Date 1, Visit Notes 1, Visit Date 2, Visit Notes 2,....."
I am eager to get this Wiki built, but for now, I need to know that the data I am collecting everyday is being put in the proper format.
2006-10-19
10:51:01
·
2 answers
·
asked by
Jackal
2