Re: OpenRefine

If you are using a VIAF data dump, you can try stripping out just the
foaf:name triples (that cuts it down to about 54 Million triples) or
foaf:name and rdf:type triples (that is about 124 Million).  I have not
tried reloading that data as I was side-tracked by another task, but I
guess it might help.  Since all you really want is presumably the URI
anyways, this would help cut down on the bloat SKOS triples.  If you want
to then get more data about the URI, you can just add columns based on
current column (i.e. the column that has the URI in it).

What would be best is if we could just fix the syntax in LOD Refine :)

Thanks,

Jeff Mixter


On Mon, Oct 28, 2013 at 4:45 PM, Adrian Stevenson <
adrian.stevenson@manchester.ac.uk> wrote:

> Yep I've been trying to use the open refine reconciliation against SPARQL
> end points recently without success despite trying all sorts of ways in.
> Got it working fine with a viaf API reconcil service using the same data so
> had assumed the SPARQL wasn't working.
>
> Adrian
>
> > On 28 Oct 2013, at 19:01, "Hugh Glaser" <hg@ecs.soton.ac.uk> wrote:
> >
> > Unfortunately I’ve not been a regular user, so it is probably my
> stupidity.
> > Basically, I go through the Reconcile process using the Freebase
> Reconcile service, but it doesn’t find anything to reconcile, even though I
> have fixed it so that there is an entry that has exactly the same text as
> the Freebase entry title.
> > It just shows as if there are no positive results.
> > I try clicking on the search for match after that, but it never comes
> back, which makes me wonder.
> >
> >> On 28 Oct 2013, at 18:53, John Erickson <olyerickson@gmail.com> wrote:
> >>
> >> Hugh, I wonder if you could be more specific regarding the troubles
> >> you had with OpenRefine?
> >>
> >> One of our students also had trouble, and I'm wondering if it might be
> >> the same problem.
> >>
> >> Like you, reconciliation with Refine has worked for me in the past but
> >> I haven't tried the same process using OpenRefine...
> >>
> >>> On Mon, Oct 28, 2013 at 2:41 PM, Hugh Glaser <hg@ecs.soton.ac.uk>
> wrote:
> >>> Hi.
> >>> I’m not sure where to ask, so I’ll try my friends here.
> >>> I was having a go at OpenRefine yesterday, and I can’t get it to
> reconcile, try as I might - I have even watched the videos again.
> >>> I’m doing what I remember, but it is a while ago.
> >>> Are there others currently using it successfully?
> >>> Or is it possibly a Mavericks (OSX) upgrade thing, which I did
> recently.
> >>> Cheers
> >>> --
> >>> Hugh
> >>
> >>
> >>
> >> --
> >> John S. Erickson, Ph.D.
> >> Director, Web Science Operations
> >> Tetherless World Constellation (RPI)
> >> <http://tw.rpi.edu> <olyerickson@gmail.com>
> >> Twitter & Skype: olyerickson
> >
> > --
> > Hugh
> > 023 8061 5652
> >
> >
>
>


-- 
Jeff Mixter
jeffmixter@gmail.com
440-773-9079