xBaseView.wlx - universal database viewer and editor

[mutex]

xBaseView - Lister plugin for DBF, DB, MDB, XLS, UDL and DSN extensions.
View and edit FoxPro, dBase, Clipper, Paradox, Access, Excel, ADO and ODBC databases.

Allows to view and edit DBF, FPT, DBT files of Visual FoxPro, FoxPro, dBase and Clipper. Index of types CDX and IDX - VFP and FoxPro, MDX and NDX - dBase, NTX - Clipper are supported. For FoxPro are supported Russian, General and Machine collates and autoincremental field VFP8. Allows run SQL Select operator for DBF.
In additional allows view, edit, print, search, filter, SQL query and SQL update for Paradox, Access and Excel files, and, ADO and ODBC databases (MS SQL Server, IBM DB2, Oracle and others), to which is access on UDL or DSN file, and their export to DBF-format. Excel files editing is not supported. Create UDL and DSN files.

Features for DBF:
- View, edit and print to Excel book.
- Index search by one column.
- Index filtration by one column.
- SQL-like filtration of all columncolumns.
- Vertical filtration (i.e. hiding) of columns.
- View and edit of MEMO and BLOB fields.
- Export to TXT, HTML, XML, XLS and DBF.
- Creation, editing and deleting of indexes.
- Creation and editing of the structure of base.
- Set or delete Code Page of DBF.
- Autorecognition of Code Page.
- Base pack and reindex.
- Run SQL Select operator.

Features for Paradox, Access, Excel, ADO and ODBC databases:
- View, edit (except Excel) and print to Excel book.
- Sort and search by one column.
- SQL-like filtration of all columns.
- Vertical filtration of columns.
- Run SQL Select operator.
- Edit (except Excel) via SQL Insert, Update and Delete.
- Export to FoxPro DBF format.
- Create UDL file.
- Create DSN file.

Requirements
- For all databases, except DBF, are requires Microsoft ADO (OLE DB).
- For SOL operators also is requires Microsoft ADO.
- For Paradox, Access and Excel is requires Microsoft Jet 4.0 OLE DB.

Sources is available.

Download: http://www.totalcmd.net/plugring/xBaseView.html

[raeubi]

Wow, good job

[DrShark]

This plugin doesn't support Unicode *.tab/*.tsv files (tried xBaseView v. 5.6a and v.10 with UTF-8, UTF-16 TAB files with and without BOM).
It seems it's the only plugin officially supporting TAB files, so to solve the issue I made internal association for TAB files with a batch script that converts TAB to CSV using NirSoft CSVFileView and opens CSV in Lister in a separate TC process where installed Excellence plugin shows it:

Code: Select all

@ECHO OFF
SETLOCAL
SET infile=%~1
SET infname=%~n1
SET infpath=%~d1%~p1
SET infext=%~x1
SET tmppath=%tmp%\_tcf_
SET tmpfile=%tmppath%\%infname%%infext%
SET fconverted=%tmppath%\%infname%.csv
DEL /Q "%fconverted%"
COPY /Y "%infile%" "%tmpfile%"
CSVFileView.exe /load "%tmpfile%" /scomma "%fconverted%"
DEL /Q "%tmpfile%"
%COMMANDER_EXE% /S=L:T4 "%fconverted%"
DEL /Q "%fconverted%"
ENDLOCAL
exit

Excellence shows correctly UTF-8 files without BOM, so since the script doesn't do any additional conversions, the TAB file must also be in UTF-8 without BOM.

[sqa_wizard]

This plugin doesn't support Unicode *.tab/*.tsv files

Well, acc. to first post it is not intended to support those files ...

[DrShark]

Well, acc. to first post it is not intended to support those files ...

From xBaseView Readme.txt:

A databases list and file extensions
...
- TAB Text .TAB