Duplicates in attachment naming

[thielem]

As I understand it, attachments are referenced in the database by their original name, prefixed by the unix timestamp of their creation time.

We have a workflow where our office scans all incoming invoices. The scan is sent to an email and the email is integrated with Rukovoditel. This automatically creates an item in the entity for invoices. However, as the office tends to scan all the invoices at once in the morning, and emails are only fetched every minute or so, it happens that two attachments get the same name.

This leads one of the files being overwritten and if one of the entries is modified, sometimes the files just disappear.

SCR-20240319-oiir.png (11.49 KiB) Viewed 87 times

I guess it would be prudent to assign a unique identifier to each attachment that is not solely dependent on the creation timestamp (UUID?)

[support]

In this case prefixed by the unix timestamp is no OK, but I can't change how app works. So just add invoice number to filename to make it unique.