[Phpmyadmin-devel] ESRI and docSQL Import Plugins
Hi, Madhura, I saw that last year your wrote the plug-in for importing ESRI Shape files. I found a short description of the format, and I wrote it here [1], but I'm not sure if that corresponds. Could you please check? Also, is there any way you can provide me with a sample .shp file to test the new import plugin? :) On a related note, Michal, do you think docSQL is still supported? I saw that their last update was in 2009, and their website is not available [2]. I downloaded the archive, but their English readme is in Deutsch, and their Deutsch readme is in English, but still not very helpful, so I did not manage to get around it. Do you think we should keep this import format? [1] http://wiki.phpmyadmin.net/pma/import [2] http://sourceforge.net/projects/docsql/ -- Alex
On Wed, Jul 4, 2012 at 9:28 PM, Alex Marin <alex.ukf@gmail.com> wrote:
Hi,
Madhura, I saw that last year your wrote the plug-in for importing ESRI Shape files. I found a short description of the format, and I wrote it here [1], but I'm not sure if that corresponds. Could you please check?
Yes, the description there is fine :)
Also, is there any way you can provide me with a sample .shp file to test the new import plugin? :)
Tracker artifact [1] contains some of the files I used for testing purposes. And the link in Michal's comment there points to some additional resources.
[1] http://sourceforge.net/tracker/index.php?func=detail&aid=3362549&group_id=23... -- Thanks and Regards, Madhura Jayaratne
On Wed, Jul 4, 2012 at 7:37 PM, Madhura Jayaratne <madhura.cj@gmail.com> wrote:
Tracker artifact [1] contains some of the files I used for testing purposes. And the link in Michal's comment there points to some additional resources.
Thanks. I tested two .shp files and each of them produced a single table with a single column called 'SPATIAL' and values similar to: [GEOMETRY - 2.2 KiB] [GEOMETRY - 3.6 KiB] etc. -- Alex
On Thu, Jul 5, 2012 at 12:39 AM, Alex Marin <alex.ukf@gmail.com> wrote:
On Wed, Jul 4, 2012 at 7:37 PM, Madhura Jayaratne <madhura.cj@gmail.com> wrote:
Tracker artifact [1] contains some of the files I used for testing purposes. And the link in Michal's comment there points to some additional resources.
Thanks. I tested two .shp files and each of them produced a single table with a single column called 'SPATIAL' and values similar to: [GEOMETRY - 2.2 KiB] [GEOMETRY - 3.6 KiB] etc.
Well, the .shp file contains only the geometry data. So if you submitted only the .shp file these results are correct. Additional data is in the .dbf file and you need to have PHP compiled with the dBase extension to import this file. More information on how you can submit multiple files can be found at [1].
[1] http://www.phpmyadmin.net/documentation/Documentation.html#faq6_30 -- Thanks and Regards, Madhura Jayaratne
On Thu, Jul 5, 2012 at 3:52 AM, Madhura Jayaratne <madhura.cj@gmail.com> wrote:
Well, the .shp file contains only the geometry data. So if you submitted only the .shp file these results are correct. Additional data is in the .dbf file and you need to have PHP compiled with the dBase extension to import this file. More information on how you can submit multiple files can be found at [1].
[1] http://www.phpmyadmin.net/documentation/Documentation.html#faq6_30
Ok, sorry for not reading that myself. -- Alex
participants (2)
-
Alex Marin -
Madhura Jayaratne