Utility gallery

This content item has been deprecated. Instead, use the Social Share content item.

  • Description - Access the Advanced Accounting Console directly through the iMIS Staff site, using a web browser.
  • Usage Scenario - The configuration for this content item allows you to set up a Remote Desktop Protocol (RDP) connection that will allow the Advanced Accounting Console to be accessed through a web browser. You can specify connection values for your remote desktop session. You can also specify the width and height of the displayed remote desktop screen. The Advanced Accounting Console section allows you to specify information about the Advanced Accounting Console, including a working directory, and an option to automatically log the current web user into the Administrative Console.

This content item has been deprecated. Instead, use the Common Search content item.

  • Description - Displays alerts to users. It must be configured to display a selected alert set.
  • Usage Scenario -
  • Description - Displays a list of data changes made in the Name and Name_Fin tables. The information that displays is information specific to the current user.

    • You can track changes made to specific business object fields by enabling the “Log All Changes” option in the BOD Property definition. The following columns display on the content item: Date, Action, User, Property, Previous Value, and New Value. The Previous Value and New Value columns are truncated to 500 characters. The data displayed is read-only and cannot be modified.

  • Usage Scenario -

  • Description - Displays a universal search page with multiple configuration options.
  • Usage Scenario - This iPart can be configured in many ways, from a simple search page (with label and text box) to an "Amazon" like search, that filters by department (such as Events versus Products).

    • This iPart supports a "debug mode" that allows you to display all current iPart settings at any time by simply adding the URL attribute: &Debug=true

  • Description - Imports data into iMIS using iMIS SOA Web Services. Imported files appear in the File Viewer For Web Services.
  • Usage Scenario - First a user chooses the file format they want to import. The file format identifies the structure of the data within the file, so that iMIS can properly import and process the contents. When they click Upload, iMIS uploads the file to the ~/UploadedFiles folder, which is relative to their iMIS web application directory. That file is then processed based on the file format they selected. This content item currently includes the following formats:
    • Standing Order payments file - BACS format - The content of the uploaded file is converted into a common standing order payment file. Each line of the file is then ready to be matched against the Standing Order commitments made to an organization, who can complete the matching process using the File Viewer For Web Services.
    • XML file - The uploaded file is placed in the ~/UploadedFiles folder. If it is a valid XML format recognized by iMIS SOA Web Services, the contents can be processed through the File Viewer For Web Services. Currently Friendraising XML files are the only supported format.

  • Description - Lists files imported through the File Importer For Web Services. When you process a file in the viewer, the results are posted to the iMIS Log Viewer For Web Services.
  • Usage Scenario -
  • Description - Imports Friendraising Export Files on demand from the Friendraising Advanced Accounting Console. You can view imported files from the File Viewer For Web Services iPart. Use the Friendraising Settings and Friendraising Mappings iParts to define the settings and mappings required for a Friendraising import.
  • Usage Scenario -
  • Description - Defines the mappings required to use the Friendraising Bridge.
  • Usage Scenario -
  • Description - Defines the settings required to use the Friendraising Bridge.
  • Usage Scenario -
  • Description - Tracks your organization's email communications with a contact. Displays essential information about each communication, such as date, type, subject, and owner.
  • Usage Scenario -
  • Description - The Log Viewer lists the results of files processed from the iMIS File Viewer For Web Services.
  • Usage Scenario -
  • Description - Configures Host Credentials and Policies for connecting to the National Realtor Database System (NRDS)
  • Usage Scenario - This iPart allows you to set up the configuration to connect to and sync with NRDS. There are three sections: NAR Host Credentials, Member field mappings, and Office field mappings. The Host Credentials section contains your credentials to connect to NRDS, including the Queue information. The field mappings sections allow you to define how NRDS fields should map to iMIS fields. The fields you can map include type, status, and address and phone data.
  • Description - Sync the selected iMIS record with NRDS. You can update data from NRDS or send data to NRDS.
  • Usage Scenario - This iPart consists of two buttons: Send to NRDS and Update from NRDS. When clicked, the buttons sync the currently selected iMIS record with NRDS data. The Send button sends data to NRDS, and the Update button receives data from NRDS. The iPart can be placed in a content record which serves as a contact profile in order to sync that contact with NRDS. The currently selected iMIS record is the logged-in user by default. If you are viewing a profile for another contact, or if there is an On Behalf Of contact selected, then that contact will be the currently selected iMIS record.
  • Description - Updates iMIS with data from NRDS for a single record, either a Member or an Office. If the record does not exist in iMIS, it will be created.
  • Usage Scenario - This iPart allows you to enter an NRDS ID for a Member or an Office, and update iMIS with NRDS data for that record. The NRDS ID is stored in iMIS as the MajorKey or iMIS ID, depending on how you have configured NRDS in iMIS. If there is no existing iMIS record for the ID, a new record will be created.
  • Description - Provides an easy way to install iParts and other iMIS functional packages, such as reports.
  • Usage Scenario - Select packages to be installed, view currently installed packages, and view failed package installs. The packages can include:
    • Objects, such as iMIS queries, business objects, and content types
    • SQL Scripts, which are are triggered to run against the iMIS database during an installation
    • Files, such as ASCX pages, images, and Word templates

