Data-Management

[Ufuk Sümer]

Hello, I have a question about Openrefine, I have Databank in Excel/Word. What I want to import  these Datas in OpenRefine and that is possible but I want to export these Datas from OpenRefine to my Wikidatabase. Is that possible?

[Antoine Beaubien]

Hi Ufuk,

   Yes, OpenRefine can easilly import CSV, or even Excel files.

   And, may I say, OpenRefine is probably the best tool to push data to a wikibase instance.

You will have to create a manifest for your wikibase. You can find examples here: https://github.com/OpenRefine/wikibase-manifests

Regards,

   Antoine

[Ufuk Sümer]

Hi Antoine and thanks for your answer. 

Best regards 

Ufuk 

Von meinem Huawei-Telefon gesendet

-------- Ursprüngliche Nachricht --------
Von: Antoine Beaubien <ant...@beaubien.qc.ca>
Datum: Mi., 13. Juli 2022, 22:40
An: OpenRefine <openr...@googlegroups.com>
Betreff: [OpenRefine] Re: Data-Management

--
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/VOQDgRk1d7I/unsubscribe.
To unsubscribe from this group and all its topics, send an email to openrefine+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/openrefine/f164b4d2-f646-4bba-aa6c-9b514db31f94n%40googlegroups.com.

[Ufuk Sümer]

hi Antoine again, i tried to understand, how i should write a manifesto to my wikibase but i couldnt.

Could you explain me please, how i should prepare it. I use Visual Studio Code, and there I can write json codes but i didnt get or find it, where i use my wikibase-URL address or why are we writing the codes, that we wrote for manifest?

[Antonin Delpeuch (lists)]

Some useful links:

https://docs.openrefine.org/manual/wikibase/configuration#for-wikibase-administrators

https://openrefine-wikibase.readthedocs.io/en/latest/

And Lozana wrote documentation on top of that, but I cannot find it anymore. I guess it is a good case for integrating it into the official documentation.

Antonin

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.
To view this discussion on the web visit https://groups.google.com/d/msgid/openrefine/CAN5h1XLMm3D_4Eco8V61HBgYZK3zh6GxSSF%3DcFGR_eJAktFJzA%40mail.gmail.com.

[Ufuk Sümer]

Hi Antoine  again, I created my manifest.json-Text but the problem is I dont know how to find the properties of my wikibase?  I just wrote a random number, thats why I get an error "invalid manifest" 

My Text :

{
 "version": "1.0",
"mediawiki": {
"name": "name",
"root": "https://name/entity/wiki/",
 "main_page": "https://name/entity/wiki/Main_Page",
  "api": "https://name/entity/w/api.php"},

"wikibase":{
     "site_iri": "https://name/entity/",
      "maxlag" : 5,
      "properties": {
      "instance_of": "P50",
      "subclass_of": "P279"
    },
}}
Do you know how I can find the properties (instance_of and subclass_of)? 

best regards 

ufuk

[Antonin Delpeuch (lists)]

Hi Ufuk,

You should be able to list all the properties in your Wikibase instance using "SpecialPage:AllPages".

For instance: https://edtf.wikibase.wiki/wiki/Special:AllPages?from=&to=&namespace=122

OpenRefine is designed to work with Wikibase instances which use properties which play the same role as "instance of"/"subclass of" in Wikidata. If your Wikibase instance does not use such properties you could create some, or explain us why you are not using such a system and how OpenRefine should support it.

Best,

Antonin

To view this discussion on the web visit https://groups.google.com/d/msgid/openrefine/897eca33-10fd-4e25-8dc8-0d418b0ef02bn%40googlegroups.com.

[Ufuk Sümer]

Thank you Antoine for your answer, that helps a lot, I'm an Intern at a company and try to find a way to send the datas from excel to our database (wikibase). 

I entered random numbers while I chose the namespace as property but it doesnt work. That means, that our wikibase doesnt support instance_of/subclass_of?

To view this discussion on the web visit https://groups.google.com/d/msgid/openrefine/2227061b-c849-b38f-44ce-fd4122440815%40antonin.delpeuch.eu.

[Antoine Beaubien]

I think you should talk to the people that setup your wikibase. It would be most suprising that your didn't have at least the property « instance of ». It's like the type property. Sub-class serves as a hierarchy to the type.

By the way, the most useful answers in this thread have been given to you by AntoNIN, whereas I'm AntoINE. ;-) Pretty close though. ;-)

Good Luck,

   Antoine

[Ufuk Sümer]

Hi Antoine, 

I'm sorry for the name:)  I learned that we use graph database, that's why we dont use properties but the query take place via sets and graph-mining.

However we can introduce the instance_of and subclass_of as a normal properties. But I dont now how?   That's all what I learned. Im trying to find it out.

Thanx for your help Antoine and Antonin:)

Ufuk

Antoine Beaubien <ant...@beaubien.qc.ca>, 22 Tem 2022 Cum, 07:43 tarihinde şunu yazdı:

To view this discussion on the web visit https://groups.google.com/d/msgid/openrefine/c27d9dff-5fdc-4828-8322-ae44a264889fn%40googlegroups.com.

[Dennis Diefenbach]

Hi, we imported instance of and subclass of using WikibaseSync:

https://github.com/the-qa-company/WikibaseSync

The local properties look like:

https://linkedopendata.eu/wiki/Property:P35

I’m not sure how it is supposed to be without these properties. Antoine can for sure help.

Also I guess you need them only if you need the reconciliation service I guess. And this you need to set up separately.

Salut

D063520

To view this discussion on the web visit https://groups.google.com/d/msgid/openrefine/897eca33-10fd-4e25-8dc8-0d418b0ef02bn%40googlegroups.com.

[Ufuk Sümer]

Thank you Dennis, Im try it on monday.

best regards

'Dennis Diefenbach' via OpenRefine <openr...@googlegroups.com>, 22 Tem 2022 Cum, 21:42 tarihinde şunu yazdı:

To view this discussion on the web visit https://groups.google.com/d/msgid/openrefine/AC9AD981-3A09-4884-9E1D-40E386522A8A%40googlemail.com.