Mergemill Pro 4.1

Mergemill Pro 4.1 offers users with an effective yet beneficial tool which is designed to take diverse sources of data, such as databases, web pages, e-mails and more, and then merge them with templates to produce the desired output, from web pages to customized e-mails. The program features powerful data-processing capabilities such as data filters, multi-level data sorting, BASIC scripting, and multiple search-and-replace actions. 

It supports Unicode and other text encodings, and has project scheduling and auto-run functionality. You can control output in templates through scripting with tags for content insertion, arithmetic expressions, looping, branching, statistic calculations and for marking text blocks for variable assignment or special output actions. 

1. Data Input from Diverse Sources
   • Local text file
   • Remote text file, via FTP
   • Local folder of text files
   • Remote folder (or directory) of text files
   • Emails from a Hotmail or standard POP3 account
   • Web page, by specifying its URL
   • A list of webpage URLs in a text file
   • ODBC-compliant SQL data source
   • Local RealSQLDatabase
2. Diverse Output Options
   • Add records to or update records in an ODBC-compliant SQL data source.
   • Generate plain or formatted text files with an option to automatically upload them to an FTP server as well.
   • Easily export data to tab-delimited text files, CSV text files, or XML files, with an option to upload them via FTP.
   • Build and send mass personalized email messages.
   • Read out the generated text using the speech synthesizer available in the operating system.
3. Powerful Data Processing Options and Features
   • Include filters allow you to set conditions to include or exclude certain data values.
   • Fetch filters allow you to fetch from each data value the text strings that meet the conditions you specify.
   • Multi-level data sorting: all columns of data values from the same feed are sorted together.
   • 12 basic processing options that can be turned on or off using simple checkboxes: trim spaces, convert to lowercase, ...
   • Search and replace text strings in data values. There is no limit to the number of search-and-replace actions to be applied to each data value.
   • Add your own data processing code in BASIC to be compiled, run, and applied to data feeds. Mergemill Pro features RBScript in REALBasic, which is very similar to Microsoft Visual Basic.
4. Embedded Scripting with Just a Handful of Easy-to-Learn Tags
   • Field tag
   • • Field attributes may be used together. They control the actual text from the data value to be inserted.
     • • UCase: returns the data text in uppercase
       • LCase: returns the data text in lowercase
       • TCase: returns the data text in titlecase, i.e., initial caps
       • AWords,nn: returns the first nn words of the data text
       • ZWords,nn: returns the last nn words of the data text
       • Left,nn: returns the first nn characters of the data text
       • Right,nn: returns the last nn characters of the data text
       • Mid,ss,nn: returns the nn characters of the data text, beginning at ss
       • Count: returns the total number of data values in the data column of the current stream for the field
       • Position: returns the position number of the current data value in the data column for the field
     • Lookup extension makes it very easy to use a lookup list.
     • Result number format enables you to control how the data value as a number is to be inserted.
     • Data value position offset lets you easily create multi-column lists in your output.
   • Arithmetic expression tag
   • • It allows you to perform basic arithmetic calculations to cover your regular data processing needs.
     • An operand can be a number, a field (which means its current data value), a system value like PageNum, a statistical function, or a variable.
     • Accepted operators are sum (+), difference (-), multiply (*), floating point division (/), integer division (), remainder (%), and the exponential (^).
     • You may use parentheses to change operator precedence.
   • Statistical function tags
   • • Basic statistical functions include maximum, minimum, count, sum, average, sample standard deviation, and population standard deviation.
     • Linear regression functions include the constant term, regression coefficient, and the correlation coefficient.
   • Looping tags
   • • They are the important tags that enable you to generate a list in an output.
     • You may set a loop break count, or use the tag to break a loop, or simply let Mergemill Pro break the loop at data stream boundaries by default.
   • IF and CASE branching tags
   • • You may nest them up to 100 levels deep.
     • The special tag performs a look-behind comparison.
     • You may include a data value position offset in the and tags to perform a look-ahead comparison.
   • System value tags
   • • Easy insertion of system date and time values, as well as page URLs and page number.
     • , , , , , , , , , and .
   • Section tags
   • • Use Variable assignment tags to initialize and change variable value, and use the Variable insertion tag to insert value into the output.
     • Use the Hide section tags for comments, spacings, or field tags that you don't want to appear in the output.
     • Use Speech section tags to mark blocks of output text to be spoken out.
     • Use Email section tags to mark the block of output text for each part of the email to be sent: from, to, cc, bcc, subject, HTML message, and plain text message.
5. Other Very Helpful Features
   • Mergemill Pro features extensive support of Unicode and other text encodings. So long as you specify the text encoding of all your data sources correctly, the software can work with feeds, templates, and outputs in any language.
   • Mergemill Pro manages jobs by projects. You can drag and drop jobs between projects, and drag the jobs to change their run order.
   • Projects can all be set to autorun at scheduled times.
   • If a job you want to add is like any one you have done, just duplicate the existing job, then edit the copy. This saves a lot of time.
   • Sometimes setting up a complex job and its associated tasks can be daunting. Mergemill Pro’s extensive red-dot system alerts you to errors in your job and task settings. Just follow the dots to fix them one by one and you can easily create valid jobs. This enables you to focus your effort more on template designs to create useful solutions that solve real problems.
   • The Mergemill Pro software package includes a Dreamweaver extension for constructing and inserting Mergemill tags into templates you develop using Adobe Dreamweaver.

• Mac OS X Intel (10.5 or above)