Example usage for org.apache.commons.csv CSVRecord get

Introduction

In this page you can find the example usage for org.apache.commons.csv CSVRecord get.

Prototype

public String get(final String name) 

Source Link

Document

Returns a value by name.

Usage

From source file:com.siemens.sw360.importer.ReleaseLinkCSVRecordBuilder.java

ReleaseLinkCSVRecordBuilder(CSVRecord record) {
    int i = 0;//from  ww w . j ava 2s  .c o m
    componentName = record.get(i++);
    releaseName = record.get(i++);
    releaseVersion = record.get(i++);
    linkedComponentName = record.get(i++);
    linkedReleaseName = record.get(i++);
    linkedReleaseVersion = record.get(i++);
    relationship = ThriftEnumUtils.stringToEnum(record.get(i), ReleaseRelationship.class);
}

---

From source file:com.publictransitanalytics.scoregenerator.datalayer.directories.GTFSReadingStopDetailsDirectory.java

public GTFSReadingStopDetailsDirectory(final Store<StopIdKey, StopDetails> stopDetailsStore,
        final Reader stopDetailsReader) throws IOException, InterruptedException {

    this.stopDetailsStore = stopDetailsStore;
    try {//from   w w w  .j a  va 2s.  c o m
        if (stopDetailsStore.isEmpty()) {
            log.info("Building stop details directory.");

            final CSVParser parser = new CSVParser(stopDetailsReader, CSVFormat.DEFAULT.withHeader());
            final List<CSVRecord> stopDetailsRecords = parser.getRecords();
            for (CSVRecord record : stopDetailsRecords) {
                final String latitude = record.get("stop_lat");
                final String longitude = record.get("stop_lon");
                final String stopId = record.get("stop_id");
                final StopDetails stopDetails = new StopDetails(stopId, record.get("stop_name"),
                        new Coordinate(latitude, longitude));
                stopDetailsStore.put(new StopIdKey(stopId), stopDetails);
            }
        }
    } catch (final BitvantageStoreException e) {
        throw new ScoreGeneratorFatalException(e);
    }
}

---

From source file:com.tutuka.io.CSVFileReader.java

public List<TransactionRecord> loadFileIntoList() throws IOException {
    Reader in;//from w  w w  .j  a v  a  2s .c  o m
    if (handlePart) {
        in = new InputStreamReader(tutukaFile.getInputStream());
    } else {
        in = new FileReader(fileLocation);
    }

    Iterable<CSVRecord> records = CSVFormat.EXCEL.withHeader().parse(in);

    List<TransactionRecord> trecList;
    trecList = new ArrayList<>();
    for (CSVRecord rec : records) {
        TransactionRecord trec = new TransactionRecord();
        trec.setTransactionID(rec.get("TransactionID"));
        trecList.add(trec);
    }
    return trecList;
}

---

From source file:com.ksa.myanmarlottery.service.parser.CSVFileParser.java

public List<Result> getResult(InputStream in) throws FileNotFoundException, IOException, ParseException {
    Iterable<CSVRecord> records = CSVFormat.RFC4180
            .parse(new BufferedReader(new InputStreamReader(in, "UTF-8")));
    int i = 0;/*ww  w  .j av  a  2  s. co m*/
    List<Result> resultList = new ArrayList<>();
    List<Prize> prizes = null;
    for (CSVRecord record : records) {
        if (OLD_LOTTERY_TYPE.equals(record.get(0))) { // for lottery type result
            Result result = new Result();
            result.setType(ConstantUtil.OLD_LOTTERY_TYPE);
            result.setNumberOfTimes(Integer.valueOf(record.get(1)));
            result.setResultFor(new SimpleDateFormat("dd/MM/yyyy").parse(record.get(2)));
            result.setDataProvider(record.get(3));
            result.setCompanyName(record.get(4));
            prizes = new ArrayList<Prize>();
            result.setPrizes(prizes);
            resultList.add(result);

        } else if (NEW_LOTTERY_TYPE.equals(record.get(0))) {
            Result result = new Result();
            result.setType(ConstantUtil.NEW_LOTTERY_TYPE);
            result.setNumberOfTimes(Integer.valueOf(record.get(1)));
            result.setResultFor(new SimpleDateFormat("dd/MM/yyyy").parse(record.get(2)));
            result.setDataProvider(record.get(3));
            result.setCompanyName(record.get(4));

            prizes = new ArrayList<Prize>();
            result.setPrizes(prizes);
            resultList.add(result);

        } else {
            // check validation for character.
            String character = record.get(0);
            String value = charMap.get(character);
            if (value == null) {
                throw new ParseException("Character is Not valid at Row " + i + " column:" + 0, 400);
            }
            prizes.add(new Prize(record.get(0), Integer.parseInt(record.get(1)), record.get(2), record.get(4)));
        }
        i++;
    }
    log.info("Total rows after parsing. " + i);
    return resultList;
}

