Create entry limitations on SharePoint 2013 Calendar

Date fields do not have a minimum or maximum date property (like numbers).

Depending on your requirements you could probably do something with the validation property.
An example where someone posted an answer to validate the end date not being later than 30 days after the start date: date column validation

more info on date validations:
https://social.technet.microsoft.com/Forums/office/en-US/b4a57b7c-0938-42d8-96f6-f7e6ef21876d/custom-validation-in-sharepoint-2010-list-for-datetime-columns?forum=sharepointgeneralprevious

Formulas

  • You can only compare column values to one another in a list level validation.
  • A validation formula at the column level cannot include any other columns besides itself. For example, (Column1)>(Column2) is an invalid
    formula and SharePoint will not allow it to be used at the column
    level. In this case, you want to use list-level validation.
  • There is only one formula available at the list level.
  • The formula syntax is similar to that used in Calculated Columns

There are a few dozen functions available – I have not tried every
one. One interesting thing to note is that SharePoint 2010 would not
allow me to use the TODAY function, even when validating a Date field.
(DateColumn)>TODAY is not a valid validation formula.

The validation is effective for every user. If you want to make a difference per user (so user x gets date 1-3 and user y gets date 4-6) this will be much harder.

If the validation property won’t meet your requirements, perhaps Javascript can help you.

Javascript- Do something on date change in Datetime field- Newform.aspx https://social.technet.microsoft.com/Forums/sharepoint/en-US/3e7f06a8-2850-4f8b-966c-ade15667d588/javascript-do-something-on-date-change-in-datetime-field-newformaspx

caml query – using SSRS to generate a report based on a Calendar in Sharepoint 2013

We use the calendar in SP2013 to collect information when a user is away on holiday and when there will be any visitors. It works fine as a calendar but now struggling to generate a report in SSRS to show all the days when on holiday.

Example; this is what calendar looks like in SP2013

enter image description here

I am struggling to show all the consecutive days from Friday 03/02/2017 until 17/02/2017.
In this case, the Reports is just pulling the start date =Fields!Start_Time.Value

enter image description here

enter image description here

As you can see, from the result above, it does not show all the consecutive days but only the start time. Yes, you may say “…well you specified to show from the start time” but my question is here how to modify it so it shows HOLIDAY on all the dates relative to the start & end date.

Any ideas / suggestions?

The SSRS Query Type is as following:

<RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <ListName>Staff Movements</ListName>
  <ViewFields>
    <FieldRef Name="Title" />
    <FieldRef Name="Location" />
    <FieldRef Name="EventDate" />
    <FieldRef Name="EndDate" />
    <FieldRef Name="Category" />
    <FieldRef Name="User" />
    <FieldRef Name="Department" />
    <FieldRef Name="Position" />
    <FieldRef Name="Visitors_x0020_Name" />
    <FieldRef Name="Visitors_x0020_Business" />
    <FieldRef Name="Visitors_x0020_purpose" />
    <FieldRef Name="Visitors_x0020_Visiting" />
    <FieldRef Name="Created" />
  </ViewFields>
</RSSharePointList>

SharePoint 2013 Workflow to Send Email When Item is Changed in a Specific Column

I am trying to make a tracker on SharePoint for when items are delivered.

I have a list that has the columns (Name, Category, Prize, and a hidden column that requires input in the submission form for the list called Delivered.) As of now, the default entry is “No” for the delivered column. For tracking purposes, I want to have an email automatically send once that entry is changed from No to Yes. Saying that the Current Item: Name’ prize has been delivered.

I have it partially working. It sends the current email that I have after any item is changed in the list. Can I specify it down to the one choice column? Only send this email when Delivered is changed from No to Yes?

The way I have my workflow set up is as follows:

Stage 1: Check List

–> Wait for Event: When an item is changed(in the List Weekly Winner) (Output to Variable: related item)

–> Transition to stage email

Stage 2: Email

–> Sends me an email (but when any item is changed and it can even be changed from yes to no and it will still send)

sharepoint designer – How to modify list from InfoPath 2013

I am trying to modify a list made in Sharepoint Designer 2013 so when I go to the Design Form option in InfoPath I get the following error:

InfoPath cannot generate a form template for the Sharepoint list

Inside the box I have the following details

Form customization is not supported for this SharePoint list.

Additional to Sharepoint Designer 2013 I found this Sharepoint Online configuration:

