Hi all,
I want upload csv file for direct processing into SQL only, not for save to
ZODB nor LocalFS. Upload for LocalFS already worked for me.
So I have form:
<form method="POST" enctype="multipart/form-data">
<input type="file" name="fcsv" value="" size="50"><br>
<input type="file" name="fcsv2" value="" size="50"><br>
<input type="submit" name="fileupload" value="Upload">
</form>
Diagnostic processing:
<dtml-var "fcsv.filename">::<dtml-var "fcsv.headers['Content-Type']
">::<dtml-var fcsv>
And what it get:
data_2011.CSV::application/vnd.ms-excel::
Su upload worked, but what I can access to data of the uploaded file?
the dtml-in does not process anything, only displays NO DATA.
<dtml-in "PyS_csvimport(fcsv)" prefix="pys">
<dtml-var pys_item><br>
<dtml-else>
NO DATA
</dtml-in>
PyS_csvimport parse CSV file by line and return array structure like this
[['',''],['','']].
If I use TEXTAREA instead of file upload, dtml-in works.
How to get CSV file content to processing?
Many thanks,
Jaroslav Lukesh
PS: HTTP Request loks like that:
http://myhost/csvimport/
POST /csvimport/ HTTP/1.1
Host: myhost
(......)
Content-Type: multipart/form-data;
boundary=---------------------------30333176734664
Content-Length: 21822
-----------------------------30333176734664
Content-Disposition: form-data; name="fcsv"; filename="data_2011.CSV"
Content-Type: application/vnd.ms-excel
(....bulk od CSV data.....)
-----------------------------30333176734664
Content-Disposition: form-data; name="fcsv2"; filename="data_2011_kd.CSV"
Content-Type: application/vnd.ms-excel
(....bulk od CSV data.....)
-----------------------------30333176734664
Content-Disposition: form-data; name="fileupload"
Upload
-----------------------------30333176734664--
HTTP/1.1 200 OK
Server: Zope/(Zope 2.10.13-final, python 2.4.6, linux2) ZServer/1.1
Date: Fri, 14 Oct 2011 09:21:48 GMT
Content-Length: 2389
Content-Type: text/html; charset=cp1250
_______________________________________________
Zope maillist - Zope@zope.org
https://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
https://mail.zope.org/mailman/listinfo/zope-announce
https://mail.zope.org/mailman/listinfo/zope-dev )
I want upload csv file for direct processing into SQL only, not for save to
ZODB nor LocalFS. Upload for LocalFS already worked for me.
So I have form:
<form method="POST" enctype="multipart/form-data">
<input type="file" name="fcsv" value="" size="50"><br>
<input type="file" name="fcsv2" value="" size="50"><br>
<input type="submit" name="fileupload" value="Upload">
</form>
Diagnostic processing:
<dtml-var "fcsv.filename">::<dtml-var "fcsv.headers['Content-Type']
">::<dtml-var fcsv>
And what it get:
data_2011.CSV::application/vnd.ms-excel::
Su upload worked, but what I can access to data of the uploaded file?
the dtml-in does not process anything, only displays NO DATA.
<dtml-in "PyS_csvimport(fcsv)" prefix="pys">
<dtml-var pys_item><br>
<dtml-else>
NO DATA
</dtml-in>
PyS_csvimport parse CSV file by line and return array structure like this
[['',''],['','']].
If I use TEXTAREA instead of file upload, dtml-in works.
How to get CSV file content to processing?
Many thanks,
Jaroslav Lukesh
PS: HTTP Request loks like that:
http://myhost/csvimport/
POST /csvimport/ HTTP/1.1
Host: myhost
(......)
Content-Type: multipart/form-data;
boundary=---------------------------30333176734664
Content-Length: 21822
-----------------------------30333176734664
Content-Disposition: form-data; name="fcsv"; filename="data_2011.CSV"
Content-Type: application/vnd.ms-excel
(....bulk od CSV data.....)
-----------------------------30333176734664
Content-Disposition: form-data; name="fcsv2"; filename="data_2011_kd.CSV"
Content-Type: application/vnd.ms-excel
(....bulk od CSV data.....)
-----------------------------30333176734664
Content-Disposition: form-data; name="fileupload"
Upload
-----------------------------30333176734664--
HTTP/1.1 200 OK
Server: Zope/(Zope 2.10.13-final, python 2.4.6, linux2) ZServer/1.1
Date: Fri, 14 Oct 2011 09:21:48 GMT
Content-Length: 2389
Content-Type: text/html; charset=cp1250
_______________________________________________
Zope maillist - Zope@zope.org
https://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
https://mail.zope.org/mailman/listinfo/zope-announce
https://mail.zope.org/mailman/listinfo/zope-dev )