Welcome to MSDN Blogs Sign in | Join | Help

Source Code for the Data Extraction Program (DEP) of the SPS Report Pack now available on GotDotNet

First of all, I would like to thank our outsourcing partners Quilogy for developing this wonderful reporting tool for SharePoint.  I would like to mention some names from Quilogy as my partners in crime:

Rick Kight - Thanks for all your patience and persistence in making this a success project and putting up with all my cr@p

David Harper - You are my idol!

Charles Wieland - You will be a great developer some day

Eric Brown - Welcome to the mob!

So here it is:

http://workspaces.gotdotnet.com/SPSReportPack

As time permits, I am making some enhancements to the DEP for the following:

1) A WSS-only extractor with no dependencies on the Portal object model

2) A multi-threaded extractor for  performance improvement

3) Remove Web service calls and use the object model to improve performance

Published Thursday, November 03, 2005 7:50 AM by Dino Dato-on

Comments

# re: Source Code for the Data Extraction Program (DEP) of the SPS Report Pack now available on GotDotNet

well following the documentation doesnt seem to work at least with wss/sps sp2? IIS parsing seems to work fine though... C:\Program Files\Report Packs\SPS\Data Extraction>RPDataExtraction.exe Resolving...Microsoft.SharePoint.Portal.resources, Version=11.0.0.0, Culture=en- US, PublicKeyToken=71e9bce111e9429c Resolving...Microsoft.SharePoint.Portal.resources, Version=11.0.0.0, Culture=en, PublicKeyToken=71e9bce111e9429c Parsing IIS Log files... Parsing C:\Program Files\Report Packs\SPS\Data Extraction\IIS\HOUSTON\W3SVC1 with Log Parser...finished Parsing WSS Log files... Parsing C:\Program Files\Report Packs\SPS\Data Extraction\WSS\HOUSTON... An exception has occured: System.UnauthorizedAccessException Access to the path "C:\Program Files\Report Packs\SPS\Data Extraction\WSS\HOUSTON" is denied. -so i deviate from the documentation and just place the sts logs directly under the WSS root (rather than creating a SERVERNAME folder) - then this happens..... C:\Program Files\Report Packs\SPS\Data Extraction>RPDataExtraction.exe Resolving...Microsoft.SharePoint.Portal.resources, Version=11.0.0.0, Culture=en- US, PublicKeyToken=71e9bce111e9429c Resolving...Microsoft.SharePoint.Portal.resources, Version=11.0.0.0, Culture=en, PublicKeyToken=71e9bce111e9429c Parsing IIS Log files... Parsing C:\Program Files\Report Packs\SPS\Data Extraction\IIS\HOUSTON\W3SVC1 with Log Parser...finished Parsing WSS Log files... Parsing C:\Program Files\Report Packs\SPS\Data Extraction\WSS\00.log...finished Parsing C:\Program Files\Report Packs\SPS\Data Extraction\WSS\01.log...finished Parsing C:\Program Files\Report Packs\SPS\Data Extraction\WSS\02.log...finished Parsing C:\Program Files\Report Packs\SPS\Data Extraction\WSS\03.log...finished Parsing C:\Program Files\Report Packs\SPS\Data Extraction\WSS\04.log...finished Parsing C:\Program Files\Report Packs\SPS\Data Extraction\WSS\07.log...finished Parsing C:\Program Files\Report Packs\SPS\Data Extraction\WSS\09.log...finished Parsing C:\Program Files\Report Packs\SPS\Data Extraction\WSS\10.log...finished Parsing C:\Program Files\Report Packs\SPS\Data Extraction\WSS\12.log...finished Parsing C:\Program Files\Report Packs\SPS\Data Extraction\WSS\13.log...finished Parsing C:\Program Files\Report Packs\SPS\Data Extraction\WSS\14.log...finished Parsing C:\Program Files\Report Packs\SPS\Data Extraction\WSS\15.log...finished Parsing C:\Program Files\Report Packs\SPS\Data Extraction\WSS\16.log...finished Parsing C:\Program Files\Report Packs\SPS\Data Extraction\WSS\19.log...finished Parsing C:\Program Files\Report Packs\SPS\Data Extraction\WSS\22.log...finished Parsing C:\Program Files\Report Packs\SPS\Data Extraction\WSS\23.log...finished Parsing C:\Program Files\Report Packs\SPS\Data Extraction\WSS\24.log...finished Parsing C:\Program Files\Report Packs\SPS\Data Extraction\WSS\25.log... An exception has occured: System.Data.SqlClient.SqlException Error converting data type nvarchar to smalldatetime. ---------- have you had any reports of this?
Friday, December 02, 2005 11:41 AM by Andy Lubel

# The SharePoint Chronicles Source Code for the Data Extraction Program | Paid Surveys

PingBack from http://paidsurveyshub.info/story.php?title=the-sharepoint-chronicles-source-code-for-the-data-extraction-program

Friday, May 29, 2009 4:25 PM by The SharePoint Chronicles Source Code for the Data Extraction Program | Paid Surveys
New Comments to this post are disabled
 
Page view tracker