Microsoft CRM and Scribe in perfect symbiosis

Microsoft CRM and Scribe in perfect symbiosis

About this Blog

In this Blog I will gather information about Microsoft Dynamics CRM and Scribe.

Any issues I might come across will be highlighted and a solution/workaround will be given.

Scribe Update Notifier has stopped working

ScribePosted by Niels Poulsen 2016-11-03 10:07

This service will check for updates to you Scribe Insight solution.

If you get the message "Scribe Update Notifier has stopped working" when logging on to the Scribe server, you need to check the Event viewer.

As shown in below pictures, the error occurs if the "Long date" contains the name of the day (Thursday, November 3, 2016). This can't be pharsed as "Date".

The system format of the server have to be change to a "Long date", that do not contain the weekday.





Using Scribe to write to SQL tables with spaces in the table name

ScribePosted by Niels Poulsen 2016-04-22 07:56

When using a SQL ODBC connection to write to a table, that have spaces in the table name, you will get an error.

The solution is to use the Scribe OLE DB adapter to connect to the database.


Use this connection setup:

Data Source = The name of the ODBC to the database

Initial Catalog = The name of the database

User = Name of the user

Password = The password for the user

Additional Connect Parameters: = Blank

Use Owner In Queries: TRUE



Ensuring data is recived by the ERP-system

ScribePosted by Niels Poulsen 2016-04-22 07:52

This post will show you how to ensure, that data are imported from CRM to an ERP-system (ex. Navision).

Whenever you are importing data from CRM to ex. Navision, you would like a handshake, that data actually are imported to the other system.

There are several scenarios, but I’ll only show two for now.

Scenario one: (using CRM and Navision adapter)

Account from CRM should be imported to Navision.

Job one

a. Step one in Scribe is update/insert in Navision

b. Step two in Scribe is to update the source account in CRM with a status “Sent to Navision” and a date for the update/insert (custom fields)

If the update/insert is successfully, the source in CRM will show this in the two new custom fields.

Scenario two: (using CRM adapter and XML-files to ERP system)

Account from CRM should be imported to ERP system. (no adapter available)


Job one

a. Step one in Scribe is to insert into a XML-file, which is placed in a specified file location on the network.

Step two in Scribe is to update the source account in CRM with a status “Sent to ERP-system” and a date for the insert (custom fields)

If the insert is successfully, the source in CRM will show this in the two new custom fields. We are now sure, that the XML-file has been placed in the specified folder.

Job two

a. When the ERP-system has imported the XML-file, a new XML-file is placed in another folder on the network.

b. An integration process in Scribe Console looks for files in the specified folder. Whenever a XML-file is in the folder, the handshake is made to the account in CRM. She Scribe job update the account with status “Accepted by ERP-system” and date for this accept (new custom field)

We are now sure, that the XML-file sent to the ERP-system has been placed in the specified folder and that it have been acpted.