Can you import locations from a CSV (or other file) and...

Hi,

There's no import tool yet in MML, but it's a feature we would like to add in a future version.
But if you're familiar with MySQL you can try to import csv/xls in database

Regards,

well, I am familiar. I can access phpmyadmin and import there, but the question is this...
if I just have 2 columns. name and zip code, would that be enough to add the locations?

@Jonathan Rosenbaum
though we are not supporting mml import functionality.the main thing is we are highly dependent on latitude and longitude for geocoding. for that i have created one function

components\com_mymaplocations\helpers\mymaplocations.php

there we have created the function

public function getLatLongFromPostcode($postcode)

if you want to call that function anywhere in the code you can do it by

$filename=JPATH_SITE . '/components/com_mymaplocations/helpers/mymaplocations.php';
if (file_exists($filename)) {
require_once($filename);
}

$geo=MyMaplocationsHelper::getLatLongFromPostcode($address) ;

here if in this function you can put postcode it will geocode.so you need to create one custom script where you can call this function and save the data in geocode.once you get latitude longitude just save them on database.
i am also open to help you in it if you find any issues in it.

well, I found a zip to geocode converter and I tweaked the file and did a mass upload to the database.

2 things:
for some reason when I go to the page it messes up the main nav bar
http://www.alliedaircontractor.net/alliedaircooling/index.php/where-to-buy

second is there a way to reduce the size of that large search bar? I'm guessing css, but is there something other than that?

@Jonathan ,
It looks really cool.can you please create one ticket to my maplocation as you are not pre sales forum customer anymore so i can try to customize the code for you.

Hi, I have the same problem, I have around 500 location that I need to import but all I have is the city for location...My problem is that I have no coding or database skills...Any suggestion or tutorial available...?

Thanks