See also Sqlite2DBF
So SoftMaker-Office lets you save PlanMaker files in dBase-format, and you can use the dBase-files as a data-source for TextMaker documents.
As the database can be managed in TextMaker, you can choose one of two ways to add, remove or alter records:
- Either via the menu-command Tools | Edit Database in TextMaker,
- or after opening the file *.dbf in PlanMaker.
This is enough to create or manage simple databases. The only inconvenience with the procedure is the user-interface, which is either that of a spreadsheet program or the little database-tool which is integrated in TextMaker. You have to remember that dBase itself is a simple, and nowadays considered outdated, database-format.
Those who wish to combine the database-functionality in TextMaker with a full-blown relational database, configured and managed with SQL or by use of a sophisticated user-interface, must be disappointed. I have though a suggestion.., if you can live with the sqlite3 format for your database.
(Foreign Key statement added for sophistication)
You can convert the sqlite-tables from your database each to a dBase-file, using my sqlite2dbf conversion utility:
Code: Select all
user@machine:~$ export LANG=en_EN.UTF-8
user@machine:~$ sqlite2dbf -h
Usage: sqlite2dbf -s [SQLite-file] [options]
or sqlite2dbf [Common options]
-s, --source [PATH] SQLite-file to read.
-c, --config [PATH] Configuration file for this transformation
-n, --name [TABLE] The name of the table from the SQLite-database to convert
-t, --target [PATH] Path to the dBase-file to be written.
-l, --list Show the list of available tables and exit
-o, --out [PATH] Use the table-name as file-name for the DBF-result, store output in PATH
--time [list] Fields (table-columns) which shall be handled as timestamp values.
--date [list] Fields (table-columns) which shall be handled as date-time values.
-d, --debug Show debug-messages
-h, --help Show this message
-v, --version Show version and program information
If my database is named “record.sqlite
”, I extract the table “records” and write it to “records.dbf
” with the following command:
Code: Select all
user@machine:~$ sqlite2dbf -s record.sqlite -n Records
The program answers almost immediately with “Done. Bye.”. And in the current directory I find a new file “record.dbf
When I connect this database with a TextMaker Document, it works just like with the previous version, that I had written with PlanMaker.
- The conversion of date and time-values is problematic, if you do not know the database well enough to determine the fields, concerned. dBase uses a text-field to store dates, in SQLite three different data-types are possible; hence the --time and --date parameters to SQLite2DBF (see usage-message, above).
- Views are not transformed to dBase-tables.