B+B Systems, LLC
627 Madison
Waukesha, Wisconsin  53188
262-522-2869
E-Mail

DOALL - access any .dbf file
Easy/Powerful Database to Edit, Delete, Sort or Select data in ANY .DBF file
A self-contained, customizable database for any .dbf type file for Mailings, Telemarketing, Sales Leads,
Mailmerge Files for MSWord, Reports, Labels, Fast Search/Replace for mass changes, etc.

Download DOALL    Demo+Upgrades (06/20/2008)

User Manual (.DOC file) (opens in your browser if you have MS Word)

Network/Workstation Installs & FAQ

MelissaData - Address Object guide, support files - address validation

Microsoft site - download ODBC drivers (.msi file) for use with SQL Server functions

Order MapPoint usage licenses

Use PayPal, or remit checks to: B+B Systems, LLC, 627 Madison, Waukesha, Wisconsin  53188
(Annual licenses include ability to link to other DataBases, such as SQL Server, Oracle, Access, etc.)
Print mail-in order form

Our most popular product.
Make it easy for users to view data. You can use it with any .dbf type file.  Or, use the sample files included.  The sample files are a master customer and contact files.  These sample files are "related to one another" - parent and child.  This means that without any further setup, you can use Doall as a contact database with the ability to store/view multiple contacts for customers, or multiple contact names, or multiple locations for a customer, etc.    

With this system you can make it easy for end-users to customize how data is displayed using custom colors, fonts, sorts, field sequencing, all specific to each .dbf file.  The system remembers the next time you use that .dbf file.  Easy manipulation tools. 

Would you like to see your "master" records and related "child" records easily & quickly?  Use with ANY .dbf files.  -  Comes with sample master/child related .dbf files

Sample - Startup Screen (with sample parent/child database)

* Use the SAME system for accessing all of your .dbf type files

* GRAPH data from any .dbf table
    Bar graph
    Pie Chart
    Line Chart
    3-D
    Cross-Tab/Cross-tabulation Graphs
    Graphs with left & right side descriptions

* FAST - Uses SQL for counting records, labels and reports

* On-the-Fly Encryption - Incorporates Xitech encryption technology
Mode 1 - For sensitive data, Doall can encrypt a .dbf, then, when the data is loaded by a Doall user, it is Automatically un-encrypted in memory.  It is always in an encrypted state on the hard drive.  No one can read the data outside of Doall.    In addition, if you install password protection, you can restrict who can use Doall.
Mode 2 - For any sensitive file, Encrypt or Unencrypt any type of file on your hard drive, including .dbfs.
You can run "setdefaults.exe" to select encryption level.

IMPORT THESE FORMATS:
Comma Delimited ASCII (txt)
Comma Separated Value (csv)
Standard Data Format (Columns) ASCII (sdf/txt)
FoxPro/dBase (dbf)
FoxBase 2x plain MEMO (dbf)
Lotus 1-2-3 (wks)
Data Inter. Format (dif)
Multiplan v4.01 (mod)
Excel ver. 2-4 (xls)
Excel ver. 5-> (xls)
Symphony v1.1 (wr1)
Paradox v3.5 (db)
FrameWork II (fw2)
Rapid File (rpd)
XML to Cursor/Table 

EXPORT THESE FORMATS:
Comma Delimited ASCII (txt)
Comma Separated Value (csv)
Standard Data Format (Columns) ASCII (sdf/txt)
FoxPro/dBase (dbf)
FoxBase 2x plain MEMO (dbf)
Lotus 1-2-3 (wks)
Data Inter. Format (dif)
Multiplan v4.01 (mod)
Excel ver. 2-4 (xls)
Excel ver. 5-> (xls)
Symphony v1.1 (wr1)
Wordstar/NewWord MailMerge (txt)
MS WORD MailMerge (txt)
WordPerfect MailMerge (txt)
Word Writer MailMerge (txt)
WordPlus-PC MailMerge (txt)
Smart MailMerge (txt)
Cursor/Table to XML
Cursor/Table to Simple HTML
Cursor/Table to Cross-Tabulation
Cursor/Table to ClipBoard (Tab delimited - This format can be "pasted" in Excel/Spreadsheets)
Cursor/Table to ClipBoard (Space delimited)