---

From source file:com.esri.geoevent.datastore.CSVParsingTest.java

@Test
public void testSimpleCSVParse() throws Exception {
    StringReader csvServers = new StringReader("mingz14,getest1w");
    Iterable<CSVRecord> records = CSVFormat.DEFAULT.parse(csvServers);
    for (CSVRecord record : records) {
        int size = record.size();
        for (int i = 0; i < size; i++) {
            System.out.println(record.get(i));
        }//from  w  w w .j a va  2  s.  com
    }
}

---

From source file:de.speexx.jira.jan.service.issue.IssueCoreFieldConfigLoader.java

Set<FieldName> fetchAliasses(final CSVRecord record) {
    final String alias = record.get(FIELDNAME_ALIAS_HEADER);
    if (alias == null || alias.length() == 0) {
        return Collections.emptySet();
    }/*from  ww w  . j ava  2  s  .c o  m*/
    final String[] aliases = alias.split(KEY_ALIAS_DELIMITER);
    if (aliases.length == 0) {
        return Collections.emptySet();
    }
    final FieldName[] fieldNameAliases = new FieldName[aliases.length];
    for (int i = 0; i < aliases.length; i++) {
        fieldNameAliases[i] = this.fieldNameService.createFieldName(aliases[i].trim());
    }
    return new HashSet<>(Arrays.asList(fieldNameAliases));
}

---

From source file:com.ibm.watson.catalyst.jumpqa.template.TemplateFactory.java

@Override
public ITemplate readRecord(final CSVRecord aRecord) {
    logger.fine("Reading record #" + aRecord.getRecordNumber());

    final String templateClass = aRecord.get("Template Class");
    logger.finer("Template class is" + templateClass);
    final ITemplateRecordReader trr = readers.get(templateClass);
    if (trr == null)
        throw new RuntimeException("Template Class not found: " + templateClass);

    return trr.readRecord(aRecord);
}

---

From source file:de.upb.wdqa.wdvd.processors.decorators.GeolocationFeatureProcessor.java

private String getValue(CSVRecord record, String key) {
    String value = record.get(key);

    if (value.equals(FeatureValue.MISSING_VALUE_STRING)) {
        value = null;//from  w ww.j a  va  2s .  c o  m
    }

    return value;
}

---

From source file:com.ibm.g11n.pipeline.example.MultiBundleCSVFilter.java

@Override
public Map<String, LanguageBundle> parse(InputStream inStream, FilterOptions options)
        throws IOException, ResourceFilterException {
    Map<String, LanguageBundleBuilder> builders = new HashMap<String, LanguageBundleBuilder>();
    CSVParser parser = CSVParser.parse(inStream, StandardCharsets.UTF_8,
            CSVFormat.RFC4180.withHeader("module", "key", "value").withSkipHeaderRecord(true));

    for (CSVRecord record : parser) {
        String bundle = record.get(0);
        String key = record.get(1);
        String value = record.get(2);

        LanguageBundleBuilder bundleBuilder = builders.get(bundle);
        if (bundleBuilder == null) {
            bundleBuilder = new LanguageBundleBuilder(true);
            builders.put(bundle, bundleBuilder);
        }//from  www  .j a va2 s.  c  o  m
        bundleBuilder.addResourceString(key, value);
    }

    Map<String, LanguageBundle> result = new TreeMap<String, LanguageBundle>();
    for (Entry<String, LanguageBundleBuilder> bundleEntry : builders.entrySet()) {
        String bundleName = bundleEntry.getKey();
        LanguageBundle bundleData = bundleEntry.getValue().build();
        result.put(bundleName, bundleData);
    }

    return result;
}

---

From source file:gradingfun.GradeParser.java

public void parse() {
    Map<String, Double> data = new HashMap<String, Double>();
    for (CSVRecord csvRecord : this.parser) {
        if (csvRecord.getRecordNumber() > 1) {
            String lastName = csvRecord.get(0);
            String firstName = csvRecord.get(1);
            String score = csvRecord.get(6);
            Double dblScore = null;
            try {
                dblScore = new Double(score);
            } catch (NumberFormatException ex) {
                dblScore = 0.0;//from   www  .  ja va2  s. c  om
            }
            data.put(firstName + " " + lastName, dblScore);
        }
    }
    this.parsedData = data;
    try {
        this.parser.close();
    } catch (IOException ex) {
        Logger.getLogger(GradeParser.class.getName()).log(Level.SEVERE, null, ex);
    }
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »