Tuesday, September 8, 2015

DFFS and vLookup BETA 3

The documentation is not updated with the BETA 3 changes. This will follow as soon as I can manage.
You find the updated files here

I have finally finished the hopefully last BETA of DFFS and vLookup.

The DFFS BETA 3 is compatible with SharePoint 2007, 2010 and 2013, but the BETA 3 of vLookup is for SP2010 and 2013 only. I have not updated vLookup for SP 2007.

Normally, BETA 3 would contain only bugfixes from BETA 2, but I ended up adding a few new features also – like “print” and “email”, a visually brushed-up DFFS backend, and a bit more.

Use the “help icons” in DFFS backend to learn about the new features. See “Documentation” below for more info.

License code handling

The license code has now moved into the DFFS backend configuration (not for the JSLink version).

I have also updated the license code validation to make all versions use the same “format” on the license code.

This mean all but the JSLink version license codes must be updated.

If you have a valid DFFS v4 license you can send me the old license code, and I’ll send you a new one – free of charge.

Please note

I cannot guarantee full backwards compatibility for all older configurations. Please BACK UP your configuration first by going to the Misc tab and Export the configuration to a text file.

This way you can restore your previous version if something did not perform as expected.

Documentation

I have put in a HUGE amount of work in this new version, and as is is long overdue my original release date, I was keen to get it published as soon as I possibly could.

This means I have not been able to update all the documentation for the new version. This will follow – hopefully tomorrow, but here is a few short notes.

Installation of “CEWP” version

(all but the JSLink verson of SharePoint 2013.)

I have now added a folder “CEWP” to the download package. This contains updated versions of the “DFFS_frontend_CEWP.html”, “DFFS_frontend_overlay.html” and “DFFS_backend_CEWP.html”.

The recommended location for all the DFFS files is in a document library named “SPJS” in the root of each site (or in the root of the site collection).

When the solution is out of BETA

You must update your existing CEWP code to use the latest DFFS and plugins from this package. Ideally, you should change all existing CEWP’s in all your forms to point to the new files. This will make future updates easier to manage as all files has it’s designated location.

Special focus points for testing

The one point I’m most keen to get reports on, is large lists with a lot of rules. I have changed the trigger handling part of the code, and hope it has become more efficient. If you find your form using a long time to load, please consider reworking the rules, and utilize the new functionality to “Stop if this rule = true, and jump to” functionality on the triggers.

You can also control the “reversing” for each individual rule to prevent unnecessary processing of “reversed rules”.

Questions and feedback

Use the forum for all issues with general interest. If you don’t already have an user account, you find instructions in the sticky post in the top of the forum.

Best regards,
Alexander

by Alexander Bautz via SharePoint JavaScripts

#SPCOM weekly Newsletter - SharePoint 2016 & Conferences

Hello SharePointers and welcome to this week’s SharePoint Newsletter! In this newsletter we will talk about SharePoint 2016 and Conferences!

1. Win a Pass to SPLive360 in Orlando November 16-20

Chart the best collaboration course at SharePoint Live!, November 16-20 in Orlando! Whether you are a Manager, IT Pro, DBA, or Developer, SharePoint Live! brings together the best the industry has to offer for 5 days of workshops, keynotes, and sessions to help you work through your most pressing SharePoint projects.

Conference Info: http://bit.ly/UGOR13Home

Contest: http://spvlad.com/1M7pAND

2. Learn SharePoint 2016 from some of the best in the business

The Collab365 Global Conference is just 6 weeks away now, and with the launch of the Agenda this week it’s been full steam ahead. With 120 sessions, and two of them focusing strictly on SharePoint 2016, what’s not to love? This event is also FREE, and you can watch it from everywhere!

http://spvlad.com/1K5W1Kk

3. SharePoint Server 2016 IT Preview Web Templates [By Bill Baer]

The following table documents all Web Templates available in SharePoint Server 2016 IT Preview.

http://spvlad.com/1UExr4z

Upcoming SharePoint Conferences

