prevent the “SharePoint Migration Tool Public Preview” from executing any workflows during the migration from SP 2010 to SP online

We want to migrate a sharepoint on-premises 2010 to sharepoint online. and we are planning to do a test migration using the “SharePoint Migration Tool Public Preview” downloaded from https://spmtreleasescus.blob.core.windows.net/betainstall/default.htm

now our SP 2010 contain many sub-sites, document libraries & lists + some libraries and lists have workflows attached to them and those workflows will be executed when adding/editing the items. so i need to make sure that those workflows will not be executed during the migration, as this can result in sending hundreds of emails and updating external systems which we do not want it to happen during the migration. We do need the workflows to get migrated but without been executed during the migration, i checked the available options inside the “SharePoint Migration Tool Public Preview” tool but I did not find any option to present the workflows from been executed during the migration, or this will happen out of the box?

Thanks

“Base table or view not found” in Data Migration Tool PostProcessing Step – Prefix Missing

I am migrating a Magento EE 1.14.4.2 to Magento Commerce 2.3.2 using the Data Migration Tool 2.3.2. It appears to be processing correctly until it fails about 50 minutes later on the PostProcessing step with the following error…

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘magento2.catalog_product_entity_int’ doesn’t exist, query was: DELETE FROM catalog_product_entity_int WHERE (value_id IN (‘535690′,’545428′,’546868′,’551863′,’551890′,’551899′,’551908′,’551926’, …

The source database has no table prefix and the destination database has a table prefix which are both declared as such in the config.xml (user, password and crypt keys have been removed and db names and prefix tweaked here for security)

vendor/magento/data-migration-tool/etc/commerce-to-commerce/1.14.4.2/config.xml

<?xml version="1.0" encoding="UTF-8"?> <!-- /**  * Copyright © Magento, Inc. All rights reserved.  * See COPYING.txt for license details.  */ --> <config xmlns:xs="http://www.w3.org/2001/XMLSchema-instance" xs:noNamespaceSchemaLocation="../../config.xsd">     <steps mode="settings">         <step title="Settings Step">             <integrity>Migration\Step\Settings\Integrity</integrity>             <data>Migration\Step\Settings\Data</data>         </step>         <step title="Stores Step">             <integrity>Migration\Step\Stores\Integrity</integrity>             <data>Migration\Step\Stores\Data</data>             <volume>Migration\Step\Stores\Volume</volume>         </step>     </steps>     <steps mode="data">         <step title="Data Integrity Step">             <integrity>Migration\Step\DataIntegrity\Integrity</integrity>         </step>         <step title="EAV Step">             <integrity>Migration\Step\Eav\Integrity</integrity>             <data>Migration\Step\Eav\Data</data>             <volume>Migration\Step\Eav\Volume</volume>         </step>         <step title="Custom Customer Attributes Step">             <integrity>Migration\Step\CustomCustomerAttributes\Integrity</integrity>             <data>Migration\Step\CustomCustomerAttributes\Data</data>             <volume>Migration\Step\CustomCustomerAttributes\Volume</volume>         </step>         <step title="Customer Attributes Step">             <integrity>Migration\Step\Customer\Integrity</integrity>             <data>Migration\Step\Customer\Data</data>             <volume>Migration\Step\Customer\Volume</volume>         </step>         <step title="Map Step">             <integrity>Migration\Step\Map\Integrity</integrity>             <data>Migration\Step\Map\Data</data>             <volume>Migration\Step\Map\Volume</volume>         </step>         <step title="Url Rewrite Step">             <integrity>Migration\Step\UrlRewrite\Version11410to2000</integrity>             <data>Migration\Step\UrlRewrite\Version11410to2000</data>             <volume>Migration\Step\UrlRewrite\Version11410to2000</volume>         </step>         <step title="Log Step">             <integrity>Migration\Step\Log\Integrity</integrity>             <data>Migration\Step\Log\Data</data>             <volume>Migration\Step\Log\Volume</volume>         </step>         <step title="Ratings Step">             <integrity>Migration\Step\Ratings\Integrity</integrity>             <data>Migration\Step\Ratings\Data</data>             <volume>Migration\Step\Ratings\Volume</volume>         </step>         <step title="SalesOrder Step">             <integrity>Migration\Step\SalesOrder\Integrity</integrity>             <data>Migration\Step\SalesOrder\Data</data>             <volume>Migration\Step\SalesOrder\Volume</volume>         </step>         <step title="ConfigurablePrices step">             <integrity>Migration\Step\ConfigurablePrices\Integrity</integrity>             <data>Migration\Step\ConfigurablePrices\Data</data>             <volume>Migration\Step\ConfigurablePrices\Volume</volume>         </step>         <step title="OrderGrids Step">             <integrity>Migration\Step\OrderGridsEE\Integrity</integrity>             <data>Migration\Step\OrderGridsEE\Data</data>             <volume>Migration\Step\OrderGridsEE\Volume</volume>         </step>         <step title="Tier Price Step">             <integrity>Migration\Step\TierPrice\Integrity</integrity>             <data>Migration\Step\TierPrice\Data</data>             <volume>Migration\Step\TierPrice\Volume</volume>         </step>         <step title="SalesIncrement Step">             <integrity>Migration\Step\SalesIncrement\Integrity</integrity>             <data>Migration\Step\SalesIncrement\Data</data>             <volume>Migration\Step\SalesIncrement\Volume</volume>         </step>         <step title="Inventory Step">             <integrity>Migration\Step\Inventory\Integrity</integrity>             <data>Migration\Step\Inventory\Data</data>             <volume>Migration\Step\Inventory\Volume</volume>         </step>         <step title="VisualMerchandiser Step">             <integrity>Migration\Step\VisualMerchandiser\Integrity</integrity>             <data>Migration\Step\VisualMerchandiser\Data</data>             <volume>Migration\Step\VisualMerchandiser\Volume</volume>         </step>         <step title="PostProcessing Step">             <data>Migration\Step\PostProcessing\Data</data>         </step>     </steps>     <steps mode="delta">         <step title="Custom Customer Attributes Step">             <delta>Migration\Step\CustomCustomerAttributes\Delta</delta>             <volume>Migration\Step\CustomCustomerAttributes\Volume</volume>         </step>         <step title="Customer Attributes Step">             <delta>Migration\Step\Customer\Delta</delta>             <volume>Migration\Step\Customer\Volume</volume>         </step>         <step title="Map Step">             <delta>Migration\Step\Map\Delta</delta>             <volume>Migration\Step\Map\Volume</volume>         </step>         <step title="Log Step">             <delta>Migration\Step\Log\Delta</delta>             <volume>Migration\Step\Log\Volume</volume>         </step>         <step title="SalesOrder Step">             <delta>Migration\Step\SalesOrder\Delta</delta>             <volume>Migration\Step\SalesOrder\Volume</volume>         </step>         <step title="OrderGrids Step">             <delta>Migration\Step\OrderGridsEE\Delta</delta>             <volume>Migration\Step\OrderGridsEE\Volume</volume>         </step>         <step title="SalesIncrement Step">             <delta>Migration\Step\SalesIncrement\Delta</delta>             <volume>Migration\Step\SalesIncrement\Volume</volume>         </step>         <step title="Inventory Step">             <delta>Migration\Step\Inventory\Delta</delta>             <volume>Migration\Step\Inventory\Volume</volume>         </step>     </steps>     <source>         <database host="localhost" name="magento1" user="my_user" password="my_password" />     </source>     <destination>         <database host="localhost" name="magento2" user="my_user" password="my_password" />     </destination>     <options>         <map_file>etc/commerce-to-commerce/1.14.4.2/map.xml</map_file>         <eav_map_file>etc/commerce-to-commerce/map-eav.xml.dist</eav_map_file>         <eav_document_groups_file>etc/commerce-to-commerce/eav-document-groups.xml.dist</eav_document_groups_file>         <eav_attribute_groups_file>etc/commerce-to-commerce/eav-attribute-groups.xml</eav_attribute_groups_file>         <log_map_file>etc/commerce-to-commerce/map-log.xml.dist</log_map_file>         <log_document_groups_file>etc/commerce-to-commerce/log-document-groups.xml.dist</log_document_groups_file>         <settings_map_file>etc/commerce-to-commerce/settings.xml.dist</settings_map_file>         <customer_map_file>etc/commerce-to-commerce/map-customer.xml.dist</customer_map_file>         <customer_document_groups_file>etc/commerce-to-commerce/customer-document-groups.xml.dist</customer_document_groups_file>         <customer_attribute_groups_file>etc/commerce-to-commerce/customer-attribute-groups.xml.dist</customer_attribute_groups_file>         <sales_order_map_file>etc/commerce-to-commerce/map-sales.xml.dist</sales_order_map_file>         <delta_document_groups_file>etc/commerce-to-commerce/deltalog.xml.dist</delta_document_groups_file>         <customer_attr_map_file>etc/commerce-to-commerce/customer-attr-map.xml.dist</customer_attr_map_file>         <customer_attr_document_groups_file>etc/commerce-to-commerce/customer-attr-document-groups.xml.dist</customer_attr_document_groups_file>         <order_grids_document_groups_file>etc/commerce-to-commerce/order-grids-document-groups.xml.dist</order_grids_document_groups_file>         <class_map>etc/commerce-to-commerce/class-map.xml.dist</class_map>         <visual_merchandiser_map>etc/commerce-to-commerce/visual_merchandiser_map.xml.dist</visual_merchandiser_map>         <visual_merchandiser_document_groups>etc/commerce-to-commerce/visual_merchandiser_document_groups.xml.dist</visual_merchandiser_document_groups>         <visual_merchandiser_attribute_groups>etc/commerce-to-commerce/visual_merchandiser_attribute_groups.xml.dist</visual_merchandiser_attribute_groups>         <map_document_groups>etc/commerce-to-commerce/map-document-groups.xml.dist</map_document_groups>         <tier_price_map_file>etc/commerce-to-commerce/1.14.4.2/map-tier-price.xml.dist</tier_price_map_file>         <stores_map_file>etc/commerce-to-commerce/map-stores.xml.dist</stores_map_file>         <!--         In case bulk_size=0 it will be auto-detected for every document.         -->         <bulk_size>100</bulk_size>         <!--         Set direct_document_copy = 1 for better performance.         NOTE: 'source' and 'destination' databases MUST be placed on the same MySQL instance         and 'destination' user MUST be granted with 'SELECT' permissions on 'source' database          -->         <direct_document_copy>1</direct_document_copy>         <source_prefix />         <dest_prefix>abc123_</dest_prefix>         <auto_resolve_urlrewrite_duplicates>1</auto_resolve_urlrewrite_duplicates>         <log_file>migration.log</log_file>         <progress_bar_format>%percent%% [%bar%] Remaining Time: %remaining%</progress_bar_format>         <upgrade_customer_password_hash>1</upgrade_customer_password_hash>         <edition_migrate>commerce-to-commerce</edition_migrate>         <edition_number>1.14.4.2</edition_number>         <init_statements_source>SET NAMES utf8;</init_statements_source>         <init_statements_destination>SET NAMES utf8;</init_statements_destination>         <crypt_key>REMOVED</crypt_key>     </options> </config> 

It appears that the data migration tool is trying to delete records from that table without using the proper prefix for the destination site. Am I missing a setting here or is this some kind of bug?

Site / tool to contact multiple study participants with their IDs after pseudonymization

For this multiple-weeks research study with an early access app, a pseudonymization process is used to disconnect the participant’s emails from their data with a random ID.

I need to contact those people after they registered through the pre-form and provide them with the app link and their ID. They will need it to fill out the post-form and provide the ID so the data of this second form can be connected to the data of the first.

Now the thing is that I have about 60 people and it would be annoying to send each of them an individual mail with their ID.
Can anyone recommend something that would make this easier?
To somehow automate the process of sending out the correct ID to the correct email?


I’ve thought about tools like Mailchimp, but you can only dynamically reference variables that the user provided (e.g. name or gender).

Tool to prepare report of security auditing

I was doing dorking on my friend’s website to make sure there is no leak of information that is not meant to be. I found domains and sub-domains in search results.

Is their a tool which can help me to prepare the report? Report like domains and subdomains are represented in some graphical format something like tree structure?

And also what tools should be used to capture details during target enumeration phase?

Border Radius Preview Tool

I am running through an app idea to help improve my knowledge of Javascript. The code attached performs the following:

  • Performs a regex on the input field to check it is value 0-9 If not,
  • it clears the field and shows a warning (Although this only seems to work on FF)

  • If it passes, updates the styles of the preview box on keyup

  • Adds the styles to a text area that the user can copy when selecting the button

I am looking for suggestions where I can improve in terms of writing more efficient code. Or pointers where I have possibly used the wrong method to perform a task. One area where I struggled was getting the value of the input field.

This is the first stage for this application as in the near future I plan to add in the ability modify each corner.

Feedback is welcomed

"use strict"  const masterField = document.getElementById('masterField'); const box = document.getElementById('box'); const warn = document.getElementById('warn'); const styleSheet = document.getElementById('styleSheet');  const WARNING_TIME = 2000; var warningTimer;  masterField.addEventListener('keyup', updateCss);  function updateCss() {     let inputVal = this.value;     console.log(this.value);     const expCase = /[0-9]/;      if (expCase.test(inputVal)) {         box.style.borderRadius = inputVal + 'px';         styleSheet.textContent = 'border-radius: ' + inputVal + 'px';     } else {         this.value = '';         showWarning();     } }  function hidewarning() {     warn.classList.add('hide-warning'); }  function showWarning() {     clearTimeout(warningTimer);     warningTimer = setTimeout(hidewarning, WARNING_TIME);     warn.classList.remove('hide-warning'); }  function copyStyles() {     styleSheet.select();     document.execCommand('copy'); }
#box {             width: 300px;             height: 175px;             background-color: red;         }          #warn {             display: block;         }          #warn.hide-warning {             display: none;         }
<div id="box"></div>     <div>         <label for="masterField">All Corners</label>         <input id="masterField" class="radius-field" type="number">         <span id="warn" class="hide-warning">Only numbers 0 - 9 are allowed</span>     </div>      <button onclick="copyStyles()">Copy Styles</button>      <textarea id="styleSheet"></textarea>