PHP import_parts Examples

Example #1

File: partsB.php Project: jquade/lxoffice-erp

    /* check if file is really there */
    if (!file_exists("{$file}.csv") or filesize("{$file}.csv") == 0) {
        ende("Datenfile ({$file}.csv) nicht im Ordner gefunden oder leer");
    }
    /* Zu diesem Zeitpunkt wurde der Artikel Importiert */
    if (!$db->chkcol($file)) {
        ende("Importspalte konnte nicht angelegt werden");
    }
    /* first check all elements */
    $_test = $_POST;
    $_test["precision"] = -1;
    $_test["quotation"] = 0;
    $_test["lager"] = $_POST["lager"];
    $_test["lagerplatz"] = $_POST["lagerplatz"];
    /* just print data or insert it, if test is false */
    import_parts($db, $file, $trenner, $trennzeichen, $parts, FALSE, !$test, $_POST["show"], $_POST);
} else {
    $bugrus = getAllBG($db);
    ?>

<p class="listtop">Artikelimport f&uuml;r die ERP<p>
<br>
<form name="import" method="post" enctype="multipart/form-data" action="partsB.php">
<input type="hidden" name="MAX_FILE_SIZE" value="20000000">
<input type="hidden" name="login" value="<?php 
    echo $login;
    ?>
">
<table>
<tr><td><input type="submit" name="ok" value="Hilfe"></td><td></td></tr>
<tr><td>Trennzeichen</td><td>

Example #2

File: tools_import.php Project: AlexanderS/Part-DB

         $import_data = extract_import_data_from_request($table_rowcount);
         $table_loop = build_parts_import_template_loop($database, $current_user, $log, $import_data);
         import_parts($database, $current_user, $log, $import_data, true);
         $html->set_variable('data_is_valid', true, 'boolean');
         // now the "import" button will be visible
         $messages[] = array('text' => 'Die Daten sind gültig!', 'strong' => true, 'color' => 'darkgreen');
     } catch (Exception $e) {
         $messages[] = array('text' => 'Die Daten sind nicht gültig!', 'strong' => true, 'color' => 'red');
         $messages[] = array('text' => 'Fehlermeldung: ' . nl2br($e->getMessage()), 'color' => 'red');
     }
     break;
 case 'import_data':
     try {
         $import_data = extract_import_data_from_request($table_rowcount);
         $table_loop = build_parts_import_template_loop($database, $current_user, $log, $import_data);
         $new_parts = import_parts($database, $current_user, $log, $import_data, false);
         $html->set_variable('refresh_navigation_frame', true, 'boolean');
         $messages[] = array('text' => 'Die Daten wurden erfolgreich importiert!', 'strong' => true, 'color' => 'darkgreen');
         unset($import_data);
         unset($table_loop);
         $file_content = '';
         $new_part_ids = '';
         foreach ($new_parts as $part) {
             $new_part_ids .= $part->get_id() . ';';
         }
         // reload the site to avoid multiple actions by manual refreshing
         header('Location: tools_import.php?show_imported_parts=1&new_part_ids=' . $new_part_ids);
     } catch (Exception $e) {
         $messages[] = array('text' => 'Es gab ein Fehler beim Importieren!', 'strong' => true, 'color' => 'red');
         $messages[] = array('text' => 'Fehlermeldung: ' . nl2br($e->getMessage()), 'color' => 'red');
     }