InfoPath Form Slow To Load

InfoPath Form Slow To Load

Last week, one of our clients reported that a InfoPath form they are developing is really slow to load. It takes about two minutes to load and then everything works fine. The form and logic were developed by one of their team members (does not want to pay consultant :)).

There were only 1100 items in the data source. They already exhausted XML and SQL data source options with same data set. So, it is now obvious that the issue lies somewhere within the form. But they could not figure it out, hence it came on our plate.

Looks like our friend Google has lot to say regarding this issue and suggested many solutions. Unfortunately, none worked for me. So, I decided to take the time to examine each control and logic one by one (It was a big form). Sure enough, culprit was identified.

What Happened?

One of the page views,

  • Had a repeating table with 3 columns
  • First column contains a drop-down list
  • 2nd and 3rd columns have text box controls
  • Developer assigned default values to 2nd and 3rd column controls. Default values were an defined as InfoPath functions those were dependent on the drop down selection of the first column and that was the issue.
  • Removed default values, published and the form loaded up within second


Explain More

Basically, every time the form was loading, it was trying to set default values for 2nd and 3rd column controls. But as there was no selection in the drop-down, it kept trying to get a value until it timed out.

InfoPath form slow to load can happen for many reasons. Above is just one of those that we experienced. Hope somebody will find this information helpful, some day.


How To Integrate Google Map in Nintex Form

Following steps will guide you to integrate Google map in Nintex form. Google map will be displayed using bootstrap modal dialog with dynamic data.

So, what do we need to make it work?

Make a wild guess!! Yes, you are right. You will need address information, obviously. In my case, I am using Latitude and Longitude data, kept into two different columns in SharePoint List. But you can have both data in a single column seprated by comma. We will use these columns as connected fields later.

List Columns:

  • Latitude
  • Longitude

Note: We will use these column(s) as connected fields later in Nintex form.

Now actual work:

Setup your Nintex form (Flexi Task or regular Nintex form) to work with Google Map. I am integrating Google map in Flexi task Form.

  • Add google map API Link in Flexi task form
    1. Open Flexi Task form and Click on Settings from ribboNintex flexi task form ribbon. Form settings control. Nintex google integration. using bootstrap in nintex
    2. Copy following Google Map JS API link;

     3. Paste this link in Settings > Advanced > Custom JavaScript Includes

How to enable custom javascript in Nintex. using google map in bootstrap modal in Nintex

4. Click OK on the Settings Modal dialog window. You will be back to “Assign Flexi Task” Page


  • Add Latitude and Longitude columns on the form
    1. Find, drag and drop Latitude on the form. You can put it anywhere you want.

how to add SharePoint control in Nintex form?

2. Open Latitude control setting and change settings as show in the screenshot below:

How to make a Nintex control JQuery enabled?    3. Click ‘Save’

4. Repeat step a to c for Longitude list column as well.

  • Now in the Flexi task form:
    1. Drop a ‘Rich Text Control’ on your Flexi Task Form, open control settings and follow the screenshotHow to add custom HTML and JavaScript in Nintex form
    2. Now you should see ‘HTML Editor’ dialog window
    3. In the HTML editor window, paste below code:

