This blog is about SharePoint, Office365 and Office Development

Popular Posts

Hide Action Menu in Business Data List Webpart

To hide the action menu there is an OOTB option in the Business Data List Webpart , but it hides the Paging controls as well , so how to hide the action menus and keep the paging controls
The first thing pumps to your head is to do so you should alter the xslt used by the webpart , and simply remove the first td in the below place holder

  <asp:PlaceHolder id="ActionBarTable" runat="server">
        <table class="ms-menutoolbar" cellpadding="2" cellspacing="0" border="0" width="100%">
           <b> <td class="ms-toolbar" style="padding-left:3px;text-align:left" nowrap="true">
              <xsl:value-of select="$ActionsText" />
            <td class="ms-toolbar" style="padding-right:3px;text-align:right" nowrap="true">
              <xsl:value-of select="$EditViewText" />

but the action menu keep appearing , so I think of a client side script to hide the action menu

by using the Content Editor WebPart and injecting the below script

<script type='text/javascript' src='valid url of latest jquery'></script>
<script type='text/javascript'>
$(document).ready(function() {
  $("table [class='ms-menutoolbar'] tbody tr td:first-child").hide();

the last thing to do is to ensure that animation is set to off in the webpart Options as if the animation is enabled the JavaScript function will called before even the action menu rendered

Image carousel webpart Sanboxed


In order to create a slider /image carousel webpart you have 2 options
Use content By Query Web Part
1-be sure that the publishing infrastructure feature is activated in your site collection
2-Add a New Content Query Webpart as below

3- Export the webpart you will prompt to download file named "Content Query.webpart"

4-Save the file as Content Query Nivo.webpart in this step you can open the file using any text editor and change the webpart name
5-Content query webpart uses XSL files to transform the xml result set to predefined html the OOTB xsl files are
  • ContentQueryMain.xsl
  • Header.xsl
  • ItemStyle.xsl

these file can be found under the Style Library/XSL Style Sheets as shown

you can alter any of these files to get the html markup you are looking for but it's recommended to create a copy before changing the file
The Html markup of the Carousel in this post I'm going to use a famous image slider called nivo , the css and js files can be downloaded via Nivo Slider Home Page
the desired markup is

to be able to create this html markup using the sharePoint designer copy the file ContentQueryMain.xsl and save it as nivoCQWP.xslt
locate the Outer template and update the xsl to be as below insert the highlighted lines

to complete the markup locate the OuterTemplate.Body and update the template as below

the last step you need to execute is to add the nivo directory to the site collection Style Library using SharePoint Designer Import Folder

Now to use the new customized Content Query webpart you need to upload the webpart if you have a quick look on the first snapshot you will find upload webpart in the left bottom portion of the dialog use it to upload your custom webpart

now you can use your custom CQWB , set the query parameters to load Images from Asset Library ->Image Content Types

the second option is to create a webpart from scratch this will be posted later

Add Item to External List using Site Workflow


when trying to add new item to external list while running a site workflow a strange error appears
"Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack"
and the sharePoint Redirects me to access denied page
I tried to execute the below steps to figure it out
1- check the current user and BSC permissions :

as you can see the user already been granted full permission
2- check the External Content Type Authentication mode

the current user identity is selected
3- I checked the SQL server Login and Also the user amr-pc/amr got a valid login to the target database
after a while I recall that BSC used the Service account to connect to External List
In order to achieve that
First we create a Secure Store Service
central administration->Manage Service Applications->Manage Secure Store Service
Application and select manage
before adding new Secure Store service Target application you will have to provide a Key if it's the first time

afterwards you can create your Secure Store target application
1- set the application ID

In the last step sepcify the target application administrators and members be sure to add all authenticated users to the secure store target application

after creating the target application select the created application and choose the Set Credentials button from ribbon

Type the target user which will be used to access the remote SQL server database
go to the sharePoint designer and Edit the External Content Type authentication to be Impersonate windows account add the localhostServices "or the application ID you entered while creating the target applicatoin "as the application id in both default and client tab

back to the web browser as you can see below the external list contains 0 items

navigate back to the site workflow and use the initiation form to create an external list Item
Enter the following data First Name: Amr
Last Name: Fouad
Title : SharePoint Developer
press create

now navigate back to the external list you will find the newly created record

and that's it Vola! you can now access the external list within the site workflow