With Progress Tracker, you can visually display progress towards a goal based on the results of an IQA query. For example, connect this content item to a fundraising query, so that your members can easily track the progress of a fundraising effort towards a specific goal. Or connect it to an events query, so that you can see at a glance how many people have registered for an event.

  1. Create a query for the Progress Tracker.

    2. Note: For sample queries that will work with this content item, see $/Samples/ProgressTracker/ in IQA.

    The Progress Tracker uses three pieces of information supplied by an IQA query: a goal amount, the sum total of what you are tracking, and the end date (which is optional). When you build your query for this content item, it must contain specific aliases. In IQA, create a new query and choose the business object you want to query on. Make sure you are in Advanced Mode, then from the Display tab, choose properties to assign the following aliases to:
    • Goal_Amount: Indicates which property is the goal amount. You can apply this alias to a property of a business object, or apply it to a Custom SQL Expression property. For example, add CAST(25000 AS INT) as a property to set the goal amount to 25,000.
    • Sum_Total: Indicates which property is the amount to be summed. The percentage displayed in the Progress Tracker is based on this amount compared to the goal. It can be a monetary amount or any other number, such as the number of event registrations.

      • Note: From the Function dropdown list for this property, select Sum, so that only one row is sent to the content item. This is not required, but it will improve performance.

    • End_Date: Indicates which property specifies the end date. This alias is only required if you want to display an end date in the content item. You can apply this alias to a property of a business object, or apply it to a Custom SQL Expression property. For example, add CAST('2012-12-25' AS DATE) as a property to set the end date to 25 December, 2012.
  2. Add the content item to a content record and configure it.
    1.  Go to RiSE > Page Builder > Manage content.
    2. Do one of the following:
      • Select a Content Folder and click Edit.
      • Select New > Website Content.
    3. Click add content.
    4. Go to ContentTypes > Utility.
    5. Select Progress Tracker.
    6. Click OK.
    7. Enter the CSS class to style the Progress Tracker. Two styles have been pre-defined that you can use in the content item: ProgressTracker and ProgressTracker2. You can edit these classes to change the look and feel, or you can create your own style for the Progress Tracker.
    8. Select a Source query.
    9. (optional) Select a data column by which you want to filter. You can use this feature to dynamically update your Progress Tracker, based on the value passed to it in the URL. If you choose to filter on a data column, then also enter the name of the URL parameter, which the content item uses to identify the value to filter on. For example, to limit the results of an event query to a specific event, you can select the EventCode property and give the URL parameter a name such as EventCode. The progress displayed will then reflect only the event code which is included in the URL as EventCode=[EventCodeValue].
    10. (optional) Enter any messages you want to appear in the content item. The variables below can be used in the descriptions. For example, "Help us reach our goal of [GoalTotal] new members by [EndDateLong]!"
      • [GoalTotal] displays the goal total
      • [CurrentTotal] displays the current sum total or count
      • [EndDateLong] displays the end date in a long format
      • [EndDateShort] displays the end date in a short format
    11. Select the Caption Options. In addition to the progress bar, you can also display the values as text. If any of the Caption Options are unavailable after selecting a query, this indicates that the required aliases have not been defined in the query.
    12. Select the Progress bar location. The bar can be displayed above or below the captions.

      13. Note: You can also use this content item to display only a countdown (days remaining to a certain date). In configuration, only select the caption option Display days remaining, then for the Progress bar location, select (None).

    13. Click OK.

The Query Chart Viewer content item displays query results in a chart, which can be set to a range of sizes, skins, and chart types.

The Query Chart Viewer can render any existing query, but you will get the best results by following these guidelines on how to design queries specifically for use with this content item:

  • Queries – The queries you create for the content item should be structured so that the results are appropriate for charting. For example, if you want the chart to display the total sales per salesperson, then the source query should be written using the Sum function in IQA.
  • Query Display Columns – Each property you select on the display tab in IQA is available in the configuration page as a Data column display option. You can select up to three properties to be displayed on the content item if you want to display a chart with multiple data values.

    • Note: In order to display multiple data values in a chart, a property in the display tab must have the checkbox checked in the Subtotal column. The properties for which the checkbox is selected in the Subtotal column will be available as options for the Series data column configuration option in the content item.

  • Aliases – In your source query, enter an Alias for the display properties you plan to show in the content item. Relying on the default labels might not be sufficient, especially when your query uses multiple joined sources or custom SQL expressions. If the query does not display as you expect, using an Alias often resolves the issue.
  • Sorting – You can sort the query results displayed in your chart in ascending or descending order. To sort your results, edit your source query and, from the sorting tab, add the property to be sorted.
  • Labels – The labels on your chart’s x-axis might overlap if there are too many data points or if the labels are too long. You might be able to improve the display through a few methods: In the content item, you can expand the width of the chart or change the label angle. In the query, you can try to reduce the number of data points.