* Produce output using any sort, any record selection, any fields.

* Convert data - Import spreadsheets/Word Processing, XMLtoCursor(), and many of the same formats (above).

* Displays memo field/notes while browsing thru records.

* Search any field, value within field - Replace with any value.

* MASS FAX a Word DOC or WinFax Cover page to individuals/groups

* Search memo type fields

* Duplicate check, phonetic and exact matches

* Add, Change, or Delete any data base fields

* When adding records, have any data repeated

* Use "Lookup" F2 function in any field in Browse screen, say for ZIP CODES. Data from "ZIP" help file can then be transfered to main file.

* Automatically Dial Phone numbers (thru modem), pick up phone, then after call
        -prompts for entering notes
        -prompts to update callback date,
-track call activity in ACTION1, ACTION2-5 fields

* If CALLBACK date field exists, pending callbacks will pop up

* Get record COUNTS for selected records

* Sample data files provided are RELATIONAL: sample.dbf and contacts.dbf are linked by the custno field
allowing multiple "contact" records for each "sample" record (You can customize any of these fields, in either file, for your use).

* Proportional font sizing based on row height for the visually impaired. Simply expand row height, and all font sizes increase.

* Microsoft's Text-To-Speech (TTS) engine
For the visually handicapped,  B+B Doall allow you to use Microsoft's Text-To-Speech (TTS) engine.   You can elect to have the "captions" or titles on the buttons read to you, or the "tooltip" for a button when your mouse moves over the button.   In addition, you can elect to have the data in your data file read to you.  If you elect this option, when your mouse enters a row of data, the "field" name (name of the data column) will be read, followed by the reading of the actual data.

* Doall can Reverse-Engineer text files with an unknown structure.  A "best effort" will be made to determine the "likely" structure of text file.   The text file can be either comma delimited, delimited with another character, or in Standard Data/Column Format.    A .dbf data file is created.   Doall determines the type of data (character vs. numeric vs. date vs. datetime), along with length, and decimals (if any).

* Send outgoing E-Mails from tables.  User defines the field containing addresses.  MAPI or SMTP protocols.

* Automatically open browsers with MapQuest maps (tm), Google maps (tm) or Yahoo maps (tm) for a single record using a hotkey. 

* You can produce multiple maps.  Having a party? Hosting a convention?  Want to send customized maps to your house to each guest, with driving directions?  Since you don't want to open a browser each time, you have several option working with multiple maps.  If you want to add driving directions, you just add your address once.

        You can store the hyperlink (url) that was created for each map in a separate field in your data table.
        Then, you can email the url.

        And/Or, you can save an image of the map in bitmap format (.bmp).  If you create a .bmp image of the
        map, you can store the folder/filename for each .bmp in an empty field in your data table.

        And/Or you can print the maps.  

* Validate addresses on-line using MelissaData (tm).  You can validate single addresses with a hotkey.  US or Canadian addresses.  Demo is limited to address validation in Nevada only.  Full access will require a subscription arranged with MelissaData.   

For single address lookups, the browser will contain additional information (below).  For multiple address lookup, you will be able to save ANY or ALL of this additional data locally to your data table:

Aerial View
AM, FM & TV stations
City demographics
Political Contributors & amounts for zip code
Income Tax statistics
Home sales
Labor statistics
Map
Non-profit organizations
Street detail
Carrier Route
County FIPS code
Time Zone
CMSA – Consolidated Metro area
PMSA – Primary Metro area
Congressional Representative
Latitude, Longitude
Census tract

* Create new table of emails from Windows Address Book

* Create an import file for the Windows Address Book from your table

* The easiest way to graph data in SQL Server, Oracle, Access, or other ODBC databases. 
        1. simply open a connection from Menu>File,
        2. select Menu>Special>Graph
        3. select a field (or two) to graph. Click the button.   Voila!  Instant graph.

* With one click, Import .dbf tables into SQL Server, Oracle, Access, or other ODBC databases.

* With one click, Export/Copy remote SQL Server (or another ODBC database) table to a local .dbf table.

* Used by McDonald's, GE, NBC, Teledyne, etc.

Sample Screen - Clean table of Invalid Characters
You can scan your table for bad characters. Invalid characters, such as characters from the extended character set can render tables unusable, as well as unreadable. This could be an indication that the table has become corrupted.

