MPLIC ILS & Tech Train

Upgrading Unicorn Application

2009-11-10T10:42:00.004-06:00

Unicorn is the overall name of our Integrated Library System. WorkFlows is the desktop application that we all use to access the ILS (desktop computers refer to all the individual staff computers throughout the system, as compared to the server which all the desktops connect to). We are currently using Unicorn 3.1 and we need to regularly update the ILS application as new versions are released.

By the time I came on board last year, Symphony 3.2 (the successor of Unicorn 3.1) had been released and Symphony 3.3 was around the corner. I opted to wait for Symphony 3.3, but when Symphony 3.3 was released recently, I noticed that the desktop RAM requirements increased. As you may recall, we had a difficult time with WorkFlows until we finally increased our desktop RAM to somewhere near the 1GB range, which is the recommended amount of RAM. The WorkFlows that comes with Symphony 3.3 has a recommendation of 2GB of RAM.

So I shifted gears and aimed for Symphony 3.2. I then saw that a server requirement for 3.2 calls for a newer version of Oracle (the underlying database embedded within Unicorn/Symphony and not related to the city-wide Oracle database). SirsiDynix can perform this upgrade, but it requires a two-hour downtime. And SirsiDynix can do this for free between the hours or 8am-5pm, but it costs quite a bit per hour to do this upgrade when the library is not open.

Along came the Veteran's Day holiday in which the library is closed and SirsiDynix is open. So, tomorrow, SirsiDynix will upgrade Oracle so that we can upgrade Unicorn in the near future. And we will save a good chunk of change in the process.

Stay tuned for more about the Symphony 3.2 upgrade.

Public Catalog Most Popular Lists

2009-10-28T13:29:00.002-05:00

A while back, I added some links on the public catalog page listing some popular titles and subjects. I would update this list manually, but the time it took to update forced me to update the list only once a quarter.

After an upgrade to our public catalog, I was able to utilize an automated tool that would do the same thing. Therefore, we now have the "Most Popular Lists" on every page of our public catalog. This list shows the top 5 Authors, Titles, and Subjects with the option to expand to the top 20 in each category. Of course, these list entries are links to searches for these topics. Rankings are taken directly from our circulation stats and are updated every Saturday night.

So, to review. These lists changed from manual quarterly updates to weekly automated updates. And these lists are located on every page instead of only on one page as it was before.

Behind the Scenes of Statistics (a general overview)

2009-10-21T14:53:00.004-05:00

OK. It has been nearly 5 months since my last post. I'm not promising anything, but in the spirit of openness and greater access, I'll give this another try.

Outside of regular "ILS" duties (see previous post), I also coordinate many of the statistics that we produce. Some statistics can be pulled directly from the ILS, such as circulation, user, catalog-type statistics. How many items do we have in the library? I can pull that up pretty quickly. How many items in each library? Can do. How many items in a certain location that have had no activity in the past 3 years? No problem.

But there are also a lot of statistics that do not come from the ILS. They come from you. How many people visited the library? How many reference questions did they ask? These are a bit harder to answer. These statistics require staff to measure usage and submit various forms. I have been exploring the idea of converting some of these forms to "webforms". Much like "online job applications" (which we love so much), you could enter data online with drop-down menus and text boxes. Instead of worrying about using the correct form and sending attachments to various people, you could enter the data online and click submit and be done with it. And computer usage statistics will soon be a lot easier for everyone as the automated computer sign-up allows for some detailed reporting.

So what do we do with these stats once we've collected them? Some are used to measure our own Goals and Objectives. This report is produced by the 5th of each month. We also produce Quarterly and Annual statistic reports. We also use these statistics for various surveys we receive throughout the year. Currently, I am working on the annual Tennessee public library statistics report. And we use these statistics to assist with any grant proposals or to provide answers to questions from other government offices or media.

If you have any questions about our statistics, please let me know and I'll see what I can find.

What is the ILS?

2009-05-29T11:06:00.002-05:00

My job title is ILS Coordinator. But what exactly is the ILS? It stands for Integrated Library System. This refers to the application that libraries use to help purchase items, catalog items, search for items, check items out to users, store user account information, and more.

