Wednesday, October 12, 2011

Finding Office Web Apps 2010 for SharePoint 2010

We've been searching everywhere for Microsoft's Office Web Apps 2010 for SharePoint 2010.  After asking a sales rep, we were given the link to Microsoft's VLSC site.  Your organization has to have a volume license agreement before you can enter the site.  Once in the site, go to the Office Professional Plus 2010 with SP1 site, click on the downloads link, then you'll see "Office Web Apps 2010 64-bit English (for SharePoint 2010)."  Also be aware that it uses its own software key, not that of Office 2010 or SharePoint.  Good luck.

Appending data to a list of items in a CSV file via PowerShell

I had a list of local usernames that needed to be appended with the domain name of bc\.  Since I'm learning PowerShell, I thought I'd try to find a solution via PS.  Here is what I did:
1.  Created a CSV file with everyone's name in one column and column header name of Name.
2.  Read up on how to append objects and write the new object out to a file.
3.  Created the script:
       import-csv .\names.csv|foreach -process { out-file -filepath names.txt -append -inputobject ("bc\" + $_.Name)}
4.  The script processes each line of the names.csv column by added bc\ to the existing column object then outputs the data into a new text file named names.txt and places the text file into the same file path as the CSV file.
5.  The result changed a username of BobSmith to BC\BobSmith.