{"id":160,"date":"2017-07-06T17:32:05","date_gmt":"2017-07-06T17:32:05","guid":{"rendered":"http:\/\/jetletter.mhetadatamarketing.com\/?p=160"},"modified":"2017-08-13T17:56:01","modified_gmt":"2017-08-14T00:56:01","slug":"pjb-file-automation-with-powershell-sql","status":"publish","type":"post","link":"https:\/\/mhetadatamarketing.com\/jetletter\/?p=160","title":{"rendered":".PJB file automation"},"content":{"rendered":"<p>When you open up any Jetletter Page Builder folder there is a project .PJB file that is managed by the workflow manager where you can set options.\u00a0 Once options are set the way you like you can just double-click the .PJB file and Jetletter Page Builder runs exactly what you requested..<\/p>\n<p>This option means that you can run any project from the command-line or from powershell as well. Setup as many options as you like and just rename each .PJB file with the options you want.<\/p>\n<p>This is my favorite option and the most flexible way to run jobs hands-free!<\/p>\n<p>I have even built SQL commands to execute powershell in the file-system to run projects where Jetletter Page-builder has ODBC connection to SQL.\u00a0 This is the dream!\u00a0 You can build a record set in SQL, then trigger your Jetletter Page Builder outputs from SQL-2-Powershell scripts hands-free and all ran from SQL Active Agent.\u00a0 I live for hands-free personalized VDP output on-demand.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When you open up any Jetletter Page Builder folder there is a project .PJB file that is managed by the workflow manager where you can set options.\u00a0 Once options are set the way you like you can just double-click the .PJB file and Jetletter Page Builder runs exactly what you requested.. This option means that [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[8],"tags":[],"_links":{"self":[{"href":"https:\/\/mhetadatamarketing.com\/jetletter\/index.php?rest_route=\/wp\/v2\/posts\/160"}],"collection":[{"href":"https:\/\/mhetadatamarketing.com\/jetletter\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mhetadatamarketing.com\/jetletter\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mhetadatamarketing.com\/jetletter\/index.php?rest_route=\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/mhetadatamarketing.com\/jetletter\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=160"}],"version-history":[{"count":3,"href":"https:\/\/mhetadatamarketing.com\/jetletter\/index.php?rest_route=\/wp\/v2\/posts\/160\/revisions"}],"predecessor-version":[{"id":473,"href":"https:\/\/mhetadatamarketing.com\/jetletter\/index.php?rest_route=\/wp\/v2\/posts\/160\/revisions\/473"}],"wp:attachment":[{"href":"https:\/\/mhetadatamarketing.com\/jetletter\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=160"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mhetadatamarketing.com\/jetletter\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=160"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mhetadatamarketing.com\/jetletter\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}