enter image description here

Inplace upgrad 2008R2 SQL Server to 2014 for SharePoint 2013

I currently have 2 Windows 2012 servers to support a 2013 SharePoint environment. One server has 2008R2 SQL on it, and the other server has SharePoint 2013. Both of these servers are virtual machines and due to time constraints I would like to do an “in-place” upgrade with no changes. Is this possible and what should I look out for? Thx!

Need script solution for SharePoint 2013 list? It returns all names vs just the active ones

Anyone have a solution as to what is missing in this script: It returns all the names in the list vs just the active ones?
enter image description here

2013 – Paste a url together with title (Display Text) in Quick Edit mode

I have several hundred urls I need to paste in to a Sharepoint list. I can paste the urls with no problem, but I need to paste in a Title too (or ‘Display Text’ to give the exact system name for the field). I like to be able to paste in the ‘Display Text’ at the same time as pasting the url. I’m working in Edit / Quick Edit mode, rather than the standard mode.

When in Edit mode, I can click in the url field and it will allow me to manually type in the Display Text, but that’ll take ages and cause me to lose the will to live.

Image of list item, showing the url column

Research

I’ve found a couple of posts with proposed solutions, neither of which work for me.

Link 1 and Link 2. This third link also looked useful, it involves using a workflow. *New addition: Link 4 and Link 6. (No, there’s no Link 5).

Link 2 Results

The second of the links above looked especially promising. In Excel I pasted in the formula they’ve used:

=CONCATENATE(“”””,B2,””””,”, “,””””,,A2,””””)

Yet the result I get is a #NAME? error.

Here’s a screenshot of what I see in Excel. The formula looks ok to, Excel appears happy to accept it, yet gives a bad result.

Excel picture with Concatenate formula

Link 3 Results

The workflow failed to paste the values correctly; the display text contains both the url and the ‘Display Text’.

Picture of failed url, created by workflow

result of using the workflow option

Link 4 Results

THis post has two answers, Sergei’s accepted answer has since been deprecated by Microsoft (html no longer permitted in calculated columns). I tried out the second answer, by using a calculated column, but this only returned the value of the text field I’m using as a title for the url.

5. Ganesh’s suggestion

Thanks for posting Ganesh. I tried out this method, I’m using Excel. Please note the formula that created the url. As you see in the 2nd and 3rd pictures below, the value ‘I am the Title’ is posted to both fields, the url has not been pasted in.

enter image description here
enter image description here
enter image description here

Link 6 Results

(I don’t have the correct version of Access to be able to attempt this method by Daniel Šmon, but am posting for reference for others facing the same issue as me. Yes, I’m selfless I know I know…)

error – Sharepoint 2013 PostSetup System.NullReferenceException after upgrade

I have SharePoint 2013 with build number = 15.0.4569.1506 now we have installed November 2018 CU, but when i run the product configuration wizard i got the following exception on step 8 out of 9:

enter image description here

I tried many things what I found on the internet but none of them has worked

Here is the part of the related logs.

