topic Re: Removing Error Records That Have Been Fixed Using Datareviewer in ArcGIS Data Reviewer Questions

Removing Error Records That Have Been Fixed Using Datareviewer

bobongubza — Thu, 21 Mar 2019 12:37:43 GMT

I am creating a website that shows errors of features and errors that have been resolved (fixed). I want to use datareviewer to find this errors. The errors are stored in a MS SQL database. The problem I have is that when errors are fixed, the data reviewer does not automatically remove errors that have been fixed within the database table.

I was hoping someone can inform me on whether there is a way to remove errors that have been fixed from the database when datareviewer runs, after the errors have been fixed. The only way I can do so is by removing all records in the database table before datareviewer, but I want to avoid that, because error records that I marked as exceptions will also be removed.

Re: Removing Error Records That Have Been Fixed Using Datareviewer

JayCary — Fri, 22 Mar 2019 21:43:21 GMT

You may want to consider a couple of approaches to this requirement.

If you would like to retain a history of errors that have already been fixed (to support management reporting, etc), then you may want to simply filter the list of errors presented to the user in your application. The JS ReviewerResults task supports the query of errors with an optional filter to exclude those errors you don’t want to display. This task also supports creation of a layer definition that can be applied to a map service to filter the error geometries displayed in the map.

If you do not need to retain the fixed errors, then you could “move” fixed errors to a different session (using Managing Data Reviewer Records sample) and then delete the session (using Delete Reviewer Session GP tool). The temporary session can be created using the Create Reviewer Session GP tool.

In either scenario, you may want to use the Managing Data Reviewer Records sample to move error exceptions to a separate Reviewer session to facilitate their management.

Re: Removing Error Records That Have Been Fixed Using Datareviewer

TuanVu_Huu — Sun, 16 Aug 2020 21:01:07 GMT

Dear Jay,

I am Tuan from Esri Vietnam.

I am help customer in vietnam to build table check and I using Regular Expression check. I have try to check value field name of map sheet as like this : 6636-V-DN

And I have try expression as :

([0-9][0-9][0-9][0-9]-\[A-Z]-\[A-Z][A-Z])

But it is not return the error.

Moreover, when I have set some expression for other field it is work but it not check for NULL or Space value?

Please help!

Many thank in advance!

Vu Tuan

Re: Removing Error Records That Have Been Fixed Using Datareviewer

KumarGaurav — Sun, 16 Aug 2020 23:22:08 GMT

Hi Vu Tuan,

Please use the following expression to find values in format : 6636-V-DN

([0-9][0-9][0-9][0-9]-[A-Z]-[A-Z][A-Z])

To find NULL values or an empty string values please add another Execute SQL Check check against the same field with the following expression:

<field name> IS NULL OR <field name > = " "

Thanks,

Kumar Gaurav

Re: Removing Error Records That Have Been Fixed Using Datareviewer

TuanVu_Huu — Mon, 17 Aug 2020 14:31:35 GMT

Dear Kumar,

Thank you so much for your help. But, I have tried your option still not get the error.

Please advice!

Thanks,

Vu Tuan

Re: Removing Error Records That Have Been Fixed Using Datareviewer

TuanVu_Huu — Mon, 17 Aug 2020 16:25:06 GMT

Dear Kumar,

I have known the error that the field name contain Vietnamese word as : 6634-V-ĐN

so in this text have "Đ" that is vietnamese word therefore it could not check,

please advise!

Vu Tuan

Re: Removing Error Records That Have Been Fixed Using Datareviewer

KumarGaurav — Mon, 17 Aug 2020 16:25:34 GMT

Hi Vu Tuan,

I tested the option in ArcMap 10.7.1 and it worked for me:

I got 2 results which are not validated by this expression.

Can you please confirm, what did not worked in your case?

Thanks,

Kumar Gaurav

Re: Removing Error Records That Have Been Fixed Using Datareviewer

TuanVu_Huu — Mon, 17 Aug 2020 17:00:46 GMT

Dear Kumar,

Thank you for your help!

As I took you that in the field contain Vietnamese Character. Therefore, it is not work.

please advise!

Vu Tuấn