SPBiz Solution Day – Sept 17 - http://spvlad.com/1NZnFv6
Collab365 Conference -Oct 7-8 – http://collab365.events
European SharePoint Conference Stockholm- Nov 9-12 - http://ift.tt/Mmzz5s
SPLive 360 Orlando – Nov 16-20 - http://bit.ly/LSPK13Home
SPFest Chicago – Dec 8-10 - http://ift.tt/1AjQb1l

by Vlad Catrinescu via Everyone's Blog Posts - SharePoint Community

DynamicPoint Prepares for SharePoint 2016

Like so many others out there, DynamicPoint is anxious for the official release of SharePoint 2016 and with the latest update from Microsoft we can anticipate the product to be ready in Q2 2016.

At DynamicPoint we are busy evaluating this new release, especially how we can take advantage of the features in upcoming versions of our SharePoint applications. One of the most exciting new improvements is the responsive interface that renders sites tailored for touch friendly devices. As our customers have grown more and more interested in expanding the reach of SharePoint to mobile users, this new feature will provide additional tools for us to tailor our interface to be consistent with the new SharePoint look and feel.

This is actually just one of many improvements that we plan to take full advantage of. For a summary of the new features please see the graph below or read the official office blog.

Contact DynamicPoint today with any questions.

By Mike Marcin, DynamicPoint – SharePoint Expense, Invoice & Requisition Management applications built exclusively for Dynamics GP & NAV.

The post DynamicPoint Prepares for SharePoint 2016 appeared first on SharePoint Blog.

by Mike Marcin, DynamicPoint via SharePoint Blog

Monday, September 7, 2015

Win a free pass to SPLIVE360 in Orlando!

Hello SharePointers,

I am excited to announce a new contest to give you the ability to learn more SharePoint before the end of the year.

Chart the best collaboration course with SharePoint Live!, providing leading-edge knowledge and training for SharePoint administrators, developers, and planners who must customize, deploy and maintain SharePoint Server on-premises and in Office 365 to maximize the business value.

Whether you are a Manager, IT Pro, DBA, or Developer, SharePoint Live! brings together the best the industry has to offer for 5 days of workshops, keynotes, and sessions to help you work through your most pressing SharePoint projects.

Check out more about SPLive360 here: https://splive360.com

How to win ...

To win the ticket, simply go to this page and enter the Raffle. It takes seconds to complete. Enter the Raffle here. Also, Please note that the contest only includes the Conference Pass, and not the Airfare & Hotel! The Raffle closes on October 12 at 4 PM Eastern Time!

What if I don't win?

Even if you don't win, SharePoint Community has an 600$ discount on the conference price! To use it, simply enter the following code (in the image) when you sign up!

by Vlad Catrinescu via Everyone's Blog Posts - SharePoint Community

Preparing for Cloud? Know this before you Migrate to SharePoint Online & Office 365 !

SharePoint Online – the most powerful and rapidly growing platform typically used for enterprise collaboration along with Office 365 are becoming the popular ways to connect with experts across the globe, organize information, engage with people, share ideas and reinvent the way individuals across an enterprise work together in sync. In the rat race to rapidly adopt cloud technologies, many organizations are considering to dump their on-premises file servers and previous versions of SharePoint so as to switch to the cloud environment by adopting either SharePoint Online or Office 365.

In a recent survey conducted by Cryptzone on May 5, 2015; it was revealed that nearly 48% of the organizations currently use Office 365 and 39% are using SharePoint 2013 (SharePoint Online version) while the additional 15% are looking forward to move to the cloud within the next year.

Considering the above numbers, I’m quite sure that most of the enterprises that are preparing to move to the cloud are still finding answers to critical questions like – How they should proceed towards secure migration?, What are the Cloud Migration challenges they’re likely to encounter in the long run? What they should do to quickly turn their organization into a cloud friendly enterprise?

This blog discusses some of the extremely important things that you must take into account before you jump to the cloud – whether SharePoint Online or Office 365.

1) Taking the first crucial step - Conduct a Pre-Migration Analysis