The ILS application that we use is a product from SirsiDynix called Unicorn. We have version 3.1. This application is run on a server, but there is an application on each workstation called WorkFlows which allows us to perform ILS-related tasks in a Windows-based graphical environment. And while much of my work can also be performed in WorkFlows, from time to time I have to delve deep behind WorkFlows and perform tasks on the server itself, which is not a graphical environment.

The Unicorn product communicates with many other products on other servers. First, there is EPS. This is the application used for our Web-based catalog, which is the main interface that our customers have with our ILS system. They perform searches on our catalog via the internet, which sends the request to our EPS server, which grabs the information from the Unicorn server and sends it back to the customer on the Web. And while many of the tasks I perform on the EPS can be done on the Web-based interface, many times I find myself crawling through files and directories on the server.

Unicorn also communicates with SVA (Sirsi Voice Automation). Unicorn sends overdue and hold notices to SVA and SVA calls the customers and reads the notices. SVA will also need to request information from Unicorn from time to time when a customer calls our automated account line.

Then we have Director's Station which is a statistical web-based application. Unicorn sends information to this server once a day. This allows people to query the information stored on the Unicorn database without actually interfering with that information (such as circulation stats, user stats, collection stats, etc.). As of now, I am pretty much the only user of Director's Station. I use it to collect many of the stats that eventually appear on quarterly and annual reports. I also use it quite frequently when I receive questions regarding circulation or collection counts for specific libraries, locations, and time periods.

So coordinating the ILS involves making sure all of these applications work together. And as updates and upgrades occur to these applications, I have to make sure those occur smoothly and with as little down-time as possible. Speaking of "down-time", these applications will stop working from time to time (just like any other application), and it is up to me to get them back up and running, find out why they went down, and try to fix it so it doesn't happen again.

Unicorn also needs to be able to communicate with other third party applications such as OverDrive (the e-audio book application). OverDrive needs to be able to access information from Unicorn when customers attempt to check-out an e-audio book. And when we institute self-checkout and automated computer sign-up, these services will need to communicate with our ILS application as well.

On top of coordinating all of these machines, I also coordinate the connections between staff and customers and our ILS. That involves making sure we are using the ILS correctly, assisting in developing proper procedures, assisting with training, investigating mysteries, and more!

Behind the Scenes of Discarding

2009-05-26T13:43:00.002-05:00

When you discard an item, you check it out to your agency's discard account (HUMDISCARD, PWSDISCARD, etc.). The item is still in our catalog, but items that are checked out to a DISCARD account have a current location of DISCARD (instead of CHECKEDOUT). This current location is set to be shadowed (or not viewable) on the public catalog. Holds cannot be placed on these items as well.

While these items have been checked out to a discard account, we have not "really" discarded them. Therefore, once a week on Saturday, reports run which convert all items checked out to a discard account. These items are then "officially" set to a discard status. But that is not all.

Another report runs, also on Saturday after all of the Discard Convert reports. This is the "Discard Remove" report. It removes all discarded items from the catalog and produces a list of those items. Items that have bills associated with them are not removed. That is why you will still see quite a few "discard" items in our catalog.

Once a quarter, I take these weekly discard reports and perform a multi-step process in order to create a list of deleted items that we can use to update our holdings with OCLC.

Emailing Customer Surveys

2009-05-13T11:02:00.003-05:00

Last week we sent an email to all customers who had selected email as their preferred method of notification. As we see in my prior post, that is about 13% of our 360,000+ customers. This email asked our customers to fill out a survey. The last time we sent an email out like this was back in 2005 for our last customer survey.

We have since had about 2,800 people fill out the online survey. With many more weeks to go in our survey collection period, we have far surpassed the 1100 online surveys collected in 2005.

Also, about 20% of these emails bounced back. Over the years, people changed their email, but they did not inform us. Or, the email was entered incorrectly.

We regularly receive bounce backs from email notices we send daily. Circulation staff receive those bouncebacks and they change the customer's notification method to PHONE, erase the email, and place a note on the account requesting an updated email. Or, if an obvious error is found, it can be corrected (ex. blahblah@yahoo.cmo).

