How to Compare CSV Files or Compare a CSV File to a Database Table

CSV files are a quick and convenient way to record structured data in a generic format. Because CSV files are so easy to create, multiple similar versions of very large CSV files can quickly proliferate. Often it becomes necessary to compare CSV files to find the desired version. In an ETL (Extract Transform Load) scenario, a data analyst may want to compare a CSV file to a database table for validation or to update data.

DiffDog, the unique XML-aware diff / merge tool from Altova, supports CSV as a native file format for comparison and can compare and selectively merge data CSV to CSV, or between a CSV file and database table. Let’s look at an example.

Read more…
Tags: , , , ,

Automate Word Document Comparison in Busy Enterprises

Many enterprises and business situations leverage Microsoft Word documents in standardized formats, with variations in content in subsequent versions. Think of contracts or other legal documents, status reports, test results, lists of rules, and many others. These documents may even be generated through automated processes. Manually identifying and reporting changes between versions would be a cumbersome process. Altova DiffDog Server provides an efficient, automated solution.

DiffDog Server brings the file and directory comparison power of Altova DiffDog to high-performance servers, making it easy to automate Word document comparison and generate diff reports comparing files, directories, or URLs, and even Word documents (.docx) saved in MS Office versions 2007 or later.

Let’s look at a Word document comparison.

Automate Word document comparison with DiffDog Server
Read more…
Tags: , , , , ,

Automate Diff Report Generation

DiffDog Server makes it easy to automate high-volume comparisons and generate diff reports comparing files, directories, and URLs. This high-performance server software is available for Windows, Linux, and MacOS X machines.

Developers have long relied on DiffDog for comparing XML, text, and binary files, as well as directories and URLs. Now, the power of DiffDog is available in lightning-fast server software for easily automating large comparison tasks.

For instance, DiffDog Server is perfect to automate diff report generation for critical files and directories at a given time – every day, once a week, etc.

Read more…

Tags: , ,