OpenRefine 3.0-beta was released

170 views
Skip to first unread message

qi

unread,
May 27, 2018, 10:21:37 AM5/27/18
to OpenRefine
Hi All,
OpenRefine 3.0-beta was released. Thank everyone did the contribution to coding, bug fixing and testing. If you find out any issue, please create issue and mention it is from V3.0 beta.

New features:
- Wikidata extension
- Data package metadata
- Tag system
- Google drive API 
- OpenRefine Database Import Extension 
- Add coalesce function 
- Implement "Facet by null" and "Facet by empty string" and add to customized facets menu 
- Feature Request: Export SqlDump 
- migrate from JRDF to JENA library
- Added option to toggle show/hide null values in cells in data-table 
- unify the internal date type
- Update OpenRefine logo 
- Set http req headers 
- add find function
- Some bug fixes

See the full list of changes

Cheers!
Jacky

Thad Guidry

unread,
May 27, 2018, 12:09:43 PM5/27/18
to openr...@googlegroups.com
Awesome ! Thanks Jacky !

Thad

Antonin Delpeuch (lists)

unread,
May 27, 2018, 12:14:48 PM5/27/18
to openr...@googlegroups.com
Great! Should we update the website too?

Antonin

On 27/05/2018 18:09, Thad Guidry wrote:
> Awesome ! Thanks Jacky !
>
> Thad
>
> --
> You received this message because you are subscribed to the Google
> Groups "OpenRefine" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to openrefine+...@googlegroups.com
> <mailto:openrefine+...@googlegroups.com>.
> For more options, visit https://groups.google.com/d/optout.

Thad Guidry

unread,
May 27, 2018, 1:09:16 PM5/27/18
to openr...@googlegroups.com
Martin will be doing the new website rollout, yes.

Also, I just noticed when I click on the About page, the dependencies might need updating on the app ? or no ?

And found 1 bug so far with the new Quoting option for CSV/TSV importer.

Thad

Yael Netzer

unread,
May 30, 2018, 8:04:34 AM5/30/18
to openr...@googlegroups.com
Hi, excited to try the new version, but  on MacOS High Sierra 10.13.14 I can run the 3.0 but without my previous projects  -->

If I run it with an empty OpenRefine directory in /library/application support/OpenRefine -> no problem, 
otherwise, it gets 'stuck' in the 'loading butterfly etc.' on 127.0.0.1

My OpenRefine directory works well with both 2.7 or 2.8 (the truth is that I sometimes choose to use 2.7 when some functionalities don't work)

Any ideas?
Thanks!
Yael

--
You received this message because you are subscribed to the Google Groups "OpenRefine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+...@googlegroups.com.

Qi Cui

unread,
May 30, 2018, 8:08:51 AM5/30/18
to openr...@googlegroups.com
Hi Netzer, Any error message from your console? can you paste the startup log from your console?

To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to a topic in the Google Groups "OpenRefine" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/openrefine/ol2g36KJNUk/unsubscribe.
To unsubscribe from this group and all its topics, send an email to openrefine+unsubscribe@googlegroups.com.

Yael Netzer

unread,
May 30, 2018, 8:38:50 AM5/30/18
to openr...@googlegroups.com
Sorry, no console when running openrefine -> where can I find the log?

To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to a topic in the Google Groups "OpenRefine" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/openrefine/ol2g36KJNUk/unsubscribe.
To unsubscribe from this group and all its topics, send an email to openrefine+...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "OpenRefine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+...@googlegroups.com.

Owen Stephens

unread,
May 30, 2018, 11:06:28 AM5/30/18
to OpenRefine
Are you able to use the Mac terminal/command line?

If you are confident with this, you can do the following:

Open a terminal
Change directory to
/path/to/OpenRefine.app/Contents/MacOS/


for example - if you installed in Applications, the command will be:

cd /Applications/OpenRefine.app/Contents/MacOS/

Run OpenRefine by using the command:

/JavaAppLauncher

This should start OpenRefine and in the terminal Window you should see the console/log

Owen

Owen Stephens

unread,
May 30, 2018, 11:07:20 AM5/30/18
to OpenRefine
Sorry that final command should have been

Run OpenRefine by using the command:

./JavaAppLauncher

Yael Netzer

unread,
May 30, 2018, 11:54:01 AM5/30/18
to openr...@googlegroups.com

Thanks for your assistance,

ere's my log:



MacBook-Pro-3:MacOS yaeln$ ./JavaAppLauncher 

18:51:18.258 [            refine_server] Starting Server bound to '127.0.0.1:3333' (0ms)

18:51:18.282 [            refine_server] Initializing context: '/' from '/Applications/OpenRefine3.app/Contents/Resource/webapp' (24ms)

18:51:19.158 [                   refine] Starting OpenRefine 3.0-beta [TRUNK]... (876ms)

18:51:19.158 [                   refine] initializing FileProjectManager with dir (0ms)

18:51:19.158 [                   refine] /Users/yaeln/Library/Application Support/OpenRefine (0ms)

18:51:21.055 [       database-extension] Initializing OpenRefine Database... (1897ms)

18:51:21.059 [       database-extension] Database Extension Mount point /extension/database/ [*] (4ms)

18:51:21.059 [       database-extension] Registering Database Extension Commands...... (0ms)

18:51:21.075 [       database-extension] Database Extension Command Registeration done!! (16ms)

18:51:21.075 [       database-extension] Database Operations Registered successfully... (0ms)

18:51:21.075 [       database-extension] Database Functions Registered successfully... (0ms)

Exception in thread "main" java.lang.LinkageError: loader constraint violation: loader (instance of edu/mit/simile/butterfly/ButterflyClassLoader) previously initiated loading for a different type with name "org/slf4j/Logger"

at java.lang.ClassLoader.defineClass1(Native Method)

at java.lang.ClassLoader.defineClass(ClassLoader.java:760)

at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)

