frevvo v9.0 Documentation

Software Download Directory

Versions Compared

Old Version 2

changes.mady.by.user MaryAnn Rapuano

Saved on

compared with

New Version Current

changes.mady.by.user Megan Ellis

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column

 

The frevvo SharePoint Connector and wizard , make it easy to create forms and approval workflows that validate information, route for signatures as required and save the data and documents to a secure SharePoint website. The Connector was designed to integrate with Office 365 SharePoint Online.
 All customers need a valid Office 365 SharePoint account.Submissions can contain multiple files of different types - Invoice, Receipt, PO etc. You may want to save these files in different locations on your SharePoint site.The SharePoint Connector wizard, allows you to:
  1. Save the form/flow data and metadata to a SharePoint destination. The destination could be a folder in a document library and/or a list item.
  2. Designers select Select the SharePoint destination from a dropdown.
  3. Map form/flow control values to the SharePoint columns.
  4. Configure two destinations for your data.
The
Frevvoproduct
SharePoint wizard guides you through connecting your forms/flows to SharePoint.

Image Modified
Column
width300px

On This Page:

Table of Contents
maxLevel2

...

frevvo - SharePoint Configuration Scenarios

  1. Cloud Customers Connecting to SharePoint Online - This configuration had been certified by frevvo. Follow these steps:
    1. Configure Live Forms frevvo as a SharePoint Add-in
    2. Configure SharePoint for your Live Forms frevvo tenant.
    3. Connect your Forms/Flows using the SharePoint wizard.

  2. In-house Customers connecting to SharePoint Online - This configuration has been certified by frevvo.   Follow these steps:

    Info

    frevvo only supports/certifies the SharePoint Connector running in the Apache Tomcat container.

    1. Configure Live Forms frevvo as a SharePoint Add-inConfigure SharePoint for your Live Forms tenant
    2. Download the  the SharePoint Connector. Rename it to sharepoint.war. Copy it to the <frevvo-home>\tomcat\webapps folder
    3. Configure SharePoint for your frevvo tenant
    4. Connect your Forms/Flows using the SharePoint wizard.

  3. In-house customers using SharePoint On-premise - this configuration is supported but not certified.
    1. Customers using SharePoint On-premise also need an Office 365 SharePoint Online account. This is necessary to obtain an authorization token. There is no data transfer from the SharePoint On-premise to SharePoint Online.
    2. Customers are responsible for configuring the On-premise installation and the integration with SharePoint Online.
    3. The On-premise version of SharePoint must be version 2013+.
    4. Refer to this Microsoft website for information about how to use Office 365 to allow 
      Frevvoproduct
      to authenticate.

  4. Live Forms frevvo Cloud customers connecting to SharePoint On-premise - This configuration is supported but considered unlikely as SharePoint On-premise requires your On-premise SharePoint to be exposed to the Cloud.
    1. Customers are responsible for configuring the On-premise installation and it's exposure to the Cloud. 

...

These instructions assume you are a frevvo Cloud customer or have an in-house installation of 

Frevvoproduct
 up and running using the frevvo Tomcat bundle. Follow these steps:

Step 1 - Configure

...

frevvo as a SharePoint App/Add-in

Frevvoproduct
must be added as a SharePoint provider hosted add-in by your global Office 365 tenant SharePoint Administrator. The process is described in Steps 1 and 2 on this Microsoft SharePoint website. Copy the Client Id and client Secret and save them somewhere on your desktop. You will need to add these values when configuring your tenant for SharePoint.

...

Code Block
<AppPermissionRequests AllowAppOnlyPolicy="true">
<AppPermissionRequest Scope="http://sharepoint/content/tenant" Right="Manage" />
</AppPermissionRequestsAppPermissionRequests>

Remember SharePoint only allows https.

Tip
We recommend that you create a separate user in SharePoint for frevvo forms connection, and use that user while configuring the Save to SharePoint wizard in frevvo forms. This frevvo specific SharePoint user always remains active and eliminates issues if the designer user configured your forms to submit to SharePoint using their own SharePoint login and then leaves the company.

Step 2 - Configure the

...

frevvo Tenant for SharePoint

Cloud and in-house customers must configure their