<input id=”btnShow” type=”button” value=”Show Maps”/>
<input class=”ImageLinkFormat” type=”button” value=”View Map” />
<div id=”dialog” style=”display: none;”>
<div id=”dvMap” style=”width: 580px; height: 380px;”>   </div>
<script type=”text/javascript”>
/* view map code*/
NWF$(“#btnShow”).click(function ()
var lat = NWF$(‘#’ + Latitude).val();
var long = NWF$(‘#’ + Longitude).val();
modal: true,
title: “Google Map”,
width: 600,
height: 450,
Close: function ()
open: function ()
var mapOptions =
center: new google.maps.LatLng(lat, long),
zoom: 18,
mapTypeId: google.maps.MapTypeId.ROADMAP
var map = new google.maps.Map(NWF$(“#dvMap”)[0], mapOptions);

/* view map code ends*/


NOTE: By default, Nintex forms are JQuery enabled. One catch is you must use NWF$ instead of $.
4. Save and publish Nintex form or workflow.

That’s all. Make sure that you have proper Latitude and Longitude information in SharePoint list columns.

Please feel free to share, like or follow us in social networks.




Advantages of property management on the cloud

Advantages of property management on the cloud

Technology is evolving day in day out in the world. With the current trends in technology , business have to be upfront in ensuring that they are updated or else they found themselves obsolete in the market and later fails. Change in technology is very significant in the business and therefore the management has the responsibility of ensuring all things are running well in the business. In the advent of enough information in the internet, small businesses can have great benefit with what is provided there. Small businesses have little capital to run and the returns which they make are not substantial enough to install super infrastructure to run the business. Incorporating expensive infrastructure in small business is good for its growth but the major consideration is whether the business can be able to pay back the assets injected into the business. However, there are platforms in the internet which can be utilized to provide some resources necessary to run and manage residential property and also recover the data lost. This entails property management which is key player in the economy. The paper is going to focus on cloud computing and how it can be utilized to bring benefit in property management.


Cloud computing is also called on–demand computing. It is type of computing that involves sharing of the resources for computing . Instead of having a localized server, the computing services are provided In the internet to serve the same purpose as the one which could have been served by having a personal device to handle the application. The advantage of cloud computing in the business is that it minimizes the running cost of the business. When we compare the fee charged on paying to use the services in the internet and purchasing one’s own program, it by far bypasses the expected cost. The devices required to run the program might be expensive and therefore the cloud system can replace this in excellent manner. On the other hand utility refers to the process of sharing resources in order to have economy of scale. Economy of scale entails avoiding incurring higher costs to cut down the cost of operation and also to increase the profit.


The benefits of cloud system are gaining adoption in property management. This is mostly in businesses which have not established market well and therefore they want to safe on finance. The system allows them to access the facility at lower cost in the internet  hence they can recover the data accurately. Some of the resources the business can benefit from are the improved software to monitor the residential property. Instead of developing personal software only for the business, internet avenues can be explored to source for those platform where little subscription is required instead of developing new one. The major advantage of this is that the resources are shared globally and this gives the chance to make people know about the product well . Also the cost of maintaining personal server might be too expensive to the business. Another point of concern is on the databases of the business. The cloud system can replace the odd system of organizing the database. The business can access the recent method of storing the data. Data is very important for every business because it is through it that the business can be able to account and evaluate its performance. The cloud system will enable the business to have the applications which are running faster and they can be managed easily. This enhances the adjustment of various resources due to changing demand of the product. When all this are incorporated in the business, it is easier to reach out for the clients and customers in a broader manner. The business will be able to design more about its branding and even include more of advertisements in their sites because the systems in place will support that. It will therefore be easier for the customers to check their site even via phone.



I have been working with Nintex form and workflow for last one year. Prior to that I have worked with Microsoft InfoPath a lot. Nintex is a great tool. I love the graphical workflow designer. The workflow export and import feature is fabulous. The action items are easily configurable. Workflow action can be copied & pasted (one at a time) within the same workflow.

But, it would be nice to have Cut & Paste functionalities for workflow actions. Imagine you have to move quite a few actions from very bottom to top or vice versa.Currently, you can copy an individual action, paste it to desired position, then go back and delete action from old position.

If copy & paste works, should not cut & paste work?

SQL ‘Data Source Type’ missing from Data configuration Wizard

SQL ‘Data Source Type’ missing from Data configuration Wizard

Today, I sat for coding after a long time. I have started a SharePoint 2013 visual web part project which will perform CRUD operation using Telerik radgrid UI Control. One of the process is to create a data source for the grid using grid control’s smart tag.

Basically, smart tag opens up visual studio’s data configuration wizard and gives you step by step instructions to create data source. But for me, data source type was missing in “Data Source Type” window. I could not find any other way to add SQL data source in this window.

Then I thought to use ‘Data Source’ control from ASP.NET toolbox. I remember using that control in earlier version of VS. But it is missing from toolbox panel as well. Then I decided to manually create it.

Here are the steps:
1) Add or modify your connection string in web.config file as follows:

    <add name=”TestConnectionString” connectionString=”Data Source=SharePoinDev1; Initial Catalog=YourDatabaseName;User ID=sqllogin;Password=loginpassword”

      providerName=”System.Data.SqlClient” />


NOTE: You cannot use windows authentication if you are using the connection string with Telerik grid. You will receive following runtime error:

“This control does not allow connection strings with the following keywords: ‘Integrated Security’, ‘Trusted_Connection’.“

2) In your ASCX page. Paste the following code snippet probably at the bottom:

<asp:SqlDataSource ID=”SqlDataSource1″ ConnectionString=”<%$ ConnectionStrings:TestConnectionString %>” SelectCommand=”SELECT * FROM yourTable” runat=”server”></asp:SqlDataSource>

3) Now sync your design view with code by clicking the yellow notification.




4) Once synced, you should see SQLDataSource control in your design pane




5) Now in code page, reference newly created SQLDataSource id in grid control:

