Can't run reconcile-csv.jar file #9
Comments
|
Sorry for the late reply - extensive offline vacations here - The command prompt would be the right spot to run it. Don't forget to pass the right parameters to reconcile-csv. What is the result of your command prompt experiment? |
|
Hello! My apologies in advance for my newbie-ness. The reconcile-cvs instructions breeze over things that likely are obvious to seasoned data wranglers. But they aren't (yet) obvious to me. Like the member above, I'm am also having trouble starting the reconcile-csv server using the .jar file. A few questions: I am on the MacBook platform and in entering commands in terminal. Do I need to navigate to the same directory as the .jar file to run the command prompt to launch the server? Where should I put the .jar file so that it works? (Should I put it in a "Reconcile-CSV" folder along with the other reconcile services in the Extensions folder. I'm referring to the directory you can see when you click on the "Browse workspace directory" link at the bottom of the OpenRefine home page when the app is running.)
Where should I put the .csv file to which it refers? Does it belong in the same directory as the .jar file? Do I need to navigate to that folder in Terminal to execute the command to start? When I enter the code into Terminal to start the server (java -jar reconcile-csv-0.1.1.jar ), how should the CSV-File name be entered? I have a file called InventorsList.csv. Does it need the suffix ".csv"? Do the values need quotes around the names? I've tried with and without quotes, with and without .csv and still get the following error:
Last, more a big-picture concept thing so that I can wrap my brain around this -- how does this work exactly? As an example: My plan is to bring in the inventor Spreadsheet A into OpenRefine to reconcile on the column called Name against Spreadsheet B. My understanding is that Spreadsheet B would be the .csv file that I would list in the .jar code. In this scenario, the "Search Column" would be the "Name" column in Spreadsheet B and the "ID column" would be the "Name" column in the project we created from Spreadsheet A. Am I understanding this correctly? In that example would I enter the following to start the server: java -jar reconcile-csv-0.1.1.jar <Spreadsheet_B.csv> I welcome your insights and corrections . . .again, my apologies if any of this seems obvious. I'm relatively technical, but am still coming up to speed on command prompt tasks. Many thanks! |
|
Thanks for the long description of what you're trying to do. To run, java needs to know where exactly the .jar file is you are trying to run. So you can either run ``java -jar reconcile-csv-0.1.1.jar` if the jar is in the same folder or
Don't put the pointy brackets in - run e.g.
reconcile-csv just works with the spreadsheet you are giving and exposes a reconciliation API towards Refine - the reconciliation itself will happen in Refine. This means: The CSV you give to it is your database export - the "Search Column" would be the name and the "ID column" would be the column with the database ID. Hope that helps. |
|
Hello Mr. Bauer, @meriteadrupal,Thanks for the long description of what you're trying to do.To run, java needs to know where exactly the .jar file is you are trying to run. So you can either run`java -jar reconcile-csv-0.1.1.jar if the jar is in the same folder or java -jar /path/to/reconcile-csv.jar if the jar is in a different folder. The same for the CSV file.Don't put the pointy brackets in - run e.g.java -jar reconcile-csv.jar spreadsheetB.csv "name" "Contact ID"reconcile-csv just works with the spreadsheet you are giving and exposes a reconciliation API towards Refine - the reconciliation itself will happen in Refine.This means: The CSV you give to it is your database export - the "Search Column" would be the name and the "ID column" would be the column with the database ID.Hope that helps.— |
|
Hi there, You will generally open one file (the one with the unique-IDs) in reconcile-csv and the other (the one where you want to introduce the IDs in refine. Hope that helps. |
|
Hello Michael, I got the .jar file running, thanks to your clarifications. Thank you so much. So we've made progress. However, I am getting a new error that I hope you can help me resolve: Krista-Bradfords-MacBook-Pro-2:openrefine kristabradford$ java -jar reconcile-csv-0.1.1.jar inventorslist.csv “name” “Contact ID” In troubleshooting, I noticed instruction that I needed to add the reconciliation service and thought that might have something to do with the issue above. So I went to Start Reconciling->Add Standard Service. I entered "http://localhost:8000/reconcile" without the quotes. It returned the error: Error contacting recon service: timeout : timeout - http://localhost:8000/reconcile I look forward to your thoughts. Thank you! |
|
Hi there,
This looks wierd - are the dobule quotes the same as you posted? If yes - |
|
OK. The following produces no error. So I think we're making progress . . . java -jar reconcile-csv-0.1.1.jar inventorslist.csv ‘name’ ‘Contact ID’ Just the cursor is returned, which i presume means it is working. Here, I'm unclear on what to do next. Your instructions say: Then add http://localhost:8000/reconcile as a reconciliation service to refine. You can add more columns through the reconcile-interface in Refine. Then use to get the ID from the match. What I did: I went to the Name column I want to reconcile in OpenRefine. In the dropdown I selected Start Reconciling->Add Standard Service. I entered "http://localhost:8000/reconcile" without the quotes. It doesn't seem to save or show up in list of services. It returned the error: Error contacting recon service: timeout : timeout - http://localhost:8000/reconcile Am I doing something wrong? |
The cursor shouldn't be returned from the call - The program should stay Data Diva | skype: mihi_tr | @mihi_tr |
|
I tried again and I misspoke. The cursor with the $ was not returned . . . just the rectangular square part of the cursor. So I presume it loaded. I still get the time-out error. FWIW. |
|
So i have managed to get Reconcile-csv to run in java. (Yes!) I went into OpenRefine. Selected "Start Reconciling" on the column "linkedin". ( I am using the URL as a unique identifier.) I went to Add Standard Service and entered http://localhost:8000/reconcile. It took me to this screen. It showed as "working" but I never got beyond that point.
In checking Terminal, it showed an exception error: ExecutionException: java.lang.NullPointerException (See text below.) Also, as I reviewed instructions --- there seems to be two sets of instructions -- I don't understand the difference between the two. One set of instructions involves the reconcile-csv-0.1.0-SNAPSHOT-standalone.jar file and the other features the reconcile-csv-0.1.1.jar. If it isn't an imposition could you fill me in on the difference? (I presume the first "stands alone" -- it isn't entirely obvious to me what that means and I don't see that detailed in the documentation.) Also, i've seen instructions to point to http://localhost:8000/reconcile and to just http://localhost:8000/ I've tried both -- http://localhost:8000/reconcile is the one that gets me to the "working" screen. (I hope you find my fumblings a wee bit entertaining . . .) Krista-Bradfords-MacBook-Pro-2:openrefine kristabradford$ java -jar reconcile-csv-0.1.1.jar LinkedInCheck-standardizedURLs.csv ‘LinkedInStandardized’ ‘linkedin’Starting CSV Reconciliation service My apologies in advance for the multiple posts. My hope is that there will be information in our discussion that will help other users. Regards, |
|
Krista, First the two different names are simply two different versions of reconcile-csv. Nevertheless, It's hard to say what the error is you are encountering. There seems to be something happening within the data that makes it barf. Could you share your .csv file? Did you make sure there are no empty cells? |
|
I'm very much in the same position as the original poster - I have very little experience of doing anything in command prompt so I'm probably doing something very obviously wrong, but I have absolutely no clue what. I've download the file and stored it in FolderX. The Data I want to use as my reconciliation file i.e. the one with the IDs is in Folder Y. I've tried putting the below into the command prompt but it keeps on saying "Unable to access jarfile P:\FolderX\reconcile-csv-0.1.2.jar java -jar "P:\FolderX\reconcile-csv-0.1.2.jar" P\FolderY\HouseOfLords-Donations-Reconciliation.csv "Name" "PersonID" Am I missing something or is my computer being buggy? If I can get this going ASAP it'll save me a load of time with what I'm trying to do, so any swift assistance on this would be greatly appreciated. |
|
Interesting issue, toe command line seems ok - if your path is correct. Can you dir P:\FolderX\reconcile-csv-0.1.2.jar . Also I do think the double quotes should not be needed... |
|
Think I'm getting somewhere. It now seems to be having problems finding the file I want to reconcile from. You might have to spell things out very simply for me if I'm doing something wrong because I have no idea how this language works. Thanks for your assistance C:\Users\Steve>java -jar "P:_Shared files exc DSP\PROJECTS\Lobbying\Data\reconc |
|
I could be your folder names with a ton of spaces in them - not sure it handles those well. Could you move your files to the same folder? Or type cd "THEFOLDERWITHYOURFILE" and just run: |
|
Morning Michael, Sorry for the very late reply. In the end I had to do this the long hard way, but I’ll try your solution the next time I need to reconcile some data. Thanks for your time From: Michael Bauer [mailto:[email protected]] I could be your folder names with a ton of spaces in them - not sure it handles those well. Could you move your files to the same folder? Or type cd "THEFOLDERWITHYOURFILE" and just run: — |
|
I had similar issues and finally it was a problem of a malformed csv. After that, I could use it as a openrefine reconciliation service with reconcile-csv like this: C:\currentpath> java -Xmx1g -jar C:\path-to-executable\reconcile-csv-0.1.2.jar C:\path-to-csv\myfile.csv "name" "id" |
I am a newbie i data reconciliation with open refine and I am still in learner stage. I am using windows XP SP3 and I have java run time environemnt installed in my machine. My question is where do I run the command:-
java -jar reconcile-csv-1.0.1-SNAPSHOT-standalone.jar <column with id's>
I have tried running it in windows command prompt and I used different prmutationsa dn combinations to see if any runs. I have also tried double clicking and running the reconcile-csv.jar file. It threw a hava virtual machine error and eventually didn't proceed. I want to know how to make it run?
The text was updated successfully, but these errors were encountered: