Thursday, October 29, 2009

Displaying Document Libraries in other sites

A client recently asked for a modification to Business Portal - Requisitions Management. They wanted to post a library for supporting documentation (quotes, product spec sheets, etc.). The problem is that they wanted it visible in both the Employee Purchase Request entry screen and the Purchasing Requisitions management screen and these pages are in two entirely separate sites.

As you may know, SharePoint is great at showing content from all the libraries you set up....as long as they are within the same site. Site A has no clue that Site B even exists.

The key for this solution came down to using the Page Viewer web part. This web part allows you to display another website within a window on another page.

The next challange is that SharePoint pages all include navigational borders and headers. When you display a SharePoint page within another page, all this flotsam is included, making a really confusing page. Here's how I worked around this issue.

Step 1: Setup your document library. Because I wanted to make sure that all users could get to the library, I set it up in the main Business Portal site. You can add permissions to the library if you need to in order to keep the right people in and the wrong ones out. Add any custom fields you might need to help find your documents more quickly. In this case, I added a mandatory Requisition ID field and an optional description field.

Step 2: Create a view for the document library that only shows the columns you'll want displayed on the other page.

Step 3: Create a new blank page that we'll use to display the document library in a web part. We'll be adding code to hide all of the navigational elements, so we don't want to do this on a page that's needed for something else. In this case, I went to the Business Portal Common Pages library and added the new page there, calling it RequisitionDocs.aspx

Step 4: Add the document library web part to the page.

Modify the web part to your liking. For me, I like to remove the ability of the user to do anything bad, like deleting the web part, moving it around, etc. I put it there for a reason, now you leave it alone! :) You'll also want to either have no title showing or show the title only. Select the view for the document library that you created above.

Step 5: Add another web part - the Content Editor web part. This is where we'll hide everything else on the page like the borders, the header...all that junk. In the content editor page, paste the code found on this page: http://vspug.com/spfromscratch/2007/12/18/blank-page/

NOTE: Take the "*" characters out of the word "java*script and don't forget the colon after the work "java*script"

As soon as you save the content, the page should change dramatically. If you're brave, you can remove the link at the bottom. Just remember though that you need a way to get back into edit mode so DON'T hide all your titlebars!

Step 6: Now that we have the page built that we want to display, we can link to it from our source pages. Edit the page where you'd like to display the library and add the Page Viewer web part. Modify the web part and add the url to your document library to the Link field. In this case, the URL would be http://dynamics-web/BP/Business%20Portal%20Common%20Pages/RequisitionDocs.aspx

Adjust the web part to be the way you want it on the page and Viola!

To take it further, the list view that I created had title that you could click on which then loaded the document library in my web part...bringing back all the navigational nastiness. To get around this, change the titleurl field in the document library on the display page (requisitiondocs.aspx). Instead of pointing to the document library, use the hash character instead (#).

Another problem is that in the default views for the document library, there's an "Add new document link" that again loads a full page for uploading documents. Sheesh, I try to get out and they keep pulling me back in! To get around this, edit the document library web part on your display page and change the toolbar type to "No Toolbar".

I have quite a few sources to thank for this, most of all is the code for hiding the nav elements. I found it posted on this page - http://vspug.com/spfromscratch/2007/12/18/blank-page/

The tip for hiding the Title URL was found here - http://social.msdn.microsoft.com/Forums/en-US/sharepointcustomization/thread/ac235b36-b516-40d3-bd2d-ea7dccd8eef1 and the tip on hiding the "Add new document" link was found here - http://social.msdn.microsoft.com/Forums/en-US/sharepointcustomization/thread/9561ff37-bd33-44ec-be45-82f0fcd868db



Tuesday, August 11, 2009

Sharepoint or Sharepoint Central Admin Returns Error “The File Exists (Exception from HRESULT: 0x80070050)

One of my clients is a financial institution. As such, they have pretty stringent controls on user accounts for vendors that may need to work on their system. Several months ago, I was brought in to do an install of Business Portal, which requires SharePoint.

I was given a temporary admin level userid to use during the setup, which I used to install and configure SharePoint and Business Portal.

Today I was called back to resolve some issues with Business Portal. When I tried to log back into SharePoint, my access was denied. I tried to get to Central Admin and received the error – The file exists. (Exception from HRESULT: 0x80070050).

Basically, what has happened is that the user account I was given initially was deleted after the initial install was completed and then recreated when I was asked to come back and repair Business Portal. They also never created another Admin login for the Central Admin and SharePoint sites. When the new account was created, AD issued a new SID (Security ID) which is the string of characters that REALLY defines your account. Your username is just a descriptive field. SharePoint provides access based on the SID, not just the username field. So, my username is the same, but the SID is different, preventing me from getting to SharePoint. The problem is that my account is the ONLY one that has rights – not a good situation for the client to be in.

Fixing this problem….well, it’s not a simple procedure. I’ve spent nearly two hours now researching and testing ways of getting the SID updated in the SharePoint database.

Here’s the procedure to go through to get the SID changed for a user in SharePoint. You’ll definitely earn your Geek badge for this one.

ts-geek.lg[1]

WARNING: This is a low-level solution, requiring hackery and other risky behaviors. USE AT YOUR OWN RISK ONLY AFTER YOU HAVE A BACKUP.

Procedure:

  • Get the SID listed in SharePoint
  • Get your current SID from Active Directory
  • Convert your current SID from binary SID to HEX
  • Update the database with the new HEX value

Simple sounding, not so much in real life. After much searching and trial and error, here are the source files you’ll need to accomplish this.

1) Get the SID listed in Sharepoint

Connect to your SQL Server and run the following query on the AdminContent database for your SharePoint install:

SELECT Sites.Id, Webs.FullUrl FROM Sites inner join Webs on Sites.RootWebId = Webs.Id

This will give you a list of the sites and associates URL’s that SharePoint knows about. Copy the Site ID to your clipboard.

You’ll now run this script that will get you the other information you need – including the user’s SID which is in the tp_SystemID field. Paste your Site ID from above into the XXXX space below.

SELECT * FROM UserInfo WHERE tp_SiteID='XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX'

If you don’t mind filtering through a long list manually, you can just skip the 1st step and run this query -

SELECT * FROM UserInfo

This will get you a list of the usernames for that site.

2) Get your current SID from AD and convert to HEX

This is the part that took a long time to figure out. Fortunately, I came across a Visual Basic Script that will accomplish the task in one fell swoop.

You’ll want to copy the following text into NotePad and then save it as getSID.vbs. Note the portion in yellow below, you’ll need to replace it with the user’s AD context information. If you don’t know what the context is, use the dsquery command listed below the script to retrieve it.

