Looking for PowerObjects? Don’t worry, you’re in the right place! We’ve been part of HCL for several years, and we’ve now taken the final step in our acquisition journey: moving our website to the HCL domain. Nothing else is changing – we are still fanatically focused on Microsoft Business Applications!

PowerObjects Blog 

for Microsoft Business Applications


Manually Editing the Scribe QETXT.ini File for Microsoft Dynamics CRM

Post Author: Joe D365 |

When migrating large text files with many columns in Microsoft Dynamics CRM using Scribe Insight, sometimes it's more efficient to manually edit the QETXT.ini file. A good example of this would be when migrating from text file exports from Salesforce.com to Microsoft Dynamics CRM.

How many times have you set up a connection to a text file using a sample file only to later get the full data set and realize all of your columns are too small or of the wrong data type? You can save yourself time and energy by manually editing the QETXT.ini file. The QETXT.ini is a text file that is created automatically when using the Scribe Text Wizard to create a connection to a text file.

To see an example of the QETXT.ini, you can navigate to the TextData samples that get installed with Scribe Insight.

Scribe QETXT

In this example, we will be using the sample Company.dts that Scribe provides to illustrate how to change the QETXT.ini. When using the Scribe connection wizard to define text connections, it will define the length of any characters fields by default to the longest value in the current file. We want to change all character columns to a length of 100.

  1. First let's look at the column definitions prior to editing. Notice the column lengths vary and were likely set automatically by the column lengths at time of first connection.

  2. Now open up the QETXT.ini and edit the column lengths. Notice each new text connection is started with the connection name in brackets [ ].

  3. For each VARCHAR field, change the length to 100 in two locations.

  4. Repeat until all VARCHAR fields have been updated.

     

     

  5. That's it! Once you re-open the Scribe job, you will see that all of the column lengths have been updated.

     

As you can see, editing the QETXT.ini file manually can save you time while importing data into Microsoft CRM using Scribe. Try it out for editing columns lengths, data types or even data masks.

Happy CRM'ing!

Joe CRM
By Joe D365
Joe D365 is a Microsoft Dynamics 365 superhero who runs on pure Dynamics adrenaline. As the face of PowerObjects, Joe D365’s mission is to reveal innovative ways to use Dynamics 365 and bring the application to more businesses and organizations around the world.

PowerObjects Recommends