/**
* Import data from CSV file into database
*/
public function import()
{
$API = new PerchAPI(1.0, 'root_locator');
$Lang = $API->get('Lang');
$Template = $API->get('Template');
$Template->set('locator/address.html', 'locator');
$Addresses = new RootLocator_Addresses($API);
$Tasks = new RootLocator_Tasks($API);
$data = $this->reader->fetchAssoc();
foreach ($data as $row) {
$errors = $this->getRowErrors($row);
$warnings = $this->getRowWarnings($row);
if ($errors) {
$this->addError($row, $Lang->get('‘%s’ columns are missing required data', $errors));
continue;
}
if ($warnings) {
$this->addWarning($row, $Lang->get('‘%s’ columns are recommended to prevent geocoding errors.', $warnings));
}
$imported = $Addresses->create(['addressTitle' => $row['addressTitle'], 'addressBuilding' => $row['addressBuilding'], 'addressStreet' => $row['addressStreet'], 'addressTown' => $row['addressTown'], 'addressRegion' => $row['addressRegion'], 'addressPostcode' => $row['addressPostcode'], 'addressCountry' => $row['addressCountry']]);
$imported->index($Template);
$Tasks->add('address.geocode', $imported->id());
$this->addSuccess($row);
}
}
$UserPrivileges->create_privilege('root_locator', 'Access the locator app');
$UserPrivileges->create_privilege('root_locator.import', 'Mass import location data');
// Convert categories
$sql = 'UPDATE ' . PERCH_DB_PREFIX . 'category_sets
SET setTemplate="~root_locator/templates/locator/category_set.html", setCatTemplate="~root_locator/templates/locator/category.html"
WHERE setTemplate="~/jw_locator/templates/locator/category_set.html"
AND setCatTemplate="~/jw_locator/templates/locator/category.html"';
$db->execute($sql);
}
if ($Settings->get('root_locator_update')->val() != '2.0.0') {
$legacy = $Addresses->getLegacyData($Paging);
if (PerchUtil::count($legacy)) {
foreach ($legacy as $row) {
// Ok, we have an error and it's not a quota issue, so just save as is.
if (isset($row['errorMessage']) && !empty($row['errorMessage']) && $row['errorMessage'] == 'The address could not be found.') {
$legacyAddress = $Addresses->create(['addressTitle' => $row['locationTitle'], 'addressBuilding' => $row['locationBuilding'], 'addressStreet' => $row['locationStreet'], 'addressTown' => $row['locationTown'], 'addressRegion' => $row['locationRegion'], 'addressPostcode' => $row['locationPostcode'], 'addressCountry' => $row['locationPostcode'], 'addressDynamicFields' => $row['locationDynamicFields'], 'addressError' => 'no_results']);
$legacyAddress->index();
continue;
}
// Do we have some existing location data we can just simply shift over?
if (isset($row['markerLatitude']) && isset($row['markerLongitude'])) {
$legacyAddress = $Addresses->create(['addressTitle' => $row['locationTitle'], 'addressBuilding' => $row['locationBuilding'], 'addressStreet' => $row['locationStreet'], 'addressTown' => $row['locationTown'], 'addressRegion' => $row['locationRegion'], 'addressPostcode' => $row['locationPostcode'], 'addressCountry' => $row['locationPostcode'], 'addressDynamicFields' => $row['locationDynamicFields'], 'addressLatitude' => $row['markerLatitude'], 'addressLongitude' => $row['markerLongitude']]);
$legacyAddress->index();
continue;
}
// Ok, default action is to just save the row and queue it for later.
$legacyAddress = $Addresses->create(['addressTitle' => $row['locationTitle'], 'addressBuilding' => $row['locationBuilding'], 'addressStreet' => $row['locationStreet'], 'addressTown' => $row['locationTown'], 'addressRegion' => $row['locationRegion'], 'addressPostcode' => $row['locationPostcode'], 'addressCountry' => $row['locationPostcode'], 'addressDynamicFields' => $row['locationDynamicFields']]);
$legacyAddress->index();
$Tasks->add('address.geocode', $legacyAddress->id());
}
} else {
