Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By AlanClifford on
I'm new to Drupal. I need to 1) have a database of URLs with some additional information such as: text description, category/sub-category, location (country, state/province, city), type and display the results of queries entered by users, 2) be able to maintain the database through a separate screen. The users can't change the data just query it. The database will eventually have tens of thousands of entries. This seems like the kind of thing others would have developed. We're using 8 but I assume I can adapt one from earlier versions. I've looked for an existing module but haven't been able to find one probably because I don't know what search terms will select it. Could someone point me in the right direction? Thanks.
Comments
You don't need any modules,
You don't need any modules, this can be done with core.
Create a content type called URL. Make the title the URL. Add a textfield for the description. Add a term reference (taxonomy) field for the category. Add other fields for the rest of the data you want. Set anonymous and authenticated users to have viewing permissions to view published content (so they can see the URL pages). Create a 'URL Author' role, and give them permission to created/edit/delete URL content type.
The only thing I can see that you may need a module for is the location.
Contact me to contract me for D7 -> D10/11 migrations.
Use feed module for data import
Hi Alan,
yes, creating content type is correct method. In addition to that, if you have thousands of entries, you can Drupal content import methods like Feed (https://www.drupal.org/project/feeds). This will import all records directly from your csv file in one go.
Best!
Gaurav
For displaying and letting
For displaying and letting visitors query the data you can use Views. Add filters in the view for the fields you would like to be searchable and make those filters exposed.
Thanks
Thank you all for your quick and gentle replies. I've taken the Drupal 8 Beginner course from OSTraining on YouTube but I'm new to content management. Before Drupal I built websites using DreamWeaver so I'm used to carving what I need from chunks of wood and bone. The idea that I can just describe what I need Is new and, I might add, VASTLY BETTER :)