Start Up Fusion Solr as Non-root User in CentOS 6.6

One of the basic things to do when installing and configuring Lucidworks Fusion 2.x on a single-server using the Solr instance included in the Fusion distribution is getting all Fusion services to start up on their own on a server reboot. Lucidworks included the fundamentals for how to do this in their Fusion 2.1 User Guide, but the …

Continue reading “Start Up Fusion Solr as Non-root User in CentOS 6.6”

Semaphore 4.x ontology model not flushing properly when published

The first ontology I built/published called “Locations” was rough. So, I built/published a better one called “Organizations.” I deleted the first ontology from the Ontology Editor (OE), but my Search Application Framework (SAF) search dialog box seemed to continue autosuggesting old ontology terms found “in Locations” I then realized I was unaware of a way …

Continue reading “Semaphore 4.x ontology model not flushing properly when published”

Lucidworks Fusion 2.1 datasource connector to SQL returns only one document

Fusion 2.1 datasource connector to SQL returns only one document.

Workaround – Display Tableau dashboard in SharePoint web part

When the business needs to view Tableau dashboards or visualizations in SharePoint 2010, the most complete solution is to install the Tableau Server Service Application into the SharePoint farm. But what if it is not installed or supported on the farm? The most obvious workaround is to add a Page Viewer web part to a …

Continue reading “Workaround – Display Tableau dashboard in SharePoint web part”

Remove HTML formatting from SharePoint Rich Text Editor content with JavaScript

Compared with Microsoft Word, SharePoint’s out of the box Rich Text editor seems like a tool from the dark ages. These days, anyone can use Microsoft Word to format content better than the US Mint could 20 years ago, so when it comes to publishing content in SharePoint, most of us follow the path of …

Continue reading “Remove HTML formatting from SharePoint Rich Text Editor content with JavaScript”

Using “Append Text to Query” in Search Core Results

After creating a document library with uniquely named columns, populating the columns with values, and waiting for Search to crawl the library, you set up a Display Group and Scope on the Site Collection Administration Search scopes management page (_layouts/viewscopes.aspx), then add a Search Box and Search Core Results web part to a page and …

Continue reading “Using “Append Text to Query” in Search Core Results”

Open SharePoint List/Library Link in New Window

Why can’t a SharePoint list/library web part open links in a new window by default? Right… maybe someday. There are several workarounds, but here’s one of the “easy” ones that seems to make sense to site owners. It adds some Javascript in an XML Web Part or Form Web Part that’s placed below the list/library …

Continue reading “Open SharePoint List/Library Link in New Window”

Calculated Columns for Cascading Drop-Downs in SharePoint Lists and Libraries

Situation SharePoint list or library users need a simple way to enter data in one column that depends on what was entered in another, but out-of-the-box SharePoint 2007 or 2010 does not support direct cascading functionality. Using jQuery for SharePoint Web Services might be an option for cascading drop-downs, but you are not allowed to …

Continue reading “Calculated Columns for Cascading Drop-Downs in SharePoint Lists and Libraries”

Generate a hierarchical XML file from SharePoint list

Situation You need to get data from a SharePoint 2010 list and generate a hierarchical XML file that can be used as a data source for a Flash movie on a site. Your enterprise SharePoint Admins want their platform to stay as out of the box as possible, and they have good reasons to minimize …

Continue reading “Generate a hierarchical XML file from SharePoint list”

Reporting Services web parts on SharePoint page

Problem Adding Report Builder web parts to SharePoint 2010 made the page colorful and intelligent, but the UI lacked a bit. The parts that took up little horizontal space and lots of vertical space looked kind of goofy; the data abruptly cut off vertically after 11 inches they required a fixed vertical setting at about …

Continue reading “Reporting Services web parts on SharePoint page”

Using HTTP-EQUIV to refresh a page

Consider this scenario. A patient enters a tele-health kiosk, fills out an InfoPath survey and privacy agreement form and clicks a submit button. The form thanks the patient for filling out the info and alerts a nurse to start an interactive session. As the nurse and patient interact in their session, the form automatically brings …

Continue reading “Using HTTP-EQUIV to refresh a page”

Automatically closing a SharePoint 2010 Edit form opened from a Reporting Services web part

SharePoint 2010 Edit and Display forms can be modified with InfoPath. This opportunity comes with a few new bugs, but the UI and functionality can be compelling. It takes a snippet of Javascript, but a Reporting Services web part can open one of these new list or library Edit forms with a GoToURL action. On …

Continue reading “Automatically closing a SharePoint 2010 Edit form opened from a Reporting Services web part”

Access Denied for Visitors on a SharePoint Page with Reporting Services Webpart

If you are working in SharePoint 2010 and discover that users in the Visitors group or All Authenticated Users are unable to open pages that contain a Report Services web part with an Access Denied error… … you might think the issue is related to permissions. Then again, it may just be something quirky about …

Continue reading “Access Denied for Visitors on a SharePoint Page with Reporting Services Webpart”

How to use a URL to launch Report Builder 3.0 and edit a report

Make it easy for SharePoint site owners to edit their custom SSRS reports, by giving them a hyperlink that opens the Report Builder 3.0 application to a specific report. This MSDN article and this Technet article show how the Report Builder application can be opened from a browser. A native mode installation URL would be: …

Continue reading “How to use a URL to launch Report Builder 3.0 and edit a report”

Get the BDC Identity value from a SharePoint 2010 External List to SQL Server

Why bother? Well, because without the BDC Identity value, it is nearly impossible to hyperlink directly to the Edit form of an External List from anywhere on a SharePoint web site. Say you have a Reporting Services web part, and you want to position users just one click away from of changing a value from …

Continue reading “Get the BDC Identity value from a SharePoint 2010 External List to SQL Server”