function grabData($filename) { $rowNumber = 0; if (($handle = fopen($filename, "r")) !== FALSE) { while (($data = fgetcsv($handle, 0, ",")) !== FALSE) { //pp($rowNumber); // //-----------------------------------------------------------------------convert to usable array $convertedData = convertData($data, $rowNumber); // //-----------------------------------------------------------------------create new file location makePath($convertedData); // //-----------------------------------------------------------------------if tiff convert to pdf and move to new location convertAndCreate($convertedData); // //-----------------------------------------------------------------------crates xml file createXMLFile($convertedData); //Needs file create first //ppr($convertedData); $rowNumber++; } // add 1 to row number and reepeat on next line of data } //Close file fclose($handle); }
<?php //Array of fields. Format: fieldName (as in the XML), description, type (text, date, boolean, if boolean, an array of two values), required (true, false, or, if required because of another field, the field name) $fields = [['fieldName' => 'archiveInformationPackageID', 'description' => 'AVID', 'type' => 'text', 'required' => true, 'count' => 1], ['fieldName' => 'archiveInformationPackageIDPrevious', 'description' => 'Tidligere aflevering', 'type' => 'text', 'required' => true, 'count' => 1], ['fieldName' => 'archivePeriodStart', 'description' => 'Startdato', 'type' => 'date', 'required' => true, 'count' => 1], ['fieldName' => 'archivePeriodEnd', 'description' => 'Slutdato', 'type' => 'date', 'required' => true, 'count' => 1], ['fieldName' => 'archiveInformationPacketType', 'description' => 'Slutaflevering', 'type' => 'bool', 'data' => [['value' => 'true', 'description' => 'Ja'], ['value' => 'false', 'description' => 'Nej']], 'required' => true, 'count' => 1], ['fieldName' => 'archiveType', 'description' => 'Afleveringstype', 'type' => 'bool', 'data' => [['value' => 'true', 'description' => 'Afsluttet periode'], ['value' => 'false', 'description' => 'Øjebliksbillede']], 'required' => true, 'count' => 1], ['fieldName' => 'systemName', 'description' => '', 'type' => 'text', 'required' => true, 'count' => 1], ['fieldName' => 'alternativeName', 'description' => '', 'type' => 'text', 'required' => false, 'count' => 'm'], ['fieldName' => 'systemPurpose', 'description' => '', 'type' => 'text', 'required' => true, 'count' => 1], ['fieldName' => 'systemContent', 'description' => '', 'type' => 'text', 'required' => true, 'count' => 1], ['fieldName' => 'regionNum', 'description' => '', 'type' => 'bool', 'data' => [['value' => 'true', 'description' => 'Ja'], ['value' => 'false', 'description' => 'Nej']], 'required' => true, 'count' => 1], ['fieldName' => 'komNum', 'description' => '', 'type' => 'bool', 'data' => [['value' => 'true', 'description' => 'Ja'], ['value' => 'false', 'description' => 'Nej']], 'required' => true, 'count' => 1], ['fieldName' => 'cprNum', 'description' => '', 'type' => 'bool', 'data' => [['value' => 'true', 'description' => 'Ja'], ['value' => 'false', 'description' => 'Nej']], 'required' => true, 'count' => 1], ['fieldName' => 'matrikNum', 'description' => '', 'type' => 'bool', 'data' => [['value' => 'true', 'description' => 'Ja'], ['value' => 'false', 'description' => 'Nej']], 'required' => true, 'count' => 1], ['fieldName' => 'bbrNum', 'description' => '', 'type' => 'bool', 'data' => [['value' => 'true', 'description' => 'Ja'], ['value' => 'false', 'description' => 'Nej']], 'required' => true, 'count' => 1], ['fieldName' => 'whoSygKod', 'description' => '', 'type' => 'bool', 'data' => [['value' => 'true', 'description' => 'Ja'], ['value' => 'false', 'description' => 'Nej']], 'required' => true, 'count' => 1], ['fieldName' => 'sourceName', 'description' => '', 'type' => 'text', 'required' => ['multipleDataCollection'], 'count' => 'm'], ['fieldName' => 'userName', 'description' => '', 'type' => 'text', 'required' => false, 'count' => 'm'], ['fieldName' => 'predecessorName', 'description' => '', 'type' => 'text', 'required' => false, 'count' => 'm'], ['fieldName' => 'containsDigitalDocuments', 'description' => '', 'type' => 'bool', 'data' => [['value' => 'true', 'description' => 'Ja'], ['value' => 'false', 'description' => 'Nej']], 'required' => true, 'count' => 1], ['fieldName' => 'searchRelatedOtherRecords', 'description' => '', 'type' => 'bool', 'data' => [['value' => 'true', 'description' => 'Ja'], ['value' => 'false', 'description' => 'Nej']], 'required' => true, 'count' => 1], ['fieldName' => 'relatedRecordsName', 'description' => '', 'type' => 'text', 'required' => ['searchRelatedOtherRecords'], 'count' => 'm'], ['fieldName' => 'systemFileConcept', 'description' => '', 'type' => 'bool', 'data' => [['value' => 'true', 'description' => 'Ja'], ['value' => 'false', 'description' => 'Nej']], 'required' => true, 'count' => 1], ['fieldName' => 'multipleDataCollection', 'description' => '', 'type' => 'bool', 'data' => [['value' => 'true', 'description' => 'Ja'], ['value' => 'false', 'description' => 'Nej']], 'required' => true, 'count' => 1], ['fieldName' => 'personalDataRestrictedInfo', 'description' => '', 'type' => 'text', 'required' => true, 'count' => 1], ['fieldName' => 'otherAccessTypeRestrictions', 'description' => '', 'type' => 'text', 'required' => true, 'count' => 1], ['fieldName' => 'archiveApproval', 'description' => '', 'type' => 'text', 'required' => true, 'count' => 1], ['fieldName' => 'archiveRestrictions', 'description' => '', 'type' => 'text', 'required' => false, 'count' => 1]]; if (isset($_POST['create_xml'])) { createXMLFile($fields); } else { if (isset($_GET['avid'])) { $fields = parseXMLGetValues('xmlf/' . $_GET['avid'] . '.xml', $fields); } require_once 'form_template.php'; } function createXMLFile($fields) { echo "Saves XML..."; $xml_document = writeXMLString($fields); $path_dir = "xmlf/"; $path_dir .= $_POST['archiveInformationPackageID'] . ".xml"; if (file_exists($path_dir)) { unlink($path_dir); } /* Data in Variables ready to be written to an XML file */ $fp = fopen($path_dir, 'w'); $write = fwrite($fp, $xml_document); /* Loading the created XML file to check contents */ $sites = simplexml_load_file($path_dir); echo "<br> Checking the loaded file <br>" . $path_dir . "<br>"; echo "<br><br>Whats inside loaded XML file?<br>"; print_r($sites); } function writeXMLString($fields)