Ejemplo n.º 1
0
 public void load() {
   master.enableBackButton(false);
   if (!isConsumed) {
     Log.Debug(this, "Overwrite is set to " + master.getStore().getProperty("overwrite", false));
     importXML();
   }
 }
Ejemplo n.º 2
0
  private void imports() {
    jProgressBar1.setMinimum(0);
    jProgressBar1.setMaximum(jTable1.getRowCount());

    Runnable runnable =
        new Runnable() {

          public void run() {
            int imp = 0;
            for (int i = 0; i < jTable1.getRowCount(); i++) {
              if ((Boolean) jTable1.getValueAt(i, 1)) {
                master.setCursor(new Cursor(Cursor.WAIT_CURSOR));
                final int p = i;

                String val = "";
                try {
                  DatabaseObject dog = ((DatabaseObject) jTable1.getValueAt(p, 0));
                  if (!dog.saveImport()) {
                    val = "<html><p><font color =red>" + Messages.ERROR_OCCURED;
                  } else {
                    val =
                        "<html><p><font color =green>"
                            + Messages.IMPORTED
                            + " ID: "
                            + dog.__getIDS();
                    imp++;
                  }
                } catch (Exception e) {
                  val =
                      "<html><p><font color =red>" + Messages.ERROR_OCCURED + ": " + e.getMessage();
                } finally {
                  jTable1.setValueAt(val, p, 4);
                  jProgressBar1.setValue(p);

                  master.setCursor(new Cursor(Cursor.DEFAULT_CURSOR));
                }
              }
            }
            jProgressBar1.setString(imp + " " + Messages.IMPORTED);
          }
        };
    new Thread(runnable).start();

    master.setCursor(new Cursor(Cursor.DEFAULT_CURSOR));
    master.isEnd(true);
  }
 public boolean next() {
   try {
     imports();
   } catch (Exception e) {
     Log.Debug(e);
     master.setCursor(new Cursor(Cursor.DEFAULT_CURSOR));
   }
   return false;
 }
