topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • November 22, 2019, 04:05 AM
  • Proudly celebrating 13 years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - dementedmuppet [ switch to compact view ]

Pages: [1]
1
Hi, all

SharePoint 2007 provides canned site usage reports.  I need to be able to dig in to the actual data.  There are detailed activity logs for the SharePoint site.  However, they are not in a user friendly format.  The data is encoded or refers to system tables. 

There are programs that allow an admin to view the actual log.  These pull 'friendly' versions (ex:  user names rather than a user key that ties to a system table).  Micro$oft has apps that expose the friendly version of the logs.  These (obviously) are insanely expensive and not an option for me.

Does anyone know of a free or low cost application that allows a site admin to view the SharePoint activity logs in a 'friendly' format?

Thanks!!
Mup

2
The data is received in a funky format because negative values are not allowed.  The numbers are converted as:

On a positive number:                                On a negative number:

{ = 0                                                         } = 0
A = 1                                                         J = 1
B = 2                                                         K = 2
C = 3                                                         L = 3 
D = 4                                                        M = 4
E = 5                                                         N = 5
F = 6                                                         O = 6
G = 7                                                         P = 7
H = 8                                                         Q = 8
I = 9                                                          R = 9

Examples:

0000568G = $56.87
0001651L = -$165.13

I need to convert the wacky 0000568G types to currency types.  Anyone got code for this? 

I have sample code that does the opposite but reversing code I barely understand is a waste of time if someone already has code to do what I need:

 
Spoiler
Function format_currency1(ByVal money As String, ByVal width As Integer) As String

   'convert to internal format for currency

 

   Dim positive As Boolean

   Dim decmoney As Currency

 

   'need to convert to decimal to format number

   decmoney = money

 

   'set switch for positive/negative value

   If decmoney >= 0 Then

      positive = True

   Else

      positive = False

   End If

 

   'ensure there are no negative numbers

   decmoney = Math.Abs(decmoney)

 

   'format number to ensure the 2 right characters are the cents and convert back to string

   If Left(Right(decmoney, 3), 1) = "." Then

      money = decmoney

   Else

      money = decmoney & ".00"

   End If

 

   'omit decimal point

   money = Left(money, Len(money) - 3) & Right(money, 2)

 

   If positive = True Then

      'positive currency amount

      Select Case Right(money, 1)

        Case 0

            money = Left(money, Len(money) - 1) & "{"

        Case 1

            money = Left(money, Len(money) - 1) & "A"

        Case 2

            money = Left(money, Len(money) - 1) & "B"

        Case 3

            money = Left(money, Len(money) - 1) & "C"

        Case 4

            money = Left(money, Len(money) - 1) & "D"

        Case 5

            money = Left(money, Len(money) - 1) & "E"

        Case 6

            money = Left(money, Len(money) - 1) & "F"

        Case 7

            money = Left(money, Len(money) - 1) & "G"

        Case 8

            money = Left(money, Len(money) - 1) & "H"

        Case 9

            money = Left(money, Len(money) - 1) & "I"

      End Select

   Else

      'negative currency amount

      Select Case Right(money, 1)

        Case 0

            money = Left(money, Len(money) - 1) & "}"

        Case 1

            money = Left(money, Len(money) - 1) & "J"

        Case 2

            money = Left(money, Len(money) - 1) & "K"

        Case 3

            money = Left(money, Len(money) - 1) & "L"

        Case 4

            money = Left(money, Len(money) - 1) & "M"

        Case 5

            money = Left(money, Len(money) - 1) & "N"

        Case 6

            money = Left(money, Len(money) - 1) & "O"

        Case 7

            money = Left(money, Len(money) - 1) & "P"

        Case 8

            money = Left(money, Len(money) - 1) & "Q"

        Case 9

            money = Left(money, Len(money) - 1) & "R"

      End Select

   End If

           

   'pad left with leading zeros to meet field width requirements

   While Len(money) < width

      money = "0" & money

   Wend

           

   format_currency1 = money

 

End Function



Hoping for help
Sincerely
Muppet


edit by jgpaiva: added spoiler/code tag

3
The obvious:  Working with any Microsoft product SUCKS

... but I have no choice because it is for work and my employer chose MS

The problem:  It is a waste of time to set the column widths every time I have to convert the flat files to Excel since there are 76 columns and the width is the same every time.

Question:  How do I create a template??

The files are .txt
I know the column width
I can manually set the column widths while converting from .txt to .xls
Can't I create a template to do this?

I keep searching Google and Microsoft but not finding any 'useful' answers

Is there a better place to search????  Or does someone actually know how to do this???

4
General Software Discussion / PDF to CSV
« on: January 14, 2008, 10:38 AM »
This task is driving me mad

Here is the problem:

Preprinted surveys are sent.  Respondents check boxes on the surveys.  The surveys will be scanned.  The responses need to be captured in a spreadsheet or database.

Obviously, a Scantron would work better.  However, I'm stuck working with these checkbox pages and can't find an effective solution to capturing the responses.

Can anyone recommend software or a process for doing this?

5
One of my professors helps with the state technology competition for students from elementary through high school.  The registration site for the schools, projects, and sponsors needs work. 

I've never done a website but want to tackle it and was hoping for input regarding which technologies are best suited to the purpose. 

The continuity of administration is a challenge.  It will likely be a different individual every year.  The last individual to attempt to update the site was hampered by incompatibility issues between versions of VB. I searched on the forum but I didn't find a thread that seemed to address web development best practices. 

I thought SQL and SOAP look promising and hoped for feedback.

 There didn't seem to be definitive information on Google and the feedback from the NANY project was great so I thought DC forum would be a good place to post

Current site
http://acte.aum.edu/state07/index.asp

6
FreePcSecurity - v1.00.01 - December 14, 2006

   
  • First release
  • Based on a friend's website
  • When I send people with questions to his site, they are too lazy to read it
  • Hoping a GUI will get a better response
  • Since it is basic security information, people silly enough to run JRE are a good target audience
  • ALL suggestions are welcome!  I'd really like to replace ZoneAlarm with a free firewall that isn't evil so I am hoping for suggestions on that
  • I'm still researching how to add the icon to the jar  :-\ 


WHAT IT DOES:
Each button either starts the download for a free security application or else it takes them to a site to get the app.
The last button takes them to a page with explanations and other security information.


SCREENSHOT:
[attach=#1][/attach]

Pages: [1]