# Purging, extracting, or compressing all attachments

**URL:** <https://forum.manager.io/t/purging-extracting-or-compressing-all-attachments/21341>\
**Category:** Uncategorized\
**Created:** [March 28, 2019, 3:12pm UTC](https://forum.manager.io/t/purging-extracting-or-compressing-all-attachments/21341 "2019-03-28T15:12:10Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jon](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/jon/32/1915_2.png) [@Jon](https://forum.manager.io/u/Jon)\
**Post date:** [March 28, 2019, 3:12pm UTC](https://forum.manager.io/t/purging-extracting-or-compressing-all-attachments/21341/1 "2019-03-28T15:12:11Z")

</div>

I thought I loved the new attachment feature, until I noticed how enormous my Manager data file is getting. Especially with daily backups, it’s getting out of hand.

Is there a way to extract all my attachments to a separate file (or files), or at least a way to mass-delete or purge them from the Manager data file, or, failing that, to compress the file somehow? I have separate copies of everything I’ve attached in Manager and was just attaching copies to the invoices as a convenience, but now that I realize the cost of that convenience, I’m going to stop doing it going forward. Is there an easy way to remove my attachments without having to dig through one by one?

---

<div class="post-metadata">

**Author:** ![Jon](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/jon/32/1915_2.png) [@Jon](https://forum.manager.io/u/Jon)\
**Post date:** [March 28, 2019, 3:20pm UTC](https://forum.manager.io/t/purging-extracting-or-compressing-all-attachments/21341/2 "2019-03-28T15:20:49Z")

</div>

And this is strange. I started deleting attachments one by one by clicking the `X` next to the attachment at the bottom of the invoices they were attached to. After deleting quite a number of them, I saved a backup and closed Manager. I was surprised to find that the size of both the active data file and the backup file was exactly the same as it was before I deleted all of those attachments.

Apparently, clicking the `X` unlinks the attachment from the invoice but doesn’t actually purge the attachment from the data file. Is that correct, and if so, is there any way to purge and compress?

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [March 28, 2019, 3:29pm UTC](https://forum.manager.io/t/purging-extracting-or-compressing-all-attachments/21341/3 "2019-03-28T15:29:20Z")

</div>

Click the file size number on the Businesses page. That will execute a vacuum command on the file. Normally, deleting things doesn’t restructure or compress the file.

---

<div class="post-metadata">

**Author:** ![jeffbangquil](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/jeffbangquil/32/23071_2.png) [@jeffbangquil](https://forum.manager.io/u/jeffbangquil)\
**Post date:** [April 19, 2019, 4:54am UTC](https://forum.manager.io/t/purging-extracting-or-compressing-all-attachments/21341/4 "2019-04-19T04:54:54Z")

</div>

Deleting the transaction without deleting the attachment does not reduce file size. Why is it so? How can I clean this up?

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [April 19, 2019, 12:28pm UTC](https://forum.manager.io/t/purging-extracting-or-compressing-all-attachments/21341/5 "2019-04-19T12:28:00Z")

</div>

Read the previous answer.

---

<div class="post-metadata">

**Author:** ![jeffbangquil](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/jeffbangquil/32/23071_2.png) [@jeffbangquil](https://forum.manager.io/u/jeffbangquil)\
**Post date:** [April 20, 2019, 10:23am UTC](https://forum.manager.io/t/purging-extracting-or-compressing-all-attachments/21341/6 "2019-04-20T10:23:04Z")

</div>

Above answer (VACUUM) only works when the attachment was deleted before the record was removed. If the other way around, it is not working.

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [October 25, 2019, 7:52am UTC](https://forum.manager.io/t/purging-extracting-or-compressing-all-attachments/21341/7 "2019-10-25T07:52:02Z")

</div>

For greater visibility, I realized we need `Attachments` tab after all. This would allow to see orphaned attachments, do batch delete, search across all attachments etc.

So `Attachments` tab is now available in the latest version (19.10.32)

---

<div class="post-metadata">

**Author:** ![sharpdrivetek](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/sharpdrivetek/32/34244_2.png) [@sharpdrivetek](https://forum.manager.io/u/sharpdrivetek)\
**Post date:** [October 25, 2019, 9:22am UTC](https://forum.manager.io/t/purging-extracting-or-compressing-all-attachments/21341/8 "2019-10-25T09:22:27Z")

</div>

@lubos would it be possible to show the actual file size against the attachments rather than showing the equivalent in bytes? it would be better to show a measure which is consistent with the businesses page.

also, a link to the actual transaction record would help.

---

<div class="post-metadata">

**Author:** ![alasdair](https://avatars.discourse-cdn.com/v4/letter/a/fbc32d/32.png) [@alasdair](https://forum.manager.io/u/alasdair)\
**Post date:** [October 28, 2019, 5:30pm UTC](https://forum.manager.io/t/purging-extracting-or-compressing-all-attachments/21341/9 "2019-10-28T17:30:13Z")

</div>

> [@sharpdrivetek](#):
>
> would be better to show a measure which

Any chance we can make it possible to hide this tab (i.e. allow it to be uncheck in customized) even though I do have attachments in my business files. Its a tab I’d like to turn on/off and take a look at occasionally rather than something I want displayed all the time. Since it is not really ‘transactional’ but more ‘maintenance’ in nature I don’t think it needs the same constraints on turning off as would a tab related to transactions. Or, maybe it could be relocated to settings instead of a tab, like other maintenance items such as chart maintenance etc

Thoughts?

---

<div class="post-metadata">

**Author:** ![dalacor](https://avatars.discourse-cdn.com/v4/letter/d/7bcc69/32.png) [@dalacor](https://forum.manager.io/u/dalacor)\
**Post date:** [November 18, 2019, 2:02am UTC](https://forum.manager.io/t/purging-extracting-or-compressing-all-attachments/21341/10 "2019-11-18T02:02:26Z")

</div>

I agree that the Attachments Tab should be relocated to Settings as it’s not really a transactional tab but more of a maintenance function. It’s not likely to get that much use more like a once every few months usage and with the addition of the Reconciliations tab means that the list of tabs is growing.

However, I am pleased to see this tab however because I can see that I have incorrectly named same of the invoices, so I will correct that at my leisure. Thank you.

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [January 18, 2023, 2:58pm UTC](https://forum.manager.io/t/purging-extracting-or-compressing-all-attachments/21341/11 "2023-01-18T14:58:15Z")

</div>


