{"id":1152,"date":"2023-06-08T01:14:44","date_gmt":"2023-06-08T01:14:44","guid":{"rendered":"https:\/\/craftcookcode.com\/?p=1152"},"modified":"2024-08-06T02:31:11","modified_gmt":"2024-08-06T02:31:11","slug":"qlik-replicate-simple-trick-for-source-file-connectors","status":"publish","type":"post","link":"https:\/\/craftcookcode.com\/?p=1152","title":{"rendered":"Qlik Replicate &#8211; Simple trick for Source file connectors"},"content":{"rendered":"\n<p>Quick post on a trick I use in Qlik Replicate<\/p>\n\n\n\n<p>Qlik Replicate has a Source connector to consume flat files from a drive.&nbsp;<\/p>\n\n\n\n<p>More details can be found on the <a href=\"https:\/\/help.qlik.com\/en-US\/replicate\/May2023\/Content\/Replicate\/Main\/File\/file_source.htm\">Qlik website<\/a><\/p>\n\n\n\n<p>For change data capture of these files; Qlik will only consume files that have a newer &#8220;Last Change Date&#8221; than when the task is started.<\/p>\n\n\n\n<p>So if for some reason you have to stop and reload files that are already present; you have to change the &#8220;Last Modified Date&#8221;<\/p>\n\n\n\n<p>A simple Powershell command that I got from <a href=\"https:\/\/www.itechtics.com\/change-timestamp\/\">itechtics.com<\/a> can be used to reset all the dates in a directory of your choice.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: powershell; title: ; notranslate\" title=\"\">\nGet-ChildItem -force PathToItem * | ForEach-Object{$_.LastWriteTime = (&quot;yyyy-mm-dd hh24:mi:ss&quot;)}\n<\/pre><\/div>\n\n\n<p>So to change all the dates of the files in the directory C:tempload to the current time (as of writing):<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: powershell; title: ; notranslate\" title=\"\">\nGet-ChildItem -force c:\\temp\\load * | ForEach-Object{$_.LastWriteTime = (&quot;2023-06-08 11:05:00&quot;)}\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"http:\/\/craftcookcode.com\/wp-content\/uploads\/2023\/06\/Code_PowerShell-1024x601.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>If a Qlik Replicate task is running and watching this directory; it will reload the file <em>my_load.file.csv<\/em>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Quick post on a trick I use in Qlik Replicate Qlik Replicate has a Source connector to consume flat files from a drive.&nbsp; More details can&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":1076,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[16],"tags":[],"class_list":["post-1152","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlik-replicate"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/craftcookcode.com\/index.php?rest_route=\/wp\/v2\/posts\/1152","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/craftcookcode.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/craftcookcode.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/craftcookcode.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/craftcookcode.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1152"}],"version-history":[{"count":6,"href":"https:\/\/craftcookcode.com\/index.php?rest_route=\/wp\/v2\/posts\/1152\/revisions"}],"predecessor-version":[{"id":1494,"href":"https:\/\/craftcookcode.com\/index.php?rest_route=\/wp\/v2\/posts\/1152\/revisions\/1494"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/craftcookcode.com\/index.php?rest_route=\/wp\/v2\/media\/1076"}],"wp:attachment":[{"href":"https:\/\/craftcookcode.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1152"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/craftcookcode.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1152"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/craftcookcode.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1152"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}