| 
|
Pertaining to ResourceMate ® 2.0
3.0
support
Latest Issues | ResourceMate®
Regular | ResourceMate® Plus | Network
Search Screen | Web Search | EntryMate™
Please find your product
and support category below, or use your browser's Find
function to look for specific error message text or keywords.
Product:
ResourceMate® Regular. Support Categories:
Product:
ResourceMate® Plus Version. Support Categories:
Product:
Network Search Screen. Support Categories:
- Installing Network Search
Screen(s)
- Network issues
Product:
Web Search. Support Categories:
Product:
EntryMate. Support Categories:
Back
to Top
Installing,
Registering & Starting ResourceMate®:
How do I copy
my ResourceMate® database from one computer to another? - click
here
I
forgot my password or my password doesn't work anymore.
The password in ResourceMate®
is sensitive to upper and lower case letters. Ensure that the Caps
Lock key has not been pressed on your keyboard. (This often
illuminates up a special indicator light on your keyboard).
Also ensure that you are
entering the password with the same capital and small letters as when
you created the password.
If you still can't recall
your password, click here to download
and use a utility that can help ResourceMate® customer support
determine your password.
ResourceMate®
freezes / hangs when I click on the icon to start the program.
This may be happening because
ResourceMate® is a 16-bit application and may be conflicting with
currently running 32-bit applications.
What we suggest is that
you make sure ResourceMate® is the FIRST program to load into
your operating system, before other applications. If you have several
applications that startup automatically you may have to disable that
so that you can have ResourceMate® always run first. (Check your
StartUp group by clicking on the Start button, then
clicking on Programs then on StartUp).
If the problem persists,
please contact Customer Support by e-mail
or by calling 800-815-8370.
Name
on the top of all screens and reports was entered incorrectly.
The easiest way to change
the name that appears on the top of every screen and report is to
re-install the software. However, If you have already entered a number
of items, contact Jaywil Software by phone
or e-mail and we will send
you a file that corrects the name.
New Registration
number given at registration no longer works
The new registration number
works in conjunction with the old registration number. The old registration
number changes whenever you re-install the program. If you
have re-installed ResourceMate® and entered the name of the organization
slightly different than you did originally, the new registration number
will not be valid. Contact Jaywil Software by phone toll-free at 800-815-8370
or by e-mail with your
old registration number and we will issue you a new registration number.
What are the
System Requirements for installing ResourceMate®?
Windows™ Version
100% IBM Compatible
80486 or higher
VGA Monitor
8Mb RAM
MS-DOS version 3.1 or higher
Microsoft Windows™ 3.1 or higher running in 386 enhanced
mode
Mouse
15MB Hard Drive space + approx. 1mb. per 1,000 items
For other system related
questions click on System Requirements &
Technical Questions.
Back
to Top
Updating your copy of ResourceMate®:
When updating
to a newer version, I get the message "cannot create c:\rm\lists".
Please click here
to see how to correct this problem.
Adding/changing/deleting item records:
Importing from Internet
(Library of Congress):
After
I import items from the Library of Congress, some fields have their
data truncated (missing characters up front).
This is most likely caused
by trying to import from the wrong Library of Congress search page.
ResourceMate® can only import from the Z39.50 interface
at the following web page: http://www.loc.gov/z3950/
Don't forget to choose
Advanced Search and then choose Full
as your "preferred record display" setting in order to see
all fields in the results you receive. (See image below)
If you chose Simple
Search or had Brief selected in the Advanced
Search, you will only get partial results.
Some
fields like "Author", "Dewey" and "Subjects"
are missing from the results.
You must choose Advanced
Search and then choose Full as your "preferred
record display" setting in order to see all fields in the results
you receive. (See image below)
If you chose Simple
Search or had Brief selected in the Advanced
Search, you will only get partial results.
NOTE: You can click the
link called "More on this record" to see all fields.
I
can't find the Library of Congress web page.
The Library of Congress web page won't let me initialize my search session.
Click on the following
web address in order to reach the Library of Congress search page:
http://www.loc.gov/z3950/
(don't forget to choose Advanced search and then
click on Full)
The Library of Congress
search site only allows 250 simultaneous users worldwide.
If you get an error trying to log in, press the Back
button in your web browser and try again. Usually you can connect
if you keep trying. There may be high-user "peak" times
during which it is more difficult to log into their site. Try during
non-peak hours.
Back
to Top
Adding/changing/deleting
name/patron records:
Finding
records; sorting questions:
Author - I can't
find my items when I search by Author.
Author - Authors are not sorting properly in my lists and reports.
Call Number -
Call numbers do not sort properly because of leading spaces.
Subject - I can't find my items when I search by Subject
Subject - Subjects are not sorting properly in my lists and reports.
Title - I can't find my items when I search by Title
Title - Titles are not sorting properly in my lists and reports.
Please click
here for the solution to these problems.
How
do I use the new "Optional Sort" capabilities that were introduced
in version
2.0h? -
click here
Foreign
characters are causing titles to sort incorrectly:
If you are using foreign
characters in your titles, you may find those titles sorting incorrectly
in reports and within ResourceMate®. Add the following two text
lines to the file config.fpw in the folder in which
ResourceMate® is installed (usually c:\rm
("How
do I determine my ResourceMate® installation folder?")
CODEPAGE=AUTO
COLLATE=GENERAL
Go into ResourceMate®,
click on Utilities then click on menu entry Re-index,
Refresh and Pack Data files.
If you see three check boxes, just click on "Re-index" and
make sure the other boxes are clear. Click OK.
If you didn't see three check boxes (because you have an earlier version
of ResourceMate®, just click OK).
I can't find
an entered item with Quick Search or Search Specific Items
If you are using Quick
search, Search Specific Items or any of the Search screens and are
not finding a title that you know you have entered, the title may
have accidentally been entered with one or more leading spaces
before the title.
In the Item screen click
on Search Specific Items, press the Tab
key once on your keyboard, change = to Like,
press Tab once, enter the first few letters of the
title, press Tab, press Enter. You
should see the missing title on the list. Highlight it and press Esc
twice. (The "like" search operand looks for characters within
a title so it can help you locate missing items).
Once you have found the
record move to its Title field using the TAB key.
When the title field is highlighted, press the Home
key or use the arrow keys to move to the very start of the field.
You should find that the first character or two is blank. Press the
Delete key on your keyboard to delete these spaces.
Click on the Save Changes button to save this change.
Removing the leading spaces
will put the item back in the correct sort sequence so it can be found
in the future.
I am looking
for examples on how to use ResourceMate's Browser to include/exclude
items on my reports
I am looking for examples on how to use ResourceMate's "Search
Specific Items" button
The newest ResourceMate®
manual has some examples of the usage of the Browser.
Also visit the newsletter archive page by clicking
here. Several past newsletters have some good Browser
examples.
Back
to Top
Printing
library catalogue cards and/or library labels:
Cards - I checked
off "Author card" in the Library Card screen, but that card
won't print.
It's possible to enter
a book in ResourceMateŽ without entering an author. If you then
had the "Print Author Card" check box turned on, no Author
card would be printed. ResourceMate® will not print an empty card.
If this does not explain
your situation, please call us at 800-815-8370 or e-mail us at info@resourcemate.com.
Cards, Shelf
- When I print cards, my Shelf Card information line is being truncated
- click here
Cards or Labels
- I need a fast way to set on or off the check boxes indicating which
cards or labels to print - click
here
Labels: I'm printing
spine-only labels and all I get is one column of labels down the left
side of the page.
Check the following:
- Exit
the labels print screen and click on Utilities then click
on Choices... and ensure that the correct printer type is
selected for the printer you are using. If you have an inkjet or laser
printer and "Dot matrix" is checked off, you will experience
this problem. Go back to the Print Library Labels screen and click
See Library Labels on the Screen to see if the problem is
fixed.
- In
the Print Library Labels screen (Reports / Print Library Labels) make
sure that the Print Spine Labels Only box has a check mark
in it--that is, it is turned on. Click See Library
Labels on the Screen to see if the problem is fixed.
I Want to Print
an Extra Line of Information on ALL cards.
Enter any information you
want in the notes field on the Library Card Information
Screen. Patrons/users can also see such notes in
their Search Results screens. Warning: if you enter too much information
in the Notes field your Subject headings may be forced onto the next
card and this will produce bad results for all remaining cards. Use
ResourceMate®'s Preview Mode to check the cards
before printing them.
I Want to Print
Extra Information Only on the Shelf/Inventory Card.
Enter any information you
want in the Shelf Card Information field on the Library Card Information
screen. Such additional information will only appear on the Shelf/Inventory
Card when it is printed.
I want to modify
the way my cards and labels look (change fonts, add/remove information)
Choose #1 or #2
below:
1) Per Item Changes: Make changes manually in the Body
of Card box on the Library Card Information
Screen. If this box is not available for editing it means your system
has been setup to automatically refresh the Body of Card box whenever
changes are made to that item's data. You can however make changes for
this item by doing these steps: click on the Utilities menu
(you do not need to close the Item screen), then click on Choices...
then temporarily turn off the check box called "I
want the body of card automatically refreshed when I make changes".
Click OK. Make your desired changes to the Body of
Card box. Click Save Changes. Go back to the Utilities
menu, choose Choices... and turn the check-box back on.
Click OK. NOTE: since you have turned auto-refreshing
back on, any changes you make to this item's data will cause the Body
of Card box to change as well--erasing your custom change.
2) Changes for all cards/labels: See Reports:
Modifying/customizing reports/cards/labels
Labels: My label
sheets have eight (8) rows of spine-pocket-signout labels; ResourceMate®
is printing ten (10) rows.
E-mail customer support
at by clicking here (info@resourcemate.com)
or call 1-800-815-8370. Please:
- Indicate your need for
8-row label sheet templates
- Write your e-mail address
- Write your full contact
information (including organization name)
- Go into ResourceMate®,
click on the Help menu then click on About ResourceMate:
indicate in your e-mail the version letter, i.e.
2.0d, 2.0g etc.
- Also from that same
About ResourceMate window: indicate the "date stamp"
or "version date"
- Also from that same
About ResourceMate window: indicate the "installed
in" folder name.
- Exit that screen and
click on Utilities then click on Choices...: indicate
the "printer type" you have selected.
- Indicate the make and
model of your printer.
We will be glad to send
you the appropriate 8-rows-per-sheet templates, along with instructions
on how to install them.
My labels are
drifting to the left the closer you get to the right side of the sheet.
1) First read how to change
margins by clicking here: Report Modification
2) In that same "Report
Layout" screen make sure the following values are in the data
box:
- In
the first box under "Columns" (which is the left margin
value) enter: 0.0551
- In the next box below
that (label width) enter: 0.9567
- In the next box below
that (space between labels) enter: 0.0413
- Ensure that you have
inches selected.
Warning
to dot matrix printer users who print cards and labels.
The printer drivers in
Windows 2000 and the new Windows XP operating system may not
support custom form sizes for dot matrix printers. Custom form sizes,
which have until now been supported by all Microsoft operating systems,
are required in order to print cards and labels in ResourceMate®
on dot matrix printers. Thus if you use a dot matrix printer and are
about to upgrade your operating system to Windows 2000 or XP, you
may not be able to print your cards or labels once the new operating
system is installed. (Note: all your "regular" ResourceMate®
reports that are sized 8½"x11" are unaffected by
this problem).
If you plan to continue
printing cards or labels on a dot matrix printer and will be upgrading
your operating system to Windows 2000 or Windows XP please contact
us.
One suggested work around
is to upgrade your operating system only after you have found
a new inkjet or laser printer and/or you have used up your existing
dot matrix card/label stock. Another suggestion would be to use another
computer, either one at home or elsewhere in your organization, that
is still pre-Windows 2000/XP, to do all your cards and labels printing
on your dot-matrix stock.
Back
to Top
Reports:
Previewing and printing:
How do I use
the new "Optional Sort" capabilities that were
introduced in version
2.0h? -
click here
Accession
Report - Displays accession date with 3-digit year.
...for example: 06/01/199.
Your Windows™
operating system date setting is set to display dates with a 4-digit
year. The accession report does not have room for the final digit
and it gets truncated, resulting in a 3-digit displayed year. Use
your windows settings to display dates with a two digit year (see
below). Alternatively, support-paying users can call us at (519)
837-8370 or e-mail us at info@resourcemate.com
for instructions on making more room for the accession date field
on the Accession Report.
Changing Windows™
settings:
- In Windows™ 95
or 98 choose Start / Settings / Control Panel / Regional Settings
/ Date (tab) / Short date style. Change the four-digit year
format to a two-digit year format.
- In Windows™ 3.1
or 3.11, choose Main / Control Panel / International / Date Format
/ Century
Also, see the note about
Year 2000 Compliance if you are using your
Windows™ settings to force 4-digit year display.
How do I get
a printout of all the items I have entered?
On the Reports
menu choose Item Files Reports, then choose with Call
number or with Location. You will then see a list of
reports (by title, author, category, status, call number, i.s.b.n.,
bar code number, subject, accession number)
How do I change
the report margins? - click here
I
get computer errors when I try to PRINT or PREVIEW reports/cards/labels
(and I am using an HP DeskJet printer).
This applies to users who
have an HP DeskJet printer and are trying to print or preview reports/cards/labels
in ResourceMate®. If you are receiving computer errors like:
"Foxprow caused
a general protection fault in ..."
"Invalid function, argument, ..."
"Expression evaluator fault ..."
...changing your default
printer driver may solve the problem. Here's how:
Exit ResourceMate®
if it is still running.
Click on Start.
Click on Settings then on Printers.
Click on the Add Printer icon and click Next.
In the left panel under "Manufacturers:" choose HP (see
image below).
In the right panel under "Printers:" choose HP DeskJet.
**IMPORTANT** Do not choose a printer with any numbers in the name;
just choose "HP DeskJet". This is a "generic"
deskjet printer and will accomplish 99% of your regular printing tasks.
Click Next.
Under "Available ports:" choose Printer Port which is usually
LPT1:.
Click Next.
Click on Yes for the question, "Do you want your Windows-based
programs to use this printer as your default printer?". ** IMPORTANT
** This printer will become your default printer for all your programs.
This should be fine for 99% of your printing needs. If you decide
not to set this printer as your default printer, you will need to
do so before going into ResourceMate®. You may set it back to
another choice when you have exited ResourceMate®.
Click the Finish button to complete the installation of this printer
driver.
Run ResourceMate® again and try printing and/or previewing
I want to modify
the look of my reports/cards/labels - click
here
I want to print
reports as text-only (ASCII) to a file - click
here
I am looking
for examples on how to use ResourceMate's Browser to include/exclude
items on my reports.
The newest ResourceMate®
manual has some examples of the usage of the Browser.
Also visit the newsletter archive page by clicking
here. Several past newsletters have some good Browser
examples.
Name on the top
of all screens and reports was entered incorrectly - click
here
Series Report:
It is showing items that have no series information.
The Items by Series report
lists all items that have no series information at the top of the
list. It displays their titles since they have no series
information. To filter out these entries from the report do
the following:
- Select "Items by
Series" report
- Answer "Yes"
to the prompt "Do you want to select a specific group of items?"
- In the "Browser"
dialog box that appears, change the default search field
from "Title" to "Series" (under table
of contents in the manual, see section BROWSER -- immediately after
the section ITEMS/MULTIMEDIA TAB).
- Change the default operator
from = to <> (which means
'not equal to' or 'false'). Now press TAB
- A long highlighted "comparison
value" field will be displayed along with an check box entitled
"Empty". Click in the check box to turn it on, then
press TAB.
- This selects the "Done"
radio button. Simply press TAB again to complete
the filter.
These steps tell the program
to create the Item by Series report but to use only those
items whose "Series" field is not empty.
(Note: in a future release,
the behaviour of this report will be changed so that it will automatically
exclude items with no series information.)
"SQL column
'XXXXX' not found"
"Program
with error: BREPORT" - click
here
Back
to Top
Reports:
Modifying/customizing reports/cards/labels:
Some
advanced help for modifying reports is available from the following
links:
Report Modification
- Overview/Commands/Fieldnames
Report Modification - Name Report - change so
name is reported as last name, first name
Report Modification - Series Report - change
so it just lists Series names, not items
Report Modification - Library Labels - change
so labels print title, sub-title and series
Report Modification - Library Labels - change
so labels print title and sub-title
Report Modification - Library Labels - change
so labels print author, 2nd author and 3rd author
Report Modification - Library Labels - change
so labels print author and 2nd author
Report Modification - Cards - add donor
information to the shelf or inventory card
Report Modification - Cards - add sub-title to the top line of the Title
card
Report Modification - Cards or Labels -
Change the font size
Report Modification - Cards or Labels don't
line up on stock properly
Report Modification - Adding the "cut paper" command
for Receipt printers
How do I change
the report margins? - click here
Report
Modification - Cards or labels - Change the font size
First make sure you have
selected the correct printer type. In ResourceMate® click on Utilities,
then click on Choices... or Select Printer Type.
Next:
- Click on the Reports
menu, Print Library Cards or Print Library Labels.
- Click on the Modify
button.
- When asked, "Are
you sure you want to modify?", answer Yes.
- Once in the Modify screen,
press Ctrl and F10 together to
maximize the screen.
- You'll see three
horizontal dividing bars, called Page Header, Detail, and
Page Footer. Double-click on the bar called Detail.
All of the objects/boxes between Page Header
and Detail should now have tiny marks on their edges and
corners indicating that they have been selected. (Click
here to learn more about ways
of selecting objects in Modify mode).
- Click on the Object
Menu (new menu added on the top line at the right)
- Choose Font...
- Change the new font
size you wish and click Ok.
- Click on File
and choose Close. Answer Yes to
the prompt "Do you want to save changes?".
This changes the font for
all objects in the window. If you want to change the
font for only one object, select only it by clicking on it once, rather
than the technique described above that selects all objects.
Also click
here for links with more details on modifying these and other
reports:
Back
to Top
Report
Modification - Cards - add donor information to the shelf or inventory
card
Note: You must be at version
2.0f or later for this procedure to work. (How
do I tell what version I am at?)
Note: If you have made other custom changes to your cards this modification
may OVERWRITE them. Check with Support if you have any questions.
- Go into ResourceMate®.
- Click
on the Utilities menu and choose User Defined Field Names.
Determine which user defined field contains your Donor
information and write this down. For example your Donor information
might be stored in the 2nd user defined "character" field
called Char. Field 2.
- Close the User Defined Fields window.
- Click on Reports
then on Print Library Cards.
- Click on Modify. Click Ok on the warning and information
screens. (You are now in the report modify screen).
- Maximize the inner window (if it isn't maximized already) by pressing
the keys at the same time Ctrl+F10
- Below you will
find new field code that you must copy EXACTLY. First choose which
code you should copy (based on what you wrote down in the first step)
and then, with your mouse, do one highlight-and-copy (Ctrl-C) operation
to ensure you don't insert any unwanted carriage returns into the
code you copy:
If you determined in the
first step that your Donor information is in Char. Field 1
highlight and copy...
pubinfo+chr(13)+chr(13)+iif(!empty(libnotes),alltrim(libnotes)+chr(13)+chr(13),'')+iif(inventyn,alltrim(shelfinfo)+iif(!empty(uc1),"
donor: "+alltrim(uc1),'')+chr(13)+chr(13),'')+libsubj()
If you determined in the
first step that your Donor information is in Char. Field 2
highlight and copy...
pubinfo+chr(13)+chr(13)+iif(!empty(libnotes),alltrim(libnotes)+chr(13)+chr(13),'')+iif(inventyn,alltrim(shelfinfo)+iif(!empty(uc2),"
donor: "+alltrim(uc2),'')+chr(13)+chr(13),'')+libsubj()
If you determined in the
first step that your Donor information is in Char. Field 3
copy...
pubinfo+chr(13)+chr(13)+iif(!empty(libnotes),alltrim(libnotes)+chr(13)+chr(13),'')+iif(inventyn,alltrim(shelfinfo)+iif(!empty(uc3),"
donor: "+alltrim(uc3),'')+chr(13)+chr(13),'')+libsubj()
If you determined in the
first step that your Donor information is in Char. Field 4
highlight and copy...
pubinfo+chr(13)+chr(13)+iif(!empty(libnotes),alltrim(libnotes)+chr(13)+chr(13),'')+iif(inventyn,alltrim(shelfinfo)+iif(!empty(uc4),"
donor: "+alltrim(uc4),'')+chr(13)+chr(13),'')+libsubj()
If you determined in the
first step that your Donor information is in Char. Field 5
highlight and copy...
pubinfo+chr(13)+chr(13)+iif(!empty(libnotes),alltrim(libnotes)+chr(13)+chr(13),'')+iif(inventyn,alltrim(shelfinfo)+iif(!empty(uc5),"
donor: "+alltrim(uc5),'')+chr(13)+chr(13),'')+libsubj()
- Once you have highlighted
and copied the proper code above, return to ResourceMate® and
double-click on the field that starts with: pubinfo+chr(13)+
...
- This should open the Report
Expression window.
- Click on the Expression button. This should open
the Expression Builder window.
- Press Ctrl-V to paste your copied text. (It will
replace the contents of the box called "Expression for field
on report".) You should see the contents of that box change when
you pressed Ctrl-V.
- Click OK.
- Click OK again.
- Click on the File
menu and choose Close.
- Click Yes to the question, "Do you want to
save changes?"
- Try your report changes. NOTE: Donor information (including the
word "Donor:" will only show if a donor is actually assigned
to that item.)
Also click
here for links with more details on modifying these and other
reports.
Back
to Top
Report
Modification - Cards - add sub-title to the top line of the Title card
- From the Print Library
Cards screen click Modify. Click Ok on the warning
and information screens.
- Press CTRL + F10 together to maximize the modify area.
- Double-click on the field box called line1
- You should now
be in the Report Expression window.
- Press TAB until the you have highlighted the original contents in
the box immediately to the right of the "Expression..."
button.
- Replace the current highlighted contents with EXACTLY the following
code (with your mouse do one highlight-and-copy operation to ensure
you don't insert any unwanted carriage returns into the expression.
Paste [ctrl-V] into the field):
iif(line1<>title,line1,alltrim(line1)+iif(not empty(subtitle),'
: '+subtitle,''))
- Click OK
- Click on the File menu and choose Close
- Click Yes to the question, "Do you want to
save changes?"
- Try your report changes. NOTE: The change will only appear at the
top of the Title card.
Also click
here for links with more details on modifying these and other
reports.
Back
to Top
Report
Modification - Cards or Labels don't line up on stock properly
Make sure you have selected
the correct printer type. Click on Utilities then
on Choices. (If you have version 2.0d click
on Utilities then on Select Printer Type).
If you had the correct
printer type, or you changed the printer type and the alignment is
still not good...
- Go into Reports, Print
Library Cards or Print Library Labels.
- Click on the Modify
button.
- Answer Yes to "Are
you sure you want to modify?"
- Press Ctrl-F10 to maximize
the screen.
- You'll see three
horizontal dividing bars, called Page Header, Detail, and
Page Footer. Double-click on the bar called Detail.
All of the objects/boxes between Page Header
and Detail should have tiny marks on their edges and corners
indicating that they have been selected. (Click on the "Report
Modification" link below to learn more about selecting objects).
- On your keyboard
use the Left, Right, Up and Down arrow keys to move all the selected
objects a little at a time in the necessary direction. If
your label/card text is riding too close to the top of the
label/card, then move the selected boxes down.
- Click on the File menu
and choose "Close". Answer Yes to "Do you want to
save changes".
Print on blank paper and
compare to label or card stock too ensure they line up properly. You
may need to repeat this procedure a few times until the cards or labels
line up properly.
Also click
here for links with more details on modifying these and other
reports.
Back
to Top
Report
Modification - Name Report - change so name is reported as last name,
first name
To change the name
report so the name is reported as Last name followed by First name:
Double click on the field
that now says:
iif(empty(nmtitle),'',alltrim(nmtitle)+'
') + iif(empty(nmfirst),'',alltrim(nmfirst)+' ') + iif(empty(nmlast),'',alltrim(nmlast))
Change it to say:
alltrim(NmLast)+', '+alltrim(NmFirst)
Tip: You
can highlight and cut the above changes from this web page and paste
into the field.
Also click
here for links with more details on modifying these and other
reports:
Back
to Top
Report
Modification - Library Labels - change so labels print title, sub-title
and series
To change the library labels
so they print title, sub-title and series
Click on Reports; click
on Print Library Labels; click on Modify; continue with instructions
below...
To change the Sign
out card label:
Double click on the field/box
that now says: Alltrim(SoTitle)
This will open the "Report
Expression" window.
In the box to the right of the "Expression..." button, change
the text to say exactly:
Alltrim(SoTitle) + iif(!empty(SoSubtitle),
':' + Alltrim(SoSubtitle),"") + iif(!empty(SoSeries), '
(' + Alltrim(SoSeries) + ')' ,"")
To change the Pocket
label:
Double click on the field/box
that now says: alltrim(PoTitle)
This will open the "Report
Expression" window.
In the box to the right of the "Expression..." button, change
the text to say exactly:
Alltrim(PoTitle) + iif(!empty(PoSubtitle),
':' + Alltrim(PoSubtitle),"") + iif(!empty(PoSeries), '
(' + Alltrim(PoSeries) + ')' ,"")
Tip: You
can highlight and cut the above changes from this web page and paste
into the field.
Also click
here for links with more details on modifying these and other
reports.
Back
to Top
Report
Modification - Library Labels - change so labels print title and sub-title
To change the library labels
so they print title and sub-title...
To change the Sign
out card label:
Double-click on the field
that now says:
alltrim(sotitle)
Change it to say:
alltrim(SoTitle) + iif(!empty(SoSubtitle),
':' + alltrim(SoSubtitle),"")
To change the Pocket
label:
Double-click on the field
that now says:
alltrim(potitle)
Change it to say:
alltrim(PoTitle) + iif(!empty(PoSubtitle),
':' + alltrim(PoSubtitle),"")
Tip: You
can highlight and cut the above changes from this web page and paste
into the field.
Also click
here for links with more details on modifying these and other
reports:
Back
to Top
Report
Modification - Library Labels - change so labels print author, 2nd author
and 3rd author
To change the library labels
so they print author, 2nd author and 3rd author
To change the Sign
out card label:
Double-click on the field
that now says:
alltrim(soauthor)
Change it to say:
alltrim(soauthor) + iif(!empty(soauthor2),';'+alltrim(soauthor2),"")
+ iif(!empty(soauthor3),';'+alltrim(soauthor3),"")
To change the Pocket
label:
Double-click on the field
that now says:
alltrim(poauthor)
Change it to say:
alltrim(poauthor) + iif(!empty(poauthor2),';'+alltrim(poauthor2),"")
+ iif(!empty(poauthor3),';'+alltrim(poauthor3),"")
Also click
here for links with more details on modifying these and other
reports:
Back
to Top
Report
Modification - Library Labels - change so labels print author and 2nd
author
To change the library labels
so they print author and 2nd author
To change the Sign
out card label:
Double-click on the field
that now says:
alltrim(soauthor)
Change it to say:
alltrim(soauthor) + iif(!empty(soauthor2),';'+alltrim(soauthor2),"")
To change the Pocket
label:
Double-click on the field
that now says:
alltrim(poauthor)
Change it to say:
alltrim(poauthor) + iif(!empty(poauthor2),';'+alltrim(poauthor2),"")
Tip: You
can highlight and cut the above changes from this web page and paste
into the field.
Also click
here for links with more details on modifying these and other
reports:
Back
to Top
Report
Modification - Adding the "cut paper" command for Receipt
printers
Most receipt printers support
the ability to automatically cut the receipt once printing has been
completed. By default, the Print Receipt report template in ResourceMate®
does not cut the receipt; each receipt must be torn off by hand after
it is printed.
To modify the report template
to cut the paper automatically, use one of the following methods.
(Method #1 may not be available depending on the receipt printer model
you have installed on your system).
Method #1 –
using Windows Control Panel:
- click the Windows START button.
- If you see Settings, click on it. If not, move to the next step.
- Click on Control Panel, then on Printers & Faxes.
- Right-click on the name of your installed receipt printer.
- Choose Properties from the small context menu that
displays.
- Click on the Print Options tab.
- Change "Cut action" to "Form feed / Full cut"
or to "Form feed / Tear bar" or to a similar setting. (These
may vary from printer driver to printer driver).
- Click OK to save your changed setting.
- Test your changes by choosing File > Names in ResourceMate®,
choosing one library user who has items checked out, and clicking
the Print Receipt button.
Method #2 –
using Report Modify:
- Find the documentation for your receipt printer and determine the
control character(s) it defines as needed to perform the page cut.
For example, on some receipt printers the "cut" character
is simply the letter "l"
(lowercase 'L'). Write this information down and make note if it is
uppercase or lowercase, if applicable. If you cannot find the "cut"
character information, do not proceed further with these
steps but contact your printer's manufacturer to determine the code.
- In ResourceMate®
click on Reports > On Loan Reports.
- Click on either the All Names button or the Search button and choose
one name for whom loans exist. (This will be used at the end for testing
your changes). Highlight the name and press [Enter].
- Click Continue.
- Click once on the report called "Checkout Receipt" to
highlight it.
- Click the Modify Report button at the bottom, then click OK
to dismiss the "information has been posted..." message.
- Press [CTRL] and [F10] together
to maximize the Modify window to see the report format on a full screen.
- We will now increase the size of the Group Footer
area: Move your mouse pointer over the small rectangle just to the
left of the bar called Group Footer. Your mouse pointer should change
to an up-down arrow.
- Now click and hold and drag that small rectangle down about a 1/4
inch (using the ruler guide on the screen). This should result in
a larger blank white space under the word "Total" and the
data box "reccnt".
- From the vertical list of buttons along the top-left side, click
on the large capital 'A'.
- Move your mouse to point to the white space below the word "Total".
Your mouse pointer should now be a text insert pointer (also knows
as an "I-Beam").
- Click once in the white space below the the "reccnt" box.
This should result in a blinking vertical bar on the white space.
- Before actually typing any text, click on the Object
menu and choose Font...
- From the Font: list choose the font called Control.
- Click the OK button.
- On your keyboard type your specific "cut" character(s)
that you wrote down in the first step (in our example that would be
a lowercase 'L'). Ensure you have typed the character(s) in the same
case (upper or lower) that it is defined in your printer's documentation.
- Click the File menu and choose Close.
Answer YES to the "Do you want to save changes?"
prompt.
- To test your changes
click on the OK button.
- Answer YES to the prompt "This will print
a receipt for every person who has items on loan" prompt. (Remember:
you chose just one name at the start of this procedure so you should
only get one receipt from this test).
- You can examine the screen preview. Click OK and
you may choose to print this test to the actual receipt printer.
"SQL column
'XXXXX' not found"
"Program
with error: BREPORT" - click
here
Back
to Top
Utilities:
Backing up or restoring data:
"I tried
opening the backup file but it contains garbage and gobbledygook"
Backup files created by
ResourceMate® are
not viewable in any program outside ResourceMate®.
The file RM.SQZ is
a compressed binary file and can only be utilized by ResourceMate®’s
“Restore” function.
If you wish to create an
ASCII text listing of your items choose one of the following methods:
a) Use the Item File
- Generic Export function in ResourceMate® Plus
to export your items to one of the ASCII text formatted files (Comma
delimited; delimited with Tab; SDF); or,
b) Install a “Generic
Printer” driver into Windows and have it set as your default
printer. In ResourceMate® choose one of the many reports and have
the output directed "To file". The generic printer driver
will be used and will create an ASCII text file version of the report
results.
Backup
Problems
Some backup related problems
include:
- Machine locks or re-boots
while backing up data;
- The
message "Insert next diskette", "Wrong diskette"
continually flashes in the top right hand corner when the first
diskette is filled.
ResourceMate® version
2.0d and higher have a check box on the Backup Data Files Screen that
says Use Batch Files. Turn that box ON and re-run
the backup.
If that does not solve
the problem,
- Exit ResourceMateŽ
- Go to the MS-DOS Prompt.
Click
here for instructions.
- Change to the ResourceMateŽ
installation folder.
Click
here for instructions.
- Run one of the following
batch files by typing in its name and pressing the Enter
key:
backah
- backing up to the a: drive onto high density diskettes (this
is the most common choice)
backbh
- backing up to the b: drive onto high density diskettes
backal
- backing up to the a: drive onto low density diskettes
backbl
- backing up to the b: drive onto low density diskettes.
- Once the backup is complete,
at the MS-DOS prompt type
Exit and press the Enter
key to return to Windows™
Utilities:
Search screen password:
I forgot my password
or my password doesn't work anymore - Click
here
Program
error messages (listed alphabetically):
"Cannot
create c:\rm\lists"
There is a problem with
the WinZip self extracting utility and Windows 98 in which required
subfolders are not created during the Unzip process. To fix this,
navigate to the rm folder(or the folder
that contains your installation of ResourceMateŽ) and manually create
a subfolder called lists. Now rerun the
self-extracting update program.
"Divide
by 0 error"
or "Foxprow - An error has occurred in your program"
- click here.
"Error
Opening Input" ... (Restoring Data Files)
You might be using the
wrong ResourceMate® function to open the data on the disk(s).
If you created the disk(s)
using the Backup Data Files function on the Utilities
menu, then you must use the the Restore
Data Files function on the Utilities menu to restore
the data.
If you or a volunteer created
the disk(s) using the Volunteers--Copy Entered Items to Diskette
function on the Plus menu, then you must
use the Main Computer--Add Items from Diskette function on
the Plus menu to merge the data into the main database.
This error message may
also be caused because of a mechanical alignment difference between
the floppy drive on the computer that produced the backup and the
floppy drive on the computer trying to restore the data from the diskette.
It may mean a problem exists with one of the floppy diskette drives.
If you are restoring from one computer to another, redo the backup
and try restoring again. If the problem persists, have a computer
technician verify the reliability of both floppy drives.
"Expression
evaluator fault"
- If you are using the widely
available HotSend utility, you will need to disable
it when ResourceMateŽ is running. Contact Jaywil Support for
more information; or,
- Click here
for another solution to the "expression evaluator fault"
error if you are printing or previewing reports/cards/labels and are
using an HP DeskJet printer.
"File access
denied"
This message usually occurs
if you have tried to run ResourceMate® while it is already running.
This may also occur if ResourceMate® is installed on a shared
network drive and someone is already running ResourceMate®. Before
starting ResourceMate® check your Windows™ taskbar
at the bottom of your screen to ensure that the program is not already
running.
"Foxprow
- An error has occurred in your program"
or "Divide by 0 error" - click
here.
"Foxprow
has caused a General Protection Fault in Module xxxxxx"
This error is usually related
to a video driver conflict with Windows™ 3.1. (If you are using
an HP DeskJet printer and getting this error when printing/previewing,
click here instead).
You may switch your current
video driver settings to VGA for immediate results
or pick up and install a generic Super VGA Driver at our web page
svga.html.
To switch the video driver
to VGA using Windows™ 3.1:
- Open the "Main"
Group
- Double Click on Windows
Setup
- Click on Options
- Choose "Change
System Settings"
- Make a note of the
current display settings
- Click on Display
- Choose VGA or VGA (version
3.0)
- Click on Ok
NOTE: You may need your
Windows diskettes to carry out this procedure.
A message may appear that
says "A driver for this display is already ..." Choose Current.
The video driver is now
set to VGA. Your display will be set to 640x480 with
16 colours.
"Index does
not match table"
- Exit ResourceMate®.
- Delete all files in the
RM installation folder that have a file extension of cdx
(
"How do
I determine my ResourceMate® installation folder?")
- Run ResourceMate®.
- If you are given a message
with an Ignore button, click Ignore. NOTE
OF CAUTION: Only take an Ignore option when advised by Jaywil Software.
After you get into ResourceMate®
you will need to re-index as follows:
- Go into the Utilities
menu
- Choose "Re-Index,
Refresh and Pack Data Files".
(version 2.0e or higher): when presented with the three check boxes,
only select "re-index" and "refresh". Press Yes.
(earlier versions): click on Yes.
When re-indexing is complete
the problem will be solved.
"Insufficient
Memory error"
You may get this error
if you have too many Categories or Locations or Statuses in your ResourceMate®
Main screen. You will need to send us a backup of
your data (Utilities menu, choose Backup Data Files)
so we can move your data to other fields that can hold more information.
For instance, we will move the Location data to the Call #1 Field
on the Library Card Information screen.
Remember to send us the
backup files from each backup disk in your set. If
your backup takes, say, three diskettes, will need all three files.
You can send us the backup
files by attaching them to an email and sending it to info@resourcemate.com.
"Invalid
Function, argument value, type or count. Program with error: PROPCENT"
Contact Jaywil Software
by phone toll-free at 800-815-8370 or by e-mail at info@resourcemate.com.
"Invalid
Subscript Reference"
If you receive this message
while going into File, Items:
- Go into the Utilities
Menu
- Choose "Select
Resource Type" (depending on your version, you may need to
click on Choices... first)
- Click on the Popup
and choose "Books"
- Click on Ok.
You may now continue entering
items.
"I/O Operation
Failure" ... (Restoring Data Files)
This is most often caused
by a faulty floppy diskette. Try using a new diskette and making a
new backup. Then re-try the Restore operation.
This error message may
also be caused because of a mechanical alignment difference between
the floppy drive on the computer that produced the backup and the
floppy drive on the computer trying to restore the data from the diskette.
It may mean a problem exists with one of the floppy diskette drives.
If you are restoring from one computer to another, redo the
backup and try restoring again. If the problem persists, have a computer
technician verify the reliability of both floppy drives.
"MEMO file
missing or invalid"
If ResourceMate® was
unexpectedly or improperly shutdown (computer failure, power failure
etc), one of your data files may have this error. Since this is a
data problem, reinstalling ResourceMate® will
not fix the problem.
1. Go to web page http://www.resourcemate.com/rmupdate.html
and download and apply the latest update. You will need to do this
even if you recently downloaded and applied an update. The process
of updating usually repairs the "MEMO file missing or invalid"
error. After applying the update, start ResourceMate® and see
if the problem is gone. Note that you will need to have an active
Support contract with us to download program updates. If you don't
have a Support contract or the update did not repair the problem,
see step #2.
2. If the error still exists,
you will need to send us a new backup that contains
the error so we can repair it. Sending an older backup will not fix
the problem. If you can access the Utilities menu in ResourceMate®,
choose Backup Data Files and attach the rm.sqz
file (or files) created on the diskette (or diskettes) to an e-mail
to Jaywil Software. If you cannot access the Utilities menu
in ResourceMate®, you can create a backup from MS-DOS. Here's
how to do this:
- Exit ResourceMate®
if you are in the program.
- Go to the MS-DOS Prompt.
Click
here for instructions.
- Navigate to the ResourceMate® installation folder.
Click
here for instructions.
- Put a new floppy disk in the drive. (Never backup onto your
most recent backup disks; if your computer fails during the backup
you could lose both your last backup and your current data!)
- At the DOS prompt type:
BACKAH
[press the Enter key]
BACKAH is a built-in batch
file that will begin backing up your data to one or more floppy disks.
- Follow the prompts if the routine asks for more than one diskette.
- Check that it finishes without error.
- Once the backup is complete, at the MS-DOS prompt type
Exit and press the Enter key to return
to Windows™.
- Attach the rm.sqz
file (or files) created on the diskette (or diskettes)
to a new e-mail message and send it to us at info@resourcemate.com.
Please indicate in your
e-mail message that you are sending in data for a "MEMO file
missing or invalid" error and tell us your organization name.
We will fix the problem and return your data back to you as soon as
possible. You cannot
add or modify data while we are in possession of your backup.
Once we send the repaired data back to you, it will completely overwrite
your ResourceMate® database.
"Menu
manager internal consistency"
If you are using the widely
available HotSend utility, you will need to disable
it when ResourceMateŽ is running. Contact Jaywil Support for
more information
"Not a Table/DBF"
If ResourceMate® was
unexpectedly or improperly shutdown (computer failure, power failure
etc), one of your data files may have this error. Since this is a
data problem, reinstalling ResourceMate® will not
fix the problem.
1. Try the following to
see if the problem is corrected: if you can go back into ResourceMate®,
click on the Utilities menu then click on Re-index Refresh
and Pack Data Files. When the program presents three little check
boxes, select the second box only ("refresh")
and click "Yes". (The program may ask you if you want to
include the five Jaywil lookup lists; you may answer yes or no depending
on whether you use these lookup lists or not). After ResourceMate®
finishes the Refresh function, exit ResourceMate®
completely, then go back into ResourceMate® and see if the problem
has been solved.
2. If the problem persists,
go to web page http://www.resourcemate.com/rmupdate.html
and download and apply the latest update. You will need to do this
even if you recently downloaded and applied an update. The process
of updating usually repairs the "Not a Table/DBF" error.
After applying the update, start ResourceMate® and see if the
problem is gone. Note that you will need to have an active Support
contract with us to download program updates. If you don't have a
Support contract or the update did not repair the problem, see step
#3.
3. If the error still exists,
you will need to send us a new backup that contains
the error so we can repair it. Sending an older backup will not
fix the problem. If you can access the Utilities menu in
ResourceMate®, choose Backup Data Files and attach the
rm.sqz file (or files) created on the diskette (or
diskettes) to a new e-mail message and send it to us at info@resourcemate.com.
If you cannot access the Utilities menu in ResourceMate®,
you can create a backup from MS-DOS prompt. Here's how to do this:
- Exit ResourceMate®
if you are in the program.
- Go to the MS-DOS Prompt. Click here for instructions.
Click
here for instructions.
- Navigate to the ResourceMate® installation folder.
Click
here for instructions.
- Put a new floppy disk in drive. (Never backup onto your most
recent backup disks; if your computer fails during the backup you
could lose both your last backup and your current data!)
- At the DOS prompt type:
BACKAH
[press the Enter key]
BACKAH is a built-in batch
file that will begin backing up your data to one or more floppy disks.
- Follow the prompts if the routine asks for more than one diskette.
- Check that it finishes without error.
- Once the backup is complete, at the MS-DOS prompt type
Exit and press the Enter key to return
to Windows™.
- Attach the rm.sqz
file (or files) created on the diskette (or diskettes)
to a new e-mail message and send it to us at info@resourcemate.com.
Please indicate you are
sending in data for a "Not a table/DBF" error and tell us
your organization name. We will fix the problem and return your data
back to you as soon as possible. You cannot add or
modify data while we are in possession of your backup. Once we send
the repaired data back to you, it will completely overwrite your ResourceMate®
database.
"Record
is out of Range"
If you
receive this message and are using version 2.0d then...
(How do I tell
what version I have?) |
If you
receive this message and are using version 2.0e or later, then...
(How do I tell
what version I have?) |
Go into
the Utilities Menu
Choose Re-Index, Refresh and Pack Data Files
Click on Yes
When re-Indexing is completed the problem will be solved. |
Go into
the Utilities menu
Choose Re-Index, Refresh and Pack Data Files
When presented with the three check boxes, check off the first
box, Re-index, and the second box, Refresh
lists.
Click on Yes
(When the program starts to refresh the
lists it will ask you if you want to include the lists provided
by Jaywil Software. These are lookup lists that help you
enter data, but they add considerable size to your backups.
You may choose to use them or not. They will not
affect your actual item data. (In the new manual {copyright
2000} in the table of contents look under UTILITIES MENU / RE-INDEX,
REFRESH AND PACK DATA FILES. Also see under the table of contents
ITEMS/ MAIN TAB / AUTHOR). |
"SQL
column 'XXXXX' not found"
"Program
with error: BREPORT"
If you are using the Optional
Sort field on the Report Options window you will get
this error if you enter a data field name that is incorrect. For instance
if you were trying to sort by publisher and entered "publisher"
into the Optional Sort field, ResourceMate® will shutdown with
this error. The correct field name is publish. For
a list of all the correct field names visit the Report
Modification web page.
"Stack Fault
in Module xxxxxx"
If you receive this message:
- Go into the Utilities
menu
- Choose Re-Index,
Refresh and Pack Data Files
- Click on Yes
When Re-Indexing is completed
the problem will be solved.
"Table is
not ordered"
If the error message box
has an Ignore button, click on Ignore. Caution:
Only click on an Ignore button when advised by Jaywil Software.
After you get into ResourceMate®
you will need to Re-Index as follows:
- Go into the Utilities
menu
- Choose Re-Index,
Refresh and Pack Data Files
- Turn the first check
box ("Re-index") on
- Click on Yes
When Re-Indexing has completed
the problem will be solved.
Variable acc not
found Program VDETACC
To immediately solve this
problem, make sure you press Save Changes before
leaving the Item/Main screen before proceeding to the Library Card
Information screen. To solve this problem pickup the most recent version
of ResourceMate® at http://www.resourcemate.com/rmupdate.html.
"Variable
LOANEDSTR not found"
This error has been fixed
in the latest version of ResourceMate® which can be accessed on
our update page.
"Wrong diskette"
If you are trying to do
a backup, click here.
"Year is
less than 1999"
Older PC's are unable to
handle year-2000 dates and revert to a year of January 1, 1980 instead.
ResourceMateŽ detects this and issues the warning "Year is less
than 1999". This is to alert you to potential problems
in choosing dates in your ResourceMateŽ circulation screens.
Hit any key to cancel the
error message -- this will exit you from the ResourceMateŽ program.
You will need to set your
date and time each time you start up your computer. The easiest
way to do this is to edit your C:\AUTOEXEC.BAT file and include the
following two commands:
DATE
TIME
Close and save the AUTOEXEC.BAT
file and restart your computer.
"Your
subject file is big |