Performing migration without proper analysis of data that you intend to migrate is one of the biggest security risks that no organization would ever want to take with their important information. Conducting a pre-migration analysis helps an enterprise in many ways. Besides checking the compatibility, it helps you optimize the whole migration plan along with processes so as to pre-identify the probability of a successful move, identify potential migration issues that one may encounter during the whole operation and get an overview of content so as to plan how much storage you will need in the cloud to accommodate your data.

2) Checking the state of your current data is important before Cloud Migration

Yes, you heard that right!! Before you even think to migrate, it’s important to check the state of your current data (both information & content), know whether your files & folders are evenly structured, estimate the probable speed of migration to get an idea about the time that the migration operation will take and investigate if the migration would be actually beneficial for your enterprise.

Though it’s a time-consuming task to conduct a check on the current content state, it still plays a significant role in detecting the migration performance whether you’re looking to move specifically to SharePoint Online or adopt the full Cloud suite - Office 365. One way to perform this crucial check is by organizing workshops with individuals who actually understand the content structure; how it can be stored & what are the ways to plan reorganization of the whole information architecture in the best possible way.

3) Learning about new features and how to use them is critical for Cloud Success

You can’t just jump to the cloud because you’ve decided to move your data and people around you are quickly transitioning to the new online system. For improved performance and smooth workflow even after performing the migration process, you must get hands on training about the comprehensive features that the platform offers to its users. After all, what’s the use to spend thousands of dollars in switching your data from one place to another and scratch your head later when you face difficulties in maintaining the whole infrastructure and managing workflows & communication on the cloud? Definitely nothing! So, it’s better to first know how to jump to the cloud, deal with the new challenges and then take the transition !!

4) The Cost Factor – Evaluate what it costs to migrate to the Cloud and also evaluate the maintenance overheads

Last, but not the least, don’t forget to evaluate the cost factor of both migration and maintenance. Immediately after you finalize your cloud architecture, you must plan your cloud expenses beforehand like whether you would like to pay for monthly Office 365 subscription or annual fees, evaluating the cost according to storage space needed for your content, what would the overheads involved in maintaining the applications & services afterwards and what are your backup and restore needs. Evaluating all this is important to figure out whether cloud would turn to be actually cost-effective for your organization or not. There’s no point to migrate only to know later that you’re unable to maintain your new online system within your estimated budget and then repent later. It’s better to first know how things work in the cloud, how much it would cost you and then consider to take the big move.

Conclusion :

However hard you may try, migration from SharePoint on-premises to SharePoint Online or Office 365 will always be difficult especially if you’re following the native path. For performing pre-migration analysis, third party tools like LepideMigrator for Documents have been successful in enabling users to migrate a site/central admin; list/libraries; and also items from a previous SharePoint version to a new one. Also, clients across the globe trust LepideMigrator for Documents for facilitating two-way synchronization between two servers while also simplifying Exchange migration via powerful reporting consoles. You may download the free trial of this software to get started. For more details about this versatile Exchange migration tool, click here - http://ift.tt/1rRPxrU

by Satyendra Tiwari via Everyone's Blog Posts - SharePoint Community

Saturday, September 5, 2015

SharePoint Search - how to return all results

SharePoint Search - how to return all results

By default, when we use the Search API, SharePoint limits the number of items retrieved. If your query returns a number of items within this limit, then it is not a problem. However, if your query results in a larger set, then by default those items will not be present in the result set.

I noticed that when using KQL, by default SharePoint limits the results to 50 rows. We can explicitly set the RowLimit up to 500. When using the REST API using JavaScript, I noticed that the results were limited to 500. If our result set contains more items, then we need a mechanism to retrieve the other results.

We might want to include all the results in one single unit such as in a report. Or, we might want to show a initial set of results and then page through the remaining results. In either case, we need to be able to retrieve sections of the results at a time. In case we want to create a single report, we can merge them together.

This can be done by keeping the current row index value(which is the last row of the current result set), looping through the pages and updating the current row index after fetching the current page.

