Latest posts of: dementedmuppet -
Welcome Guest.   Make a donation to an author on the site August 01, 2015, 12:44:48 AM  *

Please login or register.
Or did you miss your validation email?

Login with username and password (forgot your password?)
Why not become a lifetime supporting member of the site with a one-time donation of any amount? Your donation entitles you to a ton of additional benefits, including access to exclusive discounts and downloads, the ability to enter monthly free software drawings, and a single non-expiring license key for all of our programs.

You must sign up here before you can post and access some areas of the site. Registration is totally free and confidential.
Check out and download the GOE 2007 Freeware Challenge productivity tools.
  Forum Home Thread Marks Chat! Downloads Search Login Register  
  Show Posts
      View this member's profile 
      donate to someone Donate to this member 
Pages: [1]
1  Main Area and Open Discussion / General Software Discussion / SharePoint 2007 activity log viewer - looking for a free viewer (or low cost) on: November 23, 2011, 02:43:22 PM
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?

2  Main Area and Open Discussion / General Software Discussion / Re: What Windows needs: fully streamlined application installation at setup on: July 20, 2009, 01:03:05 PM
Bart PE  is nice for XP installs
3  Other Software / Programming School / Re: Which language should I learn first? on: July 20, 2009, 12:11:25 PM
I agree with both methods:  using SQL server backend and splitting the back/front end.  PPLandry is right about about the importance of good design.  An accountant built a database for budgeting that resembled a house of cards over a bowl of spaghetti. 

The debate really highlights the point I was making:  Because it is easy to quickly create a database in M$ Access many businesses use it even if it is only an interface for an SQL, Oracle, or other database.  It can create some hideous results but that is all the more reason for good coders to be familiar with it. 

Just like the technically proficient prefer Linux over Windows and Firefox over IE, most agree that Access is not the BEST database solution.  But Windows, IE, and Access are not going away and you can't wrench users away from these sick addictions.

No one is going to change the tide.  Going with the flow a little can lead to $$$$$. 

Maybe I should not argue the point.  As long as techies continue to hate Access, I continue to get paid well for working with it.  Excerpt from my job offer acceptance speech:  "I would like to thank all of the brilliant programmers who refuse to work with Access.  Without them no one would ever consider paying me this much.

Go HATERS!!"   Kiss 
4  Main Area and Open Discussion / Living Room / Re: From the BBC science desk: Cats 'exploit' humans by purring on: July 14, 2009, 02:01:09 PM
I am not surprised.  I have always been suspicious of Mouser.  tongue
5  Other Software / Programming School / Re: Which language should I learn first? on: July 14, 2009, 11:23:44 AM
Maybe this is a stupid question, but I have wonder for quite some time now...

Why don't more beginning programmers get into the type of applications used in offices?  

I write databases for a Fortune 500 (specifically, Fortune 100) company.  Being able to understand the business needs and match those with code is challenging.  The guy who previously had my job was an engineer.  His programming skills far exceed mine.  He had "engineer blinders" that put him out of touch with the users.  

Microsoft Office is so commonly used yet I almost never find coders who are familiar with it.  If I had a nickel for ever time I heard "Access is not a good database solution" I would never need to work again.  The prevalence of the product makes it worthwhile to learn.  Once the basics are learned, the pathetic interface is less relevant since it reads SQL and VB.  The fact that a good coder would never choose it is well established.  But it is in such common use that the coder's choice is irrelevant.  It is no worse than OOP like Java or C#. 

MS Access knowledge would create incredible freelance opportunities.  Most office workers don't want to know how to write code even if the code is easy.  So a coder could offer to do it, spend ten minutes writing the solution, deliver it a week later and charge a zillion $s...

Please don't villify me for leaving the Ivory Tower of coders.  I am just curious why there are so many talented coders who struggle to make a living.  Not all of them struggle.  But fewer would have to if they peak outside the Tower.
6  Special User Sections / Site/Forum Features / Re: Longtime DC Member JoTo is in hospital again -- address for sending postcards on: January 29, 2009, 10:04:33 PM
Welcome back!  Yes something is definitely missing when you are not around
7  Other Software / Found Deals and Discounts / Re: on sale: The Complete Calvin and Hobbes on: March 27, 2008, 11:13:36 AM
Calvin and Hobbes has got to be the best comic in the universe! Too bad it's so expensive.

When I was young, I had a few people tell me that I reminded them of Calvin.