02/20/2021 10:29:04 19 INF Leaving function StringResourceManager.GetResourceString
02/20/2021 10:29:04 19 WRN Unable to create a Service Connection Point in the current Active Directory domain. Verify that the SharePoint container exists in the current domain and that you have rights to write to it.
Microsoft.SharePoint.SPException: The object LDAP://CN=Microsoft SharePoint Products,CN=System,DC=dhphbud01,DC=hph,DC=int doesn’t exist in the directory.
at Microsoft.SharePoint.Administration.SPServiceConnectionPoint.Ensure(String serviceBindingInformation)
at Microsoft.SharePoint.PostSetupConfiguration.UpgradeTask.Run()
02/20/2021 10:29:24 19 INF Entering function TaskCommon.TraceToPsconfigLogAndUpgradeManagerLog
02/20/2021 10:29:24 19 INF Not spawning off the upgrade job, but rather running upgrade synchronously by calling SPFarm.Local.Upgrade() for inplace upgrade
02/20/2021 10:29:24 19 INF Leaving function TaskCommon.TraceToPsconfigLogAndUpgradeManagerLog
02/20/2021 10:30:15 19 ERR Task upgrade has failed with an unknown exception
02/20/2021 10:30:15 19 ERR Exception: System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.SharePoint.Upgrade.SPContentDatabaseIntegrity.CheckAppOrphans()
at Microsoft.SharePoint.Upgrade.SPContentDatabaseIntegrity.Check(SPContentDatabaseIntegrityCheckOptions options)
at Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence.ContentDatabaseDataIntegrityCheck()
at Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence.PreUpgrade()
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.Upgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Administration.SPPersistedUpgradableObject.Upgrade(Boolean recursively)
at Microsoft.SharePoint.Administration.SPDatabase.Upgrade(Boolean recursively)
at Microsoft.SharePoint.Administration.SPContentDatabase.<>c__DisplayClass2.b__0()
at Microsoft.SharePoint.SPSecurity.RunAsUser(SPUserToken userToken, Boolean bResetContext, WaitCallback code, Object param)
at Microsoft.SharePoint.Administration.SPContentDatabase.Upgrade(Boolean recursively)
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.ReflexiveUpgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.Upgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Administration.SPPersistedUpgradableObject.Upgrade(Boolean recursively)
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.ReflexiveUpgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.Upgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Administration.SPPersistedUpgradableObject.Upgrade(Boolean recursively)
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.ReflexiveUpgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.Upgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Administration.SPPersistedUpgradableObject.Upgrade(Boolean recursively)
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.ReflexiveUpgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.Upgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Administration.SPPersistedUpgradableObject.Upgrade(Boolean recursively)
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.ReflexiveUpgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.Upgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.PostSetupConfiguration.UpgradeTask.Run()
at Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask()

Is there any chance to fix this problem? :S

boot loop – Nexus 7 2013 – stuck at android is starting optimizing apps. trying adb to get the data

I have a 2013 model Nexus 7.
It is running 6.0.1, unmodified with locked bootloader. USB debugging is on.

Battery drained to 0. Charged then the device is stuck on boot loop .. android is optimizing app X of x.
I don’t wanna lose the data so I’ve avoided hard reset.

  • I’ve wiped cache more than once.

  • I tried ADB Commands .. and while on the android is starting I can list the device and I can list the directoies ..

  • Tried adb pull /
    and it return this message.

    c:Adb>adb pull /

    • daemon not running; starting now at tcp:5037
    • daemon started successfully adb: warning: stat failed for path /proc/self/task/1208/root/proc/self/task/1208/root/proc/self/task/1208/root/proc/self/task/1208/root/proc/self/task/1208/root/proc/self/task/1208/root/proc/self/task/1208/root/proc/self/task/1208/root/proc/self/task/1208/root/proc/self/task/1208/root/proc/self/task/1208/root/proc/self/task/1208/root/proc/self/task/1208/root/proc/self/task/1208/root/proc/self/task/1208/root/proc/self/task/1208/root/proc/self/task/1208/root/proc/self/task/1208/root/proc/self/task/1208/root/proc/self/task/1208/root/proc/222/task/1208/fd/15:
      Protocol not available

Tried shell to see if I can list folders and

Adb shell ls /sdcard/sdcard
it returns the same message.

c:Adb>adb shell ls /mnt

asec

expand

media_rw

obb

runtime

sdcard *******************

secure

user

c:Adb>adb shell ls /mnt/sdcard/
/mnt/sdcard/: No such file or directory

Is there any way that I can retrieve the data before hard resetting .. through adb or custom recovery .. or whatever.

Sharepoint 2013 Version History Export

I have a follow up question regarding this solution:
Exporting item list version history

I used this method and it worked on a very small list, maybe 10 items.

I tried the same method on a large list, 4000 items and I get and error:

Error
Cannot complete this action.

Please try again.

Troubleshoot issues with Microsoft SharePoint Foundation.

I don’t have powershell access so I’m looking for any other suggested solutions. Perhaps using MS Access? or simply figuring out why the solution above works for small lists and not large lists, even when the view is limited to only 100 items.

Thanks.

EDIT 1:
Upon further investigation, it appears to be a limit based on the number of columns in the SharePoint list. Not the columns in the view, but total columns in the list. I’ve tried the method on a list with 1000+ items but only 4 columns, this worked without any issue. My understanding is that the XML Version history option only works on lists with fewer than 30 columns. I also believe this includes the default columns that are pre-populated by SharePoint depending on the type of list you created.

I’m going to test this in about 10 days when I am able to delete some columns from the list I am working with. If it works, I will report back.