There is not much we can do about people changing emails and not informing us. But we can eliminate any typos (whether written down wrong by customer or entered incorrectly by staff). One way we will do this is by sending out a welcome email. This will be sent weekly to all customers who have created an account in the past week who have also chosen email as their notification method. This email will inform them of the types of notices they may receive. It will also allow us catch any bouncebacks before we actually send an overdue or hold notification.

While we do not want to start sending random emails to our customers, we feel that this will serve both the customer's needs and our own.

Behind the Scenes of Customer Notifications

2009-04-22T12:40:00.003-05:00

We send notifications to our customers regarding holds, overdue items, and assumed lost items. We send these notifications by email, telephone, or US mail and it is up to the customer to choose which method they prefer.

Currently, we have about 363,000 registered customers and here is the breakdown for notification preference:

84% TELEPHONE
13% EMAIL
3% US MAIL

Telephone customers will receive a hold notification and overdue notification. Our SVA service handles this process. It will attempt to notify the customer three times. If someone answers or an answering machine answers, it will cue the recording and will count as a notification. If SVA cannot notify the customer about an overdue item, then a mail notice will be sent at the same time that all other mail notices are sent (only for overdue, not holds). If an item status changes to assumed lost, these customers are sent a US Mail notice.

Email customers receive several notifications since it is so much easier to send emails. They receive a hold notification on the day the hold becomes available. If the item has not been picked up after four days, they receive another email. They also receive an email three days prior to an item being overdue, three days after the item is overdue, and ten days after the item is overdue. If an item status changes to assumed lost, these customers are sent a US Mail notice.

US Mail customers receive only one overdue notice, and that is all. They do not receive hold notifications. They will also receive, via US Mail, any assumed lost notices.

LOST-ASSUM vs. LOST-CLAIM

2009-04-13T15:17:00.003-05:00

We have talked about "Current Location" in a previous post. It tells you where the item is currently located. Two of these locations may seem redundant, but they are, oh, so different. They are LOST-ASSUM (aka Assumed Lost) and LOST-CLAIM (aka Claims Returned).

In short, LOST-ASSUM are items that are so long overdue that we assume they are lost. LOST-CLAIM are items that customers claim to have returned but were never discharged.

Every two weeks, I run several reports on our system that produce overdue mailer notices. One of these notices is the assumed lost notice. This report finds all items that are currently checked out to customers that are over 60 days overdue (NOTE: Since the report is run just once every two weeks, items could actually be up to 73 days overdue before they are assumed lost.) This report changes the "Current Location" of these items to LOST-ASSUM and bills the associated User ID for the cost of the item and a processing fee. Notices are mailed to all customers (even to those who have selected PHONE or EMAIL as their notification choice (more on that on another post)). If the customer returns the item, the customer only owes the maximum $5.00 fine.

At any point in time, a customer may state that they have returned an item that, according to us, was never discharged from their account. A report is created every two weeks that is sent to each agency that lists all items that have been claims returned for the past two weeks. Staff then attempt to locate these items.

Academy Awards - Best Picture

2009-04-13T14:03:00.000-05:00