For this, lets set the RowLimit to 50. Then, if the TotalRows is greater than the row count of the returned results, get the additional rows.

KeywordQuery keywordQuery = new KeywordQuery(siteCollection);

SearchExecutor searchExecutor = new SearchExecutor();
keywordQuery.QueryText = "KQL Query String";
keywordQuery.StartRow = 0;
keywordQuery.RowLimit = 50;

//retrieve the first page of results
ResultTableCollection resultTableCollection = searchExecutor.ExecuteQuery(keywordQuery);
var resultTables = resultTableCollection.Filter("TableType", KnownTableTypes.RelevantResults);
var resultTable = resultTables.FirstOrDefault();
DataTable resultDataTable = resultTable.Table;

int currentRowIndex = 0;
//Iterate through the rest of the pages
while (resultTable.TotalRowsIncludingDuplicates > resultDataTable.Rows.Count)
{
//Update the current row index
currentRowIndex += resultDataTable.Rows.Count;
resultTableCollection = GetSearchResults(keywordQuery, currentRowIndex, searchExecutor);
var searchResults = resultTableCollection.FirstOrDefault();
if (searchResults.RowCount <= 0)
break;
else
resultDataTable.Merge(searchResults.Table);
}

private ResultTableCollection GetSearchResults(KeywordQuery keywordQuery, int startIndex, SearchExecutor searchExecutor)
{
ResultTableCollection resultTableCollection = null;
try
{
//keyword search using "Default Provider" .
keywordQuery.ResultsProvider = SearchProvider.Default;
keywordQuery.StartRow = startIndex;//gets or sets the first row of information from the search results

// execute the query and load the results into a collection
resultTableCollection = searchExecutor.ExecuteQuery(keywordQuery);
}
catch (Exception ex)
{
}
return resultTableCollection;
}

After executing the above code the resultDataTable will have the complete results even if it is a large result set.

Doing this using JavaScript and REST API, is a bit more tricky. The key thing here is to make the recursive call from the success handler. This is because we want to merge the results of all the individual pages of information.

var allResults;
function yourFunction() {
var searchUrl = _spPageContextInfo.webAbsoluteUrl + "/_api/search/postquery";
postData = {
'request': {
'__metadata': { 'type': 'Microsoft.Office.Server.Search.REST.SearchRequest' },
'Querytext': "sharepoint",
'RowLimit': '50',
'SortList':
{
'results': [
{
'Property': 'Created',
'Direction': '1'
}
]
}
}
};
allResults = [];
searchSharePoint(searchUrl, 0);
}

function searchSharePoint(searchUrl, startRow, allResults) {
//initialize to empty array if it does not exist
allResults = allResults || [];
postData.request.StartRow = startRow;

$.ajax(
{
type: "POST",
headers: {
"accept": "application/json;odata=verbose",
"content-type": "application/json;odata=verbose",
"X-RequestDigest": $("#__REQUESTDIGEST").val()
},
data: JSON.stringify(postData),
url: searchUrl,
success: onQuerySuccess,
error: onQueryFail
});
}

function onQueryFail(data, errorCode, errorMessage) {
//log error message
}

Hope this helps.

Check out the original article at my blog - SharePoint Search – how to return all results

by Prashanth Padebettu via Everyone's Blog Posts - SharePoint Community

Friday, September 4, 2015

We Are Not “Resources”

Human “Resources” …. when did that happen?! It drives me insane. Why is it called the Human Resources Department? To take the humanity out of it allowing some companies to perform some of the worst atrocities in history? Why not the Human Beings Department? Because then it will remind people that we are actually dealing with real, live people every day who hurt and bleed? We’re calling it that in our company now, the Human Beings Department, and it’s filled with beautiful, amazing people.

Human BEINGS have feelings. Human BEINGS have families. Human BEINGS give up their family time to work in your company. Human BEINGS have emotional and financial needs that need to be met. Human BEINGS experience love, joy and pain. Human BEINGS are colourful, crazy, creative and diverse.

What is a “resource” for goodness sake? I’m not a resource, I am a person. Long live our new Human Beings Department!