Tuesday, November 4, 2008

SharePoint SSRS Manage Menus

Issue:
After uploading a Reporting Services Report to a SharePoint site, clicking on the drop down next to the report to bring up Manage Data Sources, Manage Subscriptions, Manage Paramters and Manage Process Options returned the following error:
The resource object with classname of “ReportServer” and key of “DataSourceList” was not found. DataSourceList was replaced with either SubscriptionList, ParameterList or ProcessingList dependent on which menu was selected.

The environment is setup with Two Front End Web Servers and One Central Application SharePoint server.

Answer:
It turns out that it had to do with the Web Front End servers not configured the same as the Central SharePoint server and this is what was causing the error.

The following are the steps that were done to get the menus the work as intended:
It turns out the ReportServer.resx was missing on the two front ends. In IIS on the Web Front Ends, navigate to WebsitesDefault Web SiteApp_GlobalResources and paste a copy of ReportServer.resx which was found in the InetPub folder tree.

The ReportServer.resx is the resource object XML file that has sections for DataSourceList, ParameterList, SubscriptionList, etc., which would explain the error we saw if the file was missing.

In the event that you run into this in the future, checking the Web Front End servers as well as the Central Admin server and ensuring that the files are in synch is a good troubleshooting tactic to solve any strange behavior.

Radio, Cell phone and Television most owned ICT assets

Brenda Zulu

The Central Statistics Office (CSO) 2006 Living Conditions Monitoring Survey (LCMS IV) results in Zambia indicate that the most owned assets were the radio at 55.6 percent, Cell phones at 24.2 percent and Television at 24 .1 percent while the least owned asset was the internet connection with 0.1 percent.

The CSO June monthly publications shows that the 2006 LCMS IV collected information on information communication and technology (ICTs) facilities which included radios, televisions, video player, land phone, cellular phone, satellite dish and decoder, computer and internet connection.

Analysis by rural and urban shows that, ownership of a radio, cell phone and television was more in urban areas that in rural areas. The proportion of households that owned a radio in urban areas was 65.8 percent compared to 50.1 percent in rural areas while that of those who owned a cell phone was 53 and 8.8 percent in urban and rural areas respectively. The proportion of households that owned a television was 54.6 percent in urban areas compared to 7.8 percent in rural areas.

The survey also revealed that there has been an increase in the proportion of households that own cell phone while those that owned land telephone lines declined. The proportion of household that own a cell phone increased from 10.8 percent in 2004 to 24.2 percent in 2006. The proportion of household that own land telephone line declined from 5.2 percent to 1.2 percent during the same period.

Analysis of ICT assets by sex of household head shows that male headed household own more ICT facilities that female headed households. About 62 percent of male headed households and 35.5 percent of female headed households own a radio. The results also indicate that 26% male headed household owned a cell phone than 18.4 percent female headed households.

Digital Asset Management with MediaBin

Interwoven MediaBin helps companies to deliver a more solid customer experience by effectively managing, distributing, and publishing the thousands of customer-facing digital assets used to their promote products and brands.
MediaBin is a leader in Digital Asset Management (DAM) solution sphere. It lets marketing teams give their global sales force and business companions instant, self-service access to current, approved marketing content â€" including pictures, photos, logos, presentations, CAD drawings, marketing collateral, audio, video, and others.
MediaBin speeds the delivery of brand-correct, current marketing content so that internal departments and external partners can get what they needâ€"when they need it. Marketers can speed time-to-market for marketing campaigns, product launches, and other marketing initiatives. And the more quickly sales people can get what they need, the faster they can sell and increase top-line income.
MediaBin helps organizations raise control of their brands by providing easy access to the most up-to-date, brand-approved marketing materials. Marketing and brand managers choose which content to make available to internal employees and external partners, thereby protecting and controlling the brand more carefully.
MediaBin reduces costs associated with manual processes by automating the production and distribution of marketing content. By providing constituents with self-service access, marketing personnel no longer have to spend time fulfilling content requests from the field. For example, Presentation WorkBench makes it possible to assemble custom PowerPoint® presentations in MediaBin, using brand-approved templates. This not only saves the company finances, it also frees marketing staff to work on additional marketing activities to yield further income.

Monday, November 3, 2008

If you are migrating DTS packages to SQL Server 2005 or 2008...

… your options include
1. Saving the DTS packages to the new server and executing them directly.
2. Running DTS Migration Wizard and letting it convert the packages to SSIS packages for control flow invoking DTS components for the data flow.
3. Rewriting DTS packages completely in SSIS.