The following are examples of chart types in the Query Chart Viewer.

Displays data in an area filled with color to illustrate trends.

Note: You can display multiple data values in an Area chart.

Displays sets of data with horizontal rectangular bars for comparison.

Note: You can display multiple data values in a Bar - Horizontal chart.

You can also select Enable stacked series. This option allows related data to be stacked on the same data-point bar. This option is only available for Bar - Horizontal and Bar – Vertical charts.

Displays sets of data with vertical rectangular bars for comparison. For example, create a vertical bar chart that shows the number of contacts in your organization by customer type.

Note: You can display multiple data values in a Bar - Vertical chart.

You can also select Enable stacked series. This option allows related data to be stacked on the same data-point bar. This option is only available for Bar - Horizontal and Bar – Vertical charts.

Displays data as a series of bubbles.

Note: You cannot assign a size value to the bubbles in the Bubble chart.

Functionally identical to a pie chart, with the exception of a blank center and the ability to support multiple statistics at once.

Displays data as a series of data points connected by a line to illustrate trends. For example, create a line chart that shows the number of contacts in your organization by customer type.

Note: You can display multiple data values in a Line chart.

Displays data in a circular chart divided into sections to illustrate proportion.

Query Menu lets you merge query results into your site for tremendous utility. You can set the content item to display a query, set with whatever title, parameters, columns, labels, and sorting you need, and you can enable exports, which adds icons for sending the data to Word, Excel, PDF, and CSV.

You can also organize helpful queries into a folder and point the content item to that folder. When the page loads, the content item displays the first query at the top of that folder, and it presents a drop-down menu of additional queries available, organizing them by subfolders, if any. When the user clicks on a query from the menu, the content item immediately runs that query and displays the results.

If the query selected returns contacts, Query Menu provides the ability to send an email to all of the contacts using the Communication Creator content item. You can use the Email button in the Query Menu to email the entire contact list if the query contains a required Id column or column alias. See Creating a list of contacts to email to view a list of columns and column aliases that you can use to enable mass emailing of the contact list.

If the query selected contains an address property, you can configure the content item to automatically map the query results when an address is available. Only one address property per query can be mapped. When this option is enabled, the content item looks for the following address properties in this order and maps the first one it finds: FullAddress, Address, FullAddressText, AddressText, Address Text, and Full Address Text.

This content item has been deprecated. Instead, use the Related Items content item.

  • Description - Shows a list of recently viewed items and allows all users to quickly review and access items that have been recently viewed such as events and contacts .
  • Usage Scenario - When configuring this content item, choose the types of recent items you would like to include by selecting the drop-down.

With the Related Items content item, you can display a list of profile or product pictures based on the results of an IQA query. For example, you can write a query to display the profile pictures of everyone who has registered for an event, made a donation, or ordered a particular product, or to display products in the same category. You can configure the list to display horizontally or vertically, to display a name for the item, and to choose the size of the image. You also have the option to make the profile picture a live link that opens a URL of your choosing, such as the member profile page.

  • The pictures displayed in the content item are based on iMIS product or contact IDs. When creating the query for this content item in IQA, you must select a property that returns an iMIS product or contact ID on the (Display tab). Give this property an Alias of key_Id (the Alias is case sensitive).
  • To define the image to display for each record, include a column in your query that specifies the image file name for that record. Give this property an Alias of Image.
  • To display a name for each record, include a column in your query for the name of the item or contact. Give this property an Alias of Name.
  • When you add Display columns to the query in IQA, they become available within the content item as Filter columns to filter on.
  • You can dynamically filter the query results displayed in the content item based on the value of another content item’s URL parameter. For example, you can set up your donation page to display the profile pictures of people that have donated to a particular cause (called a distribution in iMIS). Donation Creator uses the URL parameter itemid to determine which distribution the donation should go towards. If you add your content item to the same content record as the Donation Creator, then you can set up the Related Items content item to look at the value of itemid to determine which profile pictures to display. You just have to make sure that your query includes the CsActivity.Product Code property, so that you can select it as a Filter column on the content item’s configuration page. Once selected, enter itemid for the Filter on URL parameter, so that the content item knows to filter the results based on that URL parameter’s value.

