Moving a Tab

Have you ever moved a new tab up several items in the tab order? This article provides an efficient method to move a tab, anywhere within your tab structure on  a DotNetNuke web site.  Note this can only be done if you are logged in with Host access rights.

Begin by loging into the portal using the Host account,  This will provide access to the host administration tabs. Navigate to the sql tab.

We need to execute the sql code

SELECT * FROM tabs WHERE portalid = 1 ORDER BY taborder

You will notice from this list that the taborder is an odd number series, no even numbers.  Our aim is to move our page between two items, into the correct place and then get the numbers sequence to be re-built. This will require us to move another pair of pages, but much better than manually moveing the required mage upwards, say 20 or 30 times.

Having determined which tabid is to be moved, and to which taborder value, execute another sql command, something like the following.

update tabs set taborder = 402 where tabid = 846

Navigate to the admin tabs page and move another tab.  This will move this tab, but more importantly the tab order will be re-built. Finish by moving the page which you moved from the tabs page back to its original position.