Results 1 to 2 of 2

Thread: Monitoring new records

  1. #1
    guyrosen is offline Junior Member
    Join Date
    Jul 2007
    Posts
    1

    Default Monitoring new records

    Hi,

    Is there any way to get notified of new entries people have entered into SugarCRM?

    Ideally, I'd like to get, say, a daily update that says "XX added these new accounts: A, B, C; YY added these new contacts: Mr. A, Mr. B, Mr. C" and so on? Perhaps if an RSS feed of accounts/contacts/other is available I will be able to see new entries with a standard RSS reader.

    Any ideas?

    Thanks!

  2. #2
    eggsurplus's Avatar
    eggsurplus is offline Sugar Community Member
    Join Date
    Dec 2005
    Location
    Minnesota
    Posts
    2,343

    Default Re: Monitoring new records

    Hey guyrosen,

    It should be a simple matter to make a customization for this. If you are familiar with SQL you can have a script run every morning that pulls this info from all the tables like for who created what new cases:

    select users.user_name, users.first_name, users.last_name, cases.case_number, cases.date_entered
    from users
    inner join cases on users.id = cases.created_by
    where convert(cases.date_entered,date) = '2007-07-24'

    From there there are many ways of implementing that.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Contact Export misses some records
    By saradoo in forum Help
    Replies: 2
    Last Post: 2007-08-06, 06:12 PM
  2. Loosing Case records in Sugar 4.01e
    By GWsugar in forum General Discussion
    Replies: 0
    Last Post: 2006-12-07, 12:10 AM
  3. Loosing Case records in Sugar 4.01e
    By GWsugar in forum Help
    Replies: 0
    Last Post: 2006-12-07, 12:09 AM
  4. retrieve records from table
    By agvg in forum Help
    Replies: 2
    Last Post: 2006-11-15, 08:57 AM
  5. copying records from the popup picker
    By sankar in forum Developer Help
    Replies: 4
    Last Post: 2006-04-05, 08:19 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •