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

Reconcile CSV not showing up #5

Closed TheMagicLightBulb closed 10 years ago

TheMagicLightBulb commented 10 years ago

Hi,

I am using reconcile csv with OpenRefine, and when I start the recon service, everything seems to go well, until I choose the service in Open Refine. No services show up and the message in the attached screenshot appears. My data in the uploaded csv is nothing out of the ordinary, just names, addresses, and phone numbers of people. When I start the recon service, it does not match any of the data, and I know that is not correct, because it does the same with any of my other data, and Recon csv worked right before I upgraded to Mavericks, where it created matches for the data. However, I had similar issues the first time around in Mountain Lion as well, but as soon as I upgraded my java to the latest version (1.7.0_51), it worked. I STILL have the latest version of java in Mavericks, as I installed it again, but it is still not working. I am having the exact same issue on my Windows XP machine (and my Windows also has the latest version of java). I tried to uninstall java v6 to see if that would help, but Open Refine doesn't seem to like that, as it spit out a message saying I needed to install v6. Help would be greatly appreciated. Thanks!

TheMagicLightBulb commented 10 years ago

Here is the screenshot: reconcilecsv

mihi-tr commented 10 years ago

This is a really interesting problem - do you have any output given by reconcile-csv on the command line?

TheMagicLightBulb commented 10 years ago

I ran it again, and this is what I see as the output: output

mihi-tr commented 10 years ago

This is interesting - it seems to completely fail there. Can you give me details on how you call reconcile-csv and the csv file you are using? (first three rows should be enough).

From what I see the problem is in the fuzzy matching library.

TheMagicLightBulb commented 10 years ago

Ooohh! I figured the problem! It was really silly and small. I misspelled the column name that I used in my recon calling syntax. The name of the column in the csv file was FullName, and in my syntax I used FullName. @@ Arrgh. Thanks for looking into this though.

magdmartin commented 10 years ago

I am experiencing the same issue, however this is not due to a syntax error in between my file and my command.

I've tried with Google Refine 2.5 and OpenRefine 2.6-beta. With Google Refine 2.5 I've the same screen as @TheMagicLightBulb OpenRefine 2.6-beta just spin endlessy (or I refreshed the page before any message was displayed)

I have the same error in the consol as @TheMagicLightBulb

I am using dummy test data to wrap my head around this service: Refine project data

name
WilLIAM
martin
JOEE
Henry

csv data:

"id","name"
"1","William"
"2","Martin"
"3","Joe"
"4","Henry"
"5","John"
"6","Tom"

command used to start the server: java -jar reconcile-csv-0.1.1.jar name.csv name id

magdmartin commented 10 years ago

I restarted my machine and waited a couple of day and everthing works fine now. I guess I had a typo somewhere. Sorry for the trouble

mihi-tr commented 10 years ago

No worries!