Submit InfoPath Each Repeating Table Data to SharePoint List as Individual Item

Submit InfoPath Each Repeating Table Data to SharePoint List as Individual Item

I received a requirement to create a time card entry and keep track of the number of hours consumed in their activities. Below is a sample of the form.

I had to design the form in such a way so that individuals can make multiple entries for a week and on different types, like, Project, Holiday, if it is Project then What is the name of the project and whether it is Design or Lab hours. So, I added all my controls on a repeating section. Initially I thought of merging the records in comma separated value but reporting is complicated. I decided to save them in a list as individual item to make life easy. Below are the steps which can help you achieve the same.

1. Create a List and add all your fields which are required on the form.

2. Open the InfoPath Form designer, Select SharePoint List form template and Select Design Form.

    

3. Provide the Site URL

4. Select the List and continue

5. Now before you click finish, notice there is a check box says, "Manage multiple list items with this form".

6. Select the checkbox and click on finish.

7. This would open the Form with all controls added inside a repeating section.

8. If the repeating section is not enabled to add sections at run time, click on the repeating section property and enable them.

For me the end result look like below.

Hope this helps ! Feel free to suggest any other alternative you know.

Cheers !

Use SPServices in Nintex Form

Below are  the steps given to use famous jQuery SPServices in Nintex Forms

1. Open the minified SPServices file, in my case it is jquery.SPServices-2014.02.min.
2. Scroll down to the end of the file where you will see a line,
 
    return aK.test(ao(aM)[i.method](i.property))}})(jQuery);

3. Replace the term jQuery to NWF$
4. Save as the file in different name, NWF.min
5. Now upload the file to a SharePoint library and refer it in Nintex Form
6. Open Nintex Form settings, expand Advanced, and paste the url in "Custom Javascript Includes" section.
7. Expand Custom javascript and paste the below code.
   
           NWF$(document).ready(function(){
                 console.log(NWF$().SPServices.Version());

           });

8. Hit F12 and Preview the form.

9. If all the steps are followed, you can see the version of the SPServices file, in my case LOG: 2014.02 in the console.

Hope this helps. Cheers !

InfoPath Form Multiline Text published as Single Line of Text on Form Library

You have Multi line textbox on your InfoPath Form and after you published it, you noticed that your data is truncated on the library view and the field is published as Single Line of Text.

This is a known issue for Microsoft and looks like it is not yet fixed or won't be fixed. There is no solution to this, however, there are two workarounds which I can think of -

Option 1) 

Create a Multi line Textbox and if not required, uncheck the richtext options and publish the form.

Option 2) 

a) Publish the form library and if it is single line of text then create a Multi line text field on the form library.

b) Select Allow unlimited length while creating the column.

c) Go to the form publishing wizard, and on the field promotion, Select the field which you promoted, hit modify, and then map it with your new multiline field create on your library.

d) Now all your data is mapped to this new field, so you won't loose any record.

Cheers :) !

sideloading of apps is not enabled on this site : sharepoint online

Are you developing Apps for SharePoint 2013 on a non developer site ? There is a new site template available for developers to develop their apps and test them on a Developer Site Template. You should use Developer site template to develop and test your apps.
If you are trying to deploy your app on a non developer site then you would receive an error "side loading of apps is not enabled on this site SharePoint online".

Side Loading is a hidden feature  which should be enabled on the site to deploy your app. By default this feature is not enabled on any non developer site, so when Visual Studio tries to deploy your app, VS checks if side loading is enabled.
VS calls a method Microsoft.SharePoint.Client.AppCatalog.IsAppSideloadingEnabled and it returns FALLS if it is not a developer site template. However, this hidden feature can be enabled by using Power Shell. Please follow the below MSDN link which explains how to enable them.
http://blogs.msdn.com/b/officeapps/archive/2013/12/10/enable-app-sideloading-in-your-non-developer-site-collection.aspx

Remember side loading of apps is not secure on production sites. It has potential risk of unwanted apps to get added in your site. So never turn on this feature on a production site.

SharePoint Developer Dashboard

SharePoint 2010 has introduced a cool tool for developers to troubleshoot performance issues, the Developer Dashboard. By default the tool is disabled on SharePoint 2010. You can use stsadm or powershell scripts to enable or disable the tool.

Powershell to Enable Developer Tool

Execute the below powershell script to enable Developer Dashboard on your environment.

$service = [Microsoft.SharePoint.Administration.SPWebService]::ContentService
$addsetting =$service.DeveloperDashboardSettings
$addsetting.DisplayLevel = [Microsoft.SharePoint.Administration.SPDeveloperDashboardLevel]::On
$addsetting.Update()

It displays the output window at the bottom after the page loads.

OnDemand Developer Tool

$service = [Microsoft.SharePoint.Administration.SPWebService]::ContentService
$addsetting =$service.DeveloperDashboardSettings
$addsetting.DisplayLevel = [Microsoft.SharePoint.Administration.SPDeveloperDashboardLevel]::OnDemand
$addsetting.Update()

On Demand enables a small button to make it available when needed.

Disable Developer Tool

Execute the below script to disable the tool.

$service = [Microsoft.SharePoint.Administration.SPWebService]::ContentService
$addsetting =$service.DeveloperDashboardSettings
$addsetting.DisplayLevel = [Microsoft.SharePoint.Administration.SPDeveloperDashboardLevel]::Off
$addsetting.Update()

The expected version of the product was not found on the system

Are you trying to install any cummuliative update on SharePoint and receiving error "The expected version of the product was not found on the system". This is because you are missing some patches which are required before you install the update. You can open Central Admin and navigate to "Check product and patch installation status" page and check for missing patches. Alternatively, if you don't want to do the check and just want to install it, open command prompt and run the below command. Cheers !

packagename.exe PACKAGE.BYPASS.DETECTION.CHECK=1