private function processTextfileDataToDatabase($dir, $spatialfile, $sheetname, $bexcel) { $conn = $this->get('database_connection'); $runResult = null; if ($bexcel === true) { $field_names = SpatialFileMethods::excelToDatabase($conn, $dir, $spatialfile, $sheetname); if ($field_names !== null && count($field_names) > 0) { SpatialFileMethods::updateTableGeommetry($this->params, $conn, 'spatial_' . str_replace('-', '_', $spatialfile->getId())); } else { $runResult = "uploaded excel file:" . $spatialfile->getFileName() . " no field name found!"; } } else { $field_names = SpatialFileMethods::textToDatabase($conn, $dir, $spatialfile); if ($field_names !== null && count($field_names) > 0) { SpatialFileMethods::updateTableGeommetry($this->params, $conn, 'spatial_' . str_replace('-', '_', $spatialfile->getId())); } else { $runResult = "uploaded text file:" . $spatialfile->getFileName() . " no field name found!"; } } return $runResult; }
public static function checkTextDataFields($textData) { $i = 0; $field_names = array(); foreach ($textData as $data) { if ($i == 0) { $field_names = SpatialFileMethods::checkTextDataFieldNames($data); } else { $field_names = SpatialFileMethods::checkTextDataEachRowType($data, $field_names); } $i = $i + 1; } return $field_names; }