Neither option guarantees a performance gain. In fact, moving data directly from a source to a destination table without much transformation logic you will likely see similar performance for all the options. So unless you are taking advantage of new features in SSIS, you are better off selecting the option that fits best into your operating procedures.

If you continue using DTS packages on the new server, you will certainly need Microsoft SQL Server 2000 DTS Designer Components. That applies to options 1 and 2. With option 2, the Migration Wizard generates SSIS control flow, but creates an embedded DTS package for every Data Pump, instead of converting it to a Data Flow Task. Option 3 will likely require the most amount of work, and that's where the fun begins!

SCC MediaServer

SCC MediaServer SCC MediaServer is a fully integrated Text, Graphics, PDF Page, Sound, Photo, and Video storage management system, composed of an industry standard SQL relational database and incorporating free-text search technology licensed from Autonomy Corporation. Optional MediaServer modules allow to perform the following:
  • management of assignments and news budgets;
  • automated delivery of content to Web sites and online vendors;
  • hosting of electronic Tearsheets;
  • dynamic integration with Microsoft Word;
  • offsite MediaServer database replication.
Access to the MediaServer database available from a standard Web browser or from the SCC MediaGrid client (for Windows and Macintosh OSX) . The SCC MediaGrid client, which is oriented at super users such as Librarians or Photo Editors, includes many powerful features made to simplify the data enhancing, data manipulation and delivery processes. Files for inclusion in the SCC MediaServer database are simply saved to one or more network folders from where they are automatically inserted and cataloged within the database. Text and preview metadata is extracted automatically during insertion and indexed in real-time for fast full text searching. Files from live wire feeds can be simply directed into one or more of these server folders for automatic insertion into the SCC MediaServer database.

Southern Africa Telecentre Network underway

By Brenda Zulu
Efforts to set up Southern Africa Telecentre Network (SATNET) are underway with the Zambia Association for Advancement of ICTs (ZAA-ICTs) being the lead network for the project.
ZAA-ICT Executive Coordinator, Dean Mulozi said there was need to have this network to help support the information development of rural telecentres. He said they were facilitating the development of the SATNET.
A visit to Chinyunyu Community Multipurpose Telecentre in rural Zambia showed that when a community is involved in the setting up of a Telecentre the people embrace the centre as their own. Set up in 2006, the centre last year installed solar energy and a very small aperture terminal (VSAT) with the help of UNIDO which has enabled farmers to charge their mobile phone barriers and have access to the internet.
It is important that the centre realizes the money that it pays to the Communications Authority of Zambia as regulators fees and also the monthly subscription for the VSAT connection which is a very big challenge as the centre was in a rural location.
Austin Chilala Head of Kasis Agricultural Training Centre said the centre had received a seven acres of land as a donation to the project from Chief Bunda Bunda. The steering committee now plans to put up demonstration plots for the farmers and housing for stuff.
It is clear that Chinyunyu Telecentre does not need to exist in isolation but needs to learn from other telecentres are sustaining themselves which makes initiatives of setting up SATNET relevant.
There is also need of creating an electronic network before creating a physical network as this is very vital now that telecentres are being encouraged to provide internet services to their communities.
So far feedback from Chinyunyu farmers include that fact that they had learnt how to process chili and expand their fish farming activities as they accessed information from Chinyunyu Telecentre.

Radiance Technologies Digital Asset Delivery System

Radiance Technologies is a provider of asset delivery systems (ADS).
In April 2007 Radiance Technologies announced that it was planning to deliver a completely integrated, single platform that combines digital asset management (DAM) with its field-proven digital asset delivery system.
Tom Engdahl, president and CEO of Radiance Technologies, said:
"Radiance becomes an ever more robust and cost-effective delivery infrastructure for any high-value, asset-driven collaborative workflow through this integration with leading digital asset management products.
With this unified platform, customers not only have the ability to manage, transform and format content but they can remove the time-consuming manual tasks of delivering their ever-larger files such as video, audio, and high-resolution images while gaining greater control over distributing those assets.
The first unified digital asset management and delivery solution for immediate implementation will be announced in 2007 through a technology integration and co-marketing partnership agreement between Radiance and a leading digital asset management provider."
Radiance
Technologies will integrate its TrueDelivery asset delivery software with LightBox Live, a set of flexible editing tools that enable collaboration between photographers and videographers and their customers - including print houses and editors and re-touchers at magazines, newspapers and retailers.
Radiance Technologies, in tandem with LightBox Live, virtually automates the process flow from the moment a photo or video image is shot, all the way through post-production and publishing.
Radiance Technologies enables the delivery of those digital assets to creative professionals in the collaborative environment.