Not all dataflow step types from Profitbase Studio 5x is supported in PS6x. These are marked as obsolete and get a pink color in the dataflow editor.
The obsolete steps can be executed but there is no guarantee that they will work.
Following PS5x steps are marked as obsolete:
A tool has been made to convert these 5x steps to corresponding 6x steps. The tool can also check command connections and solution id. A PS5x command may result in multiple PS6x commands. The commands in PS6x are based on a single module vs PS5x that can contain more than one module.
Each step in a dataflow contains a data command stored in an xml command. The tools make it easier to substitute that content vs a SQL or PowerShell script.
Click here to download the PS6 Dataflow Converter V3.zip file.
Unzip the files to eg. C:\temp\PS6 Dataflow Converter
Click on PS6 Dataflow Converter.exe to start the program.
Click on [Connect Server] to select server and optional user/password. On first startup, a connection to a server must be established. Next time the tool opens, this connection is used.
Then select a solution / solution database from the dropdown box.
There are then 3 tabs to choose from:
For manual conversion, select a dataflow from the dropdown. A list of obsolete dataflow steps is listed to the left.
Select a step from the list, and the type and expression is shown right of the list.
Click on [Try convert Dataflow Step] to convert it. The result is shown below. The original step may result in multiple converted steps (1 per module). Select result step from the 'Steps conv.to' dropdown.
Click on [Save] to store the converted step in the solution database.
You need to reopen the Solution to view result in Profitbase Studio.
For automatic conversion select options 'Substitute obsolete commands' and/or 'Check command connection parameters'.
Check the dataflows in the list. Right-click to select/deselect all.
Click on [Convert selected dataflows] to check, convert and store dataflows.
You need to reopen the Solution to view result in Profitbase Studio.
The log contains a simple log of the operations done. Right-click to copy to clipboard or clear the list.