B+B Systems,
LLC
627 Madison
Waukesha, Wisconsin 53188
262-299-3602
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.
DOALL - First time Installation+Upgrades ( )
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 MSSQL Server
functions Order MySQL, MS SQL, Oracle record
conversion licenses (from/to remote tables) Use PayPal, or remit checks to: B+B Systems, LLC,
627 Madison, Waukesha, Wisconsin 53188 Our most popular product. 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. Sample - Startup Screen (with sample parent/child
database) * Use the SAME system for
accessing all of your .dbf type files IMPORT THESE FORMATS: EXPORT THESE FORMATS: * Produce output using any
sort, any record selection, any fields. * Convert data - Import
spreadsheets/Word Processing, XMLtoCursor(), and many of the same formats
(above). * 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. And/Or, you can
save an image of the map in bitmap format (.bmp). If you create a .bmp
image of the 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 * 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.
* 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 Sample Screen - Zip Code characteristics - Melissa
Data Sample Screen - Map addresses on MapQuest, Google
or Yahoo tm Link Microsoft's MapPoint to your local
tables 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: 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.
(Annual licenses include ability
to link to other DataBases, such as SQL Server, Oracle, Access,
etc.)
Print mail-in order
form
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.
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
* 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.
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
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)
* 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,
*
Automatically Dial Phone numbers (thru modem), pick up phone, then after
call
-prompts for entering
notes
* If CALLBACK date field exists, pending callbacks will
pop up
* Get record COUNTS for selected records
* Sample data
files provided are RELATIONAL:
*
Proportional font sizing based on row height for the visually impaired. Simply
expand row height, and all font sizes increase.
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.
Then, you can email
the url.
map, you can store
the folder/filename for each .bmp in an empty field in your data table.
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
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.
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.
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. 
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.
If you have purchased Microsoft’s
MapPoint (required), you can link your local tables to more easily produce:
(simply identify the fields containing Address/City/State/Zip data OR
Latitude/Longitude)
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
MapPointTM – 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.
| Time | Mile | Instruction | For | Toward |
| 9:00 AM | 0.0 | Depart 43.0389 -87.9036 on N Jackson St (South) | 0.2 mi | |
| 9:00 AM | 0.2 | Take Ramp (RIGHT) onto I-794 | 0.8 mi | I-43 / I-94 |
| 9:01 AM | 1.0 | At exit 1A, take Ramp onto I-94 [US-41] | 15.1 mi | I-94 / US-41 / Madison |
| 9:15 AM | 16.0 | At exit 295, turn RIGHT onto Ramp | 0.2 mi | CR-F / WI-74 / Waukesha / Sussex |
| 9:15 AM | 16.2 | Keep LEFT to stay on Ramp | 65 yds | CR-F / Waukesha |
| 9:15 AM | 16.2 | Keep STRAIGHT onto Local road(s) | 32 yds | |
| 9:15 AM | 16.2 | Turn LEFT (South) onto CR-F [Redford Blvd] | 1.8 mi | |
| 9:18 AM | 18.1 | Keep STRAIGHT onto CR-F [E North St] | 0.1 mi | |
| 9:18 AM | 18.2 | Keep STRAIGHT onto US-18 [SR-164] | 1.0 mi | |
| 9:21 AM | 19.2 | Turn RIGHT (North-West) onto Madison St | 0.2 mi | |
| 9:22 AM | 19.3 | Arrive 614 Madison St, Waukesha, WI 53188 |
MapPoint - Driver profiles
You can have all drivers use the same profile, by selecting the
"default" profile.
Or, you make individual driver profiles.
Each driver can have their own
route types, shortest, quickest, or with specific road preferences.
Each
driver can have his/her own speed averages, and start/end or flexibility time
(extending the end of the route for the last stop)
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
Data Duplicator - copy data TO and FROM .dbf's TO
and FROM SQLServer/MySQL/Oracle/Access,
etc.
Data Duplicator - Help screen
Upload .dbf table - define fields - creates
table structure and indexes and copies data to SQLServer, MySQL,
Oracle, Access, or any other ODBC connection.
Upload .dbc database - define which tables + which fields - creates Database/schema/catalog along with table structure and indexes and copies data to SQLServer, MySQL, Oracle, Access, or any other ODBC connection.
Download to multiple file types - define which Server tables + which Server fields - creates file and copies data to local disk.
Download to .dbc and multiple .dbf tables - define which Server tables + which Server fields - creates file and copies data to local disk.
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. 
Sample - Cross Tab graph
Sample - Left/Right side descriptions graph
The Data Duplicator can:
Copy data from SQLServer to a Comma Delimited ASCII (txt) file.
Copy data
from MySQL to a Comma Delimited ASCII (txt) file.
Copy data from Oracle to a
Comma Delimited ASCII (txt) file.
Copy data from Access to a Comma Delimited
ASCII (txt) file.
Copy data from SQLServer to a Comma Separated Value
(csv) file.
Copy data from MySQL to a Comma Separated Value (csv)
file.
Copy data from Oracle to a Comma Separated Value (csv) file.
Copy
data from Access to a Comma Separated Value (csv) file.
Copy data from SQLServer to Standard Data Format (Columns) ASCII
(sdf).
Copy data from MySQL to Standard Data Format (Columns) ASCII
(sdf).
Copy data from Oracle to Standard Data Format (Columns) ASCII
(sdf).
Copy data from Access to Standard Data Format (Columns) ASCII
(sdf).
Copy data from SQLServer to FoxPro/dBase (dbf).
Copy data from MySQL
to FoxPro/dBase (dbf).
Copy data from Oracle to FoxPro/dBase
(dbf).
Copy data from Access to FoxPro/dBase (dbf).
Copy data from SQLServer to FoxBase 2x plain MEMO (dbf).
Copy data
from MySQL to FoxBase 2x plain MEMO (dbf).
Copy data from Oracle
to FoxBase 2x plain MEMO (dbf).
Copy data from Access to FoxBase 2x
plain MEMO (dbf).
Copy data from SQLServer to Lotus 1-2-3 (wks).
Copy data from MySQL
to Lotus 1-2-3 (wks).
Copy data from Oracle to Lotus 1-2-3
(wks).
Copy data from Access to Lotus 1-2-3 (wks).
Copy data from SQLServer to Data Inter. Format (dif).
Copy data from MySQL
to Data Inter. Format (dif).
Copy data from Oracle to Data Inter.
Format (dif).
Copy data from Access to Data Inter. Format (dif).
Copy data from SQLServer to Multiplan v4.01 (mod)
Copy data from
MySQL to Multiplan v4.01 (mod)
Copy data from Oracle to Multiplan
v4.01 (mod)
Copy data from Access to Multiplan v4.01 (mod)
Copy data from SQLServer to Excel ver. 2-4 (xls)
Copy data from MySQL
to Excel ver. 2-4 (xls)
Copy data from Oracle to Excel ver. 2-4
(xls)
Copy data from Access to Excel ver. 2-4 (xls)
Copy data from SQLServer to Excel ver. 5-> (xls)
Copy data from
MySQL to Excel ver. 5-> (xls)
Copy data from Oracle to Excel
ver. 5-> (xls)
Copy data from Access to Excel ver. 5-> (xls)
Copy data from SQLServer to Symphony v1.1 (wr1)
Copy data from MySQL
to Symphony v1.1 (wr1)
Copy data from Oracle to Symphony v1.1
(wr1)
Copy data from Access to Symphony v1.1 (wr1)
Copy data from SQLServer to Wordstar/NewWord MailMerge (txt)
Copy
data from MySQL to Wordstar/NewWord MailMerge (txt)
Copy data from
Oracle to Wordstar/NewWord MailMerge (txt)
Copy data from Access to
Wordstar/NewWord MailMerge (txt)
Copy data from SQLServer to MS WORD MailMerge (txt)
Copy data from
MySQL to MS WORD MailMerge (txt)
Copy data from Oracle to MS WORD
MailMerge (txt)
Copy data from Access to MS WORD MailMerge (txt)
Copy data from SQLServer to WordPerfect MailMerge (txt)
Copy data
from MySQL to WordPerfect MailMerge (txt)
Copy data from Oracle
to WordPerfect MailMerge (txt)
Copy data from Access to WordPerfect
MailMerge (txt)
Copy data from SQLServer to Word Writer MailMerge (txt)
Copy data
from MySQL to Word Writer MailMerge (txt)
Copy data from Oracle
to Word Writer MailMerge (txt)
Copy data from Access to Word Writer
MailMerge (txt)
Copy data from SQLServer to WordPlus-PC MailMerge (txt)
Copy data
from MySQL to WordPlus-PC MailMerge (txt)
Copy data from Oracle
to WordPlus-PC MailMerge (txt)
Copy data from Access to WordPlus-PC
MailMerge (txt)
Copy data from SQLServer to Smart MailMerge (txt)
Copy data from
MySQL to Smart MailMerge (txt)
Copy data from Oracle to Smart
MailMerge (txt)
Copy data from Access to Smart MailMerge (txt)
Copy data from SQLServer to XML
Copy data from MySQL
to XML
Copy data from Oracle to XML
Copy data from Access
to XML
Copy data from SQLServer to Simple HTML
Copy data from MySQL
to Simple HTML
Copy data from Oracle to Simple HTML
Copy data
from Access to Simple HTML
Copy data from SQLServer to Cross-Tabulation
Copy data from MySQL
to Cross-Tabulation
Copy data from Oracle
to Cross-Tabulation
Copy data from Access to Cross-Tabulation
Copy data from SQLServer to Cursor/Table to ClipBoard (Tab delimited -
This format can be "pasted" in Excel/Spreadsheets)
Copy data from MySQL
to Cursor/Table to ClipBoard (Tab delimited - This format can be "pasted"
in Excel/Spreadsheets)
Copy data from Oracle to Cursor/Table to
ClipBoard (Tab delimited - This format can be "pasted" in Excel/Spreadsheets)
Copy data from Access to Cursor/Table to ClipBoard (Tab delimited - This
format can be "pasted" in Excel/Spreadsheets)
Copy data from SQLServer to ClipBoard (Space delimited)
Copy data
from MySQL to ClipBoard (Space delimited)
Copy data from Oracle
to ClipBoard (Space delimited)
Copy data from Access to ClipBoard (Space
delimited)