...
Create some new objects in your configuration (this is the best approach – otherwise it may be confusing trying to distinguish your objects from objects of the same name on a different CenterView PhixFlow instance). Export some objects from your CenterView PhixFlow instance, and import them into another CenterView PhixFlow instance – in fact, you could even import them back into your instance, but try importing these into the CenterView PhixFlow instance of one of the other delegates.
Or – if you want, create a new instance of CenterView PhixFlow on your machine, and import the objects into that. Your CenterView PhixFlow trainer can help you do this, but you should start by trying to follow to the guidelines in the document CenterView PhixFlow Installation Guide under the section User Documentation in the CenterView PhixFlow help.
Make some changes to these objects.
Export them, and then import back into your instance.
Verify that the model has been properly imported. Note that collectors and exporters are set to Not Enabled, and that (for security reasons) the export does not include data source instance information (that is, database connection details).
...
Re-work the example in exercise Error! Reference source not found. to pass the list of accounts to the database collector as a list, rather than a series of individual account numbers. This is a more efficient configuration, since the query will then only be run once (in fact, the entire Stream calculation will only be run once since the output of the input multiplier will now be a list of only one item – that item itself being a list).
Hint: you construct a list in CenterView PhixFlow with the [ … ] notation. If you are hard-coding a list this will look like:
["red", "green", "black"]
but if you are passed a thing that is already a list – as in this case, when the notation acc.ACCOUNT_NUM is a list of account numbers provided by the pipe acc, then using the notation
[acc.ACCOUNT_NUM]
creates a list of one item – the item itself being a list.
| Anchor | ||||
|---|---|---|---|---|
|
Find the spreadsheet C:\CenterViewPhixFlow\train\inputData\AccountTransactions\AccountTransactions.xlsx. Open the spreadsheet and review the data. You will see that some lines, at the start of each section, have the details for the account – and all following lines omit these details, until the section for the next account starts.
Create a Stream to read in this data and populate, along with the transactions details, the account details for each record.
To do this:
...