{"id":631,"date":"2019-03-29T18:23:05","date_gmt":"2019-03-29T17:23:05","guid":{"rendered":"http:\/\/www.ume.li\/blog\/?p=631"},"modified":"2019-03-29T18:23:05","modified_gmt":"2019-03-29T17:23:05","slug":"connections-mass-file-removal","status":"publish","type":"post","link":"https:\/\/www.ume.li\/blog\/2019\/03\/29\/connections-mass-file-removal\/","title":{"rendered":"Connections &#8211; Mass file removal"},"content":{"rendered":"<p>I got a request to cleanup some files in a IBM Connections environment. Remove all the files created before 1.1.2015.<br \/>\nGetting the list of files is easy.<br \/>\n<code><br \/>\nconnect to files@<br \/>\nexport to files.csv of del modified by nochardel<br \/>\nselect hex(ID), id, title,create_date from files.media where create_date < date('2015-01-01')@\nconnect reset@\n<\/code><br \/>\nThis got me around 11'000 records.<br \/>\nIn the<a href=\"https:\/\/www-10.lotus.com\/ldd\/lcwiki.nsf\/xpAPIViewer.xsp?lookupName=IBM+Connections+6.0+API+Documentation#action=openDocument&#038;res_title=Deleting_a_file_and_its_metadata_ic60&#038;content=apicontent\" rel=\"noopener noreferrer\" target=\"_blank\"> api documentation<\/a> I found the required API call.<br \/>\nAfter a while I got my first node.js app. Which was correctly posting the required requests against my server. Doing a testrun with 11'000 records was a bad idea. My environment was so fast, that it sent the 11'000 requests in under 10s.<br \/>\nThe first couple of request passed, but then I got a lot of errors and the files app did not respond at all. With the help of <a href=\"https:\/\/www.npmjs.com\/package\/simple-rate-limiter\" rel=\"noopener noreferrer\" target=\"_blank\">simple rate limiter<\/a> I throttled it down to 2 requests\/per second. The process will now take a bit longer, but at least the connections environment stays alive.<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I got a request to cleanup some files in a IBM Connections environment. Remove all the files created before 1.1.2015.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[],"class_list":["post-631","post","type-post","status-publish","format-standard","hentry","category-connections"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.3 - aioseo.com -->\n\t<meta name=\"description\" content=\"I got a request to cleanup some files in a IBM Connections environment. Remove all the files created before 1.1.2015. Getting the list of files is easy. connect to files@ export to files.csv of del modified by nochardel select hex(ID), id, title,create_date from files.media where create_date &lt; date(&#039;2015-01-01&#039;)@ connect reset@ This got me around 11&#039;000\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"umeli\"\/>\n\t<meta name=\"keywords\" content=\"connections\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.ume.li\/blog\/2019\/03\/29\/connections-mass-file-removal\/\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Urs Meli&#039;s Blog\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Connections \u2013 Mass file removal | Urs Meli&#039;s Blog\" \/>\n\t\t<meta property=\"og:description\" content=\"I got a request to cleanup some files in a IBM Connections environment. Remove all the files created before 1.1.2015. Getting the list of files is easy. connect to files@ export to files.csv of del modified by nochardel select hex(ID), id, title,create_date from files.media where create_date &lt; date(&#039;2015-01-01&#039;)@ connect reset@ This got me around 11&#039;000\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.ume.li\/blog\/2019\/03\/29\/connections-mass-file-removal\/\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2019-03-29T17:23:05+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2019-03-29T17:23:05+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@umeli\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Connections \u2013 Mass file removal | Urs Meli&#039;s Blog\" \/>\n\t\t<meta name=\"twitter:description\" content=\"I got a request to cleanup some files in a IBM Connections environment. Remove all the files created before 1.1.2015. Getting the list of files is easy. connect to files@ export to files.csv of del modified by nochardel select hex(ID), id, title,create_date from files.media where create_date &lt; date(&#039;2015-01-01&#039;)@ connect reset@ This got me around 11&#039;000\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@umeli\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.ume.li\\\/blog\\\/2019\\\/03\\\/29\\\/connections-mass-file-removal\\\/#article\",\"name\":\"Connections \\u2013 Mass file removal | Urs Meli's Blog\",\"headline\":\"Connections &#8211; Mass file removal\",\"author\":{\"@id\":\"https:\\\/\\\/www.ume.li\\\/blog\\\/author\\\/umeli\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/www.ume.li\\\/blog\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/www.ume.li\\\/blog\\\/2019\\\/03\\\/29\\\/connections-mass-file-removal\\\/#articleImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b722f3e7e78b4f1e2b994856370dd7327963f636c5b50078baa80c2c4e411165?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"umeli\"},\"datePublished\":\"2019-03-29T18:23:05+01:00\",\"dateModified\":\"2019-03-29T18:23:05+01:00\",\"inLanguage\":\"en-US\",\"commentCount\":1,\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.ume.li\\\/blog\\\/2019\\\/03\\\/29\\\/connections-mass-file-removal\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.ume.li\\\/blog\\\/2019\\\/03\\\/29\\\/connections-mass-file-removal\\\/#webpage\"},\"articleSection\":\"Connections\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.ume.li\\\/blog\\\/2019\\\/03\\\/29\\\/connections-mass-file-removal\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.ume.li\\\/blog\\\/#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.ume.li\\\/blog\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.ume.li\\\/blog\\\/category\\\/connections\\\/#listItem\",\"name\":\"Connections\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.ume.li\\\/blog\\\/category\\\/connections\\\/#listItem\",\"position\":2,\"name\":\"Connections\",\"item\":\"https:\\\/\\\/www.ume.li\\\/blog\\\/category\\\/connections\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.ume.li\\\/blog\\\/2019\\\/03\\\/29\\\/connections-mass-file-removal\\\/#listItem\",\"name\":\"Connections &#8211; Mass file removal\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.ume.li\\\/blog\\\/#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.ume.li\\\/blog\\\/2019\\\/03\\\/29\\\/connections-mass-file-removal\\\/#listItem\",\"position\":3,\"name\":\"Connections &#8211; Mass file removal\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.ume.li\\\/blog\\\/category\\\/connections\\\/#listItem\",\"name\":\"Connections\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.ume.li\\\/blog\\\/#person\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/www.ume.li\\\/blog\\\/2019\\\/03\\\/29\\\/connections-mass-file-removal\\\/#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bba650dede6888bd44d79e656db7b6564b4a7e7ba51445cc1c062dd769729e59?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"admin\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.ume.li\\\/blog\\\/author\\\/umeli\\\/#author\",\"url\":\"https:\\\/\\\/www.ume.li\\\/blog\\\/author\\\/umeli\\\/\",\"name\":\"umeli\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/www.ume.li\\\/blog\\\/2019\\\/03\\\/29\\\/connections-mass-file-removal\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b722f3e7e78b4f1e2b994856370dd7327963f636c5b50078baa80c2c4e411165?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"umeli\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.ume.li\\\/blog\\\/2019\\\/03\\\/29\\\/connections-mass-file-removal\\\/#webpage\",\"url\":\"https:\\\/\\\/www.ume.li\\\/blog\\\/2019\\\/03\\\/29\\\/connections-mass-file-removal\\\/\",\"name\":\"Connections \\u2013 Mass file removal | Urs Meli's Blog\",\"description\":\"I got a request to cleanup some files in a IBM Connections environment. Remove all the files created before 1.1.2015. Getting the list of files is easy. connect to files@ export to files.csv of del modified by nochardel select hex(ID), id, title,create_date from files.media where create_date < date('2015-01-01')@ connect reset@ This got me around 11'000\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.ume.li\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.ume.li\\\/blog\\\/2019\\\/03\\\/29\\\/connections-mass-file-removal\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/www.ume.li\\\/blog\\\/author\\\/umeli\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/www.ume.li\\\/blog\\\/author\\\/umeli\\\/#author\"},\"datePublished\":\"2019-03-29T18:23:05+01:00\",\"dateModified\":\"2019-03-29T18:23:05+01:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.ume.li\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.ume.li\\\/blog\\\/\",\"name\":\"Urs Meli's Blog\",\"description\":\"Mostly harmless\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.ume.li\\\/blog\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Connections \u2013 Mass file removal | Urs Meli's Blog","description":"I got a request to cleanup some files in a IBM Connections environment. Remove all the files created before 1.1.2015. Getting the list of files is easy. connect to files@ export to files.csv of del modified by nochardel select hex(ID), id, title,create_date from files.media where create_date < date('2015-01-01')@ connect reset@ This got me around 11'000","canonical_url":"https:\/\/www.ume.li\/blog\/2019\/03\/29\/connections-mass-file-removal\/","robots":"max-image-preview:large","keywords":"connections","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.ume.li\/blog\/2019\/03\/29\/connections-mass-file-removal\/#article","name":"Connections \u2013 Mass file removal | Urs Meli's Blog","headline":"Connections &#8211; Mass file removal","author":{"@id":"https:\/\/www.ume.li\/blog\/author\/umeli\/#author"},"publisher":{"@id":"https:\/\/www.ume.li\/blog\/#person"},"image":{"@type":"ImageObject","@id":"https:\/\/www.ume.li\/blog\/2019\/03\/29\/connections-mass-file-removal\/#articleImage","url":"https:\/\/secure.gravatar.com\/avatar\/b722f3e7e78b4f1e2b994856370dd7327963f636c5b50078baa80c2c4e411165?s=96&d=mm&r=g","width":96,"height":96,"caption":"umeli"},"datePublished":"2019-03-29T18:23:05+01:00","dateModified":"2019-03-29T18:23:05+01:00","inLanguage":"en-US","commentCount":1,"mainEntityOfPage":{"@id":"https:\/\/www.ume.li\/blog\/2019\/03\/29\/connections-mass-file-removal\/#webpage"},"isPartOf":{"@id":"https:\/\/www.ume.li\/blog\/2019\/03\/29\/connections-mass-file-removal\/#webpage"},"articleSection":"Connections"},{"@type":"BreadcrumbList","@id":"https:\/\/www.ume.li\/blog\/2019\/03\/29\/connections-mass-file-removal\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.ume.li\/blog\/#listItem","position":1,"name":"Home","item":"https:\/\/www.ume.li\/blog\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.ume.li\/blog\/category\/connections\/#listItem","name":"Connections"}},{"@type":"ListItem","@id":"https:\/\/www.ume.li\/blog\/category\/connections\/#listItem","position":2,"name":"Connections","item":"https:\/\/www.ume.li\/blog\/category\/connections\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.ume.li\/blog\/2019\/03\/29\/connections-mass-file-removal\/#listItem","name":"Connections &#8211; Mass file removal"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.ume.li\/blog\/#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www.ume.li\/blog\/2019\/03\/29\/connections-mass-file-removal\/#listItem","position":3,"name":"Connections &#8211; Mass file removal","previousItem":{"@type":"ListItem","@id":"https:\/\/www.ume.li\/blog\/category\/connections\/#listItem","name":"Connections"}}]},{"@type":"Person","@id":"https:\/\/www.ume.li\/blog\/#person","name":"admin","image":{"@type":"ImageObject","@id":"https:\/\/www.ume.li\/blog\/2019\/03\/29\/connections-mass-file-removal\/#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/bba650dede6888bd44d79e656db7b6564b4a7e7ba51445cc1c062dd769729e59?s=96&d=mm&r=g","width":96,"height":96,"caption":"admin"}},{"@type":"Person","@id":"https:\/\/www.ume.li\/blog\/author\/umeli\/#author","url":"https:\/\/www.ume.li\/blog\/author\/umeli\/","name":"umeli","image":{"@type":"ImageObject","@id":"https:\/\/www.ume.li\/blog\/2019\/03\/29\/connections-mass-file-removal\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/b722f3e7e78b4f1e2b994856370dd7327963f636c5b50078baa80c2c4e411165?s=96&d=mm&r=g","width":96,"height":96,"caption":"umeli"}},{"@type":"WebPage","@id":"https:\/\/www.ume.li\/blog\/2019\/03\/29\/connections-mass-file-removal\/#webpage","url":"https:\/\/www.ume.li\/blog\/2019\/03\/29\/connections-mass-file-removal\/","name":"Connections \u2013 Mass file removal | Urs Meli's Blog","description":"I got a request to cleanup some files in a IBM Connections environment. Remove all the files created before 1.1.2015. Getting the list of files is easy. connect to files@ export to files.csv of del modified by nochardel select hex(ID), id, title,create_date from files.media where create_date < date('2015-01-01')@ connect reset@ This got me around 11'000","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/www.ume.li\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/www.ume.li\/blog\/2019\/03\/29\/connections-mass-file-removal\/#breadcrumblist"},"author":{"@id":"https:\/\/www.ume.li\/blog\/author\/umeli\/#author"},"creator":{"@id":"https:\/\/www.ume.li\/blog\/author\/umeli\/#author"},"datePublished":"2019-03-29T18:23:05+01:00","dateModified":"2019-03-29T18:23:05+01:00"},{"@type":"WebSite","@id":"https:\/\/www.ume.li\/blog\/#website","url":"https:\/\/www.ume.li\/blog\/","name":"Urs Meli's Blog","description":"Mostly harmless","inLanguage":"en-US","publisher":{"@id":"https:\/\/www.ume.li\/blog\/#person"}}]},"og:locale":"en_US","og:site_name":"Urs Meli's Blog","og:type":"article","og:title":"Connections \u2013 Mass file removal | Urs Meli's Blog","og:description":"I got a request to cleanup some files in a IBM Connections environment. Remove all the files created before 1.1.2015. Getting the list of files is easy. connect to files@ export to files.csv of del modified by nochardel select hex(ID), id, title,create_date from files.media where create_date &lt; date('2015-01-01')@ connect reset@ This got me around 11'000","og:url":"https:\/\/www.ume.li\/blog\/2019\/03\/29\/connections-mass-file-removal\/","article:published_time":"2019-03-29T17:23:05+00:00","article:modified_time":"2019-03-29T17:23:05+00:00","twitter:card":"summary","twitter:site":"@umeli","twitter:title":"Connections \u2013 Mass file removal | Urs Meli's Blog","twitter:description":"I got a request to cleanup some files in a IBM Connections environment. Remove all the files created before 1.1.2015. Getting the list of files is easy. connect to files@ export to files.csv of del modified by nochardel select hex(ID), id, title,create_date from files.media where create_date &lt; date('2015-01-01')@ connect reset@ This got me around 11'000","twitter:creator":"@umeli"},"aioseo_meta_data":{"post_id":"631","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":"","og_description":"","og_object_type":"article","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":"","og_article_tags":"","twitter_use_og":false,"twitter_card":"summary","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"location":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2021-01-13 07:46:10","updated":"2025-07-09 09:52:36","seo_analyzer_scan_date":null,"focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.ume.li\/blog\/\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.ume.li\/blog\/category\/connections\/\" title=\"Connections\">Connections<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tConnections \u2013 Mass file removal\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.ume.li\/blog\/"},{"label":"Connections","link":"https:\/\/www.ume.li\/blog\/category\/connections\/"},{"label":"Connections &#8211; Mass file removal","link":"https:\/\/www.ume.li\/blog\/2019\/03\/29\/connections-mass-file-removal\/"}],"_links":{"self":[{"href":"https:\/\/www.ume.li\/blog\/wp-json\/wp\/v2\/posts\/631","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ume.li\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ume.li\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ume.li\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ume.li\/blog\/wp-json\/wp\/v2\/comments?post=631"}],"version-history":[{"count":2,"href":"https:\/\/www.ume.li\/blog\/wp-json\/wp\/v2\/posts\/631\/revisions"}],"predecessor-version":[{"id":633,"href":"https:\/\/www.ume.li\/blog\/wp-json\/wp\/v2\/posts\/631\/revisions\/633"}],"wp:attachment":[{"href":"https:\/\/www.ume.li\/blog\/wp-json\/wp\/v2\/media?parent=631"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ume.li\/blog\/wp-json\/wp\/v2\/categories?post=631"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ume.li\/blog\/wp-json\/wp\/v2\/tags?post=631"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}