DNN Search and Replace Tool for DNN 7 (NOT for DNN 8+ / DNN 9+)

posted by evotiva - 9/8/2014
evotiva Active Since 9/30/2005
Uruguay

4.83

(6 total reviews for evotiva in the last six months.)

reviews Ask a Question



A DNN (DotNetNuke) Search and Replace module. Search (and optionally replace) text within any table/column in the DNN database. A 'target' is a database table/column pair. Typical usage: update legacy URLs (or any text) embed in the site; for example, after cloning a DNN to a different URL. Module 33609
  • $0.00 Free (Open Source)

$0.00

Add To Cart

Description (2.0+ version)

A DNN (DotNetNuke) Search and Replace module.

This tool allows you to search (and optionally replace) text within any table in the DNN database.

Given the nature of this tool, only super (a.k.a. 'host') users are allowed to access its functionality.

You can perform search and replace operation in one or many of the configured targets. A 'target' is a database table/column pair.

A typical usage of this module is to update legacy Urls (or any text) embed in HTML modules or DNN Url's references. For example, after moving a DNN web site to a different URL. See Evotiva DNN Backup (backup - restore - clone).

The search will be case sensitive depending on your database configuration (the database collation). Typically (by default), it is case-insensitive.

The search will look for the given string on the select table/column, and will match with a 'contains...' criteria.

An empty 'Replace With' is valid. Therefore, you can 'delete' text.



Release Notes


2.0.0 (Jun 3, 2013)

  • ENH - Rebuilt as a DNN module (for DNN 7.0.5+). Note: Not yet for DNN 8+ (version 1 will work, though).
  • ENH - Option to bulk search or replace many table/column pairs.
  • ENH - On screen search and replace results.
  • ENH - Option to search for the html encoded version of the typed text.
  • ENH - Settings: Easy configuration of the search targets (table/column pairs. Just point and click to add/remove items. The 'Available Targets' can be sorted, filtered, and by default all 'textual' columns of 250 characters or more are included as possible targets. It features the same defaults the 1.x version has (if they are available on the current database).
  • CHG - Download it from CodePlex: http://dnnsearchandreplace.codeplex.com

 

Description (1.x version)

=============

A generic DNN Search and Replace tool (virtually any table; e.g. "HtmlText"   , "Links" , "ModuleSettings", "TabModuleSettings", "DnnForge_NewsArticles_Page", "Tabs',  etc. (you can add yours).

This ASPX page is self-contained. To work, it does not need any external stored procedure, DLL, vb or cs file. No module to install/register.
Just upload the ASPX page to your site (in any folder, even the root) and browse to it.
Before browsing to this page, you must be logged in as a super user (host).

Select the table (tablesList) where you want to search and/or replace data on the configured column (columnsList)
You can enter a term to search, and once you click on <search> a grid will display the results (may be in the future paging/sorting could be implemented)
The search  will look for the given string on the select table/column. The search will match 'contains...'
The search  will be case sensitive depending on your database configuration (the database collation). Typically (by default), the search is case-insensitive.

Clicking on <Search & Replace> will replace every instance of the search string with the defined 'Replace With' string.
An empty 'Replace With' is valid. Therefore, you can 'delete' text.
The replace operation is case-insensitive.

More details/usage information within the file itself.

Updated Jan 6 2009: faster, cleaner, no need to define PK and supporting any column ([n}text, [n]varchar,..) zise (even > 8000 chars)

We plan to pack this utility as a DNN Module, and we will add additional features.

v. 1.7 (Oct 1, 2011)

  • ENH - Updated UI.
  • ENH - Simplified the way to configure the table-row pairs where to perform the search and/or replace operations
  • ENH - You can 'bulk' replace all the configured table-row pairs with a single click
  • ENH - It now supports defining more than one column to search and replace for the same table.
v. 1.5 (Apr 26, 2011)
  • CHG - Updated to support a htmltext table column change in the dnn core.
  • ENH - Enhanced built-in tables list for s&r operations, including core (HtmlText, ModuleSettings, TabModuleSettings, Tabs, Urls, Links, EventsCalendar) and 3rd party modules (Ventrian NewsArticles, Activeforums)

 

 

Find out about other Evotiva products

Evotiva DNNBackup
DNNBackup provides full backup and restore
of any DNN or Evoq Installation (complete instances). The restore can be made back to the source server or to a new destination.

DNNBackup is perfect for moving DNN installations from your local development machine to a deployment server, from a remote server to another remote server or for archival purposes.  Power users are free to customize many options.

Evotiva DNNUpgrade
DNNUpgrade provides a set of tools that helps DNN users to accelerate and automate DNN sites upgrades.

DNNUpgrade is the perfect companion of DNNBackup enabling guided, safe and fast DNN Installations upgrades.

Evotiva DNN UserFiles Evotiva DNN User Files is an easy to use and powerful file and document manager that allows you to present template-based filtered views of the portal's files (served by any folder provider, including all DNNGlobalStorage's supported providers).
When combined with a DNN Folder Provider (such as DNN GlobalStorage, it enables you to have your files secured in your favorite could storage provider.
Windows Azure     Amazon S3     Dropbox     Windows UNC     FTP     Microsoft SkyDrive     Rackspace Cloudfiles     FTP
Evotiva DNNGlobalStorage
DNNGlobalStorage expands your DotNetNuke 6 and 7 storage options
 beyond your Web Server, enabling a 100% integrated way to have your files wherever you want.
It is a set of folder providers which allows the integration of special, external, and cloud based file systems out of the box. For example: Windows AzureAmazon S3, Dropbox, Google Drive (including Google Docs), Rackspace Cloud Files (with its built-in CDN features), Microsoft SkyDrive, and UNC paths. In next releases will be added support for more providers. Please let us know if you need one not already implemented.
 

Product License

Terms of Use


Please review the
DNN Search And Replace - License (MIT) page.