0 votes

How do you get a dump of the FLN database and can I query on specifics and output in different formats?

by (20 points)

1 Answer

0 votes

In the installation folder there's a command line utility called DumpDB.exe, which can be used to export the search results. The command line options can be listed executing:

dumpdb /?

FileLocator Network  - Database Export Utility. Copyright (C) 2010 Mythicsoft Ltd.

usage: dumpdb.exe
        /exportfolder:"path to export folder"
        /exportfile:"path to a single file"
        /transform:"path to transform"  - only valid for format:custom
        /format:html|xml|text|custom    - optional (default:text)
        /after:"search run date"        - optional
        /before:"search run date"       - optional
        /search:"search name"           - optional

If you specify /exportfolder: each search run will be exported as a separate file in the target folder, otherwise to export all the results to a single file use the /exportfile: switch.

By default all search results will be exported but you can limit the export to specific results based on search run date or search name. The export format can be changed using the /format: switch.

by (31.5k points)

Excellent! Thank you. I'd also like to know if there's any way to prune the database?

Not through the command line utilities but you can do it from the main app using the 'View->Database Usage' menu option. If you want to be able to do it via the command line ask it as a separate question and I'll see if I can rustle up a PowerShell based solution.