Framed HTML Docs Search Function

Documents SQL Server 2005 and 2008 databases.

Moderators: JonathanWatts, David Atkinson, Michelle Taylor

Framed HTML Docs Search Function

Postby jasoncleme » Fri Jan 25, 2013 6:45 pm

Well this is a very powerful tool. We are doing a lot with it in a little amount of time that we have owned it. But I have a question.

Is it possible to add a custom search bar to the HTML. I would love to be able for the users to be able to search the extended properties or anything else from the Framed HTML.

I know we can do it in chm and PDF. But I'm posting the results from the Framed HTML to Sharepoint Page viewer that is created from a SSIS package running a PowerShell command that is using the SQLDOC Command Line.

Image

Code: Select all
<# 
 =====================
 Delete Current SQLDOC
 =====================
#>
$path = '\\\\rpt102\\d$\\PVP\\PVP21\\webcontent\\Powershell\\Database_Documentation\\DBPrime1\\'
Get-ChildItem $path  |
    Sort-Object { $_.Name -as [Version] } |
    Select-Object -Last 1 |
    Remove-Item -recurse
<# 
 ===============
 Create SQLDOC
 ===============
#>
$CMD = 'C:\\Program Files (x86)\\Red Gate\\SQL Doc 2\\sqldoc.exe'
$arg1 = '/project:H:\\My Documents\\SQL Server Management Studio\\Red-Gate\\DBPrime1.sqldoc'
$arg2 = '/filetype:html-frames'
$arg3 = '/force'
$arg4 = '/outputfolder:"\\\\rpt102\\d$\\PVP\\PVP21\\webcontent\\Powershell\\Database_Documentation\\DBPrime1"'
 
& $CMD $arg1 $arg2 $arg3 $arg4

<#
"C:\\Program Files (x86)\\Red Gate\\SQL Doc 2\\sqldoc.exe" /project:"H:\\My Documents\\SQL Server Management Studio\\Red-Gate\\DBPrime1.sqldoc" /filetype:html-frames /force /outputfolder:"\\\\rpt102\\d$\\PVP\\PVP21\\webcontent\\Powershell\\Database_Documentation\\DBPrime1"
#>

<# 
 ===============
 Rename Directory
 ===============
#>
cd \\\\rpt102\\d$\\PVP\\PVP21\\webcontent\\Powershell\\Database_Documentation\\DBPrime1
dir | Where-Object {$_.Name} | Rename-Item -NewName "DBPrime1"


Our final result and nightly updated. But we have no way to search it.
Image
jasoncleme
 
Posts: 3
Joined: Wed Jan 16, 2013 4:00 pm

Postby eddie davis » Mon Jan 28, 2013 4:30 pm

Hi jasoncleme

Thank you for your forum post.

Sadly what you are seeking is not currently available within SQL Doc. It may be possible for you to edit the HTML SQL Doc generates and add your search feature.

I have added the details of this forum post to an existing feature request whose reference is SDOC-1423. The feature requested is to be able search documentation for particular string.

At this time I have no further information regarding SDOC-1423, hopefully it will appear in a future version of the product.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 942
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Doc 2

Who is online

Users browsing this forum: No registered users and 0 guests