SONY camera reused file names

There are partners who’s cameras file names have been reseted by mistake or the cameras have reseted themselves resulting in repeated file names. This can be problematic since the data base counts on the file names being unique to generate new rows and to pair the data coming from the SD cards with the metadata coming from the app.

TX02 (TX-Guo)

Background

It seems that their camera reseted itself frequently. I got in a call with them and determined that this is not something that the users were doing intentionally nor that something on their workflow was causing this behavior. The user reported that the uploader was failing in several instances what prompted me to look further into the problem. I determined that the problem was that the AgIR app was generating a new file name for those repeated names by adding an underscore followed by a number. When trying to upload data from the app there were no issues since this is a new file name so there were no conflicts in the DB. Furthermore, it seems that the app