Frequently Asked Questions
- Is HELP!Desk really free?
- What is the default user name and password?
- Error - Q+E Software ODBC Driver is not Licensed
- How can I speed up HELP!Desk?
- I get the following error message when I try to log into HELP!Desk: "Data Window Error. Database transaction information not available. Call SetTrans or SetTransObject function"
- Error: SQL State S0002, Cannot open C:\HDWIN\HD_ENTRY.DBF
- Reports do not show data within your selected date range.
- Can I use other databases with HELP!Desk, i.e. Oracle or SQL?
- How often should I reindex the databases?
- How can I create my own entries in the drop-down fields?
- Can I add, modify or delete fields in the HELP!Desk databases?
- Unable to configure HELP!Desk Alert for my user id.
- Can I use a third-party report writer with HELP!Desk?
- Can I use a third-party database program (such as Microsoft Access) to manipulate HELP!Desk data?
- Error: Undefined column HD_ENTRY.MAIL_ADDR.
- Error: Cannot open HD_CALLS.DBT.
- I am getting the words "<Not Linked>" at the top of the Client Profile for some clients. Why?
- How is duration computed?
HELP!Desk for Windows FAQs
Is HELP!Desk really free?
Yes, it is. You can download it, use it forever, and it won't cost you a dime. If you want technical support or training, there are fees associated with those services. See the pricing page for details.
I can't log in? What is the default user
name and password?
Enter HD for the user name, then HD again for the password.
Error - Q+E Software ODBC Driver is not Licensed
HELP!Desk includes to files that provide you with a license to use the ODBC drivers we provide. If these files are not found where the driver expects them to be, you will receive an error message. This error most frequently occurs on systems that have Windows NT installed or have been upgraded to a new version of Windows since HELP!Desk was installed. The solution is to locate the two license files (qepwrsft.lic and qepb.lic) and copy them to the \Windows\System directory. These files will usually be found in the HELP!Desk data directory or in your local \Windows\System32 directory. You can also find these files on the HELP!Desk CD-ROM.
How can I speed up HELP!Desk?
To improve database performance, start ODBC Administrator (in the HELP!Desk program group), double-click the "HELP!Desk for Windows" line, then set the Cache Size to 1024. You will need to do this at each workstation. Note: On some systems, the 1024 value will cause HELP!Desk to crash. If this happens to you, try 512. Continue to decrease the value until HELP!Desk runs without crashing. Some systems will not support any value in the cache size. Also, we have yet to see a system that will work with a value greater than 1024, but you're welcome to try.
You may have data problems that prevent all of the indexes from being maintained. Use Notepad to open the file QEDBF.INI located in your HELP!Desk data directory on the network. Compare it to the one shown here. Pay particular attention to the settings of NUMUNIQUE found under [HD_CALLS.DBF] and [HD_CLIEN.DBF]. If either setting shows NUMUNIQUE=0 you will be experiencing a definite reduction of performance. At this time it is advisable to contact our support team. However, if you wish to perform additional diagnostic tests on your own, download DUPID.ZIP and check the Client and Call files for duplicate and zero IDs.
To find out how much performance is being impacted by your network, copy the HELP!Desk data directory from the network to a local temporary directory. Run ODBC Administrator and change the Database Directory to the local directory. Compare performance to your previous configuration.
I get the following error message when I
try to log into HELP!Desk: "Data Window Error. Database transaction
information not available. Call SetTrans or SetTransObject function"
This error means the ODBC drivers for HELP!Desk did not install properly and you may need to install or reinstall them. If you have installed a demo copy of Bendata's HEAT, the HEAT installation copies files that prevent HELP!Desk and some other applications from functioning properly. Uninstalling HEAT will not correct the error. You will need to manually do the following:
- Replace the file CTL3DV2.DLL in your \Windows\System directory with the one from \HDWIN\CLIENT\DLL (on the network drive or from the CD).
- Rename C:\WINDOWS\SYSTEM\INETWH32.DLL to INETWH32.OLD.
You should then be able to run HELP!Desk. In some cases you will need to reinstall the ODBC drivers and reboot the computer to complete the procedure.
When I try to log into HELP!Desk I get an
error, SQL STATE S0002 Unable to open C:\HDWIN\HD_ENTRY.DBF.
The problem is the ODBC setting that tells HELP!Desk where the databases are is incorrect. To correct the setting, run ODBC Administrator from the HELP!Desk for Windows program group. Double-click on the HELP!Desk for Windows entry in ODBC to open the Setup window. Change the database path (third line) to the directory containing the HELP!Desk databases. This is normally a directory on your file server.
Reports do not
show data within your selected date range.
Using version 3.42 or later, you must have the setting forcefourdigityear=ON in the [General] section of HDWIN.INI. Remember to make this setting on each workstation.
Can I use other databases such as Oracle
No, the HELP!Desk license agreement restricts the use of the program to the database drivers that are included with the product. Options for other databases may be available in the future,
How often should I index the HELP!Desk data
Indexing is a process that must be completed when no other users are accessing the system. The indexing process will not harm the files and the files cannot be over indexed. For high volume operations, the indexing process should be completed daily. If a computer is turned off or rebooted while HELP!Desk is running you may experience index corruption and need to rebuild the index files.
How can I create my own entries in the drop
All of the customizable drop down fields in the HELP!Desk software are controlled via the field table maintenance section of the software. This section of the program can be accessed by selecting UTILITIES from the main menu, then Table Maintenance, and Field Tables. From this window the drop downs are selectable from the drop down on this window. For each section you can add, edit, or delete records associated with each drop down. You can also use the field validation setting in each user's security record to automatically or optionally add new entries to the tables.
Can I add, modify or delete fields in the
No, the fields and the field lengths in the HELP!Desk for Windows software are not customizable. The software will not be able to use changes to the fields or field lengths, thereby rendering those changes useless.
I am unable to configure HELP!Desk Alert
for my user ID.
All of the customizable drop down fields, including the technician drop down in HELP!Desk Alert, are controlled via the field table maintenance section of the software. This section of the program can be accessed by selecting UTILITIES from the main menu, then Table Maintenance, and Field Tables. From this window select the Technician table and add the names of each technician. You will then be able to configure the Alert program.
Can I use a third party report writer to
design custom reports?
Absolutely. The HELP!Desk for Windows program uses dBASE III+ compatible databases. These databases can be accessed by most report writers, such as R&R Report Writer and Crystal Reports. You are always welcome to use these third party report writers, but we suggest that you use them with copies of your databases.
Can I use a third party database management
program to manipulate the databases?
The HELP!Desk for Windows program uses dBASE III+ compatible databases. These databases can be accessed by most database management software programs, but you should use copies of the databases. Many programs, such as dBASE IV and Microsoft Access, alter the structure of the files and would prevent HELP!Desk from running. Please note the database file names, relations and structures can be found in the HELP!Desk Administrator's Guide.
When logging onto the HELP!Desk for Windows
software I am receiving an undefined column HD_ENTRY.MAIL_ADDR. What is this error message
and how can I fix the problem?
This usually means that you are trying to connect the HELP!Desk for Windows program to the HELP!Desk for DOS databases. The two programs use different database structures and therefore cannot be used for the two different software programs. HELP!Desk for Windows ships with a conversion program that will copy your HELP!Desk 2.x data to the HDWIN format.
When logging into HELP!Desk for Windows I
am receiving an error message "cannot open HD_CALLS.DBT". What is this error
message and how can I fix the problem?
This error usually signifies a database corruption in the DBT portion of the database file. This can be corrected outside of the HELP!Desk for Windows using a dBASE-compatible program. If you can't find a copy in your software closet, you may need to contact our support staff to resolve this issue. Please be aware that there is a fee for all HELP!Desk tech support, and you must purchase a support contract or pay-as-you-go support before we can help you. See the pricing page for more information.
I am getting the words "<Not
Linked>" at the top of the Client Profile for some clients. Why?
This error usually signifies database corruption in the DBF portion of the database file. This corruption is usually associated with duplicate IDs in the HD_CLIEN.DBF file. Download DUPID.ZIP to verify this duplication. The problem can be corrected outside of the HELP!Desk using dBASE or FoxPro.
How is duration computed?
The duration field counts the amount of time spent in ADD/EDIT mode for a particular call. If additional time is spent outside of the program then that duration should be keyed into this field and it will be totaled with the time spent in ADD/EDIT mode to provide a total time spent on the call.