Microsoft SharePoint

36K

Solutions

40

Articles & Videos

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

Hi,

Is there a simple way to expose the Accounts from our CRM Online on our SharePoint Online? I would like to be able to add custom columns on Libraries where I can select the Account from a drop-down list.

I would expect this to be pretty simple and straightforward but Microsoft does surprise us negatively quite regularly.
0
Independent Software Vendors: We Want Your Opinion
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Hi All,

We're a care company with a standard file server with X amount of mapped drives per department (and a shared 'Z' drive).

We are wanting to migrate over to O365 and I've had conflicting advice on weather to move to Onedrive for Business or Sharepoint.

My first question would be which one would you guys recommend ? And are there any reasonably priced tools to assist.

The ultimate goal as our users are not technically minded would be the ability to re-map the network drives to the new Sharepoint / Onedrive for each of the 'drives' so the end users doesn't really notice too much difference.

I know there are companies out there who charge thousands to manage the process but having done the migration thus far from Exchange / AD to O365 I'd like to tackle this myself.

Many thanks,
Shaun Okeefe
0
I created an InfoPath 2013 Form and it is located in a SharePoint 2013 Document Library. This is an HR form for employee change request. The idea is to have the employee go to the doc library and select new document, then complete the form, but instead of submitting the form to the same library, which is the way it is setup right now, rather I need to configure this form to submit to a different document library. The other library will be secure, so that an employee cannot view sensitive data. I looked at other knowledge based articles but could not find a solution for particular for this issue, unless I missed something.

The first document library is open to all employees, but the submit to document library is secure, only for HR use. Is it possible to accomplish this type of configuration in either InfoPath or Sharepoint?

FYI - I'm a beginner with InfoPath and SharePoint.
0
I want to give a developer access to one site on my SharePoint Online (Office 365 Enterprise E3) tenet. What is the current best practice way to do this? The developer will need to upload documents to the Site Assets folder and add/edit pages within the site.
0
Hi Experts,

In Windows 10 and Excel 2016. using a Sharepoint 2013 site with a New Team Site and Logged in as a user or even the Site collection owner (global admin) when attempting to create a new list via the SharePoint app "Import from Spreadsheet" we get the error message "An unexpected error has occurred"

This only appears to happen in Window 10 not Windows 7, although on our Windows 7 computer we are using Excel 2013 so not sure if the issue is related to the version of Excel or not.

Steps to reproduce:
1) Create an Excel spreadsheet (using Excel 2016 in our case) with a single worksheet & basic data. Save and exit Excel.
2) Login to SharePoint online team site as site collection owner.
3) Site Contents-->Add an app-->Import Spreadsheet
4) Enter List name, then click "Browse" button to open .xlsx file location
5) Click "Import"

Result: we get the error message "An unexpected error has occurred" See attached screenshot

Have tried to add the sharepoint URL to the list of Internet explorers trusted sites and see the same result. Regardless where the excel file is saved (ie local or a network location) we see the same issue and seems to affect all users

Any ideas what's causing this or how to resolve?
unexpected_error.jpg
0
Our internal sharepoint site prompts all users for a username and password when clicking on a link to open a publisher document. Any other document types open fine so it is not a trusted site issue nor is it saved passwords or anything like that.
This affects both Windows 7 and Windows 10 users using IE11. SharePoint 2013 Enterprise on premise.
0
Hi All,
I am working in SharePoint 2013 server. I have an .xlsm file that is filled out as a work request and submitted to the SharePoint site. The Excel file is then reviewed and eventually approved through the Item Approval process. I am looking for a way to use a workflow that once the file is approved that the file is removed from the SharePoint site and archived in my network folder //borg/usershar/MCL/datasources/XH-707/
The excel files are up to 6 MB in size so I do not want to consume the SharePoint site capacity and store offline from that server.
The second part to my question, is there a way to generate a pdf automatically through a workflow once the Excel file is Approved? If this is possible, I could maintain the pdf and delete the excel file after approval. Thanks for any help.
0
Hi,
I was deploy web part using powershell, but still showing in the central admin following message
(system Setting->farm managemet-> Manage farm solution)
Status -   "Deploying(scheduled at 6/20/2017 3:19 PM )".

use following command to deploy
Add-SPSolution -LiteralPath D:\ERP\test.wsp
Then click on the Deploy

After i checked the webpart ,it's looks deployed success, but in the status still deploying

Any idea what is going on ,how to handle this .
Many thanks
0
hello, I  need to know if it is possible to unlock a subsite while the parent site is in ReadOnly Mode. If it is , how?

https://portal.company.com/sites/siteA  ----> Locked (ReadOnly)

