Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- /** PHPExcel_IOFactory */
- include $_SERVER["DOCUMENT_ROOT"].'/_excel_import_export/Classes/PHPExcel/IOFactory.php';
- //$inputFileName = 'dogeductus_import.xlsx';
- $inputFileName = $_SERVER["DOCUMENT_ROOT"].'/_excel_import_export/test.xlsx';
- $objPHPExcel = PHPExcel_IOFactory::load($inputFileName);
- $sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);
- echo "<div style=''>";
- foreach ($sheetData as $sheetDataRow)
- {
- if($sheetDataRow["A"] != "") {
- echo "<br><br>".$sheetDataRow["A"];
- // Skapa Modul
- $post_module_id = get_page_by_title($sheetDataRow["C"], ARRAY_A, 'module'); // Viktigt att det inte ligger något i trash för den får med trash i sökningen också
- if ($post_module_id == NULL) {
- $post_module = array(
- 'post_title' => $sheetDataRow["C"], // Modulnamn
- //'post_author' => $new_user_id,
- 'post_type' => 'module',
- 'post_status' => "publish"
- );
- $post_module_id = wp_insert_post( $post_module );
- echo " Insert-post Module";
- }
- // Skapa Övning
- $post_exercise = array(
- 'post_title' => $sheetDataRow["B"], // Övningsnamn
- //'post_author' => $new_user_id,
- 'post_type' => 'exercise',
- 'post_status' => "publish"
- );
- //var_dump($post);
- $post_id = wp_insert_post( $post_exercise );
- echo " Insert-post Exercise";
- update_field('field_544d33d862fab', $sheetDataRow["A"], $post_id); // DogID
- echo " DogID";
- update_field('field_5409c4a59ed5c', $sheetDataRow["G"], $post_id); // Förkunskaper
- echo " Förkunskaper";
- update_field('field_5409c423a08a1', $sheetDataRow["I"], $post_id); // Syfte
- echo " Syfte";
- update_field('field_5409c3be8da74', $sheetDataRow["J"], $post_id); // Beskrivning
- echo " Beskrivning";
- update_field('field_5409c615fee5b', $post_id, $post_module_id); // Modul
- update_field('field_5409e884a7aeb', $post_module_id, $post_id); // Övning/Modul
- echo " Modul";
- if($sheetDataRow["F"] == "Lätt") {
- update_field('field_5409c4f1805c3', "1", $post_id); // Svårighetsgrad
- echo " Svårighetsgrad Lätt";
- }
- if($sheetDataRow["F"] == "Medel") {
- update_field('field_5409c4f1805c3', "2", $post_id); // Svårighetsgrad
- echo " Svårighetsgrad Medel";
- }
- if($sheetDataRow["F"] == "Svår") {
- update_field('field_5409c4f1805c3', "3", $post_id); // Svårighetsgrad
- echo " Svårighetsgrad Svår";
- }
- $field_key = "field_54098e6377390";
- $value = get_field($field_key, $post_id);
- $value[] = array("field_54098e7c77391" => $sheetDataRow["H"]);
- update_field( $field_key, $value, $post_id );
- //update_field('field_54098e7c77391', $sheetDataRow["C"], $post_id); // Video 1
- echo " Video 1";
- // Kategorier / Taggar
- wp_set_object_terms( $post_id, $sheetDataRow["D"], 'exercise_main_categories' ); // Huvudgrupp
- echo " Huvudgrupp";
- wp_set_object_terms( $post_id, $sheetDataRow["E"], 'exercise_sub_categories' ); // Undergrupp
- echo " Undergrupp";
- $exercise_tags = array();
- if($sheetDataRow["K"] != "") $exercise_tags[] = $sheetDataRow["K"];
- if($sheetDataRow["L"] != "") $exercise_tags[] = $sheetDataRow["L"];
- if($sheetDataRow["M"] != "") $exercise_tags[] = $sheetDataRow["M"];
- if($sheetDataRow["N"] != "") $exercise_tags[] = $sheetDataRow["N"];
- if($sheetDataRow["O"] != "") $exercise_tags[] = $sheetDataRow["O"];
- if($sheetDataRow["P"] != "") $exercise_tags[] = $sheetDataRow["P"];
- if($sheetDataRow["Q"] != "") $exercise_tags[] = $sheetDataRow["Q"];
- wp_set_object_terms( $post_id, $exercise_tags, 'exercise_tags' ); // Taggar
- echo " Taggar";
- }
- }
- echo "</div>";
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement