Deleting multiple cases from CSDB file

[msoni]

Hi and greetings

We are running a survey where around 45 devices being used for data collection and sending data on daily basis on CSWeb server. I download data everyday and process something and prepare data file for analysis.

There are 5 IDs which needs to be deleted as these were test cases.

I need to each time download and make excel output and then delete from the output excel. Is there a way to delete those 5 cases directly from CSDB file and after that, i export to excel.

I read documents which says using delcase function but says works only external dictionary.
Is there some other quick way of doing it within CSDB file ?

Thanks and Regards
Manoj

[htuser]

A few years ago Greg helped me with similar and a worse issue. It was the first and only batch application I ever wrote...
a) I created a list string with all the UUIDs of the cases I wanted to delete.
b) And wrote few logic lines in a batch application adding the main dictionary (and related csdb) as external dict.
Please take a look at the attached solutions.

DeleteCasesBatch.zip

(18.26 KiB) Downloaded 5332 times

Hope this help.

[msoni]

Thanks. Will look into it.
Regards

[msoni]

Dictionary is missing in attached file.
Please send. Thanks

A few years ago Greg helped me with similar and a worse issue. It was the first and only batch application I ever wrote...
a) I created a list string with all the UUIDs of the cases I wanted to delete.
b) And wrote few logic lines in a batch application adding the main dictionary (and related csdb) as external dict.
Please take a look at the attached solutions.
DeleteCasesBatch.zip

Hope this help.

[htuser]

You should replace case key or uuid, dictionary and item names with your own and test it.

[Gregory Martin]

@htuser's application uses the case UUID, which is necessary if you have multiple cases with the same key. If the case keys that you do not want are unique, you can use the key function to simply check against the list of bad cases and then skip them:

string case_key = key(DICT_NAME);

if case_key in "BAD_ID1", "BAD_ID2" then
    skip case;
endif;