SplitFile: splitting large text files

I have been working on a project for the last three months where large script files with millions lines of rows is scripted from a database. These script files often contains errors due to data from the old database that don’t fit into the new database.

The largest script files is up till 6GB and difficult to handle with with editors I have available – even in UltraEdit. Therefore, I have been looking for a proper tool for splitting these large files into smaller chunks. 10 years ago, I had some windows toools ported from UNIX, but I couldn’t find them any more, and had to write the tool myself.

I needed a tool that splitted a large file into smaller files with a number of lines or had a maximum size. In addition, it was desirable to be able to just pick a line range from the large file and write these lines into a new file.

Here is example executions with command line parameters:

SplitFile /INFILE:"C:\TFS\SplitFile\Lines.txt" /MAXSIZE:250
SplitFile /INFILE:"C:\TFS\SplitFile\Lines.txt" /MAXLEN:100000
SplitFile /INFILE:"C:\TFS\SplitFile\Lines.txt" /PICKLINES:100,150

Download source code: SplitFile.zip


Enable tracing/logging in Microsoft CRM

Today, I found a nice updated article “How to enable tracing in Microsoft Dynamics CRM” describing how to enable logging and tracing troughout Microsoft CRM. This article descibes both CRM4 and CRM2011.

It descibes how to enable logging and tracing capabilities by Registry settings and XML configuration files.

Disable Internet Explorer Enhanced Security Configuration (IE ESC)

Are you tired of Internet Explorer enhanced security using Windows Server 2003 or 2008 developer enviroments? Until recently, I haven’t used Windows Server in my developer virtual machines, but I have started with Sharepoint 2010 development and found it appropriate to start using Windows Server 2008.

The screenshot below show the annoying pop-up when using IE within your Windows Server 2008 developer Virtual Machine.

To disable this security setting, you have to open the “Server Manager” that is found under “Administrative Tools”. In the “Security Information” section you find a link named “Configure IE ESC”.

Windows Server 2008 - Server Manager

Windows Server 2008 – Server Manager

When selecting this, the following dialogbox is shown. My developer VM don’t need these enhanced security settings, but If you do’t know the risks of removing this setting don’t do it. When doing development I normally use known web resources and don’t need additional web security. My settings is show below. I have disabled for both administrators and user group, but it’s an option to only disable the administrators and leave the security for users.

IE Enhanced Security Configuration

IE Enhanced Security Configuration

 Happy coding!!