public boolean importKK(final String file) {
ExcelWrapper exw = new ExcelWrapper();
exw.setFieldTypes(
new Class[] {
Integer.class,
String.class,
String.class,
String.class,
String.class,
Integer.class,
Integer.class
});
exw.load(file, 0);
String[] row;
for (int i = exw.getFirstRow() + 1; i <= exw.getLastRow(); i++) {
row = exw.getRow(i).toArray(new String[0]);
if (row == null) {
continue;
}
if (row.length != 7) {
continue;
}
log.info(Messages.KontaktImporterBlatt_Importing + StringTool.join(row, " "));
// Please keep in sync with doc/import.textile !!
String bagnr = StringTool.getSafe(row, 0);
String name = StringTool.getSafe(row, 1);
String zweig = StringTool.getSafe(row, 2);
String adresse = StringTool.getSafe(row, 3);
String typ = StringTool.getSafe(row, 4);
String EANInsurance = StringTool.getSafe(row, 5);
String EANReceiver = StringTool.getSafe(row, 6);
String[] adr = splitAdress(adresse);
Organisation kk =
KontaktMatcher.findOrganisation(name, null, adr[0], adr[1], adr[2], CreateMode.CREATE);
if (kk == null) {
return false;
}
kk.setInfoElement("EAN", EANInsurance); // $NON-NLS-1$
kk.setInfoElement("BAGNr", bagnr); // $NON-NLS-1$
kk.set("Bezeichnung2", zweig); // $NON-NLS-1$
kk.set(
"Kuerzel",
StringTool.limitLength(
Messages.KontaktImporterBlatt_KKKuerzel // $NON-NLS-1$
+ StringTool.getFirstWord(name),
39));
}
return true;
}
/**
* remove an external reference
*
* @param ref the reference to remove
*/
public void removeRef(String ref) {
List<String> refs = getRefs();
refs.remove(ref);
set(FLD_REFS, StringTool.join(refs, StringConstants.COMMA));
}