GETSID.VBS

Option Explicit
Dim objUser, arrSid, strSidHex, objTrans, strUserDN, strSidDec
' Constants for the NameTranslate object.
Const ADS_NAME_INITTYPE_GC = 3
Const ADS_NAME_TYPE_1779 = 1
Const ADS_NAME_TYPE_SID_OR_SID_HISTORY_NAME = 12
' Bind to object. REPLACE WITH YOUR AD INFO 
Set objUser = GetObject("LDAP://cn=Test,ou=Sales,dc=MyDomain,dc=com")
' Retrieve SID and convert to hex string, then to decimal string.
arrSid = objUser.objectSid
strSidHex = OctetToHexStr(arrSid)
Wscript.Echo strSidHex
strSidDec = HexStrToDecStr(strSidHex)
Wscript.Echo strSidDec
' Use the NameTranslate object to convert objectSid to
' Distinguished Name.
Set objTrans = CreateObject("NameTranslate")
' Initialize NameTranslate by locating the Global Catalog.
objTrans.Init ADS_NAME_INITTYPE_GC, ""
' Use the Set method to specify the SID format of the object name.
objTrans.Set ADS_NAME_TYPE_SID_OR_SID_HISTORY_NAME, strSidDec
' Use the Get method to retrieve the Distinguished Name of the user object.
strUserDN = objTrans.Get(ADS_NAME_TYPE_1779)
Wscript.Echo strUserDN
Wscript.Quit
Function OctetToHexStr(arrbytOctet)
' Function to convert OctetString (byte array) to Hex string.
Dim k
OctetToHexStr = ""
For k = 1 To Lenb(arrbytOctet)
OctetToHexStr = OctetToHexStr _
& Right("0" & Hex(Ascb(Midb(arrbytOctet, k, 1))), 2)
Next
End Function
Function HexStrToDecStr(strSid)
' Function to convert hex Sid to decimal (SDDL) Sid.
Dim arrbytSid, lngTemp, j
ReDim arrbytSid(Len(strSid)/2 - 1)
For j = 0 To UBound(arrbytSid)
arrbytSid(j) = CInt("&H" & Mid(strSid, 2*j + 1, 2))
Next
HexStrToDecStr = "S-" & arrbytSid(0) & "-" _
& arrbytSid(1) & "-" & arrbytSid(8)
lngTemp = arrbytSid(15)
lngTemp = lngTemp * 256 + arrbytSid(14)
lngTemp = lngTemp * 256 + arrbytSid(13)
lngTemp = lngTemp * 256 + arrbytSid(12)
HexStrToDecStr = HexStrToDecStr & "-" & CStr(lngTemp)
lngTemp = arrbytSid(19)
lngTemp = lngTemp * 256 + arrbytSid(18)
lngTemp = lngTemp * 256 + arrbytSid(17)
lngTemp = lngTemp * 256 + arrbytSid(16)
HexStrToDecStr = HexStrToDecStr & "-" & CStr(lngTemp)
lngTemp = arrbytSid(23)
lngTemp = lngTemp * 256 + arrbytSid(22)
lngTemp = lngTemp * 256 + arrbytSid(21)
lngTemp = lngTemp * 256 + arrbytSid(20)
HexStrToDecStr = HexStrToDecStr & "-" & CStr(lngTemp)
lngTemp = arrbytSid(25)
lngTemp = lngTemp * 256 + arrbytSid(24)
HexStrToDecStr = HexStrToDecStr & "-" & CStr(lngTemp)
End Function

This script will give you pop-up messages with the HEX value of the userid you’ve searched for. Unfortunately, you can’t copy and paste. So, VERY CAREFULLY transcribe it into notepad and then copy to your clipboard.

Future upgrade: I’ll try and see if I can revise the script to export to a text file instead.

DSQuery:

This command line will have to be run from a server that is AD aware and has the DSQuery utility. Easiest option is to run it from your AD Controller. In this example, we return any userid that starts with the letters JE. So for me, where my userid is RYoder, I’d use RY*

dsquery * domainroot -filter "(&(objectCategory=Person)(objectClass=User)(sAMAccountName=je*))" -attr sAMAccountName distinguishedName ObjectSid -Limit 0

 

3) Update the database with the new HEX value

Run the following script against the Content database. NOTE: You’ll need to append the 0x to the front of the HEX string you found above.

Replace the X with the tp_ID of the user you are trying to update.

UPDATE UserInfo SET tp_SystemID = 0x010500000000000000000986BD9EA976E44036C3F5D3F04040000 WHERE tp_ID = 'X'

You should now have access to the content database. Note,  you’ll also want to run this update against any other content databases that are out there – usually one exists for each web application, otherwise you’ll get an Access Denied error when trying to hit the site.

 

sleep_desk_full[1]

That’s it! Enough for now, my brain hurts just typing this!

Thursday, August 6, 2009

Troubleshooting SSRS With Dynamics GP

Installing and getting SQL Reporting Services to work with Dynamics GP is a fairly straightforward process, but there can be some tricks involved. The following link provides a good bit of information about configuring and troubleshooting the SQL Reporting Services Deployment Wizard.

SSRS with Dynamics GP FAQ

SQL2005_RS_Reports[1]

Wednesday, August 5, 2009

SQL Maintenance Plans – Rebuild or Reorganize?

Over time, customers may begin to notice a slowdown in the responsiveness of their Dynamics GP or CRM systems. One of the culprits can be SQL indexes that are no longer valid. It’s like telling your SQL Server to drive to California and then handing it a 20 year old road map – it’s going to take a little longer than it should!

closemaps3[1]

This is where maintenance plans come in. In a perfect world, each of our customers would either hire a SQL DBA to constantly monitor the server, tweaking and optimizing or else pay us to do this. Yeah…right. This is where Maintenance Plans come in – ways of automating and scheduling those cleanup tasks so that the system doesn’t deteriorate over time.

Paul Thurrott of SuperSite for Windows posits that the brain is like a stack. Put a new memory in at the top and an old memory has to drop out the bottom. As I get older, I’m starting to believe this more and more! Memorize that esoteric SQL command and out drops that memory of Skippy, my pet turtle. (Did I have a turtle? I seem to remember something like that…)

That’s where this blog post comes in. I need to document those common tasks that I use every time I setup a new maintenance plan and there’s no reason you shouldn’t benefit as well.

Nightly sub plan:

  • Full backup of all user databases
  • Delete any existing backups older than 1 week (depending on disk space)
  • Reorganize Indexes
  • Update Statistics

