Hi there, I’ve been experimenting with attachments ahead of deciding if I want to use Manager to manage invoice files (pdfs, scans, etc) internally. What I wanted to avoid was ending up with a singular massive file (the business data file) containing all these invoice files as it would result in sl…

[image] hijomojo: making a change to one transaction record resulting in a few B or KB change in the data file but then having to sync an entire 100MB+ file as a result. Backups are typically incremental. Even Dropbox, Google Drive or iCloud are incremental. They only sync the portion of the …

[image] lubos: Yeah, and then you need each folder for each transaction because one transaction can have multiple attachments and then one attachment could be attached to more documents and now you are duplicating files across multiple folders. Sorry, I wasn’t describing something that would …

I think this addresses the other requirements [image] New Audit Trail (aka History) The backup function will be improved so you can choose what to include in the backup. If you want the smallest database possible, you would backup without emails, history and attachments. …

Hadn’t seen that topic, thanks for sharing.

Attachment storage structure idea

Patch August 5, 2020, 4:26am 4

I think this addresses the other requirements

Topic		Replies	Views
[16.10.70] Added ability to attach documents to transactions (+local storage)	55	6398	January 18, 2023
Connect folders to records attachments/ protect upload delete	3	109	November 9, 2024
Attachments are here?	10	2532	October 31, 2016
Attachments File Management Idea	12	1148	January 18, 2023
Attachment - Big thanks!	36	4013	October 24, 2016

Attachment storage structure idea

Related topics