Ejemplo n.º 4
0
  private void importXML() {
    master.setCursor(new Cursor(Cursor.WAIT_CURSOR));
    isConsumed = true;
    XMLReader x;
    ArrayList<ArrayList<DatabaseObject>> objs = null;

    if (master.getStore().hasProperty("file")) {
      x = new XMLReader();
      x.setOverwriteExisting(true);
      try {
        x.newDoc(new File(master.getStore().getProperty("file")), false);
        objs = x.getObjects();
        jTable1.setModel(
            ImportTableModel.getModel(objs, !master.getStore().getProperty("overwrite", false)));
        jLabel2.setText(
            jLabel2.getText()
                + " "
                + master.getStore().getProperty("file")
                + " ("
                + jTable1.getRowCount()
                + ")");
        TableFormat.format(jTable1, 0, 0);
        TableFormat.format(jTable1, 1, 33);
        TableFormat.format(jTable1, 2, 100);
      } catch (Exception ex) {
        Popup.error(ex);
        Log.Debug(ex);
      } finally {
        master.setCursor(new Cursor(Cursor.DEFAULT_CURSOR));
      }
    }
  }
  @SuppressWarnings("unchecked")
  private void importCsv() {
    master.setCursor(new Cursor(Cursor.WAIT_CURSOR));
    isConsumed = true;
    CSVReaderWriter x;
    Object[][] arr;

    if (master.getStore().hasProperty("file")) {
      x =
          new CSVReaderWriter(
              new File(master.getStore().getProperty("file")),
              master.getStore().getProperty("separator"));
      List<Object[]> d = x.read();
      try {
        d = ArrayUtilities.removeDuplicates(d);
        arr = ArrayUtilities.listToTableArray(d);
        arr = ArrayUtilities.inserValue(arr, null, null);

        jTable1.setModel(new MPTableModel(arr));
        jLabel2.setText(
            jLabel2.getText()
                + " "
                + master.getStore().getProperty("file")
                + " ("
                + jTable1.getRowCount()
                + ")");

      } catch (Exception ex) {
        Popup.error(ex);
        Log.Debug(ex);
      } finally {
        master.setCursor(new Cursor(Cursor.DEFAULT_CURSOR));
      }
    }
    //
    //
    //        if (objs != null && objs.size() < 0) {
    //        } else {
    //            Popup.notice(Messages.NO_DATA_FOUND);
    //        }
    //      for (int i = 0; i < objs.size(); i++) {
    //                ArrayList<DatabaseObject> arrayList = objs.get(i);
    //                for (int j = 0; j < arrayList.size(); j++) {
    //                    DatabaseObject databaseObject = arrayList.get(j);
    //                    Log.Debug(this, "Parsing " + databaseObject.getDbIdentity() + " : " +
    // databaseObject.__getCname() + " from file: " + master.getStore().getProperty("file"));
    //                    databaseObject.save();
    //                }
    //            }
  }
  private void imports() {

    jProgressBar1.setMinimum(0);
    jProgressBar1.setMaximum(jTable1.getRowCount() * jTable1.getColumnCount());

    Runnable runnable =
        new Runnable() {

          public void run() {
            int imp = 0;

            for (int i = 0; i < jTable1.getRowCount(); i++) {
              master.setCursor(new Cursor(Cursor.WAIT_CURSOR));

              for (int j = 0; j < jTable1.getColumnCount() - 1; j++) {
                final int p = i;
                boolean existing = false;
                String val = null;
                try {
                  if (jTable1.getValueAt(p, j) != null) {
                    ProductGroup dog = null;
                    try {
                      Log.Debug(this, "Checking for group: " + jTable1.getValueAt(p, j));
                      dog =
                          (ProductGroup)
                              DatabaseObject.getObject(
                                  Context.getProductGroup(), jTable1.getValueAt(p, j).toString());
                      existing = true;
                      Log.Debug(this, "Already existing: " + jTable1.getValueAt(p, j));
                    } catch (NodataFoundException nodataFoundException) {
                      Log.Debug(this, "Create a new group: " + jTable1.getValueAt(p, j));
                      dog = new ProductGroup(jTable1.getValueAt(p, j).toString());
                      dog.setProductgroupsids(1);
                    }

                    if (j > 0) {
                      try {
                        Log.Debug(
                            this, "Checking for parent group: " + jTable1.getValueAt(p, j - 1));
                        dog.setProductgroupsids(
                            DatabaseObject.getObject(
                                    Context.getProductGroup(),
                                    jTable1.getValueAt(p, j - 1).toString())
                                .__getIDS());
                      } catch (NodataFoundException nodataFoundException1) {
                        throw new IllegalStateException(
                            "Parent unknown: " + jTable1.getValueAt(p, j - 1));
                      }
                    }

                    if (!existing) {
                      if (!dog.saveImport()) {
                        val = "<html><p><font color =red>" + Messages.ERROR_OCCURED;
                      } else {
                        val =
                            "<html><p><font color =green>"
                                + Messages.IMPORTED
                                + " ID: "
                                + dog.__getIDS();
                        imp++;
                      }
                    } else {
                      val = "<html><p><font color =blue> Existing ID: " + dog.__getIDS();
                    }
                  }
                } catch (Exception e) {
                  e.printStackTrace();
                  val =
                      "<html><p><font color =red>" + Messages.ERROR_OCCURED + ": " + e.getMessage();
                } finally {
                  if (val != null) {
                    jTable1.setValueAt(val, p, jTable1.getColumnCount() - 1);
                  }
                  jProgressBar1.setValue(p * j);
                  master.setCursor(new Cursor(Cursor.DEFAULT_CURSOR));
                }
              }
            }
            jProgressBar1.setString(imp + " " + Messages.IMPORTED);
          }
        };
    new Thread(runnable).start();

    master.setCursor(new Cursor(Cursor.DEFAULT_CURSOR));
    master.isEnd(true);
  }