Difference between revisions of "lazdbexport"
| Line 3: | Line 3: | ||
Also included are various ready-made descendants for: | Also included are various ready-made descendants for: | ||
| − | {| class=" | + | {| class="wikitable sortable" |
| + | ! icon || Component || Description | ||
|- | |- | ||
| component || || Description | | component || || Description | ||
Revision as of 10:25, 5 September 2016
lazdbexport is a package that supplies components to facilitate database export. It is delivered with lazarus and may be installed by using [Package|Install/Uninstall packages]. After install the components are accessible via the Data Export tab. It provides a template class for descendants that can provide export of datasets. Also included are various ready-made descendants for:
| icon | Component | Description |
|---|---|---|
| component | Description | |
| TCSVExporter | CSV | |
| TFixedlengthExporter | Fixed length | |
| TSQLExporter | SQL | |
| TXMLXSDExporter | XML/XSD | |
| TSimpleXMLExporter | XML | |
| TSimpleJSONExporter | json | |
| TFPDbfExport | dbf | |
| TTeXExporter | TeX | |
| TRTFExporter | RTF | |
| TStandardExportFormats | ||
| TFPDataExporter |
As indicated, developers can write their own export classes using the export framework. An example of this is the Excel/spreadsheet format exporter in FPSpreadsheet
Import
There is no corresponding import to dataset code in FPC/Lazarus, but there is third party code like dbimport (https://bitbucket.org/reiniero/smalltools/src, directory dbimport).
DbImport is used in the LazSQLX and TurboBird database management tools for importing CSV (like) data into datasets.
Example
See the examples in your FPC source directory $(fpcdir)\source\packages\fcl-db\tests (see Databases#Running_FPC_database_tests), specifically testdbexport.pas.