Frevvoproduct
tenant to connect to SharePoint as a client. frevvo expects that customers will only be integrating with one SharePoint instance for their organization. You will need the SharePoint Client Id and the Client Secret from Step 1.

...

  1. Login to

    Frevvoproduct
    as the tenant admin

  2. Click the Edit Tenant link.

  3. Click the  blue arrow to expand the SharePoint section.

  4. Enter the Connector URL. - This URL is needed if you are using 

    Frevvoproduct
    in the cloud and installing the connector locally. Enter the URL where your
    Frevvoproduct
    installation that is configured for SharePoint is located. This URL must use the https protocol.

    The URL in the Connector URL field will override the connector URL that is specified in the configuration property in the <frevvo-home>\tomcat\conf\frevvo-config.properties file. In some cases you can leave this field blank.

    Info

    The default value is shown below:
    frevvo.sharepoint.connector.url=http://localhost:8082/sharepoint

  5. Enter the Client Id and the Client Secret that you saved in Step 1 into the respective fields.



  6. Enter the SharePoint Domain Name e.g. <Your SharePoint tenant name>.sharepoint.com - there is a dot between the SharePoint tenant name and sharepoint.com
  7. To determine the realm for your SharePoint site :

    1. Navigate to https://<tenant>.sharepoint.com/_layouts/appprincipals.aspx - change the <tenant> to the name of your SharePoint tenant - e.g. https://frevvo.sharepoint.com/_layouts/appprincipals.aspx

    2. Find your registered application in the list and and look at the App Identifier column. The unique identifier after the @-sign in the App Identifier is the app realm and must be entered in the Realm field.



  8. Click Submit
  9. Browse http://<your server:port>/sharepoint/health (replace <your server:port> with your frevvo server:port) to check the status of the connector. If the connector is up and running, you will see { "status" : "UP" }.
  10. Proceed to Connect Forms/Flows with the Save to SharePoint wizard

Step 3 - Connect Forms and Flows with the SharePoint wizard


Excerpt

  1. Login as a 

    Frevvoproduct
    designer user. If you are In-House
    Frevvoproduct
    connecting to Sharepoint in the cloud, use the URL https://<server>:<SSL port>/frevvo/web/login. Example: https://localhost:8443/frevvo/web/login. Port 8443 is the default.

  2. Create your form or flow with controls that capture the data that you want to store in the columns configured in the Lists and Libraries on your SharePoint website

  3. Click on the Image Modified Edit Form/Flow Properties icon on the designer toolbar.

  4. Select

...

  1. Send to Sharepoint

...

  1. . If the tenant is not configured for SharePoint, the

...

  1. Send to SharePoint

...

  1. option will not display.

...


  1. Image Added

  2. Click Login. You’ll be redirected to login to SharePoint or Office 365 if you are logging into your account for the first time.

    1. On successful login, you will be asked to grant or deny access for your 

      Frevvoproduct
      SharePoint add-in.

      Image Modified
      Click Trust It to authenticate and grant permission to 
      Frevvoproduct
      . You will not see the trust screen on subsequent logins. The wizard will display.

      Tip
      • We recommend that you create a separate user in SharePoint for frevvo forms connection, and use that user while configuring the Save to SharePoint wizard in frevvo forms. This frevvo specific SharePoint user always remains active and eliminates issues if the designer user configured your forms to submit to SharePoint using their own SharePoint login and then leaves the company.
      •  At least one designer user must also be a SharePoint user with the correct privileges to provide consent when invoking the Save to SharePoint wizard if your tenant is configured with the Azure SAML Security Manager .
  3. You can set up a single Document Action to write to multiple places (SharePoint Library and List). Add a route for the second destination by clicking the Image ModifiedRoute 2 icon.
    Image Added

    1. Select a format for the Snapshot to be saved in SharePoint. The choices are: PDF, PNG or JPEG. If you do not check the Snapshot checkbox under the Destination Type section, you can leave this field empty.

...

    1. PDF is the default.

    2. Enter the site URL - this is the SharePoint site or subsite containing the destination e.g. https://frevvo.sharepoint.com - Remember this URL must specify the https protocol. This value is read in from the SharePoint tenant configuration screen for Route 1.

    3. Set up the first location (route) where you want to save your files in SharePoint. SharePoint destinations can be a Library (and optionally a Folder), or List. Select Library or List from the Destination Type dropdown.

