search

DHoffm / Responsive-color-google-map

display a custom colored responsive Google map (api 3) in Joomla 2.5/3.0
10 stars 3 forks source link

CSV file import and export #3

Open fridayshoes opened 9 years ago

fridayshoes commented 9 years ago

Is it possible to add a CSV file import and export option into the backend?

Would be awesomely handy for importing a list of co-ordinates and labels.

Regards

DHoffm commented 9 years ago

I was working on an import/export admin interface but unfortunately I don't have enough time at the moment to complete it.

fridayshoes commented 9 years ago

Is there a way to do it manually? Is the data stored in a file, maybe I can copy paste the data in that way?

DHoffm commented 9 years ago

The data is saved to the database, into the modules table. The field is called "params" which is the default Joomla field for module settings.

Here is an example:

{"profilResponsiveMapTemplates":"default","profilResponsiveMapGeoCoordinates":["50.98476789999999","11.029879899999969","test","","",""],"profilResponsiveMapColor":"#123456","profilResponsiveMapContrast":"1.58","profilResponsiveMapZoom":"14","profilResponsiveMapPopup":"1","profilResponsivePanControl":"1","profilResponsiveZoomControl":"1","profilResponsiveMapTypeControl":"1","profilResponsiveScaleControl":"1","profilResponsiveStreetViewControl":"1","profilResponsiveScrollwheel":"1","cache":"1","cache_time":"900","module_tag":"div","bootstrap_size":"0","header_tag":"h3","header_class":"","style":"0"}

The saving of this data is prety much handled by Joomla itself. The data is saved in the order of the field declaration which can be found here: https://github.com/DHoffm/Responsive-color-google-map/blob/master/mod_profil_responsive_map.xml

What might be interesting for you ist the following part which you could alter with a PHP/SQL script:

profilResponsiveMapGeoCoordinates":["50.98476789999999","11.029879899999969","test","","",""]

The locations are saved as [Latitude, Longitude, Label, Latitude, Longitude, Label ,...] and so on.

Hope this helps.

How many locations are you planning to add?

fridayshoes commented 9 years ago

Thanks, I have around 40+ locations ready to add