Data Settings: How does csweb handle modified cases on relational SQL table?

Discussions about tools to complement CSPro data processing
Post Reply
Webexplr
Posts: 8
Joined: June 12th, 2023, 4:08 am

Data Settings: How does csweb handle modified cases on relational SQL table?

Post by Webexplr »

Using CSWeb's Data Settings, we can configure dictionaries to break out questionnaire data into relational tables. I have a question:

1. I send an entry to my csweb server (using PUT method),
2. then I break out all cases data currently on the server (php bin/console csweb:process-cases),
3. then I modify or delete that previous entry (no. 1) on my laptop, and re-send that entry to my server
4. I repeat step 2

Will there be two same cases (one is the original, the other one is the deleted/modified case), or just one case (a.k.a one table record) on my MySQL relational table? Thanks in advance.
aaronw
Posts: 565
Joined: June 9th, 2016, 9:38 am
Location: Washington, DC

Re: Data Settings: How does csweb handle modified cases on relational SQL table?

Post by aaronw »

The original case should be updated, leaving you with one case. I am assuming when you say modify/delete the case you are doing so though CSEntry.
Post Reply