Sample Screen - Zip Code characteristics - Melissa Data
With this screen you can create a table containing zip code
characteristics. Data includes Zip, City, State, Latitude and Longitude center points,
MSA - Metropolita Statistical Area, PMSA - Primary Metropolitan Statistical Area,
County FIPS, LastLine indicator, Facility Code, etc. Demo limited to Nevada addresses only. Requires subscription to Melissa Data.

Sample Screen - Map addresses on MapQuest, Google or Yahoo tm
Produce maps automatically from address data in your tables.  Once address locations are defined, use a hotkey to automatically produce a map in your browser, based on data in the current record.

Use Doall to link your .dbf tables to MapPoint.  If your tables contains addresses (or latitude/longitude values), you can create Maps and Driving Directions easily. Create:

1. Maps,
2. Driving Directions,
3. Or, Both
4. Calculate + Save Latitude, Longitude or PostalCode values in your local table.
5. Export comma delimited tables from your local table that can be used directly by MapPoint.
6. Find all addresses within ?? miles/KM radius of a specific address.

You can send Maps or Driving Directions to a Printer or a File on disk (.ptm,.ptt, .htm, or .mps PocketStreets formats). In addition, you can store the name of the file you just produced in an empty field in your table. For example, let’s say you produce an .htm file with driving directions, named JOHNSMITH.HTM (or you could use a phone number/email to be more precise). You can save the value WWW.MYCOM.COM/JOHNSMITH.HTM into the empty field. You could the .htm file to the net, or email it directly to John Smith.

You can save Driving directions directly to a memo field in your local table (can then be emailed or printed).

The cost of this link to your local tables is controlled by a separate license file. Once you purchase Doall, you can purchase any number of license uses, in increments of 1,000, depending on your needs.  If you produce 100 routes of 5 addresses each, 500 address lookups are deducted from the license.  To test the system for your needs, you can produce 5 sample address lookups at a time. 

MapPoint^TM – Display your personally defined Territories on maps
You can display custom territories in your maps. Territories will display as colored geographical areas on the map.

Files that define territories are plain text files, in comma separated value .csv format) containing some basic information. An example might be Territory and Postal Code, or Territory and County and State. Territory is a description of the territory you want displayed on the map. The other geographical information is used to color specific map areas.

You can create these territory files within Doall. See Setup>Territories. In the territory screen, you can create territory files from any table (.dbf) containing at least a description of the territory and at least one additional field containing geographical information. This could be PostalCode, County, State, Census Tract, or MSA (or any combination thereof)

In the territory screen, you can load any territory file you’ve created and can elect to automatically plot those territories every time you create a new map.

 Sample territory file, terr1.csv :
Zip, Territory
"53188","Bob"
"53186","Dan"

Sample map:

MapPoint – Find nearest addresses in your table within a specified radius
If you want to find all addresses in your table within a certain number of Miles/KM of a specific address (within a radius), Doall will access MapPoint to determine the distance between a destination address and all of the other addresses in your table. Addresses that are within this radius will be listed on screen.  You will also see the calculated driving time in minutes, and the calculated cost.

Output options:
Paste this list to the clipboard for use in other applications.
Print a Quick report of the list
Save the Driving Distance value for future reference in your table

MapPoint^TM – Find Points of Interest within a specified radius
You can access MapPoint's database of Points of Interest.  You can select which "type" or "category" of POI you are interested in. The system will retrieve preliminary counts of POIs ineach category.   Registered users can save the data to a permanent file on the hard drive.

MapPoint - Points of Interest - plot on maps/create a .dbf table
When you define at least one Point of Interest, a .dbf table of POI's will be created when processing maps.

In the setup screen you can elect to automatically print/or save these points of interest when processing maps.   In addition, you also have the .dbf table of Points of Interest for reference. 




