Auto-Saving to SharePoint

SDA Dashboard & SharePoint integration Guide

There are numerous benefits to integrating SharePoint with your SalesDoc Architect (SDA) solution.  The following questionnaire covers the decisions that need to be made before implementing these integrations.

QUESTIONNAIRE

SharePoint

  1. Which version of SharePoint are you utilizing?
    • SharePoint Online (Office 365)
    • SharePoint Online with Multi-Factor Authentication (MFA), requiring each user to be set up for MFA via O365’s admin
    • SharePoint On-Premise 2013-2019 with web access, meaning users can access SharePoint via the internet without requiring login to the corporate network
    • SharePoint On-Premise 2013-2019 with internal network access only (not recommended)
  2. What is the URL of your SharePoint site collection?(for example, https://corsproductivity.sharepoint.com, or https://corsproductivity.sharepoint.com/sites/opportunities if it’s a subsite of your main SharePoint URL)See Appendix 2: Setting up a SharePoint Online site collection for instructions on setting up a new site collection
  3. Would you like for SDA to auto-create SharePoint subsites for each new sales opportunity?If not, your admin and/or your users will need to create your own subsites, and users will be required to browse for the save-to subsite when they first save a quote file

 

Quote and Output File Auto-Saving

SDA must be configured (on the Base Info tab) to auto-name quote and output files.  Please see Appendix 1: Setting up quote and output file auto-saving.

  1. Would you like to utilize CorsPro’s recommended auto-saving/auto-naming setup, or something different?

Update:  Please note that with the enhancements made to the Dashboard, there’s an easier way to set up Auto-Saving rather than in the BaseInfo Tab.  See File Auto-Saving in the Admin Guide for SDA Dashboard.

SDA Dashboard

  1. Do you want all users to be able to see all opportunities?  If no, you can define the hierarchy by tagging a manager for each user via Administration >> Users in the Dashboard.  Note: A user who has no manager can see all opportunities.
  2. What sales opportunity statuses/stages would you like to set up, and which should be the default “starting” stage?  For example, you might have “Open”, “Proposed”, “Won” and “Lost” as your sales opportunity stages, with “Open” as default.  Clients can define sales statuses/stages via Administration >> Opportunity Stages in the Dashboard, along with a default close percent and order that they should appear in the status/stage drop-down.
  3. Is there any custom data that you’d like to roll up into the quote or opportunity data in the Dashboard?  Client-defined fields can be added via Administration >> Client Defined Fields in the Dashboard, along with setting up Excel named ranges in the quote file as needed.

 

Add-On Sales Handling

  1. How would you like to save quote/output files for small (post-project) add-on sales?  Note:  In most cases, creating new sales opportunities and new SharePoint subsites is overkill for small add-on sales
    • Save as a new SharePoint subsite (not recommended)
    • Auto-save to one or more “add-ons” site(s)
    • Manually save to project sites

 

INSTRUCTIONS

Appendix 1: Setting up Quote & Output File Auto-Saving

Quote and output file auto-saving is set up by adding the following Named Ranges to the Base Info tab:

If SharePointSiteURL is blank or doesn’t exist, and also one or the other of SharePointSiteCollectionURL and SharePointSiteTitle are blank or don’t exist, then users will be prompted to browse for the save location in SharePoint based on the URL entered when the user registers as a SharePoint user within SDA via Add-Ins >> Architect >> Setup >> Register as SharePoint user.

Detailed instructions on setting up file auto-saving/auto-naming – including additional options and functionality – are found in the “Auto-Saving Files” section of the Architect Manager User Guide.

More Information

Update:  Please note that with the enhancements made to the Dashboard, there’s an easier way to set up Auto-Saving rather than in the BaseInfo Tab.  See File Auto-Saving in the Admin Guide for SDA Dashboard.