Exportizer Users' Guide
vlsoftware.net
Contents
Introduction
System Requirements
Author
Differences between Exportizer and Exportizer Pro
Exportizer Pro Registration
Working with Databases
Opening Databases
Creating Schema for a Text Table
Database History
Database Grid
Searching Text in Database Table
Filtering Data
Special Data Functions
Exporting Data
Exporting to HTML Using Template
Command Line Usage
Printing Data
Options
Shortcut Keystrokes
Appendices
Expression Engine
dataset_field_val
dataset_field_is_null
dataset_nvl
dataset_field_exists
dataset_param_val
query_res
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
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
format_float
lpad
rpad
iif
upper
lower
capitalize
pretty
length
pos
substr
substr_count
trim
trim_left
trim_right
string_replace
concat
ordinal_number
quantitative_numeral
number_to_words
Example of Using Template in HTML Export
Connection Strings Examples
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)
Interbase, Firebird Databases (.gdb, .ib, .fdb)
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
Field Mappings File
Table Mappings File