MapPoint - Driving Directions
Output options
Print them (sample output http://www.bbsys.com/mappointdirections.htm)
Save them to a file (sample of .htm file created – same as above)
Save them to a memo type field. You can save Directions in an .htm format (sample is same as above), Or,
Save them in a text (.txt) format. The text format allows more customization of the driving directions output.

The driving itinerary can be customized in multiple ways.   You can:
- change the default MapPoint format by excluding individual items (see below)
- add custom text to the bottom and/or top of the itinerary.
- add the to/from addresses at the top.
- change the default start time for each itinerary from the default (9:00am) to any value
- change the default end time for each itinerary to any value, plus you can
-define a blank end time that allows "drive thru" routes that are continuous
-if you prefer an end time, you can define a flexibility factor that allows extra time to reach the next stop
- automatically insert varied stop times or layover times to each stop (from a value in your table)

Driving Directions – customize the text output

MapPoint - produce map and directions
If you have MSWord, produce a route Map & Directions in the same .doc file.  Can be printed or saved to file automatically.

Summary: 19.3 miles (22 minutes)

SUMMARY
Driving distance: 19.3 miles
Trip duration: 22 minutes
Driving time: 22 minutes
Cost: $2.15

MapPoint - Driver profiles
You can have all drivers use the same profile, by selecting the "default" profile.

MapPoint – Verify addresses
You can use Doall’s link to MapPoint to verify or validate addresses in your table based on MapPoint's address table. The verification process will loop through your records and list the address found in MapPoint on the left side of the screen, and the addresses not found on the right.

Optionally, you can pick an unused field in your table in which to store a "flag" indicating if the address was successfully found. If you select a character field, "OK" will be inserted if the address was found, otherwise "NO" will be inserted. For numeric type fields, a "1" will be inserted if found, otherwise "0". And if you select a logical type field, a "T" (True) will be inserted if found, otherwise "F" (False). You can decide later whether to continue using addresses that MapPoint could not find.

MapPoint – Extract Postal Codes, Zips, Latitudes or Longitudes
(for routes, – Extract Driving Times, distances or costs)
You can use Doall’s link to MapPoint to extract MapPoint data and insert it into your table.

Once you define fields in your table containing address data, you can elect to replace/insert MapPoint's Postal Codes, Latitudes, and or Longitudes into specific fields in your table.  If you elect to process a route (multiple addresses), you can have MapPoint insert the calculated driving times, driving distances, or driving costs into specific fields in your table.

Dynamic Sizing of fonts
Helpful for visually disabled or visually handicapped.  Data can be displayed in any font size, large or small.
Go to Grid Setup from the menu, and click to enable this feature.  Then drag the 2nd row line (left border) down or up.

Split Screen capability
Display data Vertically/Horizontally on same screen.

1040 - Schedule D Attachment Helper - Broker transactions
If you have too many stock trades to fit on a Schedule D, you can prepare a schedule D attachment here.  Enter stock transactions directly from your broker's gain/loss report or import a file downloaded from your broker's website. Some scenarios may require editing, thus it is your responsibility to ensure the accuracy of these entries.

A transaction table will be cxreated for you where you can either:
1. Manually enter brokerage transactions, or
2. Import downloaded brokerage transaction files.

Once transactions are created, you can produce a Schedule D attachment.

Create .DBF from a text file - with an unknown structure
If you have a text file with an unknown structure, your system can make a "best effort" to determine the "likely" structure. Doall will also attempt to determine the type of data (character, numeric, date, datetime) , length, and decimals (if any).   Once a preliminary structure is derived, you can fine-tune it, or export the file.

Create an import file for Windows Address Book
Import names, address, phone numbers, emails, etc. from any .dbf table into the Windows Address Book.
From this screen, just match each of the Windows Address Book data elements with the same data in your table.

Compare + Print files or folders
With this screen you can compare the contents of two files or two entire folders, based on size difference, date difference, or content difference, plus the ability to print folder contents with file names, dates, and sizes.

Send Email - Simple (default email client), MAPI, or SMTP

To use SQL Server tables, select Open connection from menu
(to connect to SQL Server, Access, Oracle, or any other ODBC database)
Use connect button to pick a database, then a table from the list

Resulting (remote view/copy) of SQL data table is displayed
From this temporary table, you can use any Doall features, like graphing, editing, sorting/analyzing data

Sample Screen - Graphs
User controls for graph options are in one screen, including, Title wording, Axis wording, font colors, font sizes, bar colors, graph type, orientation & rotation, label placement, edit graph data, white space, etc.

Free Counter