Links: Sites Created: Sites I like:
Excellence - http://excellence.bergren.net
Pics - http://picasaweb.google.com/rnbergren
Bibles - www.ilikebibles.com
Polk City - www.polkcity.org
Church - www.ridgelife.org
FCStone -
www.fcstone.com
http://www.efcpolkcity.com/
http://www.kruegerankeny.com/
http://www.hotwireds.com/
http://www.totalqualityinc.com/
www.npcitizensforprogress.com
DMACC - wwww.dmacc.edu
http://rnbergren.stumbleupon.com/
http://my.yahoo.com
www.geekbrieftv.com

Having fun being a father and a web geek.

Hello, my name is Rod Bergren

Who am Who am I?  I am a geek/programmer/webmaster/manager for the bestest company.  I write applications for Web Services and Windows.  I also do on the side contract programming as my time allows (which is not very much).

 

Wednesday, October 15, 2014

Linking from into a List Item for Viewing or Editing the list. Project Server
Sometimes in Project Server (Microsoft Project server that is)  you are creating a report that shows the list items from the project site.  IE Issues, Risks, Deliverables.  

These can all be found in the reporting database and it comes contained in there.  Pretty easy stuff to find.  I will let you do the research for that.  

But once in awhile.  You have to link to the list item.  Mainly because there is just too much information that is in the item to show on a report and the end users want that drill down ability.  

I cannot say that I blame them.  

Anyhoo,  You need to know SharePoint at this point.  The linkage is pretty easy.  So lets say that I have a Risk for a Project and I want to be able to put an Edit this Item link into one of my reports.  The SQL is fairly easy.  If you know the project guid.  You just write SQL like

select r.RiskID, p.projectworkspaceinternalhref  as purl from msp_wssrisk inner join msp_epmproject_userview p on r.projectuid=p.projectuid  where projectuid = @guid

ok now you have the RiskID and the URL for the Project.  Want to create that link?

here is your formula

@purl + Lists + Risks + Editform.aspx + ?ID = @RiskID

so it should come out like the following

@purl = "http://projectserver1/projectsite1"
@RiskID = 1
full link should be
"http://projectserver1/projectsite1/Lists/Risks/Editform.aspx?ID=1"

There you go.  Now you can give people that ability to edit the item

Want them to Just view
Replace Editform with DispForm
Entering a New Item?
drop the ?ID=#
use NewForm.aspx

Lots and lots of uses.  Issues, and Deliverables work the same way.  
I have not tested with Tasks especially not in 2013. 



Wednesday, October 08, 2014

Just another morning. Just another sunrise.
Just another sighting of God.  A friend the other day spoke to me about God and how I have been looking for God in nature.  He isn't far off.  But I look for God in glimpses.  glimpses of things.  a glimpse of a smile on a child's face when they see their mom,  a glimpse of a butterfly as it weirdly flies around.  the glimpse of a dog when its master enters the house.  and yes the glimpse of God as I drive across saylorville lake at 7am in the morning.  Yes there is a glimpse of God there.  He is everywhere though.  You just have to look.  God is there in your pain.  He is there in your frustration.  He is there when someone lies to you.  He is there when you get a hug.  He is there when it rains and when the sun is shining.

God is there.

And yes there is a picture.


Monday, October 06, 2014

Problem Steps Recorder
This is more a note to myself than anyone else

Problem Steps recorder?
Start Button || Type “PSR” || Hit Enter
Works in Windows 7 and 8. Basically it records what your doing to create a problem and saves all the screen shots and the mouse clicks and keyboard strokes into a zip file html page that you can email to someone else to review.

Good starting point for documentation. Also, good starting point to review how a customer might be encountering an issue.

And it is free and just works.
Tuesday, September 30, 2014

Go Comets
love the new field.  It is awesome
Thursday, September 18, 2014

Morning sunrise

Saylorville at its best looking.  This does help make my day start off correctly. 

Wednesday, September 10, 2014

My drive to work this morning

Was a nice drive.  No one else on the road for once.  I could stop and shoot. 

Saturday, September 06, 2014

Yes it was that gorgeous for about two seconds last night

The evening sky

 

 


The Crew

  More pictures are here.

 
From Ariea

Papa's concert.


     

Other stuff of interest to people possibly.

Trip to Tahiti.

Belize is nice as well