Substring in InfoPath

To get a value AFTER a charactersubstring-after(FieldName, “;”)This will return all text after the character ; To get a value BEFORE a character substring-after(FieldName, “;”)This will return all text before the character ; Substring and Concatenate I often use Concatenate to join text from two fields. For example, the Date function now() has a “T” between Date …

Working with Date formats in InfoPath

To extract the day number of a date number(substring(DateField, 9, 2)) To extract the month number of a datenumber(substring(DateField, 6, 2)) To extract the year number of a datenumber(substring(DateField, 1, 4)) Calculate hours addSeconds(now(), 7200) Get the month name from a date (and time) field =TEXT([DateField];”mmmm”) Get three characters of the month name=TEXT([DateField];”mmm”) Sort or group …

Error in the personal information on MySite

If you see this error on the MySite and personal information page: “There was a problem retrieving data for this field. Updating values in this field is disabled temporarily. You can still update values in other fields.” Then something is wrong with the Managed Metadata Service. Clicked on the service app for Managed Metadata service …

Form has been closed

This post is more for my own memory, since I tend to forget how I solved it when I get this message “Form has been closed” when submitting browser forms in InfoPath 🙂 Scenario is the following:You have a mail view that you wish to mail instead of the default Edit form, so that you …

Installation of Windows 8

Today I installed Windows 8 on my laptop. It was very fast and easy, I did these steps: Booted on USB Since I ran a Home Edition of Windows 7, I was not able to select “Upgrade” since I am installing an Enterprise version. So it had to be “Custom: Install Windows only (advanced)” which …

New setting for AD import

Use SharePoint Active Directory Import – User Profiles Instead of using the default setting of synchronization of User Profiles, you can select the “Use SharePoint Active Directory Import” setting. Which is a lighter version and which only imports information from the AD. If you had a connection before, it is lost when you click on …

Noderunner.exe

My SP2013 server was getting slower and slower and I could not even create a site collection anymore, so I looked into Task Manager and the processes. Found a new one, noderunner.exe, and it was consuming a lot of CPU That process is the Search service, with a new process name. Restarted the SharePoint Search Host Controller service and the performance looked a bit …

Limits and restrictions in SP2013

Most intranets I have worked with are used more or less as a file server (I struggle hard with getting users to organize the files with tags rather than folders, but users are lazy and they often end up dragging files directly from the file server with folder structures that are huge), so the content db often grows …