Hi, all
This is a progress report about import function.
A screenshot with dialog test mode (/t) attached.
Only the file page's code is finished.
1. Target page:
Now it is blank.
Reserved for standalone version to select target database and table.
2. Source pages: file / Source / ODBC
Import from csv format file / other pgsql database / ODBC(for MS-Windows)
First, csv file will be supported. Remainders only in plan.
3. Columns page:
Set data format ( date & number), space trim and column's order
I plan to support express, user can input a pgsql express to treat data.
4. Options/Status/Others page:
Only some ideas:
Skip empty rows
Import rows match regex
Don't import rows match regex
Commit per (n) rows.
Some log options
Test insert with (n) rows before insert to DB
Generate insert statement to a file.
Stop when (n) errors
and so on.
Limited encoding can be Support, see attached file "encodinglist.txt".
ASCII, Japanese EUCJP/Shift_JIS and Chinese GB2312/Big5 had been tested.
-----------------------------------------------
Quan Zongliang
quanzongliang(at)gmail(dot)com
CIT Japan: http://www.cit.co.jp
CIT China: http://www.citbj.com.cn