The wizard pulls the list of Libraries and Lists configured on your SharePoint site to populate the Library/List dropdown. Select Library or List. Only destinations that the user has access to are displayed.

...

    1. Enter the server relative path of the folder within the library. For example, for folder 'test' in library 'mylib', enter /mylib/test.

    2. Select a Content Type from the dropdown. The wizard automatically pulls the content type choices from your SharePoint site. The Content Type determines the available metadata column names for mapping. For example, if the destination is a Document list you would see Item as a choice for the Content Type. This means your submission is saved as a new item on your SharePoint list. Document Libraries show Document.as the Content Type.

    3. Check the types of files to be saved to the selected destination. The choices are:

      1. Data -

...

      1. include the

        Frevvoproduct
        XML document

...

      2. Snapshot -

...

      1. include a snapshot of your form/flow in the format selected in the Send Snapshot

...

      1. field

...

...

      1. Attachments -

...

      1. include attachments uploaded to your forms/flows

...

      1. . The wizard automatically lists the Upload Controls in your form/flow by name when Files is checked. The attachments for the selected Upload Controls will be saved in the configured destination. 

      2. Gen Forms(PDF) - this checkbox appears if you have mapped PDFs associated with your form/flow e.g. W-4 and I-9 filled out by a new employee. Select the mapped PDFs that you want to store in SharePoint.
        Image Added

...

      1. Image Added

    2. Map the Control Names in your form/flow to the column names in your SharePoint destination. The wizard will populate the Column Name dropdown with all the columns in the destination but a maximum of 15 controls can be mapped.

      Tip

      When mapping Message controls with templates to the SharePoint Connector, the Save Value property should be checked.

  2. Click Submit.

  3. Click the Image Modifiedsave and test icon to save the form/flow and bring up Test mode popup.

  4. If you configure a second Route, clicking the Clear Route button removes the information for Route 2 only.

...


  1. Image Added


Special Characters in Filenames

...

  •  If you leave the PDF Name property blank, Live Forms frevvo uses the flow/form name as the pdf file name. The PDF will not post to SharePoint generating an HTTP 500 403 status error if the Form Name contains special characters. To avoid any issues, name your form/flows using characters that are suitable for filenames and explicitly set the pdf name in the form/flow using the same standard. Following the POSIX filename standard (A–Z a–z 0–9 . _ - ) will ensure it works.
  • Special characters in filenames will cause the submission to be flagged with an error in the
    Frevvoproduct
    submission table. We recommend POSIX naming standards as there are some special characters that are not supported by the connector. 


Section
Column
width50%

< (less than)
> (greater than)
: (colon - sometimes works, but is actually NTFS Alternate Data Streams)
" (double quote)
/ (forward slash)
(backslash)
| (vertical bar or pipe)
? (question mark)
* (asterisk)

Column

Image Added

This can happen if you do not name the PDF file, and it defaults to your form/workflow name, if that name has special characters.


Check Submissions on SharePoint

...

At least one designer user that is going to be connecting forms/flows to SharePoint with the Save to SharePoint wizard must also be a SharePoint user with the correct privileges to provide consent if your tenant is configured with the Azure SAML Security Manager.

...

If the submission doesn't reach your SharePoint website - if

Frevvoproduct
does not receive a response back from SharePoint with a status code of 200, you can find information about the error from the
Frevvoproduct
submission table.

All tenant admin(s) in your tenant or flow admin(s) configured for specific workflows will receive a Doc Post Failure notification email to alert them that an issue has occurred. The <server-name> will be provided in the email subject.

...

  1. Browse http://<your server:port>/sharepoint/info  - the version information is returned as shown in the image.

 

 

...

Refresh Token Expired

If your users see an error like "org.springframework.security.oauth2.client.resource.UserRedirectRequiredException: A redirect is required to get the users approval" when accessing or trying to submit a form, the cause is that your Sharepoint Token has expired. The user who owns the Sharepoint Account (usually the designer) will need to login and provide consent to refresh the token. You can learn more in this Microsoft Documentation. Currently frevvo does not provide a way to generate a new refresh token automatically. This feature may be added in a future release. However, until then the Sharepoint account user will have to provide consent for a fresh token every 6 months.