In order to connect to an on-premise file you must have a DropPoint - to see how to set up a DropPoint see Connecting to on-premise applications.
In this article we are going to read data from an Excel spreadsheet.
- Begin by creating a new Workflow by clicking on the Add icon at the bottom of the screen.
- Specify the name of the new Workflow.
- On the Workflow Design screen, click on an 'Add Node' icon.
- In this example, we are going to use a File Node, so type in the name on the
- With the File Node on the screen, click on the Connection tab and then on the plus + sign to add a new Connection. A Connection is needed so you can access the data or application source - for information about Connections see Connection. A message will appear that the Connection has been created.
Then click on the pen icon to edit the Connection.
- The Connection will open in a new browser tab. Change the DropPoint from 'Run from Cloud' to the on-premise DropPoint you set up.
- Click on the Save icon at the bottom of the screen to save the Connection.
- On the Workflow Design screen, the Connection is now specified in the File Node.
- As this example involved reading from an Excel spreadsheet, we need to specify the full pathname of the Excel file, and change the FileType to Binary.
- To test that the file can be read, click on the white triangle on the File Node, and on the drop-down list select 'Run this Node'.
- The Activity Log will appear in the lower half of the Console screen; on the left half of the log you should see successful Results.
- For the second line of the Activity Log, the right half of Log shows two FileData fields - the first is input, and second is output which shows that data has been read.
- In order to get the data from the Excel file into Flowgear, the data needs to be converted to XML, this requires the Excel Node.
Add the Excel Node, and then to ensure the Workflow runs, connect up the Nodes as shown. The FileData parameter on the File Node is connected as it's output is the input to the ExcelDocumentTemplate parameter in the Excel Node.
- Run the Workflow by clicking the Run icon at the bottom of the screen.
- You have now run a complete Workflow!
The Activity Log now has three lines, the last line showing the Excel Node.
- The right half of the Activity Log shows the input TableXML (Empty) and the output TableXML (<NewDataSet>).
- Click on the <NewDataSet> value to see the contents of the output TableXML in a table view.
- To see the output in XML, click on the Value icon.
- Values of the output in XML view.
- Click on the tick mark on the bottom of the window to exit the dataset view.
- Save the Workflow by clicking on the Save icon at the bottom of the screen.