[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Count emails by specific subject and display count in Sharepoint

Posted on 2010-01-08
3
Medium Priority
?
610 Views
Last Modified: 2013-11-29
Hello good people,

1. I'd like to automatically count the number of emails received in a specific account, with a specific subject, on a basic pop3 email server (http://www.squirrelmail.org/).

2. I'd like to present the count in a Sharepoint page web part (not looking to change the dna of SP with deep, deep, "look at what I can change on Sharepoint!" code work--so it will never upgrade ;) A simple web part would be nice.

2.a. Cumulative count since a specific date (I.e. Jan 1),

2.b. Current day count

2.c. Yesterday count


0
Comment
Question by:celler_wellbridge
  • 2
3 Comments
 

Author Comment

by:celler_wellbridge
ID: 26214241
Update: I'm very open to the idea of building these counts in an aspx .NET 2.0 page and pulling it in as an iframe web part!
0
 
LVL 51

Accepted Solution

by:
Ted Bouskill earned 2000 total points
ID: 26274657
To be honest, these are the type of questions most experts avoid.  It's not a specific question and is very open ended with a lot of potential issues.

In this case I'll provide some advice and won't be able to provide a specific solution.

#1 I have no knowledge of that product and it might not be possible.  It may or may not track those details.  Many mail programs don't do much tracking by default to minimize the overhead.  An email server is like a post office wear they don't deliver.  Email is always pushed to email servers where an email client can then connect and pull the email onto the client.  So, adding overhead like inspecting the mail and counting it is optional.  You'll have ask a specific question in another zone about how to gather metrics with squirrel mail or contact the vendor.  Ideally you'll need to push those metrics into a SQL database.

#2 There are a LOT of choices for displaying metrics in Sharepoint assuming you get the core data into a SQL DB.  If you have the Enterprise version of MOSS you could do this with a Business Data Catalog or even an Excel Spreadsheet managed by Excel Services to show the data on a web page

If you have SQL Reporting services you could produce reports shown in a Page Viewer Web Part in Sharepoint

I manage very experienced Sharepoint developers that could build a custom web part to show the metrics in less than one day.  However, they've already finished the learning curve for Sharepoint

You could use Sharepoint Designer to build a Data View Web Part to display the data

Regarding your last comment yes many people try to do it the easy way and stick with what the know however, the problem is that then you lose all the benefits of Sharepoint.  The Page Viewer Web Part is basically an IFRAME, however, you lose security features, search can provide as many advanced choices for the data because it's not in a Sharepoint UI format and the graphics won't automatically match the Sharepoint them.

Learn how to do it properly in Sharepoint with a custom web part.  Sharepoint is VERY popular in the Enterprise and companies get advice from experts like me when they hire employees or contractors and we can tell when a developer knows Sharepoint or simply knows how to get by with it.  Career wise being a quality Sharepoint developer is going to be worth it for a long time.
0
 

Author Comment

by:celler_wellbridge
ID: 26284874
Thank you tedbilly!

I'll seriously consider your recommendations.

I thought I could cobble together som sort of inbox for a specific account, CC the specific emails into that client account, run a count on that box and display it in the page.

I'm going to break down all the steps and Identify them, determine all the practical ways each step can be accomplished, then go after the best route for my needs.

Thank you again for the thoughts and clarity.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
Check out the latest tech news, community articles, and expert highlights in August's newsletter.
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question