Uploads folder, getting bloated

I was backing up my SuiteCRM folder, and I noticed that each time I did it, the uploads folder always too lots of time.

It turns out that I have a couple hundred gigabytles of data in there!

Can this folder be trimmed down?

What, if anything, can I get rid of?

Thanks

Joseph

Hello Simeon.

The folder contains multiple non-descript file names.

I have attached them at the end of this message.

They mean nothing, and take up lots of space:)

Thanks for yours, or anyone’s, ideas.

Thanks!

Joseph


117fd1f0-c062-ba1a-42ff-5363e5711031 87464422-860a-06ad-662e-54638fcf352c
118fdccc-91c3-9829-3982-5387545014f0 87e6271c-1d17-c653-1e17-54d939b87858
12f33810-43c5-6217-5925-553fb0099fd9 89220207-34ae-a05e-2a2f-53408acd80ae
133a8c27-a4b2-21d1-c655-55411634ecc5 89358a3f-b0f6-6726-a1de-537216a6fdd4
138fdfc0-7720-042c-653d-553560e64017 89e5e403-a0dc-9408-9443-55371a0d0b89
13c87216-270f-a9aa-4235-55737ebddd92 8a450b84-4b0d-3137-e004-54ca3d13e496
13d3be85-2c2d-7130-6fc4-5573875b1f6e 8b524b6d-d5cc-2826-410f-5538656a9f7a
142bcd16-ca51-3530-3490-55324303e536 8c0df28a-4074-c9b6-644a-5524998e118d
148ec959-6e6b-f673-8db1-5395d50d815f 8c510d28-cb14-aeca-eacd-55391ad4d6b6
14b3e417-4d8c-5e5b-db99-534086153ce8 8c739688-60a1-3cda-0ce0-536ba31638b6
1507d007-01f0-fdc0-1524-54760d81fc8c 8ccb96b9-35fc-8f30-14d6-536a9aba1c73
15da53f3-e69b-2240-1d17-553fb0e54ec8 8d4b94e0-a12c-25ca-7c35-54da414c989d
15ebb377-740e-063c-7b1c-5535601943d8 8e031e01-636e-8188-f09c-54638f11b407
16bb28f8-d20b-965e-240b-5512b4700536 8f4e6651-40aa-dbd4-eb32-5387544972d7
172134f5-d9b8-d806-19e4-5473859d6cac 91a588f1-8b8e-f038-4281-5343fdde9b38
17d2151f-0524-4bcd-8b5c-53408740f26f 91e32fe5-5850-c2d8-9f16-5345438827ff
18d5cbdf-4933-6287-52eb-5543e81d2ccd 921b2482-7a52-867a-03b4-5569b8226793
194e04e8-31e9-0fe8-7a53-5573918036f9 932b94c7-3997-c83a-3379-53408a224c61
1b324a24-d79f-8c1a-94e7-554d02337581 937627e8-0632-34ca-4808-54ca3a723953
1c24a707-da4c-d660-9b59-54efd662794b 93ea1187-7005-3731-1746-553717d6c70a
1c668798-0bc3-9655-d4d0-552e8cc2183a 94408bca-5ac5-0119-4e6b-5573873476da
1c89c064-6ff9-ea25-f5aa-551706046480 945e65d8-2786-44cc-d0e5-55784ef49aba
1d7f8758-37fc-1583-a3ee-539ba8f7eccf 94a34a37-ad62-4973-0219-5390f38835e5
1dec8e6a-74d7-453e-5b2a-554412f83908 94d4fa67-a272-4e15-66e2-5363e7730890
1e103c5a-c70c-c793-0c10-546ba9d822f7 950209cd-1857-00d5-99cc-552ebfe485e7
1f2f0750-6a5f-6cc0-ec36-539719860ef1 953c1caa-6f99-3a7b-1bbf-546b9d5f4a36
1f59f4df-af19-2f8e-cf7b-556ba95672b4 95c3edd6-087a-1c77-9617-537626b231ac
1f775b88-3b25-0a72-4318-5573877ff444 9674088d-3f19-4b1b-b0f7-554922422125
200e404a-3942-00ca-2564-54d4ee96ef85 96d6f057-536a-0f25-f195-553ba7b5fe11
203c679a-9711-ae6a-77b8-538744b3bd2d 96d7675b-2c62-2ba6-eecf-53876cca2487
209a07ae-aec5-a9cf-104f-539ba8d712fd 973683d9-487d-ca2a-9d50-534089d44303
218e000a-c26f-ae63-60ec-55706cae1fde 9805b19c-3414-fcaa-fd1b-5331875dd23a
21c116e3-9290-f7db-6b06-54613171d282 98125f62-563b-d33f-6e76-536b9b767247
21e91909-e4ad-4617-e61b-55737e48416f 98e10d69-77b6-5687-6442-5395f209de22
22a5c05a-0213-3dcf-0d9c-5345420d4feb 99758dc5-03f7-3074-accb-545bc80e8c35
23163d42-9686-6a6b-fb09-538557359bf5 9a1a00e8-32ea-44f4-06fe-55356dd5f887
2650eee0-7617-7873-b8f3-5340873086bf 9ae0d80a-0336-ce84-050e-54638f81e8f9
26d7deb8-a290-8f63-b87b-5543e839b6c8 9aeccbaa-9b65-71d9-591e-5372111eafa9
272e2b6b-d80b-9b2e-1a11-55737e07233c 9c220c56-e928-bee2-417c-538b19dc6691
27529654-e1cb-ba13-8d36-538776dedc41 9d5c31b5-c4d9-bb5a-cffb-531f89ea5639
280982e8-390e-80e5-884a-53762616e5a3 9d64003b-7115-6999-bab1-53597aa721c7
28365f9e-f3f0-eff5-9e91-54da410c28c5 9e030efc-bf4b-f26a-56fe-55314451d17f
297293c6-c329-839a-14f2-5512fd3be5bf 9e157a75-1961-31ae-178a-54f4a84eda67
29ae1c7a-e63c-723b-7583-55249965d528 9ee5ad25-e6d1-5d21-91e8-53720ef716ee
2a721b50-678c-d5fe-f556-5390f33a87f4 9f420456-a4e4-02ff-28a8-5553fa7c0ce6
2b0783a6-fd25-1d5c-cbad-54cfe34647ed 9fe60851-e816-b881-3370-53971ad3cedd
2cd95681-dac0-f73e-b45e-556baa07031b a089b5a9-7c04-22f4-da48-5351315a863c
2e155396-a3d5-18bd-8e4e-556bc50a2811 a094072c-8bce-1f60-3da6-54ca3a5e5365
2e172ecb-65f9-789d-c163-53874471490e a0b9246f-137d-db87-c3d1-536b9afb9496
2eac16d3-6940-88ba-ed85-54eced3c1c89 a36c7a60-2610-0ea3-4c6b-53971c75cbcd
2f7183aa-acda-acff-af5c-5374bc91c127 a4d000ed-8072-f086-9057-5571f60e673c
3022de7d-6459-09ab-d3e0-5397278057d5 a4f5522d-afef-6416-e5fd-5360f7a09637
303c46aa-36b3-f10f-8ff4-555de4594d47 a5a2d825-b36f-7967-efe0-53454313b510
30fd1321-1ced-655c-9883-536959ba0a84 a812b964-18ca-bff7-b48f-5532432500db
30fe8f74-df13-8009-f61f-556bc5397ed5 a81e4e8d-6559-f4fe-60e9-54d8def63f9c
314af996-95d3-25f0-424b-537626fef1af a8823d89-9824-9801-c9cb-546b9d356194
31c256bd-a6e9-5895-651a-5343ffdddcd7 a92856bb-e913-9b85-bf27-5543e8404b46
328d791b-5db1-a019-163b-5374bcbc5fe7 aa0beef9-1623-7c34-e2aa-553560d9ca07
33e086b5-486a-bfd4-5b47-555de9d9ee15 aa170d0d-e6ef-da07-1fc9-5536523ebf98
33f79b31-0b81-62ea-21f3-556b0cd4cfd3 aa6445e2-6fea-d3fa-b071-55706c0ffd42
34199ae8-02fd-b032-60a4-53695a2aef0d aa700ab6-bef3-1170-44c4-555288dadb57
34b6e93d-6ee3-4d98-cf55-54ca9f1da9d6 ab2ea6e3-ba5a-5996-6792-5552c2778388
378446b9-882a-d688-bbe8-5571f62f3f3e ab4d7501-be9a-0d5a-9d58-553140f4f934
37ec3768-6f00-b4d4-3d3d-53617983495f abe6884b-00f4-0417-f2f8-557387feb85e
3a901691-e7a0-586c-6cf6-5538656a1b58 ad1fc112-cd46-c08e-4217-536b9afca6b1
3bd5cfd7-cfd6-7cc1-532b-5535601a85ae ad4df807-419d-5641-6a79-553ba4122a7d
3bea6082-21ad-9caf-21a9-5531406cb7c7 af53d9ba-63ff-16d6-107a-55706c41dbb0
3d08ee55-3a89-3c74-932a-551af0b268b1 af5cd1fb-03df-45d8-02f7-5340ad866a9e
3d1403a6-ddc9-fa3f-880d-5541167cdc61 afcbb68c-4af6-6e29-9949-554a2da195ee
3d694a45-b8b0-9ef8-1661-556ba925e1ce b013e9ab-260b-51fb-b127-555de9aa637e
3db97780-3c67-8ebd-7b3e-555116a10f53 b01c8ed5-88c0-0351-3694-5343f7134c89
3dbde70a-effb-b091-f9de-556ba921da03 b0333f9e-3986-8f06-4923-54efd7e42938
3e2c1041-9623-d109-6af3-5343fe1ef856 b1481f6c-2877-dcbf-2586-554a1dc000d6
3f7418a9-46bc-55e4-bfb7-545c00df6a61 b212d83d-1bbf-ad04-05a7-554405e0b155
4018ae84-4e0f-3cca-4e30-54d4eebab795 b279257f-cd6a-5137-56dc-536011950438
4189583d-d461-5e0b-de6c-551b6b124d8c b2faa35a-7981-1bf9-f665-536b9ad7642a
41bd6775-8e0f-b4a3-f51f-53598024344e b2fcbb25-18b1-439f-bd1c-551360f6cd9c
41ea0f46-4df5-b914-6220-54638f4378a4 b34d4c74-2862-0258-c32b-5541a86d8b68
43b58db2-38a7-268f-7bc5-55181c03a0c4 b41853b2-f04a-1c0e-de32-5547a869c72c
4402774d-bf74-7f0b-9e53-5463a9709382 b5774de9-e37a-393a-cc1b-556b1c3eebb3
444dbb5c-eca8-c129-ce13-546b9d5ca45b b74b0066-a827-9c0f-31ca-556baa0a4953
4485dfe1-b347-5d69-4bd4-53597a098e6d b7f23d4e-89d5-348e-2504-537211b95559
45459cf1-29db-71c4-41dd-556ba9479088 b8233b51-e088-775d-dbc6-54fa50204e46
45d16442-de71-9295-0b2d-53762616e819 b9d342dc-f749-6e75-b3f3-551706d2b7f8
4603d42e-0235-4f0e-b0cf-53971ce28af8 ba580e3e-f8b0-94dd-6cc7-557848e3e328
46349edc-7a54-52fb-36a0-556b0c013c2a bcbdd1de-e16e-5dea-8274-5535601983a4
46497198-8fca-7990-1c1a-54fa25b7beb8 bdf1926e-442c-8c3e-902f-5543e80a953a
46ab3d8d-c6d5-35a9-b25a-5359d3864286 bdf32bdf-5119-715e-ce74-538776a04618
46ce69db-c214-a581-3c26-5393c0ee2494 be6e85e6-360b-b65a-6cd4-538b19b6985d
481a40f9-271b-320d-7b72-54760d2184a2 bf406fb1-4acb-f696-3e48-555de4e0f048
486f0ffe-64d6-2da0-5d0d-534ef92c9b21 bfbb6a4b-5cac-9754-dba3-5351319bdbbb
4938a342-51e9-85cd-1f48-5360179335b2 bfe52572-056f-cc42-048b-556b0c5d5343
494fc757-2746-fa78-575e-5534176a5869 c00549d5-9f72-a1ca-4517-536ba370235c
4af54166-8b85-ee64-3e42-5492fec5e270 c033bc66-89ab-fd8e-a332-53720d13ccc8
4b2b0ea5-77fc-ac10-9d81-53695a82108c c06efd26-9dd7-c14d-d4b7-552e8c1679d7
4d8b0a9a-aa14-745b-1007-55784e43d17f c1bb1425-4f2d-61a2-64eb-534132b3e3b4
4fa91074-677f-cfe5-9a8c-538b192476b5 c1e4714b-c0aa-99d0-7f7f-554411dbaadc
52517fe4-2da3-ff97-8793-5394471e68d6 c1eeacba-464f-5ab5-5680-555e0977344e
526aa06f-ea76-d3cb-4783-536b97ffdb4a c1fcc810-78de-217e-9597-536b9aad4cab
52c7f8d1-3fb2-3363-4ebd-55371216033d c217f232-00ad-c577-e594-556b1c598754
52ead86b-ec37-c820-244e-55364db2e193 c2a983c2-6b42-05ab-a620-54ca3af8d431
5316e67d-41d3-5d94-728b-55737e29a382 c313ee39-bf30-850b-a0a1-553ba49f3885
535080fa-cdd4-2718-001b-5394472973a7 c38ab1de-7ae3-f806-8ae3-54f9cac76b89
53e688a9-1824-23ff-9a3a-53720d520e36 c391fe82-cbd2-0902-dcdd-55356d36a840
544a84c4-e72f-81a5-ba66-5571f6ade86c c4752237-9346-074b-570a-538b198faad7
5466bdbf-70e4-4317-6dc2-55157e39e084 c50344cd-a284-192b-0828-555de4ea6412
54f774db-58d4-26b5-b150-55356d4b313f c66b29b3-5273-0ef3-7909-5359d783cb43
55649079-9b10-585d-646f-5367a139171b c68b70bf-fbd9-a2c8-6269-536179abcdf7
55b53a9d-9b78-bd6b-403f-5573876f83b1 c74430ac-e92f-41ec-09da-5552c21ab3af
55b99b74-902e-980a-5a3b-537eb9c5aa61 c769d438-3461-72e3-f467-5526de24b4de
5680c46f-5b69-88ff-7de0-5543e8fd0f3a c834a695-5657-d713-441b-556ba9f6fd42
57d01192-643c-672d-5d9c-553147130d01 c91da2c7-4acd-35fd-b06b-5364038e46f2
591c829e-ad2c-1674-cca7-5343fdc8a0a8 ca76c27a-13f1-e676-cd5d-554922fbac72
59b7a903-dec6-519f-2c90-54efbc43d920 ca780d0c-c3bd-cf35-92a6-5360f5c0d019
59fd78ba-3d73-4f77-91e8-551338323a5b cb8926f1-c797-90c2-6be0-556ba97154fd
5a12fe99-1af7-dec1-6178-537626290ef9 cc92017c-a617-271b-78e4-54ca3d7158e4
5ac2ad4a-92e5-ef30-a396-5460f6473942 ccb71818-6a04-e3b4-3bcc-54eded0bab8f
5b31b064-62bd-2e24-c382-553242e20e5a cce1a6dd-8866-d6e7-5b8b-553865d300a4
5cf4894f-4dbf-f31f-1f6e-556ba9b4a9aa cd4f370b-775a-f15a-9d5f-5460c8ee1202
5de70904-49fa-b438-199f-53720fe7150a cdab47b1-619f-e068-3ce7-53762697dbe2
5f3be5e2-77a5-45e1-b193-534086b37dcc cdb6f4c3-1d92-a2d0-a6e9-5395f190b18f
5fee523b-ce2e-bb1d-a3ba-5360f3ee4953 d01603df-33d6-85e5-69fa-55391a669d9f
614bf966-ec75-092a-f770-557391858394 d06ecbf7-0ef5-3386-2bf3-55706c9dd69e
623383ec-5341-d8f6-352a-555de93b4d99 d08763ab-92a8-9f7a-4bb5-5553e6a5fed8
62dd0632-68f9-e898-c895-5460c8e1caf8 d0f082fc-8706-0a52-fd02-5543e8b634e5
63db5a84-16c9-6a23-423d-55784e42018a d1f2e9eb-41cf-0b52-5630-55521066b122
648af8af-e504-2ecc-9edd-539447916ff4 d1f8a67d-f100-a5c3-9315-5544af08a181
66503deb-c6c1-f776-be13-5531470e7bf1 d23c39fb-37a4-143e-099e-555de4778b59
66b871fd-792a-77f5-6fa3-5341349a24f8 d4c3ac95-3c35-7a90-18f0-5360f6ca470e
691e8cb5-1518-2279-247d-5384d8c13e14 d595fa7b-2789-ecf2-8932-55668e568a15
6a5f9611-3104-0695-69c4-552f22625b8d d72cb67e-4380-9773-124d-5541a8be0cd4
6b1d4eba-9520-f659-1945-5387442529a0 d733811c-c946-e22c-ff30-534ef6f68ca3
6d29d8f2-82ed-f60b-2eb6-534542d59e7e d736fda6-d365-d9df-d0c9-553ba7da434e
6de875e5-fdb5-dfb2-33d2-53695928c272 d7e81c72-1033-d63b-9bbd-553246da491e
6e5367a7-9fc9-e1f7-f0a0-551b13a98d3c d88f75b3-740e-7ff8-2ac6-5492fec21838
6f535511-c441-4ed5-eb39-534089cc9cd0 da6f78d4-b23c-bca1-f038-5394471cc92b
7078ce10-55b5-74fb-77f5-554116476fb2 daf85d92-36ac-ed45-a89e-546202a9f648
70cd0534-fc4a-ca9e-dfed-553560d24fe4 dd19a712-0620-b8ee-69da-5564bd546cbb
70dc82f8-2200-1420-bc8a-5376268ab555 de5be18d-0479-913b-b2fe-5494a44e8ba6
714551d4-acfa-32cd-5a46-553560733cd1 de819351-f3be-2200-2189-55492bc8cfac
71514dda-b1ae-af4b-695c-554537734056 deleted
7218d727-5ace-ee58-1250-54e77ab72d2f df880750-8cbd-4d2d-c801-54624e60b4af
73b0676d-feb0-134c-7195-5463a9b41dce dfb97d23-6ff2-9b31-2f2e-54d9396fff72
73ca5684-5dfa-7621-453c-55668ec8fd03 e2048138-db6f-75db-630d-55341516d78d
765fa100-1a4a-cdfc-d5a1-5569b8c50924 e20f950e-714f-ea38-e2ba-5472405a1e64
77126814-8ff6-aad4-4135-5343f9f097fc e235e924-f8d1-6ffa-3c70-546b9dbb08cb
7727baa9-623c-61fb-3161-54d4f6f8658e e289a867-400b-7db8-c964-552ebf794249
77b3abd7-7e62-a27b-a773-556baadc9e50 e2949e88-1a32-3880-cfde-551563bee70f
793104f6-4455-fdc1-a95f-536b9739539f e3078cf0-6c56-b08f-e6eb-55668eb2b9b7
795c4aef-6d2c-9ac0-8e3b-5551170a0f63 e36a5bc8-1068-1fb6-69c9-5512fa687704
796ab635-a512-2657-6234-54ca3c2c8843 e4274578-6445-bb24-8a1a-5340addc9f40
79727ca2-2ee7-c446-3ca4-5536523384ee e460a90b-a4e9-f418-091b-554537c6b7cb
797a3338-4a3a-74b6-bf49-556b1cce9152 e53732af-5aed-5e10-98d3-53873e34051e
79c6a42d-0d3f-8b8b-0c39-5367a086cf7e e628cb0a-cfce-0f8d-c793-552be55b8025
7ad6fe71-5f01-24ea-e707-55706c4d8ca1 e6b00ae6-8a87-1329-d00e-55356d3adf4a
7bc535a2-81ff-e074-83cc-554a1d3f40d0 e84ffac7-5832-76d2-9991-5537ab424c47
7c0ebbaf-07ec-02b3-6444-539727307d47 e8b23b14-c149-c24e-069e-5340adea4cce
7deaa8cf-c33f-cadc-969c-556b0cb88ebd e9ccf998-a658-70bf-a134-55668e1929ef
7f0cb882-8fde-8b5e-dd7a-5492fc0e092b ea9201f8-ffd1-e058-7b32-55784e7a37f0
7f4cad78-9bb3-ad66-e4d7-55314106a708 eb04778f-e254-9639-f4ac-557848f93e2a
800ceabf-430c-a65a-2c5b-53874abb67bc ec9df55a-7e56-2ea5-3355-53876ca2abef
80a892d2-9588-ff5b-5453-537217e1b5d1 ed100999-d856-36b9-27fc-5373885c1d2f
818bbff8-6bac-7202-2cf7-54e782665dc0 ee4adee2-fbe6-7b67-fde1-54638f6bf22c
81ea6f1a-8c35-6ef7-7a1f-5384d878a70e ef2244a5-fb8e-8c0b-0c73-53877679755b
8391b140-9579-881d-923d-5395f2dc3032 efb07dc1-ee54-aafa-e9b1-556bc5f104a7
83a422a8-8a60-d72b-d406-54ca3a7214bf f1501c27-e4ae-8772-5b74-5571f6a16fba
83c1483b-504e-2c12-f039-53617a744d84 f1badc08-64cf-771b-c7f1-538411d3e31f
83dfa670-33a2-4fd2-05a0-554410856729 f3187228-94ad-97f2-8a9b-556bc56a8965
8408ee5d-a0b7-4d50-0628-536b9a995bef f32a5754-4e43-004d-54f6-5340ad956c28
84a8c37d-e589-628e-8092-555116491b0e f3472703-07ad-a77f-889a-54ca3a28c90e
856c88a0-3437-9c18-4450-535980beaca0 fac50297-c4d6-c14c-adc7-556b1ce04ee8