In this example, the Related Items content item is set up to display clickable images for other products in the same category as a particular product. This example uses content installed for the sample Member site.

  1. Go to Page Builder > Manage Content.
  2. Click Core Content > Shop > Store Layouts > Item Detail.

    3. Note: The Item Detail content record displays product pages in the Member sample site’s Shop. The product displayed is based on the value of the URL parameter iProductCode. iProductID.

  3. Select Add content > Utility > Related Items.
  4. For the Source query, click select. Navigate to $ > Samples > RelatedItems and select Related Products.
  5. Filter Options dropdown, select ProductCategory. ProductClassKey.
  6. Filter on URL parameter, type in Category.
  7. For the Items link to (URL or shortcut), type in: 
    ItemDetail?iProductCode={key_Id}&Category={ProductCategory}
    This uses the ItemDetail shortcut to link each item in the list to the product page. The particular item’s product ID and category are specified in URL parameters so that the correct product and related products are displayed in the resulting product page.
  8. Click Save & Publish to complete the content record.

In this example, the Related Items content item is set up to display clickable profile pictures of other users who have bought a particular product. This example uses content installed for the sample Member site.

  1. Go to Page Builder > Manage Content.
  2. Click Core Content > Shop > StoreLayouts > Item Detail.

    3. Note: The Item Detail content record displays product pages in the Member sample site’s Shop. The product displayed is based on the value of the URL parameter iProductCode.

  3. Click add content > Content Types > Utility > Related Items.
  4. For the Source query, click select. Navigate to $ > Samples > QueryProfilePictureList. Select Orders.
  5. Filter column dropdown, select ProductCode.
  6. Filter on URL parameter, type in iProductCode.
  7. For the Items link to (URL or shortcut), type in: 
    MBR/Party.aspx
    This redirector web page looks for an ID in the URL parameter and then checks the ID’s party type and the user’s permissions to determine which content record to display. The user’s ID is appended to any URL specified in this field.
  8. Click Save & Publish to complete the content record.
  • Description - The new Report Display iPart displays an SSRS report using an RDL template stored in the iMIS Document System. This is different from the SSRS Report iPart, which requires you to begin with an IQA source query and requires an SSRS runtime object. The Report Display iPart permits you to create reports outside of iMIS or pull in already-existing reports by simply adding an RDL to the Document System.
  • Usage Scenario -
  • Description - Users can easily bookmark or share pages with social networking sites such as Facebook, Twitter, and LinkedIn. Clicking a social share icon opens a separate browser to the selected social media site, and prompts the users to log in to their account. Clicking the email icon opens the users default email client.
  • Usage Scenario - With this content item on a page, it's easy for users to share your content across the web. For example, add the content item to a donation page so that donors can easily promote your cause to their friends.

The SSRS Report content item lets you display the results of any IQA query on any page where you place it. SSRS Report uses the version 10.0 ReportViewer, which supports IE8 natively and, in IE8, adds a Print button on its toolbar. You can add the SSRS Report content item to any content page using CM: open the Utility folder and choose the content type SSRS Report.

This content item lets you customize whether to display the export buttons for PDF and Excel versions of the report. You can change the default design (layout, colors, fonts) of your reports by editing the SSRS parameters in the SystemConfig table.

How it works: The process engine specified by the content item loads a report template (.RDL file) from the document system and creates a report data source (a DataTable) based on an IQA query's SQL source; the report viewer then combines the template and query to generate the report's output. When you configure the content item, you specify the Document system path to the SSRS Report runtime, which must be a link to an SSRS Process Engine. Click the select link next to the textbox, then browse to your reports (such as $/Samples/ReportingServices), and pick one of the runtime entries.

Note: Identify a process engine (run-time report) by the arrow on its icon!

The Summary Display content item displays a single row of query results in a form view.

When creating a query that you want to display in the Summary Display content item, keep the following guidelines in mind:

  • This content item only displays a single row of query results.
  • If you connect the content item to a query that returns more than one row of results, only the first row is displayed.

    • Note: You can dynamically filter your query results by the currently logged-in user, a selected contact, or a date.  See Adding dynamic filters to queries for more information.

  • Description - Displays a single YouTube video in a video player with configuration options to play video automatically, hide the player's controls, and define the height and width.
  • Usage Scenario - This iPart displays a YouTube video in an embedded video player. The URL of the video is specified in the configuration options, and you can also configure the video to play automatically, to show or hide the player controls, and to specify the height and width in pixels. The URL for the video should link to a single YouTube video which is either Public or Unlisted. Private videos are allowed, but the user will need to sign in to YouTube in order to view the video. Users must also have the Adobe Flash Player plugin in order to view the video.