Daily sub plan (every hour):

  • Transaction log backup of all user databases
  • Delete any existing backups older than 1 week (depending on disk space)

Weekly sub plan:

  • DB Integrity Check
  • Full backup of all databases (including system)
  • Rebuild Indexes
  • Update Statistics
  • Delete history older than 8 weeks
  • Shrink Databases

DataBaseSmall[1]

According to Pinalkumar Dave, indexes should be rebuilt when greater than 40% fragmented. Between 10% and 40%, use reorganize.

Setup Bing Wallpaper Desktop Slideshow

For those running Windows 7, you may have played around with the desktop slideshow. Did you know you can have those images piped in from an RSS feed. I’m thinking Flickr or maybe even those cool images Bing uses on it’s front page.

Mahendra Palsule at makeuseof.com has posted an article on how to do this. If you want to use another source, you could edit the file she provides and throw in your own source!

BingArchive[1]

Find the article here.

Creating Report Subscriptions in Microsoft Dynamics CRM 4

Something that gets asked a lot is “Why can’t the data come to me? Why do I have to go somewhere and get it?”

There are ways to make that happen. CRM MVP Donna Edwards has posted an article on the Dynamics CRM Team Blog about exactly that topic. Find the article here - http://tinyurl.com/n5dsy7

Plus, it utilizes one of my new favorite tools – SQL Reporting Services.

RSub8Image[1]

Friday, February 13, 2009

Vista Defrag: Nice Utility - No Feedback

The defrag utility in Windows XP was a useful utility that provided a text report on fragmentation statistics as well as a graphical representation of the hard drive showing fragmentation.

Vista has none of that. For some reason, the developers removed all the reporting and set defrag as a background process. Admittedly, it does a good job of keeping the system relatively cleaned up.

However, sometimes as an admin, I just gotta know what's up with the volume. Command line to the rescue!

