SharePoint Connector for SysConnnect

From FabSoft
(Redirected from Reform SharePoint)
Jump to: navigation, search

The SharePoint plug-in acts as a bridge between SysConnect and SharePoint/Office 365 SharePoint. It allows you to archive documents processed by SysConnect to SharePoint Document Libraries where your collection of documents can be shared.

SysConnect maximizes the integration with Microsoft’s SharePoint by enabling automatic delivery of document information from any operating system, application or device. Whether a document is being printed from the host, scanned in using an MFP or copier, or generated by a user from an application, SysConnect will capture the process, extract the text and intelligently archive it to SharePoint. With Reform’s alternative input options, more of your valuable information can be effortlessly accessed and easily shared company-wide through SharePoint. SysConnect can control directory locations as well as custom index information to simplify document retrieval. Fast and easy access to important information is an extremely vital resource, and Reform’s integration capabilities to SharePoint let you obtain the most comprehensive document information archive to improve the workflow of your business operations.

Software & Hardware Requirements

Click Here

Tutorial - Sending Your First Document to SharePoint

First, the SysConnect VDP must be started. To open it, go to your Desktop FabSoft > SysConnect >SysConnect Form Designer.

1. For the example, we will be creating a new form with an existing template. Go to File > New > New. Select the SHAREPOINT.FTM and click OK.

Reform15 SharePoint 04.png

2. When it asks if you would like to open a text file for designing, select No.

3. Next, go to File > Save to save your form. Name it SharePointPackingSlip.FOM

4. You can now close the SysConnect Form Designer since we have our form which we will be using alongside the Workflow Designer to route the document.

5. *Now that we have our form, we can begin to create the desired SharePoint workflow using the Workflow Designer. First, the Workflow Designer must be started.

6. To open it, go to your Desktop FabSoft > Base > Workflow Designer

7. Once open, we must go to File > New…

Reform15 SharePoint 05.png

8. Select "Document Automation" and click Ok.

Reform15 SharePoint 06.png

9. You will now notice that your Inputs, Processes, and Outputs have been populated by the various plugins you have installed (SharePoint being one of the Outputs).

Reform15 SharePoint 07.png

10. Once opened, we can start adding the necessary components to the workflow. First, drag and drop a Form and File object onto the workflow by clicking and holding your mouse on Form and File and then moving your mouse over to the workflow and releasing the mouse button.

Reform15 SharePoint 08.png

*You will be prompted with the following dialog:

Reform15 SharePoint 09.png

11. Enter a description for the object you just added. This is done by typing in the provided box. Type "SharePoint Demo" and click Finish. This will take you back to your workflow.

12. Now we are ready to configure the "SharePoint Demo" form and input file. To do so, right-click on the newly added object and select "Configuration…" or simply double-click on it.

Reform15 SharePoint 10.png

13. You are now presented with the Input Setup window. First, we want to select the TextFile or data stream that our form will be using. To do so, you can simply begin typing in the box, or you can browse to find it. We want to select the SharePointPackingSlip.out file. Click the small folder icon to bring up a window that will let us choose that file. Select the file and click Open.

Reform15 SharePoint 11.png

14. After choosing the text file, you are taken back to the Input Setup page so that you can now select a form. Click the small folder icon to bring up a window that will let us choose the desired SharePointPackingSlip.FOM form file. Select the FOM file and click Op'''e'''n.

Reform15 SharePoint 12.png

15. Now that you have both your Input Text File and SysConnect Form selected, the setup of Form and File is complete. You can quickly double-check that the correct files are selected and then click Finish.

Reform15 SharePoint 13.png

16. You will also be prompted to add a page-break field to the forms. At this point, we want to select No.

17. To finish the SharePoint workflow, we want to add a SharePoint Output. We use the same drag and drop procedure as with the "Form and File" (see step 9). Take your mouse and drag the "SharePoint" object from under Output onto the workflow somewhere below your Input. Once you release your mouse, you will be prompted to describe "SharePoint". Type "SharePoint Upload" in the box and then click Finish.

Reform15 SharePoint 14.png

18. Once you click Finish, you are taken back to your workflow. Your SharePoint will have a Red Caption because it is not yet configured. To configure SharePoint, you must first connect the Form and File object titled "SharePoint Demo". To do so, first select the "Add Connector" button from the menu bar. Next, drag your mouse from the small "x" underneath "SharePoint Demo" to the small "x" above "SharePoint Upload" as pictured below. When the connection is complete, the connecter will turn black (if red, connection has not been made correctly, try again) and the "SharePoint Demo" caption will turn green.