1927/28 (1st) -Wings
1928/29 (2nd) -The Broadway Melody
1929/30 (3rd) -All Quiet on the Western Front
1930/31 (4th) -Cimarron
1931/32 (5th) -Grand Hotel
1932/33 (6th) -Cavalcade
1934 (7th) -It Happened One Night
1935 (8th) -Mutiny on the Bounty
1936 (9th) -The Great Ziegfeld
1937 (10th) -The Life of Emile Zola
1938 (11th) -You Can't Take It with You
1939 (12th) -Gone with the Wind
1940 (13th) -Rebecca
1941 (14th) -How Green Was My Valley
1942 (15th) -Mrs. Miniver
1943 (16th) -Casablanca
1944 (17th) -Going My Way
1945 (18th) -The Lost Weekend
1946 (19th) -The Best Years of Our Lives
1947 (20th) -Gentleman's Agreement
1948 (21st) -Hamlet
1949 (22nd) -All the King's Men
1950 (23rd) -All about Eve
1951 (24th) -An American in Paris
1952 (25th) -The Greatest Show on Earth
1953 (26th) -From Here to Eternity
1954 (27th) -On the Waterfront
1955 (28th) -Marty
1956 (29th) -Around the World in 80 Days
1957 (30th) -The Bridge on the River Kwai
1958 (31st) -Gigi
1959 (32nd) -Ben-Hur
1960 (33rd) -The Apartment
1961 (34th) -West Side Story
1962 (35th) -Lawrence of Arabia
1963 (36th) -Tom Jones
1964 (37th) -My Fair Lady
1965 (38th) -The Sound of Music
1966 (39th) -A Man for All Seasons
1967 (40th) -In the Heat of the Night
1968 (41st) -Oliver!
1969 (42nd) -Midnight Cowboy
1970 (43rd) -Patton
1971 (44th) -The French Connection
1972 (45th) -The Godfather
1973 (46th) -The Sting
1974 (47th) -The Godfather Part II
1975 (48th) -One Flew over the Cuckoo's Nest
1976 (49th) -Rocky
1977 (50th) -Annie Hall
1978 (51st) -The Deer Hunter
1979 (52nd) -Kramer vs. Kramer
1980 (53rd) -Ordinary People
1981 (54th) -Chariots of Fire
1982 (55th) -Gandhi
1983 (56th) -Terms of Endearment
1984 (57th) -Amadeus
1985 (58th) -Out of Africa
1986 (59th) -Platoon
1987 (60th) -The Last Emperor
1988 (61st) -Rain Man
1989 (62nd) -Driving Miss Daisy
1990 (63rd) -Dances With Wolves
1991 (64th) -The Silence of the Lambs
1992 (65th) -Unforgiven
1993 (66th) -Schindler's List
1994 (67th) -Forrest Gump
1995 (68th) -Braveheart
1996 (69th) -The English Patient
1997 (70th) -Titanic
1998 (71st) -Shakespeare in Love
1999 (72nd) -American Beauty
2000 (73rd) -Gladiator
2001 (74th) -A Beautiful Mind
2002 (75th) -Chicago
2003 (76th) -The Lord of the Rings: The Return of the King
2004 (77th) -Million Dollar Baby
2005 (78th) -Crash
2006 (79th) -The Departed
2007 (80th) -No Country for Old Men
2008 (81st) -Slumdog Millionaire
2009 (82nd) -The Hurt Locker

Item Format

2009-03-30T11:54:00.002-05:00

As mentioned in the previous post, Item Types can be a decent search limiter, but sometimes they can be a bit too limiting.

There is another search option that can be used to limit your search that may be a better tool to use. It is called "Format".

I have created a page that lists each Format as well as a description. Click here to see this page. It is also listed on the main WorkFlows page.

You can limit your searches to specific formats by clicking on the Search Options button and using the Format drop-down menu.

When using the online public access catalog, you can limit your search to a specific format by using the advanced search and using the Format drop-down menu.

Item Types

2009-03-23T11:17:00.002-05:00

As noted in a previous post, each item is given a Home Location. Each item is also given an Item Type. Not only does this give us a decent description of the item, it also allows us to create different circulation rules depending on the Item Type. And it can also be a decent search limiter from time to time.

I have created a page that lists each item type as well as a description and any notes (if any). Click here to see this page. It is also listed on the main WorkFlows page.

Item Types can be seen on the Call Number/Item tab in WorkFlows. You can limit your searches to specific item types by clicking on the Search Options button and using the Item Type drop-down menu.

When using the online public access catalog, item types can be seen by clicking an individual title. The item details page lists the item type description instead of the item type code that we see in WorkFlows. You can limit your search to a specific item type by using the advanced search and using the Item Type drop-down menu.

Home Location vs. Current Location

2009-03-12T11:22:00.000-05:00

Now that we have talked about a record, let's talk about the details. A record describes a certain material, but we may buy many copies of that book or CD or whatever. These are called items. Each item is given a Home Location, an Item Category 1 and 2, an Item Type, and so on. Today, we'll talk about Locations.

