duplicate keys in syncdata
Posted: June 13th, 2019, 8:27 am
Hello,
I am working in a new round of a survey that it was a couple of years ago. At that time I used dat files (txt), and tranmitted files betwwen supervisor and enumerators. In this round I want to introduce csdb files. In the old version, after tranmission to supervisor and before concatenate, checked if there were same keys in the different files, it was not often, because the supervisor assigns the HH to an specific enumerator, and each enumerator tablet is serialized and only the assigned enumerator can open the HH, however the supervisor after the assignment and transmission to the enumerator decides to change the HH assignment to a different enumerator and transmits the assignment to the new enumerator but no to the old one, then both enumerators have the same HH in the list, then for some reason the first enumerator selects the HH and start the dataentry program and exit, it creates the case. The second enumerator complete the HH, now both send the data to the supervisor, what happen in the csdb file when both enumerators transmit to the supervisor, and both have the same HH key in their files, then if the second ovewrite the first, and the first is not accessing that wrong HH again, and then first transmit again to the supervisor other HH collected, what happen with that wrong HH, is it overwrited again?.
Would appreciate to know what happen in the explained situation, because I have a possible solution, but I need to know the behaivor of this situation.
Thanks
Mario
I am working in a new round of a survey that it was a couple of years ago. At that time I used dat files (txt), and tranmitted files betwwen supervisor and enumerators. In this round I want to introduce csdb files. In the old version, after tranmission to supervisor and before concatenate, checked if there were same keys in the different files, it was not often, because the supervisor assigns the HH to an specific enumerator, and each enumerator tablet is serialized and only the assigned enumerator can open the HH, however the supervisor after the assignment and transmission to the enumerator decides to change the HH assignment to a different enumerator and transmits the assignment to the new enumerator but no to the old one, then both enumerators have the same HH in the list, then for some reason the first enumerator selects the HH and start the dataentry program and exit, it creates the case. The second enumerator complete the HH, now both send the data to the supervisor, what happen in the csdb file when both enumerators transmit to the supervisor, and both have the same HH key in their files, then if the second ovewrite the first, and the first is not accessing that wrong HH again, and then first transmit again to the supervisor other HH collected, what happen with that wrong HH, is it overwrited again?.
Would appreciate to know what happen in the explained situation, because I have a possible solution, but I need to know the behaivor of this situation.
Thanks
Mario