By dorien on

Hi,

I have a (very large) database with following entries per record:
title - url - email - date

I want a Drupal user to be able to search for a keyword in the title. (Is it better to store my database entries as nodes for that or some other way so that I can use some kind of built in search?)

The search results are displayed in a table. The user is able to check the entries in the table. And the system sends out 1 email (personalised by the user 1 time).

There should be a limit on the number of emails that can be send out per month by the user, depending on his role.

Anybody has some tips?

I am open to offers for anybody who can develop the module with me. Please send a pm.

Thanks!

⋅ Categories: Drupal 7.x

Comments

steeph’s picture

steeph commented

These may not be the best solutions, but here is what I would do.

  • Create a content type and add the URL, email and date field (you need to install the respective modules)
  • Create a view (you need to install the views module) and add exposed filters for the fields that should be searchable
  • If the email content is given use the rules module to send the email
  • If the email content should be entered by the user use the email form widget for the email field
  • Use rules to increment some value and remove the permission to send mail
  • Again use rules to reset the value to 0 and give back the perission on the beginning of a new month

This is a simplified guide. Ask again if you need more help ;)