Installation

Flow Properties

Before installing the workflows, it is required to create several Global Flow Properties within Novacura Flow Studio.

Flow Text Properties

Flow Property	Example Value	Description
ExcelMigration_IFSBaseUrl	https://ifscloud.ifscloud.com	Your IFS Cloud environment base URL use for the REST Connector

Azure Services

Microsoft Graph

Create an Azure App Registration for reading and editing Excel files. The App Registration needs the following API permissions to be able to access the Excel documents.

Privileged permissions
Files.ReadWrite.All
Sites.ReadWrite.All

You will need to add additional permissions if you plan to utilize more functionality against the Graph API in other workflows.

Read more in the how-to guides Create App Registration.

• Navigate to the registered Microsoft Graph application's Authentication page

• Add ncflow://authenticate value to Mobile and desktop applications' Redirect URIs' list

• Add https://web.novacuraflow.com/ value to Mobile and desktop application's ' Redirect URIs' list

The ncflow://ncflowsuccess value is needed instead if it is used External App Launcher integration call back.

The API's used in this connector are documented here.

Read more in the how-to guides Create App Registration.

Flow Connectors

REST Connector

IFS Cloud Rest Connector

This REST connector is used to gather object information directly from IFS, It uses this information to build the mapping tables within the app.

Create a new REST Service Connector named "IFS Cloud DataMigration" and import the configuration file "IFS23R1_Connector.ncrcp". For more information see Import a REST Configuration.

• Enter Base Address as your IFS Base Url Address. eg: https://ifscloud.ifscloud.com

Follow the IFS Cloud authentication steps documented here.

Enter the Client ID, Client secret, and Realm as shown inside the Global Parameters for the REST connector from the Authentication setup above.

Microsoft Graph API

A REST Connector Project must be set up to utilize Microsoft Graph APIs.

Create a new REST Service Connector named "Microsoft Graph REST" and import the configuration file "Excel_Connector.ncrcp". For more information see Import a REST Configuration.

• Enter a Base Address https://graph.microsoft.com

• Set up the parameters for OAuth2 authentication

Parameter	Value	Description	Required
Enabledb	Checked✔️	To enable OAuth2 Authentication in REST connector
Access Token URLec	https://login.microsoftonline.com/{tenant_id}/oauth2/v2.0/token	URL to get token
Auth URLR	https://login.microsoftonline.com/{tenant_id}/oauth2/v2.0/authorize	URL to authorize
Client ID	{client_id}	The Application (client) ID that the Azure portal – App registrations experience assigned to your app.
Client Secret	{client_secret}	The application secret that you created in the app registration portal for your app. You shouldn't use the application secret in a native app or single page app because client_secrets stored on devices or web pages are not reliable.
Scope	https://graph.microsoft.com/.default	For ID tokens, must be updated to include the ID token scopes - openid, and optionally profile and email.
Extra query parameters	{"login_hint": "[e-mail]", "prompt": "login"}	To add extra paramters if needed. It has to be in JSON format.

IFS OData Connector

If you do not have a connector set up, you can see an example here.

If you already have an IFS Cloud OData connector setup, you can skip this step and use the existing connector instead.

For how to add a new projection to the connector click here.

Mandatory Projections

Projections Used
PrepareWorkOrderHandling
CustomerHandling
PartHandling
SupplierHandling

Installation

Make sure that you have created all connectors before importing the workflows.

1. Import Workflows

Import workflows in the file "Excel Connector.wap."

For details see Import Workflows

2. Setting Menu Roles

Together with the imported workflows, there will also be a menu. Connect the menu to your roles to make them available for users.

For details see Setting Menu Roles

3. Publishing Workflows

Within the Server Contents Window, right-click on the Excel Connector folder and select “Publish.” This process can take a few minutes but once complete, a Publish Successful message will be displayed.