# Support and Helpdesk **URL:** https://forum.openrefine.org/c/support/12.md?page=2 [Latest](https://forum.openrefine.org/latest.md) · [Categories](https://forum.openrefine.org/categories.md) · [Tags](https://forum.openrefine.org/tags.md) **Page:** 3 --- ## [Apply operation history from json file not working](https://forum.openrefine.org/t/apply-operation-history-from-json-file-not-working/1582)
**Author:** [@Cher](https://forum.openrefine.org/u/Cher)\ **Replies:** 25\ **Last updated:** [October 23, 2025, 2:56pm UTC](https://forum.openrefine.org/t/apply-operation-history-from-json-file-not-working/1582 "2025-10-23T14:56:19Z")
Hello, I am a very new OpenRefine user, thanks for your patience. I'm trying to clean multiple sets of data. I'm trying to apply my saved (long and time consuming) cleaning to another dataset. This worked fine yesterday… --- ## [Move Column to End via applied JSON](https://forum.openrefine.org/t/move-column-to-end-via-applied-json/2605)
**Author:** [@SpencerLamm](https://forum.openrefine.org/u/SpencerLamm)\ **Replies:** 1\ **Last updated:** [October 16, 2025, 12:18pm UTC](https://forum.openrefine.org/t/move-column-to-end-via-applied-json/2605 "2025-10-16T12:18:37Z")
Hi- I’m new to OpenRefine and loving it. My context is that I will be using OpenRefine to process very similar, but not identical, metadata from different digital repositories. My goal is to automate as many of the step… --- ## [Reuploading files after deletion](https://forum.openrefine.org/t/reuploading-files-after-deletion/2593)
**Author:** [@datalifecycle](https://forum.openrefine.org/u/datalifecycle)\ **Replies:** 2\ **Last updated:** [October 9, 2025, 7:22am UTC](https://forum.openrefine.org/t/reuploading-files-after-deletion/2593 "2025-10-09T07:22:37Z")
Hello there, im new to this community. Im an intern at Bibliothek und Archiv Aargau. Recently I uploaded some files to wikimedia with open refine. The files got deleted because of some issues with the license tag. Now I … --- ## [Unable to reconcile or edit schema](https://forum.openrefine.org/t/unable-to-reconcile-or-edit-schema/2596)
**Author:** [@Rob\_Fernandez](https://forum.openrefine.org/u/Rob_Fernandez)\ **Replies:** 1\ **Last updated:** [October 8, 2025, 7:22pm UTC](https://forum.openrefine.org/t/unable-to-reconcile-or-edit-schema/2596 "2025-10-08T19:22:58Z")
I’ve just upgraded to 3.9.5 and I’m unable to reconcile or edit the schema. I’ve tried two different services and nothing happens when I try to reconcile with Wikidata, but I am able to reconcile with VIAF. I’m unable… --- ## [Upload structured data on Wikimedia Commons via PAWS](https://forum.openrefine.org/t/upload-structured-data-on-wikimedia-commons-via-paws/2568)
**Author:** [@Mtv84](https://forum.openrefine.org/u/Mtv84)\ **Replies:** 8\ **Last updated:** [October 7, 2025, 7:25am UTC](https://forum.openrefine.org/t/upload-structured-data-on-wikimedia-commons-via-paws/2568 "2025-10-07T07:25:59Z")
Hello everyone, For a very long time now (since the beginning of summer probably), I’ve been trying to upload edits on Wikimedia Commons. My goal is to add structured data to images I uploaded thanks to Pattypan. Every… --- ## [Cannot undo 30k tasks](https://forum.openrefine.org/t/cannot-undo-30k-tasks/2598)
**Author:** [@robin\_agri](https://forum.openrefine.org/u/robin_agri)\ **Replies:** 0\ **Last updated:** [October 6, 2025, 1:32pm UTC](https://forum.openrefine.org/t/cannot-undo-30k-tasks/2598 "2025-10-06T13:32:50Z")
I have a large database of 23k entries that I was working on. After an hour of work (~25k actions later), I realized a mistake and wanted to go back to the state 1h ago. I was at 44k tasks then and am at 70k tasks now. I… --- ## [Issue with OpenRefine Wikimedia Commons extension](https://forum.openrefine.org/t/issue-with-openrefine-wikimedia-commons-extension/2531)
**Author:** [@Ambrosia10](https://forum.openrefine.org/u/Ambrosia10)\ **Replies:** 8\ **Last updated:** [October 2, 2025, 10:48am UTC](https://forum.openrefine.org/t/issue-with-openrefine-wikimedia-commons-extension/2531 "2025-10-02T10:48:33Z")
When I’m attempting to use the Wikimedia Commons OpenRefine extension to create a project by adding a WikiCommons category, OpenRefine fails to execute this request. I’m getting a “memory usage” message and the project … --- ## [Use Sunil's LLM extension to describe images from URL](https://forum.openrefine.org/t/use-sunils-llm-extension-to-describe-images-from-url/2583)
**Author:** [@jfaurel](https://forum.openrefine.org/u/jfaurel)\ **Replies:** 5\ **Last updated:** [September 30, 2025, 2:19pm UTC](https://forum.openrefine.org/t/use-sunils-llm-extension-to-describe-images-from-url/2583 "2025-09-30T14:19:43Z")
I didn’t want to revive @Michael\_Markert long thread on LLMs, which ended with @sunil\_natraj extension, so I’m starting a new topic here. @Rory mentioned last year the unfortunate Boston 311 dataset, which includes photo… --- ## [JSON: Parsing from label:value structure](https://forum.openrefine.org/t/json-parsing-from-label-value-structure/2567)
**Author:** [@mcyzyk](https://forum.openrefine.org/u/mcyzyk)\ **Replies:** 4\ **Last updated:** [September 23, 2025, 2:17am UTC](https://forum.openrefine.org/t/json-parsing-from-label-value-structure/2567 "2025-09-23T02:17:21Z")
All, I have this chunk of JSON: "metadata" : \[ { "label" : "Accession Number", "value" : "03547" }, { "label" : "File Name", "value" : "03547-2" }, { "label" : "Call number", "value" : "D657 L726t / 1-SIZE" } an… --- ## [Applying invalid JSON causes unrecoverable error](https://forum.openrefine.org/t/applying-invalid-json-causes-unrecoverable-error/2563)
**Author:** [@susannah-slv](https://forum.openrefine.org/u/susannah-slv)\ **Replies:** 2\ **Last updated:** [September 21, 2025, 9:41pm UTC](https://forum.openrefine.org/t/applying-invalid-json-causes-unrecoverable-error/2563 "2025-09-21T21:41:31Z")
Hi everyone, I may have found a bug, I thought I’d share in case it helps anyone else. We initially thought it was an issue with our installation so spent some time debugging. Behaviour When applying a JSON process to… --- ## [Running reconciliation service on many columns](https://forum.openrefine.org/t/running-reconciliation-service-on-many-columns/2541)
**Author:** [@js1980](https://forum.openrefine.org/u/js1980)\ **Replies:** 3\ **Last updated:** [September 17, 2025, 1:14pm UTC](https://forum.openrefine.org/t/running-reconciliation-service-on-many-columns/2541 "2025-09-17T13:14:39Z")
Hello, I need to run reconcile-csv across a bazillion columns and would rather not do it one column at a time. Do you know of a way run this across all columns at once? Maybe you have a script you can share that interact… --- ## [Normalizing astronomical photometric data](https://forum.openrefine.org/t/normalizing-astronomical-photometric-data/2559)
**Author:** [@AstroToby](https://forum.openrefine.org/u/AstroToby)\ **Replies:** 1\ **Last updated:** [September 16, 2025, 10:01am UTC](https://forum.openrefine.org/t/normalizing-astronomical-photometric-data/2559 "2025-09-16T10:01:38Z")
Hello – I am working with an ASCII file that contains photometric data of a transiting exoplanet. The x axis is time, the y axis is magnitude. The y data needs to be normalized by using part of the data. Which part? Its … --- ## [I am receiving a error:Unauthorized message when trying to test and connect to a SQLite database file](https://forum.openrefine.org/t/i-am-receiving-a-error-unauthorized-message-when-trying-to-test-and-connect-to-a-sqlite-database-file/1943)
**Author:** [@sdw50-maker](https://forum.openrefine.org/u/sdw50-maker)\ **Replies:** 11\ **Last updated:** [September 4, 2025, 7:44pm UTC](https://forum.openrefine.org/t/i-am-receiving-a-error-unauthorized-message-when-trying-to-test-and-connect-to-a-sqlite-database-file/1943 "2025-09-04T19:44:53Z")
I am attempting to test and connect to a SQLite database using OpenRefine's latest version (originally I was using version 3.8.1) on a windows OS. I received an "error:Unauthorized" message when trying to test or connect… --- ## [Commons upload by URL: Unexpected character ('\<' (code 60)): expected a valid value](https://forum.openrefine.org/t/commons-upload-by-url-unexpected-character-code-60-expected-a-valid-value/2494)
**Author:** [@DaxServer](https://forum.openrefine.org/u/DaxServer)\ **Replies:** 3\ **Last updated:** [September 3, 2025, 7:38am UTC](https://forum.openrefine.org/t/commons-upload-by-url-unexpected-character-code-60-expected-a-valid-value/2494 "2025-09-03T07:38:34Z")
Hi. These errors became too frequent in last few days. Here’s a stacktrace for the error: com.fasterxml.jackson.core.JsonParseException: Unexpected character ('\<' (code 60)): expected a valid value (JSON String, Number,… --- ## [Help with matching 72,000 institutions to ROR IDs](https://forum.openrefine.org/t/help-with-matching-72-000-institutions-to-ror-ids/2508)
**Author:** [@kassandrarane](https://forum.openrefine.org/u/kassandrarane)\ **Replies:** 1\ **Last updated:** [August 30, 2025, 8:52pm UTC](https://forum.openrefine.org/t/help-with-matching-72-000-institutions-to-ror-ids/2508 "2025-08-30T20:52:21Z")
Hello! I found OpenRefine while looking for the best way to clean up our institutional data so we can align it with the Research Organization Registry (ROR). I see that OpenRefine has a reconciliation feature, and I’ve … --- ## [Get Redirected URL](https://forum.openrefine.org/t/get-redirected-url/2509)
**Author:** [@mcyzyk](https://forum.openrefine.org/u/mcyzyk)\ **Replies:** 5\ **Last updated:** [August 28, 2025, 7:09pm UTC](https://forum.openrefine.org/t/get-redirected-url/2509 "2025-08-28T19:09:53Z")
I have a bunch of URLs and have discovered they are all Redirects. I need to get the final, target, redirected URL. Looking at this: Looks like the solution here is to “Add column based on” original URL. Set the la… --- ## [Row inconsistency in OpenRefine from Excel/CSV/TSV for a file](https://forum.openrefine.org/t/row-inconsistency-in-openrefine-from-excel-csv-tsv-for-a-file/2513)
**Author:** [@psm](https://forum.openrefine.org/u/psm)\ **Replies:** 2\ **Last updated:** [August 28, 2025, 2:58pm UTC](https://forum.openrefine.org/t/row-inconsistency-in-openrefine-from-excel-csv-tsv-for-a-file/2513 "2025-08-28T14:58:15Z")
Dear all, I am facing an issue while importing a dataset into OpenRefine. The file is available here: Google Spreadsheet Link This dataset is associated with the following journal paper: https://doi.org/10.1177/01655… --- ## [Collapsing records into rows](https://forum.openrefine.org/t/collapsing-records-into-rows/2491)
**Author:** [@natalie.901](https://forum.openrefine.org/u/natalie.901)\ **Replies:** 2\ **Last updated:** [August 20, 2025, 9:10pm UTC](https://forum.openrefine.org/t/collapsing-records-into-rows/2491 "2025-08-20T21:10:24Z")
Hello friends, I am working with a data set where each entry had multiple lines of data. However, when I ran my document through pdfsandwich and Tabula, it recognized each line of data as its own row. The Records functio… --- ## [\[OPENREFINE 3.2\] Error occurred during file formatting](https://forum.openrefine.org/t/openrefine-3-2-error-occurred-during-file-formatting/2462)
**Author:** [@hamdi\_ghribi](https://forum.openrefine.org/u/hamdi_ghribi)\ **Replies:** 3\ **Last updated:** [August 7, 2025, 7:24pm UTC](https://forum.openrefine.org/t/openrefine-3-2-error-occurred-during-file-formatting/2462 "2025-08-07T19:24:28Z")
I have a Spring Boot application that uses OpenRefine 3.2 for file formatting. While the formatting itself works correctly, I’m currently encountering an issue during the creation of an OpenRefine project. The following … --- ## [When I try and Undo Certain Actions, I get an Error](https://forum.openrefine.org/t/when-i-try-and-undo-certain-actions-i-get-an-error/2429)
**Author:** [@ellathompson](https://forum.openrefine.org/u/ellathompson)\ **Replies:** 3\ **Last updated:** [July 30, 2025, 4:50pm UTC](https://forum.openrefine.org/t/when-i-try-and-undo-certain-actions-i-get-an-error/2429 "2025-07-30T16:50:35Z")
Hello all! I am running into a difficult problem with OpenRefine that is seriously affecting my data. I have a project where I was trying to split multi-valued cells. It is a large project, and when I tried doing so he … --- ## [Issue Columnizing by Key/Value Columns with Data in other Columns](https://forum.openrefine.org/t/issue-columnizing-by-key-value-columns-with-data-in-other-columns/2421)
**Author:** [@ellathompson](https://forum.openrefine.org/u/ellathompson)\ **Replies:** 4\ **Last updated:** [July 17, 2025, 1:51pm UTC](https://forum.openrefine.org/t/issue-columnizing-by-key-value-columns-with-data-in-other-columns/2421 "2025-07-17T13:51:36Z")
Hello! I am working in version 3.9.3 and wishing for improved functionality with the "Columnizing by Key/Value Columns" option. I have a large and complex dataset, so I will simplify it for illustrative purposes. I am wo… --- ## [Error batch upload to Wikimedia Commons](https://forum.openrefine.org/t/error-batch-upload-to-wikimedia-commons/2331)
**Author:** [@Ingert2022](https://forum.openrefine.org/u/Ingert2022)\ **Replies:** 2\ **Last updated:** [July 17, 2025, 6:44am UTC](https://forum.openrefine.org/t/error-batch-upload-to-wikimedia-commons/2331 "2025-07-17T06:44:08Z")
I try to upload a batch of images in openrefine version 3.7.6., Some of the images are perfectly uploaded and others failed. I got this error: I tried again with only the images that failed the first time but everyti… --- ## [Seeking OpenRefine Expert for data Integration](https://forum.openrefine.org/t/seeking-openrefine-expert-for-data-integration/2405)
**Author:** [@Daniel\_Njiu](https://forum.openrefine.org/u/Daniel_Njiu)\ **Replies:** 2\ **Last updated:** [July 11, 2025, 8:09pm UTC](https://forum.openrefine.org/t/seeking-openrefine-expert-for-data-integration/2405 "2025-07-11T20:09:25Z")
Dear OpenRefine Community,I hope this message finds you well. My team is developing a data engine platform focused on aggregating diverse data sources to generate actionable insights. We are exploring how OpenRefine’s po… --- ## [Change default rows shown?](https://forum.openrefine.org/t/change-default-rows-shown/2390)
**Author:** [@mebrett](https://forum.openrefine.org/u/mebrett)\ **Replies:** 2\ **Last updated:** [July 3, 2025, 3:01pm UTC](https://forum.openrefine.org/t/change-default-rows-shown/2390 "2025-07-03T15:01:58Z")
This may be a very basic question. Is there a way to change the number of default rows/records show for a project? I almost always want it to be 25, and while it doesn't take that long to click it would be nice to just s… --- ## [Fail to load change file](https://forum.openrefine.org/t/fail-to-load-change-file/2365)
**Author:** [@Robertgarrigos](https://forum.openrefine.org/u/Robertgarrigos)\ **Replies:** 4\ **Last updated:** [June 16, 2025, 6:04am UTC](https://forum.openrefine.org/t/fail-to-load-change-file/2365 "2025-06-16T06:04:00Z")
Trying to debug a previously reported error, I wanted to undo some changes in a project and got this error: java.lang.RuntimeException: Failed to load change file /Users/robert/Library/Application Support/OpenRefine/177… --- ## [Problems with VIAF Reconciliation](https://forum.openrefine.org/t/problems-with-viaf-reconciliation/2063)
**Author:** [@Libusama](https://forum.openrefine.org/u/Libusama)\ **Replies:** 31\ **Last updated:** [June 13, 2025, 4:15pm UTC](https://forum.openrefine.org/t/problems-with-viaf-reconciliation/2063 "2025-06-13T16:15:45Z")
Hello everyone! I've experienced some issues with the VIAF reconciliation since the beginnig of 2025. VIAF has recently updated its website, but since then the OpenRefine VIAF Reconciliation service is not working at a… --- ## [Invalid json error for a previously used json file](https://forum.openrefine.org/t/invalid-json-error-for-a-previously-used-json-file/2363)
**Author:** [@Robertgarrigos](https://forum.openrefine.org/u/Robertgarrigos)\ **Replies:** 6\ **Last updated:** [June 12, 2025, 10:44am UTC](https://forum.openrefine.org/t/invalid-json-error-for-a-previously-used-json-file/2363 "2025-06-12T10:44:21Z")
I'm importing a history.json file, which gives an invalid json error. However, I've imported before this same file with no problem...with previous versions of openrefine. Has openrefine changed something on json files? T… --- ## [“Someone is claiming OpenRefine is offering online jobs – is this real?”](https://forum.openrefine.org/t/someone-is-claiming-openrefine-is-offering-online-jobs-is-this-real/2354)
**Author:** [@Lynette\_Chua](https://forum.openrefine.org/u/Lynette_Chua)\ **Replies:** 1\ **Last updated:** [June 3, 2025, 7:08pm UTC](https://forum.openrefine.org/t/someone-is-claiming-openrefine-is-offering-online-jobs-is-this-real/2354 "2025-06-03T19:08:05Z")
Hello, I was contacted by someone offering an online job where I would complete tasks like giving star ratings and earn commissions. They claimed that their company is OpenRefine and gave me this website: https://openre… --- ## [Importing 300MB SQLite fails (freezes, no errors)](https://forum.openrefine.org/t/importing-300mb-sqlite-fails-freezes-no-errors/2342)
**Author:** [@pReya](https://forum.openrefine.org/u/pReya)\ **Replies:** 2\ **Last updated:** [May 29, 2025, 10:12am UTC](https://forum.openrefine.org/t/importing-300mb-sqlite-fails-freezes-no-errors/2342 "2025-05-29T10:12:30Z")
Hello everyone, I'm trying to import a 300MB SQLite database into OpenRefine. The table has about 50 columns and 1 million rows – which is not small, but also not huge in my opinion. I'm using OpenRefine 3.9.3 on macOS… --- ## [Tips on performing cross() between values that aren’t perfectly equal?](https://forum.openrefine.org/t/tips-on-performing-cross-between-values-that-aren-t-perfectly-equal/2322)
**Author:** [@archilecteur](https://forum.openrefine.org/u/archilecteur)\ **Replies:** 7\ **Last updated:** [May 27, 2025, 7:29pm UTC](https://forum.openrefine.org/t/tips-on-performing-cross-between-values-that-aren-t-perfectly-equal/2322 "2025-05-27T19:29:13Z")
Hello OR Community, I have a list of published conference titles, on one hand, and a list of preliminary conference titles (as submitted to the conference organizers prior to selection), together with their abstracts, o… [Previous page](https://forum.openrefine.org/c/support/12.md?page=1) [Next page](https://forum.openrefine.org/c/support/12.md?page=3)