> SYSPRO Office Integration Introduction

SYSPRO Office Integration Introduction

SYSPRO Office Integration enables you to distribute information from your core ERP system to users in the enterprise by leveraging off users' familiarity with applications from the Microsoft Office suite of products (e.g. Microsoft Word, Microsoft Excel, or Microsoft Outlook).

SOI enables you to use a Microsoft Office application to access SYSPRO information, regardless of whether you are a regular SYSPRO user or have SYSPRO installed. SOI uses web services, so a web server needs to be configured to connect to the SYSPRO application server.

Getting started

The SYSPRO Office Integration components can be installed using the Autorun facility included on the Installation DVD. Alternatively, you can install the components manually (the executable files are located in the SOI folder of the DVD).

You install SYSPRO Office Integration on each client that requires access to SYSPRO data via a Microsoft Office application.

Once installed, you need to define login credentials for the Microsoft Office application (a once-off process) that will store information on the client machine.

Once you have configured SYSPRO Office Integration for the Microsoft Office applications, an additional toolbar is displayed within these applications which allows you to access SYSPRO information.

Server prerequisites

Prerequisites Installation notes and considerations
  • Microsoft .NET Framework 4.0
  
  • Visual Studio Tools for Office Second Edition Runtime
  
  • Microsoft Primary Interop Assemblies (PIAs) for Office 2010 | 2013 | 2016
  

Client prerequisites

Prerequisites Installation notes and considerations
 

  • The SYSPRO Office Integration client portion can either be installed on the same machine as a SYSPRO Client, or on a standalone machine. In both cases the MS Office application uses the same architecture to call to the web service and retrieve the data.

    Components that can be installed include:

    • SOI for Outlook 2010 | 2013 | 2016
    • SOI for Word 2010 | 2013 | 2016
    • SOI for Excel 2010 | 2013 | 2016
  • Microsoft .NET Framework 4.0
  
  • Visual Studio Tools for Office Second Edition Runtime
  
  • Microsoft Primary Interop Assemblies (PIAs) for Office 2010 | 2013 | 2016
  
  • CMS license
 If you intend using SOI with Outlook, then you will need a license for the Contact Management System.
  • e.net System Manager license
 If you intend using SOI with Excel or Word, then you will need a license for e.net System Manager.

MS Word integration

Toolbar and menu
Field Description
SYSPRO Credentials Define the credentials and configuration options for SYSPRO Office Integration to MS Word.
SYSPRO Search Search and retrieve information from the SYSPRO database according to entered criteria.
SYSPRO Reporting Services  
SYSPRO Reporting Services This opens a SYSPRO Reporting Services pane from where you can print the SRS reports. Select this icon again to close the pane.
Print Queue

If you are using SRS server-side printing, then this enables you to view completed reports or reports that are in the reporting queue.

This applies to MS Office 2010 and 2013.

MS Excel integration

Toolbar and menu
Field Description
SYSPRO Credentials Define the credentials and configuration options for SYSPRO Office Integration to MS Excel.
SYSPRO Search Search and retrieve information from the SYSPRO database according to entered criteria.
SYSPRO Reporting Services  
SYSPRO Reporting Services This opens a SYSPRO Reporting Services pane from where you can print the SRS reports. Select this icon again to close the pane.
Print Queue

If you are using SRS server-side printing, then this enables you to view completed reports or reports that are in the reporting queue.

This applies to MS Office 2010 and 2013.

MS Outlook integration

Toolbar and menu
Field Description
SYSPRO Credentials  
Status Connected This is displayed if a connection between Outlook and SYSPRO is established.
Status Disconnected This is displayed if there is no connection between Outlook and SYSPRO. Check that you have configured your

SYSPRO Credentials correctly.
SYSPRO Credentials Define the credentials and configuration options for SYSPRO Office Integration to MS Outlook.
SYSPRO Mail Item Creates a mail item.
SYSPRO Activities This option is only enabled when you select an email entry.
Refresh
Option Description
Yes Processes all unread items and captures them into the SYSPRO CMS where relevant (the recommended option).
No Processes all items and captures them into the SYSPRO CMS where relevant.
Cancel Exits without processing any item.
Record Selection Records the highlighted email as an activity.
Record All  
Recording Status Select this to confirm the successful capture of email activities as well as reasons why the recording an email activity has failed.