https://portal.company.com/sites/siteA/subsite1----> unlocked
Is it posible , and how

Thanks,
0
please advise
Sharepoint does not always have the best interface to do quick copy pastes from one field to another.
0
Simplifying Server Workload Migrations
LVL 4
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

I am using handlebars and ran into an issue with trying to group by a category but I was able to fix that by using underscorejs.  Now my issue is using my object categorized into arrays into my template.  Here's an image of what I see in the developer tools:
Object with two arrays
As you can see, it's an object with two arrays.  I got the data to show by doing the following but as you will see, it's not very efficient because there are actually have 6 categories and not just two.
<!-- Handlebar Js Template Starts Here -->
   
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
 
<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/underscore.js/1.8.3/underscore-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="../nrm/SiteAssets/projectMilestone.js"></script>

<script id="projectMilestone-template" type="text/x-handlebars-template">
 
<table border=1> 
 	<tr>
 		<th colspan="7">Milestones</th>
 	</tr>


	<tr>
		<td>Milestone Description</td>
		<td>Planned Date</td>
		<td>Revised Date</td>
		<td>Actual Date</td>
		<td>Type</td>
	</tr>
{{#Construction}}	
	<tr>
		<td>{{ MilestoneDescription}}</td>
		<td>{{ Planned_x0020_Date}}</td>
		<td>{{ 

Open in new window

…
0
It looks like they removed the option to add parameters to data connections in the wizard.  Can anyone suggest how this can be do as in 2010? thanks
0
This line works to validate email address
=AND(ISERROR(FIND(" ",[Email Address],1)),IF(ISERROR(FIND("@",[Email Address],2)),FALSE,AND(ISERROR(FIND("@",[Email Address],FIND("@",[Email Address],2)+1)),IF(ISERROR(FIND(".",[Email Address],FIND("@",[Email Address],2)+2)),FALSE,FIND(".",[Email Address],FIND("@",[Email Address],2)+2)<LEN([Email Address])))))

Open in new window


But now I only want it to use above if email field is NOT empty.

Can you help?
0
I have a SharePoint 2016 Server hosted in Azure.  Does anyone have any knowledge or links about adding bootstrap support here?
0
Until the recent update of OneNote mobile for iOS I was able to open my SharePoint OneNote Notebooks...  As anyone aware of a change they made on the new iOS mobile app?  Instead of opening the SharePoint Windows Domain login it opens the Microsoft Live login...
0
Hello Folks,

Can any one help me with steps to create an attendance tracker in Sharepoint?

Just need few links for reference.
0
My organization did a vulnerability scan one of our websites (SharePoint 2013) which is behind AD authentication... the report gives warnings about about "cross-site scripting" and "clickjacking" vulnerabilities.

My question is, if the site is behind AD authentication these are not actually vulnerabilities, are they?
0
I am using REST API with SharePoint 2013 and I want to know if the following url endpoint is legal or if there is a better way?
 //http://myspsite.com/nrm/_api/web/lists/getbyTitle('My_Project_Modules')/items?$select=DIR,Station,Title,Building_x0020_Number&$filter=Project_x0020_Number eq '402-CSI-001'     //<---  Works when I paste it in the browser
 var projNum = '402-CSI-001';
var endPointUrl = _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getbyTitle('My_Project_Modules')/items?$select=DIR,Station,Title,Building_x0020_Number&$filter=Project_x0020_Number eq "+projNum;  //<---  Not valid when I run it in my code

Open in new window


Error I get in my js file
rest api error
js file
function loadSPItems() {
var projNum = '402-CSI-001';
var endPointUrl = _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getbyTitle('My_Project_Modules')/items?$select=VISN,Station,Title,Building_x0020_Number&$filter=Project_x0020_Number eq "+projNum;//,ProjectNumber,ApprovalStatus,ProjectExecutionStatus”;
var headers = { 
	"accept": "application/json;odata=verbose" 
}
 
jQuery.ajax({ 
	url: endPointUrl, 
	type: "GET", 
	headers: headers, 
success: function (data) {
	console.dir(data);
}, 
	error: function (err) { 
	alert("Error Occured:" + JSON.stringify(err)); 
}
 
});
 
}

loadSPItems();

Open in new window




Thoughts?
0
I have a SharePoint 2016 Site Collection.  In this collection I created a custom content type with Item as the parent.  To that custom type I added a couple of choice columns.

Now I go to a list and list/settings/advanced and turn on Managed Data. After that I go into the list settings again and add this content type.  So, now I see other columns which I can then use on the list.  Ok, that seems to work.

But,  when I launch InfoPath to create a form to Create/Edit list items for this list, none of the custom content type columns show up.

Any advise on this would be appreciated.
0
SharePoint Admin?
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

I have been trying to configure search in on-premise SharePoint 2016 site. I need to add a Query (KQL) to be able to search specific document library within specific site. So far I had no luck with Path: command. Below is what I am using which is as close as it gets:
{SearchBoxQuery}  (contentclass:STS_List_DocumentLibrary)  ListUrl:{url to document library}
This KQL gets me the search results for the entire site not specific document library.
Any suggestions?
0
Hi,

How to save opened word with macro, in sharepoint 2013 on premise?

I want to save the word with his current name and add client name and date of creation.

I tried this, but not working:
Sub save()
Dim Client As String
Client = InputBox("Saisie de votre Client : ")
sDocName = Left(sOrigName, Len(sOrigName) - 4)
sDocName = sDocName & Client & MonthName(Month(Date))
sDocName = sDocName & ".docx"
ActiveDocument.SaveAs FileName:= _
    "https://sharepoint.contoso.com/conventions/Documentspartages/" & sDocName, _
     FileFormat:=wdFormatXMLDocument, _
LockComments:=False, Password:="", _
AddToRecentFiles _
:=True, WritePassword:="", ReadOnlyRecommended:=true, _
EmbedTrueTypeFonts _
:=False, SaveNativePictureFormat:=False, SaveFormsData:=False, _
SaveAsAOCELetter:=False
ActiveDocument.Convert
End Sub

Open in new window

0
Hi,


we have one site collection which is having 2 document library, its contents 450 GB database size. Actual database size is 100 GB but due to version history the overall Site Collection Database size reached to 450 GB, I am thinking to shift one document library to another site collection and remove the same from existing site collection.

We have 2 document library with millions of folder and sub folder. I will create two Separate site Collection with this two library (One Document Library in one site collection and another document library in another Site collection)

I want site permission , Library permission , Folder and item level permission as it is of that new Sites - Library with version history and check in check out,

I will create new Web application in same farm

I am going to use Import and export document library approach - May I able to retain Permission of site , Library , Folder with version history and check in check out status .

Any other points which I need to take care while moving , I require user to access site as it is, I will create just link of new document library on main site .

We have SharePoint 2010 Standard and SQL standards 2012 .  Any other approach is also welcome.
0
Honored Experts.

Im new to Microsoft Online and OneDrive Business.
I have set up an agreement for a very small company.
I have uploaded a folder called SHARED to OneDrive and shared this for all users.
However NONE of the OTHER users are actually able to see this folder in Windows Explorer OneDrive.
They have to go online and see shared folders to access it.
How do I make this shared folder visible in Windows?? :-)
0
I have the following formula on a calculated field that searched the value funnel status for values then sets as live or active...  rather than search is the field contains I would like to be if the field equals...

how would the formula change?

=IF(ISNUMBER(SEARCH("Early Engagement",[funnel status])),"active",IF(ISNUMBER(SEARCH("DRFP (Active) ",[funnel status])),"active",IF(ISNUMBER(SEARCH("DRFP (Non-Active) ",[funnel status])),"active",IF(ISNUMBER(SEARCH("Post Proposal Submission ",[funnel status])),"active",IF(ISNUMBER(SEARCH("DRFP Questions ",[funnel status])),"live",IF(ISNUMBER(SEARCH("RFI",[funnel status])),"live",IF(ISNUMBER(SEARCH("RFP",[funnel status])),"live",IF(ISNUMBER(SEARCH("BAFO",[funnel status])),"live",IF(ISNUMBER(SEARCH("Orals",[funnel status])),"live",IF(ISNUMBER(SEARCH("Quals",[funnel status])),"live",IF(ISNUMBER(SEARCH("ENs",[funnel status])),"live",IF(ISNUMBER(SEARCH("FRP",[funnel status])),"live",IF(ISNUMBER(SEARCH("Bridge",[funnel status])),"live",IF(ISNUMBER(SEARCH("Contract MOD",[funnel status])),"live",IF(ISNUMBER(SEARCH("Unsolicited",[funnel status])),"live","")))))))))))))))
0
Hi,

I'm using an Excel spreadsheet to extract filtered data from an Advantage database via ODBC data links.  I have uploaded the spreadsheet to Sharepoint so that other users in my organisation can view it, and so that I can use the filtered data in the spreadsheet for other applications, such as Power BI.

Is there a way to have the ODBC data links in this document refresh automatically (ie without having to open the spreadsheet and manually refresh the connections)?

Thanks

Gerry
0

Microsoft SharePoint

36K

Solutions

40

Articles & Videos

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.