I am building a site on drupal 6 with numerous modules. It will be a small community site with events, forums, video, image galleries, blogs, etc.. I want to incorporate a crm (client relationship management) "back end" in to this. I am using a panels dashboard for the "back end" to track the clients profile info, (event appointment) node creation, comments, and communications.

My first question is what would be the best way to "store" the communication records. Right now I am thinking nodes, I can import emails, and document phone calls. This could add up quick with all the other node types. Maybe one node per client for all communications? Any body using drupal to track and record cllient communications? Any ideas?

My next question is how to set this up for performance and security. All one site/one database? One site 2 databases? 2drupal installs (domain/clients) 2 databases? I was testing civicrm and read about some performance issues with prefixed tables in databases. I am not really sure how to do that anyway, civicrm does it (semi)automatically.

Any ideas or suggestions to either of these questions will be greatly appreciated.

Chris

Comments

rpadua’s picture

Hi, wondering if you get this working! did you do it? I'm trying to do the same. cheers x