A window is displayed enabling you to view the Incoming Email Status and Outgoing Email Status.

OptionDescription
Delete AllRemoves all entries from the list view.
Delete SelectionRemoves all entries currently highlighted in the list view.
Delete SuccessfulRemoves all entries with a status of Successful from the list view.
Delete FailedRemoves all entries with a status of Failed from the list view.
Field ChooserView a list of additional fields you can add to the list view.
SYSPRO Companies  
SYSPRO company Select the company for which to review information.
SYSPRO Activity Information This option is only enabled when you open an email entry. It indicates activity and follow up information and enables you to record the email as an activity in the SYSPRO Contact Management System.
SYSPRO Reporting Services  
SYSPRO Reporting Services This opens a SYSPRO Reporting Services pane from where you can print the SRS reports. Select this icon again to close the pane.
Print Queue

If you are using SRS server-side printing, then this enables you to view completed reports or reports that are in the reporting queue.

This applies to MS Office 2010 and 2013.

SYSPRO Activity Information

This is displayed when you select Activity Options from the toolbar.

If you selected any required fields for email then you need to use the Activity Options function to record emails.

The fields on this screen enable you to define additional information for the activity before you record it in the SYSPRO Contact Management System or to change some information for an email which you have already recorded.

You can use the Contact Activity Posting program to maintain other information for an activity already recorded.

Field Description
Activity type The Activity type is only displayed if the email has already been recorded.
Email sent Indicates that the email was sent and is displayed if you selected to view the activity options for an email in your Sent Items folder.
Email received Indicates that the email was received and is displayed if you selected to view the activity options for an email in your Inbox.
From Indicates the sender's email address. This is only displayed if the email has already been recorded.
Regarding

Enter a category against which the activity must be recorded.

This defaults to the activity preference defined for Regarding (Contact Activity Posting).

If the option: Activity selection criteria - Regarding is enabled (Contact Management Setup) then you must select the regarding text from the dropdown list. If this setup option is not enabled, then you can enter your own text.
Result

Records the outcome of the activity.

This defaults to the activity preference defined for Result (Contact Activity Posting).

If the option: Activity selection criteria - Result is enabled (Contact Management Setup) then you must select a result from the dropdown list. If this setup option is not enabled, then you can enter your own result.
Location

Enter where the activity took place.

This defaults to the activity preference defined for Location (Contact Activity Posting).

If the option: Activity selection criteria - Location is enabled (Contact Management Setup) then you must select a location from the dropdown list. If this setup option is not enabled, then you can enter your own location.
Follow-Up Information  
Follow up Flag Assign a color coded flag to the activity.

This is only relevant when you record an activity against a contact linked to a SYSPRO operator.

Setting this to Cleared indicates that no further action is required for this activity. If the Follow up Flag is set to Cleared, then no Follow up information is saved against the activity.
Follow up Date Enter a date on which the activity must be reviewed.

This defaults to the current system date, but can be changed.

This field is only enabled if the Follow up Flag is NOT set to Cleared.

Follow up Time Enter a time when the activity must be reviewed.

This defaults to the current system time plus 15 minutes, but can be changed.

This field is only enabled if the Follow up Flag is NOT set to Cleared.
Record Activity Records the email activity in the SYSPRO Contact Management System.

This option is only enabled if:

  • you selected to record incoming emails
  • the email currently highlighted has not yet been recorded

When you select this option, the email is listed as an activity in your CMS Activities list view as well as in the CMS Activities list view of the contact who sent it (see Contact Query).
Save Saves any changes made to the email activity. The changes are saved against the activity in the SYSPRO Contact Management System.

This option is only displayed if the activity has already been recorded.
Record Activity in SYSPRO CMS Records a new email message you are creating in the SYSPRO Contact Management System.

This option is only displayed when you create a new email to send.

If you select this option, then when you select the Send option, the email is listed as an activity in your CMS Activities list view as well as in the CMS Activities list view of the contact to whom the mail was sent (see Contact Query).

