D T U t i l i t i e s  
DATA TRANSFORMATION SOFTWARE TOOLS
 
 

Extract data from multiple sources :

  bullet  files   bullet  emails   bullet  web pages

Organize the data and transmit it to database records and/or files with :

  DTBuild  data transformation development workshop download button 1.9 MB  register button $100.00 USD  more info »
  DTRun runs transformations created with DTBuild download button 1.1 MB  register button $10.00 USD  more info »

For an idea of what it can do and how it works:  see the examples.

Download the appropriate program - DTBuild or DTRun, then :

 
Web scraping samples: Location:  
Web page title + header scraper - news headlines installer more »
Web page number scraper - stock quotes installer more »
HTML table parser - U.S. Census Bureau, state population + area download button more »
Multiple table parser - U.S. Census Bureau zip code data download button more »  

Extract information from the Web

DTBuild can fetch web pages, parse them and extract selected information.   This extraction of information from web (HTML) pages is known as web scraping.

In general, the web scraping samples scan one or more web pages and collect the results in a single database table or HTML file.

 
Email parsing samples:    
Search for words in folders installer more »
Search for word pairs in folders installer more »
Parse generated emails into a database - eBay example installer more »
 more email parsers »

Extract information from emails

DTBuild can scan stored email folders in MS Outlook and other email clients that use the Windows Messaging Application Programming Interface (MAPI).  

Use DTBuild to generate database records from formatted messages sent by eBay, PayPal, Amazon.com, etcetera.

 
File transformation samples:    
Text search - produces HTML + text output, + result summaries installer more »
Text search and replace installer more »
Count lines installer more »
Count keywords installer more »
Convert carriage return + line feed pairs to line feeds installer more »
Convert line feeds to carriage return + line feed pairs installer more »
Generate a website index from HTML files installer more »
Filter unprintable characters from files installer more »
Import comma-separated values (CSV) files into a database more »
Import PDF files into a database more »
 more file transformers »

Transform files

Use DTBuild to :

  • search files
  • replace data in files
  • convert old (legacy) formats
  • repair incorrectly formatted data
  • count lines, words, keywords, + other user-defined patterns

+ more.

 

Command line program DT runs DTBuild definitions.   Use it wherever command lines are used :

  • batch files
  • Windows shortcuts
  • Windows Scheduled Tasks

DTBuild is also packaged as a Windows DLL (dtlib.dll) and can be called by other Windows programs to transform streams of data.

DTBuild can be extended with custom programming.   See the development tools topic for more information.


These tools can eliminate a lot of tedious, error-prone manual data entry.   Let the machines do the work!

Configure it yourself, adapt the samples, or request help.

DTBuild's flexible design delivers a single tool that can scrape the web, transform files and parse emails.   Download it now or contact DTUtilities support for more information.


 

 www.dtutilities.com © 2002-2010 DTUtilities All rights reserved.