WHAT'S THIS ? Now based on WySQL this is a trivial CSV-SQL table management with upload and dump capabilities. For both directions of loading data table must exist first. Then, for upload, if data file (CSV) contains no header information (columns name) they are obtained from exinting table. At the time of writing WyCSV has only been tested with Netscape. Despite WySQL is trying to be DBMS indepent, this currently fully works only with MySQL. See below for fallback support for PostgreSQL. COPYING This is free software, and you are welcome to redistribute it under certain conditions; see the file COPYING for details. This software is OSI Certified Open Source Software. OSI Certified is a certification mark of the Open Source Initiative. You may want to check http://www.franzoni.info/open for up to date version. HISTORY V2.snap Added 'truncate' feature for insert/replace data V2.0.0 Stable release with a few bug fixing. V2.0.0-beta3 Added fallback support for PostgreSQL (table name can't be selected from list and must be typed in, upload only work for CSV files with header or there must be at least one record in the table), dump exports all the fields' data as string. Files have been prefixed with 'wycsv_', backward compatibility files (dump.php and upload.php) include right files. Added file preview for upload. V2.0.0-beta Using new WySQL's OO interface V1.4.1 Tables list filtered by "like '$DBfix%'" V1.4.0 Added html table format dump (and version alignment) Removed newline from last fields in upload (bug fix) V1.3.3 Added where clause optionally with external custom code, Added handling for db connection failure (bug fix) V1.3.2 index.php split into new file wycsv.php for external usage Removed table name selection if there is just one table V1.3.0-beta: The code has been rearranged as WySQL plugin (see http://www.franzoni.info/open/wysql for details) INSTALLATION At first you need to install WySQL. Then, Unpack the compressed tarball from the parent directory of WySQL. Database setup and access configuration depends on the above. This is just a plug-in... and just acts where and as far as WySQL can. This bunch of code really relies on finding ../wysql/* ... ofcourse you can change relative/absolute location references... but that is just UP TO YOU ! TODO Add selections to choose decimal character ('.' ',') and date format (dd/mm/yy[yy] mm/dd/yy[yy] [yy]yy-mm-dd) according to local settings, for both dump and import. BUGS Please report any bug to the address below. Suggestions are also welcome. No known bugs so far :-) CONTACT INFO: Mauro Franzoni Via Torbole 1 I-21100 VARESE ITALY e-mail: info@franzoni.info