Marketplace Documentation
  • 🛒Novacura Marketplace Documentation
  • Applications
    • Explore Apps
      • IFS
        • Shop Floor Reporting
          • Change Log
            • IFS Application 10
            • IFS Cloud
          • Installation
            • IFS Application 10
            • IFS Cloud
          • Documentation
            • IFS Application 10
              • Portal 2 Reporting
              • Report Setup and Production
              • Report Downtime
              • Report Indirect Time
              • Register Tool
              • Report Scrap
              • Issue Material
              • Approve Operations
              • Manual Issue Material
              • Inspection (Control Plan Analysis)
              • Receive By-Products
              • Create MRB
              • Upload Document
              • Download Document
              • Manual Receive
            • IFS Cloud
              • Portal 2 Reporting
              • Report Setup and Production
              • Report Downtime
              • Report Indirect Time
              • Register Tool
              • Report Scrap
              • Issue Material
              • Approve Operations
              • Manual Issue Material
              • Inspection (Control Plan Analysis)
              • Receive By-Products
              • Create MRB
              • Upload Document
              • Download Document
              • Manual Receive
        • Mobile Work Order
          • Change Log
            • IFS Application 10
            • IFS Cloud
          • Installation
            • IFS Application 10
              • Flow Classic
              • Flow Connect
            • IFS Cloud
              • Flow Classic
              • Flow Connect
          • Documentation
            • IFS Application 10
              • Mobile Work Order App
              • My Tasks (Inbox)
              • My Tasks (Inbox) Cont.
              • Pool Tasks (Inbox)
              • New Work
              • Objects
              • PO Receipts
              • Invoice (Inbox)
              • Service Quotation
            • IFS Cloud
              • Mobile Work Order App
              • My Tasks (Inbox)
              • My Tasks (Inbox) Cont.
              • Pool Tasks (Inbox)
              • New Work
              • Objects
              • Invoice (Inbox)
              • PO Receipts
              • Service Quotation
        • Travel and Expense
          • Change Log
            • IFS Application 10
            • IFS Cloud
          • Installation
            • IFS Application 10
              • Flow Classic
              • Flow Connect
            • IFS Cloud
              • Flow Classic
              • Flow Connect
          • Documentation
            • IFS Application 10
              • Create Expense
              • Review Expenses
              • Confirm Expenses
              • Approve Expenses
              • Emailed Receipts Service
              • Emailed Receipts
            • IFS Cloud
              • Create Expense
              • Review Expenses
              • Confirm Expenses
              • Approve Expenses
              • Emailed Receipts Service
              • Emailed Receipts
        • Permission Manager
          • Change Log
          • Installation
          • Documentation
            • Permission Manager
        • Warehouse Management
          • Change Log
            • IFS Application 10
            • IFS Cloud
          • Installation
            • IFS Application 10
              • Flow Classic
              • Flow Connect
            • IFS Cloud
              • Flow Classic
              • Flow Connect
          • Documentation
            • IFS Application 10
              • Inventory Part In Stock selection
              • Basic Data
                • Change Default Site
              • Procurement
                • Register Arrivals
                • Attach Receipt to Handling Unit
                • Unattach Receipt from Handling Unit
                • Move Part In Receipt
              • Warehouse Handling
                • Find Inventory
                • Move Inventory Part
                • Move Handling Unit
                • Count Inventory Part
                • Count Handling Unit
                • Count Inventory Part Per Count Report
                • Count Handling Unit Per Count Report
                • Issue Inventory Part
                • Scrap Inventory Part
                • Scrap Handling Unit
                • Start Transport Task
                • Process Part on Transport Task
                • Process Handling Unit on Transport Task
                • Receive Inventory Part from Transit
                • Receive Handling Unit from Transit
                • Create Material Requisition Line
                • Issue Material Requisition Line
                • Start Warehouse Task
                • Park Warehouse Task
              • Customer Order & Shipment
                • Start Picking
                • Report Picking of Parts
                • Report Picking of Handling Units
                • Deliver Customer Order
                • Delivery Confirmation of Customer Order
                • Process Shipment
                • Pack into Handling Unit on Shipment
                • Unpack from Handling Unit on Shipment
                • Reassign Handling Unit on Shipment
                • Return Parts from Shipment Inventory
                • Return Handling Units from Shipment Inventory
                • Move Parts Between Shipment Inventories
                • Move Handling Units Between Shipment Inventories
                • Scrap Parts in Shipment Inventory
                • Scrap Handling Units in Shipment Inventory
              • Handling Unit Management
                • Create Handling Unit
                • Modify Handling Unit
                • Delete Handling Unit
                • Attach Part to Handling Unit
                • Unattach Part from Handling Unit
                • Change Parent Handling Unit
              • Maintenance
                • Manual Issue Work Order
                • Unplanned Issue Work Order
                • Unissue Work Order
              • Manufacturing
                • Report Picking of Part Shop Order Picklist
                • Report Picking of Handling Unit Shop Order Picklist
                • Manual Issue Shop Order Part
                • Manual Issue Shop Order Handling Unit
                • Receive Shop Order
                • Receive Shop Order Handling Unit
                • Receive Shop Order By-Product
            • IFS Cloud
              • Inventory Part In Stock selection
              • Basic Data
                • Change Default Site
              • Procurement
                • Register Arrivals
                • Attach Receipt to Handling Unit
                • Unattach Receipt from Handling Unit
                • Move Part In Receipt
              • Warehouse Handling
                • Find Inventory
                • Move Inventory Part
                • Move Handling Unit
                • Issue Inventory Part
                • Scrap Inventory Part
                • Scrap Handling Unit
                • Count Inventory Part
                • Count Handling Unit
                • Count Inventory Part Per Count Report
                • Count Handling Unit Per Count Report
                • Create Material Requisition Line
                • Issue Material Requisition Line
                • Receive Inventory Part From Transit
                • Receive Handling Unit from Transit
                • Start Transport Task
                • Process Part on Transport Task
                • Process Handling Unit on Transport Task
                • Start Warehouse Task
                • Park Warehouse Task
              • Customer Order & Shipment
                • Start Picking
                • Report Picking of Parts
                • Report Picking of Handling Units
                • Deliver Customer Order
                • Delivery Confirmation of Customer Order
                • Process Shipment
                • Pack into Handling Unit on Shipment
                • Unpack from Handling Unit on Shipment
                • Reassign Handling Unit on Shipment
                • Move Parts Between Shipment Inventories
                • Move Handling Units Between Shipment Inventories
                • Return Parts from Shipment Inventory
                • Return Handling Units from Shipment Inventory
                • Scrap Parts in Shipment Inventory
                • Scrap Handling Units in Shipment Inventory
              • Handling Unit Management
                • Create Handling Unit
                • Modify Handling Unit
                • Delete Handling Unit
                • Attach Part to Handling Unit
                • Change Parent Handling Unit
                • Unattach Part from Handling Unit
              • Maintenance
                • Manual Issue Work Order
                • Unplanned Issue Work Order
                • Unissue Work Order
              • Manufacturing
                • Manual Issue Shop Order Part
                • Manual Issue Shop Order Handling Unit
                • Report Picking of Part Shop Order Pick List
                • Report Picking of Handling Unit Shop Order Pick List
                • Receive Shop Order
                • Receive Shop Order Handling Unit
                • Receive Shop Order By-Product
        • Worksite Field Reporting
          • Change Log
            • IFS Application 10
            • IFS Cloud
          • Installation
            • IFS Application 10
              • Flow Classic
              • Flow Connect
            • IFS Cloud
              • Flow Classic
              • Flow Connect
          • Documentation
            • IFS Application 10
              • Default Project Selection
              • Crew Management
              • Crew Time Report
              • My Time Report
            • IFS Cloud
              • Default Project Selection
              • Crew Management
              • Crew Time Report
              • My Time Report
        • Maintenance Survey
          • Change Log
            • IFS Cloud
          • Installation
            • IFS Cloud
          • Documentation
            • IFS Cloud
              • Creation of Maintenance Surveys
              • Execute Maintenance Survey
      • Infor M3
        • Change Log
        • Installation
        • Documentation
          • Supply Chain Execution
            • Receive Goods (PO)
            • Inspect Goods (PO)
            • Putaway Goods (PO)
            • Receive Delivery (ASN)
            • Release Delivery for Pick
            • Pick Delivery
            • Pack Delivery
            • Issue Delivery
            • Move Stock
            • Count Stock
            • Reclassify Stock
            • Update Stock
            • Add Stock
            • Print Stock Label
            • View Stock Allocation
            • View Stock Details
          • Manufacturing Execution
            • Report Material (MO)
            • Report Operation (MO)
            • Report Receipt (MO)
          • Sales Management
          • Procurement
          • Rental and Maintenance Management
  • Components
    • Explore Components
      • OPC UA Component
        • Change Log
        • Installation
        • Documentation
          • OPC UA Component
      • Anomaly Detector
        • Change Log
        • Installation
        • Documentation
          • Anomaly Detector
      • Bluetooth Low Energy
        • Change Log
        • Installation
        • Documentation
          • Bluetooth Low Energy Component
      • Outlook Attachment
        • Change Log
        • Installation
        • Documentation
          • Outlook Attachment Component
      • Form Recognizer
        • Change Log
        • Installation
        • Documentation
          • Form OCR Recognizer Component
          • Form Recognizer Studio
      • Excel Connector
        • Change Log
        • Installation
        • Documentation
          • Excel Connector
  • Resources
    • Marketplace FAQ
    • Flow Help
    • Flow Forum
