Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x

Microsoft SharePoint

37K

Solutions

19K

Contributors

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Share tech news, updates, or what's on your mind.

Sign up to Post

Not sure if this is the right place!  I installed SharePoint 2016 on a 2016 Server for a client.  Then they got crypto on their mail server so I installed Exchange 2016 on the server as well.  I rebuilt the old mail server and migrated the mailboxes.  Started working on SharePoint and realized it wouldn't work with SQL 2008 R2,so I uninstalled SP2016 and installed SP2013 - couldn't get it to search, conflict with the timer service installed by SP2016 or something in Exchange 2016 so I uninstalled both.  Have tried to reinstall SP2013 but can't get into Central Admin or any other sites in iis.  Am about to scrub the server and start over.  Does anyone know how to completely manually remove all SharePoint stuff so I can start over with a fresh install.  Any other advice would be great
0
Get quick recovery of individual SharePoint items
LVL 1
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

I'm configuring RBS in our system with SharePoint Server 2016 and SQL Server 2014 SP2 Enterprise.
The article we're following: https://technet.microsoft.com/en-us/library/ee748631(v=office.16).aspx
Our system has:
- 1 DB Server with SQL Server 2014 SP2 Enterprise
- 3 SharePoint Servers 2016 Enterprise as farm

When we following article from Technet above, when we run at step "To install the RBS client library on the on the first Front-end or Application server", we used RBS.msi file download from Microsoft SQL Server 2014 SP2 Feature Pack (https://www.microsoft.com/en-us/download/details.aspx?id=53164) but it cannot completed.

When we checked in Content Database we configured, the tables need for RBS wasn't created.

The log file in attachment.

Please help us on this issue. Thank-you very much!
0
Is there not some web service or worst case library based API to query sharepoint lists and libraries similar to SQL?

I’ve only been able to find fairly obtuse ways of doing this and in reality the basis for these are sql server relational dB tables.

And I do mean querying to sharepoint not the tables behind it.  I have SP Online sites and I only have acces to SP not the DB behind it.
0
Hi, I need a SP2013 calendar with three main categories: Department, Events and Other. This part I can achieve by creating 3 calendars and using overlays to combine them into a single view.
But then I need subcategories of John, Hayley, Mary and Victor for each of the 3 main categories so if I create a calendar entry for Events for example, I can associate John and Hayley to the entry.
How can I then create a view for each of the subcategories e.g. a view for John that shows all items where John is associated for Department, Events and Other?
0
I'm struggling with overcoming the 5000 document limit on libraries for SharePoint O365.

We're using the Document Center flavor of SharePoint and had thought that we could configure it to support greater than 5,000 documents (if we used indexes on key metadata fields) to 20,000 (or ideally even more) documents per library.

It doesn't seem that's the case.  There's a note with the articles we've found where SharePoint OnLine doesn't support doing this (whereas all non-MS hosted SparePoint versions do).

Is this a limit we can't adjust to 20,000 with SharePoint O365 or are we just missing on where we can modify it?
0
I am using SharePoint 2013.  

I am using Handlebars to display my SharePoint list into a table, which works.  But when I try to turn it into a dataTable, it does not transform into a dataTable.  I was able to do it in jsFiddle and it works.  Can you see what I am doing wrong?  

siteAdmin.html
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<!-- Handlebar Js Template Starts Here --> 
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/handlebars.js/4.0.10/handlebars.min.js"></script>   
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.18.1/moment.min.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js"></script>
<script type="text/javascript" src="http://understandsp.com/spdev/SiteAssets/siteAdmins.js"></script>

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/datatables/1.10.16/css/jquery.dataTables.css" />
<script id="siteadmin-template" type="text/x-handlebars-template">
 
<table border=1 width="100%" id="example" class="display"> 
<thead>
	<tr>
		<th>Picture</th>
		<th>First Name</th>
		<th>Last Name</th>
		<th>Email</th>
		<th>Phone</th>
	</tr>

Open in new window

0
Hi,

I have a SharePoint 2013 list.
In it I have "1" column type Choice with values a1, a2, a3, b1, b2, b3, c1, c2, c3.
I would like to make calculated column "2" where, when I choose a1 or a2 or a3 the value is "a", if a choose b1or b2 od b3, the value is "b "and if I choose c1 or c2 or c3 the value is "c".
I tried with formula:
=IF(OR([1]="a1",[1]="a2",[1]="a3"),"a","b") , but it is functioning only for 2 values - combinations of "a" and "b", "a" and "c", or "b" and "c" , not for all of them.
Is there a way to do this?
Can you help me with the correct syntax?

Thanks in advance
0
Trying to create a List called 'Contact List' on a SharePoint site, https://mainsite.sharepoint.com/sites/Client/List/ContactList, that has a number of columns (Phone -single line of text w/ length 12, Notes - multiple lines of text, Position - managed metadata, Active -
 Yes/No, Sign Date - Date (Date Only))  and I can create the list via PowerShell PnP but I cannot create the columns no matter what I have tired.  I am using SharePoint Online and Powershell Pnp.  I cannot find one place with an example that will work.  Does anyone know of a web site of examples or have an example they can share?

