Category: Tools

Send data from WordPress (and other PHP sites) to Dynamics CRM/CE

On of the easiest ways to capture data from WordPress and other PHP based sites and send it to Dynamics CRM/365CE has to be the PHP Toolkit created by AlexaCRM. They have two tools available for use for free.

  1. PHP Toolkit
  2. WordPress Plugin

    WordPress Plugin for Dynamics CRM

    If you have a WordPress site, connecting to Dynamics CRM/D365CE is a 10-minute exercise. Install the WordPress plugin on your site, create a form in Dynamics with a distinct name, add a page in WordPress and put the following shortcode snippet in the code editor.

    Unexpected error: An exception has been thrown during the rendering of a template ("Authentication failed: AADSTS7000222: The provided client secret keys for app 'db75707e-ae4f-49aa-bc64-3306f4a65382' are expired. Visit the Azure portal to create new keys for your app: https://aka.ms/NewClientSecret, or consider using certificate credentials for added security: https://aka.ms/certCreds. Trace ID: 2e49fe91-e818-4112-a57e-7e1b8657ae00 Correlation ID: 38d08d14-e1bf-490c-9d08-e2ea9aac56f5 Timestamp: 2024-04-18 19:14:36Z") in "template_b04d9354c3b12a2bacb8b36ae5ef9855510e5525".

    In the code above, replace the “Contact Card” with the name of your form in CRM. That’s it!

    Other PHP based sites

    If you have any other PHP based site like Joomla or Drupal, you can use the PHP Toolkit to connect Dynamics CRM/365CE to your site. Put the toolkit libraries into a libraries folder and you can call them from any page since it’s PHP. AlexaCRM has made examples available on their GitHub page.

    Filed under: Blog, Dynamics 365/CRM, Tools

    Project Management Process Guidelines Flowchart

    Use these flowchart diagrams as a visual aid to help understand the project management methodology. The diagrams show parallel and interdependent processes, as well as project lifecycle relationships.

    Initiation Processes Flow

    Planning Processes Flow

    Executing Processes Flow

    Monitoring & Controlling Processes Flow

    Closing Processes Flow

    Credit: https://www.itplanning.org.vt.edu/pm/processflow.html

    Filed under: Blog, Tools

    How to insert data from Excel to MS SQL quickly

    I have used this tool a few times and honestly, its a lot quicker than the “Import and Export Data” tool or the “Generate Scripts” option under Tasks. This is a tool built by Perceptus Consulting to import data from Excel into an existing SQL table quickly. It just gives you the import script and you can modify it as you like. You can modify the script to make the transaction explicit, or simple add more statements to the script. It’s simple and a lot safer than running unreliable wizards.

    Here is the tool:

    https://tools.perceptus.ca/text-wiz.php?ops=7

    Filed under: Tools