Each item has a "Home Location". This can be something like FICTION, NONFICTION, POPULAR, REFERENCE, etc. The Central library has many unique Home Locations such as HUM_FIC (which stands for Humanities Fiction and is used instead of FICTION), or C_EASY_FIC (which stands for Children's Easy Fiction and is used instead of EASY_FIC).

This is similar but different to an item's "Current Location". If the Current Location is the same as the Home Location, then the item should be on the shelf. But the Current Location can also be CHECKEDOUT, DISCARD, MISSING, INTRANSIT, LOST-ASSUM, LOST-CLAIM, etc.

In WorkFlows, the Home Location and the Current Location can be seen on the Call Number/Item tab. The "item tree" displays the Current Location. The box on the right will show the Home Location as well as the Current Location.

On the Online Public Catalog, the Current Location can be seen by clicking on a title that displays in your results. The ensuing screen will display a list that is similar to the "item tree" that appears on the left side of the Call Number/Item tab in WorkFlows. This lists the Current Location only. The Home Location cannot be seen unless the Current Location is the Home Location. Also, this list does not show items that have a Current Location of MISSING, DISCARD, LOST-ASSUM, LOST-CLAIM, etc. These are "shadowed".

Online Renewals

2009-03-06T08:21:00.002-06:00

When customers access their account online, they have the option to renew their items. However, the list of items is not limited to those items which CAN be renewed. It simply lists all of their items they have checked out.

If a customer selects all items and renews, they receive a list of items that did renew followed by a list of items that did NOT renew. A problem occurs when customers do not examine this list and assume that all items were renewed. Fines continue to accumulate on the items that were not renewed, and the customer is not happy when they find this out the next time they try to check something out.

Not helping this matter was the brief message a customer received when they renewed items. It stated, "(x) items were renewed." A couple of weeks ago, I changed it to "(x) items were renewed. Please scroll down to see is some items were not renewed."

I also changed the message that appears below an item if that item could not be renewed. It used to state, "renewal failed". It now states,"Renewal failed. 1) Either item already renewed once; 2) Item is a Popular Book or New DVD and cannot be renewed; 3) Or another customer has a hold on the item."

I also added a bullet to the online help for "Renewing Items". It now states:

To renew online, follow these steps:

Log in to your account.
In the My Account area, click Renew My Materials.
Select the check box by items to renew, or mark Select All.
Click Renew Selected Items.
You will then receive a list of the items that successfully renewed followed by a list of items that could not be renewed. Please review this list carefully.

I have also submitted an enhancement request to SirsiDynix that could hopefully address this issue in future upgrades. Other library systems have stated that their customers report the same experience. One way would be to possibly limit the list of items that the customer sees prior to selecting items to renew. This list would be limited to only those items that can be renewed. Or, perhaps a simpler way would be to reverse the renewal results so that all of the items that failed to renew are listed first.

What is the Catalog?

2009-02-26T11:22:00.004-06:00

Part I in a series on basic searching...

Knowing what the catalog is will help you search that catalog. In simple terms, the catalog is a collection of records that describe all of the material we have in the library. Each record has numerous fields which house certain types of information. What are the three main types of information libraries collect? Anyone?

Answer: Author, Title, and Subject.

There are other fields which store information such as call number, publisher, etc. Another useful field is the Contents field which stores information such as song titles on CDs or music scores, short story titles in short story collections, and such. Some records even have a Summary field which provides a brief description of the contents of the material.

When searching in WorkFlows, these fields can be viewed by selecting the Description tab that appears once you have your results. On the online catalog, these fields can be seen by clicking on a title in a results list. Then, click on Catalog Record which appears in a column on the right side of the page.

Where Am I? Or, The Importance of the USER ID When Logging into WorkFlows

2009-02-23T15:49:00.003-06:00

The process of logging into WorkFlows is trickier than you might expect. You should always make sure that you log in with the User ID and PIN of the location that you are currently located. Many of us work in multiple locations and almost all of us help out at Central on Sundays. And, for example, if you log in using the Randolph User ID and PIN when you are actually at Highland, then WorkFlows thinks you are at Randolph.

What are the implications of this? If you check out any books, then stats are assigned to Randolph and not Highland. If you place a book on hold to be picked up at Highland, the item is placed intransit to Highland from Randolph even though the book is already at Highland. If you discharge books that belong to Highland and reshelve, the items are still intransit from Randolph to Highland. Basically, all sorts of chaos ensues.

And you thought remembering the cryptic 4 digit PIN was the hard part!

For more information on logging into WorkFlows, visit the WorkFlows wiki and click on Logging In.

OPAC Enhancement: No Results???? Is That All I Get?

2008-10-08T15:37:00.004-05:00

Previously, if you performed a search on our online public access catalog (or OPAC) and your search retrieved no results, you received the message "No results". However, digging around the configuration files of our OPAC, I found the source of this message and altered it. Now, if you perform a search and retrieve no results, you receive this message:

No Results. Please 1) check your spelling above; 2) resubmit your search as a Browse Search below; or 3) feel free to contact us for assistance in searching our catalog.