The upload folder is were ALL your uploads to SuiteCRM will end. So, if you have that much ammount of files there, you’ve uploaded them during the normal use of the system.

The other thing to consider is: when you delete a document, revision and so on from the SuiteCRM interface you’re not deleting anythin, only mark as ‘deleted’ in the Database and the corresponding file is never deleted from the file system, you could run the “Remove missed files from the upload directory” from the “Repair” section of the Administration module to check if some of those files are not referenced anymore and can be deleted…

Hello,

I coudl easily agree with you about the revisions issue, IF I had revisions.

I checked how many documents that I have:
6 of them

I have dozens and dozens of uploads.

Does this count when I upgrade the system? I have done this 4-5 times as SuiteCRM releases upgrades.

I did try the remove files fro upload section.

It said that it removed 45 files from the original 345.

There are still 300 files! Far from the 6 documents that I have. And since they range from 4 bytes to 3.8GB, this folder takes up a lot fo space, and back ups are very larger.

Since they are all names are wierd non-descript , I have no idea what they are.

Thanks for any ideas.

JOseph

Hmmmm… .the weirdest thing is that huge multi-gigabyte file there… some of the other “normal-sized” files can be failed uploads, email messages, notes, attachments… but i thought it wouldn’t be possible to upload a 3.8 GB file through SuiteCRM…

