SharePoint Connector for SysConnnect
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
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.
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…
8. Select "Document Automation" and click Ok.
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).
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.
*You will be prompted with the following dialog:
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.
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.
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.
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.
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.
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.
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.
20. To use your SharePoint account, go to your SharePoint Site and copy in the SharePoint URL from your browser.
21. Enter the Username. Click Next.
22. Type in the password and click on Next.
23. Skip the domain field by clicking on Skip.
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.
25. Select Tutorial for the directory and click Next.
26. Type in a Filename. Using a unique file name will help you find the file easier later. Click Next.
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.
*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
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.
30. Type in 121280 for the Deal Number and click Finish.
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.
32. To make all the appropriate forms and changes, the workflow must be executed. This is done by clicking the "Execute" button
on the menu bar. After execution, you will be notified about what has taken place. Click OK.
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.
35. Navigate to your \Reform…\Backups\ directory. Select the SharePointPackingSlip.out file, right click the file, and select Copy
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
37. When the Spooler Application begins processing the file, you will notice the file name change to something similar to the image below.
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
1. Open your internet browser and copy this address
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.
4. On the left side under Documents, click on Tutorial to see your uploaded document.
5. Documents uploaded are listed in the Tutorial Library. You can open the document and also view the attributes associated with the document.
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:
Go to Control Panel > Administrative Tools > Services
Right click on RM_SharepointMonitor > Properties. Under Service status click on Start.
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 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