My Dynamic World

I used to capture results in an conditional statement to clean up reports.  It is still useful, when you want hide conditional statements. =IIf(<expr> = 0, "",  <expr>   ) However, I was considering the option numeric values have, to hide 0 values.  Which is:  0;(0);'' Now to hide the percentage format, use this:  0.0%;(0.0%);''

The 1.5 version of the adapter is not 64 bit compatible and uses the more stable NAS to read and write to NAV. I ran across this yesterday, with scribe support we upgraded one of the NAS's to 1.5 (upgraded to 1.4 first) and it works fine.  However, the help file for 1.5 only states to move these files: Scribe.NavAdapter.NasHook.dll Scribe.NavAdapter.NasHook.tlb Scribe.NavAdapter.NasHook.XmlSerializers.dll ScribeNasSettings.xml Scribe.MSXML4.dll \ScribeModifications \ReleaseNotes However, the additional NAS's will fail when attempting to connect to them in the workbench.  You also need to copy these files, which were installed in the 1.4 upgrade.  I suspect since the 1.5  adapter  no longer uses C/Side that these libraries need to be in the  install  directory for each NAS. AuthHelper.dll Interop.AuthHelperLib.dll These files are not listed in the help file for 1.5.  This should not be an issue if you upgraded all of...

Scribe has the ability to insert SQL queries against a source or target (which does not have to be a database for Scribe).  This works great when searching against distinct values. However, what if you need to format a source field to strip out and prefix text, then match it up to a larger field?  In SQL you can declare a variable and perform a LIKE statement. Plugging that statement into Scribe will cause it to fail.  Here is the workaround. Format the source variable, and save it as a calculated variable to call later. RIGHT( S1, LEN(S1)-SEARCH(" ",S1  ) )  = cvTrim Then call your query. SQLQUERY( cv_Trim, "T", "SELECT [TableField] FROM [Database].[dbo].[Table] WHERE [TableField] LIKE '%' + '%s' + '%' " ) %s references the source field.

GUID - Stripping the brackets off of a target variable. REPLACE(REPLACE( TargetVariable ,1 ,1 ,"" ), 37 ,1, "")

This occurred when upgrading the Scribe integration product, along with changing the connection settings to a test environment. In this process, MSMQ messages were critical in processing the publisher bridges that create and pass XML messages to a hosted service. The queue for the message service was unable to process them due to the update, and ended up filling the queue, in several private message queues. The total amount of messages was over 1 GB. You can clear the messages from the MSMQ MMC, but if the process is failing due to resources, which this was, it will create dead-letter messages which have to be addressed. Backup the .mq files Note Before you run MQbkup.exe, select a folder to which you will back up the Message Queuing files. This folder must be located on a disk that has at least 2.5 GB of available space. Open a Command Prompt window. Change the directory to %WinDir%\System32. Run the following command: MQbkup.exe -b Drive :\ Folder to Put Backup Files Note t...

We need to create a way to capture the global parent account on the account entities for reporting. Since the accounts were already created, this would need to be enforced after the fact. This solution will work if you need to create a data relationship for any fields you want to add. It is not an elegant solution, but it works. The attribute or field that was created needed to have a relationship tied to the account. So, I created a many to 1 (N:1) attribute to hold the global parent f ield. I made this field a business recommended, as it would be on all forms. The workflow, that I will explain later, can be set to fire on an account create action to tie the created account to the global parent account. Here are the settings of the attributes. Since there was already a parental relationship set with the account entity, a referential enforced relationship would have to be created. In t his instance, this will be fine, as we do not want a tied record to be altered if the global pa...

Use this at your own risk. Ever want to change the loading icon from the green circle... to something more interesting? Well I found a great loading icon for CRM over at Ascentium, http://consulting.ascentium.com/blog/crm/Post189.aspx . Goto your CRM webserver, and open \CRMWeb\_imgs\AdvFind in Windows Explorer. Make a copy, or rename progress.gif. Save the graphic above as progress.gif to that directory. Clear your IE cache and the new icon will appear when you perform search or loading functions.