CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Pre-installation Questions (Moderator: Dave Greenberg) »
  • Optin Logging
Pages: [1]

Author Topic: Optin Logging  (Read 2079 times)

Solar Bozo

  • Guest
Optin Logging
March 21, 2009, 04:06:25 pm
Hi friends. I hope I can consider CiviCRM but my host (DreamHost) has very strict bulk emailing policies.

Will civicrm (civimail?) log into a file all optin confirmations with date, time, and IP address?

Is there a web link that can be provided to my host to make that logging file available?

« Last Edit: March 21, 2009, 05:00:23 pm by Solar Bozo »

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Optin Logging
March 21, 2009, 06:17:24 pm

no we dont log to a file, but we maintain that information in a DB table: civicrm_subscription_history

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Solar Bozo

  • Guest
Re: Optin Logging
March 21, 2009, 08:26:46 pm
Hi lobo. Thanks for the reply.

OK, so it sounds like all the info is there, right? Date, time, IP address, and (I assume) the email address and the action taken.

Can you think of a way of making that info available to our host if they feel they need to review it?

Is there a reporting method that can output this info? If so, is there some way to give our host permission to generate said report?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Optin Logging
March 22, 2009, 07:17:37 am

you will need to write a php script to expose that data to your host. No reporting mechanism on that table as yet. You can write a custom search (http://wiki.civicrm.org/confluence/display/CRMDOC/Custom+Search+Components), for which you will need php/mysql knowledge

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Solar Bozo

  • Guest
Re: Optin Logging
March 22, 2009, 10:29:19 am
Well, thanks again Lobo. I suppose there are people out there that hire themselves out to do that kind of work. I don't think I am ready to immerse myself in that level of knowledge.

I followed the link you included to check it out. From there I went to the "ERD" which appears to be for version 2.0, but did not find the civicrm_subscription_history table you mentioned, nor could I locate its name in a site search. I was hoping to have a quick glance at its structure.

Michael

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Optin Logging
March 22, 2009, 11:02:18 am

http://civicrm.org/professional/

the ERD was contribtued by someone, so you might want to check sql/civicrm.mysql and probably update the ERD on the wiki for the latest version

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Solar Bozo

  • Guest
Re: Optin Logging
March 22, 2009, 03:09:32 pm
Hi again Lobo. Thanks for the link to helpers.

I have no idea how to get to sql/civicrm.mysql, unless that is intended to be a link to the database for my own installation of civicrm. But I have not installed it yet.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Optin Logging
March 22, 2009, 06:06:03 pm

its part of the distribution if/when u install it

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Pre-installation Questions (Moderator: Dave Greenberg) »
  • Optin Logging

This forum was archived on 2017-11-26.