Integrating Dynamics 365 ERP and CRM – Using Microsoft Flow and Common Data Service

 Why can’t we just sync data between CRM and ERP using Microsoft Flow only? why do we need to use Common Data Service?

Dynamics 365 unifies CRM and ERP capabilities into applications that work seamlessly together across different areas of a business. Two main components of Dynamics 365 are CRM and ERP applications.

For customers who use both CRM and ERP applications (for example, Dynamics 365 for Sales and Dynamics 365 for operations), it is important that these applications integrate and work together and one option for customers/partners is to use Microsoft Flow and Common data service(CDS)

In most cases, mapping of data between these products cannot be done directly. Same data may be stored in different ways or formats in these applications.

A simple example is, how Currency is used: In Dynamics 365 for Sales, Customer’s currency is stored with currency name as US Dollar whereas, in Dynamics 365 for operations, same data is stored with currency code as USD. In such cases, we can have a staging database in CDS to map as required in the destination application.

Very well explained, full article is here

https://suvidhablogpost.wordpress.com/2017/03/29/integrating-dynamics-365-erp-and-crm-using-microsoft-flow-and-common-data-service/

Sending email by using Python

#This is the code for sending email using Gmail and Python

# Import smtplib for the actual sending function
import smtplib

# Import the email modules we'll need
from email.mime.text import MIMEText

# Open a plain text file for reading.  For this example, assume that
# the text file contains only ASCII characters.
textfile = 'content.txt'

fp = open(textfile, 'rb')
# Create a text/plain message
msg = MIMEText(fp.read())
print msg
fp.close()

me = 'youraccount@gmail.com'
to = 'recipient@gmail.com'

msg['Subject'] = 'The contents of %s' % textfile
msg['From'] = me
msg['To'] = to

# Send the message via our own SMTP server, but don't include the
# envelope header.

#You need to turn on 'Allow less secure apps' to get access to the smtp server
#https://myaccount.google.com/lesssecureapps?pli=1


server = smtplib.SMTP_SSL('smtp.gmail.com', 465)
server.ehlo()

gmail_user =  'youraccount@gmail.com'
gmail_password = 'password'

server.login(gmail_user, gmail_password)
server.sendmail(me, to, msg.as_string())
server.quit()

Turn on 'Allow less secure apps' to get access to the smtp server

Connecting Power BI with D365

VicRoads Traffic Camera Live

Installing MDAC 32 bits on Windows 64 bits

I am trying to read xlsx file through CodeReady which requires ODBC 32bits. When installing MDAC 2010 32 bits on a Windows 10 64 bits, it ended up with a warning.

You cannot install the 32-bit version of Microsoft Access Database Engine 2010 because you currently have 64-bit Office products installed. If you want to install 32-bit Microsoft Access Database Engine 2010, you will first need to remove the 64-bit installation of Office products. After uninstalling the following product(s), rerun setup in order to install 32-bit version of Microsoft Access Database Engine 2010:
Microsoft Access database engine 2010 (English)

It seemed to be a nightmare. But the solution was far simple than that. I didn't uninstall everything 64bits. All I need was to install the 32 bits driver in the command line with the magic parameter /passive

AccessDatabaseEngine.exe /passive

It was just as simple as that. It was done nicely without giving me a headache.

It was a happy day!

Microsoft Dynamics AX Workflow

A very clear demonstration from setup to application.

Using ODBC with classic ASP in IIS

I have a website developed in classic ASP with ADO. Basically, the IIS in Windows 10 (64 Bits) still supports running ASP. You will able to run ASP pages after installing the IIS with ASP enabled.

Go to Control Panel > Program > Programs and Features > Turn Windows Features on or of > Internet Information Service > World Wide Web Services > ASP

It is now all set for ASP pages.

However, there is still one more thing to do for running a ASP page with ODBC connection. 

Working with 64-bit Systems

Unfortunately there are no 64-bit ODBC drivers, so on 64-bit systems you will have to run your applications in 32-bit mode. To do so, use the following steps:

1. On the taskbar, click Start, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.
2. In the Connections pane, click Application Pools.
3. Highlight the application pool for your application, then click Advanced Settings... in the Actions pane.
4. In the Advanced Settings dialog, specify True for Enable 32-Bit Applications.
5. Click OK to close the Advanced Settings dialog.

https://docs.microsoft.com/en-us/iis/application-frameworks/running-classic-asp-applications-on-iis-7-and-iis-8/using-classic-asp-with-microsoft-access-databases-on-iis

It is all done.