How to store WFFM data in SQL Server instead of SQLite database in Sitecore

When you install WFFM package, by default it store data in SQLite database.

Disadvantage with SQLite is that it creates the database on disk and it’s not centralized.

However Sitecore provides a way to store WFFM data in SQL server.

Here are the steps to do it.

·         Restore database in SQL server from “Website\Data\Sitecore_WebForms.bak”

·         Change “Sitecore.forms.config” file in “Website\App_Config\Include” where comment SQLLite section and uncomment MS SQL section and put the new connection string for restored database as shown below

    <!-- DLINQ compatible data storage -->

    <!-- MS SQL -->

   

    <formsDataProvider type="Sitecore.Forms.Data.DataProviders.WFMDataProvider,Sitecore.Forms.Core">

      <param desc="connection string">user id=abc;password=xyz;Data Source=your DS;Database=dbname</param>

    </formsDataProvider>

   

    <!-- Oracle -->

    <!--

    <formsDataProvider type="Sitecore.Forms.Data.DataProviders.Oracle.OracleWFMDataProvider,Sitecore.Forms.Oracle">

      <param desc="connection string">user id=(user);password=(password);Data Source=(database)</param>

    </formsDataProvider>

    -->

    <!-- SQLite -->

       <!--

    <formsDataProvider type="Sitecore.Forms.Data.DataProviders.SQLite.SQLiteWFMDataProvider,Sitecore.Forms.Core">

      <param desc="connection string">Data Source=/data/sitecore_webforms.db;version=3;BinaryGUID=true</param>

    </formsDataProvider>-->

Please leave your comments or share this tip if it’s useful for you.

Metadata file 'HedgehogDevelopment.CodeGeneration.Extensions.dll' could not be found

If you are getting HedgehogDevelopment.CodeGeneration.Extensions.dll error in TDS Sitecore project then put HedgehogDevelopment.CodeGeneration.Extensions.dll into C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\PublicAssemblies folder for Visual Studio 2012.

Please leave your comments or share this tip if it’s useful for you.

How to make URL in lower case in Sitecore

Sometimes client requirement is to make all letters lower case of their website URL. It’s a good practice as all search engine provide better result with lower case URL.

How to do it in Sitecore with .NET?

Sitecore is smartly provide this facility by changing just one entry in web.config file. If you want make URL in lower case then keep lowercaseUrls="true" from <linkManager defaultProvider="sitecore"> section in web.config file as highlighted below

    <linkManager defaultProvider="sitecore">

      <providers>

        <clear/>

        <add name="sitecore" type="Sitecore.Links.LinkProvider, Sitecore.Kernel" addAspxExtension="false" alwaysIncludeServerUrl="false" encodeNames="true" languageEmbedding="asNeeded" languageLocation="filePath" lowercaseUrls="true" shortenUrls="true" useDisplayName="false"/>

      </providers>

    </linkManager>

Woooowww. No programming required J

Please leave your comments or share this tip if it’s useful for you.

Could not load file or assembly 'System.Data.SQLite, Version=1.0.89.0, Culture=neutral, PublicKeyToken=abcdefghijkl or one of its dependencies

If you are getting Sitecore WFFM error "Could not load file or assembly 'System.Data.SQLite, Version=1.0.89.0, Culture=neutral, PublicKeyToken=abcdefghijkl or one of its dependencies. The system cannot find the file specified."

Then check existence of "System.Data.SQLite.dll" in "Website\bin" folder.

If it’s missing then paste in "Website\bin" folder.

Please leave your comments or share this tip if it’s useful for you.

How to check your new or modification PAN request status online

I personally feel that most of the life related work should done online. Why to visit difference government and private offices, why to meet them personally, why to call them. For a common man it’s always a difficult to go to government office and do their tasks. Government people are always showing that they are busy even they don’t have no work. Common man is always frustrated with government offices and their babus. So I always prefer to do it online.

So here I am sharing my personal experience to do changes in PAN card and how to track the request online.

If you had applied for PAN card changes like name, DOB, signature, photo etc. then you can submit your request at Karvy. You have to fill a form and attached old PAN card copy, ID proof, address proof. Submit this form along with 105 Rs. In return they will provide a receipt which has acknowledgement number. From that acknowledgement track your request status from below link

https://tin.tin.nsdl.com/pantan/StatusTrack.html

Either enter Acknowledgement number or your personal detail. Click on SUBMIT button as shown in below image and you can get the status which should be either in process or completed.

Please leave your comments or share this tip if it’s useful for you.

Tip for how to check your Aadhaar- Gas linkage Status

To get subsidy on LPG gas cylinder. You need to link your Aadhar Card number with gas agency and bank.

If you had applied your Aadhar card linkage request at Bharat Gas and Bank then you can check the status at below link

http://www.ebharatgas.com/ebgas/faces/CC_include/ConsumerAadhaarStatus.jsp

Enter your Aadhar card or cell number and click on Proceed button. Check the status on the status screen as shown below

Please leave your comments or share this tip if it’s useful for you.

Tip for how and where to check status of any modification request of Aadhar Card

If you have applied for any information update request in Aadhar card like Name, mobile number, address, date of birth, email then you can check update status at below link

https://ssup.uidai.gov.in/check-status

You have to enter your Aadhar number and URN and on click of Get Status button you can check the status.

Please leave your comments or share this tip if it’s useful for you.