By nelsonkimaiga on

I'm working on a project that involves coming up with a web application that will contain a search-able database for as the main feature. Ideally, I'm envisaging something that has a similar functionality to that of: http://www.gatesfoundation.org/How-We-Work/Quick-Links/Grants-Database

The database will be populated through a form or an uploaded .csv file which contains the data already per-filled. I'm looking for any leads as to how I can achieve this using the Drupal-7 CMS, including the modules that I can add to aid these type of search features.

⋅ Categories: Drupal 7.x

Comments

vinayak nair’s picture

vinayak nair commented

hi,
give this a try::
https://www.drupal.org/node/1592754

pixelsweatshop’s picture

pixelsweatshop commented

In D7 all you are going to need is the feeds module to import your csv and the views module with exposed filters to build your search. You could also add the search API module to enhance the search text field a bit.

nelsonkimaiga’s picture

nelsonkimaiga commented

Thanks but how do I build out the search form that enables me to search for the uploaded data?

vinayak nair’s picture

vinayak nair commented

hi,
try search api database search module it help you to index data stored in database::
https://www.drupal.org/project/search_api_db

pixelsweatshop’s picture

pixelsweatshop commented

You will need to learn views, especially exposed filters. See https://wunder.io/blog/taming-the-beast-learn-views-with-nodeone/2011-03-21

If you are going to use Drupal, you are going to need to know a lot about views.

nelsonkimaiga’s picture

nelsonkimaiga commented

Thanks, I have had a workaround on customizing the views and my search form. However I figured out that the imported data (from the CSV or any other input method) should be able to render on a table after which I can sort or filter this data using filters (Which I have already configured) of course with the search form being there too. I'd like to know if I'm on the right track on achieving that or what extra tweaks do I have to add?