Database or spreadsheet
The index file that SimpleIndex provides can also be imported into a database or spreadsheet, allowing you to create a search and retrieval interface for your documents that is simple, free, and tailored for your specific application. SimpleIndex can also be configured to interface directly with any database, eliminating the need to import the index files.
Using the Default Database, anyone can create a generic database with built-in search and viewing functionality and connect it automatically to an existing SimpleIndex job. The result is a completely free document management system that anyone with Microsoft Office or the Microsoft Access Runtime can use. Those familiar with Access may customize the forms in this database to display descriptive field names and hide unused fields.
The following spreadsheet was created by opening the index file in Excel and adding the column headings:
The image file paths were automatically converted to hyperlinks by running this short macro:
Sub ConvertToHyperlink()
Dim oCell As Range
For Each oCell In Selection
oCell.Font.Bold = True
ActiveSheet.Hyperlinks.Add Anchor:=oCell, Address:=oCell.Value, _ TextToDisplay:=oCell.Value
Next
End Sub
To use this macro, simply copy the code example into the Excel macro editor, select the cells in the Image File column and run the macro. Now users can simply click the cell and the image file will open in their default image viewer.