# Best strategy on wikidata upload

**URL:** <https://forum.openrefine.org/t/best-strategy-on-wikidata-upload/285>\
**Category:** Support and Helpdesk\
**Tags:** wikidata\
**Created:** [December 25, 2022, 7:19pm UTC](https://forum.openrefine.org/t/best-strategy-on-wikidata-upload/285 "2022-12-25T19:19:52Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Robertgarrigos](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.openrefine.org/robertgarrigos/32/41_2.png) [@Robertgarrigos](https://forum.openrefine.org/u/Robertgarrigos)\
**Post date:** [December 25, 2022, 7:19pm UTC](https://forum.openrefine.org/t/best-strategy-on-wikidata-upload/285/1 "2022-12-25T19:19:52Z")

</div>

I wonder what strategies you use when uploading to wikidata in order to not forget any edit. Then problem I’m having is that after some edit uploads I don’t know what has been uploaded and what not. I’m trying to use the flag and the star to mark rows, but I always end up with mixed data (uploaded and not uploaded) and don’t know which one it is what. What do you do?

---

<div class="post-metadata">

**Author:** ![ostephens](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.openrefine.org/ostephens/32/8_2.png) [@ostephens](https://forum.openrefine.org/u/ostephens)\
**Post date:** [January 3, 2023, 9:33am UTC](https://forum.openrefine.org/t/best-strategy-on-wikidata-upload/285/2 "2023-01-03T09:33:34Z")

</div>

Another option, in addition to using flags and stars, is to add a new column where you simply record the status of the row - this can be more explicit that just the flag/star system and make it clearer where you have got to with a particular row.

The other approach I’ve taken is to come from the other side and setup a wikidata query (e.g. using [https://query.wikidata.org/](https://query.wikidata.org/)) with all the relevant data in it so I can see what’s changed as I upload data - so checking that I see the number of items I expect, seeing if all the relevant properties have been added/updated etc. etc. This approach is coming to the problem from the other side - that is checking the state of Wikidata rather than trying to track everything in OpenRefine

---

<div class="post-metadata">

**Author:** ![Robertgarrigos](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.openrefine.org/robertgarrigos/32/41_2.png) [@Robertgarrigos](https://forum.openrefine.org/u/Robertgarrigos)\
**Post date:** [January 3, 2023, 10:45am UTC](https://forum.openrefine.org/t/best-strategy-on-wikidata-upload/285/3 "2023-01-03T10:45:27Z")

</div>

Thanks, @ostephens, I’m starting to feel more confident with flags and stars, but definitely adding a new column to record a status of the row seems a good option worth trying.

I already use wikidata queries to check general status of the uploaded data, but not with such a detail I might need from time to time. I’ll try it.