xBaseView.wlx - universal database viewer and editor

Discuss and announce Total Commander plugins, addons and other useful tools here, both their usage and their development.

Moderators: white, Hacker, petermad, Stefan2

Post Reply
mutex
Junior Member
Junior Member
Posts: 39
Joined: 2004-02-22, 12:47 UTC
Location: Kazakhstan

xBaseView.wlx - universal database viewer and editor

Post by *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
User avatar
raeubi
Power Member
Power Member
Posts: 575
Joined: 2003-11-25, 09:01 UTC
Location: Rhein/Main

Post by *raeubi »

Wow, good job 8)
Räubi
(#2852 + #287609)
User avatar
DrShark
Power Member
Power Member
Posts: 1872
Joined: 2006-11-03, 22:26 UTC
Location: Kyiv, 68/262
Contact:

Re: xBaseView.wlx - universal database viewer and editor

Post by *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.
Donate for Ukraine to help stop Russian invasion!
Ukraine's National Bank special bank account:
UA843000010000000047330992708
User avatar
sqa_wizard
Power Member
Power Member
Posts: 3854
Joined: 2003-02-06, 11:41 UTC
Location: Germany

Re: xBaseView.wlx - universal database viewer and editor

Post by *sqa_wizard »

This plugin doesn't support Unicode *.tab/*.tsv files
Well, acc. to first post it is not intended to support those files ...
#5767 Personal license
User avatar
DrShark
Power Member
Power Member
Posts: 1872
Joined: 2006-11-03, 22:26 UTC
Location: Kyiv, 68/262
Contact:

Re: xBaseView.wlx - universal database viewer and editor

Post by *DrShark »

sqa_wizard wrote: 2019-04-18, 21:49 UTCWell, 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
Donate for Ukraine to help stop Russian invasion!
Ukraine's National Bank special bank account:
UA843000010000000047330992708
Post Reply