Powered by GitBook
On this page
  • Flow Properties
  • Azure Services
  • Flow Connectors
  • Installation
  • 1. Import Workflows
  • 2. Setting Menu Roles
  • 3. Publishing Workflows

Was this helpful?

  1. Components
  2. Explore Components
  3. Excel Connector

Installation

PreviousChange LogNextDocumentation

Last updated 1 year ago

Was this helpful?

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 .

  • 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.

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.

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

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.

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

  • Set up the parameters for OAuth2 authentication

Parameter
Value
Description
Required

Enabledb

To enable OAuth2 Authentication in REST connector

Access Token URLec

URL to get token

Auth URLR

URL to authorize

Client ID

{client_id}

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

For ID tokens, must be updated to include the ID token scopes - openid, and optionally profile and email.

Extra query parameters

{"login_hint": "john.smith@example.com", "prompt": "login"}

To add extra paramters if needed. It has to be in JSON format.

IFS OData Connector

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

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."

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.

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.

The API's used in this connector are documented

Read more in the how-to guides .

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

Follow the IFS Cloud authentication steps documented .

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

Checked

The Application (client) ID that the experience assigned to your app.

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

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

For details see

For details see

Create App Registration
here.
Create App Registration
Import a REST Configuration
here
Import a REST Configuration
here
here
Import Workflows
Setting Menu Roles
✔️
https://login.microsoftonline.com/{tenant_id}/oauth2/v2.0/token
https://login.microsoftonline.com/{tenant_id}/oauth2/v2.0/authorize
Azure portal – App registrations
https://graph.microsoft.com/.default