5 |
|
|
6 |
import org.apache.commons.fileupload.FileItem; |
import org.apache.commons.fileupload.FileItem; |
7 |
|
|
8 |
|
import com.google.common.base.CharMatcher; |
9 |
import com.google.common.base.Splitter; |
import com.google.common.base.Splitter; |
10 |
|
|
11 |
import dk.daoas.adressevedligehold.AddressSourceEntry.EntryType; |
import dk.daoas.adressevedligehold.AddressSourceEntry.EntryType; |
13 |
|
|
14 |
public class AddressSourceBK extends AbstractAddressSource { |
public class AddressSourceBK extends AbstractAddressSource { |
15 |
|
|
16 |
|
Splitter splitter = Splitter.on(';').trimResults( CharMatcher.is('"') ); |
17 |
|
|
18 |
public AddressSourceBK(FileItem file) throws Exception { |
public AddressSourceBK(FileItem file) throws Exception { |
19 |
super(file); |
super(file); |
41 |
AddressSourceEntry entry = new AddressSourceEntry( EntryType.TypeSingleAddress); |
AddressSourceEntry entry = new AddressSourceEntry( EntryType.TypeSingleAddress); |
42 |
entry.distributor = "BK"; |
entry.distributor = "BK"; |
43 |
|
|
44 |
List<String> parts =Splitter.on(';').splitToList(line); |
List<String> parts = splitter.splitToList(line); |
45 |
|
|
46 |
if (parts.size() != 14) { |
if (parts.size() != 14) { |
47 |
throw new IOException("Not enough fields in CSV file. Found " + parts.size() + ", expected 14"); |
throw new IOException("Not enough fields in CSV file. Found " + parts.size() + ", expected 14"); |
48 |
} |
} |
49 |
|
|
50 |
entry.postnr = Short.parseShort( parts.get(0) ); |
entry.postnr = Short.parseShort( parts.get(0) ); |
51 |
entry.vejnavn = parts.get( 1 ).replace("\"", ""); |
entry.vejnavn = parts.get( 1 ); |
52 |
entry.husnr = Short.parseShort( parts.get( 2 ) ); |
entry.husnr = Short.parseShort( parts.get( 2 ) ); |
53 |
entry.litra = parts.get( 3 ).replace("\"", ""); |
entry.litra = parts.get( 3 ); |
54 |
entry.vejkode = SafeParsers.parseShort( parts.get( 4) ); |
entry.vejkode = SafeParsers.parseShort( parts.get( 4) ); |
55 |
entry.kommunekode = SafeParsers.parseShort( parts.get( 5) ); |
entry.kommunekode = SafeParsers.parseShort( parts.get( 5) ); |
56 |
entry.gadeid = Integer.parseInt( parts.get( 6 ) ); |
entry.gadeid = Integer.parseInt( parts.get( 6 ) ); |
57 |
|
|
58 |
String ugedage = parts.get( 7 ).replace("\"", ""); |
String ugedage = parts.get( 7 ); |
59 |
|
|
60 |
String laesnr = parts.get( 8 ).replace("\"", ""); |
String laesnr = parts.get( 8 ); |
61 |
|
|
62 |
//String distnr = parts.get( 9 ).replace("\"", ""); //Bruges ikke |
//String distnr = parts.get( 9 ); //Bruges ikke |
63 |
String foede = parts.get( 10 ).replace("\"", ""); |
String foede = parts.get( 10 ); |
64 |
String jobnr = parts.get( 11 ).replace("\"", ""); |
String jobnr = parts.get( 11 ); |
65 |
String tklaes = parts.get( 12 ).replace("\"", ""); |
String tklaes = parts.get( 12 ); |
66 |
|
|
67 |
entry.rute = laesnr; |
entry.rute = laesnr; |
68 |
entry.koreliste = "/" + foede + "/" + tklaes + "/" + jobnr; |
entry.koreliste = "/" + foede + "/" + tklaes + "/" + jobnr; |