I forbid my son to read the comic because he was too much like Calvin.  The ban didn't work because he was still Calvin, right down to playing Calvin ball.  When he was 9, he got ahold of a copy of a C&H book from my brother.  His only comment was, "You're right!  Calvin is me!"  Unfortunately, it is so.  However, I don't think I'd like him so much if he was one of those sycophant goodie-goodie kids.

In a couple of years, when it is safe, I might get the set.  He will be too old to use most of the material at that point.
8 Software / Post New Requests Here / Re: How do I convert (wtf is this? Cobol?) to numbers? Examples included. Help on: February 14, 2008, 09:25:42 PM
Nice of you to ask   smiley

I got the reports formatted and sent.

My code needs some work so future reports aren't so much hassle. 

Tinjaw's code really helped in getting me on the right track.  Just a few quirks to sort out to fully automate it.

I also have to take out the wacky bits like scrolling & resizing the window.  My boss & coworkers get all impressed by the errors because it makes it LOOK like the code is doing something.  But eventually I have to turn it over to I.T. for them to add to their processing schedule. They won't be impressed by wacko irrelevant lines.

Concise answer:  problem solved.  Thanks!!
9 Software / Post New Requests Here / Hopeless on: February 14, 2008, 03:02:00 PM
Tinjaw's code works well.  I was supposed to have the reports done two days ago.  My macros were buggy.  Scoured VB help & killed a few trees printing some VB help (hopefully, this addiction to paper will pass).

Yesterday, Excel was getting hung up on converting cells.  Driving home, I realized the problem was likely that I left "#VALUE!" errors in the range I told Excel to convert to numbers.  Brilliant  Thmbsup

After six hours of trying to fix the macros, I clicked the little "!" help icon that was beside the data that needed modified.  One option was "help with this error."  The solution was "multiply by 1".  That WOULD explain why there are no VB methods to fix the issue.

See?  Hopeless  Roll Eyes

The macro comments included my name (now removed).  Why don't I add my social security number, passwords, etc...   Genius, I tell ya.  GENIUS!
10 Software / Post New Requests Here / Re: How do I convert (wtf is this? Cobol?) to numbers? Examples included. Help! on: February 12, 2008, 03:12:34 PM
It works.  If my child did not already have a cool name, he woud be "chaim"
11 Software / Post New Requests Here / Re: How do I convert (wtf is this? Cobol?) to numbers? Examples included. Help! on: February 12, 2008, 01:00:35 PM
VBA maro would be ideal

Either to convert the values while keeping them in the Excel cells they currently occupy, or create a new tab that has the converted values.

The sample code is VBA used to create "COBOL" values.  Theoretically, I could edit & rearrange it to reverse the process.  My failure to understand the code makes that difficult.

Any reference sites you've found helpful?

12 Software / Post New Requests Here / Re: How do I convert (wtf is this? Cobol?) to numbers? Examples included. Help! on: February 12, 2008, 11:27:00 AM
Yes, it is logical and convenient for transmissions but I need to figure out precisely what the standard is so I can write the code to convert it back to currency.

COBOL 'making sense' is why it doesn't die.  From accounting/finance perspective, COBOL is beautiful.  It is the backbone of financial systems since it is the best tool for the job.  Just today, while I'm frustrated, "tool" takes on a different meaning.
13 Software / Post New Requests Here / Re: How do I convert (wtf is this? Cobol?) to numbers? Examples included. Help! on: February 12, 2008, 10:21:09 AM
It seems to be a COBOL standard but I haven't determined which standard
(How many standards did they need?? Ugh!)

0000568G = $56.87
0001651L = -$165.13

What is the likelihood that any of these will help?
14 Software / Post New Requests Here / Re: How do I convert (wtf is this? Cobol?) to numbers? Examples included. Help! on: February 12, 2008, 09:35:38 AM
The numbers start in a flat file (.txt) for EDI.  They are fixed width (not comma delimited)

I use a macro to format the data into columns for a more meaningful Excel spreadsheet with column headings.

Just knowing wtf type of system this is would help me with the conversion to currency.  Obviously it isn't hex tongue 

While the sample code works to convert from currency to the (wtf) string, it isn't helful converting from (wtf) string to currency. 


Any hints?
15 Software / Post New Requests Here / DONE: How do I convert (wtf is this? Cobol?) to numbers? Examples included on: February 12, 2008, 09:09:09 AM
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


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:


