Sunday, 5 November 2017

Are you not able to connect SQL Server on Azure Virtual Machine?

I know that there are plenty of awesome blog posts and articles available out there to troubleshoot this issue and you might have checked most of them before landing to my blog post.


So I am not going to repeat those steps by assuming that you have already checked those steps and still you are not able to connect or access SQL Server on Azure VM via SSMS or your application.


The only step I want you to look at is TCP port setting under SQL Server Configuration Manager.


Go and set your SQL server port number under TCP/IP properties --> IPAll setting as mentioned in above screen-shot and it should fix your problem.

In my case, I tried all the steps mentioned in various blog posts and articles but still I was not able to connect my SQL Server of Azure Virtual Machine via Management Studio. After configuring above setting, I was able to connect successfully. Since I found that this step is not mentioned in most of the nice blog posts, I thought to write quick post on this.

Hope this might help someone.

Tuesday, 8 August 2017

Ways To Integrate Salesforce CRM with Sitecore

May be this is my shortest blog post ever. The purpose of this blog post is to document about the options available to integrate Sitecore with Saleforce CRM.



There are two ways to integrate Salesforce CRM with Sitecore at the time of writing this blog post.

1) Using Salesforce Connect Module 

It is free connector and available on Marketplace.
https://marketplace.sitecore.net/Modules/Salesforce_Connect_Module.aspx


2) Using S4S Connector from FuseIT

It is paid and available at http://www.fuseit.com/Solutions/S4S.aspx


Like others, if you are not sure which one to use then read below blog post from Adam on community portal.

Please read below article before making any choice.
https://community.sitecore.net/technical_blogs/b/getting_to_know_sitecore/posts/introducing-salesforce-connect-for-sitecore

Tuesday, 11 July 2017

Are you facing error "Msdn subscription are restricted from provisioning in this region" while setting up Sitecore XP1 on Azure Paas?

I found that there are lot of blog posts available on internet those helps on how to setup Sitecore XP1 on Azure Paas. But there are very few blog posts which talk about the problems/challanges you face while setting up Sitecore on Azure Paas.



In this blog post series, I am going to share those errors which I encountered while setting up Sitecore XP1 on Azure Paas.

If you are facing error like Msdn subscription are restricted from provisioning in this region while setting up Sitecore on Azure Paas, then this blog post may help you.




Now if you read above error carefully in powershell console, then  you can have a rough idea that it is related with the location/region that you have configured for your Storage Account under Azure.




Yes, the problem is the with location that you have provided in your PowerShell script. The location where you are trying to setup Sitecore may not have capabilities of all Azure featues.  Make sure that you have provided correct location where you have created all your Azure resources and have provision of all the Azure features.


I updated Powershell script and tried with East US location which worked for me.


A long story short, you have to try with the correct location in your Sitecore Azure Powershell script. That's it!

Stay tuned for few more such errors encountered during Sitecore XP1 on Azure Paas setup.

Monday, 10 April 2017

How To Use Sitecore XTM Connector For Language Translation?

Do you have multilingual site? Are you looking for a solution to translate your content into multiple languages say for example 10-15 languages?

My client has the same situation, we have a website in 16 languages and majority of pages needs to be translated into 10 languages on an average.

As there are lots of Sitecore Translation Connectors available in the market which are associated different translation agencies, client is not willing to build in-house translation team obviously.

We have found many Sitecore Translation Connector modules such as:

  • SmartLing
  • LionBridge
  • SmartClay
  • XTM
  • Many more...

[Image credit: Nikki]

Finally we opted for Sitecore XTM Connector services and configured Sitecore XTM Translation Connector in our Sitecore website.

I found that there are plenty of information available on internet about all of these Sitecore Translation Connectors but it's hard to find step by step guide on how Sitecore XTM Connector works and help content authors to translate the content in multiple languages. That's why I am writing this blog post to showcase a complete Translation journey.

First of all you can get Sitecore XTM Connector by get in touch with XTM at https://xtm-intl.com/connectors/

Once you install Sitecore XTM Connector module in Sitecore, you will find XTM Connector module under modules folder in Sitecore Content Editor.


Step-1: Add Sitecore item/page for translation


Let's pick car-hire item for Chinese language translation. Since there is no Chinese language version available for car-hire page, you will see below screen when you switch language to Chinese in Sitecore content editor. 

Page Before Translation:


Select car-hire item from content tree and click on Add to Queue option under XTM menu. 

This will open Add to Queue pop-up dialog where you can select your desired translation languages. I want to send car-hire page for Chinese language translation, so you can see Chinese language selected in below screen.


You can keep adding multiple items in translation queue as suggested in this step.


Step-2: Send Sitecore item/page for translation


Once you have added all desired items in translation queue, you can then send all these items for translation by hitting Translate Now button sitting under XTM menu.



