SPJS Charts for Share. Point user manual. Last updated: July 2. Creating a stoplight status indicator via a SharePoint List to quickly display whether the project is on track or not. In terms of free, out-of-the-box functions, I consider the UserProfileService to be the most powerful thing that can be used in SharePoint-based InfoPath forms. General. This solution used to create interactive charts from data stored in Share. Point lists. It uses the Google Visualization API to draw the charts. This is a 1. 00% client side solution that doesn’t require server side code. All you need is the rights to upload documents (the script files) to a document library, and to add a Content Editor Web Part to a page. Data policy. Google’s data policy for most of the charts state: All code and data are processed and rendered in the browser. No data is sent to any server. The MAP charts will however send the coordinates / addresses to the Google Maps servers for processing. Current version. The current major version is 6. The reason for skipping from 5 to 6 so quickly has to do with changes in the “loader”. See “Upgrading from an earlier version” below. Installation. Download files. Download the files from here. Video installation guide. I have a sandbox 2013 site for testing and am following your instructions but I am not seeing the same things in your screenshots. For instance, after I upload. Upgrading from an earlier version. SPJS Charts for Share. Point v. 6 is NOT backwards compatible with earlier versions. This means you CANNOT replace the script files in your current “/SPJS/Charts” folder. You must add the two versions side- by- side in the SPJS library, and create new chart pages and import your existing charts into a chart web part created with the new installer. Share. Point 2. 00. This new version should still be compatible with SP 2. I have NOT tested it specifically. Adding charts in SP 2. Unzip and upload to a document library. Unzip, and upload to a document library named “SPJS” in the current site. The folder structure should be “/SPJS/Charts_v. If you already have SPJS Charts for Share. Point v. 5 installed, you must leave this folder as- is and add “Charts_v. Charts” folder. Storing the files in the site collection root. The default location for the SPJS Charts for Share. Point files is in the current site. If you however want to put the SPJS document library in the site collection root for sharing with multiple sites, you need to change the variable “spjs_charts_scripts_in_current_site” in the file “/SPJS/Charts_v. SPJSCharts_loader. Insert API key for Google Maps. This is only required if you plan to use Google Maps. As of June 2. 01. Google requires an API key in order to display Map charts on a web page that has not already used map charts prior to this date. This key is free for up to 2. Get a key”. You will need a Google account, but the key itself is free (no need to enter any credit card info). July 2. 7, 2. 01. I have changed the method of specifying the API key for Google Maps in the file “SPJSCharts_loader. If you see the message “Oops! Something went wrong. This page didn’t load Google Maps correctly”, you must update your version of SPJS Charts to v. API key like this in line 1. SPJSCharts_loader. Api. Key = "your_key_here"; Replace the text “your_key_here” with your API key. Insert a chart in a page. Copy the path to the file “/SPJS/Charts_v. SPJSCharts_loader. Content link field in a Content Editor Web Part (CEWP) in a page in your site to start configuring your first chart. Create web part template [optional]When you have created the first chart, you can save the CEWP as a template to be able to easily add the new chart without knowing the path to the script. Edit the page, select “Export” from the little down- arrow in the top right corner of the CEWP. Save it locally, and then upload it to the “Web part gallery” in the root site of your site collection. Type in a name and description for the web part, and add it to a custom group named “SPJS Charts”. When this is done, you can go to any page in your site collection and add it as any other web part to a page. Localize the frontend UIYou can edit the file “/SPJS/Charts/js/spjs- charts- i. UI. If you plan to use this option, ensure you include the script in the “SPJSCharts. Master_CEWP. html” file. Enter edit mode. When you have added the chart web part to the page, you see this icon: Click the icon to bring up the “New Chart form”: Enter a name and hit OK to reload the page. You will see this message: Click the ellipsis, and select “Edit chart”. I’ll not go into details on every options so please post a question in the forum if you need more details. Basic setup. Chart type. You can use most of the chart types available in the Google Visualization API. Select a list to start configuring the chart. Add at least two columns to build the chart. Click the link Configuration options for all chart types in the chart configuration to see how you build the desired chart. Web, list and view. Select the data source. If you plan to save the site as a template, you should select the “Use display name for list and view” as the GUIDs will be regenerated when you create a site from the template. Filter and Custom CAMLIn v. BETA 3 I have changed how the filters are handled. You are no longer required to use Custom CAML to be able to use filters, but you can still use Custom CAML if you prefer that. Please note that the filter values from filters above the chart are no longer picked up in the Custom CAML itself, but is applied after the dataset has been returned. This change means you must reconfigure any existing charts you have that uses the {filter: key} setup in the Custom CAML. Filter data from URLURL filters still need to be added to the Custom CAML like this: < Where> < Eq> < Field. Ref Name='Status' /> < Value Type='Text'> {url: Status}< /Value> < /Eq> < /Where> Here you can write your own CAML. This is not covered here, but you can click the “Get CAML from selected view” to start form a predefined view. Filters. If you want to use filters, you must click “Create filter(s) above the chart” checkbox to reveal this section: You can use either a freetext filter, a dynamic filter based on the actual values in the datasource, or a predefined list of filter options. You can have multiple filters – just choose another field in the dropdown to automatically add it to the filter textarea. Static filter. Here is an example of a “static” filter built from a “Year” column: [. Filter by year". "key": "Year". Type": "select". "selected": true. Dynamic filters. The filter setup is automatically generated using the controls above the filter textarea. Here is an example: [. Task status". "key": "Status". Type": "select". "cascade": true. Value": "Deferred". All. Option": true. Filter optionslabel. The label in front of the dropdown. This is the Field. Internal. Name of the field you are filtering. Set this to true to have the possibility to select multiple values in the filter select. Set the size of the multi select control. Type. This is either “text” or “select”. The parameter “cascade” determines whether or not to show only the filter values available in the current filtered datasource, or to show all options from the original unfiltered datasource. Use this attribute to control the sort order of the dynamic filter options. Use true or false. Value (dynamic filters)Use this attribute to preselect an option in the dynamic filter options. All. Option. Determines whether or not to show an option to show all data without filter. Use true or false. Additional. Charts. This attribute is deprecated. See “Use one filter for multiple charts” below. Array of filter options. The “f” is the friendly name for the option and the “v” is the database value. Use “*” as “v” attribute to retrieve all items unfiltered. Add “selected”: true if the option should be preselected. Use one filter for multiple charts. Check the “Create filter(s) above the chart” in the second chart, and insert this in the filter textarea: {"master": "parent_chart_id"}Replace “parent_chart_id” with the Chart ID of the chart where you have defined the filter. Using a script to generate the filter options. Please note that this is for advanced users. If you want to generate the filter options by a custom script, you can use two different methods. Option #1 (recommended)Leave the “options” as an empty array like this: "options": []And use a script like this to build the options: function get. Filter. Options(chart. Id,key,ticker){. if($("#"+chart. Id+"_chartfilter_"+key). Chart not ready - waiting. Timeout(function(){. Filter. Options(chart. Id,key,ticker). var opt. Arr = ["< option value='*'> Show all< /option> "], year = 2. Year = new Date(). Full. Year(). while(year < = this. Year){. opt. Arr. Id+"_chartfilter_"+key). Arr. join("")). get. How to create a Share. Point approval workflow with 3 dynamically- determined approvers. Create a workflow which is described on following image. Note: After any two of three approvers finish their approval tasks document will be either approved or rejected. Resolution. Access Share. Point site and create custom Share. Point list. List name: Regulation Approvers. Columns: Editor (People. Picker)Approver. 1 (People. Picker)Approver. 2 (People. Picker)Approver. 3 (People. Picker)Note: Using this method approvers can be different for different users/employees. Also, create libraries: Regulations – draft. Regulations. Regulations is public library, everyone has “Read” access. Open SP Designer – Workflows – List Work. Flow – “Regulations – Draft”Name: Parallel Approval WF 2. Action – Set WF Status – this message – “In progress”. Action – Set WF Variable. Workflow variable – create a new variable… –Name: Approver. Type: String – OKValue – fx. Click on fx and enter following parameters: Click on OK button. Click on Yes button. You should be able to see workflow presented on the following image: Now repeat the same steps to create variables: Now click on Action – Set a task process. Click on “these users” link. Window presented on following image will be shown. Select “Parallel (all at once)”. Now click on “…” button to define paticipants (approvers) – Workflow Lookup for a User… – Add – (insert parameters as shown on the image below). Repeat process for Approver. Approver. 3. Click on OK button. Click on “…” button next to the “Task Title” field. Type: “Request for approval – “. Click on Add or Change Lookup button, insert parameters as shown on the image below. Click on OK button. Following image presents workflow created so far. Click on Task Options. Insert parameters as shown on the images below. In this case approval process will be finished after any two of three approvers finish their approval tasks. Note: if I put any number higher than 3. Now click on Email Options. Click on Open email editor and edit email that will be sent to approvers. E. g. We do not want to set Approval Task Due Date, so in this case we will not check “Send Task Overdue Email” option. Click on Outcome Options and select parameters as shown on image below. Click on OK button. Now we need to set what whoul happened if an item is approved and what if an item is rejected. Click on Condition – If any value equals value. Click on left “value” link, click on “fx” button – (enter parameters as shown on image below). Click on other “value” link, click on Approved. Singl left click below following string: “(Start typing or use the Insert group on the Ribbon.)”. Action – Set WF Variable – Set WF status to: “Document is Approved”. Action – Copy Document – this library – Current item – OK – this library – Regulations. Action – Send an Email – these users – (click on the icon next to the “To” field). Workflow Lookup for a User… – Add. Enter parameters as shown on the images below. Define Subject as shown on the image below. Define mail body. E. g. Click on “Else Branch” button placed in the ribbon. Action – Set WF Variable – Set WF status to: “Document is NOT Approved”. Action – Send an Email. Now define mail that will be sent if document is not approved using the same method described abowe. After you finished defining Else branch click below “(Insert go- to actions with conditions for transitioning to the stage)” string, click on Action – Go to a stage – click on “a stage” link – select “End of Workflow”. Now click on “Check for Errors” button placed on the ribbon.“The workflow contains no errors” message will be shown, click on OK button. Click on Save button placed on the ribbon. Now click on the name of workflow we created. Define Settings and Start Options. Click on Save button. Click on Publish button. Originally Posted here: link.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
October 2017
Categories |