This option is automatically selected if you selected the Default 'Record in SYSPRO CMS' checkbox to Selected option.

Print Queue

SRS Report Queue toolbar

Field Description
Time filter Filter the reports displayed in the listview.
Status Choose the status of the reports you want displayed in the listview.
Apply filter+ Select this to refresh the listview with your filter selections.
Delete Delete a report you no longer want displayed in the listview.
Re-run report Re-run any report in the listview that has a status of Error.
Show scheduled reports This opens the Schedule Status window from where you can preview or delete scheduled reports.
Purge manager

This opens the Purge Manager window from where you can purge reports by date, operator or report status from the report queue.

Reports are purged only for the SYSPRO company that you are logged into.

SRS Report Queue listview

Field Description
Report name The name of the report sent to the server.
Request date The date the report was sent to the server.
Status The status that the report is currently in.
Completed date The date on which the report was processed.
Priority You can change the priority of any report in a status of In Queue. Choose a priority of Low, Medium or High.

Select High to move the report to the front of the queue.
Report Select this link to view the report. The link is displayed when the report becomes available for printing.
Exported report If a report has been exported, then select View to open the report in the application to which it has been exported.

SYSPRO Credentials

Credentials

Field Description
SYSPRO Logon Credentials  
Operator code Enter the SYSPRO operator code you use to log in to the company defined at the Company Id field below.
Operator password Enter the password for the operator code entered.
Language code Indicate the language code to use.

Select AUTO if you want to use the same language as is defined against your SYSPRO installation.
Instance Indicate the SYSPRO instance to use. This corresponds to the number against of the BaseDir entry in your registry.
Company Id Enter the default SYSPRO company ID you want to use.

The system automatically recognizes all the SYSPRO companies to which you have access. From Outlook, you can select a different company.
Company password Enter the password for the Company ID entered.
Log detail This option applies only to e.net business objects.
OptionDescription
DebugSelect this to be warned when XML strings contain incorrect parameters - normally these are ignored.
NoDebugSelect this if you do not want to be warned when XML strings contain incorrect parameters.
Type of connection
Option Description
Web service Connects to SYSPRO using a web services link.

You typically use this if SYSPRO is not installed on your machine (e.g. you may be using a laptop from a remote location, but want to link to SYSPRO at your office). SYSPRO Web Services are also typically used when the SYSPRO application server is hosted on a different network.

Ensure that the Web Services are installed.
Client Server Connects to SYSPRO in a client/server environment.
Web Service Setup  
Web Service Enter the URL to the web service.
Test Web Service Tests the connection to your web service.
Client Server Setup
Option Description
Stand Alone SYSPRO is installed on the machine you are using (i.e. you do not have to link to a server to use SYSPRO).
Client Server You login to a server to use SYSPRO (i.e. the SYSPRO programs are located on a server).
Test Connection Tests the connection to your server.
IP Address Enter the IP address or the name of your server (i.e. the server on which SYSPRO resides).

