Data Management how to Copy data to target for only the "Not Started" records ?

(0) Share

Report

Posted on by Nicolas D365

Hello,

I have a data project job that stopped at the middle of the progress, the number of record is huge and I only want to Copy data to target for the "Not Started" records.

When I am in the "View staging data" form, I can run the copy for all, errors or Rows selected by users.

I am able to filter the grid and select all lines with CTRL + Shift + M but I cannot tick the selection checkbox I tried space, CTRL + Space and CTRL + Click.

In addition, this form does not have a "select all" button.

Categories:

Data Integration

I have the same question (0)

All responses (12)

Answers (0)

Suggested answer

Sheikh Sohail 6,125 on at

Like (0)

Report

You can select the specific status record, there is feature available. Once you select the all not start record execute the project again.

How can select the specific records:

Execute project again with selected rows

Was this reply helpful? Yes No
Nicolas D365 20 on at

Like (0)

Report

Thanks for your answer.

This feature seems awesome but does not exists in my version

I'm on FinOps 10.0.2 PU 26

Are you sure it's not a customization on your project ?

Was this reply helpful? Yes No
Suggested answer

Sheikh Sohail 6,125 on at

Like (0)

Report

Hi Nicolas

I am using the same version, and this OOTB feature not customize, Do you have administrator rights? I am using my instance with admin rights.

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

Hi Nicolas D365,

You can select those record from the grid then click copy data to target button which is available for you , I can see it in your screenshot and then select criteria, check "Row selected by user" check box and run it . It should work.

Just for your info, I am using V10 Pu 26 and I don't see "Mark Status specific"button either.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,248 Super User 2025 Season 2 on at

Like (0)

Report

The option 'Mark status specific' is indeed not a standard feature. I have double checked the form design and the label files.

To be able to mark the individual records, you first need to click on 'Edit' on the action bar (left). However, marking a lot of records might be cumbersome. Then you can probably just restart everything.

Was this reply helpful? Yes No
Nicolas D365 20 on at

Like (0)

Report

So there is no standard solution to re-execute my 150 000 records without clicking on the selection checkbox one by one.

Sad

Was this reply helpful? Yes No
nmaenpaa 101,166 Moderator on at

Like (0)

Report

Or just reimport the records.

Was this reply helpful? Yes No
Sukrut Parab 71,710 Moderator on at

Like (0)

Report

If its 150K records , you should go ahead with re-import

Was this reply helpful? Yes No
Suggested answer

Nicolas D365 20 on at

Like (0)

Report

Ok I found a solution myself.

I can bulk delete completed records using the sysTableBrowser on the staging table

Was this reply helpful? Yes No
André Arnaud de Cal... 301,248 Super User 2025 Season 2 on at

Like (0)

Report

Hi Nicolas,

Glad you found this option. Note that this table browser option is read-only in production environments.

Was this reply helpful? Yes No