<telerik:RadGrid ID=”RadGrid1″ runat=”server” GroupPanelPosition=”Top” DataSourceID=”SqlDataSource1” AllowFilteringByColumn=”True” AllowPaging=”True” AllowSorting=”True” AutoGenerateDeleteColumn=”True” AutoGenerateEditColumn=”True” Skin=”MetroTouch”>

<GroupingSettings CollapseAllTooltip=”Collapse all groups”></GroupingSettings>

    <MasterTableView DataSourceID=”SqlDataSource1” AllowAutomaticDeletes=”True” AllowAutomaticInserts=”True” AllowAutomaticUpdates=”True”>


6) Sync design and code page (step 3)
7) Now, in design pane, if you select grid smart tag, you should see SQLDataSource1 and you can add or modify SQL data connections using wizard.

Even though, I wrote these steps using SharePoint 2013 visual web part and Visual Studio 2013, this should be valid for any ASP.NET data binding projects in any version of visual studio. Also, for other missing data source type.

Property management – Hassle, but does not have to be!

Property management – Hassle, but does not have to be!

property management software imageResidential property is basically housing establishments either a house or an apartment that people either lease or rent for a specific period of time for purposes of accommodation and/or occupation by a family or a single individual for non-business purposes. Meanwhile the management of such property entails the operation, control and oversight of such establishments. Residential property management is something that home owners who want to lease or rent their houses should really consider. This is to ensure that they reap the maximum returns from their establishments.

Residential property management services are offered by Residential property management Companies. A Residential Management Company performs duties on behalf of the property owner and provides services to the tenants and the property. A home owner or investor employs a property management firm to maintain their real estate so that they do not need to attend to the tenant and property issues and can instead focus on new properties or simply go about their daily life. Such companies are tasked to find suitable candidates for occupancy, check who qualifies best and select the deserving tenant.
They also manage relations with the tenants on issues such as handling contract agreements with the tenants, maintaining accounting records and overseeing legal tasks. They also collect the house rent from the tenant on behalf of the home owner. This saves the home owner the hustle of trying to contact the tenant for rent. That is not all. Being a management company, what they do is to manage the house and/ or apartment on behalf of the home owner.

They act as a point of contact for any issues. This means that whenever the tenants have any maintenance issue, they are the people that will deal with it. Electric faults, sewerage and plumping issues, leaky roofs and water shortages are all issues handled by such management companies. They will also manage the property turn over in between tenants. This ensure that the cash flow to a landlord is in constant supply because when the current tenant puts a notice to vacate, the management company will immediately start looking another tenant to move in.

