Difference between revisions of "fpDBExport"

From Lazarus wiki
Jump to navigationJump to search
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
== Overview ==
+
#redirect [[lazdbexport]]
fpdbexport lets you export datasets to various formats.
 
 
 
== FPC ==
 
fpdbexport is part of the FreePascal FCL database modules.
 
 
 
It provides a template class for descendants that can provide export of datasets.
 
Also included are various ready-made descendants for:
 
* CSV format
 
* DBF format; see [[fpdbfexport]]
 
* Fixed with text files
 
* RTF/rich text format
 
* Simple JSON
 
* Simple XML format
 
* SQL insert statements
 
* TeX format
 
* Various XML formats; see [[fpXMLXSDExport]]
 
 
 
== Extensibility ==
 
As indicated, developers can write their own export classes using the fpdbexport framework. An example of this is the Excel/spreadsheet format exporter in [[FPSpreadsheet#Dataset export |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.
 
 
 
== Lazarus ==
 
In Lazarus, the export components are not installed by default. Installation gives a ''Data Export'' tab.
 
 
 
[[File:DataExportTab.png]]
 
 
 
 
 
== Example ==
 
See the examples in your FPC source directory $(fpcdir)\source\packages\fcl-db\tests (see [[Databases#Running_FPC_database_tests]]), specifically testdbexport.pas.
 
 
 
== See also ==
 
* [[fpdbfexport]] Part of fpDBExport; exports to DBF files
 
* [[fpXMLXSDExport]] Part of fpDBExport; exports to various XML formats.
 
 
 
 
[[Category:Databases]]
 
[[Category:Databases]]
[[Category:FPC]]
 
[[Category:Lazarus]]
 
[[Category:Packages]]
 
[[Category:Data import and export]]
 

Latest revision as of 19:39, 4 September 2016

Redirect to: