For Cougar Mountain Software
Support's
Professional Version (V2012,
V2011, V2010, V2009, V12-V6)
CMS TECH
TIP DBFIX.EXE
Introducing
DBFIX.EXE. DBFIX.EXE
for the Reporting to the MAX enables you to view and
alter the header information contained in a
Dbase IV file and thereby get around some of the
shortcomings of FILEFIX.EXE. In the case of
corrupted data records in the data file, the
best approach is still to restore from backups
or use dBase to try to open the file and excise
the corruption. In the case of a corrupted
header record, you can use DBFIX.EXE to repair
or reconstruct the header record for the file,
and then open and repair the file with
FILEFIX.EXE.
In the case of a damaged or missing index
file, you can use DBFIX.EXE to uncheck the
Production Index File flag in the header record.
FILEFIX.EXE will then open and repair the file
without trying to open the index file. You can
then rebuild the index using the accounting
software Data/Index File Maintenance option.
To use DBFIX.EXE, first make a backup of the
damaged file, the associated index file, and the
associated note file if applicable. Store the
backups in a safe directory so they can be
restored if necessary. Run DBFIX.EXE and select
FILE and then OPEN DBF. Enter or select the
damaged file and click OK. Select ANALYSIS from
the main menu and then INFORMATION. This
displays the header record information including
the checkbox labeled "Has Production Index
File" which is the flag mentioned above. It
also displays the size of a record and number of
records in the file and the field number, name,
type, and length for each field in the record.
The only change that can be made from the
INFORMATION menu choice is to turn off the
"Has Production Index File" flag. Do
this if you have a damaged or missing index and
the run FILEFIX.EXE. You can view the field
information and compare it to your file
structure documentation to verify that all field
types and lengths are correct. If you find
errors in the field information, you can fix
them by going to the next step.
Select ANALYSIS from the main menu and then
CHECK FIELDS. You then see a display of all
fields for the record and the name, type,
length, and decimals for each field. To change a
value for a particular field, find the field in
the scroll box and highlight it with your mouse.
The values for the selected field appear in the
Change box at the top of the Check Fields box.
Make the required changes in the fields and
press the Change button. View the field
information in the scroll box to verify that
your changes took effect.
Be very careful when using this utility and
always refer to your file structure
documentation. Never guess at a value because
every piece of information must be absolutely
correct or the accounting software will not
function correctly.
One other capability of DBFIX.EXE is to
correct the condition where the header record of
a file indicates a different number of data
records than are physically in the file or that
DOS can read. This is the equivalent of setting
the end of file in ACTPlus. To do it, select
ANALYSIS and then DIAGNOSTICS. In the center of
the DIAGNOSTICS dialog box is a box labeled
number of records. You will see the number of
records that DOS reports on the right side of
the box, and the number of records that the
header record reports on the left. To
synchronize them, change the number of records
on the left to equal the number of records on
the right.
If you wish to get more information, please
email us at
or call us at (714) 228-5444
Welcome to
Internet to the MAX
"Your Search Engine and Website Traffic Optimization
Source"
Marketing using the internet and emails is one
of the most cost effective methods
of getting sales but it just one element
in a well coordinated marketing campaign.
It has many pitfalls that cause a
business not
to get the desired results.
We are offering a service to build a
team of specialists
to handle each aspect of internet marketing. No one person has all
the information and skills needed, so we contract with an assortment of
experts who are specialists in each aspect below. If you are such
an expert, please email us to apply to join our team.
Search Engine Optimization Expert
Website Search Engine PageRank / Relevancy Expert
Email Capturing Expert
Targeted and Opt-in Email Marketing Expert
Intelligent Scheduled Autoresponder Expert
Opening/Expanding New Selling Channel Expert
Business List Expert
Website/eCommerce Effectiveness Expert
Monthly Tune-up and Analysis Expert
Public Relations Firm to help coordinate
and keep
marketing message on track
Monthly Monitoring and Reporting Expert
Setting up Affiliate Programs to build a passive
sales force
your
products and a passive income stream for the
products of others
Companies are realizing that internet based techniques and strategies must
be approached as they would with any traditional marketing activity.
The fundamental questions must still be addressed
Who are our customers/prospects?
What are the competitors doing?
What are the channel dynamics, challenges and potential missed
channels?
Which marketing mix strategies are most cost effective?
What is the response time?
What will we make a return on investment?
The learning curve of this still world is being addressed. From
hard-learned lessons new business, pricing, distribution and advertising
models are emerging.
A Snapshot of The Internet and the World Wide Web
The Internet is a complex system of computer networks. Anyone with a
computer interface (PC, laptop, PDA, etc.) and the ability to access the
network (wireless modem, telephone line, cable,) can easily hook into
the system.
The World Wide Web is a software application that runs on the
Internet. It provides the platform that incorporates text, video,
graphic and audio functions. Consider the “Web” as the user-friendly
interface that brings the Internet to life.
The Changing Profile of Internet Users
At the start of the Internet’s history, the typical user was a
high-income, young man. It’s not surprising that the people who
developed the system would be its most dominant customers.
However, the overall demographic profile (U.S.) is shifting to
reflect the average population. Many analysts, including those from the
Yankee Group, report that the Internet is now reaching the mass consumer
market. Cheaper computer prices, cultural acceptance and the ubiquitous
influence of the Internet are influencing the online surge of new users.
A significant finding from the Yankee Group’s Interactive Consumer
Survey (IAC) 2000 indicates the Internet is losing its mystique. For
many the Internet has become an integral part of the daily lives of
household users. According to the Yankee Group study, 87% of respondents
logged online at least once a day.
As users gain a greater comfort level interacting with the Web and
begin to establish trust among the Web sites they visit, it is logical
to assume that online buying will continue to escalate.
In a study released May 2001, the Boston Consulting Group projected
$65 billion in North American online sales for 2001. This represents a
45 percent increase from 2000 purchases.