Reform15 SharePoint 15.png

19. You will be prompted to configure SharePoint upon completing the connection. Click Yes. If you clicked No, you can double click on the SharePoint object or rightclick and select "Configuration…" to begin the setup. This configuration will step you through all the settings necessary for SharePoint to successfully connect to a SharePoint server and upload files. The first piece of information is the file type you want your document to be archived with into SharePoint. Select "PDF File" and click Next.

Reform15 SharePoint 16.png

20. To use your SharePoint account, go to your SharePoint Site and copy in the SharePoint URL from your browser.

Reform15 SharePoint 17.png

21. Enter the Username. Click Next.

Reform15 SharePoint 18.png

22. Type in the password and click on Next.

Reform15 SharePoint 19.png

23. Skip the domain field by clicking on Skip.

Reform15 SharePoint 20.png

24. You might need to wait a few minutes while it’s loading the SharePoint properties. If you entered any incorrect information, close any dialogs that may come up and try the configuration again. When the wizard window appears, Select Tutorial for the Document Library where you would like to upload your document. Click Next. Note: If you are using a different SharePoint server than the one described in this tutorial, you may see different libraries available.

Reform15 SharePoint 21.png

25. Select Tutorial for the directory and click Next.

Reform15 SharePoint 22.png

26. Type in a Filename. Using a unique file name will help you find the file easier later. Click Next.

Reform15 SharePoint 23.png

27. The following screen asks for the CUSTOMER NAME that the upload will be archived under. Here we would like to use data that is available in the data stream instead of a static value. To do so, we first must click the "Click here to select variable information" button. Note: The attributes available for configuration are based on the directory selected. If you select a different document library or folder, you may see different attributes than the ones listed in the next few steps of this manual.

Reform15 SharePoint 24.png

*Note-After doing so, we see that a list will appear with the different fields that you can choose for your variable data. We will be selecting from this list, but if you needed to still type static data, you can do so by clicking the appropriate button for static information and then typing it in.

28. Now we want to use ShipAddress as our "CUSTOMER NAME" value. Select ShipAddress from the list and click Next

Reform15 SharePoint 25.png

29. For "DATE", we would like to again use variable data from the print stream. To do so, first click the button "Click here to select variable data". From the list that appears, select ShipDate and click Next.

Reform15 SharePoint 26.png

30. Type in 121280 for the Deal Number and click Finish.

Reform15 SharePoint 27.png

31. You have completing configuring your simple SharePoint workflow. Your 2 objects ("SharePoint Demo" and "SharePoint Upload") should all be green meaning they have been successfully configured and the workflow is ready to be created.

Reform15 SharePoint 28.png

32. To make all the appropriate forms and changes, the workflow must be executed. This is done by clicking the "Execute" button

Reform15 SharePoint 29.png

on the menu bar. After execution, you will be notified about what has taken place. Click OK.

Reform15 SharePoint 30.png

33. You can now close the Workflow Designer. Your form has been saved in your default forms directory. A backup of your original SharePointPackingSlip.FOM file has been copied to the "Workflow Designer Original Forms" folder in your forms directory. Any permanent form changes should be made to this original form as it is used throughout the form configuration process as a template. If changes are made to this template, you will have to execute your workflow again to see the changes in the forms.

34. To test your settings and make sure that files can be uploaded, the Spooler should be started by clicking Start > Programs > Reform… > Spooler. Once it is open, press the Start button.

*If it was already running, it will need to be stopped and restarted so that it recognizes the new forms that were created by the Workflow Designer.

Note: make sure that SharePoint Service is running. For more information please see the Starting SharePoint Service section at the end of this document to start it manually.

Reform15 SharePoint 31.png

35. Navigate to your \Reform…\Backups\ directory. Select the SharePointPackingSlip.out file, right click the file, and select Copy

Reform15 SharePoint 32.png

36. Navigate to your \Reform…\Spooler\ directory. Paste the file into the Spooler directory. (Pasting the data stream to this folder simulates printing from Windows, AS400, Unix, etc.) FabSoft has many capture agents that will deliver the print job or file into this directory automatically see Capture Agents. A Popular method is to user the included printer driver, Video

Reform15 SharePoint 33.png

37. When the Spooler Application begins processing the file, you will notice the file name change to something similar to the image below.

Reform15 SharePoint 34.png