If you are using WCF connectivity, this should be WCF:SERVER:1978 (replace SERVER with the SYSPRO application server's name or IP address, and 1978 with the SYSPRO Communication Service port that is in use).
Port This field is not used in the current version of the software.
Service This is ENCSERVER by default.

If you are using WCF connectivity, enter WCF:X (where X refers to your entry at the Instance field).

Email Configuration

You use this tab to configure how you want to integrate emails to your SYSPRO Contact Management System.

Field Description
Incoming Email  
Record incoming Email Records emails you receive from contacts and employees in the Contact Management System.

Contacts are customers, suppliers or accounts and employees are colleagues within your organization.

Each incoming email recorded is listed as an activity in your CMS Activities list view as well as in the CMS Activities list view of the contact who sent it.
Record incoming Email for unknown sender Records emails you receive from senders who are neither contacts nor employees. Unknown senders refers to people not defined in your SYSPRO Contact Management System.
[Note]

Emails for unknown senders or recipients are recorded in the Unknown Attendees table for the email and not against the Unassigned Contact in the Contact Management System.

Emails recorded from unknown senders are listed as activities in your CMS Activities list view and in the Unassigned Activities list view.

Care must be taken when selecting this option together with the Automatically record activities option, as you could create numerous unwanted activities. You would typically select this option together with the Manually record activities option as this gives you control over the recording of emails received from unknown senders.
Recording options  
Manually record activities Manually records incoming and/or outgoing emails as activities in the SYSPRO Contact Management System.

This gives you total control over which emails to record as activities in CMS.
Automatically record activities Automatically records incoming and/or outgoing emails as activities in the SYSPRO Contact Management System.
Outgoing Email  
Record outgoing Email Records outgoing (sent) emails in the SYSPRO Contact Management System.

Each outgoing email recorded is listed as an activity in your CMS Activities list view as well as in the CMS Activities list view of the contact to whom you sent it.
Default 'Record in SYSPRO CMS' checkbox to Selected Automatically records any email you send as an activity in the SYSPRO Contact Management System.
Active Directory Settings  
Domain Name Indicates the domain name of your mail server (e.g. LDAP://syspro.com).
Resolve email address using LDAP first  
Default Folders  
Default Inbox folder Indicates the Inbox folder to use for your incoming emails. This is the folder in which you want the system to check for incoming emails.

This does not have to be the standard Outlook Inbox, but can be another inbox folder you defined on your Outlook system.
Default Sent Items folder Indicates the Sent Items folder to use for your outgoing emails. This is the folder in which you want the system to check for outgoing emails.
Default Contacts folder Indicates the default Contacts folder to use.
Select Folder Displays a copy of the tree view for your Outlook email system, from which you can indicate the required folder.

Other Options

Field Description
Required fields for emails Indicate the mandatory field(s) required for the recording of all email activities created from Outlook.

This option is not available if you selected the Automatically record activities option.

[Note]

If you select any of these options, then you cannot select the Record All and Record Selection options from the SYSPRO Activities option.

This is because the mandatory field(s) indicated must be entered before the email activity can be recorded in the SYSPRO Contact Management System. Consequently, each email must be recorded individually.
Regarding Sets the Regarding field for each recorded email as mandatory.
Result Sets the Result field for each recorded email as mandatory.
Location Sets the Location field for each recorded email as mandatory.
User field 1 Sets the User field 1 field for each recorded email as mandatory.
User field 2 Sets the User field 2 field for each recorded email as mandatory.
User field 3 Sets the User field 3 field for each recorded email as mandatory.

Version

Field Description
SYSPRO Office Integration version  
SYSPRO Outlook 2007/2010/2013 Indicates the version of SYSPRO Office Integration you currently are using for MS Outlook 2007 or 2010.
SYSPRO Word 2007/2010/2013 Indicates the version of SYSPRO Office Integration you currently are using for MS Word 2007 or 2010.
SYSPRO Excel 2007/2010/2013 Indicates the version of SYSPRO Office Integration you currently are using for MS Excel 2007 or 2010.
Version available for download Indicates the latest available version which you can download from the SYSPRO Support Zone.

If you are not using the latest version, a hyperlink to the SYSPRO Support Zone is displayed.

Notes and warnings

Self-healing

  • The SYSPRO Office Integration system does not form part of the self-healing process. You must upgrade manually to each version as it is released.

Defining your SYSPRO Credentials for Office Integration

You would typically follow these steps to prevent the unauthorized access of SYSPRO data.

  1. Open the applicable Microsoft Office application (e.g. Word, Excel).

  2. Load the SYSPRO Office Integration component.

    1. Select SYSPRO Office Integration from the Microsoft Office application menu bar.

  3. Configure your SYSPRO Login Credentials.

    SYSPRO Credentials define the name of the operator and the company to access within SYSPRO. Once logged in, SOI uses SYSPRO's business objects to derive data that is securely protected using SYSPRO's own security rules. Any security changes made within SYSPRO automatically apply to SOI usage.

    1. Select SYSPRO Credentials.

    2. Enter your SYSPRO Logon Credentials.

    3. Indicate the type of connection required.

      Indicate if the connection is a web service (using the Internet) or a client server connection (connected to the server via LAN or WAN).

      For a client/server connection, there are two setup options to choose from:

      • Stand Alone

      • Client Server

      A SYSPRO client must be installed on the client machine, regardless of the client/server connection option you choose.

  4. Save your settings.

Performing a search using SYSPRO Office Integration

You would typically follow these steps search from within a Microsoft Office application such as Microsoft Excel or Microsoft Word.

  1. Open the applicable Microsoft Office application.

  2. Select the SYSPRO Office Integration tab.

  3. Select SYSPRO Search.

  4. Indicate the required search criteria.

  5. Begin the SYSPRO search.

    The results of your search are displayed in the SYSPRO Search Results pane.

    Using these results, you can, for example, add the required information to a Word document or analyze the search results in Excel.

Creating a Word document using SOI search results

  1. Open Microsoft Word.

  2. Select the SYSPRO Office Integration tab.

  3. Select SYSPRO Search and enter criteria according to which you want to perform the search and execute the search.

  4. Enter the required salutation.

  5. Locate the required customer within the search results pane and insert the customer name into the relevant area of the document.

    The customer name is located within the Customer Header bar.

  6. Insert the invoice details into the document.

    Invoice details are located within the Invoice Items bar.

  7. Insert the balance details into the document.

    Balance details are located within the Customer Totals bar.

Creating an Excel spreadsheet using SOI search results

  1. Open Microsoft Excel.

  2. Select the SYSPRO Office Integration tab.

  3. Select SYSPRO Search and enter criteria according to which you want to perform and execute the search.

  4. Locate the required customer within the search results pane and insert the customer code and name into the relevant area of the document.

    The customer code and name is located within the Customer Header bar.

  5. Insert the invoice details into the spreadsheet.

    Invoice details are located within the Invoice Items bar.

  6. Insert the balance details into the spreadsheet.

    Balance details are located within the Customer Totals bar.

Tailoring SYSPRO Office Integration search results

  1. Perform a SYSPRO search from within Microsoft Excel or Microsoft Word.

  2. Right-click on the SYSPRO Search Results pane.

  3. Select Configure Search Results from the context-sensitive menu.

  4. Select the items you want to change.

    • You can indicate which fields you want to display by checking/unchecking the relevant field.

    • You can change the display style of your search results from a listview (Collapsible Panel) to a table (Collapsible Data Grid). Once rendered as a table you can also add or remove fields by right-clicking on the table header and selecting Field Chooser from the context-sensitive menu.

  5. Save your changes.

Designing a search using SYSPRO Office Integration

  1. Perform a SYSPRO search from within Microsoft Excel or Microsoft Word.

  2. Select Design Search from the SYSPRO Office Integration toolbar.

  3. Right-click the search folder you want to configure and select Create a new search from the shortcut menu.

  4. Select the specific company, operator or role you want to configure and then save your selections.

  5. Define the specific search list criteria required within the Search Builder pane and then save your selections.

Adding a SYSPRO column to your Inbox

  • Ensure that the version of the SYSPRO Office Integration Add-in matches the version of Microsoft Outlook you are using and that you have configured your SYSPRO credentials appropriately.

You would typically follow these steps to highlight emails that are SYSPRO contacts.

  1. Open Microsoft Outlook.

  2. Right-click on any column heading within your Inbox window and select Field Chooser from the menu.

  3. Select User-defined fields in Inbox from the Field Chooser drop-down menu.

  4. Drag the SYSPRO field onto the heading area of the Inbox window.

Configuring SYSPRO for unknown senders

You would typically use this procedure to record emails received from unknown senders.

  1. Open Microsoft Outlook.

  2. Select the SYSPRO Office Integration tab.

  3. Select the SYSPRO Credentials icon from the SOI Credentials/Status portion of the SYSPRO Office Integration toolbar.

  4. Select the Email Configuration tab.

  5. Select Record incoming Email for unknown sender at the Incoming Email option.

  6. Save your settings.

Configuring SYSPRO for unknown recipients

You would typically use this procedure to record emails sent to unknown recipients.

  1. Open Microsoft Outlook.

  2. Select the SYSPRO Office Integration tab.

  3. Select the SYSPRO Credentials icon from the SOI Credentials/Status portion of the SYSPRO Office Integration toolbar.

  4. Select the Email Configuration tab.

  5. Select Record outgoing Email under the Outgoing Email option.

  6. Save your settings.

Configuring SYSPRO to record emails automatically

  1. Open Microsoft Outlook.

  2. Select the SYSPRO Office Integration tab.

  3. Select the SYSPRO Credentials icon from the SOI Credentials/Status portion of the SYSPRO Office Integration toolbar.

  4. Select the Email Configuration tab.

  5. Select Automatically record activities at the Recording Options field.

  6. Save your settings.

    If you chose to record incoming/outgoing email, then when next you receive/send an email to/from a contact it will appear in the Activities pane of the Contact Management System automatically.

Configuring SYSPRO to record emails manually

  1. Open Microsoft Outlook.

  2. Select the SYSPRO Office Integration tab.

  3. Select the SYSPRO Credentials icon from the SOI Credentials/Status portion of the SYSPRO Office Integration toolbar.

  4. Select the Email Configuration tab.

  5. Select Manually record activities at the Recording Options field.

  6. Save your settings.

    If you chose to record incoming/outgoing email, then when next you receive/send an email to/from a contact you will need to enable the Record activity in SYSPRO CMS option for it to appear in the Activities pane of the Contact Management System

Refreshing your Inbox

  • Ensure that the version of the SYSPRO Office Integration Add-in matches the version of Microsoft Outlook you are using and that you have configured your SYSPRO credentials appropriately.

You would typically use this procedure to refresh your Inbox with emails you may want to record in SYSPRO's Contact Management system.

  1. Open Microsoft Outlook.

  2. Select the SYSPRO Office Integration tab.

  3. Select the Refresh icon from the SYSPRO Activities portion of the SYSPRO Office Integration toolbar.

  4. Indicate the items you want to include for capture in the Contact Management system.

    • Select Yes to process only unread items (recommended)

    • Select No to process all items (slower).

    The Bulk Activity Status window is displayed and automatically processes your Inbox according to your selection.

  5. Close the Bulk Activity Status window.

    A checkbox is displayed within the SYSPRO column for known contacts. A tick in the checkbox indicates that the message has already been recorded as an activity in SYSPRO.

Viewing the recording status of items

  • Ensure that the version of the SYSPRO Office Integration Add-in matches the version of Microsoft Outlook you are using and that you have configured your SYSPRO credentials appropriately.

You would typically use this procedure to confirm the successful capture of email activities as well as reasons why the recording of an email activity has failed.

  1. Open Microsoft Outlook.

  2. Select the SYSPRO Office Integration tab.

  3. Select the Recording Status icon from the SYSPRO Activities portion of the SYSPRO Office Integration toolbar.

  4. Review the entries displayed.

    You can selectively delete entries by selecting the shortcut menu icon on the Incoming Email Status and Outgoing Email Status headings.

Enabling the COM Add-In for Microsoft Word and Excel 2007

The following steps describe how to add the SYSPRO Office Integration toolbar to Microsoft Word 2007 and Microsoft Excel 2007.

Ensure that you have configured the relevant text files to bind the Office COM Add-Ins to .NET Framework 2.0.

  1. Open the Microsoft Office application for which you want to enable the COM Add-In.

  2. Open the Customize Quick Access Toolbar.

  3. Locate the COM Add-Ins for the application.

    1. Select More Commands from the shortcut menu.

      The Options window is displayed for the Microsoft Office application you are configuring.

    2. Select Add-Ins from the options menu.

      The COM Add-Ins window is displayed.

    3. Select SYSPROWord2007 or SYSPROExcel2007 from the Add-ins pane.

    4. Select COM Add-Ins at the Manage field.

    5. Select Go.

    The COM Add-Ins window is displayed.

  4. Enable the COM Add-Ins for the application.

    1. Tick the relevant SYSPRO add-in from the list of available Add-Ins (e.g. SYSPROWord2007 or SYSPROExcel2007).

    2. Select OK.

    The SYSPRO Office Integration toolbar should now be accessible from within the Microsoft Office application you selected to enable.

Enabling the COM Add-In for Microsoft Outlook 2007

The following steps describe how to add the SYSPRO Office Integration toolbar to Microsoft Outlook 2007.

Ensure that you have configured the relevant text file to bind the Office COM Add-Ins to .NET Framework 2.0.

  1. Open Microsoft Outlook.

  2. Load the Customize function.

    1. Select Customize from the Tools menu.

  3. Locate the COM Add-In

    1. Select the Commands tab from the Customize menu.

    2. Select Tools from the Categories menu.

    3. Highlight COM Add-Ins from the Commands pane.

  4. Enable the COM Add-In for Microsoft Outlook.

    1. Drag the COM Add-Ins button to the Microsoft Outlook menu.

    2. Close the Customize window.

    3. Select the COM Add-Ins function.

    4. Tick the SYSPROOutlook2007 option from the list of available Add-Ins.

    5. Select Ok.

    The SYSPRO Office Integration toolbar should now be accessible from within the Microsoft Outlook application.

Enabling the COM Add-Ins for Microsoft Office 2010

The following steps describe how to add the SYSPRO Office Integration toolbar to Microsoft Word 2010, Microsoft Excel 2010 or Microsoft Outlook 2010.

Ensure that you have configured the relevant text files to bind the Office COM Add-Ins to .NET Framework 2.0.

  1. Open the Microsoft Office application for which you want to enable the COM Add-In.

  2. Locate the COM Add-in

    1. Select the Options from the File menu.

    2. Select Add-Ins from the Options window.

    3. Click on the dropdown menu at the Manage field.

  3. Enable the COM Add-Ins for the application.

    1. Highlight COM Add-Ins at the Manage field.

    2. Select Go.

    3. Enable the relevant SYSPRO add-in from the list of available Add-Ins (e.g. SYSPROWord2010, SYSPROExcel2010 or SYSPROOutlook2010).

    4. Select Ok.

    The SYSPRO Office Integration toolbar should now be accessible from within the Microsoft Office application.

Configuring SOI as a trusted source

You would typically follow these steps to ensure that Microsoft Office applications will accept the SYSPRO Office Integration application as a trusted source.

  1. Open a Command Prompt window.

  2. Navigate to the folder where .NET Framework 2.0 is located. (e.g. \WINDOWS\Microsoft.NET\Framework\v2.0.50727).

  3. Enter the command that will indicate SOI is a trusted source and press Enter.

    You will need to enter a command string for each Office COM add-in you intend using.

    • For the Microsoft Excel COM add-in enter (as a single line):

      caspol -u -ag All_Code -url "Office installation folder\
          *" FullTrust -n "SYSPROOfficeExcel" -d "SYSPRO Office Excel"

    • For the Microsoft Word COM add-in enter (as a single line):

      caspol -u -ag All_Code -url "Office installation folder\
          *" FullTrust -n "SYSPROOfficeWord" -d "SYSPRO Office Word"

    • For the Microsoft Outlook COM add-in enter (as a single line):

      caspol -u -ag All_Code -url "Office installation folder\
          *" FullTrust -n "SYSPROOfficeOutlook" -d "SYSPRO Office Outlook"

    The system will prompt you to confirm whether you want to alter security policy.

  4. Confirm your entry and close the Command Prompt window.

Configuring IIS to cater for large attachments

The following steps describe how to change the Web.Config file to allow for larger e-mail attachments when running the Record Selection SYSPRO Activity.

  1. Open the Web.Config file using your preferred text editor.

    The Web.Config file is located in the folder: c:\Inetpub\wwwroot\SOIWebService\.

  2. Append text to the file that will increase the size of attachments which IIS is able to process.

    <httpRuntime
                 executionTimeout="12000" 
                 maxRequestLength="102400" 
                 useFullyQualifiedRedirectUrl="false"
                 minFreeThreads="8" 
                 minLocalRequestFreeThreads="4" 
                 appRequestQueueLimit="100" />

  3. Save the file.

    You should now be able to run the Record Selection SYSPRO Activity as a bigger file size is allowed.