You will get Project ID successfully created for that chunk of items that you sent for translation. You can track this project id under XTM cloud dashboard mentioned in step - 3.




Step-3: Translation agency will get those submitted items in their XTM Cloud Dashboard


Once you submitted item(s) for translation from Sitecore using XTM Connector module, now it's time for translation agency to login XTM Cloud and start translation of submitted item/page(s).



Translation agency will now see car-hire item submitted for translation from Sitecore as shown in below figure.



Step-4: Translation agency will translate items/pages at XTM Cloud


Translation agency will now start feeding translation data in all the fields through XTM Cloud web based interface.




Step-5: Translation agency will submit items to Sitecore after translation from XTM Cloud


When pages are translated and ready to send back to Sitecore, translation agency will save and submit changes to Sitecore via XTM Cloud.



Step-5: Finally Sitecore will recieve all those translated items/pages submitted by translation agency through XTM Cloud


Now you will see Chinese language version added automatically for car-hire item in Sitecore Content Editor.

Page After Translation:




As you see in above screen car-hire page is now translated in Chinese language, and it's under XTM workflow.

If you want to look at different states of XTM worklflow, then you can find them under Workflows folder in Sitecore Content Tree.


Go ahead and open workbox to see all such items those are translated and sent back to Sitecore. You can find all such translated pages under awaiting for approval state.

You can see car-hire item which is translated in Chinese language and waiting for approval.


That's it.

Hope that you have now a clear picture of integrating Sitecore XTM Connector to help your content team to setup auto translation.

Have a happy language translation in Sitecore!

Thursday, 6 April 2017

Tip # 7 : Sitecore Tip Of The Day!

How Should You Configure Sitecore MongoDB Connection Strings?


Brijesh Patel has posted a tip which a Sitecore developer must not skip or take for granted.
His tip says that -

Mongo Database is now an integral part of Sitecore Experience Platform. Sitecore instances connect to mongo databases based on the values specified in connectionstrings.config.


If a Replica set is configured for mongo databases having Primary, Secondary and Arbiter, connection string should only have reference of Primary and Secondary. Arbiter is used only for voting as to who becomes Primary and takes in all reads and writes in a replica set. This serves the purpose of Arbiter which should not store any data.

Connection string for connecting mongo databases should be mongodb://user:password@primary,secondary/databasename?authSource=admin

More options for connection string to mongo databases can be found at https://docs.mongodb.com/manual/reference/connection-string/

Liked it? If you have such a small and sweet Sitecore tip to share with the community then come and share here by filling this form.

Stay tuned for more tips!

Wednesday, 18 January 2017

Tip # 6 : Sitecore Tip of The Day!

Every Developer Should Use "Sitecore Developer Tool" Chrome Extension!


Sumith Parambat Damodaran from Sitecore would like to share a tip that every sitecore developer / user / marketer should have and use "Sitecore Developer Tool" chrome extension.



If you haven't still dirty your hands with it, then you should give a try. Go ahead and install it from https://chrome.google.com/webstore/detail/sitecore-developer-tool/cmbppbejihcnbngefandoljljdppnlda



Liked it? If you have such a small and sweet Sitecore tip to share with the community then come and share here by filling this form like Sumith Parambat Damodaran did.

Stay tuned for everyday tip!

Tuesday, 17 January 2017

Tip # 5 : Sitecore Tip of The Day!

Use Performance.config File for Better Performance in Sitecore


Many developers are unaware with this amazing tip shared by Brijesh Patel with Sitecore Tip of The Day!
The tough time for any Sitecore developer is when you are debugging your code and it takes sometime to get the control back to your debug window. There are lots of processes happening behind the scenes in Sitecore. You can minimize these background processes to gain better performance.



Today's tip is all about that. You should use Performance.config and Performance.Dev.config in your development box.

Kamsar has shared these config files at https://gist.github.com/kamsar/8c9efc80e72e6ada8304
Go ahead and download this file to gain better performance.

Liked it? If you have such a small and sweet Sitecore tip to share with the community then come and share here by filling this form like Brijesh Patel did.

Stay tuned for everyday tip!

Monday, 16 January 2017

Tip # 4 : Sitecore Tip of The Day!

Use Sitecore's TransferUserPasswords.aspx After Installing Sitecore User Package


Don't think about database level operations if you want to transfer Sitecore users from one instance to another instance. Instead use Sitecore's out of the box package feature to package users/roles and then use TransferUserPasswords.aspx page to set passwords back.



Download this utility from Sitecore Knowledge base at: https://kb.sitecore.net/articles/242631

It's good practice to keep it under admin folder and then access it like:
<hostname>/sitecore/admin/TransferUserPasswords.aspx