The third suggestion is a link to our contact page.

The PrtSc Key (or Print Screen)

2008-06-12T16:16:00.003-05:00

Here is a link to some helpful instructions regarding the PrtSc key on your keyboard. You can use this to create a screen shot. Screen shots are great for notating odd error messages that may appear on your screen. That way, when you report the problem, you don't have to say something like, "An error message came up that said something about referencing a control issue or siphoning off a cable gear... what does that mean?"

Basic Mail Merge Assistance

2008-06-09T12:18:00.001-05:00

By staff suggestion, I have created a page on the Technical Trainer wiki devoted to the basics of mail merging letters and envelopes.

Phishing

2008-06-06T09:52:00.003-05:00

I just received this email:

"As a Firstbanks customer, your privacy and security always come first. We have been dedicated to customer safety and protection, and our mission remains as strong as ever.

We inform you that your Firstbanks Internet banking account is about to expire. It is strongly recommended to update it immediately. Update form is located here.

However, failure to confirm your records may result in account suspension. This is an automated message. Please, do not reply.

Sincerely,

Firstbanks administration"

This email is an example of phishing. From Wikipedia, "phishing is an attempt to criminally and fraudulently acquire sensitive information, such as usernames, passwords and credit card details, by masquerading as a trustworthy entity in an electronic communication."

Unfortunately, there are enough people in this world that would see this type of email, get worried because they do not want an account suspension, and follow the link and enter their bank username, password, etc.

More About Online Job Applications

2008-06-04T16:08:00.003-05:00

Robert from Randolph commented on the Job Application post from May 5. I was adding a follow-up comment when I realized that it would be better to create another post.

Robert's comment:

"I've noticed an increasing number of patrons who want to fill out an online job application, but their computer skills are often minimal at best. I'm wondering if we could offer a computer class at Central once a month that would help people with the online job application process?"

First, I appreciate the comment and would like to see more from everyone.

We offered a class called Job Searching on the Web. We set up monthly classes, recruited trainers, distributed flyers, and we could only get one or two people in a class (and canceled others due to lack of registration). And the few people that did attend already had the skills necessary to fill out an application. Their questions were more focused on the entire job searching process (not necessarily technically-related). Meanwhile, we have people banging the door down in order to register for our existing classes. Therefore, I removed the class from the rotation so that we could continue to focus on the existing classes.

Why did this class fail? Unfortunately, the online job application is one of those customer needs that is immediate and fleeting. Also, as the previous post pointed out, if someone cannot fill out a job application, then it suggests a larger lack of computer skills that needs to be addressed appropriately.

The online job application requires basic computer knowledge (filling out text boxes, using drop-down menus, etc.), basic internet skills (entering a URL, following links, not getting overwhelmed by the Web environment, etc.), as well as Email skills. All of these skills are addressed in our existing classes. If a customer went through our entire class program, I have no doubt that they would be able to fill out an online job application. But one class will not successfully address the issue at hand.

I believe the online job application is the single most important battleground inside the Digital Divide, which exists partly due to lack of desire to cross the divide. Nothing else has continually pushed unwilling participants into the online world. As stated in the previous post, I think that some companies use it as an unofficial screening process. If you do not know how to fill out an online job application, then they probably do not want to interview you. If that is not the case, then these companies will need to find out ways to simplify their online job application process so that first time computer users have equal access.

Databases Special Access

2008-06-02T11:19:00.003-05:00

A while ago, a staff member suggested the creation of a list of databases with special access features. As you know, most of our databases include remote access with the username m* and password e*. (These must be in lowercase letters. If you do not know what m* or e* stands for, just ask a fellow co-worker. They will know.) And many allow for unlimited log-ins.

