Transfer tables between workflows

A transfer moves a Writeback table from one workflow of a destination to another workflow of the same destination. Use it to regroup tables when a workflow grows too large, or to run a table on a different schedule: a table runs with the workflow it belongs to.

Move tables in the Workflows view

1. Open WriteBack in the sidebar, then click Workflows in the header or press Alt+4. To open the view on one destination, right-click the destination and choose Show Workflows.
2. In the left panel, select the destination under Destination, then select the workflow that holds the tables under Workflows. When you pick a destination, its first workflow is selected for you.
3. At the top of the left panel, switch the mode from Runs to Transfer. Its tooltip reads Move fully mapped tables between workflows of the same type.
4. On the Select tables step, tick the tables to move in Source tables. Only fully mapped tables of the selected workflow are listed. Click Select All to tick every table the list shows; it reads Clear when everything is ticked. Type in Search tables... to narrow the list.
5. On the Choose destination step, open Select destination workflow and pick the workflow to move the tables into. The view offers only workflows of the same type on the same destination, and it selects the first valid one for you. Each choice shows how many tables the workflow holds.
6. On the Confirm transfer step, click the round arrow button between the two panels. Its tooltip gives the number of tables, for example Transfer 3 tables. There is no dialog, and the move starts at once.
7. When it finishes, Success and Transferred <n> table(s). appear. The tables leave the source side and show under the target workflow, marked New for a moment.

What can move

• Only Mapped tables move: tables whose column mapping is saved. A table that is not mapped does not appear in Source tables. To map one, see Map columns.
• A table with no primary key column shows No PK and cannot be ticked, even when it is mapped.
• A table moves only within its destination. The view never offers another destination's workflows.
• The target must be a workflow of the same type as the source workflow. Replication workflows are not offered.
• Targets are limited to workflows you are allowed to modify. When you cannot modify any of them, the transfer button's tooltip reads You do not have permission to modify any destination workflow here.

Swap the source and destination workflows

The button under the arrow, with the tooltip Swap source and destination workflows, trades the two sides of the view, so you can move tables in the other direction. A swap needs a chosen destination workflow, and permission to modify the workflow that will receive the tables after the swap. It clears your ticked tables, so tick them again for the new direction.

After the transfer

• The tables keep their destination, their source and their column mapping. They run with the workflow they now belong to, including that workflow's schedule. See Run, schedule and monitor Writeback.
• The view refreshes both sides on its own, and the moved tables show under the target workflow, marked New for a moment.
• To check where a table sits later, open it and read Workflow on the General step. See Configure a Writeback table.

Permissions

Without View WriteBack Workflow Objects, the Workflows button is hidden. Without permission to modify a target workflow, the view does not offer it. See Writeback permissions for the full list.

Limits and edge cases

• If the destination has no other workflow of the same type, the view warns No other workflows with the same type on this destination. Check the destination's workflows, then try again.
• Before you choose a destination, the view reads Select a destination with Pick a destination from the left panel to start transferring tables between workflows. Before you choose a source workflow, it reads Select a source workflow with Choose the workflow that contains the tables you want to move. Only fully mapped tables can be transferred.
• With no fully mapped tables in the selected workflow, Source tables reads No fully mapped tables in this workflow. A search with no matches reads No tables match your search.
• While the workflows reload, the destination side shows Updating workflows....
• Switching the source workflow or the destination clears your ticked tables. If the chosen target stops qualifying, the view picks the first valid one for you.
• To move a single table, you can also pick another Workflow on its General step and click Apply. See Configure a Writeback table.
• For the full message list, see Writeback troubleshooting.

Questions, answered

Why is a table missing from the Select tables list?

The list holds the fully mapped tables of the workflow selected in the left panel. A table that is not mapped stays out: open it, map at least one column on Columns and click Apply. If the table is on another workflow, select that workflow first. See Map columns.

Why doesn't the destination list show the workflow I want?

The view offers only workflows of the same type on the same destination, and it never offers replication workflows. If none qualifies, it warns No other workflows with the same type on this destination. Check or create the destination's workflows first. See Run, schedule and monitor Writeback.

Why is the transfer button greyed out?

It switches on when you have ticked at least one table and a destination workflow is chosen. It is also off while a transfer is running. When you cannot modify any destination workflow, its tooltip reads You do not have permission to modify any destination workflow here. See Writeback permissions.

What changes for the table after the move?

Only its workflow. The table keeps its destination, its source and its column mapping, and it stays Mapped. From now on it runs with the target workflow and follows that workflow's schedule.

Can I move a table to another destination?

No. A transfer stays inside one destination, and the view offers only that destination's workflows. Each Writeback workflow belongs to one destination.

Can I undo a transfer?

Transfer the tables back. Select them in the workflow they are on now and move them to the original workflow; the view has no separate undo.

Why can't I tick a table that shows No PK?

A table needs a primary key column to move. A table without one shows No PK and cannot be ticked, even when it is fully mapped.

Does Select All tick every table in the workflow?

It ticks every table the list currently shows. With a search active, only the matches are ticked. When everything shown is ticked, the button reads Clear and unticks them all.

What does the swap button do?

It trades the source and destination sides, so you can move tables in the other direction. A swap needs a chosen destination workflow, and permission to modify the workflow that will receive the tables. It clears your ticked tables.

Where do I see a table after the move?

Under the target workflow in the Workflows view; it is marked New for a moment after it arrives. To check later, open the table and read Workflow on the General step. See Configure a Writeback table.