Staff database
2 posts by 2 authors in: Forums > CMS Builder
Last Post: November 6, 2008 (RSS)
My client wants to put a large database of names onto one of the pages of the site we are building for him.
A couple of questions
I have the data in excel format - is it possible to populate it into the mysql database without having to input each entry into the CMSB online interface?
Also is there a way of doing a simple 'search by name' function on top of the list. I have set it as a list viewer.
many thanks
A couple of questions
I have the data in excel format - is it possible to populate it into the mysql database without having to input each entry into the CMSB online interface?
Also is there a way of doing a simple 'search by name' function on top of the list. I have set it as a list viewer.
many thanks
Re: [chassa2556] Staff database
By Kenny - November 6, 2008
I have imported large amounts of records into the MySQL database before.
Make sure your column headings match your fields in CMS. Save your excel file to CSV. Make sure you save the file name as the same as your cms table. (ex. your CMS Table is called cms_personnel, so name the document cms_personnel.csv) Then use this tool to create sql you can inject into the database.
http://www.sqldbu.com/eng/sections/tips/mysqlimport.html
Inject the SQL either via command prompt or PHPMyAdmin.
A good idea is to get one entry into the section CMS Builder your working with. Then export that table as a csv file (if you have PHPMyAdmin). Then you can paste the data in the appropriate columns and follow the rest of the steps above. It's a pain in the rear if you miss a step and have to start over again, but it does save time and once you get used to the process, it becomes easier.
As far as the search goes, take a look at this http://www.cleburnehighschool.com/staff and let me know if that's what you are looking for. I can send you that code if it is.
Kenny
Make sure your column headings match your fields in CMS. Save your excel file to CSV. Make sure you save the file name as the same as your cms table. (ex. your CMS Table is called cms_personnel, so name the document cms_personnel.csv) Then use this tool to create sql you can inject into the database.
http://www.sqldbu.com/eng/sections/tips/mysqlimport.html
Inject the SQL either via command prompt or PHPMyAdmin.
A good idea is to get one entry into the section CMS Builder your working with. Then export that table as a csv file (if you have PHPMyAdmin). Then you can paste the data in the appropriate columns and follow the rest of the steps above. It's a pain in the rear if you miss a step and have to start over again, but it does save time and once you get used to the process, it becomes easier.
As far as the search goes, take a look at this http://www.cleburnehighschool.com/staff and let me know if that's what you are looking for. I can send you that code if it is.
Kenny