Thanks,
John
0
Hi,

We have a client who has moved their file structure to Sharepoint. They have a file structure that holds their products and want to share these folders with clients.

I can see that you can share individual folders but when I highlight more than 1 folder the 'Share' option blacks out.

Is there a way of sharing multiple folders?
0
We rely heavily on an Access database within our team to control actions that we need to undertake.  This is basically recording the action to be undertaken, its status, its completion by date and a progress log.  The action to be undertaken and completion by date remains static but the users assigned to the action are responsible for updating the status and progress log.
The database is secured on a share file so no other departments can gain access.  As a result the database doesn’t utilise usernames or passwords.  Instead there is a table of network usernames and the email addresses (so email reminders can be sent), it’s a static team of about 10 people so doesn’t require any maintenance.  There is then a procedure when the database loads that determines the windows username the user has logged in with and uses this to filter the actions only allocated to them (=environ("username").  Actions are assigned to the users username basically.

The problem we have is that we are starting to allocate these actions to people outside our department.  The current process which is now separate to the above is that the action is set to an email address and when the completion by date is passed, an email is sent asking them for an update on progress.  Once this update has been received by our department, someone must manually go and update the records based on the email response.  This is becoming a more time consuming task as we asign more and more actions to people outside our …
0
What does it mean to be "Always On"?
LVL 5
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

We rely heavily on an Access database within our team to control actions that we need to undertake.  This is basically recording the action to be undertaken, its status, its completion by date and a progress log.  The action to be undertaken and completion by date remains static but the users assigned to the action are responsible for updating the status and progress log.
The database is secured on a share file so no other departments can gain access.  As a result the database doesn’t utilise usernames or passwords.  Instead there is a table of network usernames and the email addresses (so email reminders can be sent), it’s a static team of about 10 people so doesn’t require any maintenance.  There is then a procedure when the database loads that determines the windows username the user has logged in with and uses this to filter the actions only allocated to them (=environ("username").  Actions are assigned to the users username basically.

The problem we have is that we are starting to allocate these actions to people outside our department.  The current process which is now separate to the above is that the action is set to an email address and when the completion by date is passed, an email is sent asking them for an update on progress.  Once this update has been received by our department, someone must manually go and update the records based on the email response.  This is becoming a more time consuming task as we asign more and more actions to people outside our …
0
We installed windows updates on server 2008 R2 with SharePoint 2010. Everyone has their assigned permission but no one can upload or modify intranet. When we are trying to modify it give us read only access but when we are checking the actual permission we have admin privileges..

Regards
0
We are in the process of Migrating from On-Premise Exchange and Sharepoint to Office 365 with Sharepoint.

We currently have an On-Premise Sharepoint 2013 Servers. We host Mail and Sharepoint for a few Companies, so the Sharepoint server is home to several Root level Sites:
team.domain-A.com
team.domain-B.com
team.domain-C.com
team.domain-D.com

Each root site is Managed by their own Administrators and the users are different for each site.
All users are part of the same Activity Directory Domain.
I have all of the domains Validated in Office 365 and mail is flowing to all of them.

I just dont see where I can Add a new Root level Domain  and separate site for each of the existing sites I have.
0
We have an O365 environment with Sharepoint for shared files and OneDrive for redirected folders.  However, on one user's computer, the old OneDrive for Business client will not install and there is an icon in Explorer for OneDrive - <TenantName> where the user's profile folders are properly redirected and show up.  However, there is also a OneDrive link in windows explorer that links to C:\users\<user>\OneDrive (not in use) above the OneDrive - <TenantName> (C:\Users\<user>\OneDrive - <TenantName>).  How do I either completely uninstall the old OneDrive for Business client or at a minimum remove the old link from explorer?  Reinstalling the latest OneDrive client fixed the library locations and default Documents link in Explorer, but there's still the old OneDrive that could cause the user confusion.

Thanks,
Patrick
0
Experts,

I've created a highly customized task list, saved it as a list template, and am now trying to deploy it to other sites. The default new form and default edit form pages for the list both have custom web parts deployed on the pages. When I deploy the list, the web part on each of the pages has been removed. For each deployment of the list, I have to manually edit the new form and edit form pages and add the web parts back in. Does anyone know why this is, or if there's a way around this?

Many thanks in advance for any help with this.
0
I have setup three columns, one number, two calculated.  Seq (number), NextNum(calculated Seq+1), SerNum(calculated conat"text"&000&NextNum

What I am trying to do in sharepoint with a workflow or any other suggestion is to set the seq to the next in a seq based on SerNum as it will start with 0 in seq but use the Max NextNum for seq when a new item is entered but a different type EX: (I am using submit to start WF in the infopath form)

Type      Seq                  NextNum                 SerNum
999                0                              =B2+1     =CONCATENATE(A2,"_","000",C2)
999      =IF(A3=A2,B2+1,0)      =B3+1      =CONCATENATE(A3,"_","000",C3)
999      =IF(A4=A3,B3+1,0)      =B4+1      =CONCATENATE(A4,"_","000",C4)
777      =IF(A5=A4,B4+1,0)      =B5+1      =CONCATENATE(A5,"_","000",C5)
777      =IF(A6=A5,B5+1,0)      =B6+1      =CONCATENATE(A6,"_","000",C6)
777      =IF(A7=A6,B6+1,0)      =B7+1      =CONCATENATE(A7,"_","000",C7)
777      =IF(A8=A7,B7+1,0)      =B8+1      =CONCATENATE(A8,"_","000",C8)
888      =IF(A9=A8,B8+1,0)      =B9+1      =CONCATENATE(A9,"_","000",C9)
888      =IF(A10=A9,B9+1,0)      =B10+1      =CONCATENATE(A10,"_","000",C10)
999      =IF(A11=A10,B10+1,0)      =B11+1      =CONCATENATE(A11,"_","000",C11)
 with results:
Type      Seq      NextNum      SerNum
999                  0             1             999_0001
999                  1              2             999_0002
999                  2             3             999_0003
777              0             1             777_0001
777                  1             2             777_0002
777                  2             3             777_0003
777                  3             4             777_0004
888                  0             1            …
0
I want to install a single sharepoint server (VM) on my network, for 20 users. I need to know the following;

1.How many cores are recommended?
2. How much RAM is recommended?
3. Other than 2012R2 server are there any other prerequisites that need to be purchased?
4. How is Shareppoint server pricing structured?
Any additional information will be welcomed as I am sure i am missing something
0
Edited:
I solved this by using string-length: concat(substring("Yes", 1, (string-length(myFields/LookupColA) > 0) * string-length("Yes")), substring("No", 1, (string-length(myFields/LookupColA) = 0) * string-length("No")))

Original:
I have an InfoPath form on a SharePoint list.  One of the cols in the list is a lookup col. I want to display "Yes" if the list's item is connected to the other list and "No" if it is not.

I used: concat(substring("Yes", 1, (myFields/LookupColA != 0) * string-length("Yes")), substring("No", 1, (myFields/LookupColA = 0) * string-length("No"))). The result is Yes even if no lookup was set for the item. I displayed the value and it is a number if the lookup was set and what appears to be null if not.

What should my formula be to work?
0
Hi Expert

I need your help to create a workflow and a form (using Infopath and SharePoint List )  for Leave request approval.

I need to apply a workflow/List/Infopath form that process like below:

1. After the user fill-out and save the Leave application form, it will automatically start the workflow.

2. Send a notification email to the APPROVER (e.g. Manager), then APPROVER will Approve or Reject the request.

IF Approved, it will automatically send a notification email to HR Department regarding the request.

IF Rejected, the requester will received an email of rejection.

Using SharePoint Designer 2013 to create a Worlflow.

Thanks in advance
0
Become an Android App Developer
LVL 11
Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

When accessing a sharepoint site on our intranet some users see a popup box asking them to enter their credentials.  When they enter credentials the box reappears.  After several attempts they will see an error 410- unauthorized access.

In our environment we have two domains, say Lemon and Peach.    Users in the Peach domain can always access sharepoint OK.  Users in  the Lemon domain can only access sharepoint from a Lemon domain PC.  eg

                    User domain
                 Lemon    Peach
PC domain
Lemon           OK       OK    
Peach             Fail     OK


Can anyone give some clues about how to solve this?


Cheers

Simon
0
Hi, We have a site that we want to make into a template. it uses a SPFX app that we have built ourselves.

When trying to save the site as a template, we get the  error "Sorry, this site can't be saved as a template. It contains apps that don't work in templates".

I understand that this is because the site is using the app. i know the solution is to not use the app, then export it as a template.

my question is - are there any work around? is there anything we can do in the app to allow it to be exported in a template? We assume not as we understand that the template can be used anywhere - even on a different SP instance, where the app would not exist.

the template in this instance is simply to provision new subsites on the same SP instance. we Ideally don't want the admin to have to add the app (in reality there are 5) and then add the app to the 8 or so pages they want them in manually.

is there any work around that we can use? I guess we could deploy the apps via code, but that would not update the content of the pages and add the apps into the pages.

i expect the answer to be "no" but thought it's worth a qucik query as someone might have a good procedure if not a work around.
0
Hi Experts,

Please see attached. We have an SP site that links to a site that allows our HR dept to create a new user request. All users can access the site but no function buttons. We need to assign specific users to have access to the function buttons but don't know how. Browsed in IIS Right click the site (folder) add full access under under security, added the user as a contributor to the site. Not sure if this is share point or something different we need to do. We as administrators have access to the site with the functions buttons. As a baseline, we have one user that has access to the function buttons but cannot locate any folder or site or anything where we find his name to add an additional user. Any help would be appreciated.
SP-button1.JPG
SP-button2.JPG
0
Is it possible to actively sync a SharePoint list to a Microsoft SQL Database?
0
Hello,

I'm having trouble adding the Wiki Library app my SharePoint site. When attempting to search for app in SharePoint Store, app does not appear. I've attempted to make test sites to see if I am able to search for it but no luck.

Had a co-worker of mine create a page and then searched for app on that new test site and we were able to search for it. Went back to our SharePoint site to see if he could search for it and add but still wouldn't appear.

I also tried to search the SharePoint Store page by page in all categories by name but I dont get a full listing of apps. It stops around the letter D section.

Any ideas?
0
I have set up a list in SharePoint with about ten columns. All of the columns except one can be answered with one to four words. Therefore, they take up little room in the list.

One of the columns, which asks for upgraded information, can take, say, 280 characters. When you save it, the comment just goes out to the right in one long paragraph. If you open in Excel or another program, it shows up in a wraparound format, which means I can see everything to the right of it on one page. Now, you have to scroll over. I suppose I could move it to the end.

I realize if it saved with the comments in four lines, for example, entries would take up four lines.

This seems like a huge limitation in SharePoint. As an FYI, I will be switching to O365 with SP in the cloud soon. Thanks for any help.
0

Microsoft SharePoint

37K

Solutions

19K

Contributors

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.