Excel Connector
Last updated
Last updated
This flow can be used to Migrate data into IFS Cloud as an example of how to Read and Write data to Microsoft Office 365 Excel documents.
You can use the content of this component as an example or template to create your own Apps with embedded Excel functionality.
Within this example, you can migrate data from an Excel document into projections inside IFS Cloud. The projections used in this example are: Create Customer, Create Supplier, Create Work Order, and Create Part.
Download the Excel migration demo file below.
You will be prompted to log in to Microsoft Graph using OAuth to access your Excel documents.
Log in using your Microsoft Active Directory credentials
Once successfully select Continue to sign in to Microsoft Graph
This screen allows to to choose the destination for the data migration. The options here are limited for this example, but you can add your own methods as required.
You can enter an Excel file path (Office Cloud) or select from your recently used files.
Select the data within the Excel document, Available choices are Excel worksheets and named Tables.
Worksheets show as green, and any named tables will show as Yellow with the table identifier under each associated worksheet.
Selecting a worksheet will set the data range to the worksheet used range. using a table will limit the data range to the table's defined range.
The App will automatically assign any Excel columns to the IFS object name if they match.
The Colored Yellow rows (sorted to the top in alphabetical order) are required IFS fields. You can map columns or set default values (dropdown list) or strings. The same applies to Optional IFS objects. Records will turn Green when a value is chosen.
IFS fields like CreationDate can be left empty as these are populated by the IFS system automatically.
You can review the created IFS objects on this screen, and end the workflow here, or continue to write a summary of the created IFS objects back to the same document as a new sheet.
Select any IFS columns to exclude from the export.
By default, the IFS projection name and current date/time are used.
When you create the summary a new worksheet will be created with data representing the newly created objects within IFS.