Liked it? If you have such a small and sweet Sitecore tip to share with the community then come and share here by filling this form.

Stay tuned for everyday tip!

Sunday, 15 January 2017

Tip # 3 : Sitecore Tip of The Day!

Use Sitecore Analytics Testing Tool For Geo-IP Testing!


I am using Sitecore Analytics Testing Tool  chrome extension for IP/Location based testing for my Sitecore websites. Derek Hunziker has created this cool extension having other Sitecore analytics testing features as well.




You can download it from chrome store at:
https://chrome.google.com/webstore/detail/sitecore-analytics-testin/pecalkbdlhhhcoenmcjnmhgnncnkdgak




You can feed different country profiles with IP address as per your desire.


Select desired profile and browse your website now to test your Sitecore personalization implementation.

Liked it? If you have such a small and sweet Sitecore tip to share with the community then come and share here by filling this form.

Stay tuned for everyday tip!

Tip # 2 : Sitecore Tip of The Day!

Let Sitecore Validate Item Name!


Many times we forget to use the cool ItemUtil API of Sitecore and write our own code do some tasks. One of such tasks is validating Sitecore item name while creating item on the fly (programmatically).

Sitecore's ItemUtil class will validate item name by replacing invalid characters (if any) in supplied item name.



Use below line of code for the same and you are good to go.
string validItemName = Sitecore.Data.Items.ItemUtil.ProposeValidItemName(itemName);


For example:
If your supplied itemName is "news@2017" then above line of code will take care of invalid characters and propose you valid item name by removing "@". Thus, it will return you "news2017" as a valid item name.

Liked it? If you have such a small and sweet Sitecore tip to share with the community then come and share here by filling this form.

Stay tuned for everyday tip!

Wednesday, 11 January 2017

Sitecore Tip of The Day!

Friends, Let's start our day with Sitecore Tip of The Day in 2017!

I hope you must be exploring at least one new thing about Sitecore in everyday of your Sitecore journey. This new thing could be anything which is existing since ages but you didn't get a chance to try or explore it.

In this new year 2017, Sitecore journey is taking initiative to spread such hidden gems through Sitecore Tip of The Day blog post.

The idea behind this blog post is to start our day with Sitecore Tip of The day! Every day you will see a new tip here. It could be known to you but could be unknown to someone else.




If you are interested in this concept and if you have any Sitecore Tip to share with community then you are most welcome. Please fill this form and your tip will be published here with your name.
If you are not comfortable with form then send your tip via email.

Please make sure that your Sitecore tip should be small and sweet. 

Day 1 - Tip #1 

How to change default RSS feed count?


The default configuration for RSS feed count in Sitecore is 50. You can change it by configuring below setting in web.config file.

<!--  MAXIMUM NUMBER OF ITEMS IN FEED
            The maximum number of items to include in the client feed.
            Default value: 50
 -->
<setting name="ClientFeeds.MaximumItemsInFeed" value="50" />




If you don't have any tip to share then also this blog post will help you to learn new thing everyday.
Let's start our day with Sitecore tip of the day!

Sunday, 1 January 2017

A Flashback of Sitecore Journey in 2016!

Hey Sitecore Heroes, first of all wish you a very Happy New Year!
Let's welcome 2017 year with some new resolutions... and let's look back at Sitecore Journey of 2016.



Year 2016 was really fruitful for Sitecore Journey. I had achieved many mile-stones during this year - 2016.

1) Achieved Sitecore XP 8 Certification with 97%

It was one of the most memorable moments when your Sitecore Journey scored 97% and achieved Sitecore XP 8 certificaiton.






2) Contributed Four More Sitecore Modules

Sitecore Journey helped many content authors and developers by writing very useful Sitecore Modules in year 2016.

3) Attended Sitecore MVP Summit and Sitecore Symposium 2016 Event

How can one forget Sitecore MVP Summit and Symposium event of 2016 year? Sitecore Journey got a chance to meet and greet community members during this event. 










4) Founded Sitecore User Group UAE (SUGUAE) in Dubai

One of the most successful user groups SUGUAE is founded in this year - 2016. We got a huge response from Sitecore community in Dubai after launching SUGUAE.




5) Contributed many useful blog posts to community

Sitecore Journey released lots of news and helpful modules for Content Authors, Developers, Marketers and Administrators in year 2016.


6) Got 34000+ Hits on Sitecore Interview Question Book

Got a tremendous response of 34K+ hits on Sitecore Interview Question book.






7) SUGUAE Grand Event with Sitecore Partner Days Dubai

Sitecore sponsored SUGUAE event on Sitecore Partner Days at Dubai. SUGUAE rocked this Sitecore Event at Dubai!



I am looking forward to 2017 and wishes you a Spectacular Sitecore Journey in 2017!