Exportizer Users' Guide
vlsoftware.net
Index Previous Next

Contents

Introduction
System Requirements
Author
Differences between Exportizer Editions
64-bit vs 32-bit
Exportizer Pro or Exportizer Enterprise Registration
Working with Databases
Creating Databases
Opening Databases
Opening Datasets to Export
SQL Query Tool
Registered Databases
Database Grid
Searching Text in Database Table
Filtering Data
Special Data Functions
Exporting Data
Available Export Formats and Format Specific Options
Text or CSV
JSON
Excel (XLS)
Excel (XLSX)
Excel (XML-based)
HTML
XML
dBase
RTF
PDF
SYLK
Excel (OLE)
Word (OLE)
SQL Script
Database
Custom
Table and Field Mappings
Export Logs and Error Handling
Importing Data
Dragging Files
Data Export Recommendations
Exporting Database Structure to DBML Format
Command Line Usage
Printing Data
Options
Shortcut Keystrokes
Practical Cases
Creating Schema for a Text Table
Exporting Data to SQL Files
Exporting dBase (DBF) to SQL Script
Exporting SQLite to SQL File
Exporting Data to dBase
Exporting CSV to DBF
Exporting Data to Excel
Exporting SQLite to Excel
Exporting PostgreSQL to Excel
Exporting Several Queries to One XLSX File
Exporting Data to Firebird
Exporting Excel to Firebird
Exporting Data to Access
Exporting Paradox to Access
Exporting Data to PostgreSQL
Converting Access to PostgreSQL
Migrating Oracle Data to PostgreSQL
Exporting Data to Oracle
Migrating PostgreSQL Data to Oracle
Migrating SQL Server Data to Oracle
Exporting Large Tables
Exporting Calculated Fields
Exporting BLOBs to Individual Files
Exporting to HTML Using Template
Importing Database Files from Explorer
Importing Data from Excel File
Importing Data from dBase (DBF) Files
Importing Data from Firebird Database
Examples
Example of Using Template in HTML Export
Connection Strings Examples
Appendices
Migrating Application to Another Machine
Expression Engine
dataset_field_val
dataset_field_hex_val
dataset_field_is_null
dataset_nvl
dataset_field_exists
dataset_param_val
query_res
dbnull
dataset_row_count
dataset_min
dataset_max
dataset_sum
dataset_avg
dataset_count
dataset_row_count_ex
dataset_min_ex
dataset_max_ex
dataset_sum_ex
dataset_avg_ex
dataset_count_ex
abs
frac
int
round
sqrt
power
exp
ln
cos
sin
tan
atan
date
time
date_time
add_date_time
compare_date_time
date_time_diff
format_date_time
doc_title
target_file_name
file_created
file_last_modified
file_last_accessed
file_size
file_version
extract_file_ext
extract_file_name
extract_file_dir
extract_file_path
extract_file_text
file_exists
dir_exists
to_number
to_string
parse
format_float
lpad
rpad
iif
char
upper
lower
capitalize
pretty
length
pos
substr
substr_count
trim
trim_left
trim_right
string_replace
concat
ordinal_number
quantitative_numeral
number_to_words
rgb
Ways of Opening Different Data Source Types
Microsoft Access Databases (.mdb)
Microsoft Access 2007+ Databases (.accdb)
Microsoft Excel Workbooks (.xls)
Microsoft Excel 2007+ Workbooks (.xlsx, .xlsb, .xlsm)
HTML Files (.htm, .html)
Firebird Databases (.fdb)
Interbase Databases (.gdb, .ib)
UDL Files (.udl)
dBase Files (.dbf)
FoxPro Files (.dbf)
Visual FoxPro Databases (.dbc)
Paradox Files (.db)
Text and CSV Files (.txt, .csv)
Lotus Files (.wj2, .wk1)
XML Files (.xml)
Oracle
SQL Server
Sybase
SQL Anywhere (Adaptive Server Anywhere)
Informix
DB2
Ingres
Pervasive PSQL
SQLBase
MySQL
PostgreSQL
SQLite
Exportizer Specific File Types
Action File
Export Definitions File
Field Mappings File
Table Mappings File

Copyright (C) 2024 Vitalii Levchenko Software. All rights reserved.