Proper management of your property ensures that the establishment last long and ensures continued income generation. The process of selecting and qualifying tenants ensures that the occupants of your house and of good character and are of the ability to pay rent on time. This is important so as to ensure that the tenants do not engage in illegal activities in your establishment. An online application like (MiPP) is a great tool that can smooth-en overall property management.

Nintex – Lauching mobile app from hyper-link in external email

Nintex – Lauching mobile app from hyper-link in external email

Yesterday, I was working on to launch Nintex mobile app using hyper-link in an email. I was able to do that by following excellent article by Vahid Taslimi.
Part of the requirement for this project is that users will receive task notification on their personal(non-corporate) email address and should be able to launch the app by clicking link in the task notification.

But, here is the issue I encounter on a Windows Phone:
Receive task notification in a Hotmail email address and able to launch Nintex mobile app on the phone. But as soon as I try to type in password, it started to give
“An error has occurred. Click OK to report this error to Nintex Support”. The annoying part is that the error keeps coming back after clicking OK unless you kill the application.

Further testing:
1) This issue does not appear if user is already signed in the app.
2) Issue only appears when app is launch through link and password field is focused.

Apparently, the issue does not exist for iOS devices. Please share you thoughts if you have experience similar issue.

Nintex – Flexi task branch recreation issue

Nintex – Flexi task branch recreation issue

Issue: Deleted branch from Nintex “Assign Flexi Task” control by following below steps:
– Advanced Options > check “Do not create branches”
– Deleted branch that I do not need.
This caused the control to have no branch and which is expected.

Now, i am trying to add branch by reversing above steps. I am able to add branches in the configuration window but branches do not appear in visual representation.

Save time and cost with Office 365

Save time and cost with Office 365

Make business easier with Aphelion Inc. and Office 365


With the need for greater mobility, agility and better data management increasingly driving the dynamic workplace, SMBs today are learning to appreciate the benefits cloud computing can bring to their businesses.  Yet, some SMBs still struggle to understand exactly what cloud computing can do for them.  Enter Microsoft Office 365, an all-inclusive productivity solution that delivers familiar Office applications coupled with powerful enterprise class communications and collaboration capabilities in a cloud-based subscription service you can easily use.


Give your business a productivity boost with the new Office


Today, you can acquire Office 365 Small Business Premium or Midsize Business through Aphelion Inc., as a standalone solution or bundled with our Online Request Tracker (ORT) cloud application, and no matter which you choose, you’ll still receive the same support and service you’ve come to expect from Aphelion Inc.


Office 365 for SMBs is a completely modernized platform designed to meet your constantly changing business needs. It delivers rich features and cloud service innovation that SMBs are adopting at an accelerated rate.


Benefits include:


  • Letting you take your personal office experience with you – across tablet, PC or phone – wherever you are and whenever you need to get work done.
  • Saving documents to the cloud by default. When you sign into Office 365, you get roaming settings and quick access to your documents in SkyDrive, SkyDrive Pro and SharePoint online.
  • Scheduling a meeting, sending an email, starting an IM, as well as initiating voice and video calls right from your contact list.
  • Easily hosting more effective online meetings, with multiparty HD video conferencing, document sharing and real-time note taking with OneNote.
  • Connecting Lync and Skype services, so you can connect with millions of Skype users right inside of Office 365.
  • An enterprise-grade cloud solution with robust security, guaranteed reliability and compliant with world’s industry standards, including ISO-27001, EU Model clauses, HIPAA and FISMA.


Most importantly, with Microsoft Office 365 you get an always available secure and reliable cloud service from a trusted partner. We manage the billing and support for your subscription service so you have a one stop shop for all your support needs.


For more details on Office 365, check out or email us at



Subscribe To Our Newsletter

Subscribe To Our Newsletter

Join our mailing list to receive the latest news, promotions and updates from Aphelion team.

You have Successfully Subscribed!