Hello,

After reading your reply, I went back and confirmed the files.

I counted wrong!

It was a 3.8MB file.

But, I wish that there was a way for someone to be able to track down a link between a non-descript file name and a email saved in the CRM with an attachment.

Then,we could get rid of extraneous files and save emails, for example.

Thanks for your help and ideas!

Joseph

Can anyone help determine how to remove all the extra bloat files that seem to be saved in the upload folder?
My upload folder just gets bigger every day, and there seems to be no way to control it.

Can I just erase everything?

Joseph

1 Like

No, I don’t think you can safely delete all that.

Those files should be one of these things:

  • email attachments
  • documents (and their revisions)
  • photos
  • maybe some other item types that I don’t know about.

If you go into the database (using PhpMyAdmin, for example), there are tables there linking those filenames to objects in SuiteCRM.

I have a few posts where I explain some of those:
https://suitecrm.com/community/forum/suitecrm-outlook-plugin/5987-attachments-not-copying-across-to-suite#32010
https://suitecrm.com/forum/suitecrm-7-0-discussion/9106-mass-importation-of-attachments#31426

If you can’t use the database, you can try adding one of those items in the SuiteCRM application and checking if a file gets added at the same time. Good luck.

How comfortable are you in MySQL (assuming that is your database)?

You could run a query to find things that have attachments (for example, notes that have data in file_mime_type and filename) and you would have a list of your files (without sizes). Theoretically, you could also write a PHP script that recursively looks at the contents of the upload directory and takes the GUID and the filesize and puts it in a database table. You could then join the two together in an SQL query and sort by filesize… you would then know what files are big and what those files are… and decide if you want to delete them. Any files you delete should have the corresponding database information deleted/updated as well.

I haven’t looked, but my best guess is that the filenames are the “id” of the corresponding database record.

I would expect this task to take several hours… then of course the time you spend cleaning it up.

You could also theoretically write a PHP page that shows all of this data in one spot and allows you to click and delete a file, affecting the CRM database record at the same time.

I don’t know what your technical ability is, but this may seem totally doable or totally overwhelming to you depending on your knowledge of SuiteCRM, PHP, and MySQL. I apologize, but it is my best idea.

sieberta