at java.net.URLClassLoader.defineClass(URLClassLoader.java:467)

at java.net.URLClassLoader.access$100(URLClassLoader.java:73)

at java.net.URLClassLoader$1.run(URLClassLoader.java:368)

at java.net.URLClassLoader$1.run(URLClassLoader.java:362)

at java.security.AccessController.doPrivileged(Native Method)

at java.net.URLClassLoader.findClass(URLClassLoader.java:361)

at edu.mit.simile.butterfly.ButterflyClassLoader.loadClass(ButterflyClassLoader.java:51)

at java.lang.ClassLoader.loadClass(ClassLoader.java:357)

at com.google.refine.extension.database.DatabaseModuleImpl.readModuleProperty(DatabaseModuleImpl.java:93)

at com.google.refine.extension.database.DatabaseModuleImpl.init(DatabaseModuleImpl.java:68)

at edu.mit.simile.butterfly.Butterfly.initializeModule(Butterfly.java:476)

at edu.mit.simile.butterfly.Butterfly.configure(Butterfly.java:451)

at edu.mit.simile.butterfly.Butterfly.init(Butterfly.java:308)

at org.mortbay.jetty.servlet.ServletHolder.initServlet(ServletHolder.java:440)

at org.mortbay.jetty.servlet.ServletHolder.doStart(ServletHolder.java:263)

at com.google.refine.RefineServer.configure(Refine.java:296)

at com.google.refine.RefineServer.init(Refine.java:208)

at com.google.refine.Refine.init(Refine.java:114)

at com.google.refine.Refine.main(Refine.java:108)



Patrick Maroney

unread,
May 30, 2018, 5:55:40 PM5/30/18
to OpenRefine
Thanks to everyone involved in making this happen.   It is great to see the revitalization of this community! 

Questions:

(1) Are any specific V3.0 RDF Extensions available and if so where? 

(2) Would/should our legacy RDF extensions work?

I wanted to start with a squeaky clean install for testing...

Stuart Kenny

unread,
May 31, 2018, 7:36:00 AM5/31/18
to OpenRefine
Hi, could you try this? 


I'd be interested to hear if it works for you.

Thanks,
Stuart.

Patrick Maroney

unread,
May 31, 2018, 11:08:42 AM5/31/18
to OpenRefine

Many thanks Stuart.  The extension loaded and is working.  

It'll be a while before I can port over legacy RDF 'stuff' and test more substantively.  However, this was the most seamless RDF Extension install I've experienced.  Off to a good start.  Presume you want to track issues in GitHub?

Stuart Kenny

unread,
Jun 1, 2018, 1:47:04 PM6/1/18
to OpenRefine
Yes, GitHub makes sense. Thanks. 

qi

unread,
Jun 2, 2018, 9:52:25 PM6/2/18
to OpenRefine
could you please create an issue for this? also including the detail of OS version, Java version.

Seems related to the database extension.

Yael Netzer

unread,
Jun 3, 2018, 1:17:45 AM6/3/18
to openr...@googlegroups.com
Done, thanks.
Reply all
Reply to author
Forward
0 new messages