Differences

This shows you the differences between two versions of the page.

--- database:csv [2015/08/21 23:49] – created mnewnham
+++ v5:database:proxy [2017/07/11 15:59] – ↷ Page name changed from v5:database:csv to v5:database:proxy mnewnham
@@ Line 1: / Line 1: @@
 ====== CSV File ======
+~~NOTOC~~
+<WRAP todo>
+The syntax required and necessary file formats have not yet been identified from the legacy documentation. Can you help?
+</WRAP>
+<WRAP right box round 300px>
+== Specification ==
+^Driver Name|csv|
+^Alternate Name|proxy|
+^Data Provider|csv|
+^Status|Inactive((This driver is not actively supported or enhanced by ADOdb project members, but you can provide fixes and enhancements if you have the expertise))|
+^Windows|Yes|
+^Unix|Yes|
+^ADOdb V5|Yes|
+^ADOdb V6|Yes|
+</WRAP>
 ===== Description =====
-The ''csv'' driver allows a CSV file to be treated like a database table
+The ''csv'' driver allows a CSV file to be read across an http connection and treated like a database table.
+  * The only parameter passed in the connect statement is the url of the file
+  * https connections are currently not supported.
+  * In order to write back data, the file/directory must be writable by the Identity that the web server runs as. This may be a problem in IIS, creating an AppPool specifically for the process may provide a possible solution.
+  * Some methods are not supported
+===== Usage =====
+<code php>
+$db = newAdoConnection('csv');
+$db->connect('http://127.0.0.1/files/file.csv');
+</code>