Hoping for help

edit by jgpaiva: added spoiler/code tag
16  Main Area and Open Discussion / General Software Discussion / Re: Create a template for converting flat files to Excel or DB on: January 25, 2008, 03:03:08 PM
The macro works great & you rock  Kiss
17  Main Area and Open Discussion / General Software Discussion / Create a template for converting flat files to Excel or DB on: January 25, 2008, 01:21:33 PM
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???
18  Main Area and Open Discussion / General Software Discussion / PDF to CSV on: January 14, 2008, 10:38:23 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?
19  Special User Sections / N.A.N.Y. 2008 / Re: The N.A.N.Y. Programming Challenge for 2008 on: December 09, 2007, 09:16:04 PM
The N.A.N.Y. Programming Challenge for 2008

What you get:
  • A rare DC mug commemorative of the event (or any other object if you already have a mug)
  • Fame and fortune (disclaimer: you will get neither of these)

Maybe not a fortune, but when I was interviewing for a better job, the employers were impressed that I participated in NANY last year.  It is a great opportunity for new coders. 

While the more experienced coders made far better apps than I did, it was helpful for me to be able to say, 'I did this.'

AND I got the fabulous mug!!
20  Other Software / Developer's Corner / Re: Web development best practices for state technology fair site on: June 12, 2007, 04:35:51 PM
Quick answers aren't a necessity.  It will be several months before the site needs to be operational since the last fair took place in April.

I've had some experience and prefer not to write in pure html.  We attempted SOAP in a class last semester but it was running Windows so it didn't turn out well.  It seems as though it would initially be a hassle, but would be easier to maintain in the future.  (Obviously, not on a Windows server, but Linux is an option)

Since we never got it working, I was hoping for input on other's experiences with SOAP, SQL, and the other web technologies.

The design tools for VB.Net are easy to use, but since the site has already had problems with that platform, it may not be a good idea for a site that won't have continuity of administration.
21  Other Software / Developer's Corner / Web development best practices for state technology fair site on: June 11, 2007, 09:28:38 PM
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
22  Special User Sections / N.A.N.Y. Challenge 2007 / Re: FreePcSecurity - v1.00.01 - December 14, 2006 on: January 11, 2007, 10:34:54 AM
All of the responses are appreciated.  I would really like for the app to have the best freeware security programs.  Everything currently in it is from the website you can access from the last button on the app.  The site belongs to a friend of mine who provides technical and security support to his clients in Southern Ohio.  Since most people don't take the time to help those who lack security knowledge, I've found it was easiest to refer people to his site when they asked for help.

Continued input is certainly welcome since the program will be updated periodically to provide the best free security information available.

I've asked my friend to review your comments and I hope he will provide further input.  It would be nice if more people were like him and benevolently spent the time to provide the type of information available on his site. 
23  Special User Sections / N.A.N.Y. Challenge 2007 / Re: FreePcSecurity - v1.00.01 - December 14, 2006 on: December 15, 2006, 11:21:41 AM
Thanks, tinjaw.  Snapfiles gives Comodo a good rating.

Ruffnekk:  I completely agree with you.  This is not even close to what I intended to do for the app.  The problem is that Java browser launch is not covered in any of the textbooks I have and I am having a difficult time getting it to work.  The only browser launch code that I can get working limits the format to this panel.  Toggling through screens was my first choice of format.  Combo box was second.  Every time I try another layout, the launch stops working.  I'll be spending more quality time with Google. 

Don't worry about hurting my feelings with criticism.   cheesy

Java is like MS Access... easy to use but inflexible.  The only answer I can find to modifying the icon is 'just like you can't put your own icon on a word document, you can't put your own icon on a jar.'  It is beginning to seem that writing the whole thing in binary would be easier than fighting with Java.
24  Special User Sections / N.A.N.Y. Challenge 2007 / FreePcSecurity - v1.00.01 - December 14, 2006 on: December 14, 2006, 11:13:07 PM
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  undecided 

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.

25  News and Reviews / Official Announcements / Re: THE N.A.N.Y. CHALLENGE - New Apps For the New Year on: November 30, 2006, 07:40:49 AM
App coerced me into this.  But I will try it  undecided
Just blame her if the result is Frankenstein
Pages: [1] | About Us Forum | Powered by SMF
[ Page time: 0.05s | Server load: 0.02 ]

Share on Facebook
submit to reddit