Difference between OneDrive and OneDrive for Business

Standard

OneDrive and OneDrive for Business are two different Products, but due to its similar name we get confuse at times that what is what?

So,

OneDrive is the Online File Share which user gets with personal email address with Microsoft, like Hotmail.com or msn.com and you get 5GB of space for free.

OneDrive for Business is the File Share that user gets with the business email address when the person logs in using Company email address and password. The Organisation gives employee the email id with the company domain name, and then user can have this product as part of the Office 365 subscription. This is a Premium Subscription and User gets upto 1TB of storage or 5TB depending on the Subscription you have. Subscription Link : https://products.office.com/en-au/onedrive-for-business/compare-onedrive-for-business-plans

You can get upto 1TB of storage in One Drive for Business, can use it as a File Share, and Share the documents with employees and external stakeholders.

For external users, the SharePoint Online Administrator needs to allow sharing at the top level by adding the external company’s domain name in the list so that users can share documents with the external users.

Lets take an example: Suppose I am working with a vendor called ABC and I have to share some documents with my vendor Adam, whose email id is adam@abc.com then I will allow abc.com domain on my “SharePoint Admin Center” in the “sharing” tab to allow sharing of the documents using OnDrive for Business with vendor in ABC Company.

OneDrive for Business is a useful Product & rather using SharePoint for storing and sharing heavy documents, users can store their documents in OneDrive for Business and implement a complete life cycle by deploying workflows and alerts.

InfoPath 2013 is not compatible with Outlook 2016 in SharePoint 2010

Standard

When sending InfoPath Form in the body of the email, usually the formatting is gone out. The tables and Controls are not aligned properly; Form is embedded as an image.

Solution:

1 – You can use only calculated fields in the InfoPath Form – funny thing but it is tried and tested.

2 – Use Nintex or SharePoint Designer to set email contents for Users.

 

I just used InfoPath 2013 + Outlook 2016 and SharePoint Online, it works and formatting is good if you use 1 table and make sections to hide form fields, key is to use 1 table and embed your solution in it.

How to auto fill InfoPath Form with User Details in SharePoint?

Standard

Business Case:

There is an Employee Application Form – any leave application form. When drafting an InfoPath Form in SharePoint, if you want the Form to be auto filled by the User Details then on Form Load you need to put the following rules.

Make sure that the Employee is not blank, else on every Form Load it will pick fresh User Name. If as a System Administrator you try to open someone ele’s form, your User details will pop up.

Form Load Rules:

Condition: When Employee Name is Blank

Rules:

UserName=Username(). The current Username() will be used to query the UserName field in the UIL List in SharePoint

Query UIL List as a Data Connection

Then, pick up the information

EmployeeTitle = Jobtitle;

Department = Department;

AccountID=Manager;

DisplayName=Concat(LastName,” ,”, FirstName);

TheEnd

Calling User Information List in InfoPath

Standard

If you want to have Employee Details, Manager Details and General Manager details in an InfoPath Form using SharePoint then it is best to make separate data connections for User Information List. The reason for making separate data connections is that, sometimes because of the Complex queries and Data retrieval, system gets confused and bring back old results.

For example if you make a single data connection for Manager and General Manager, then in the General Manager field you might get Manager’s Name. So best is to keep it separate and make entirely separate data connections.

Microsoft Dynamics 365 = CRM + ERP

Standard

This blog is related to the Office 365 and its newly added App “Microsoft Dynamics 365.

002

Microsoft has combined ERP and CRM all together in one Product which is called Microsoft Dynamics 365 and it has has rolled out with Office 365 in November 2016 for customers.

Microsoft Dynamics 365 is a CRM+ERP now, as you can pick and choose the apps from the Microsoft Pricing Model.

Microsoft Dynamics 365 has now following Apps, (the keyword Apps is used for the modules that AX and CRM had in previous versions now these are called Apps)

  • Sales
  • Customer Service
  • Field Service
  • Operations
  • Project Service Automation
  • Manufacturing and supply chain
  • Retail and commerce
  • Finance

dynamics-365-options

Microsoft has also included PowerApps and Microsoft Flows, to enhance user experience and efficiency. The Power Apps are basically Power full app builder tool that users can use to store, share, calculate the documents and perform several actions (like in Word, Excel, Power Point, Limited Excel) and Flows will be used as a workflow engine. I haven’t used these 2 functionalities much as its pretty new and I like the Classic Style of the Office 365 Stuff.

Microsoft is offering 2 Pricing Models at the moment for Enterprise.

  • Plan 1
  • Plan 2

Links to the pricing model is as below, its pretty simple and very much like the other App Plan in Office 365  Dynamics 365 Pricing Model

How to print background color and Pictures in InfoPath 2013

Standard

There are 2 settings that you need to enable in order to print Background color and Picture in InfoPath.

1 – In the InfoPath Designer 2013, File -> Options ->General -> Internet Options More Options -> General -> Check box ” Print background colors and pictures”

2 – In the IE, go to Tools ->Print -> Page Setup -> Check Box  ” Print background colors and pictures”

And you are good to go!!!

Seattle’s Tech Talk

Standard

On my flight from USA airport someone accompanying me in plane asked me what is C# and .NET jargon that we listen all the time, and I never understand the difference between jQuery and Java Script ..They seem like cousins– so here is a small blog for my plane friend.

So, Microsoft created .NET Framework in February 2002, and this became very popular amongst C Developers and Java Developers as this platform provided a base for both languages developer to code with ease. C# and VB.NET are the most popular languages on .NET Framework and is widely used in Microsoft Products.

C# is a programming language developed by Microsoft that is an initiative on a .NET Platform, it is elegant and case sensitive language that enables developers to build a variety of applications.

VB.NET is also a .NET Platform programming language which is an Object Oriented Programming language and it is not case sensitive, Microsoft launched it in 2002 as a successor of Visual Basic.

Both C# and VB.NET are strong and powerful languages, C# is bend towards some powerful features like handling unmanaged code and VB.NET is more towards ease in use like Late Binding. C# is case sensitive and VB.NET is not case sensitive, there are no major differences between the languages but I use C# more than VB.NET.

JQuery is a library of JavaScript and is widely used for Web Based Applications for using client side apps as it is comparatively easy to use. JQuery is executed on the Client side like HTML5, CSS and Java Script. Angular JS and JavaScript are client side scripting languages and they make interactive websites. I make SharePoint Online Apps on JavaScript.

HTML5, CSS executes on the Client side and is responsible for the work that is done in a browser by a user. We make websites in HTML and use CSS as a format, everything that a user’s sees on the browser is a mixture of these.

PHP is a free open source scripting language for making interactive and dynamic web pages. ASP.NET is Microsoft server side web application framework which is used for dynamic web development.

Now there is Bootstrap which is a front end framework and is used for developing responsive mobile first websites that is intelligent enough to display websites on any machine depending upon the screen size and format. This library is widely used in C# applications.