search

rufuspollock-okfn / reconcile-csv

A simple OpenRefine reconciliation service that runs on top of a CSV file
BSD 2-Clause "Simplified" License
117 stars 28 forks source link

Nearly there... #11

Open captoriginal opened 9 years ago

captoriginal commented 9 years ago

I feel I am just missing one little thing somewhere to get this all running nicely.

source csv (reconcile-v01.csv) looks like:

sid source 123 Waikiki Elementary School 321 Kaimuki Middle School

csv i want to adjust looks like:

match kaimuki mid waikiki elem

should ideally produce this:

match 321 123

I run reconcile-csv like so: java -jar reconcile-csv-0.1.1.jar reconcile-v01.csv 'source' 'sid' Starting CSV Reconciliation service Point refine to http://localhost:8000 as reconciliation service 2014-10-04 13:19:36.408:INFO:oejs.Server:jetty-7.x.y-SNAPSHOT 2014-10-04 13:19:36.431:INFO:oejs.AbstractConnector:Started SelectChannelConnector@0.0.0.0:8000

when i run "start reconciling" in OpenRefine, i get a Column 1 Judgement of 'none' for everything

the 'best candidates score' is 'No numeric value present.'

Any thoughts? Many thanks!!

mihi-tr commented 9 years ago

Hi there,

This looks interesting - Is your CSV really not comma delimited?

captoriginal commented 9 years ago

Haha. No no. It is, I was just typing it out. It does have a number of diacritical marks in it, but the cvs is sound.

mihi-tr commented 9 years ago

I've seen this as well. I have to check how to reproduce and fix. Do you have another column you could add to the reconciliation? It seems to work better then...