Prevent Duplicate File Transactions in File Manager DocType

Issue: Duplication of File Entries in File Manager

We have identified a functional issue within our document management process. When users attach a file to any DocType using the 'Attachments' section and select a file from the library, the system creates a new file transaction for the already existing file in the database. This behavior leads to unnecessary duplication of file entries, as observed in the File Manager DocType at the ../app/file path.

Steps to Reproduce

Go to any DocType and click on 'Attachments'.
In the modal, select 'Library' and choose an existing file (e.g., 'iPhone_15_Plus_Pink_2-square_medium.jpg').
Click 'Upload'.
Navigate to the File Manager DocType at ../app/file.
Observe multiple entries for the same file, indicating duplication.

Expected Behavior

The system should reference the existing file in the database without creating a new file transaction when the same file is uploaded to a DocType.

Goals

To eliminate the duplication of file transactions within the File Manager.
To ensure efficient and accurate file management within the system.

Action Items

Investigate the logic that triggers the creation of a new file transaction upon file selection from the library.
Modify the system to reference the existing file entry instead of creating a duplicate.
Implement checks to prevent duplication if the file already exists in the database.
Test the attachment functionality to confirm that duplicate transactions are no longer created.

Importance

Addressing this issue is critical for maintaining a clean and efficient file management system, preventing data redundancy, and optimizing database storage.

Request for Resolution

Please prioritize the investigation and resolution of this issue to enhance our document management practices and uphold the integrity of our data management system.

Thank you for your prompt attention to this matter and your dedication to continuous system improvement.

zaviagodev / frappe