« Return to Thread: insert interactively asc or text files
Re: insert interactively asc or text files
by Stephen Frost
::
Rate this Message:
* Chetan Tiwari (chetan.tiwari@...) wrote:
> I have a little perl script that reads CSV files uploaded via a browser and
> inserts the data into a table in postgres. I'll be happy to share that with
> you. It's setup to run with active perl and apache on windows, but it would
> be fairly easy to tweak it to your system setup.
If you want to do it on-the-fly you can use CGI.pm and its upload-hook
to avoid any disk i/o on the web server (and avoid any temp file
creation, or limits due to space on the disk, etc).
Thanks,
Stephen
> On 7/4/07, pere roca <peroc79@...> wrote:
>>
>>
>> Hi everybody,
>> I just was wondering if there is some tool to insert automatically data
>> from a .asc or .csv or text file (just X,Y and thematic data) to PostGIS
>> (something similar to shp2pgsql.exe).
>>
>> What I want to do is that after a user inserts a file in our server,
>> automatically this file is inserted in someway to PostGIS. How would you
>> do
>> it?
>>
>> Thanks!
>> Pere
>> --
>> View this message in context: http://www.nabble.com/insert
>> -interactively-asc-or-text-files-tf4022887.html#a11426251
>> Sent from the PostGIS - User mailing list archive at Nabble.com.
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users@...
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>
>
>
> --
> Chetan Tiwari, Ph.D. (ABD)
> Dept. of Geography, The Univ. of Iowa
> 316 Jessup Hall, Iowa City, IA 52242
> Ph. (319) 335-0165 Fax (319) 335-2725
> _______________________________________________
> postgis-users mailing list
> postgis-users@...
> http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users
> I have a little perl script that reads CSV files uploaded via a browser and
> inserts the data into a table in postgres. I'll be happy to share that with
> you. It's setup to run with active perl and apache on windows, but it would
> be fairly easy to tweak it to your system setup.
If you want to do it on-the-fly you can use CGI.pm and its upload-hook
to avoid any disk i/o on the web server (and avoid any temp file
creation, or limits due to space on the disk, etc).
Thanks,
Stephen
> On 7/4/07, pere roca <peroc79@...> wrote:
>>
>>
>> Hi everybody,
>> I just was wondering if there is some tool to insert automatically data
>> from a .asc or .csv or text file (just X,Y and thematic data) to PostGIS
>> (something similar to shp2pgsql.exe).
>>
>> What I want to do is that after a user inserts a file in our server,
>> automatically this file is inserted in someway to PostGIS. How would you
>> do
>> it?
>>
>> Thanks!
>> Pere
>> --
>> View this message in context: http://www.nabble.com/insert
>> -interactively-asc-or-text-files-tf4022887.html#a11426251
>> Sent from the PostGIS - User mailing list archive at Nabble.com.
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users@...
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>
>
>
> --
> Chetan Tiwari, Ph.D. (ABD)
> Dept. of Geography, The Univ. of Iowa
> 316 Jessup Hall, Iowa City, IA 52242
> Ph. (319) 335-0165 Fax (319) 335-2725
> _______________________________________________
> postgis-users mailing list
> postgis-users@...
> http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users
signature.asc (196 bytes) « Return to Thread: insert interactively asc or text files
| Free embeddable forum powered by Nabble | Forum Help |