Open a command prompt in administrative mode (right click and choose Run as administrator and then type defrag /?

Description:  Locates and consolidates fragmented files on local volumes to improve system performance.

Syntax:  defrag.exe <volume> -a [-v]
defrag.exe <volume> [{-r | -w}] [-f] [-v]
defrag.exe       -c [{-r | -w}] [-f] [-v]

Parameters:

Value                 Description

<volume>              Specifies the drive letter or mount point path of the volume to  be defragmented or analyzed.

-c                        De fragments all volumes on this computer.

-a                        Performs fragmentation analysis only.

-r                        Performs partial defragmentation (default). Attempts to consolidate only fragments smaller than 64MB.

-w                       Performs full defragmentation. Attempts to consolidate all file fragments, regardless of their size.

-f                        Forces defragmentation of the volume when free space is low.

-v                        Specifies verbose mode. The defragmentation and analysis output is more detailed.

-?                        Displays this help information.

Below are defrag.exe examples:

defrag.exe d: (defrag the D: drive)

defrag.exe d:\vol\mountpoint -w -f (defrag the mountpoint while consolidation all file fragments regardless of size and if volume space is low, forces it to defrag)

defrag.exe d: -a -v (run analysis on the D: drive and set verbose mode for detailed output)

defrag.exe -c -v (defrag all volumes on your Computer and set verbose mode for detailed output

Thursday, February 12, 2009

Opportunities don't display Pipeline Phase in CRM

I've run into some cases where Dynamics CRM will not correctly display the pipeline phase in the status area of the Opportunity record. Most often, the Opportunity simply display "None" even though the Opportunity may show up correctly on Reports like the Sales Pipeline Report.

There is a quick work-around. It appears that if you add the Pipeline Phase record as a read-only record on the Opportunity form, it will correctly display in the status area.

So, dig into Setting / Customization / Customize Entities / Opportunity / Form and add the record. Make sure the check the box that sets the field as Read-Only.

Update: If you need to develop a workflow that sets the pipeline phase, you'll need to remove it from the Opportunity form or it won't show up under Additional Fields.

Tuesday, June 17, 2008

Microsoft TS2 Event - Cincinnati

Presenter: Peter

Server 2008 Compelling Features

  • Powershell - scripted maintenance routines
    • Hundreds of scripts already available
    • All management features, including GUI, overlays for PS scripts
    • MyITForum.com
  • Deployment is based on image copy from media to drive.
  • Assign Roles (server services) / Features (specific components)
  • Server Core - extremely minimal install of the server OS / features
  • Native IP v4 / v6 support
  • Web Services
    • IIS 7.0
      • Modular component deployment
    • Windows Sharepoint Services
      • Extended supportability and feature sets
      • Sharepoint today = email 7 years ago
    • Windows Media Services
  • Virtualization
    • Presentation (Terminal Services)
    • Server (Virtual Server 2005 / Windows Server Virtualization / HyperVisor)
    • Desktop (Virtual PC)
    • Application (SoftGrid)
      • Allow multiple versions of applications on same machine with no compatibility issues
      • Basically application publishing
      • Full SoftGrid still available as Microsoft Desktop Optimization Pack
    • Hyper-V (BareBones VM Host)
    • System Center  Virtual Server Manager
  • Terminal Services Gateway
    • Remote Web Workplace for the enterprise
    • Tunnel RDP over HTTPs to an internal gateway that proxys the connection to the end point.
  • Security
    • Network Access Protection
      • Make sure patches / av / security up to date before machines get to your corporate resources
    • Read-only domain controllers
      • Only passwords allowed are stored on remote server
      • One way replication, read-only copy.
      • Users must be added at source
      • With bit-locker and RODC, secures remote access

Citrix - Meh...

Vista Service Pack 1

  • Holy crap, what a bitch fest

MS Online Services

  • Predictable IT costs
  • Peace of mind for security and reliability
  • Low run rates
  • Partner Opportunities
    • Expand reach
      • new customers
      • new segments
      • new scenarios
    • Grow revenue
      • new services
      • recurring revenut
      • upsell to online suite
    • Increase Velocity
      • increase capacity
      • scale
      • increase margins

Small Business Server 2008

  • SBS 2008 Premium requires 2 boxes.
  • 1st MUST be 64-bit. 2nd can be 64 or 32-bit.
  • Optionally, ignore 2nd OS license and install SQL on primary box (which must be 64-bit)
  • SBS may support Hyper-V.
  • 75 CAL limit (concurrent)
  • Single home network only - single NIC only (teaming OK)
  • IIS is no more. Will be rolled into ForeFront.

Links

Notes

  • Average IT Budget - 70% maintenance / 30% new purchases
  • 80% closure rate for Competitive Sales Assistance
  • Dynamics under same management structure as Office in Redmond. Increased integration down the road.

Action Items

  • Find someone to partner with that can do VOIP. Integrating with MS technologies critical.
  • Get "fantastic 40 templates"
  • Check out the Big Easy Offer
  • Check out Open License subscriptions - low monthly fee for licensing
  • Check on Small Business Specialist smbizspecialist.com

 

"Other thoughts"

  • When presenting, don't ask the question if you don't know what the answer is going to be. Presenter is 0 for 3 on rhetorical questions 10 minutes into the presentation.
  • Definitely a high level of Asperger's Syndrome in the room. Small Business consultants are some serious geeks. "Well actually...."

Thursday, May 29, 2008

GP Technical Airlift Notes - Day 2 - What, more SharePoint?

Configuring Business Portal

Eric Gjerdevig, MCT, MCP - egjerdevig@summitgroupsoftware.com

Joe Tews, MCT, MCP - jtews@summitgroupsoftware.com

Why Business Portal as opposed to just building a Sharepoint site?

  • Sharepoint doesn't have an understanding of multiple companies
  • Sharepoint doesn't understand what an invoice is, what a check is - what an employee is.
  • Business Portal has pre-defined roles that provide group level security.

What is needed to run BP in an Extranet?

  • ISA Server
  • SSL
  • Recommended - Multiple web servers / farms for internal / external access. Allows different functionality to be applied to each - more features for internal, limited for external.

Adding Users Manually

  • BP Role (MBF - Microsoft Business Framework)
  • Site Setting / Users
  • Pick a Task / Add new user
  • Assign Roles
  • Sharepoint Security
  • Open Sharepoint Security
  • Add user to BP Internal User (ALWAYS!) at a minimum
  • Assign to any other groups (that correspond with the roles assigned above)
  • Web Services Rights
  • Use Dynamics Security Console and add the user to the appropriate Web Services security role based on the roles assigned during the BP role assignment
Adding Users (the smart way)
  • Open the Security Sync Tool
  • Provide a name for the sync rule (MBF Admin to Sharepoint Admin)
  • Select Source (Business Portal - MBF), Company (all), Role (administrator)
  • Choose the same for the destination - Destination (Web Services)

Example:

Rule 1 -  MBF Sales Manager => Sharepoint Sales Manager

Rule 2 - MBF Sls Mgr => Business Framework (Web Services) Sls Mgr

Rule 3 - MBF Sls Mgr => ??????

!! - Rules are stored as an XML document that can be re-used.

Why use separate rule sets rather than multiple set.

If adding users in multiple locations, can cause security risks where users accidentally get added to groups they shouldn't be when added at a single location. Create mapping file for MBF => Business Framework and a separate mapping for Business Framework => MBF

Even after all the synchronization above, users need to be connected to their Back Office ID (employee record) in Advanced Roles

Implementation Methodology

There is a HUGE difference between installing Business Portal and implementing Business Portal.

Discovering what the customer needs added to and also what needs to be removed from BP is as important as installing it. Customization turns BP from a product that is feature rich but never used to a business critical tool.

Creating a new page
  • Site Actions / Create / Business Portal Web Part Page
  • Copy page URL in order to add to Navigation
  • Site Settings / Navigation
  • Add URL to page into site navigation
  • Browse to page
  • Add Business Portal web part (primary publishing list - 1)
    • Configure - create new query
  • Add BP web part (Rich List Result Viewer - 2)
    • Configure - create new query
  • Add publishing information to 1
  • Add subscription information to 2
  • Edit object 2, subscribe to object 1 to establish the link

 

Bring BI to life with MS Dynamics GP 10

Christina Phillips (Geyer), MCT, MCBSP - christinag@theknastergroup.com

Excel Report Builder, SQL Reporting Services, Excel Links in GP

Business Intelligence - The right information, to the right people, at the right time in the right format.

Data (86,000 line spreadsheet) vs Information (Pie Chart summary)

BI Infrastructure Hierarchy

  • Infrastructure: SQL Server
  • IT Tools: SQL IS / AS / RS
  • End User Tools: Sharepoint / Excel
  • Performance Management: Scorcarding, Analytics and Planning, Business Scorecard Manager, ProClarity, PerformancePoint Server

BI with Dynamics GP

  • Office
    • Excel Reports and Data Connections
      • Data Connections access data from GP via Excel
      • ~295 available
      • Put DC on network share so that users can get to them
    • Excel Report Builder (Bundled with SmartList Builder)
  • SQL Server
    • SQL Reporting Services Wizard
    • SQL 2008 Report Designer
  • MOSS
    • Dashboards

After June 2 - Smartlist builder pricing will go up.

Setting up Excel Reports
  • Establish a shared location for reports
  • Set permissions on folder
  • GP / Tools / Setup / Reporting Tools Setup
  • Enter paths, enable and deploy Data Connections for all companies
    • System level reports are deployed when running the utility
    • User level - nothing gets deployed automatically. Store your custom reports there. Use %username% wildcard to specify user-id named folder
  • Run Deployment
  • Do the same for the Reports Library
  • Deploys ODC files and generic Excel Reports
  • Launch Excel Reports (Admin / Other Reports / Excel Reports)
  • Excel accesses data directly - NOT an export of static data
  • Set security (in SQL) by adding to rpt_... roles in SQL
Build a New Report
  • Launch Excel
  • Data tab
  • Existing Connections
  • Browse to ODC location, choose one
  • Build report
  • Refresh the data connection
Excel Report Builder
  • Bundled with Smartlist Builder (Feature Pack 2)
  • Analyze real-time data
  • Connect to any GP or SQL table
  • Add calculated fields, restrictions
  • Publish to file, sharepoint or reports library
Building an Excel Report through Report Builder
  • Tools / Smartlist Builder / Excel Reports Builder
  • Build report
  • Pull in 1st table
  • Pull in additional tables (if needed)
  • Establish relationship between the tables if needed
  • Expand field options to clean up data returned (such as positive / negate $$ amounts for credits or 'friendly names' for document types)
  • Add any calculated field (such as Days Past Due)
    • Use DateDiff function
  • Add summary page if desired
  • Publish

SQL Reporting Services

Available to anyone who has full SQL

Over  60 Reports available

Source files for existing reports available on PartnerSource

Deployment of reports on takes several minutes

All SQL Reports can be exported (XML, CSV, PDF, Excel, Tiff, Word)

Make sure to run the reporting tools setup for SQL reporting services in Dynamics GP (See above for Excel Report publishing)

SQL Report Layout and Design

Model - set of parameters used in a report (tables, links, etc)

Components:

  • Report Designer
  • Report Builder
  • Model Designer
  • Report Manager

Planning a report

  1. Review existing reports
  2. Plan the repot layout
  3. Determine tables
  4. Determine data source
  5. Determine SQL statement or stored procedure (stored proc may be more efficient)
  6. Identify grouping
  7. Determine filtering, sorting
  8. Determine calculated fields, aggregate fields
  9. Create and save report
  10. Deploy the report, set security

Creating a new SQL Report

  • Open Report Designer
  • New Report
  • Set Data Source by clicking link on report
  • Build query in query designer
  • Query brings in fields available to the report
  • Insert report object (table, matrix, chart, gauge, list)
  • Format and publish the report

New Features in SQL 2008 Reporting Svcs

  • Enhanced report designer
  • Tablix data format (multiple groupings on the same row)
  • Report output to word
  • Integrated mode with MOSS
  • Enhanced charts and gauges

Best Practices for Designing Dashboards

  • Dashboard audience
    • Who, what, how
  • Plan components
    • Libraries, lists
    • Business Data Catalog types
    • Key Performance Indicators
    • Excel Reports, SQL Reports
  • Capitalize on the efficiencies of MOSS

Ending Session - Preview of GP 11

  • GP 10 Feature Pack
    • Rapid Install, Data Migration and Configuration
    • BI (PPS Integration)
    • Excel Report Builder
    • Project and Field Service Features
  • GP 11 TAP
    • Live Customers
    • Longest GP Beta period ever
    • ISV drops throughout
  • v10 was focused around the technology platforms. Now that this has been accomplished, version 11 will be highly focused on internal functionality. Release date is planned for 2010.
  • Vendor Approval and action based Workflow steps, not just approval only
  • New hierarchy feature in Office 14
  • Vendor Portal !
  • Contact - Chad Sogge (Security conversation)

Q & A

Now that Project Green is dead, what comes after 2013?

Releases are going to continue, integration of other products will continue, particularly products in the next 2 years. Plan on GP v12.

 

What is being done to scale GP to compete with such as PeopleSoft?

PeopleSoft is a hot market. PS customers are jumping ship and there are huge opportunities out there.

Focusing on payroll and HR to match up with PS functionality. Recent benchmarks of 50,000 payroll checks and 20,000 W2 forms. Continuing to expand SQL clustering capabilities.

140 customers over a $$ Billion in revenue

Many customers are moving up-market, many partners are following. This feature pack is focused back at the small market, next focus will be up-market.

 

Will capability be added to Dexterity for some of the new reporting features?

We don't know yet, don't have an answer as to timeline.

 

Will there be a release of source code for DEX?

Probably not going to happen.

 

Portal products coming up. Customer and Vendor Portals. What is the direction on convergence/ divergence of portal products?

Sharepoint is the first place we look at for new development. Homepage in Dex will have the same components in 11.

Graphing and data presentation will be componentized where it can be built once and deployed across many locations - homepage, bp and other portals.

There will not be a single drop and replace of the interface to take advantage of new functionality. This will happen over time.

There are 40,000 customers on GP. We will not take away big blocks of functionality. Implementing BP and Sharepoint today will not be a wasted effort when the next version arrives. It will be added and extended, not replaced.

 

Any plans for supporting products on 64-bit platforms?

GP 11 is planned to be 64-bit compatible, NOT OPTIMIZED for 64 for ALL components (includes BP?)

Wednesday, May 28, 2008

GP Technical Airlift Notes - Day 1 - GP11 ?

Keynote tidbits

Direction

  • Product will be increasingly 'role-based', mapping the product to actual business processes.
  • Product will be integrated more tightly with Office product line.
  • Product design will be handled through Visual Studio. Standardized customization means increased supportability.

Add and extend:

  • Role based => Enhanced user experience
  • Portals and worflow => process-centric design
  • BI => ad hoc, self service informationg athering
  • web service => simplified / standardized accessibility

Direction

(A) Check out "Statement of Direction"

MS will spend $7B in R&D this year

GP looking to increase value to customers who subscribe to Enhancements by releasing Feature Packs between product releases. Next Feature Pack will be a step-in to GP 11, which will be built around Office 14.

16,000 QuickBooks customers last year moved from QuickBooks Pro to QuickBooks Enterprise. They should be GP customers. GP will begin aggressively marketing to QB customers.

New VPC is out.

Feature Pack Features

  • Excel report builder - Additional data sources available. Preview columns before export. Add restrictions and calculations. Summarize a Excel Report for multiple companies into a single workbook.
  • Forcasting enhancements
  • Reporting
    • Personal BI - Report Writer, Excel Reports, Smartlists
    • Team BI - Excel Services, SQL Reporting Services, Sharepoint
    • Org BI - PerformancePoint Server, FRx
    • (A) - Check on PerformancePoint

Scope

(A) Check out Pinnacle Award winner stories to find out what cutting edge solutions are being done.

Demos

Upgrade to GP from QuickBooks. Old vs New

!! - GP 10 Feature pack includes rapid migration tool which allows you to bring in ALL data (including transactions !) in one single export / import routine.

During migration, all master records can be exported to Excel and vetted before importing into GP.

(20 minute upgrade)

Start a new company from scratch

Demo of Rapid Configuration Tool

Using Excel templates, allows for extremely rapid initial setup. End of setup, brings up list of all errors which link directly to cells in original Excel documents

Shipping 13 templates out of box for verticals.

Rapid Config tool hits ~78 windows and over 1300 Fields during setup.

(20 minute setup)

Fun Moments

Pissed off ISV barely controls his fury that his product feature will be built into GP 11 as a native feature - almost blowing his NDA.

MOSS Implementation

Eric Gjerdevig - egjerdevig@summitgroupsoftware.com

Joe Tews - jtews@summitgroupsoftware.com

Business Data Catalog - Map to back-end data that allows that data to be presented in Sharepoint as a list.

Method 1 - Business Data Catalog:

  • Imported into SSP in MOSS Central Admin
  • After Import, create new site. Add new web part Business Data List / Business Data Related List
  • Modify to select source for data for each.
  • After data resolves, Edit, Connections, Get data from...

Method 2 - Excel Web Access:

  • MOSS Central Admin / Operations / Services on Server / enable Excel Calc Services
  • Open SSP page
  • Edit Excel Services Settings
  • Fill in unattended service account
  • Back to SSP / Enter trusted file location
  • Upload Excel doc to MOSS library. Open document and publish to excel services (Office key / publish)
  • Select what items get published
  • Save to publish
  • Open page, add Excel Web Access Web Part
  • Select workbook created

KPI's

Search

Sources:
  • Internal MOSS sites
  • External websites
  • File Shares
  • Line of Business applications
  • Exchange public folders

Workflow

Approval process that defines how documents move through an organization.

  • Consistent processes
  • Automatic notification
  • Accessible through MOSS / Outlook
  • Reporting

Participant Roles:

  • Administrate
  • Manage
  • Originate
  • Approve
  • Delegate
  • Carbon Copy

Customizing Workflow

Christina Phillips - christinag@theknastergroup.com

Tim Oines - tim.oines@microsoft.com

General Notes
  • Requires MOSS
  • MDW MOSS Site
  • Documents originate in GP (NOT like requisition mgt in Business Portal where documents originate outside of the system)
  • Approvals via GP, Outlook or MOSS
  • Flexible approval structure
    • Multiple approvers
    • Routing based on document criteria
  • Workflow SDK now available on partnersource
    • Integration Guide
    • Web Service Reference
    • 2 Samples (new + extending)
  • Creates SQL role DYNWORKFLOWGRP to allow security via MOSS site. However, authentication happens via WSS Timer Service account

Terms

  • Workflow Contract - Definition of the workflow. What components are available.
  • Workflow Contract Registration - registration of assemblies with the GAC
  • Workflow events - events that occur which need to be acted upon
  • Dynamics Security Store - stores web services permissions for operations and tasks using auth mgr tool
  • Form Controller - responds to gp client events, manages communications with web services, adds message bars, controls and history bar to dynamics window
  • Form Factory - .NET code that runs before dexterity windows are opened to determined whether information is affected by a workflow
Out of the Box Workflows (6)
  • Batch Approvals
    • GL
    • Payables M
    • Rreceivables Mgt
  • Sales Order Processing
    • Credit Limit Override
    • Quote Approval
  • Purchase Order Processing
    • Purchase Order Approval
Beyond Out of the Box
  • Create a new workflow
    • Payables Check Approval
    • Sales Credit Memo Approval
  • Extend existing
    • Add custom fields to standard workflow
    • Integrate 3rd party products
Building a new workflow
  1. Make app dictionary changes
  2. Install data and config changes
  3. Add workflow columns to database
  4. Add a web service
  5. Create a client workflow assembly
  6. Create a server workflow assembly
  7. Create a document viewer
  8. Update the Dynamics Security Service
  9. Update Microsoft SQL Server Security
  10. Deploy the Server Workflow Assembly
  11. Deploy the Web Service
  12. Deploy the Client Workflow Assembly

Business Intelligence

  • Jennifer Harwood, Microsoft
  • Brian Meier, Microsoft
  • Gary Tronson, Microsoft
Excel Report Builder
  • Users create or modify data connections and refreshable excel based reports
  • Combine data from multiple companies into a single workbook
  • Allow publishing to MOSS or other network locations

Setup:

  • Install Smartlist Builder
  • Tools / Smartlist Builder / Refresh Cache
  • Grant Security to tables, views. Tools / Smartlist Builder / Security
    • Update cache every time new views are created and assign security, otherwise they will not be exposed to SLB
    • Tools / Setup / System / Security Tasks / SLB window
  • Open Excel Report Builder
  • Begin building your report
  • If you publish the report, grant security to the report wherever you publish it.
  • If you can see the report, but get errors about access - grant access for the data connection in SQL. SQL Mgt Studio / Security / Logins / Make sure the user's Windows account has rights to the databases.
SQL Reporting Services (Jennifer)

Partnersource / Product Releases / Download reports that can be opened in Visual Studio for exploration or modification

Make sure to rename reports if modifying existing reports so that they are not overwritten by service packs or upgrades

Model - a diagram of data that includes tables and views which is used as the foundation of the report. automatically creates aggregates of data (date becomes day, week, month, etc.)

Rest of presentation canceled due to trying to run the demo via Terminal Services over a wifi connection that was anemic.

Integrating BI into Dynamics GP

Demo - create a list in purchasing using Business Data as the source to pull in vendor list and purchase order list. list tracks purchasing disputes. then build a kpi that tracks the number of disputes to show red/yellow/green.

Thursday, March 27, 2008

Windows Live Accounts in Sharepoint

Hold your hands up, everyone. Now put them down if you've never used a browser. OK, lost one.

Now, put them down if you've never used a browser to access a Sharepoint site. Wow, lost a lot there.

M'kay, now put them down if you've ever built or administered a sharepoint site. Anyone left? Oh, there's a few in the corner.

Now, put them down if you've never thought - "Gee, I wish I could authenticate users on my Sharepoint site without having to give them an account on my domain". Where'd the hands go. Woohoo, still got one. This article is for you - yes, you in the shirt.

Codeplex.com now has, in the Community Kit for SharePoint, a Windows Live Authentication feature that you can install and enable the use of Windows Live ID's to your sharepoint site. Kinda cool, huh?

CKS_logo

Link here.

Tuesday, March 25, 2008

Customizing Instant Search in Vista

Instant search is the new search field in the Start menu in Vista. It allows you to hit the Windows key on your keyboard and immediately start typing. As you type, Instant Search begins to filter through items on the start menu and any other indexed locations such as email and your My Documents folder to find related items.

VistaSearch 

Did you know, however, that you can add additional search locations to the search results. For instance, I use Wikipedia frequently to get quick information about topics. I'd like to add that to my search results window.

  • Press Windows Key + R and type gpedit.msc. Click OK to open the local Group Policy Editor on your Vista machine.
  • Open the User Configuration\Administrative Templates\Windows Components\Instant Search\Custom Instant Search Internet Search provider policy setting
  • Enable the policy setting, type Search Wikipedia in the first textbox and http://en.wikipedia.org/wiki/%w in the second textbox, and click OK
  • Open a command prompt and type gpupdate/force to immediately apply the new policy setting.

Now, when you click the start button and search for Crazy Frog you'll have a new search option immediately above the search box

Search Everywhere

Search the Internet

Search Wikipedia

Happy searching!

...summarized from ITworld.com

Wednesday, March 19, 2008

Wireless Internet using my Cellphone

Think your phone is good for nothing more than making calls and sending text message? Well think again. There's a whole world of capabilities out there that can really kick your "inner geek" up a notch.

Just today, I setup my cellphone to act like a modem for my laptop - no wires required!

I've got the Cingular (now AT&T) 8125. A decent device (crappy phone) but it has all of the 'extras' I need like wireless internet, wifi and bluetooth.

Here's how I accomplished it -

Turn on bluetooth on the 8125 and set it to discoverable mode. Turn on bluetooth on your laptop and pair with the phone. You'll end up with a bluetooth modem available.

Open your network connections and create a new dialup connection using the bluetooth modem.

IMPORTANT: Use phone number *99#

Anything else will cause the call to fail. Type in the username of ISPDA@CINGULARGPRS.COM and CINGULAR1 for the password. If the first username does not work, try WAP@CINGULARGPRS.COM which means your phone is using the WAP gateway at AT&T to connect to the Internet.

IMPORTANT: Don't use the Cingular (or AT&T) Communication Manager to setup the connection. It sets the phone number to *99****1# and sets the Advanced Command string to AT+CDG. Both will cause the tethering to fail.

Now, the connection is not blazing fast, but it's way better than being stuck somewhere with no internet connection. Also, you can perform the above procedure with your phone plugged into the laptop via USB which will keep the phone charged while you're off updating your facebook status. This post was uploaded using the tethered connection and it was plenty fast.

Here's the result of my speed test. As you can see, not blazing. But then the 8125 I'm running is on the old GPRS connection, not the newer faster 3G lines.

There you go, happy surfing!

Friday, March 14, 2008

SPS Designer Class Notes and Links - Friday

Links -

www.ontolica.com - SPS search web parts for wildcard searches
www.dotnetfranco.com - Classmate who specialized in .NET coding (C#)
blogs.msdn.com/ecm/ - Enterprise content management team blog

Thursday, March 13, 2008

SPS Designer Class Notes and Links - Thursday

More useful notes and links from the SPS Designer class in Atlanta...

Infopath and forms

- form is a CAB file with an .XSN extension - Trust levels - Restricted - Domain - Full Trust


- To create forms, Infopath must be installed in designer mode.
- There is a framework from MS for importing Word and Excel documents
- To run forms services, enable both Office SharePoint Server Standard Site features and Office SharePoint Server Enterprise Site features in Site Features. Then, enable the same features under Site Collection Features.

- To force forms to be edited in browser, Advanced settings in the library, display as web page.

- If a form is going to be used in multiple locations, publish it as a content type. Then, when the form is updated, all locations where the form is used will also be updated.

Workflow

- Automates business processes

- Waits until something happens then proceeds to next step - Build on windows workflow foundation
- WF Program (template and forms)

- Installed as a feature into farm

- Workflow instance

- Activities

- .NET Framework Community Workflow site

http://netfx3.com/content/WFHome.aspx

- Microsoft Windows Workflow Foundation Step by Step by Kenn Scribner

- Shelton Blog - Workflow documents and videos

http://sheltonblog.com/

- El Blanco's Office 2007 Blog

http://chrissyblanco.blogspot.com/

- MOSS provides pre-built infrastructure for workflow. Possible with WSS but very difficult, have to build the infrastructure from scratch.

- Workflow templates (built from scratch) are deployed as features

- In Visual Studio (CTRL-K-B) to bring up snippets for sharepoint

- c:\program files\visual studio 8\xml\1033\snippets\sharepoint server workflow\snippets



Wednesday, March 12, 2008

Sharepoint Roll-Up Web Parts

www.bamboosolutions.com

This developer creates web parts for Sharepoint. Some of the more useful parts available include List and Calendar rollup web parts that allow you to display results from sub-sites in a single list.

For example, in the Clients site, a list of all open issues is displayed for all child individual sites.

Useful stuff!

Thursday, February 14, 2008

Need to find out if a file is infected by a virus?

Sometimes, you'll find your system acting a little weird. Maybe you've found a service running that you don't recognize. Your virus-scan engine reports and all clear, but you've still got that nagging suspicion.

Why not let 21 different virus engines take a look. Upload your file to Virusscan.jotti.org and let the experts take a peak.

Getting scanned by 21 different programs will either give you peace of mind regarding your system or let you know for sure that it's time for a cleanup.

Jotti can be busy sometimes. If so, here are a few alternates:

Happy Hunting!

Wednesday, October 24, 2007

Notes from Partner Briefing in Cincinnati

Introduction of Patrick Cook - New Area Sales Manager for Dynamics (patrickc@microsoft.com)

Intro

  • 60% of users workday spent looking for and retrieving data
  • GP 10 is a Technology release. Rewriting the app to take advantage of .NET, MOSS, etc.
  • GP 11 will be a feature release. Over 500 new features planned for GP 11.

Dynamics GP 10 Overview

  • Workflow
    • Users of workflow do not have to be GP users
    • When installed, adds workflow options directly into the GP client
    • User 1 enters PO into GP and submits for approval
    • User 2 is not a GP user, but authorized to approve PO's.
    • User2 receives an email from the workflow process. She can edit the task, which pulls up an approval form published by MOSS.
      • Approve
      • Reject
      • Delegate
      • Request Change
      • Cancel
    • Passes the task on up the line. User 3 loads MOSS and pulls up his workflow site. Opens the task and provides final approval.
      • Purchasing
      • A/P
      • GL
      • AR
      • Quote
      • Credit Limit Override
    • Workflow can have logic requirements for only when something matches your requirement (only over a $$ amount, etc.)
    • Built on Windows Workflow Foundation
    • Additional workflow can be written using .NET
  • Excel Reports
    • Live connections (2 way?) to Dynamics GP
    • Uses Office Data Connection (ODC) to connect
    • Launch
      • Administration
      • Other Reports
      • Excel Reports
    • Not yet able to publish the resulting report out to Excel Services on MOSS (known issue under development)
    • Can be published if using Analysis Services
      • Build an analysis cube that contains the information
      • Build an Excel spreadsheet that links to the analysis cube
      • Publish the excel doc into Excel Services
      • Add the Excel Web Access web part to the page where you want the data displayed
  • Action Panes and lists
    • Similar to ribbon in Office
    • Context sensitive action toolbar
    • Allow the user to process transactions (put a group of customers on hold)

Microsoft Office Sharepoint Server (MOSS)

  • Excel Services
    • Publish Excel spreadsheets in a web page (no excel required on the desktop)

Dynamics CRM Preview

  • Scheduled release date Jan-Mar
  • Major changes
    • Switching to Windows Workflow Foundation
    • Multi-Tenancy - Multiple copies of CRM on same server
    • Better language support / currency for multi-national companies
    • 3 Deployment options
      • On premises
      • CRM Live - Hosted at Microsoft
        • 1-2 users, don't want to buy equipment to host internally
      • Partner Hosted
    • Multi-Currency
  • Any customizations written within the SDK should port fine from 3.0 - 4.0
  • All functions (except some administrative) can be run within Outlook
  • Sales
    • Leads, Opportunities, Contacts and Accounts
    • Customization demo - Predictive Lead Rating powered by Analysis Services (Solution Accelerator)
  • Service
    • Satisfaction scorecard demo using Performance Point Server
  • Marketing

Partner Briefing

  • Introductions
  • Brad Rosen new Microsoft Partner Community Manager
  • Chet Kloss - Acting General Manager, Sales Manager, Depth Area Sales Manager (ASM)
  • Liz Siver - Market Development ASM
  • Patrick Cooks - Dynamics ASM
    • Dan Kocon - PAM KY / TN
    • Jeff Lowe Dynamics PAM for KY / TN
    • Bryan Huddleston - IW SS KY / TN
    • Mike McKinley ERP SEM KY / TN
    • Lynne Sternesky - Platform ASR KY / TN
    • Todd Smith - Dynamics ASR KY / TN

  • Patric Cook ASM for Dynamics
  • Sarah Knutson ASM Dynamics NEW
  • ???? ASM Dynamics EXISTING
  • Growth
    • #1 Growth for MBS ERP - North Central
    • #2 NY Metro
    • #3 Midwest
    • #4 Southwest
    • #5 Northwest
    • #6 Heartland
    • #7 South Central
  • Product Release path
    • Silverlight
    • Office Comm server 2007
    • Windows Server 2008
    • Visual Studio 2008
    • SQL Server 2008
  • MS Heartland Priorities
    • Server Launch
    • Unified Communications
    • Collaboration
    • Dynamics CRM
    • Partner Readiness Events (Core IO)
    • Partner to Partner
  • Of Large Customers, those with Dynamics have largest revenue per organization. (316 of 2500 customers)
  • Unified Communications (UC) great growth over 5 years. (Office of 2010)
  • Ed Blackman moving to new role. Need new ERP SEM for Ohio
  • Heartland - ERP highest revenue opportunity ($23 million 2007 / $26m in 2008)
  • Collaboration biggest gap - $19m 2007 with projected of $23m in 2008
  • "remove obstacles to success" goal for maximizing partner relationships
  • Brett Wolf - PAM for platform. Based in CIN
  • Dynamic IT
    • Unified and virtualized
      • more flexible
      • strengthen business continuity
      • able to scale
    • Process-led / model driven
    • service enabled
    • user focused
  • Infrastructure Optimization
    • Basic
      • uncoordinated, manual infrastructure
        • no policies for security or compliance
        • don't know health of services
        • no way to share information
        • hard to control environments
        • reactive to security threats
        • high touch deployments of software, patches and services
    • Standardized
      • managed infrastructure / limited automation
        • AD used to manage resources, security
        • basic standards and policies not fully implemented
        • deployment of patches / desktop svcs provided with medium touch
        • inventory of hw and sw assets managed
    • Rationalized
      • managed and consolidated infastructure with max automation
        • security proactive
        • zero-touch deployment
        • minimal desktop images and low-touch mgt
        • hw and sw inventory managed with license optimization
        • strict policies on usage and security
    • Dynamic
      • fully automated management, dynamic resource usage, business linked SLAs
        • costs fully controlled
        • users/ data; servers / desktop fully integrated
        • high level of features for mobile users
        • fully automated processes, integrated into technology
        • able to measure investments in tech
        • self-provisioning software and quarantine systems automate processes
  • Components of Core Infrastructure
    • Identity and Access Management
    • Desktop, Server and Device Management
    • Security and Networking
    • Data Protection and Recovery
    • IT and Security Process

Business Productivity Infrastructure Optimization

  • TerryS@microsoft.com
  • Thursday November 29th training day
  • November 6th - session on selling Unified Communications (UC)
  • Capabilities
    • UC
      • integrating email, faxes and voicemail
      • presence information for co-workers
    • Collaboration
      • basic = file sharing
      • dynamics = federation (sharing outside org),
    • Enterprise Content Management
      • basic = forms and templates that have to be manually entered
      • dynamic = combining data sources across the enterprise
    • Enterprise Search
      • basic = static websites, static information
      • dynamic = single search across multiple data sources,
    • Business Intelligence
      • basic = running paper reports
      • dynamic = published reporting, with dynamics filters running against live data
  • BI - Improve Business Insight
    • Integrate disparate business systems
      • data mining and reporting
      • LOB data and XML / WS / RSS
    • analysis
      • Native excel support for SQL Server analysis svcs
      • Integrate with office apps
      • Business data catalog
    • empower descisions
      • BI portal with integrated search
      • server based excel spreadsheets and calculations
      • flexible kpi's
  • Enterprise Search
    • connect to wide information sources
      • Business data catalog - add LOB systems to search
    • identify people with knowledge and experience
      • people search results grouped by social distance
      • auto-populated personal profiles
      • my-site portals
    • manage and security search solutions
      • relevence tuning using authoritative sites
      • out-of the box reporting and analytics
      • customizable query-time security trimming
    • All tied to desktop experience with Vista / Office 2007

Links

https://partner.microsoft.com/us/40047046 - Central Region Partner Awards

  • VAR open growth
  • small business transformation
  • compete to win
  • partnering to succeed
  • marketing excellence
  • customer experience
  • GM award

Heartland Area Partner Newsletter - hlapc@microsoft.com

https://partner.microsoft.com/40013533 - Central region monthly call information

https://partner.microsoft.com/us/heartland - Heartland Region Home Page

crrenew@microsoft.com - get list of all Open renewals among customer base.

www.microsoftincentives.com - current incentive list

www.microsoftfinancing.com - SmartPay Financing

www.playsmarterit.com - finance and win an smart car

www.microsoft.com/sam - software asset management

www.drivesam.com - free coffee and get your license statement

gregg.mccrabb@microsoft.com - SAM engagement manager

Action / Additional Notes

  • Get the non-timebombing VPC for CRM from Chad
  • Check out Enterprise CAL (eCal)
  • Check out benefits of federating (IM, presence information, calendar viewing) with ms counterparts
  • Exchange 2007 for Live Comm / Unified Comm

Thursday, October 18, 2007

The Road to Know Where: Ultimate List of Free Windows Software from Microsoft

Microsoft has over 150 FREE Windows & Office Programs available for download -- finding them all is extremely difficult . . . until now.

The Road to Know Where: Ultimate List of Free Windows Software from Microsoft

Great resource of links from Blake Handler