38. Once the document is processed, the demonstration is complete. If you are not getting your output, SysConnect Spooler might not have the correct permissions to process the file. Please see the SysConnect manual for more information. You can re-test the document by copying the file from the backup directory to the spooler directory again. You can also create a new form and configure it using the Workflow Designer

Viewing your document in FabSoft’s SharePoint Demonstration Site

1. Open your internet browser and copy this address

Reform15 SharePoint 35.png

2. You will be asked to enter the username and password on the next screen so please take note of the Username and Password. Click on Continue.

3. Enter the username and password from the previous screen. Click Ok.

Reform15 SharePoint 36.png

4. On the left side under Documents, click on Tutorial to see your uploaded document.

Reform15 SharePoint 37.png

5. Documents uploaded are listed in the Tutorial Library. You can open the document and also view the attributes associated with the document.

Reform15 SharePoint 38.png


There are certain directories and SQL tables that need to be monitored for growth along with the MOST plug-in for Reform. As a system processes more and more jobs, the size of these directories and SQL tables can grow very quickly. Overall system performance can be affected by the large amounts of space that the files may take up. Also, there exists a 10GB database limit if using the Microsoft SQL Server Express supplied with this installation. Obsolete files/database entries should be deleted according to your needs and file retention specifications.

Please see the Reform Health Monitor and Maintenance Utility section in the SysConnect User Manual for more information and instructions for monitoring and maintaining your server. It is recommended to monitor the following directories and SQL tables for growth:


C:\Program Files\Reform…\Backups

C:\Program Files\Reform…\Spooler\ImageQueue

C:\Program Files\Reform…\Plugins\SharePoint\Uploads

SQL Tables:


Starting SharePoint Service

Go to Control Panel > Administrative Tools > Services

Right click on RM_SharepointMonitor > Properties. Under Service status click on Start.

Reform15 SharePoint 39.png

This service acts as a liaison between SysConnect and Microsoft SharePoint. It allows for SysConnect to upload documents and their properties to the SharePoint server.


Q: Nothing is happening after the form is processed. How can I determine the cause of an issue?

A: Check the Event Log for errors related to SysConnect or the SharePoint service. The Event Log can be access by going to Control Panel > Administrative Tools > Event Log. This will usually give you a good idea about why the SharePoint plugin might be failing.

Other company or product names mentioned herein may be trademarks or registered trademarks of their respective companies

SharePoint Issue Ticket

*User’s Name: ___________________________________ *User’s Login Name: ______________________________

*User’s Email Address: ____________________________ User’s Building: _________________________________

User’s Department: ______________________________ Support Contact’s Name: __________________________

Support Contact’s Email: __________________________ Support Contact’s Phone: __________________________

*Severity of Issue (Please check one):

    □ 0 - Test environment (non-production)
    □ 1 - Users are affected, but able to continue business

□ 2 - Users are affected and it is affecting business, other functionality is working properly

□ 3 - The software is not functioning properly at all – system outage

Number of Users Affected: _____________ List Each Users Login Name ________________________________



*Description of Issue:





*Observations about issue:

Frequency of Issue: Once / Random / Every Attempt / Other (Please Describe): ________________________________


First Occurrence (Date/Time): _____________________ Latest Occurrence (Date/Time): ________________________

  • *Issue is occurring at (Fill in all fields for SysConnect Server and SharePoint):
  • Reform Server(s)

Reform Server IP(s): _____________________________________________________________________________

  • SharePoint

SharePoint URL: ________________________________________________________________________________

* Additional Information

*Have any changes been made to the SysConnect Server or Environment? yes / no If yes, What? When? By Who?



*Can the user access SharePoint website? yes / no If no, please explain ____________________________________


*Did the user’s credentials (username/password) change recently? yes / no If yes, When? ______________________

*If speed is an issue, please list the time it takes a document to process to SharePoint: _______seconds / minutes

Additional information when using the MOST plug-in with Reform

Is caching being used? yes / no

  • MFP (If using the MOST Plug-in for SysConnect from an MFP)

Number of MFPs Affected:_______________________

MFP Java Version:______________________________ MOST Version: _________________________________

MFP Serial #:__________________________________ MFP IP: _______________________________________

MFP Model #: _________________________________ MFP Location: __________________________________

  • Workstation (If using the MOST Desktop Plug-in for SysConnect from a workstation)

Number of Workstations Affected: ________________ Workstation OS: XP / Vista / 7 / 10

Workstation IP: ________________________________ Workstation Name: _____________________________

* Fields are required