If you are looking to move off of OpenText to SharePoint, let me know!
PowerStreamECM supports migrating off of OpenText to SharePoint 2013/2016/O365!
For PowerStreamECM features, check out:
If you are looking to move off of OpenText to SharePoint, let me know!
PowerStreamECM supports migrating off of OpenText to SharePoint 2013/2016/O365!
For PowerStreamECM features, check out:
It's interesting to me that my last two trips that have been out of the country have been to China and Cuba, two communistsocialist countries. Being I'm a USA born, good ole boy from Oklahoma, we can just say that it was as eye opening as moving from Oklahoma to Seattle and getting "hit on" the first time by a gay guy, which isn't bad, just different!
A bit of my background…I grew up with almost nothing, worked hard and the wonderful U. S. of A provided and rewarded me based on that hard work. My mom worked hard and paid for everything from her job and the little child support dad gave us. From what I remember, food stamps kicked in at one time, so to say I never drank from the US Democratic faucet would be false. So, what does that have to do with anything? Cuba. What an eye opening experience, even more so than China as they seem to be some kind of mix of socialism and capitalism (unlike the pure socialism of Cuba). As you will see, its not practical for someone to be able to out grow your neighbors salary wise as the average salary in Cuba is right around $40, with developers making somewhere around $500/month. But the reality is they don't have to pay for their education, or their health care. Imagine that…you can take as many courses as you want, get as smart as you want…or be as lazy as you want. If only we could do that in the USA…
Getting to Cuba is very easy. You can buy a Visa online before you go, or at the point of departure (the actual flight to Cuba) you can buy it. You also need health insurance, although, being that health care is free, it was a bit odd at this was required. The price of your ticket currently includes $25 health insurance policy and your boarding pass serves as your insurance card. Be sure that you don't lose the second part of the Visa on your way back!
Most things in China are owned by the government, the hotel we stayed in for instance, the Hotel National, is owned by the government:
Although a nice hotel, it is old and run down. There are other hotels that offer much nicer rooms and amenities, but to have stayed in a hotel that some of the greats have stayed in…we will just say it was an experience you can't compare to anything else!
We walked down to the US Embassy which is only about half a mile from the hotel. Its on the water on the Malcon and its a very nice looking building:
Prices and Money:
There are two currencies in Cuba. The CUC and the CUP. The CUC is for tourists, the CUP is for the locals. You can pay with either if you have it, you just are likely to have CUCs. I never had an issue with someone paying change in CUP back, but you should be aware of it and this blog is very helpful. Net net is CUC are pictures of monuments, CUP are pics of individuals. The price to change out the US dollar was ok at the airport. The hotel was actually better by about .01. On the way out, I got back 99% of my USD from my CUC at the airport.
The prices in Cuba are soooo cheap! Most drinks (Mojito anyone?) are $5CUC at major hotels, if you venture out, you will find them for $2-3CUC and yes, they are super strong wherever you go!
The food in Cuba was amazing! There was not a single meal that I didn't like! The prices were soo cheap that I actually would buy 2 meals each time (yeah, I may look skinny, but I eat a lot!). By the way, a massive super yummy dinner for 9 of us at a sit down nice restaurant, was $130CUC. The one thing you need to realize about sites like TripAdvisor is that the reviews are made by tourists that come off of cruise ships and its a part of their excursion package. So if you try to go to one of these top 10 places, you will very likely be turned away as they book the entire venue for the excursion folks. Face control seems to work well, so we were lucky and actually got into some of the places by smiling and laughing a bit…once we the staff realized we weren't with the cruise ships, we got much better attention!
The people in Cuba were sooo nice! You can tell that not having to worry about getting an education, getting treated for a disease or sickness made them very carefree and easy going. As an aside, they created a vaccine for lung cancer, it makes sense as one of their major exports is tobacco! I was able to bring back some Cohiba Behikes (52/54/56). If you don't know what those are, you gotta look em up!
Just know that your hotel wifi will likely not be the same wifi as the public uses and the username/password you get for the RADIUS server won't work out on the open. I had 45 minutes left on the hotel wifi and could not log into the ETECSA wifi at the airport!
So…get this…my presentation was focused on "how to make money" in Cuba. You can find it here. Needless to say, making money in Cuba as a corporation is not something you will be able to do for quite some time. Locals are not allowed to start corporations, so as a programmer, you can't start a consulting company and hire people. The concept of a corporation doesn't really exist in Cuba. You have to get government approval for everything and as we painfully learned, you also need permits for tech gathering!
The people in Cuba do have a computer science based curriculum that teaches C#. They use Microsoft products. They don't have the best computers to run things on. Most computers are imported via family and friends. So most places aren't going to have some fancy server room where you can run the latest and greatest server OS and server based products. You also can't count on the network to support cloud services so don't even think about selling cloud services there. You have to have a local presence. Someone will need to build a co-lo facility to host all the major players. I'm sure it will be owned by the Cuban government. You'll just have to put your servers in it to get any decent bandwidth. Google is trying harder than all the others, but the progress is slow. There is a trial to doing broadband. I did see co-axel cables run all over, and there were lots of CAT5 cables run between houses…a lot of the cables were used for door bells though…LOL.
Kids are playing soccer everywhere! It was very hard for me to not actually get out and play (I have a torn ACL right now), but I did manage to get the courage to brave a fully tore ACL in front of a cool church (yeah those are my old Gucci soccer shoes):
McFly! McFly! Yeah, there are old cars everywhere and at times the smog was a bit unbearable, this guy seemed to make the best of it:
Cubans love their country! Some cools pics:
Get your drugs at a Harry Potter drug store! This place was deep inside Old Havana in what we would easily call a "run down" part:
Our trip home:
Getting home is easy, the airport is pretty fast, although I can see if there were a lot of people it might be a bit crowded at times. But we had no issues. The only issue we had was the flight path back home, evidentially we flew over a tornado:
Although the major business opportunities in Cuba are in the low teens, and "USCapitalism" like careers non-existent, the environment is fun and the people are amazingly smart and carefree. They live with what they have and make the best of it. Something that a majority of Americans need to learn to appreciate. As I came home and walked through my front door, I felt that appreciation for what I have (and what I don't have and have had), and all the opprotunities I have been given by being "born in the USA".
But at the same time, I felt really sorry for myself in having the wool pulled over my eyes with the stigma and residual of capitalism and how things really shouldn't be based solely on money and success, but on what you can contribute to your community, country and family. It's what you don't know you don't know…
Go to Cuba before it changes too much!
This is from a lab from the soon to be released Nintex End User Training courses. Its the first of its kind and I'll simply say, you will learn some fun stuff!
New Nintex Courses are coming!
Yup, Nintex is such a great product and it has been making so many strides in so many ways, I decided to go ahead and build a set of in-depth courses that cover just about everything you could possibly imagine about Nintex on-premises. Currently the Nintex customer base is focused on 2013, but many people are moving to 2016 and Office 365 so another set of courses is coming in mid-2017 to cover those technologies. The courses will become officially available in mid-February 2017, but I would love to have some testers that would like to get up to speed on Nintex quickly and get some free training if you give me feedback to cycle back in!
As some of you may be aware, Nintex has started to move its technology investments to cloud based applications. The new Nintex Hawkeye, Nintex Workflow Cloud (competitor to PowerApps) and other items in the pipeline are designed to leverage the benefites of the cloud. The new courses cover those technologies too (a first for Nintex courses)!
Nintex Subscription Pricing
In addition, ACS has become a Nintex Partner so we can sell you Nintex subscriptions. I'm not greedy so you can imagine the pricing will be pretty amazing, just drop me a line and I'll get you a quote! Not only that, but I'll even throw in free training courses with the purchase in most cases!
You can find out more about the courses here:
Fun, cool announcement to make.
PowerStreamECM, a tool I have built for large scale ECM legacy migrations now supports EXTREME Mode for Office 365!
Extreme mode takes advantage of the Azure to O365 path using the content deployment API methodologies of SharePoint. The fun interesting thing about Extreme mode is its designed to work with hard drive based deployments to Azure. Sending 1GB, 10GB, 100GB to Azure is ok…try sending 30TB, or even 100TB to Azure over standard network lines….it just doesn't work. Extreme mode allows you to partition your data across multiple drives and then send those drives to Azure for upload. The entire process takes about 2-4 weeks.
Once the data is loaded, you can then fire a secondary process to upload and modify any custom properties based on custom business rules to update the pre-loaded binaries.
Once uploaded, custom and 3rd party tools can apply the retention rules you are looking for to destroy old records or do eDiscovery. Unfortunately, the only thing about uploading 30-100TB of data is that O365 can't handle it well for certain features. That's where the experience of Hyper-scale design comes into play. We have built a set of rules and software that allows you to do hyper-scale O365 deployments easily (although, time always plays a factor in hyperscale, just look at big data)!
If you have an old ECM system that has over 30TB of data that you want to move to O365, give me a shout. I have seen it all at this point and can tell you what works and what doesn't!
Nintex earlier this year unveiled a community portal for community members to provide helpful contributions to the Nintex user base called Nintex XChange. It follows along with the "App marketplace" style of the Office 365 app store.
To date there are 80 contributions, here are my ratings (5 highest) on all of them with some extra data points at the end:
|3686||Uber Price Estimate UDA||Uber price estimate UDA…sweet!||5||Workflow Template;UDA||UDA||Nintex Workflow|
|3968||Data One 4 PowerShell||Woah…running Server Side OM in a Nintex Action…Cool! Comes with intellsense and everything…dang!||5||SharePoint Solution||Custom Action||Nintex Workflow|
|3949||Parsing XE.com data – UDA||Currency convertor UDA, nice!||4||UDA||UDA||Nintex Workflows|
|5896||Wunderlist UDAs for Nintex Workflow On-Prem||A UDA that wraps Wunderlist API REST Calls. Actually made me go sign up so I could check it out…interesting!||4||UDA||User Defined Action||Nintex Workflow|
|3894||Nintex Add-in for Outlook||Nintex Add in for outlook. A simple app that looks for links in an email to notify a person that it is a Lazy Approval task.||4||Add-In||Add-In||Nintex Workflow|
|3943||Visual Studio Post Deployment Script – ALCM||A VisualStudio Post Deployment script for deploying your Nintex Artifacts to SharePoint from Visual Studio. Very handy!||4||PowerShell||PowerShell||Windows|
|3903||Generate an HTML document with dynamic data||Interseting take on generating a document from metadata in HTML format||4||Workflow Template||Workflow||Nintex Workflow|
|3923||Iterate through documents in a Document Set||Workflow that iterates through all the files in a document set. Coolness…||4||Workflow Template||Workflow||Nintex Workflow|
|3925||Archiving a List Item with Workflow History||A UDA that backs up workflow history from one instance to another. Interesting pattern.||4|
|3936||Terminate Old Instances of a Workflow||A UDA to terminate old workflow instances. Interesting…||4||UDA||UDA||Nintex Workflow|
|3939||Convert Forms to PDF w/ Workflow||Convert a form to a PDF using workflow. Pretty sweet use of out of box technology.||4||Workflow Template||Workflow||Nintex Workflow; Nintex Forms|
|3706||Sending a TXT w/ Nintex Workflow||How to send a SMS with Twilio via a web request – nice!||4||Guide||Guide||Nintex Workflow|
|3723||Latitude and Longitude UDA||How to get Latitude and Longitude via web request – nice solution||4||UDA||UDA||Nintex Workflow|
|3607||Start Workflow with PowerShell||Useful powershell script to start a nintex workflow||4||PowerShell||PowerShell||Nintex Workflow|
|3729||Resetting Repeating Sections||A custom action to reset the items in a repeating section. This is actually pretty darn handy!||4||SharePoint Solution||Custom Action||Nintex Workflow|
|3876||Tab-based Layout Solution||How to make your forms tab based. Very helpful!||4||CSS||CSS||Nintex Forms|
|3892||Splitting Text – RegEx||Example of a regex usage in Nintex Workflow||3||Guide||Guide||Nintex Workflow|
|3858||Parsing Nintex Forms Repeating Section Solution – O365||A second type of master-child form using workflow to break out the items. This one is for Office 365. Similar to 3385.||3||Workflow Template||Workflow||Nintex O365|
|3859||Get Recurring Events – UDA||UDA to get recurring events…not bad…||3||Workflow Template||Workflow||Nintex Workflow|
|3847||Create Salesforce Lead via Nintex Workflow||Creates a SalesForce lead via Nintex Workflow||3||Guide||Guide||Nintex Workflow|
|3848||Dynamic approvers for douments||Workflow for doing dynamic approvals on a document. Another basic pattern, but helpful if you haven't seen the pattern before.||3||Workflow Template||Workflow||Nintex Workflow|
|3758||Nintex Form File Attachment Validation Settings||Nintex form that only allows an upload of PDF files||3||Nintex Form||Nintex Form||Nintex Forms|
|3385||Parent/Child Forms/Workflow Solution||An example of how to use the repeating section of a nintex form to drive list item creation via workflow. Pretty basic pattern, but useful if you haven't done it before.||3||Nintex Forms|
|3728||SAP Made Easy w/ Zimt||SAP Actions from Zimt||3||SharePoint Solution||Custom Actions||Nintex Workflows|
|3608||PowerShell Find All Workflows – Part 1||Shows how to get all the Nintex workflows via the NWAdmin tool. More for reporting than anything else.||3||PowerShell||PowerShell||Windows|
|3613||Safely purge items from history list – PowerShell||PowerShell script to purge the workflow history list.||3||PowerShell||PowerShell||Nintex Workflow|
|3940||Add a Site Workflow Link in O365||A way to add a link to Nintex Site Workflows to quick nav||3||Other||Other||SharePoint|
|3895||Replace Text – RegEx||An example of using regex to do a replacement||3||RegEx||RegEx||Nintex Workflow|
|4073||Layer2 Cloud Connector||A data connector for Nintex Workflow. Doesn't really give any helpful patterns of why you should buy/use it.||3||SharePoint Solution||Custom Action||Nintex Workflow|
|4137||Theobald Software – ERPConnect Services||Theobald Software – ERPConnect Services||3||SharePoint Solution||Custom Actions||Nintex Workflow|
|4017||Delete Attachments – UDA||UDA to delete attachments||3||UDA||UDA||Nintex Workflow|
|4018||What Changed – UDA||UDA for tracking what changed in an item||3||UDA||UDA||Nintex Workflow|
|4019||Random Number – UDA||A UDA that will generate a random number||3||UDA||User Defined Action||Nintex Workflow|
|4060||Panels UI Magic with Nintex Forms for Office 365||Another example of how to do a "Stepped" or "Paneled" nintex Form||3||CSS||CSS||Nintex Forms|
|4153||Action Task Reminder – Site Workflow||Another pattern around task reminders.||3||Workflow Template||Workflow||Nintex Workflow|
|4157||Remove Permissions UDA||UDA to remove permission down to read only||3||UDA||UDA||Nintex Workflow|
|4063||Simple email validation for forms||Basic email reg ex.||2||Regular Expression||Text||Nintex Forms|
|4147||Document Review and Approval (State Machine) Workflow||An example of a workflow to do review and approvals.||2||Workflow Template||Workflow||Nintex Workflow|
|3950||Document Review Reminder Process||Basic reminder pattern.||2||Workflow Template||Workflow||Nintex Workflow|
|5974||WYSIWYG Business Cards in Office 365 SharePoint Online using @Nintex Forms and Workflow apps for @Office365||A video of how to build a business card application with preview capabilites||2||Video||Video||Nintex Forms|
|6071||Trigger a Nintex Workflow from DropBox w/ Zapier||Just a walkthrough of connecting your external start to Nintex Workflow for DropBox/Zapier.||2||Guide||Guide||Nintex Workflow|
|6072||Trigger a Nintex Workflow from OneDrive w/ Zapier||Just a walkthrough of connecting your external start to Nintex Workflow for OneDrive/Zapier||2||Guide||Guide||Nintex Workflow|
|6073||Trigger a Nintex Workflow from Salesforce w/ Zapier||Just a walkthrough of connecting your external start to Nintex Workflow for SalesForce/Zapier||2||Guide||Guide||Nintex Workflow|
|6082||Trigger a Nintex Workflow from Zendesk w/ Zapier||Just a walkthrough of connecting your external start to Nintex Workflow for Zendesk/Zapier.||2||Guide||Guide||Nintex Workflow|
|3941||Upload ULS Logs to Doc Library – PowerShell||A powershell script to upload ULS logs. Kinda odd, but I guess?||2||PowerShell||PowerShell||Windows|
|3724||Hide Form Footer||How to hide the Nintex Form footer||2||CSS||CSS||Nintex Forms|
|3772||Birthday UDA||A UDA that figures out the day of the week you were born on. Fun, but not very useful.||2||UDA||UDA||Nintex Workflow|
|3797||Replace Empty String Variable||A UDA that will replace an empty string with something else. Hmmm…||2||UDA||UDA||Nintex Workflow|
|3798||Site Creation Workflow||Workflow to create a site.||2||Workflow Template||Workflow||Nintex Workflow|
|3853||Create user group in your SharePoint Site – UDA||A user defined function (UDF) for Nintex 2010 that allows you to create a SharePoint groups||2||UDA||User Defined Action||Nintex Workflow|
|3854||Remove user group from SharePoint Site – UDA||A user defined function (UDF) for Nintex 2010 that allows you to removew users from SharePoint groups||2||UDA||User Defined Action||Nintex Workflow|
|3855||Add user to a SharePoint group – UDA||A user defined function (UDF) for Nintex 2010 that allows you to add users to SharePoint groups||2||UDA||User Defined Action||Nintex Workflow|
|3856||Remove user from SharePoint group – UDA||Remove a user from SP Group||2||UDA||UDA||Nintex Workflow|
|3857||Math Power – UDA||Math Power UDA…funny comments…||2||UDA||UDA||Nintex Workflow|
|3893||Extract Text – RegEx||An example of how to run a regular expressions against some text. Not very helpful.||2||Other||Text||Nintex Workflow|
|3887||Sample Case Summary Template – Salesforce||SalesForce case study doc…for DrawLoop stuff…||2||Guide||Guide||Drawloop|
|3888||Sample Cover Letter Template – Drawloop||SalesForce case study doc…for DrawLoop stuff…||2||Guide||Guide||Drawloop|
|3889||Sample Quote Template – Drawloop||SalesForce case study doc…for DrawLoop stuff…||2||Guide||Guide||Drawloop|
|3590||Theobald SAP – Connector||Theobald SAP – Connector – looks like it has absoltely nothing valuable to do…||1||?||?||?|
|3614||<Xchange Template – Delete this field and replace with your title>||Hmm…nada here…||1||?||?||?|
|3948||Expense Report Solution – PointBeyond||supposed to be an expense form, but nothing here 🙁||1||Other||Other||Nintex Forms|
|3944||Build a Nintex form – pt 1 of 3||Simple tutorial – should probably not be in the XChange||1||Guide||Guide||Nintex Forms|
|3945||Build a Nintex form – pt 2 of 3||Simple tutorial – should probably not be in the XChange||1||Guide||Guide||Nintex Forms|
|3946||Build a Nintex form – pt 3 of 3||Simple tutorial – should probably not be in the XChange||1||Guide||Guide||Nintex Forms|
|6111||SharePlus & Nintex Integrated Solution : Introduction||Nothing but a 3rd party adverisement/marketing slick||1||Guide||Guide||Nintex Workflow;Nintex Forms|
|4209||Nintextionary – Nintex Actions Dictionary||Have no idea what this does or why it is posted. Doesn't seem to have any assets at all!||1||Other||Other||Nintex Workflow|
One of the hot features of Office 365 and "by inheritance" in SharePoint 2016 is Data Loss Prevention (DLP). DLP allows you to execute search queries on your content to find possible "Sensitive Data Types". You can find many blog post on how to setup DLP queries and how to find data, but that is at the high level. In this blog post, I get into the nitty gritty of how it actually works under the covers.
High Level Steps:
Deep Level Steps:
Most of the major work happens in the Ceres Flow. It uses a "configuration" file of sorts from the "Microsoft.Ceres.DataLossPrevention" .NET Assembly in the GAC. You will find a "defaultCLassificationRules" resource file in this assembly. This file is called a "RulePackage" and contains Rule Packs. Currently for SharePoint 2016, there is only one rule pack, Office 365 may have more. Opening this file you will find the following:
Here are some of the regular expressions that DLP flow is looking for:
Keywords are important for deciding the confidence level of a particular pattern. If a keyword is found, then the confidence goes up. Here are some examples:
Keep in mind that your SharePoint on-premises environment will always have a static rule pack unless you download and apply updates. Office 365 will continually get updated rule packs to enhance the DLP engine features so you will be more protected against sensitive data "leaks".
At the #MVPSummit I sat in a couple of Microsoft Bot Framework sessions. Cool stuff for sure! So I decided to write a helpful program for the MVP Program that lets you look up MVP data from your favorite messaging platforms!
Check it out via Consumer Skype here:
Phrases you can use:
Updated as of 11/20/2016 – Several MVPS updated their profiles to add their twitter handle or make it public.
Updated as of 11/5/2016 – Re-posted the list creation to keep list name under limit. Added the ability for you to clear out old twitter accounts!
***HEADSUP*** – this script may cause you to be throttled by Twitter. I have added some checking in the Http layer that will let you know if you hit their circuit breaker. If you hit the circuit breaker, just re-try in 24 hours.
Here is a list of every twitter account for every current Microsoft MVP. They fit into the following new MVP categories:
The "MVPFollow.zip" file contains a TwitterFollow.ps1 PowerShell script. Simply run it, enter your "username" and "password" and then tell it what MVP category you want to follow (or type "all") and whalla, you will follow all the Microsoft MVPs with twitter handles in their profiles!
If you were curious all the cool benefits of being an MVP : http://xavierdecoster.github.io/mvpperks/
*update* – the script now supports creating twitter lists (private and public). It will name the list as "mvp-*" and add the target MVP twitter user into that list. Also added in some more elegant error handling and follow checking.
Here's my list of all the announcements, updates and news worthy things from Ignite 2016!
I made it to many more sessions at this Ignite. With my busy schedule this past year it has been a bit tough to keep up with the ever changing Office 365 landscape. My focus has changed to watching for the things they do in the cloud as many of these changes will trickle down to SharePoint on-premises at some point. Of the sessions I went too, only two ended up being a waste of time (simply because I had already been aware of the things going on, but thought maybe something new might be revealed).
Overall the venue was great, the buses were on time and timely. The city was great, Uber was available and not expensive. Lots of things to do in terms of entertainment and restaurants and the hotels were all fairly close together. The venue was just as large as last year's in Chicago. I'm thinking next time they should figure out a way to give an award to the person that walks the most, but since the Microsoft Band is now no more, might be difficult to track it! I know my feet hurt at the end of every day!
Food was bad as expected. If you have ever done a large event (such as an SharePoint Saturday) and rented a large venue such as a convention center, you will know the painfulness that is contracting with the venue's food vendors. Like the Amtrak days with its kick your butt if you say anything unions, Its unfortunate that we still are forced to endure not so great food (and evidently not much of it). I think it would be great is Microsoft offered a non-meal pass in the future so we can spare ourselves the disappointment and at least get a good meal on our own terms. Or even send us the link to the vendor's site so we can drop them lots of nasty notes rather than blame Microsoft!
I was able to find time to wonder the entire Expo hall. I always try to do this just to see what people are marketing and "trying" to sell. There was a very heavy theme on "Monitoring" and "Security". As in…at least half of the companies were promoting between those two themes. In whole, the exhibitors seemed to fall into these major categories:
CoolInteresting booths from my standpoint:
ConversationalGeek – new
spin on books and marketing promotions.
Each book is sponsored by a company and then distributed for free!
Lots of great sessions this time around. I couldn't really say that about last year, but as you might be able to figure out, many of the top SharePoint community members (Dan Holme, Chris McNulty, etc) have recently joined the Microsoft team and have been able to share their views from the outside with the product marketing and engineering teams. Although not everyone has stayed in the Office group, it has been fun to watch them learn about the massive engine that is Microsoft and how difficult it is to move the mother ship! I'm sure they have also gleaned the interesting side of taking "suggestions" from the community and who has a valuable opinion and who doesn't! I'll still at some point find time to do my "famous" or "infamous" I suppose rating of all the sessions in the next few weeks. I can say right now, the top session I attended was by Neil Hodgkinson (@nellymo). His sessions are always filled with great data points, goodgreat demos and seem to leave you full-filled with something afterwards! I highly suggest you watch any session he was in!
It seemed that a lot of the sessions were not very in depth and super technical (which is the stuff I love). I would have preferred a lot more 400 level sessions and not so much of the 200 level sessions.
You can download sessions from Channel9 or YouTube! You can also use this powershell script to download them!
Here is a list of the various announcementsupdatesdetails that I was able to gather from Ignite 2016.
Other Ignite Reviews:
Enjoy, see you in Orlando in 2017! You can pre-register here!