search

jeffreykemp / jk64-plugin-reportmap

Report Google Map APEX Plugin
https://jeffreykemp.github.io/jk64-plugin-reportmap/
MIT License
42 stars 16 forks source link

Lat Long decimal error #35

Closed the-serious-programmer closed 7 years ago

the-serious-programmer commented 7 years ago

Heyy Jeffrey,

First of all, thanks for the plugin! :)

I have tried your plugin, but when i put a decimal value in the lat or lng in the SQL statement, the plugin does not load any more (see the screenshots and the error in there below). But, when i put a decimal value in the Initial Map Position, everything seems fine and the map loads without any problem. Am i doing something wrong? I hope you can help me out!

Screenshot 1: table/column names + data screenshot 1 Screenshot 2: the select statement in the plugin screenshot 2 Screenshot 3: attribute settings part 1 screenshot 3 Screenshot 4: attribute settings part 2 screenshot 4 Screenshot 5: error in console screenshot 5

jeffreykemp commented 7 years ago

There was an earlier bug with certain numeric conversions. Please make sure you are using the latest release, 0.7.2.

I've tried creating a region with a query matching the data from your screenshot and it seems to work fine.

If you are already using this version and still getting this error, can you please set up a test case online, or perhaps send me an export of a minimal application with just the page with that region where it fails, and I will see if I can diagnose further.

Thanks! image

the-serious-programmer commented 7 years ago

Thanks for your quick response!

Hmm, i have the latest release installed.. but, i have some good news 👍 In the first screenshots from the first post, i tried to make your plug-in work on a development environment from my school. But.. now i have tried it on the development environment from my work and everything seems to work fine!! So i think the problem is that i do not have all the rights on my development enviroment from my school (or something else..).

Your plugin seems to be the perfect solution for the GEO map that i need in APEX, thank you for the development of the plug-in! :)

Screenshot 6 the plug-in works fine :) screenshot 6

jeffreykemp commented 7 years ago

Thanks for that. It's possible there's another issue at play, perhaps a different NLS number format setting that the plugin isn't taking into account. I thought I'd taken care of all those issues but there might still be some residual bits. If you can reproduce the issue again let me know.

Thanks