However, some do not allow for remote access, some do not use m*/e*, and some only allow for a limited number of log-ins. Here is a list of those that do not have remote access, or do not use m*/e*, or have limited log-ins. This can also be found on the Technical Trainer page on the MPLIC-Wiki under Databases Special Access.

Alternatives for Customers When Saving Files

2008-05-30T13:37:00.003-05:00

Many times, customers may begin working on a document, but they fail to bring anything to save the document to. Their allotted time on the computer passes, but they cannot leave the computer because they are not done with their document and they have no means of saving it so that they can complete it some other time. How can we help these customers?

First, I would heavily suggest that each agency have a floppy disk that they can use as a conduit to move customer files from one place to another. The customer cannot obviously take that disk with them, but many options below require that you first save the file somewhere. And many public computers do not allow you to save to the My Documents on the computer; therefore, you have to save it to a floppy disk or flash drive first.

Now, the first question I would ask a customer is whether or not they have an email address. If they do, then you can save the file to your agency disk. Then the customer can log onto their email account and email themselves the attached file. We can then delete the file from the agency disk and a copy is available in the customer's email account. They can access it from any other computer that has internet access.

If they do not have an email address, Andy in History points out that you can use the same site I talked about earlier regarding sending faxes from a computer (http://drop.io). You can upload files to this site without an email address or without registering:

First, you save the file to your agency disk.
Go to drop.io.
Create a unique url (ex. drop.io/kevindixon)
Upload the file from the agency disk.
Create a password if you want.
Select an expiration time.
Customers can then access the files later by going to the url that they created in step 3.

Give it a shot. Thanks Andy!

Browsers, Plug-Ins, Media Player Versions

2008-05-23T14:24:00.004-05:00

Do you receive questions from customer regarding the capability of our internet browser? Example: How come this video can't play? Or, how come this website does not work?

It could be that the lack of capability with our computers is related to the plug-ins installed on our computers. For example, do we have the most up-to-date version of Flash Player? If not, this could affect videos or websites that require the most up-to-date version of Flash Player.

For more information, see this information found on the Technical Trainer wiki page.

Send a Fax from a Computer

2008-05-15T16:20:00.004-05:00

I just tested this out and it works. If you have an electronic version of a document (Word, PDF, etc.), then you can use a website to send that file to a fax machine. The website is drop.io and it is probably best to suggest to the more tech-savvy customer. For more information, see this blog post from Reference at Newman Library.

And technically you can receive a fax from this site as well, but it looks extremely complicated. And that is usually not what our customers ask for. They usually want to send a fax, not receive.

Printing Excel Spreadsheets On One Page Width

2008-05-14T16:11:00.006-05:00

One annoying thing that happens frequently when attempting to print an Excel spreadsheet is the fact that it is sometimes difficult to fit the contents onto one page width. What do I mean by this?

Have you ever printed a spreadsheet in which the main contents will appear on, say, the first three pages; however, you get three more pages of random contents that spilled over onto separate pages due to the fact that your table was too wide to fit on one page? (wow, what a long question).

If this has ever happened to you, then here are a couple of quick fixes. First, make sure that your Page Orientation is Landscape instead of Portrait.

Click on File on the menu bar. Click on Page Setup. The Page Setup dialog box will appear.
Make sure you are looking at the Page tab.
Select Landscape under Orientation.

If this does not fix the problem, then you can automatically shrink your worksheet to one page wide.

Click on File>Page Setup again.
Make sure you are looking at the Page tab.
Under Scaling, see where it says Fit to ??? page(s) wide by ??? tall.
Select that option and make it such that it will be one page wide. This will automatically shrink the text so that it appears on one page wide.
Seeing that we do not necessarily need the table to fit on one page tall, you can change the number tall to anything obtuse (like 500). Excel will not stretch your document so that it is 500 pages long; but if your worksheet is longer than 500 pages long, then it will shrink the text. We don't really want to shrink the text this way, which is why I suggest entering in a large obtuse number that you will hopefully never approach.

So, next time you are helping a customer who can't seem to get their Excel table on one page width, just show them this handy-dandy trick.