Skip to main content

Posts

Infopath unable to connect with SharePoint server

Dear All,  We are facing many time the same issue that infopath is not able to connect with my remote server. I have two development machine where one is connecting with sharepoint correctly while the other one is giving me an unknown error ... Once i drill down i found the one development machine has office 2013 32 bit version that connect with the server with out any problem while the infopath 2013 64 bit giving me the error.. I uninstall 64 bit office and than install 32 bit office on another developer machine and after that it will work I hope it will work with you as well Regards 3art Technology Experts http://www.3art.tech

How to reduce LDF file in sql for sharepoint

Here is the script for job that you need to run for decrease the LDF file /***** Script start*** USE [DB_NAME]; ALTER DATABASE [DB_NAME] SET RECOVERY SIMPLE; CHECKPOINT; DBCC SHRINKFILE ([LOG_FileName], 1); ALTER DATABASE [DB_NAME] SET RECOVERY FULL; /***** Script End*** The above script reduce the log file up to 1,024 KB Note: before doing any activity kindly make the back of each database. Regards 3art Technology Experts http://www.3art.tech

SharePoint calculated column and hyperlink or Link (no workflows or scripts needed)

This is a process how you make the Link column in your sharepoint link original url Create a calculated column which concatenate the url text with an existing column value. This seems to be an easy task, except one thing: SharePoint doest not render hyperlink in calculated column by default. For example, I have a list with 2 columns: Search term and Google Search. Google Search is a calculated column with this formula Now, this is what I will get by default: There are a few ways to fix this problem. Usually people will recommend you to create a Hyperlink column instead and create a workflow to update the Hyperlink value ( http://social.technet.microsoft.com/Forums/ar/sharepoint2010customization/thread/32d32e47-3256-4806-8775-c250b6243038 ) . Or, you can place a script on the page that loop through the HTML nodes and replace the unfriendly html tags with a hyperlink as described here http://practicalsharepoint.blogspot.com/2011/10/dynamic-hyperlinks-in-calculated.html ...

Downgrade SQL from Enterprise to Standard “Database cannot be started in this edition of SQL server” : Restore failed for Server Error in CRM 2011

Dear All If you want to downgrade your database from the enterprise to standard here is the following solution Reference URL: https://ashwaniashwin.wordpress.com/2013/02/28/database-cannot-be-started-in-this-edition-of-sql-server-restore-failed-for-server-error-in-crm-2011/ Hello Everyone, Today while trying to restore the Org_MSCRM Database from production server to one of my testing server, I came across a new Error:“Database ‘Org_MSCRM’ cannot be started in this edition of SQL Server because it contains a partition function ‘AuditPFN’. Only Enterprise edition of SQL Server supports partitioning. Database ‘Org_MSCRM’ cannot be started because some of the database functionality is not available in the current edition of SQL Server. (Microsoft SQL Server, Error: 905)” The error was very clear indeed as my production server was SQL Server Enterprise Edition and testing server was SQL Server Standard Edition. Basically while installing CRM 2011 in Enterprise edition, a par...

How to disable sharepoint mobile website

Dear All If you want to disable SharePoint mobile URL do the add the following code under web.config  <system.web> tag /* code starte */ <browserCaps> <result type="System.Web.Mobile.MobileCapabilities, System.Web.Mobile, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/> <filter>isMobileDevice=false</filter> </browserCaps> /*code end*/ Regards 3art Technology Experts http://www.3art.tech

Create Custom New Edit and Display form for sharepoint list

Reference URL http://blog.karstein-consulting.com/2010/12/29/walkthrough-create-custom-sharepoint-2010-list-form-for-deployment-in-a-visual-studio-2010-project/ Another post http://www.ilikesharepoint.de/2013/11/sharepoint-create-custom-list-forms-with-visual-studio-part-1/ Check out the other solution for 2013  http://www.ilikesharepoint.de/2013/11/sharepoint-create-custom-list-forms-with-visual-studio-part-1/ Walkthrough: Create custom SharePoint 2010 list form for deployment in a Visual Studio 2010 project (This is part 1 of 2. See link below.) Today I want to show you how to create a custom list form for deployment within a custom list template developed in Visual Studio 2010. Download or update or modify my demo code on Codeplex.com: http://spcustomlistformdemo.codeplex.com/ For me I was difficult to figure out this way. I could not find a good documentation about this topic so I’ll write ist – If you found another description please post a link in the comm...

How to forcely run the upgrade on the single farm

PS C:\Users\sp2010farm> psconfig -cmd upgrade -inplace b2b -wait -force Result will be some how like that SharePoint Products Configuration Wizard version 14.0.6009.1000. Copyright (C) M icrosoft Corporation 2010. All rights reserved. Performing configuration task 1 of 4 Initializing SharePoint Products upgrade... Waiting to get a lock to upgrade the farm. Successfully initialized SharePoint Products upgrade. Performing configuration task 2 of 4 Initiating the upgrade sequence... Successfully initiated the upgrade sequence. Performing configuration task 3 of 4 Upgrading SharePoint Products... 100.00% Successfully upgraded SharePoint Products. Performing configuration task 4 of 4 Finalizing the SharePoint Products configuration... Successfully completed the SharePoint Products configuration. Total number of configuration settings run: 4 Total number of successful configuration settings: 4 Total number of unsuccessful configuration settings: 0 Successfully stopped the con...